test

Tables (5)

Group (group)

  • Group Id (group_id) — int — Primary key — NOT NULL
  • Group Name (group-name) — VARCHAR(255)

Hotel (hotel)

  • Hotel Id (hotel_id) — int — Primary key — NOT NULL
  • Hotel Name (hotel-name) — VARCHAR(255)
  • Hotel Address (hotel-address) — VARCHAR(255)

Order (order)

  • Order Id (order_id) — int — Primary key — NOT NULL
  • User Id (user_id) — int — Foreign key → User.User Id
  • Hotel Id (hotel_id) — int — Foreign key → Hotel.Hotel Id — NOT NULL

Review (review)

  • Review Id (_id) — int — Primary key — NOT NULL
  • User Id (user) — int — Foreign key → User.User Id
  • Review Content (content) — VARCHAR(255)
  • Hotel Id (hotel_id) — int — Foreign key → Hotel.Hotel Id — NOT NULL

User (user)

  • User Id (user_id) — int — Primary key — gkdl
  • name — VARCHAR(255)
  • email — VARCHAR(20)
  • password — VARCHAR(100)
  • Field
  • Field2