Question advices: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
{| class="wikitable" | == Question Advice Variable Documentation (Reimplementation) == | ||
'''Note:''' This table has been renamed from ''question_advices'' to ''question_advice''. | |||
{| class="wikitable" | |||
!Field Name !!Type !!Description | !Field Name !!Type !!Description | ||
|- | |- | ||
! | !id | ||
|int(11) | |int(11) | ||
|id of the advice | |id of the advice | ||
|- | |- | ||
! | !question_id | ||
|int(11) | |int(11) | ||
|id of the question | |id of the question | ||
|- | |- | ||
! | !score | ||
|int(11) | |int(11) | ||
|scores related to each question. It could be just 0/1 meaning false/true or | |scores related to each question. It could be just 0/1 meaning false/true or integers | ||
|- | |- | ||
! | !advice | ||
|text | |text | ||
|description of what a particular score means | |description of what a particular score means | ||
|} | |} | ||
== Question Advices Variable Documentation (2023 version) == | |||
{| 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 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 == | == E/R diagram for Parents Tables == | ||
Latest revision as of 03:58, 9 December 2025
Question Advice Variable Documentation (Reimplementation)
Note: This table has been renamed from question_advices to question_advice.
| 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 |
Question Advices Variable Documentation (2023 version)
| 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.