융프
테이블 (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