test
Tables (6)
Untitled (hotel)
- Key (hotel_id) — Primary key — NOT NULL
- Field (name)
Untitled (room)
- Key (room_id) — Primary key — NOT NULL
- Key (hotel_id) — Foreign key → Untitled.Key — NOT NULL
- Field (name)
- Field2 (capacity)
- Field (floor)
- Field (bathtub_flag)
- Field (view_type)
- Field (created_at)
- Key (reservation_key) — Foreign key → Untitled.Key — NOT NULL
- userId (userName) — Foreign key → Untitled.userId — NOT NULL
Untitled (reservation)
- Key (reservation_key) — Primary key — NOT NULL
- userId (userName) — Foreign key → user.userId — NOT NULL
Untitled (review)
- Key (review_id) — Primary key — NOT NULL
- Field (content)
- Field (imagePath)
Untitled (userReview)
- userId (userName) — Foreign key → user.userId — NOT NULL
- Key (review_id) — Foreign key → Untitled.Key — NOT NULL
user (User)
- userId (userName) — Primary key — NOT NULL
- userName (userPassword)
- userPassword (userRole)