Changes between Version 56 and Version 57 of iPeerDatabaseSchema


Ignore:
Timestamp:
2010-10-21T20:24:59Z (14 years ago)
Author:
Serge Okon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • iPeerDatabaseSchema

    v56 v57  
    105105||'''date_submitted'''||date||The date the evaluator submitted this evaluation.
    106106||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code.
    107 ||'''creator_id'''||integer||the ID of the ''user'' who created this course.
    108 ||'''created'''||date||a date entry for this entry's creation.
    109 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. 
     107||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users''
     108||'''created'''||date||a date entry for this entry's creation.
     109||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users''
    110110||'''modified'''||date||the last time of modification.
    111111== event_template_types ==
     
    117117||'''display_for_selection'''||integer||A boolean integer. Tells if this type of evaluations should be available for selection when an instructor creates an event
    118118||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code.
    119 ||'''creator_id'''||integer||the ID of the ''user'' who created this course.
    120 ||'''created'''||date||a date entry for this entry's creation.
    121 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. 
     119||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users''
     120||'''created'''||date||a date entry for this entry's creation.
     121||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users''
    122122||'''modified'''||date||the last time of modification
    123123== events ==
     
    135135||'''release_date_end'''||date||The when the event will close - stop showing up on the student's display, even if it was completed.
    136136||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code.
    137 ||'''creator_id'''||integer||the ID of the ''user'' who created this course.
    138 ||'''created'''||date||a date entry for this entry's creation.
    139 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. 
     137||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users''
     138||'''created'''||date||a date entry for this entry's creation.
     139||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users''
    140140||'''modified'''||date||the last time of modification
    141141== groups ==
     
    146146||''course_id''||integer||The ID of the course this group belongs to||''courses''
    147147||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code.
    148 ||'''creator_id'''||integer||the ID of the ''user'' who created this course.||users
    149 ||'''created'''||date||a date entry for this entry's creation.
    150 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||users
     148||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users''
     149||'''created'''||date||a date entry for this entry's creation.
     150||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users''
    151151||'''modified'''||date||the last time of modification
    152152== groups_members ==
     
    169169||''grade_release_status''||string||Can the users see the comments their group members gave them, or not? Just like above, ''Some'', ''None'' and ''All'' are possible.
    170170||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code.
    171 ||'''creator_id'''||integer||the ID of the ''user'' who created this course.||users
    172 ||'''created'''||date||a date entry for this entry's creation.
    173 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||users
     171||'''creator_id'''||integer||the ID of the ''user'' who created tthis record.||''users''
     172||'''created'''||date||a date entry for this entry's creation.
     173||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users''
    174174||'''modified'''||date||the last time of modification
    175175== mixevals ==
     
    185185||'''prefill_question_max'''||integer||The number of Textual Questions to Add.
    186186||'''availability||enum(public,private)||Determines whether this rubric can be used in an event by users other than the creator.
    187 ||'''creator_id'''||integer||the ID of the ''user'' who created this course.||users
    188 ||'''created'''||date||a date entry for this entry's creation.
    189 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||users
     187||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users''
     188||'''created'''||date||a date entry for this entry's creation.
     189||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users''
    190190||'''modified'''||date||the last time of modification
    191191== mixevals_questions_descs ==
     
    243243||'''availability'''||enum(public,private)||are others allowed to use/see this rubric template?
    244244||'''template'''||enum(horizontal, vertical)||Not sure (?)
    245 ||'''creator_id'''||integer||the ID of the ''user'' who created this course.||users
    246 ||'''created'''||date||a date entry for this entry's creation.
    247 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||users
     245||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users''
     246||'''created'''||date||a date entry for this entry's creation.
     247||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users''
    248248||'''modified'''||date||the last time of modification
    249249== rubrics_criterias ==
     
    282282||'''point_high_limit'''||integer||The maximum number of points per member, I guess, again. (?)
    283283||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code.
    284 ||'''creator_id'''||integer||the ID of the ''user'' who created this course.||users
    285 ||'''created'''||date||a date entry for this entry's creation.
    286 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||users
     284||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users''
     285||'''created'''||date||a date entry for this entry's creation.
     286||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users''
    287287||'''modified'''||date||the last time of modification
    288288== surveys ==
     
    297297||'''release_date_end'''||date||The final fate for this survey (and event). Students are unable to access the survey after this date.
    298298||'''released'''||emun(0,1)||hm.. no idea... (?)
    299 ||'''creator_id'''||integer||the ID of the ''user'' who created this course.||users
    300 ||'''created'''||date||a date entry for this entry's creation.
    301 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||users
     299||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users''
     300||'''created'''||date||a date entry for this entry's creation.
     301||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users''
    302302||'''modified'''||date||the last time of modification
    303303== survey_questions ==