# 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 | 1333 |  |  |  |  |  |
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 |  |  | If this field is set to 1, then the activity will be automatically marked as 'complete' once the user submits their choice.
showavailable | BIT | 1 |  |  | 0 |  |  | If this field is set to 1, then the the number of available space on choice options will be shown, given limitanswers is set to 1.

### Indexes

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

### Relationships