Post Table Schema (post)


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

post table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
blog_association.blogid blogasso_blo2_fk R
forum_read.postid Implied Constraint R
module varchar 20
userid bigint 10 0 Implied Constraint R
courseid bigint 10 0 Implied Constraint R
groupid bigint 10 0
moduleid bigint 10 0
coursemoduleid bigint 10 0 Implied Constraint R
subject varchar 128
summary longtext 2147483647 null
content longtext 2147483647 null
uniquehash varchar 255
rating bigint 10 0
format bigint 10 0
summaryformat tinyint 2 0
attachment varchar 100 null


publishstate varchar 20 draft
lastmodified bigint 10 0
created bigint 10 0
usermodified bigint 10 null post_use2_fk R

Table contained -1 rows

post table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
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

post table relationships