회비영 데모

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