infra-team04

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