== Table edumaterial_types == Purpose: store types of material we have * type: encoded type * description: textual description of type like slides, HTML lecture, homework, CCTF == Table edumaterial_shared == Purpose: store all shared materials * ID: unique ID * type: encoded type * access: student/teacher * title * location folder or binary content * author contact: who's responsible for keeping this up to date * tags: space or comma separated list of tags one could search on to find this content == Table class_assignments == Purpose: Record what is assigned per class, allow for versioning of materials specific to class * ID: unique ID * title * location folder or binary folder * PID of the class that's adopting it * GID of the group that's assigned to * state: prepared/assigned/expired * due_on: date when it is due * after_due: show/hide == Table student_assignments == Purpose: Record what is assigned per student, allow for submissions * ID: unique ID * assignment_ID: ID from class_assignments * student_ID: uid from users * state: submitted/not submitted * submission_time: datetime * submission: binary record or folder where submitted materials are