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