hotel

Tables (7)

Hotel

  • id — BIGINT
  • name — VARCHAR(200) — NOT NULL
  • address — VARCHAR(300)
  • description — TEXT

Reservation

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • room_id — BIGINT — NOT NULL
  • date — DATE — NOT NULL
  • num_guests — INT — NOT NULL
  • expected_arrival — TIME
  • walk_in — BOOLEAN
  • status — ENUM('PENDING','CONFIRMED','CANCELLED','COMPLETED')

Room

  • id — BIGINT
  • room_type_id — BIGINT — NOT NULL
  • room_number — VARCHAR(50) — NOT NULL

RoomAvailability

  • id — BIGINT
  • room_id — BIGINT — NOT NULL
  • date — DATE — NOT NULL
  • status — ENUM('AVAILABLE','BOOKED')

RoomPrice

  • id — BIGINT
  • room_type_id — BIGINT — NOT NULL
  • season — ENUM('PEAK','OFF_PEAK') — NOT NULL
  • price — DECIMAL(10,2) — NOT NULL

RoomType

  • id — BIGINT
  • hotel_id — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • capacity — INT — NOT NULL

User

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)