== 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