Description of Database fields and variables

Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/58352?pagenum=1
05 November 2025, 09:00

Topic


Raavin
Description of Database fields and variables
18 May 2005, 02:26


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

Code:

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 ;)

<

 

Replies ...


HuwR
18 May 2005, 04:33


it is already being worked on by Davio and his team of helpers.<
Davio
19 May 2005, 12:59


Team of little helpers. lol Make me sound like santa. bigsmile
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.<
© 2000-2021 Snitz™ Communications