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