사물함
테이블 (8)
Allocate
- id — BIGINT — 기본 키 — NOT NULL
- apply_id — BIGINT
- locker_id — VARCHAR(10)
- student_id — BIGINT
- apply_form_id — BIGINT
- apply_id (apply_id2) — BIGINT — 외래 키 → Apply.apply_id — NOT NULL
- name — VARCHAR(10) — 외래 키 → Locker.name — NOT NULL
- student_id (student_id2) — BIGINT — 외래 키 → Student.student_id — NOT NULL
- apply_form_id (apply_form_id2) — BIGINT — 외래 키 → ApplyForm.apply_form_id — NOT NULL
Apply
- apply_id — BIGINT — 기본 키 — NOT NULL
- student_id — BIGINT
- apply_form_id — BIGINT
- first_floor — ENUM('FLOOR_L', 'FLOOR_3F', 'FLOOR_B1')
- first_height — ENUM('TOP','MIDDLE','BOTTOM')
- second_floor — ENUM('FLOOR_L', 'FLOOR_3F', 'FLOOR_B1')
- second_height — ENUM('TOP','MIDDLE','BOTTOM')
- period — ENUM('PRIMARY','ADDITIONAL','REPLACEMENT')
- status — ENUM('APPLY','APPROVE','REJECT','BROKEN_APPLY')
- createdAt — TIMESTAMP
- updateAt — TIMESTAMP
- apply_form_id (apply_form_id2) — BIGINT — 외래 키 → ApplyForm.apply_form_id — NOT NULL
- student_id (student_id2) — BIGINT — 외래 키 → Student.student_id — NOT NULL
ApplyForm
- apply_form_id — BIGINT — 기본 키 — NOT NULL
- year — INT
- semester — INT
- first_apply_start_date — TIMESTAMP
- first_apply_end_date — TIMESTAMP
- semester_end_date — TIMESTAMP
- status — ENUM('ACTIVE', 'INACTIVE')
Dues
- id — BIGINT — 기본 키 — NOT NULL
- dues — BOOLEAN — NOT NULL
- student_id — BIGINT — 외래 키 → Student.student_id — NOT NULL
Locker
- name — VARCHAR(10) — 기본 키 — NOT NULL
- floor — ENUM('FLOOR_L', 'FLOOR_3F', 'FLOOR_B1') — NOT NULL
- height — INT — NOT NULL
- pw — VARCHAR(4) — NOT NULL
- broken — BOOLEAN — NOT NULL
- apply_form_id — BIGINT — 외래 키 → ApplyForm.apply_form_id — NOT NULL
OAuth2UserInfo
- oauth2_user_info_id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255)
- provider — VARCHAR(255)
- provider_id — VARCHAR(255)
- student_id — BIGINT
- student_id (student_id2) — BIGINT — 외래 키 → Student.student_id — NOT NULL
Report
- apply_id — BIGINT — 외래 키 → Apply.apply_id — NOT NULL
- content — VARCHAR(1000)
Student
- student_id — BIGINT — 기본 키 — NOT NULL
- student_number — VARCHAR(15) — NOT NULL
- name — VARCHAR(50)
- role — ENUM('ROLE_STUDENT', 'ROLE_EXECUTIVE', 'ROLE_FINANCE')