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
Line 10: Line 10:
|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
|
|-
!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)
|
|}  
|}  


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.

Revision as of 22:40, 25 April 2018

Field Name Type Description
id int(11)
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
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)

Back to Database Tables Main page.