회비영 데모
테이블 (4)
locker
- locker_id — BIGINT — 기본 키
- locker_number — VARCHAR(10) — NOT NULL
- location — VARCHAR(100)
- locker_status — ENUM('AVAILABLE', 'IN_USE')
locker_application_period
- application_period_id — BIGINT — 기본 키
- start_time — TIMESTAMP — NOT NULL
- end_time — TIMESTAMP — NOT NULL
- is_finished — BOOLEAN
- application_type — ENUM(MAIN, ADDITIONAL
- semester_start_date — TIMESTAMP — NOT NULL
- semester_finish_date — TIMESTAMP
- semester — VARCHAR(100)
locker_history
- locker_history_id — BIGINT — 기본 키
- member_id — BIGINT — 외래 키 → member.member_id
- locker_id — BIGINT — 외래 키 → locker.locker_id
- application_period_id — BIGINT — 외래 키 → locker_application_period.application_period_id
- application_time — TIMESTAMP
- is_assigned — BOOLEAN
- assigned_at — TIMESTAMP
member
- member_id — BIGINT — 기본 키
- name — VARCHAR(100) — NOT NULL
- student_number — VARCHAR(20) — NOT NULL
- department — VARCHAR(100)
- role — ENUM('USER', 'ADMIN')