Hotel

Tables (12)

amenities (Untitled2)

  • Key — Primary key — NOT NULL

bookings (Untitled3)

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

dorm_amenities (Untitled14)

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

dorms (Untitled)

  • Key — Primary key — NOT NULL

payments (Untitled5)

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

review_tags (Untitled13)

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

reviews (Untitled6)

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

room_images (Untitled8)

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

rooms (Untitled7)

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

tags (Untitled12)

  • Key — Primary key — NOT NULL

users (Untitled9)

  • Key — Primary key — NOT NULL

wishes (Untitled10)

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