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