Choice Table Schema (choice)


Description

Available choices are stored here

choice table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
choice_answers.choiceid choiansw_cho2_fk R
choice_options.choiceid choiopti_cho2_fk R
course bigint 10 0
name varchar 255
intro longtext 2147483647 null
introformat smallint 4 0
publish tinyint 2 0
showresults tinyint 2 0
display smallint 4 0
allowupdate tinyint 2 0
allowmultiple tinyint 2 0
showunanswered tinyint 2 0
includeinactive tinyint 2 1
limitanswers tinyint 2 0
timeopen bigint 10 0
timeclose bigint 10 0
showpreview tinyint 2 0
timemodified bigint 10 0
completionsubmit BIT 1 0

If this field is set to 1, then the activity will be automatically marked as 'complete' once the user submits their choice.

Table contained -1 rows

choice table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
choi_cou_ix Performance Asc course

choice table relationships