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