Forum Posts Table Schema (forum_posts)


Description

All posts are stored in this table

forum_posts table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
forum_posts.parent forupost_par2_fk R
forum_queue.postid foruqueu_pos2_fk R
discussion bigint 10 0
forum_discussions.id forupost_dis2_fk R
parent bigint 10 0
forum_posts.id forupost_par2_fk R
userid bigint 10 0
user.id Implied Constraint R
created bigint 10 0
modified bigint 10 0
mailed tinyint 2 0
subject varchar 255
message longtext 2147483647 null
messageformat tinyint 2 0
messagetrust tinyint 2 0
attachment varchar 100
totalscore smallint 4 0
mailnow bigint 10 0

Table contained -1 rows

forum_posts table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
forupost_cre_ix Performance Asc created
forupost_dis_ix Performance Asc discussion
forupost_mai_ix Performance Asc mailed
forupost_par_ix Performance Asc parent
forupost_use_ix Performance Asc userid

forum_posts table relationships