Difference between revisions of "Forum threadinfo"

From Open Source Software Research
Jump to: navigation, search
(updated for sf0814)
(updated for sf0914)
 
Line 111: Line 111:
 
* [[sf0714]]
 
* [[sf0714]]
 
* [[sf0814]]
 
* [[sf0814]]
 +
* [[sf0914]]
  
 
==Most Recent Description==
 
==Most Recent Description==
 
{| border="2"
 
{| border="2"
|+ Table "sf0814.forum_threadinfo"
+
|+ Table "sf0914.forum_threadinfo"
 
|-
 
|-
 
! Column
 
! Column

Latest revision as of 17:41, 17 September 2014

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.