Hotel

Tables (11)

Cities (Untitled3)

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

Facilities (Untitled4)

  • Key — Primary key — NOT NULL

HotelFacilities (Untitled2)

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

Hotels (Untitled)

  • Key — Primary key — NOT NULL

Reservations (Untitled5)

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

RoomTypes (Untitled10)

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

Rooms (Untitled6)

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

Sales (Untitled8)

  • Key — Primary key — NOT NULL

Trips (Untitled9)

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

Users (Untitled7)

  • Key — Primary key — NOT NULL

Whislists (Untitled11)

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