post

0 rows


Description

Generic post table to hold data blog entries etc in differen

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
user.id Implied ConstraintR
courseid BIGINT 19 0
course.id Implied ConstraintR
groupid BIGINT 19 0
moduleid BIGINT 19 0
coursemoduleid BIGINT 19 0
course.id Implied ConstraintR
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_iduse2_uix Must be unique Asc/Asc id + userid
post_las2_ix Performance Asc lastmodified
post_mod2_ix Performance Asc module
post_sub2_ix Performance Asc subject
post_use4_ix Performance Asc usermodified

Relationships