HotelPractice
Tables (13)
User (Untitled)
- id — Long — Primary key — NOT NULL
- Field
city (Untitled5)
- id — Long — Primary key — NOT NULL
- city_name — String
- city_description — String
coupon (Untitled10)
- id — Long — Primary key — NOT NULL
facility (Untitled12)
- id — Long — Primary key — NOT NULL
- hotel_id — Long — Foreign key → hotel.id — NOT NULL
- facility_name_id — Long — Foreign key → facility_name.id — NOT NULL
facility_name (Untitled13)
- id — Long — Primary key — NOT NULL
hotel (Untitled3)
- id — Long — Primary key — NOT NULL
- city_id — Long — Foreign key → city.id — NOT NULL
pay (Untitled8)
- id — Long — Primary key — NOT NULL
- reservation_id — Long — Foreign key → reservation.id — NOT NULL
- coupon_id — Long — Foreign key → coupon.id — NOT NULL
reservation (Untitled7)
- id — Long — Primary key — NOT NULL
- room_id — Long — Foreign key → room.id — NOT NULL
- user_id — Long — Foreign key → User.id — NOT NULL
review (Untitled9)
- id — Long — Primary key — NOT NULL
- reservation_id — Long — Foreign key → reservation.id — NOT NULL
room (Untitled4)
- id — Long — Primary key — NOT NULL
- hotel_id — Long — Foreign key → hotel.id — NOT NULL
- room_type_id — Long — Foreign key → room_type.id — NOT NULL
room_type (Untitled11)
- id — Long — Primary key — NOT NULL
trip (Untitled6)
- id — Long — Primary key — NOT NULL
- city_id — Long — Foreign key → city.id — NOT NULL
wish_list (Untitled2)
- id — Long — Primary key — NOT NULL
- hotel_id — Long — Foreign key → hotel.id — NOT NULL
- user_id — Long — Foreign key → User.id — NOT NULL