# post

0 rows

### Description

Generic post table to hold data blog entries etc in different modules

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
blog_association.blogid | blogasso_blo2_fkR
module | VARCHAR | 20 |  |  |  |  |  |
userid | BIGINT | 19 |  |  | 0 |  |  |
courseid | BIGINT | 19 |  |  | 0 |  |
course.id | post_cou3_fkR
groupid | BIGINT | 19 |  |  | 0 |  |  |
moduleid | BIGINT | 19 |  |  | 0 |  |  |
coursemoduleid | BIGINT | 19 |  |  | 0 |  |
course_modules.id | post_cou4_fkR
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 |  |
user.id | post_use2_fkR

### 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

### Relationships