경북대사물함

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