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