Description of Database fields and variables - Posted (4611 Views)
Starting Member
Raavin
Posts: 16
16
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 ;)

<
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Forum Admin
HuwR
Posts: 20611
20611
it is already being worked on by Davio and his team of helpers.<
Posted
Development Team Member
Davio
Posts: 12217
12217
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.<
 
You Must enter a message