Questions table: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
(Created page with "<!-- Questions page already exists,so created a page with the name Questions table and gave an external link on the tables page--> {| class="wikitable" !Field Name !!Type !!Desc...")
 
No edit summary
 
(4 intermediate revisions by one other user not shown)
Line 5: Line 5:
!id  
!id  
|int(11)   
|int(11)   
|
|unique identifier for the record
|-  
|-  
!txt   
!txt   
|text   
|text   
|the question string
|the question string
|-
!true_false 
|tinyint(1) 
|either it's a true/false question, or it's a question that is to be given a numeric score
|-  
|-  
!weight   
!weight   
Line 21: Line 17:
!questionnaire_id   
!questionnaire_id   
|int(11)
|int(11)
 
|the id of the questionnaire that this question belongs to
|the id of the questionnaire that this question belongs to
|-
!seq
|DECIMAL
|the sequence # of the question; rubrics display questions in order of increasing seq. #
|-
!type
|VARCHAR(255)
|Type of question
|-
!size
|VARCHAR(255)
|Size of the question
|-
!alternatives
|VARCHAR(255)
|Other question which means the same
|-
!break_before
|BIT
|
|-
!max_label
|VARCHAR(255)
|
|-
!min_label
|VARCHAR(255)
|
|}  
|}  
== E/R diagram for Parents Tables ==
Tables referred by the Questionnaires Table as Foreign Key Relationship.
[[File:question_advises_child.jpg]]




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

Latest revision as of 19:16, 3 November 2019

Field Name Type Description
id int(11) unique identifier for the record
txt text the question string
weight int(11) specifies the weighting of the question
questionnaire_id int(11) the id of the questionnaire that this question belongs to
seq DECIMAL the sequence # of the question; rubrics display questions in order of increasing seq. #
type VARCHAR(255) Type of question
size VARCHAR(255) Size of the question
alternatives VARCHAR(255) Other question which means the same
break_before BIT
max_label VARCHAR(255)
min_label VARCHAR(255)

E/R diagram for Parents Tables

Tables referred by the Questionnaires Table as Foreign Key Relationship.


Back to Database Tables Main page.