Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Frequently Asked Questions
 FAQ Addition Requests
 Description of Database fields and variables

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
   

T O P I C    R E V I E W
Raavin Posted - 18 May 2005 : 02:26:25
I'd like to get together a list of the Database fields and variables with descriptions of the data they contain and what they are used for. I don't have a list started up at the moment but I thought that others might be interested in the results or might want to contribute. Hopefully this would assist with development and with manual editing of database.

eg. (mainly made up or badly guessed)

table - FORUM_REPLY


field         description
    
CAT_ID        Category ID
FORUM_ID      Self explanatory
TOPIC_ID      Self explanatory
REPLY_ID      Self explanatory
R_MAIL
R_AUTHOR      Matches MEMBER_STATUS in the FORUM_MEMBERS table
R_MESSAGE     This is the message body
R_DATE        Date & time yyyymmddhhmmss ????
R_IP          IP address from where the message was sent
R_STATUS      boolean switch (visibility ???)
R_LAST_EDIT   Date of last edit (after initial creation)????
R_LAST_EDITBY Last edited by (member number reference
R_SIG         boolean switch for signature
R_MSGICON     boolean switch for icon


Perhaps a general development documentation project might be in order too.

Raavin ;)

<
2   L A T E S T    R E P L I E S    (Newest First)
Davio Posted - 19 May 2005 : 12:59:10
Team of little helpers. lol Make me sound like santa.

That has been done. I think maybe, I should just package it as a technical document and leave the rest of the document for another time.<
HuwR Posted - 18 May 2005 : 04:33:22
it is already being worked on by Davio and his team of helpers.<

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000 Version 3.4.07