Changes between Version 16 and Version 17 of iPeerDatabaseSchema


Ignore:
Timestamp:
2010-10-15T16:50:33Z (14 years ago)
Author:
Serge Okon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • iPeerDatabaseSchema

    v16 v17  
    1111||'''password'''||string||an MD5 hash of the user password.
    1212||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code.
    13 ||'''creator_id'''||integer||the ID of the user who created this course.||''users''
     13||'''creator_id'''||integer||the ID of the ''user'' who created this course.||''users''
    1414||'''created'''||date||a date entry for this entry's creation.
    15 ||'''updater_id'''||integer||the last user's ID who changed this record.||''users''
     15||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users''
     16||'''modified'''||date||the last time of modification.
    1617||'''instructor_id'''||integer||unused, as far as I can tell. The course-instructor is a many-to-many relationship is handled by the ''user_courses'' table.
    1718== evaluation_mixevals ==
    … …  
    2627||'''grp_event_id'''||integer||Points to the ''group_events'' entry this entry is a part of.||''group_events''
    2728||'''event_id'''||integer||Points to the ''event'' that the above ''group_event'' entry is part of.||''events''
    28 
     29||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code.
     30||'''creator_id'''||integer||the ID of the ''user'' who created this course.||''users''
     31||'''created'''||date||a date entry for this entry's creation.
     32||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users''
     33||'''modified'''||date||the last time of modification.
    2934== evaluation_mixeval_details==
    3035||'''id'''||primary key||