Question advices - Revision history

Rtantry2 at 03:58, 9 December 2025

2025-12-09T03:58:16Z

← Older revision		Revision as of 03:58, 9 December 2025
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		!id
	\|int(11)		\|int(11)
	\|id of the advice		\|id of the advice
	\|-		\|-
	!~~question_id~~		!question_id
	\|int(11)		\|int(11)
	\|id of the question		\|id of the question
	\|-		\|-
	!~~score~~		!score
	\|int(11)		\|int(11)
	\|scores related to each question. It could be just 0/1 meaning false/true or ~~integers~~		\|scores related to each question. It could be just 0/1 meaning false/true or integers
	\|-		\|-
	!~~advice~~		!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 ==

Agrawa at 22:31, 25 April 2018

2018-04-25T22:31:50Z

← Older revision		Revision as of 22:31, 25 April 2018
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.

Agrawa at 22:27, 25 April 2018

2018-04-25T22:27:41Z

← Older revision		Revision as of 22:27, 25 April 2018
Line 24:		Line 24:

	[[File:question_advises.jpg]]		[[File:question_advises.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.

Agrawa at 22:27, 25 April 2018

2018-04-25T22:27:32Z

← Older revision		Revision as of 22:27, 25 April 2018
Line 20:		Line 20:
	\|}		\|}

			== E/R diagram for Parents Tables ==
			Tables referred by Question Advices Table as Foreign Key Relationship.

			[[File:question_advises.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.

Rkyadav: 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..."

2016-05-17T19:52:46Z

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..."

New page

{| 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
|}

Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.