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