SAT-LMS ERD

Tables (6)

assignment

  • id — bigint — Primary key — NOT NULL
  • author_id — bigint — Foreign key → member.id — NOT NULL
  • title — varchar(200) — NOT NULL
  • description — text
  • due_date — datetime — NOT NULL
  • created_at — datetime — NOT NULL

file

  • id — bigint — Primary key — NOT NULL
  • owner_type — varchar(20) — NOT NULL
  • owner_id — bigint — NOT NULL
  • uploader_id — bigint — Foreign key → member.id — NOT NULL
  • original_name — varchar(255) — NOT NULL
  • stored_path — varchar(500) — NOT NULL
  • extension — varchar(10) — NOT NULL
  • size — bigint — NOT NULL
  • created_at — datetime — NOT NULL

member

  • id — bigint — Primary key — NOT NULL
  • student_id — varchar(20) — NOT NULL
  • email — varchar(100) — NOT NULL
  • password — varchar(255) — NOT NULL
  • name — varchar(50) — NOT NULL
  • role — varchar(20) — NOT NULL
  • status — varchar(20) — NOT NULL
  • created_at — datetime — NOT NULL

notice

  • id — bigint — Primary key — NOT NULL
  • author_id — bigint — Foreign key → member.id — NOT NULL
  • title — varchar(200) — NOT NULL
  • content — text — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

notice_read

  • id — bigint — Primary key — NOT NULL
  • notice_id — bigint — Foreign key → notice.id — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • read_at — datetime — NOT NULL

submission

  • id — bigint — Primary key — NOT NULL
  • assignment_id — bigint — Foreign key → assignment.id — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • content — text
  • submitted_at — datetime — NOT NULL
  • is_late — boolean — NOT NULL
  • updated_at — datetime — NOT NULL