| | 6 | == Table edumaterial_shared == |
| | 7 | Purpose: store all shared materials |
| | 8 | * ID: unique ID |
| | 9 | * type: encoded type |
| | 10 | * access: student/teacher |
| | 11 | * title |
| | 12 | * location folder or binary content |
| | 13 | * author contact: who's responsible for keeping this up to date |
| | 14 | * tags: space or comma separated list of tags one could search on to find this content |
| | 15 | |
| | 16 | == Table class_assignments == |
| | 17 | Purpose: Record what is assigned per class, allow for versioning of materials specific to class |
| | 18 | * ID: unique ID |
| | 19 | * title |
| | 20 | * location folder or binary folder |
| | 21 | * PID of the class that's adopting it |
| | 22 | * GID of the group that's assigned to |
| | 23 | * state: prepared/assigned/expired |
| | 24 | * due_on: date when it is due |
| | 25 | * after_due: show/hide |
| | 26 | |
| | 27 | = Table student_assignments == |
| | 28 | Purpose: Record what is assigned per student, allow for submissions |
| | 29 | * ID: unique ID |
| | 30 | * assignment_ID: ID from class_assignments |
| | 31 | * student_ID: uid from users |
| | 32 | * state: submitted/not submitted |
| | 33 | * submission_time: datetime |
| | 34 | * submission: binary record or folder where submitted materials are |
