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