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