Forum threadinfo
From Open Source Software Research
Appears in the following schemas:
- sf1104
- sf1204
- sf0205
- sf0305
- sf0405
- sf0505
- sf0605
- sf0705
- sf0805
- sf0905
- sf1005
- sf1105
- sf1205
- sf0106
- sf0206
- sf0306
- sf0406
- sf0506
- sf0606
- sf0706
- sf0806
- sf0906
- sf1006
- sf1106
- sf1206
- sf0107
- sf0207
- sf0307
- sf0407
- sf0507
- sf0607
- sf0707
- sf0807
- sf0907
- sf1007
- sf1107
- sf1207
- sf0108
- sf0208
- sf0308
- sf0408
- sf0508
- sf0608
- sf0708
- sf0808
- sf0908
- sf1008
- sf1108
- sf1208
- sf0109
- sf0209
- sf0309
- sf0409
- sf0509
- sf0609
- sf0709
- sf0809
- sf0909
- sf1009
- sf1109
- sf1209
- sf0110
- sf0210
- sf0310
- sf0410
- sf0510
- sf0610
- sf0710
- sf0810
- sf0910
- sf1010
- sf1110
- sf1210
- sf0111
- sf0211
- sf0311
- sf0411
- sf0511
- sf0611
- sf0711
- sf0811
- sf0911
- sf1011
- sf1111
- sf1211
- sf0112
- sf0212
- sf0312
- sf0412
- sf0512
- sf0612
- sf0712
- sf0812
- sf0912
- sf1012
- sf1112
- sf1212
- sf0113
- sf0213
- sf0813
- sf0913
- sf1013
- sf1113
- sf1213
- sf0114
- sf0214
- sf0314
- sf0514
- sf0614
- sf0714
- sf0814
- sf0914
Most Recent Description
| 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.
