Version 3 (modified by sunshine, 10 years ago) (diff)

--

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