Agrawa: Created page with "== Score Views Variable Documentation == {| class="wikitable" !Name !!Datatype !!Description |- !question_weight |INT(10) |weightage for the question |- !type |VARCHAR(255) |t..."

2018-04-29T23:43:13Z

Created page with "== Score Views Variable Documentation == {| class="wikitable" !Name !!Datatype !!Description |- !question_weight |INT(10) |weightage for the question |- !type |VARCHAR(255) |t..."

New page

== Score Views Variable Documentation ==

{| class="wikitable"
!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 [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

Score views - Revision history

Agrawa: Created page with "== Score Views Variable Documentation == {| class="wikitable" !Name !!Datatype !!Description |- !question_weight |INT(10) |weightage for the question |- !type |VARCHAR(255) |t..."