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)