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