Hotel Migration ERD

Tables (13)

addresses (Untitled)

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

booking_lists (Untitled12)

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

carts (Untitled10)

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

categories (Untitled9)

  • Key — Primary key — NOT NULL

facilities (Untitled4)

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

fix_qnas (Untitled8)

  • Key — Primary key — NOT NULL

hotels (Untitled2)

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

imgs (Untitled7)

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

items (Untitled14)

  • Key — Primary key — NOT NULL

like_lists (Untitled13)

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

reviews (Untitled6)

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

rooms (Untitled3)

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

users (Untitled5)

  • Key — Primary key — NOT NULL