Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | BIGINT | 19 | √ | null |
|
|
||||
module | VARCHAR | 20 |
|
|
||||||
userid | BIGINT | 19 | 0 |
|
|
|||||
courseid | BIGINT | 19 | 0 |
|
|
|||||
groupid | BIGINT | 19 | 0 |
|
|
|||||
moduleid | BIGINT | 19 | 0 |
|
|
|||||
coursemoduleid | BIGINT | 19 | 0 |
|
|
|||||
subject | VARCHAR | 128 |
|
|
||||||
summary | LONGTEXT | 2147483647 | √ | null |
|
|
||||
content | LONGTEXT | 2147483647 | √ | null |
|
|
||||
uniquehash | VARCHAR | 255 |
|
|
||||||
rating | BIGINT | 19 | 0 |
|
|
|||||
format | BIGINT | 19 | 0 |
|
|
|||||
summaryformat | TINYINT | 3 | 0 |
|
|
|||||
attachment | VARCHAR | 100 | √ | null |
|
|
attachment |
|||
publishstate | VARCHAR | 20 | draft |
|
|
|||||
lastmodified | BIGINT | 19 | 0 |
|
|
|||||
created | BIGINT | 19 | 0 |
|
|
|||||
usermodified | BIGINT | 19 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |
post_cou2_ix | Performance | Asc | coursemoduleid |
post_cou_ix | Performance | Asc | courseid |
post_iduse_uix | Must be unique | Asc/Asc | id + userid |
post_las_ix | Performance | Asc | lastmodified |
post_mod_ix | Performance | Asc | module |
post_sub_ix | Performance | Asc | subject |
post_use_ix | Performance | Asc | usermodified |