Questions table: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 49: | Line 49: | ||
== E/R diagram for Parents Tables == | == E/R diagram for Parents Tables == | ||
Tables referred by the | Tables referred by the Questionnaires Table as Foreign Key Relationship. | ||
[[File:question_advises_child.jpg]] | [[File:question_advises_child.jpg]] | ||
Revision as of 22:42, 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 Questionnaires Table as Foreign Key Relationship.
Back to Database Tables Main page.