Hotel

Tables (14)

amenities (Untitled2)

  • Key — Primary key — NOT NULL

boards (Untitled3)

  • Key — Primary key — NOT NULL

bookings (Untitled4)

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

categories (Untitled5)

  • Key — Primary key — NOT NULL

hotel_amenities (Untitled6)

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

hotels (Untitled)

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

payments (Untitled7)

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

review_tags (Untitled9)

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

reviews (Untitled8)

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

room_images (Untitled11)

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

rooms (Untitled10)

  • Key — Primary key — NOT NULL

tags (Untitled12)

  • Key — Primary key — NOT NULL

users (Untitled14)

  • Key — Primary key — NOT NULL

wishes (Untitled13)

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