| Author |
 Topic  |
|
|
douglerner
Starting Member
10 Posts |
 Posted - 24 July 2003 : 01:59:45
|
Could somebody point me to specs detailing the various fiels in the database tables.
For example, what is the definition of M_STATUS in the FORUM_MEMBERS table?
Thanks,
Doug
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 24 July 2003 : 05:33:21
|
Most of them (but not all) are largely self explanatory. There is no formal documentation available on all database fields I'm afraid so you'll just need to ask here when your unsure of something.
M_STATUS as far as I know is used to indicate whether a member is pending activation (0), deleted (0), or active (1) |
Kiwihosting.Net - The Forum Hosting Specialists
|
Edited by - Gremlin on 24 July 2003 05:35:00 |
 |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 24 July 2003 : 06:04:46
|
| Doh yeah forgot about the pending table :) |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
douglerner
Starting Member
10 Posts |
Posted - 24 July 2003 : 09:22:12
|
Thank you, people. I will ask about others here that are not clear!
doug
|
|
|
|
douglerner
Starting Member
10 Posts |
Posted - 29 July 2003 : 05:41:01
|
I notice that in the FORUM_TOPICS table there is a T_AUTHOR field specifying the topic author. But in the FORUM_FORUM table there is no F_AUTHOR. Does the concept of "forum author" not exist? Are they just owned by the system itself?
Thanks,
doug
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
douglerner
Starting Member
10 Posts |
Posted - 31 July 2003 : 02:36:03
|
In the FORUM_TOPICS table I would like to confirm the following:
(1) Is T_DATE the date the topic was created?
(2) Does the format 20030625101511 mean June 25, 2003 at 10:15 am (and 11 seconds)?
Thanks,
doug
|
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
douglerner
Starting Member
10 Posts |
Posted - 02 August 2003 : 23:04:55
|
In FORUM_REPLY there are the following fields:
"CAT_ID"
"FORUM_ID"
"TOPIC_ID"
"REPLY_ID"
The TOPIC_ID refers to the topic this reply is linked to. My question is, why are the CAT_ID and FORUM_ID indices needed in this table? The TOPIC_ID alone should be sufficient to locate the associated topic, shouldn't it?
doug
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
| |
Topic |
|
Topic Locked
