app_post

0 rows

Description

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

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 10 of 19 entries

Indexes

Search:

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

Showing 1 to 6 of 6 entries

Relationships

Close relationships within degrees of separation

One
Two degrees