Forum threadinfo

From Open Source Software Research
Revision as of 17:41, 17 September 2014 by Gmadey (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Appears in the following schemas:

Most Recent Description

Table "sf0914.forum_threadinfo"
Column Type Modifiers
threadinfo_id integer not null default nextval(('forum_threadinfo_pk'::text)::regclass)
thread_id integer not null
thread_topic text not null default ''::text
thread_starter_user_id integer not null
num_replies integer
most_recent_post_date integer
group_forum_id integer not null
msg_id integer not null

Other Information About the Data

This appears to be cached info about threads, likely used to generate the 'thread listing', which shows the number of posts and the date of the last post. Presumably this is updated when a new post for a particular thread is added to the forum table.