pethotel

Tables (10)

booking

  • booking_id — uuid — Primary key — NOT NULL
  • start_date — varchar
  • end_date — varchar
  • guest — int
  • pet — int
  • pay_check — varchar
  • total_price — int
  • total_date — int
  • payment_id — varchar
  • hotel_id — long — Foreign key → hotel.hotel_id — NOT NULL
  • room_id — long — Foreign key → room.room_id — NOT NULL
  • roomdetail_id — long — Foreign key → room_detail.roomdetail_id — NOT NULL
  • id (id2) — long — Foreign key → user.id — NOT NULL

hotel

  • hotel_id — long — Primary key — NOT NULL
  • hotel_name — varchar
  • location — varchar
  • postcode — varchar
  • address — varchar
  • detail_address — varchar
  • extra_address — varchar
  • hotel_phone — varchar
  • hotel_info — varchar
  • userid — long — Foreign key → user.id — NOT NULL

hotel_facility

  • hf_id — Long — Primary key — NOT NULL
  • code — varchar
  • content — varchar
  • hotel_id — long — Foreign key → hotel.hotel_id — NOT NULL

hotel_img

  • himg_id — long — Primary key — NOT NULL
  • himg_file — varchar
  • himg_url — varchar
  • hotel_id — long — Foreign key → hotel.hotel_id — NOT NULL

room

  • room_id — long — Primary key — NOT NULL
  • room_type — varchar
  • room_name — varchar
  • room_price — int
  • limit_guest — int
  • limit_pet — int
  • check_in — varchar
  • check_out — varcgar
  • hotel_id — long — Foreign key → hotel.hotel_id — NOT NULL

room_amenity

  • ra_id — long — Primary key — NOT NULL
  • code — varchar
  • content — varchar
  • room_id — long — Foreign key → room.room_id — NOT NULL

room_detail

  • roomdetail_id — long — Primary key — NOT NULL
  • room_name — varchar
  • room_id — long — Foreign key → room.room_id — NOT NULL

room_feature

  • rf_id — long — Primary key — NOT NULL
  • code — varchar
  • content — varchar
  • room_id — long — Foreign key → room.room_id — NOT NULL

room_img

  • rimg_id — long — Primary key — NOT NULL
  • rimg_file — varchar
  • rimg_url — varchar
  • room_id — long — Foreign key → room.room_id — NOT NULL

user

  • id — long — Primary key — NOT NULL
  • userid — varchar
  • user_name — varchar
  • password — varchar
  • user_role — varchar
  • user_phone — varchar
  • nickname — varchar
  • user_status — varchar