asdf

Tables (4)

member

  • member_id — BIGINT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(50) — NOT NULL
  • role — ENUM('ROLE_USER', 'ROLE_ADMIN') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notice

  • notice_id — BIGINT
  • admin_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

reservation

  • reservation_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • room_id — BIGINT — NOT NULL
  • start_time — TIME — NOT NULL
  • end_time — TIME — NOT NULL
  • status — ENUM('PENDING', 'APPROVED', 'CANCELED', 'REJECTED')
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

room

  • room_id — BIGINT
  • room_number — VARCHAR(10) — NOT NULL