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