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 ;)
<
Description of Database fields and variables
Posted - 18 May 2005 : 02:26:25
