Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||||||
| parent | BIGINT | 19 | 0 |
|
|
|||||||||
| name | VARCHAR | 255 |
|
|
||||||||||
| questiontext | LONGTEXT | 2147483647 | null |
|
|
|||||||||
| questiontextformat | TINYINT | 3 | 0 |
|
|
|||||||||
| generalfeedback | LONGTEXT | 2147483647 | null |
|
|
to store the question feedback |
||||||||
| generalfeedbackformat | TINYINT | 3 | 0 |
|
|
|||||||||
| defaultmark | DECIMAL | 12,7 | 1.0000000 |
|
|
|||||||||
| penalty | DECIMAL | 12,7 | 0.3333333 |
|
|
|||||||||
| qtype | VARCHAR | 20 |
|
|
||||||||||
| length | BIGINT | 19 | 1 |
|
|
|||||||||
| stamp | VARCHAR | 255 |
|
|
||||||||||
| timecreated | BIGINT | 19 | 0 |
|
|
time question was created |
||||||||
| timemodified | BIGINT | 19 | 0 |
|
|
time that question was last modified |
||||||||
| createdby | BIGINT | 19 | √ | null |
|
|
userid of person who created this question |
|||||||
| modifiedby | BIGINT | 19 | √ | null |
|
|
userid of person who last edited this question |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| ques_cre_ix | Performance | Asc | createdby |
| ques_mod_ix | Performance | Asc | modifiedby |
| ques_par_ix | Performance | Asc | parent |
| ques_qty_ix | Performance | Asc | qtype |