Question advices: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 24: | Line 24: | ||
[[File:question_advises.jpg]] | [[File:question_advises.jpg]] | ||
== E/R diagram for Child Tables == | |||
Tables which refer 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 22:31, 25 April 2018
| Field Name | Type | Description |
|---|---|---|
| id | int(11) | id of the advice |
| question_id | int(11) | id of the question |
| score | int(11) | scores related to each question. It could be just 0/1 meaning false/true or integers |
| advice | text | description of what a particular score means |
E/R diagram for Parents Tables
Tables referred by Question Advices Table as Foreign Key Relationship.
E/R diagram for Child Tables
Tables which refer the questionnaires Table as Foreign Key Relationship.
Back to Database Tables Main page.