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