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