post

0 rows

Description

Generic post table to hold data blog entries etc in differen

Columns

Related columns Constraint Comments

Search:

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

Implied ConstraintR

courseid

BIGINT

19

0

Implied ConstraintR

groupid

BIGINT

19

0

moduleid

BIGINT

19

0

coursemoduleid

BIGINT

19

0

Implied ConstraintR

subject

VARCHAR

128

summary

LONGTEXT

2147483647

√

null

content

LONGTEXT

2147483647

√

null

Showing 1 to 10 of 19 entries

Indexes

Search:

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

Showing 1 to 6 of 6 entries

Relationships

Close relationships within degrees of separation