Expertiza_Wiki - User contributions [en]

Suggestion comments

2018-04-25T00:28:10Z

Smishra4: Created page with "{| class="wikitable" !Name !!Datatype !!Description |- !id |int(11) |Primary key of the entry in table, auto increments by default |- !comments |text |Stores the comment..."

{| class="wikitable"
!Name !!Datatype !!Description
|-
!id
|int(11)
|Primary key of the entry in table, auto increments by default

|-
!comments
|text
|Stores the comments for the suggestion
|-
!commenter
|varchar(255)
|Stores the username of the commenter
|-
!vote
|varchar(255)
|Stores the vote(Y/N/R/NULL) for the comment on the suggestion
|-
!suggestion_id
|int(11)
|Stores the suggestion ID
|-
!created_at
|datetime
|Stores the time at which the row is created

|}
== E/R diagram of tables referencing suggestion_comments table ==
The following table doesn't reference to other tables in the database

== E/R diagram of tables suggestion_comments table is referencing to ==
The suggestion_comments table is not referenced by any other tables

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

Suggestions

2018-04-25T00:20:59Z

Smishra4: Created page with "{| class="wikitable" !Name !!Datatype !!Description |- !id |int(11) |Primary key of the entry in table, auto increments by default |- !assignment_id |int(11) |ID of the..."

{| class="wikitable"
!Name !!Datatype !!Description
|-
!id
|int(11)
|Primary key of the entry in table, auto increments by default

|-
!assignment_id
|int(11)
|ID of the assignment for which suggestions are published
|-
!title
|varchar(255)
|Stores the title of the suggestion
|-
!description
|text
|Stores the description of the suggestion
|-
!status
|varchar(255)
|Stores the status of the suggestion(Initiated/Approved/Rejected)
|-
!unityID
|varchar(255)
|Stores the unityID of the user who provides suggestion
|-
!signup_preference
|varchar(255)
|Stores the signup_preference(Y/N) of the user who provides suggestion

|}
== E/R diagram of tables referencing suggestions table ==
The following table doesn't reference to other tables in the database

== E/R diagram of tables suggestions table is referencing to ==
The tag_prompts table is not referenced by any other tables

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

Survey deployments

2018-04-25T00:10:54Z

Smishra4: Created page with "{| class="wikitable" !Field Name !!Type !!Description |- !id |int(11) |The unique record id, auto-incremented |- !questionnaire_id |int(11) |Stores the ID of the qu..."

{| class="wikitable"
!Field Name !!Type !!Description
|-
!id
|int(11)
|The unique record id, auto-incremented
|-
!questionnaire_id
|int(11)
|Stores the ID of the questionaire
|-
!start_date
|datetime
|Stores the start date of the deployment
|-
!end_date
|datetime
|Stores the end date of the deployment
|-
!last_reminder
|datetime
|Stores the last reminder date of the deployment
|-
!parent_id
|int(11)
|Stores the ID of the parent survey ID
|-
!global_survey_id
|int(11)
|Stores the global survey ID
|-
!type
|varchar(255)
|Stores the type of survey
|}

== E/R diagram of tables referencing survey_deployments table ==
This table is not referred by any other table in the database

== E/R diagram of tables survey_deployments table is referencing to ==
The system_settings table is referenced by the following tables
[[File:survey_deployments_import.png]]

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

File:Survey deployments import.png

2018-04-25T00:10:16Z

Smishra4: uploaded a new version of "File:Survey deployments import.png"

File:Survey deployments import.png

2018-04-25T00:01:40Z

Smishra4:

Survey responses

2018-04-24T23:59:58Z

Smishra4: Created page with "{| class="wikitable" !Name !!Datatype !!Description |- !id |int(11) |Primary key of the entry in table, auto increments by default |- !score |bigint(20) |Stores the score..."

{| class="wikitable"
!Name !!Datatype !!Description
|-
!id
|int(11)
|Primary key of the entry in table, auto increments by default

|-
!score
|bigint(20)
|Stores the score of survey responses
|-
!comments
|text
|Comments of the survey responses
|-
!assignment_id
|bigint(20)
|The assignment id for which survey response is stored
|-
!question_id
|bigint(20)
|The question id of survey response
|-
!survey_id
|bigint(20)
|Survey ID of the response
|-
!email
|varchar(255)
|Stores the email of the user who filled the survey
|-
!survey_deployment_id
|int(11)
|Stores the survey deployment ID
|}

== E/R diagram of tables referencing survey_responses table ==
This table is not referred by any other table in the database

== E/R diagram of tables survey_responses table is referencing to ==
The survey_responses table is not referenced by any other tables

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

System settings

2018-04-24T23:49:55Z

Smishra4:

{| class="wikitable"
!Field Name !!Type !!Description
|-
!id
|int(11)
|The unique record id, auto-incremented
|-
!site_name
|varchar(255)
|Site name as hosted
|-
!site_subtitle
|varchar(255)
|Description of site
|-
!footer_message
|varchar(255)
|Footer message for the site
|-
!public_role_id
|int(11)
|Public role for the ID
|-
!session_timeout
|int(11)
|Session timeout duration in seconds
|-
!default_markup_style_id
|int(11)
|ID of markup style
|-
!site_default_page_id
|int(11)
|ID for default page of site
|-
!not_found_page_id
|int(11)
|ID of custom page for page not found
|-
!permission_denied_page_id
|int(11)
|ID for custom permissions denied page
|-
!session_expired_page_id
|int(11)
|ID for custom sessions expired page
|-
!menu_depth
|int(11)
|Length of menu
|}

== E/R diagram of tables referencing system_settings table ==
This table is not referred by any other table in the database

== E/R diagram of tables system_settings table is referencing to ==
The system_settings table is not referenced by any other tables

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

Ta mappings

2018-04-24T23:28:55Z

Smishra4:

{| class="wikitable"
!Name !!Datatype !!Description
|-
!id
|int(11)
|Primary key of the entry in table, auto increments by default
|-
!ta_id
|int(11)
|Id of the TA in question; FK into users table.
|-
!course_id
|int(11)
|Respective course; FK into courses table.
|}
== E/R diagram of tables referencing ta_mappings table ==
The table is not referencing any other table
== E/R diagram of tables users table is referencing to ==
The ta_mappings table is referenced by the following tables
[[File:ta_mappings_import.png]]

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

File:Ta mappings import.png

2018-04-24T23:28:46Z

Smishra4:

Tag prompt deployments

2018-04-24T23:15:33Z

Smishra4: Created page with "{| class="wikitable" !Name !!Datatype !!Description |- !id |int(11) |Primary key of the entry in table, auto increments by default |- !tag_prompt_id |int(11) |ID of the ..."

{| class="wikitable"
!Name !!Datatype !!Description
|-
!id
|int(11)
|Primary key of the entry in table, auto increments by default
|-
!tag_prompt_id
|int(11)
|ID of the tag prompt
|-
!assignment_id
|int(11)
|ID of the assignment for which a tag is created
|-
!questionnaire_id
|int(11)
|ID of the questionaire for which tag is created
|-
!question_type
|varchar(255)
|type of question, depends on whether the based on the format of answer that it expects
|-
!answer_length_threshold
|int(11)
|Maximumm length of answer expected
|-
!created_at
|datetime
|Time of creation of row
|-
!updated_at
|datetime
|Time of updation of row
|}

== E/R diagram of tables referencing tag_prompt_deployments table ==
The following image shows the tables referencing users table
[[File:tag_prompt_deployments_export.png]]

== E/R diagram of tables users table is referencing to ==
The following image shows the tables that tag_prompt_deployments table is referenced by:
[[File:tag_prompt_deployments_import.png]]

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

File:Tag prompt deployments import.png

2018-04-24T23:12:44Z

Smishra4:

File:Tag prompt deployments export.png

2018-04-24T23:10:25Z

Smishra4:

Tag prompts

2018-04-24T22:58:34Z

Smishra4: Created page with "{| class="wikitable" !Name !!Datatype !!Description |- !id |int(11) |Primary key of the entry in table, auto increments by default |- !prompt |varchar(255) |Prompt of t..."

{| class="wikitable"
!Name !!Datatype !!Description
|-
!id
|int(11)
|Primary key of the entry in table, auto increments by default

|-
!prompt
|varchar(255)
|Prompt of tag as text
|-
!desc
|varchar(255)
|Description of tag as text
|-
!control_type
|varchar(255)
|Type of control as text
|-
!created_at
|datetime
|Time of creation of row
|-
!updated_at
|datetime
|Time of updation of row

|}
== E/R diagram of tables referencing users table ==
The following image shows the tables referencing tag_prompts table
[[File:tag_prompts_export.png]]

== E/R diagram of tables users table is referencing to ==
The tag_prompts table is not referenced by any other tables
Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

File:Tag prompts export.png

2018-04-24T22:49:51Z

Smishra4:

File:Teams export.png

2018-04-24T22:48:56Z

Smishra4: uploaded a new version of "File:Teams export.png": Reverted to version as of 22:37, 24 April 2018

File:Teams export.png

2018-04-24T22:48:27Z

Smishra4: uploaded a new version of "File:Teams export.png"

Teams

2018-04-24T22:37:48Z

Smishra4:

{| class="wikitable"
!Field Name !!Type !!Description
|-
!id
|int(11)
|
|-
!name
|varchar(255)
|Name of the team
|-
!parent_id
|int(11)
|ID of assignment that this team is participating in
|-
!type
|varchar(255)

|Type of the team
|-
!comments_for_advertisement
|text
|text for comments
|-
!advertise_for_partner
|tinyint(1)
|Boolean variable to store whether it has to be advertized by partner***
|-
!submitted_hyperlinks
|text
|List of submitted hyperlinks
|-
!directory_num
|int(11)
|directory number where details are stored
|-
!grade_for_submission
|int(11)
|Stores the grade of submission
|-
!comment_for_submission
|text
|Stores the comments for the submission
|}
== E/R diagram of tables referencing users table ==
The following image shows the tables referencing teams table
[[File:teams_export.png]]

== E/R diagram of tables users table is referencing to ==
The teams table is not referenced by any other tables

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

File:Teams export.png

2018-04-24T22:37:09Z

Smishra4:

Teams users

2018-04-24T22:25:57Z

Smishra4:

The Teams table maps users to teams; in rare cases, a single individual is on > 1 team for an assignment.
{| class="wikitable"
!Field Name !!Type !!Description
|-
!id
|int(11)
|
|-
!team_id
|int(11)
|id of the team to which the user belongs to
|-
!user_id
|int(11)

|student who belongs to the team
|}
== E/R diagram of tables referencing teams_users table ==
This table is not referenced by any other tables

== E/R diagram of tables teams_users table is referencing to ==

The following image shows the tables referencing teams_users table is referencing to
[[File:teams_users_export.png]]

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

File:Teams users export.png

2018-04-24T22:12:07Z

Smishra4:

Track notifications

2018-04-24T22:09:05Z

Smishra4: Created page with "This table is used to store the details of notifications generated == Tree Folders variable documentation == {| class="wikitable" !Field Name !!Type !!Description |- !id ..."

This table is used to store the details of notifications generated
== Tree Folders variable documentation ==

{| class="wikitable"
!Field Name !!Type !!Description
|-
!id
|int(11)
|This object's unique ID value. One per object.
|-
!notification
|int(11)
|Stores notification ID
|-
!user_id
|int(11)
|User ID for which the notification is created
|-
!created_at
|datetime
|Stores the time when the row is added to the database
|-
!updated_at
|datetime
|Stores the time when the row is updated in the database
|}
== E/R diagram of tables referencing track_notifications table ==
This table is not referencing any table in the database

== E/R diagram of tables track_notifications table is referencing to ==
The track_notifications table is not referenced by any other tables

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

Tree folders

2018-04-23T01:42:33Z

Smishra4:

Tree folders define the top level containers for the tree display.

== Tree Folders variable documentation ==

{| class="wikitable"
!Field Name !!Type !!Description
|-
!id
|int(11)
|This object's unique ID value. One per object.
|-
!name
|varchar(255)
|The name displayed for the tree folder
|-
!child_type
|varchar(255)
|The model type name contained in this folder
|-
!parent_id
|int(11)
|This object's unique parent ID value.
|}
== E/R diagram of tables referencing tree_folders table ==
This table is not referencing any table in the database

== E/R diagram of tables tree_folders table is referencing to ==
The tree_folders table is not referenced by any other tables

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

Tree folders

2018-04-23T01:40:07Z

Smishra4:

Tree folders define the top level containers for the tree display.

== Tree Folders variable documentation ==

{| class="wikitable"
!Field Name !!Type !!Description
|-
!id
|int(11)
|This object's unique ID value. One per object.
|-
!name
|varchar(255)
|The name displayed for the tree folder
|-
!child_type
|varchar(255)
|The model type name contained in this folder
|-
!parent_id
|int(11)
|This object's unique parent ID value.

== E/R diagram of tables referencing tree_folders table ==
This table is not referencing any table in the database

== E/R diagram of tables tree_folders table is referencing to ==
The tree_folders table is not referenced by any other tables
|}

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

Tree folders

2018-04-23T01:38:18Z

Smishra4:

User pastebins

2018-04-23T01:03:40Z

Smishra4:

{| class="wikitable"
!Field Name !!Type !!Description
|-
!id
|int(11)
|The unique id for user_pastebins
|-
!user_id
|int(11)
|User id of the user who created the pastebin***
|-
!short_form
|varchar(255)
|Short form of the pastebin
|-
!long_form
|text
|Long form of the pastebin
|-
!created_at
|datetime
|Stores the date and me of creation of this record
|-
!updated_at
|datetime
|Stores the date and me of creation of this record

|}
== E/R diagram of tables referencing user_pastebins table ==
This table is not referencing any table in the database

== E/R diagram of tables user_pastebins table is referencing to ==
The user_pastebins table is not referenced by any other tables

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

User pastebins

2018-04-23T01:00:43Z

Smishra4: Created page with "{| class="wikitable" !Field Name !!Type !!Description |- !id |int(11) |The unique id for user_pastebins |- !user_id |int(11) |User id of the user who created the paste..."

Documentation on Database Tables

2018-04-23T00:51:40Z

Smishra4:

'''PROJECT TITLE: Regularize Expertiza DB schema'''
PROBLEM DESCRIPTION:
 The current Expertiza database has some problems which needs to be rectified.
 The current Expertiza database has issues similar to what is described below:
 1. redundant record. For instance, deadline_types table has two signup and team_formation record.
 2. some field name is confused. For instance, in users table assignment_id becomes parent_id and in response_maps assignment_id becomes
reviewed_object_id.

'''The scope of our project is to rectify these problems by performing the below steps.'''
 1. Go through the Expertiza_development database to find tables that not used any more or redundant records.
 2. Write migrations to regularize the Expertiza database and also change code if necessary.
 3. Make sure all existing tests are passed and change test code if necessary
 4. Modify database wiki page to make it up to date

'''DATABASE TABLE DESCRIPTION:'''
 Below is the old detailed description of the tables in the Expertiza DB schema. Our Primary Job is updating the wiki and making it more informative by including all the changes in the Expertiza Db in this wiki.

'''STEPS TO NAVIGATE TO expertiza_development SCHEMA:'''
 1. Open terminal.
 2. Change to the "expertiza" folder using the command: $cd expertiza
 3. Invoke the rails database console using the command: "$rails dbconsole" and give the password "expertiza" when prompted.
 4. List the databases present in the MYSQL server using the command >show databases;
 5. Move to the "expertiza_development" database using the command >use expertiza_development
 6. List down the tables present in the "expertiza_development" using the command >show tables;

'''FLOWCHART:'''

[[File:Flowchart.PNG]]

# '''Assignments'''
#: [[assignments]]
#: [[assignment_questionnaires]]
#: [[deadline_types]]
#: [[deadline_rights]]
#: [[due_dates]]
#: [[late_policies]]
#: [[participants]]
#: [[wiki_types]]
#: ''Deprecated Tables''
#:: [[assignments_questionnaires]]
# '''Goldberg'''
#: [[content_pages]]
#: [[controller_actions]]
#: [[markup_styles]]
#: [[menu_items]]
#: [[permissions]]
#: [[plugin_schema_info]]
#: [[roles]]
#: [[roles_permissions]]
#: [[schema_info]]
#: [[site_controllers]]
#: [[users]]
#: [[system_settings]]
# '''Reviewing'''
#: [[comments]]
#: [[mapping_strategies]]
#: [[responses]]
#: [[response_maps]]
#: [[review_strategies]]
#: [[score_caches]]
#: [[scores]]
#: ''Deprecated Tables''
#:: [[review_feedbacks]]
#:: [[review_mappings]]
#:: [[review_of_review_mappings]]
#:: [[review_of_reviews]]
#:: [[reviews]]
#:: [[teammate_reviews]]
# '''Teammate'''
#: [[invitations]]
#: [[teams]]
#: [[teams_users]]
# '''Courses'''
#: [[Courses_table|courses]]
# '''Hierarchy'''
#: [[institutions]]
#: [[languages]]
# '''Display'''
#: [[nodes]]
#: [[tree_folders]]
# '''Questionnaires/Rubrics'''
#: [[question_advices]]
#: [[questionnaires]]
#: [[Questions_table|questions]]
#: ''Deprecated Tables''
#:: [[questionnaire_types]]
# '''Surveys'''
#: [[survey_deployments]]
#: [[survey_participants]]
#: [[survey_responses]]
# '''Other Features'''
#: [[signed_up_users]]
#: [[sign_up_topics]]
#: [[resubmission_times]]
#: [[ta_mappings]]
# '''New Tables'''

#: [[user_pastebins]]
#: [[versions]]



Back to [[Expertiza_documentation]] Main page.

Users

2018-04-23T00:47:36Z

Smishra4: /* E/R diagram of tables referencing users table */

{| class="wikitable"
!Name !!Datatype !!Description
|-
!id
|int(11)
|Primary key of the entry in table, auto increments by default
|-
!name
|varchar(255)
|User name of the respective user
|-
!crypted_password
|varchar(40)
|Password of the respective user
|-
!role_id
|int(11)
|Role which this user corresponds to FK into ROLES table
|-
!password_salt
|varchar(255)
|
|-
!fullname
|varchar(255)
|Registered full name of the user
|-
!email
|varchar(255)
|Registered email of the respective user.
|-
!parent_id
|int(11)
|Parent of the respective user; correspond to the ID which created this particular user
|-
!private_by_default
|tinyint(1)
|If the user is private by default; essentially Boolean
|-
!mru_directory_path
|varchar(128)
|Default home directory of the respective user
|-
!email_on_review
|tiny_int(1)
|If the user is emailed on receiving a review; essentially Boolean
|-
!email_on_submission
|tiny_int(1)
|If emailed on submission; essentially Boolean
|-
!email_on_review_of_review
|tiny_int(1)
|Whether to email on receiving review of review; essentially boolean
|-
!is_new_user
|tiny_int(1)
|If the user is a new user; used to check if user has signed the new user form
|-
!master_permssion_granted
|tiny_int(4)
|If the user has the master user permission is granted
|-
!handle
|varchar(255)
|Name of the handle created for the user
|-
!digital_certificate
|mediumtext
|Digital certificate generated for the user to protect his password
|-
!timezonepref
|varchar(255)
|Timezone of the user
|-
!public_key
|mediumtext
|Public key used for data-encryption by user
|-
!copy_of_emails
|tinyint(1)
|Number of copies of emails sent
|-
!institution_id
|int(11)
|id of the institution of the user
|}

== E/R diagram of tables referencing users table ==
The following image shows the tables referencing users table
[[File:Users_export.png]]

== E/R diagram of tables users table is referencing to ==
The users table is not referenced by any other tables

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

Users

2018-04-23T00:47:06Z

Smishra4:

{| class="wikitable"
!Name !!Datatype !!Description
|-
!id
|int(11)
|Primary key of the entry in table, auto increments by default
|-
!name
|varchar(255)
|User name of the respective user
|-
!crypted_password
|varchar(40)
|Password of the respective user
|-
!role_id
|int(11)
|Role which this user corresponds to FK into ROLES table
|-
!password_salt
|varchar(255)
|
|-
!fullname
|varchar(255)
|Registered full name of the user
|-
!email
|varchar(255)
|Registered email of the respective user.
|-
!parent_id
|int(11)
|Parent of the respective user; correspond to the ID which created this particular user
|-
!private_by_default
|tinyint(1)
|If the user is private by default; essentially Boolean
|-
!mru_directory_path
|varchar(128)
|Default home directory of the respective user
|-
!email_on_review
|tiny_int(1)
|If the user is emailed on receiving a review; essentially Boolean
|-
!email_on_submission
|tiny_int(1)
|If emailed on submission; essentially Boolean
|-
!email_on_review_of_review
|tiny_int(1)
|Whether to email on receiving review of review; essentially boolean
|-
!is_new_user
|tiny_int(1)
|If the user is a new user; used to check if user has signed the new user form
|-
!master_permssion_granted
|tiny_int(4)
|If the user has the master user permission is granted
|-
!handle
|varchar(255)
|Name of the handle created for the user
|-
!digital_certificate
|mediumtext
|Digital certificate generated for the user to protect his password
|-
!timezonepref
|varchar(255)
|Timezone of the user
|-
!public_key
|mediumtext
|Public key used for data-encryption by user
|-
!copy_of_emails
|tinyint(1)
|Number of copies of emails sent
|-
!institution_id
|int(11)
|id of the institution of the user
|}

== E/R diagram of tables referencing users table ==
The following image shows the tables referencing users table
[[File:Users_export.jpg]]

== E/R diagram of tables users table is referencing to ==
The users table is not referenced by any other tables

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

File:Users export.png

2018-04-23T00:42:54Z

Smishra4:

Users

2018-04-23T00:31:50Z

Smishra4:

{| class="wikitable"
!Name !!Datatype !!Description
|-
!id
|int(11)
|Primary key of the entry in table, auto increments by default
|-
!name
|varchar(255)
|User name of the respective user
|-
!crypted_password
|varchar(40)
|Password of the respective user
|-
!role_id
|int(11)
|Role which this user corresponds to FK into ROLES table
|-
!password_salt
|varchar(255)
|
|-
!fullname
|varchar(255)
|Registered full name of the user
|-
!email
|varchar(255)
|Registered email of the respective user.
|-
!parent_id
|int(11)
|Parent of the respective user; correspond to the ID which created this particular user
|-
!private_by_default
|tinyint(1)
|If the user is private by default; essentially Boolean
|-
!mru_directory_path
|varchar(128)
|Default home directory of the respective user
|-
!email_on_review
|tiny_int(1)
|If the user is emailed on receiving a review; essentially Boolean
|-
!email_on_submission
|tiny_int(1)
|If emailed on submission; essentially Boolean
|-
!email_on_review_of_review
|tiny_int(1)
|Whether to email on receiving review of review; essentially boolean
|-
!is_new_user
|tiny_int(1)
|If the user is a new user; used to check if user has signed the new user form
|-
!master_permssion_granted
|tiny_int(4)
|If the user has the master user permission is granted
|-
!handle
|varchar(255)
|Name of the handle created for the user
|-
!digital_certificate
|mediumtext
|Digital certificate generated for the user to protect his password
|-
!timezonepref
|varchar(255)
|Timezone of the user
|-
!public_key
|mediumtext
|Public key used for data-encryption by user
|-
!copy_of_emails
|tinyint(1)
|Number of copies of emails sent
|-
!institution_id
|int(11)
|id of the institution of the user
|}

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

Users

2018-04-23T00:19:48Z

Smishra4:

Documentation on Database Tables

2018-04-23T00:06:02Z

Smishra4:

'''PROJECT TITLE: Regularize Expertiza DB schema'''
PROBLEM DESCRIPTION:
 The current Expertiza database has some problems which needs to be rectified.
 The current Expertiza database has issues similar to what is described below:
 1. redundant record. For instance, deadline_types table has two signup and team_formation record.
 2. some field name is confused. For instance, in users table assignment_id becomes parent_id and in response_maps assignment_id becomes
reviewed_object_id.

'''The scope of our project is to rectify these problems by performing the below steps.'''
 1. Go through the Expertiza_development database to find tables that not used any more or redundant records.
 2. Write migrations to regularize the Expertiza database and also change code if necessary.
 3. Make sure all existing tests are passed and change test code if necessary
 4. Modify database wiki page to make it up to date

'''DATABASE TABLE DESCRIPTION:'''
 Below is the old detailed description of the tables in the Expertiza DB schema. Our Primary Job is updating the wiki and making it more informative by including all the changes in the Expertiza Db in this wiki.

'''STEPS TO NAVIGATE TO expertiza_development SCHEMA:'''
 1. Open terminal.
 2. Change to the "expertiza" folder using the command: $cd expertiza
 3. Invoke the rails database console using the command: "$rails dbconsole" and give the password "expertiza" when prompted.
 4. List the databases present in the MYSQL server using the command >show databases;
 5. Move to the "expertiza_development" database using the command >use expertiza_development
 6. List down the tables present in the "expertiza_development" using the command >show tables;

'''FLOWCHART:'''

[[File:Flowchart.PNG]]

# '''Assignments'''
#: [[assignments]]
#: [[assignment_questionnaires]]
#: [[deadline_types]]
#: [[deadline_rights]]
#: [[due_dates]]
#: [[late_policies]]
#: [[participants]]
#: [[wiki_types]]
#: ''Deprecated Tables''
#:: [[assignments_questionnaires]]
# '''Goldberg'''
#: [[content_pages]]
#: [[controller_actions]]
#: [[markup_styles]]
#: [[menu_items]]
#: [[permissions]]
#: [[plugin_schema_info]]
#: [[roles]]
#: [[roles_permissions]]
#: [[schema_info]]
#: [[site_controllers]]
#: [[users]]
#: [[system_settings]]
# '''Reviewing'''
#: [[comments]]
#: [[mapping_strategies]]
#: [[responses]]
#: [[response_maps]]
#: [[review_strategies]]
#: [[score_caches]]
#: [[scores]]
#: ''Deprecated Tables''
#:: [[review_feedbacks]]
#:: [[review_mappings]]
#:: [[review_of_review_mappings]]
#:: [[review_of_reviews]]
#:: [[reviews]]
#:: [[teammate_reviews]]
# '''Teammate'''
#: [[invitations]]
#: [[teams]]
#: [[teams_users]]
# '''Courses'''
#: [[Courses_table|courses]]
# '''Hierarchy'''
#: [[institutions]]
#: [[languages]]
# '''Display'''
#: [[nodes]]
#: [[tree_folders]]
# '''Questionnaires/Rubrics'''
#: [[question_advices]]
#: [[questionnaires]]
#: [[Questions_table|questions]]
#: ''Deprecated Tables''
#:: [[questionnaire_types]]
# '''Surveys'''
#: [[survey_deployments]]
#: [[survey_participants]]
#: [[survey_responses]]
# '''Other Features'''
#: [[signed_up_users]]
#: [[sign_up_topics]]
#: [[resubmission_times]]
#: [[ta_mappings]]
# '''New Tables'''

#: [[versions]]



Back to [[Expertiza_documentation]] Main page.

Versions

2018-04-23T00:02:22Z

Smishra4: Created page with "{| class="wikitable" !Field Name !!Type !!Description |- !id |int(11) |The unique record id |- !item_type |varchar(255) |Types of items |- !item_id |int(11) |id ..."

{| class="wikitable"
!Field Name !!Type !!Description
|-
!id
|int(11)
|The unique record id
|-
!item_type
|varchar(255)
|Types of items
|-
!item_id
|int(11)
|id of types of items used like 'Assignment','User' or 'Team'
|-
!event
|varchar(255)
|description of the event, whether data was created/updated or deleted
|-
!whodunnit
|varchar(255)
|id of the person who has done the work
|-
!object
|varchar(255)
|description of the object that has been updated
|-
!created_at
|datetime
|Auto-generated column that stores the date and time of the column when it is updated
|}

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

Documentation on Database Tables

2018-04-22T23:38:03Z

Smishra4:

'''PROJECT TITLE: Regularize Expertiza DB schema'''
PROBLEM DESCRIPTION:
 The current Expertiza database has some problems which needs to be rectified.
 The current Expertiza database has issues similar to what is described below:
 1. redundant record. For instance, deadline_types table has two signup and team_formation record.
 2. some field name is confused. For instance, in users table assignment_id becomes parent_id and in response_maps assignment_id becomes
reviewed_object_id.

'''The scope of our project is to rectify these problems by performing the below steps.'''
 1. Go through the Expertiza_development database to find tables that not used any more or redundant records.
 2. Write migrations to regularize the Expertiza database and also change code if necessary.
 3. Make sure all existing tests are passed and change test code if necessary
 4. Modify database wiki page to make it up to date

'''DATABASE TABLE DESCRIPTION:'''
 Below is the old detailed description of the tables in the Expertiza DB schema. Our Primary Job is updating the wiki and making it more informative by including all the changes in the Expertiza Db in this wiki.

'''STEPS TO NAVIGATE TO expertiza_development SCHEMA:'''
 1. Open terminal.
 2. Change to the "expertiza" folder using the command: $cd expertiza
 3. Invoke the rails database console using the command: "$rails dbconsole" and give the password "expertiza" when prompted.
 4. List the databases present in the MYSQL server using the command >show databases;
 5. Move to the "expertiza_development" database using the command >use expertiza_development
 6. List down the tables present in the "expertiza_development" using the command >show tables;

'''FLOWCHART:'''

[[File:Flowchart.PNG]]

# '''Assignments'''
#: [[assignments]]
#: [[assignment_questionnaires]]
#: [[deadline_types]]
#: [[deadline_rights]]
#: [[due_dates]]
#: [[late_policies]]
#: [[participants]]
#: [[wiki_types]]
#: ''Deprecated Tables''
#:: [[assignments_questionnaires]]
# '''Goldberg'''
#: [[content_pages]]
#: [[controller_actions]]
#: [[markup_styles]]
#: [[menu_items]]
#: [[permissions]]
#: [[plugin_schema_info]]
#: [[roles]]
#: [[roles_permissions]]
#: [[schema_info]]
#: [[site_controllers]]
#: [[users]]
#: [[system_settings]]
# '''Reviewing'''
#: [[comments]]
#: [[mapping_strategies]]
#: [[responses]]
#: [[response_maps]]
#: [[review_strategies]]
#: [[score_caches]]
#: [[scores]]
#: ''Deprecated Tables''
#:: [[review_feedbacks]]
#:: [[review_mappings]]
#:: [[review_of_review_mappings]]
#:: [[review_of_reviews]]
#:: [[reviews]]
#:: [[teammate_reviews]]
# '''Teammate'''
#: [[invitations]]
#: [[teams]]
#: [[teams_users]]
# '''Courses'''
#: [[Courses_table|courses]]
# '''Hierarchy'''
#: [[institutions]]
#: [[languages]]
# '''Display'''
#: [[nodes]]
#: [[tree_folders]]
# '''Questionnaires/Rubrics'''
#: [[question_advices]]
#: [[questionnaires]]
#: [[Questions_table|questions]]
#: ''Deprecated Tables''
#:: [[questionnaire_types]]
# '''Surveys'''
#: [[survey_deployments]]
#: [[survey_participants]]
#: [[survey_responses]]
# '''Other Features'''
#: [[signed_up_users]]
#: [[sign_up_topics]]
#: [[resubmission_times]]
#: [[ta_mappings]]

#: [[versions]]



Back to [[Expertiza_documentation]] Main page.

Documentation on Database Tables

2018-04-22T23:35:54Z

Smishra4:

'''PROJECT TITLE: Regularize Expertiza DB schema'''
PROBLEM DESCRIPTION:
 The current Expertiza database has some problems which needs to be rectified.
 The current Expertiza database has issues similar to what is described below:
 1. redundant record. For instance, deadline_types table has two signup and team_formation record.
 2. some field name is confused. For instance, in users table assignment_id becomes parent_id and in response_maps assignment_id becomes
reviewed_object_id.

'''The scope of our project is to rectify these problems by performing the below steps.'''
 1. Go through the Expertiza_development database to find tables that not used any more or redundant records.
 2. Write migrations to regularize the Expertiza database and also change code if necessary.
 3. Make sure all existing tests are passed and change test code if necessary
 4. Modify database wiki page to make it up to date

'''DATABASE TABLE DESCRIPTION:'''
 Below is the old detailed description of the tables in the Expertiza DB schema. Our Primary Job is updating the wiki and making it more informative by including all the changes in the Expertiza Db in this wiki.

'''STEPS TO NAVIGATE TO expertiza_development SCHEMA:'''
 1. Open terminal.
 2. Change to the "expertiza" folder using the command: $cd expertiza
 3. Invoke the rails database console using the command: "$rails dbconsole" and give the password "expertiza" when prompted.
 4. List the databases present in the MYSQL server using the command >show databases;
 5. Move to the "expertiza_development" database using the command >use expertiza_development
 6. List down the tables present in the "expertiza_development" using the command >show tables;

'''FLOWCHART:'''

[[File:Flowchart.PNG]]

# '''Assignments'''
#: [[assignments]]
#: [[assignment_questionnaires]]
#: [[deadline_types]]
#: [[deadline_rights]]
#: [[due_dates]]
#: [[late_policies]]
#: [[participants]]
#: [[wiki_types]]
#: ''Deprecated Tables''
#:: [[assignments_questionnaires]]
# '''Goldberg'''
#: [[content_pages]]
#: [[controller_actions]]
#: [[markup_styles]]
#: [[menu_items]]
#: [[permissions]]
#: [[plugin_schema_info]]
#: [[roles]]
#: [[roles_permissions]]
#: [[schema_info]]
#: [[site_controllers]]
#: [[users]]
#: [[system_settings]]
# '''Reviewing'''
#: [[comments]]
#: [[mapping_strategies]]
#: [[responses]]
#: [[response_maps]]
#: [[review_strategies]]
#: [[score_caches]]
#: [[scores]]
#: ''Deprecated Tables''
#:: [[review_feedbacks]]
#:: [[review_mappings]]
#:: [[review_of_review_mappings]]
#:: [[review_of_reviews]]
#:: [[reviews]]
#:: [[teammate_reviews]]
# '''Teammate'''
#: [[invitations]]
#: [[teams]]
#: [[teams_users]]
# '''Courses'''
#: [[Courses_table|courses]]
# '''Hierarchy'''
#: [[institutions]]
#: [[languages]]
# '''Display'''
#: [[nodes]]
#: [[tree_folders]]
# '''Questionnaires/Rubrics'''
#: [[question_advices]]
#: [[questionnaires]]
#: [[Questions_table|questions]]
#: ''Deprecated Tables''
#:: [[questionnaire_types]]
# '''Surveys'''
#: [[survey_deployments]]
#: [[survey_participants]]
#: [[survey_responses]]
# '''Other Features'''
#: [[signed_up_users]]
#: [[sign_up_topics]]
#: [[resubmission_times]]
#: [[ta_mappings]]

#: [[wiki_types]]



Back to [[Expertiza_documentation]] Main page.