Question advices: Difference between revisions
Jump to navigation
Jump to search
(Created page with "{| class="wikitable" !Field Name !!Type !!Description |- !id |int(11) |id of the advice |- !question_id |int(11) |id of the question |- !score |int(11) |scores...") |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 20: | Line 20: | ||
|} | |} | ||
== E/R diagram for Parents Tables == | |||
Tables referred by Question Advices Table as Foreign Key Relationship. | |||
[[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.