app_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 bigserial 19 nextval('app_post_id_seq'::regclass)
app_blog_association.blogid Defined in XMLR
module varchar 20 ''::character varying
userid int8 19 0
courseid int8 19 0
groupid int8 19 0
moduleid int8 19 0
coursemoduleid int8 19 0
subject varchar 128 ''::character varying
summary text 2147483647 null
content text 2147483647 null
uniquehash varchar 255 ''::character varying
rating int8 19 0
format int8 19 0
summaryformat int2 5 0
attachment varchar 100 null
publishstate varchar 20 'draft'::character varying
lastmodified int8 19 0
created int8 19 0
usermodified int8 19 null
app_user.id Defined in XMLR

Indexes

Constraint Name Type Sort Column(s)
app_post_id_pk Primary key Asc id
app_post_iduse_uix Must be unique Asc/Asc id + userid
app_post_las_ix Performance Asc lastmodified
app_post_mod_ix Performance Asc module
app_post_sub_ix Performance Asc subject
app_post_use_ix Performance Asc usermodified

Relationships