Stores the information about each thread. The posts in each thread are stored in Database Tables/mybb_posts .
Field
Type
Null
Key
Default
Description
tid
int(10)
No
Primary
Thread ID
fid
smallint(5)
No
Multiple
0
Forum ID
subject
varchar(120)
No
Multiple
Thread subject
prefix
smallint(5)
No
0
Thread prefix ID
icon
smallint(5)
No
0
Post Icon ID
poll
int(10)
No
0
Poll ID (if one exists)
uid
int(10)
No
Multiple
0
User ID of the author
username
varchar(80)
No
Username of the author
dateline
bigint(30)
No
Multiple
0
UNIX Timestamp of the time the thread was created
firstpost
int(10)
No
Multiple
0
Post ID of the first post
lastpost
bigint(30)
No
Multiple
0
UNIX Timestamp of the time the last post was posted
lastposter
varchar(120)
No
Username of the author who posted the last post
lastposteruid
int(10)
No
0
User ID of the last poster
views
int(100)
No
0
Number of thread views
replies
int(100)
No
0
Number of replies
closed
varchar(30)
No
Closed/moved thread status
sticky
int(1)
No
0
Sticky thread status
numratings
smallint(5)
No
0
Number of thread ratings
totalratings
smallint(5)
No
0
Total ratings value
notes
text
No
Moderator thread notes
visible
int(1)
No
0
Status of the thread (visible, unapproved, draft)
unapprovedposts
int(10)
No
0
The number of unapproved posts in the thread
attachmentcount
int(10)
No
0
The number of attachments in the thread
deletetime
int(10)
No
0
Used to keep track of moved threads with a "temporary" Moved link (UNIX Timestamp)
Indexes:
Keyname
Type
Cardinality
Field
PRIMARY
PRIMARY
0
tid
fid
INDEX
None
fid, visible, sticky
dateline
INDEX
None
dateline
lastpost
INDEX
None
lastpost, fid
firstpost
INDEX
None
firstpost
uid
INDEX
None
uid
subject
FULLTEXT
None
subject