=== packages ===
id|int(11)|PRI
dest_id|int(11)|MUL
title|varchar(500)|
slug|varchar(500)|UNI
overview|text|
price_per_person|int(11)|
original_price|int(11)|
price_label|varchar(50)|
nights|int(11)|
days|int(11)|
cities|text|
cities_count|int(11)|
hero_image|varchar(500)|
nexus_link|text|
ex_city|varchar(100)|
is_honeymoon|tinyint(4)|
is_premium|tinyint(4)|
is_active|tinyint(4)|
hotels_count|int(11)|
activities_count|int(11)|
transfers_count|int(11)|
star_rating|int(11)|
created_at|timestamp|
ROWS:1

=== package_itinerary ===
id|int(11)|
package_id|int(11)|
day_number|int(11)|
title|varchar(500)|
description|longtext|
hotel_name|varchar(255)|
city|varchar(100)|
meals|varchar(100)|
hotel_star|int(11)|
room_type|varchar(255)|
meals_breakfast|tinyint(4)|
meals_lunch|tinyint(4)|
meals_dinner|tinyint(4)|
ROWS:4

=== package_hotels ===
id|int(11)|PRI
package_id|int(11)|MUL
hotel_id|int(11)|MUL
room_type|varchar(255)|
day_from|int(11)|
day_to|int(11)|
meal_plan|varchar(50)|
city|varchar(100)|
display_order|int(11)|
ROWS:3

=== hotels ===
id|int(11)|PRI
name|varchar(255)|MUL
slug|varchar(255)|
city|varchar(100)|
destination|varchar(100)|
star_rating|int(11)|
address|text|
description|text|
highlights|text|
negatives|text|
created_at|timestamp|
room_info|text|
ROWS:2

=== package_transfers ===
id|int(11)|PRI
package_id|int(11)|MUL
transfer_type|varchar(100)|
vehicle_name|varchar(255)|
route_from|varchar(100)|
route_to|varchar(100)|
day_number|int(11)|
is_premium|tinyint(4)|
notes|text|
display_order|int(11)|
ROWS:11

=== package_activities ===
id|int(11)|PRI
package_id|int(11)|MUL
activity_id|int(11)|MUL
day_number|int(11)|
is_included|tinyint(4)|
notes|varchar(500)|
display_order|int(11)|
ROWS:3

=== package_inclusions ===
NOT FOUND

=== inclusions_exclusions ===
NOT FOUND

TARGET: id=1 slug=andaman-bliss-getaway-port-blair-havelock title=Andaman Bliss Getaway – Port Blair & Havelock

HOTELS SAMPLE:
{"id":"1","name":"Hotel Darwin City","city":"Port Blair","star_rating":"3"}
{"id":"2","name":"Hotel Golden Pebble","city":"Havelock-Island","star_rating":"3"}