Questions table: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (3 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 | ||
| 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.