| Column Name |
Datatype |
Default |
Column Description |
| post_id |
mediumint(8) unsigned
|
0 |
Foreign key to the phpbb_posts table. There is a one - one (manditory) relationship between these tables. Every post must have text. |
| bbcode_uid |
varchar(10)
|
|
This appears to be a temporary storage place for generating BBCode tags. I have not completely determined how this field is used yet. It is required, but may have a space instead of an actual bbcode_uid. |
| post_subject |
varchar(60)
|
|
Subject line for a post. Can be null. First post subject is also the topic title. The logic to ensure that the topic title is not null is enforced in the php code, not by the database constraints. |
| post_text |
text
|
|
The actual post of the text. |