Changes between Version 67 and Version 68 of iPeerDatabaseSchema

Timestamp:

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

Author:

Serge Okon

Comment:

--

iPeerDatabaseSchema

@@ -338 +338 @@
 ||'''user_id'''||integer||The User ID of a user in this group||''users''
 == sys_function ==
+Holds the access permissions, and the location of some iPeer functionality (used sparsely for that). 
 ||__Column__||__Type__||__Description__||__Foreign Key to table...__
 ||'''id'''||integer||Primary_Key
-||'''function_code'''||A short code to ID the function||
-||'''function_name'''||A longer function name
-||'''parent_id'''||Not sure (?)
-||'''controller_name'''||The name for the controller this function sits in
-||'''url_link'''||The link to CakePHP's was to call this function.
+||'''function_code'''||string||||A short code to ID the function||
+||'''function_name'''||string||A longer function name
+||'''parent_id'''||integer||Not sure (?)
+||'''controller_name'''||string||The name for the controller this function sits in
+||'''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.
+||'''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
 == sys_parameters ==
 == users ==