Changes between Version 68 and Version 69 of iPeerDatabaseSchema


Ignore:
Timestamp:
2010-10-22T17:28:27Z (13 years ago)
Author:
Serge Okon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • iPeerDatabaseSchema

    v68 v69  
    341341||__Column__||__Type__||__Description__||__Foreign Key to table...__
    342342||'''id'''||integer||Primary_Key
    343 ||'''function_code'''||string||||A short code to ID the function||
     343||'''function_code'''||string||A short code to ID the function
    344344||'''function_name'''||string||A longer function name
    345345||'''parent_id'''||integer||Not sure (?)
     
    347347||'''url_link'''||string||The link to CakePHP's was to call this function.
    348348||'''PermissionTypes'''||setof(A,I,S)||Determines who is allowed to access this function. ''A'' is Admin, ''I'' stands for Instructors, and ''S'' for Students.
     349||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code.
    349350||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users''
    350351||'''created'''||date||a date entry for this entry's creation.
     
    352353||'''modified'''||date||the last time of modification
    353354== sys_parameters ==
     355Holds system configuration variables.
     356||__Column__||__Type__||__Description__||__Foreign Key to table...__
     357||'''id'''||integer||Primary_Key
     358||'''parameter_code'''||string||A key used by the code to check this setting
     359||'''parameter_value'''||string||The value of this configuration setting.
     360||'''parameter_type||enum(B,I,S)||The type of the value. ''B'' is boolean, ''I'' is integer, and ''S'' means string.
     361||'''description'''||text||The description of this parameter
     362||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code.
     363||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users''
     364||'''created'''||date||a date entry for this entry's creation.
     365||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users''
     366||'''modified'''||date||the last time of modification
    354367== users ==
    355368== user_enrols ==