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)