weeb
Tables (3)
Hotel (Untitled2)
- hotelId (Key) — INT — Primary key — NOT NULL
- title (Field) — VARCHAR
- location (Field2) — VARCHAR
- rate (Field3) — INT
- pricePerDay (Field4) — INT
- totalRoom (Field5) — INT
- vacantRoom (Field6) — INT
- phone (Field7) — VARCHAR
- imageTitle (Field8) — VARCHAR
Reservation (Untitled3)
- reservationId (Key) — INT — Primary key — NOT NULL
- hotelId (Key2) — INT — Foreign key → Hotel.hotelId — NOT NULL
- userId (Key3) — INT — Foreign key → User.userId — NOT NULL
- numberOfRooms (Field) — INT
User (Untitled)
- userId (Key) — INT — Primary key — NOT NULL
- loginId (Field5) — VARCHAR
- password (Field2) — VARCHAR
- name (Field3) — VARCHAR
- userType (Field4) — ENUM