Question advices: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
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.