forum_posts

0 rows


Description

All posts are stored in this table

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
forum_posts.parent forupost_par2_fkR
forum_queue.postid foruqueu_pos2_fkR
forum_read.postid forum_read_erd_post_idR
discussion BIGINT 19 0
forum_discussions.id forupost_dis2_fkR
parent BIGINT 19 0
forum_posts.id forupost_par2_fkR
userid BIGINT 19 0
user.id Implied ConstraintR
created BIGINT 19 0
modified BIGINT 19 0
mailed TINYINT 3 0
subject VARCHAR 255
message LONGTEXT 2147483647 null
messageformat TINYINT 3 0
messagetrust TINYINT 3 0
attachment VARCHAR 100
totalscore SMALLINT 5 0
mailnow BIGINT 19 0
deleted BIT 1 0
privatereplyto BIGINT 19 0
wordcount BIGINT 19 √ null
charcount BIGINT 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
forupost_cre2_ix Performance Asc created
forupost_dis2_ix Performance Asc discussion
forupost_mai2_ix Performance Asc mailed
forupost_par2_ix Performance Asc parent
forupost_pri2_ix Performance Asc privatereplyto
forupost_use2_ix Performance Asc userid

Relationships

Close relationships within degrees of separation