Hotel

Tables (13)

Amenitys (Untitled2)

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

Bookings (Untitled4)

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

D_amenitys (CopyOfUntitled3)

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

D_categorys (Untitled3)

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

Dorms (Untitled)

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

Users (Untitled6)

  • Key — Primary key — NOT NULL

Wishs (Untitled10)

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

payments (CopyOfUntitled4)

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

r_tsgs (Untitled8)

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

reviews (Untitled7)

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

room_imgs (CopyOfUntitled5)

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

rooms (Untitled5)

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

tags (Untitled9)

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