Questions table: Difference between revisions
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 |
||
| (4 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 | ||
|text | |text | ||
|the question string | |the question string | ||
|- | |- | ||
!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 | |||
|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. | |||
[[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.