Changes between Version 25 and Version 26 of iPeerDatabaseSchema


Ignore:
Timestamp:
2010-10-15T18:38:32Z (13 years ago)
Author:
Serge Okon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • iPeerDatabaseSchema

    v25 v26  
    9797||'''modified'''||date||the last time of modification.
    9898== evaluation_submissions ==
     99||__Column__||__Type__||__Description__||__Foreign Key to table...__||
     100||'''id'''||integer||Primary_Key
     101||'''event_id'''||integer||Points to the ''event'' that the above ''group_event'' entry is part of.||''events''
     102||'''grp_event_id'''||integer||Points to the ''group_events'' entry this entry is a part of.||''group_events''
     103||'''submitter_id'''||integer||The evaluator's user ID||''users''
     104||'''submitted'''||integer||Apparently determined whether the evaluation was submitted or not. I don't see any 0's in the prod2009 database though. Not sure (?).
     105||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code.
     106||'''creator_id'''||integer||the ID of the ''user'' who created this course. Not used in this table (All 0's) (?)||''users''
     107||'''created'''||date||a date entry for this entry's creation.
     108||'''updater_id'''||integer||the last ''user's'' ID who changed this record. Not used in this table (All NULLS's)||''users''
     109||'''modified'''||date||the last time of modification.
    99110== event_template_types ==
    100111== events ==