hotel
Tables (10)
holidays
- holiday_id — BIGINT — Primary key — NOT NULL
- holiday_date — DATE — NOT NULL
- name — VARCHAR(100) — NOT NULL
hotels
- hotel_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
points
- point_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- amount — INT — NOT NULL
- reason — TINYINT — NOT NULL
- expires_at — DATETIME
- is_expired — TINYINT(1) — NOT NULL
reservations
- reservation_id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- check_in — DATE — NOT NULL
- check_out — DATE — NOT NULL
- number_of_guests — TINYINT — NOT NULL
- reservation_code — VARCHAR(100) — NOT NULL
review_photos
- review_photo_id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → reviews.review_id — NOT NULL
- photo_url — VARCHAR(255) — NOT NULL
reviews
- review_id — BIGINT — Primary key — NOT NULL
- reservation_id — BIGINT — Foreign key → reservations.reservation_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- content — TEXT — NOT NULL
- is_visible — TINYINT(1) — NOT NULL
room_photos
- room_photo_id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
- photo_url — VARCHAR(255) — NOT NULL
room_price_policies
- room_price_policy_id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
- season_type — TINYINT — NOT NULL
- price — INT — 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
users
- user_id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(100) — NOT NULL
- password — VARCHAR(100) — NOT NULL