Post Table Schema (post)


Description

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 19 √ null
blog_association.blogid blogasso_blo2_fk R
module VARCHAR 20
userid BIGINT 19 0
user.id Implied Constraint R
courseid BIGINT 19 0
course.id Implied Constraint R
groupid BIGINT 19 0
moduleid BIGINT 19 0
coursemoduleid BIGINT 19 0
course.id Implied Constraint R
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_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

Close relationships within degrees of separation