HotelReservation

Tables (4)

board (Untitled)

  • userId (Key) — Long — Foreign key → user.userId — NOT NULL
  • boardId (Field) — Long
  • title (Field2) — String
  • date (Field3) — String
  • content (Field4) — String

reservation (Untitled2)

  • reservationId (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → user.userId — NOT NULL
  • roomdId (Key3) — Long — Foreign key → room.roomdId — NOT NULL
  • reservationDate (Field) — String
  • request (Field2) — String
  • checkInDate (Field3) — String
  • checkOutDate (Field4) — String
  • state (Field5) — String

room (Untitled3)

  • roomdId (Key) — Long — Primary key — NOT NULL
  • pricePerNight (Field) — int
  • grade (Field2) — String
  • roomNum (Field3) — int
  • roomAvailable (Field4) — boolean

user (Untitled4)

  • userId (Key) — Long — Primary key — NOT NULL
  • username (Field) — String
  • passoword (Field2) — String
  • name (Field3) — String
  • type (Field4) — String
  • phoneNum (Field5) — String