Hotel

Tables (12)

amenities (Untitled3)

  • Key — Primary key — NOT NULL

bookings (Untitled6)

  • Key — Primary key — NOT NULL

hotel_amenities (Untitled9)

  • Key — Foreign key → amenities.Key — NOT NULL
  • Key (Key2) — Foreign key → hotels.Key — NOT NULL

hotel_categories (Untitled10)

  • Key — Primary key — NOT NULL

hotels (Untitled)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → hotel_categories.Key — NOT NULL
  • Key (Key3) — Foreign key → reviews.Key — NOT NULL

payments (Untitled7)

  • Key — Foreign key → bookings.Key — NOT NULL
  • Key (Key2) — Foreign key — NOT NULL

reviews (Untitled4)

  • Key — Primary key — NOT NULL

room_images (Untitled11)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → rooms.Key — NOT NULL

rooms (Untitled2)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → hotels.Key — NOT NULL
  • Key (Key3) — Foreign key → bookings.Key — NOT NULL

rtags (Untitled8)

  • Key — Foreign key → tags.Key — NOT NULL
  • Key (Key2) — Foreign key → reviews.Key — NOT NULL

tags (Untitled5)

  • Key — Primary key — NOT NULL

wishes (Untitled12)

  • Key — Foreign key → rooms.Key — NOT NULL
  • Key (Key2) — Foreign key — NOT NULL