hotels
Tables (8)
hotels
- hotel_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
images
- image_id — BIGINT — Primary key — NOT NULL
- image_url — VARCHAR(200)
points
- Key — Primary key — NOT NULL
reservations
- reservation_id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
- check_in — DATETIME
- check_out — DATETIME
- head_count — TINYINT
- price — INT
- user_id (String) — VARCHAR(50)
reviews
- review_id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(50)
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
reviews_images
- review_id — BIGINT — Foreign key → reviews.review_id — NOT NULL
- image_id — BIGINT — Foreign key → images.image_id — NOT NULL
rooms
- room_id — BIGINT — Primary key — NOT NULL
- hotel_id — BIGINT — Foreign key → hotels.hotel_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- capacity — TINYINT — NOT NULL
- floor — TINYINT — NOT NULL
- bathtub_flag — TINYINT(1) — NOT NULL
- view_type — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — `fk_Rooms_hotels_idx`
- max_price — INT
- min_price — INT
rooms_images
- image_id — BIGINT — Foreign key → images.image_id — NOT NULL
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL