Changes between Version 68 and Version 69 of iPeerDatabaseSchema

Timestamp:

2010-10-22T17:28:27Z (14 years ago)

Author:

Serge Okon

Comment:

--

iPeerDatabaseSchema

@@ -341 +341 @@
 ||__Column__||__Type__||__Description__||__Foreign Key to table...__
 ||'''id'''||integer||Primary_Key
-||'''function_code'''||string||||A short code to ID the function||
+||'''function_code'''||string||A short code to ID the function
 ||'''function_name'''||string||A longer function name
 ||'''parent_id'''||integer||Not sure (?)
@@ -347 +347 @@
 ||'''url_link'''||string||The link to CakePHP's was to call this function.
 ||'''PermissionTypes'''||setof(A,I,S)||Determines who is allowed to access this function. ''A'' is Admin, ''I'' stands for Instructors, and ''S'' for Students.
+||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code.
 ||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users''
 ||'''created'''||date||a date entry for this entry's creation.
@@ -352 +353 @@
 ||'''modified'''||date||the last time of modification
 == sys_parameters ==
+Holds system configuration variables.
+||__Column__||__Type__||__Description__||__Foreign Key to table...__
+||'''id'''||integer||Primary_Key
+||'''parameter_code'''||string||A key used by the code to check this setting
+||'''parameter_value'''||string||The value of this configuration setting.
+||'''parameter_type||enum(B,I,S)||The type of the value. ''B'' is boolean, ''I'' is integer, and ''S'' means string.
+||'''description'''||text||The description of this parameter
+||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code.
+||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users''
+||'''created'''||date||a date entry for this entry's creation.
+||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users''
+||'''modified'''||date||the last time of modification
 == users ==
 == user_enrols ==