hotel

Tables (5)

Hotels

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Field (Hotel_Name) — VARCHAR(100)

Untitled (Rooms)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Key (Hotel_ID) — BIGINT — Foreign key → Hotels.Key — NOT NULL
  • Field (Room_Name) — VARCHAR(100)

Untitled (Guest)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Field (Name) — VARCHAR(100)
  • Field (Point) — BIGINT

Untitled (Reviews)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Key (Room_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (Hotel_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (text) — MEDIUMTEXT

Untitled (Rent)

  • Key (Room_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (Hotel_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (Guest_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL