choice

0 rows


Description

Available choices are stored here

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
choice_answers.choiceid choiansw_cho2_fkR
choice_options.choiceid choiopti_cho2_fkR
course BIGINT 19 0
name VARCHAR 255
intro LONGTEXT 2147483647 null
introformat SMALLINT 5 0
publish TINYINT 3 0
showresults TINYINT 3 0
display SMALLINT 5 0
allowupdate TINYINT 3 0
allowmultiple TINYINT 3 0
showunanswered TINYINT 3 0
includeinactive TINYINT 3 1
limitanswers TINYINT 3 0
timeopen BIGINT 19 0
timeclose BIGINT 19 0
showpreview TINYINT 3 0
timemodified BIGINT 19 0
completionsubmit BIT 1 0
showavailable BIT 1 0

Indexes

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

Relationships

Close relationships within degrees of separation