Questions table: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 47: Line 47:
|
|
|}  
|}  
== E/R diagram for Parents Tables ==
Tables referred by the Assignment 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.

Revision as of 22:41, 25 April 2018

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
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 Assignment Table as Foreign Key Relationship.


Back to Database Tables Main page.