융프

테이블 (5)

application

  • id — int — 기본 키
  • student_id — int — 외래 키 → students.id
  • status — varchar(50) — NOT NULL — '대기' '검토' '승인' '거부'
  • priority_score — int — NOT NULL
  • is_document — bool
  • Field
  • created_at — datetime — NOT NULL
  • update_at — datetime

dormitory

  • id — int — 기본 키
  • dorm_name — varchar(50) — NOT NULL
  • gender — char — NOT NULL

members

  • id — int — 기본 키
  • username — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • role — varchar(128) — NOT NULL
  • created_at — datetime — NOT NULL

period

  • id — int — 기본 키
  • application_start — datetime — NOT NULL
  • announcement — datetime — NOT NULL
  • payment_deadline — datetime — NOT NULL
  • document_deadline — datetime — NOT NULL
  • additional_application — datetime — NOT NULL

students

  • id — int — 기본 키
  • member_id — int — 외래 키 → members.id
  • name — varchar(256) — NOT NULL
  • student_number — varchar(256) — NOT NULL
  • student_type — varchar(128) — NOT NULL
  • major — varchar(256) — NOT NULL
  • gpa — double — NOT NULL
  • distance_from_school — double — NOT NULL
  • submit_document — tinyint(1) — NOT NULL