sat-lms
Tables (6)
assignments
- id — BIGINT — Primary key — NOT NULL
- writer_id — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- due_date — DATETIME — NOT NULL
- allow_late — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- deleted_at — DATETIME
files
- id — BIGINT — Primary key — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- stored_name — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- file_size — BIGINT — NOT NULL
- extension — VARCHAR(20) — NOT NULL
- file_type — VARCHAR(30) — NOT NULL
- notice_id — BIGINT — Foreign key → notices.id
- assignment_id — BIGINT — Foreign key → assignments.id
- submission_id — BIGINT — Foreign key → submissions.id
- created_at — DATETIME — NOT NULL
notice_reads
- id — BIGINT — Primary key — NOT NULL
- notice_id — BIGINT — Foreign key → notices.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- read_at — DATETIME — NOT NULL
notices
- id (공지번호) — BIGINT — Primary key — NOT NULL
- writer_id (작성자id(외래키)) — BIGINT — Foreign key → users.id — NOT NULL
- title (공지제목) — VARCHAR(100) — NOT NULL
- content (공지본문내용) — TEXT — NOT NULL
- is_pinned (상단공지고정여부) — BOOLEAN — NOT NULL
- created_at (공지 작성일시) — DATETIME — NOT NULL
- updated_at (공지 수정일시) — DATETIME
- deleted_at (공지 삭제일시) — DATETIME
submissions
- id — BIGINT — Primary key — NOT NULL
- assignment_id — BIGINT — Foreign key → assignments.id — NOT NULL
- student_id — BIGINT — Foreign key → users.id — NOT NULL
- content — TEXT
- submitted_at — DATETIME — NOT NULL
- is_late — BOOLEAN — NOT NULL
- updated_at — DATETIME
users
- id (고유 id) — BIGINT — Primary key — NOT NULL
- student_number (학번) — VARCHAR(10) — NOT NULL
- password (비밀번호) — VARCHAR(255) — NOT NULL
- name (이름) — VARCHAR(20) — NOT NULL
- role (사용자 역할/권한) — VARCHAR(10) — NOT NULL
- status (승인상태) — VARCHAR(10) — NOT NULL
- rejected_reason (거절 이유) — VARCHAR(255)
- created_at (가입 신청 일시) — DATETIME — NOT NULL
- approved_at (승인일) — DATETIME
- deleted_at (탈퇴일) — DATETIME