Questions table - Revision history

Admin at 19:16, 3 November 2019

2019-11-03T19:16:10Z

← Older revision		Revision as of 19:16, 3 November 2019
Line 21:		Line 21:
	!seq		!seq
	\|DECIMAL		\|DECIMAL
	\|		\|the sequence # of the question; rubrics display questions in order of increasing seq. #
	\|-		\|-
	!type		!type

Agrawa at 22:42, 25 April 2018

2018-04-25T22:42:16Z

← Older revision		Revision as of 22:42, 25 April 2018
Line 49:		Line 49:

	== E/R diagram for Parents Tables ==		== E/R diagram for Parents Tables ==
	Tables referred by the ~~Assignment~~ Table as Foreign Key Relationship.		Tables referred by the Questionnaires Table as Foreign Key Relationship.

	[[File:question_advises_child.jpg]]		[[File:question_advises_child.jpg]]

Agrawa at 22:41, 25 April 2018

2018-04-25T22:41:57Z

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

			== E/R diagram for Parents Tables ==
			Tables referred by the Assignment 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:40, 25 April 2018

2018-04-25T22:40:54Z

← Older revision		Revision as of 22:40, 25 April 2018
Line 5:		Line 5:
	!id		!id
	\|int(11)		\|int(11)
	\|		\|unique identifier for the record
	\|-		\|-
	!txt		!txt

Agrawa at 22:40, 25 April 2018

2018-04-25T22:40:34Z

@@ Line 10: / Line 10: @@
 |text
 |the question string
 |-
 !weight
@@ Line 21: / Line 17: @@
 !questionnaire_id
 |int(11)
 |the id of the questionnaire that this question belongs to
 |}
 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 !!Desc..."

2016-05-17T19:45:47Z

Created page with " {| class="wikitable" !Field Name !!Type !!Desc..."

New page

{| class="wikitable"
!Field Name !!Type !!Description
|-
!id
|int(11)
|
|-
!txt
|text
|the question string
|-
!true_false
|tinyint(1)
|either it's a true/false question, or it's a question that is to be given a numeric score
|-
!weight
|int(11)
|specifies the weighting of the question
|-
!questionnaire_id
|int(11)

|the id of the questionnaire that this question belongs to
|}

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