exam-hotel
Tables (7)
hotel (Untitled)
- hotel_id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar
image (Untitled6)
- image_id (Key) — bigint — Primary key — NOT NULL
- review_id (Key2) — bigint — Foreign key → review.review_id — NOT NULL
- path (Field) — varchar
point (Untitled7)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (Field) — bigint
- amount (Field2) — int
- reason (Field3) — varchar
- earned_at (Field4) — datetime
- expires_at (Field5) — datetime
- expired (Field6) — tinyint(1)
price (Untitled4)
- price_id (Key2) — bigint — Primary key — NOT NULL
- room_id (Key) — bigint — Foreign key → room.room_id — NOT NULL
- peak_season_price (Field) — int
- off_season_price (Field2) — int
reservation (Untitled3)
- reservation_id (Key2) — bigint — Primary key — NOT NULL
- room_id (Key) — bigint — Foreign key → room.room_id — NOT NULL
- check_in_date (Field) — datetime
- check_out_date (Field2) — datetime
- reserved_number (Field3) — tinyint
- is_cancelled (Field4) — tinyint(1)
- price (Field5) — int
review (Untitled5)
- review_id (Key) — bigint — Primary key — NOT NULL
- reservation_id (Key2) — bigint — Foreign key → reservation.reservation_id — NOT NULL
- expose (Field2) — tinyint(1)
- content (Field) — varchar
room (Untitled2)
- room_id (Key) — bigint — Primary key — NOT NULL
- hotel_id (Key2) — bigint — Foreign key → hotel.hotel_id — NOT NULL
- name (Field) — varchar
- capacity (Field2) — tinyint
- floor (Field3) — tinyint
- bathtub_flag (Field4) — tinyint(1)
- view_type (Field5) — tinyint
- created_at (Field6) — datetime