Fenix Complete Reference (Dennis's Worklog)
The complete reference for Fenix support 
Data Model
This is my first data model of the system. Any suggestions regarding stored data are welcome.
[ITEMS]>---|-[USERS]
USERS
ID - INT[PK] (number auto-generated)
NAME - VARCHAR[NN] (nickname)
REALNAME - VARCHAR (optional: real name)
EMAIL - VARCHAR [NN]
PASSWORD - VARCHAR [NN] : (password to log in)
LOCATION - VARCHAR (optional: country)
ITEMS
ID - INT [PK]
NAME - VARCHAR (i.e. map_get_pixel)
CLASS [NN][CHECK ('F','K','V')] (Function, Keyword (global, begin, ...), Variable (file, x, graph, ...)
TEXT - VARCHAR [NN] (dunno if it should be HTML or not)
EXAMPLE - VARHCAR [NN] (example code)
TIMESTAMP - DATE [NN] (automaticly generated when record inserted)
USR_ID [NN][FK ref USERS] (user who created it)
Layout model
- Static part
- Dynamic part
-The rest is coming soon-
[ITEMS]>---|-[USERS]
USERS
ID - INT[PK] (number auto-generated)
NAME - VARCHAR[NN] (nickname)
REALNAME - VARCHAR (optional: real name)
EMAIL - VARCHAR [NN]
PASSWORD - VARCHAR [NN] : (password to log in)
LOCATION - VARCHAR (optional: country)
ITEMS
ID - INT [PK]
NAME - VARCHAR (i.e. map_get_pixel)
CLASS [NN][CHECK ('F','K','V')] (Function, Keyword (global, begin, ...), Variable (file, x, graph, ...)
TEXT - VARCHAR [NN] (dunno if it should be HTML or not)
EXAMPLE - VARHCAR [NN] (example code)
TIMESTAMP - DATE [NN] (automaticly generated when record inserted)
USR_ID [NN][FK ref USERS] (user who created it)
Layout model
- Static part
- Dynamic part
-The rest is coming soon-
(Posted on September, 28th 2006, 16:59)
Comments
yonni said:
for functions, could there be a place to write the full function (inc. perameters) and then a seperate place to explain the perameters (to encourage consistency)? Also, it might be a good idea to differentiate between predefined constant, global and local variables.
(Posted on September, 28th 2006, 22:15)