hotel
Tables (7)
bookings (Untitled7)
- booking_id (Key) — BIGINT — Primary key — NOT NULL
- room_id (Key2) — BIGINT — Foreign key → rooms.room_id — NOT NULL
- user_id (Key3) — BIGINT — Foreign key → users.user_id — NOT NULL
- check_in (Field) — date
- check_out (Field2) — date
hotels (Untitled3)
- hotel_id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — varchar(100)
points (Untitled6)
- point_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → users.user_id — NOT NULL
- booking_id (Key3) — BIGINT — Foreign key → bookings.booking_id — NOT NULL
- expire_date (Field) — date
- created_at (Field2) — datetime
review_photos (Untitled5)
- photo_id (Key) — BIGINT — Primary key — NOT NULL
- review_id (Key2) — BIGINT — Foreign key → reviews.review_id — NOT NULL
- photo_url (Field) — varchar(255)
- upload_at (Field2) — datetime
reviews (Untitled4)
- review_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → users.user_id — NOT NULL
- room_id (Key3) — BIGINT — Foreign key → rooms.room_id — NOT NULL
- contnet (Field) — text
- created_at (Field2) — datetime
- is_visible (Field3) — tinyint(1)
rooms (Untitled2)
- room_id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — varchar(100)
- capacity (Field2) — tinyint
- floor (Field3) — tinyint
- bathtub_flag (Field4) — tinyint(1)
- view_type (Field5) — tinyint
- created_at (Field6) — datetime
- hotel_id (Key2) — BIGINT — Foreign key → hotels.hotel_id — NOT NULL
users (Untitled)
- user_id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — varchar(50)
- password (Field2) — varchar(255)
- created_at (Field3) — datetime