Questions table: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(2 intermediate revisions by one other user not shown)
Line 21: Line 21:
!seq
!seq
|DECIMAL
|DECIMAL
|
|the sequence # of the question; rubrics display questions in order of increasing seq. #
|-
|-
!type
!type
Line 47: Line 47:
|
|
|}  
|}  
== 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.