Score views

From Expertiza_Wiki
Jump to navigation Jump to search

Score Views Variable Documentation

Name Datatype Description
question_weight INT(10) weightage for the question
type VARCHAR(255) type of the question
q1_id INT(10) unique identifier for the question
q1_name VARCHAR(255) name for the question
q1_instructor_id INT(10) id for the instructor
q1_private BIT Boolean to represent whether the question is private or not
q1_min_question_score INT(10) the minimum score possible for this question
q1_max_question_score INT(10) Max score possible for this question
q1_created_at DATETIME Creation Date and time for this question record
q1_updated_at DATETIME Update Date and time for this question record
q1_type VARCHAR(255) Type of this question
q1_display_type VARCHAR(255) Type that is displayed for this question
ques_id INT(10) unique identifier
ques_questionnaire_id INT(10) id for question in questionnaire
s_id INT(10) id for the solution
s_question_id INT(10) solution for unique question id
s_score INT(10) score for the solution
s_comments TEXT comments for the solution
s_response_id INT(10) response id for the solution

E/R diagram for Parents Tables

No Tables were referred by the Score Views Records Table as Foreign Key Relationship.


E/R diagram for Child Tables

No Tables were referred by the Score Views Records Table as Foreign Key Relationship.


Back to Database Tables Main page.