경북대사물함
테이블 (3)
개폐기록 (record)
- record_id — BIGINT(20) — 기본 키 — NOT NULL
- lockerStatus — ENUM('NONE', 'OPEN', 'CLOSE') — NOT NULL
- createdAt — DATETIME — NOT NULL
- account_id — BIGINT(20) — 외래 키 → 계정.account_id
- locker_id — BIGINT(20) — 외래 키 → 사물함.locker_id
계정 (account)
- account_id — BIGINT(20) — 기본 키 — NOT NULL
- schoolNumber — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — ENUM('ROLE_STUDENT', 'ROLE_MANAGER') — NOT NULL
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- phoneNumber — VARCHAR(255) — NOT NULL
사물함 (locker)
- locker_id — BIGINT(20) — 기본 키 — NOT NULL
- lockerLocation — ENUM('LOC_B1', 'LOC_L', 'LOC_3F') — NOT NULL
- lockerNumber — VARCHAR(255) — NOT NULL
- lockerPassword — VARCHAR(255) — NOT NULL
- lockerIsBroken — BOOLEAN — NOT NULL
- account_id — BIGINT(20) — 외래 키 → 계정.account_id