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