통합 디비
테이블 (20)
allocate
- id — BIGINT — 기본 키 — NOT NULL
- apply_id — BIGINT
- locker_id — VARCHAR(10)
- student_id — BIGINT
- apply_form_id — BIGINT
apply
- apply_id — BIGINT — 기본 키 — NOT NULL
- created_at — timestamp
- update_at — timestamp
- student_id — BIGINT
- first_floor — SMALLINT
- first_height — SMALLINT
- second_floor — SMALLINT
- second_height — SMALLINT
- period — VARCHAR
- status — VARCHAR(255)
- apply_form_id — BIGINT — 외래 키 → apply_form.apply_form_id — NOT NULL
apply_form
- apply_form_id — BIGINT — 기본 키 — NOT NULL
- year — INT
- semester — INT
- first_apply_start_date — datetime
- first_apply_end_date — datetime
- semester_end_date — datetime
- status — SMALLINT
auth_client_domains
- domain_id — BIGINT — 기본 키 — NOT NULL
- domain — VARCHAR(255)
- client_id — BIGINT — 외래 키 → auth_clients.client_id — NOT NULL
auth_clients
- client_id — BIGINT — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- client_name — VARCHAR(100) — NOT NULL
- client_description — VARCHAR(500)
- jwt_secret — VARCHAR(500) — NOT NULL
- status — VARCHAR(255) — NOT NULL
authorization_codes
- code — VARCHAR(36) — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- redirect_uri — VARCHAR(500) — NOT NULL
- expires_at — DATETIME — NOT NULL
- used — BIT(1) — NOT NULL
- created_at — TIMESTAMP
- client_id — BIGINT — 외래 키 → auth_clients.client_id — NOT NULL
deprecated_social_accounts (social_accounts)
- social_id — BIGINT — 기본 키 — NOT NULL
- provider_type — VARCHAR(50) — NOT NULL — google, kakao, github 등
- provider_key — VARCHAR(255) — NOT NULL — 제공자 측 식별자
- created_at — TIMESTAMP
- student_id
dues
- dues_id — BIGINT — 기본 키 — NOT NULL
- student_id — BIGINT — 외래 키 → student.student_id — NOT NULL — 납부 학생
- depositor_name — VARCHAR(50) — NOT NULL — 입금자명
- amount — INT — NOT NULL — 납부 금액
- remaining_semesters — INT — NOT NULL — 잔여 학기
- submitted_at — DATETIME — NOT NULL — 납부일
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
locker
- name — VARCHAR(10) — 기본 키 — NOT NULL
- floor — VARCHAR(255) — NOT NULL
- height — INT — NOT NULL
- pw — VARCHAR(4) — NOT NULL
- broken — BIT(1) — NOT NULL
- allocate_id — BIGINT — 외래 키 → allocate.id — NOT NULL
locker_allocate
- allocate_id — BIGINT — 기본 키 — NOT NULL
- apply_id — BIGINT — 외래 키 → locker_apply.apply_id
- form_id — BIGINT — 외래 키 → locker_apply_form.form_id
- locker_name — VARCHAR(10)
- student_id — BIGINT — 외래 키 → student.student_id — 배정받은 학생
locker_apply
- apply_id — BIGINT — 기본 키 — NOT NULL
- form_id — BIGINT — 외래 키 → locker_apply_form.form_id
- student_id — BIGINT — 외래 키 → student.student_id — 신청자
- first_floor — SMALLINT
- first_height — SMALLINT
- second_floor — SMALLINT
- second_height — SMALLINT
- status — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
locker_apply_form
- form_id — BIGINT — 기본 키 — NOT NULL
- year — INT — NOT NULL
- semester — INT — NOT NULL
- first_apply_start_date — DATETIME
- first_apply_end_date — DATETIME
- semester_end_date — DATETIME
- status — SMALLINT
locker_report
- report_id — BIGINT — 기본 키 — NOT NULL
- apply_id — BIGINT — 외래 키 → locker_apply.apply_id — NOT NULL
- content — VARCHAR(255)
oauth_user_info
- oauth_user_info_id — BIGINT — 기본 키 — NOT NULL
- student_id — BIGINT — 기본 키
- email — VARCHAR(255)
- provider — VARCHAR(255)
- provider_id — VARCHAR(255)
official_post (CopyOftech_events)
- event_id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(255)
- content — TEXT
- deleted — BIT(1)
provider
- provider_id — bigint — 기본 키 — NOT NULL
- email — varchar(255) — NOT NULL
- provider_name — varchar(255) — NOT NULL
- provider_key — varchar(255) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- student_id — BIGINT — 외래 키 → student.student_id — NOT NULL — 통합 식별자
qr_auth_log
- log_id — BIGINT — 기본 키 — NOT NULL
- student_number — VARCHAR(20) — NOT NULL — 로그 당시 학번
- student_name — VARCHAR(50) — NOT NULL
- scan_date — DATE — NOT NULL
- scanned_by — VARCHAR(255) — NOT NULL — 스캔한 관리자
- dues_paid — BIT(1) — NOT NULL
- created_at — TIMESTAMP
report
- apply_id — BIGINT — 기본 키 — NOT NULL
- content — VARCHAR(255)
- apply_id (apply_id2) — BIGINT — 외래 키 → apply.apply_id — NOT NULL
student
- student_id — BIGINT — 기본 키 — NOT NULL — 통합 식별자
- student_number — VARCHAR(20) — NOT NULL — 학번 (비즈니스 키)
- name — VARCHAR(50) — NOT NULL — 이름
- email — VARCHAR(255) — NOT NULL — 이메일 (연락처)
- major — VARCHAR(100) — 학과
- role — VARCHAR(20) — 권한(ROLE_STUDENT, ROLE_ADMIN)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
tech_events
- event_id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(255)
- content — TEXT
- start_date — DATETIME
- end_date — DATETIME
- deleted — BIT(1)