|
ozone
Starting Member
India
11 Posts |
 Posted - 15 March 2001 : 02:20:28
|
Hi again,
Is there any link which explains the usage of the tables and what each field does in SQL Server 7. For instance, in the table 'FORUM_FORUM', what does F_TOPICS and F_COUNT mean. It shows 4 for both the fields even though Ive created only one Topic
Thanx in advance
Parasuraman
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 15 March 2001 : 02:49:49
|
Well, if you really want to know ozone, if you look at the front of your forum, you will see a Topics column and a Posts column. The topics column shows how many Topics have been posted in that particualr forum. The Posts column shows how many Posts and Replies in total are in that forum.
And we keep those numbers in F_TOPICS and F_COUNT for each forum that is created. The F_ is to tell us the field is in the FORUM table. If you look in the FORUM_CONFIG table you will notice all the fields begin with C_, and so it is with the other fields. The FORUM_FORUM table contains info on all the forums that you will create.
I can't go into detail on ALL the tables right now, as I'm tired and need some sleep. But there's no need to know what each table does. Unless you're gonna start doing some coding, then you can always ask what each table does. 
Unless someone is more willing than me to spill it all out.
|
 |
|
Topic Locked
