-- Data for Name: property_policy_templates; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.property_policy_templates (id, property_id, policy_template_id, policy_type, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: property_pricing_rules; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.property_pricing_rules (id, property_id, rule_type, label, start_date, end_date, days_of_week, price_per_night, min_nights, max_nights, advance_booking_min_days, advance_booking_max_days, allow_same_day, priority, created_at, updated_at) FROM stdin;
4	79	seasonal	seasonal	2026-01-01	2026-02-28	\N	9500.00	\N	\N	\N	\N	t	1	2025-12-28 23:58:59.045289+03	2025-12-28 23:58:59.045289+03
\.


--
-- Data for Name: property_rating_stats; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.property_rating_stats (property_id, avg_rating, review_count, updated_at) FROM stdin;
128	5.00	1	2026-01-03 14:15:12.837506+03
\.


--
-- Data for Name: property_room_types; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.property_room_types (id, property_id, name, description, capacity, bed_type, inventory, base_price_per_night, weekend_price_per_night, extra_guest_charge, currency, is_active, sort_order, created_at, updated_at, image_url) FROM stdin;
1	128	Garden Deluxe Room	King bed with garden view and private sit-out.	2	King	4	9500.00	11000.00	1200.00	INR	t	1	2026-01-20 15:03:27.955334+03	2026-01-20 22:38:15.1833+03	https://images.unsplash.com/photo-1505691938895-1758d7feb511?auto=format&fit=crop&w=1200&q=80
2	128	Family Suite	Two-bedroom suite with lounge and kitchenette.	4	Queen + Twin	2	14500.00	17000.00	1500.00	INR	t	2	2026-01-20 15:03:27.98866+03	2026-01-20 22:38:15.184248+03	https://images.unsplash.com/photo-1505691723518-36a5ac3be353?auto=format&fit=crop&w=1200&q=80
3	128	Pool Villa	Private plunge pool and premium amenities.	3	King	1	18500.00	21000.00	1800.00	INR	t	3	2026-01-20 15:03:27.99781+03	2026-01-20 22:38:15.187744+03	https://images.unsplash.com/photo-1493809842364-78817add7ffb?auto=format&fit=crop&w=1200&q=80
\.


--
-- Data for Name: property_services; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.property_services (id, property_id, service_id, default_selected, meta_json, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: property_spaces; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.property_spaces (id, property_id, title, type, description, capacity, beds_json, images_json, sort_order, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: property_types; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.property_types (id, category_id, name, slug, description, is_active, sort_order, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: rate_plans; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.rate_plans (id, property_id, name, currency, base_nightly_rate, weekend_rate, weekend_days, min_nights_default, max_nights_default, extra_guest_fee_per_night, cleaning_fee, service_fee, tax_percent, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: review_events; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.review_events (id, review_id, actor_type, actor_id, event_type, metadata, created_at) FROM stdin;
1	8cf18d56-7f87-4911-8a71-631a103e81a7	guest	4	created	{"seeded": true, "booking_code": "HV-TRANSPARENT-001"}	2026-01-03 14:15:12.814669+03
\.


--
-- Data for Name: review_media; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.review_media (id, review_id, media_url, type) FROM stdin;
\.


--
-- Data for Name: reviews; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.reviews (review_id, user_id, rating, comment, created_at, updated_at, property_id, booking_id, host_id, guest_id, rating_overall, rating_cleanliness, rating_accuracy, rating_checkin, rating_communication, rating_location, rating_value, title, private_note_to_host, status, host_response, host_responded_at, admin_note) FROM stdin;
8cf18d56-7f87-4911-8a71-631a103e81a7	\N	5	Great stay, would recommend.	2026-01-03 14:15:12.795854+03	2026-01-03 14:15:12.795854+03	128	14	310	4	5	5	5	5	5	5	5	Seed review	\N	published	\N	\N	\N
\.


--
-- Data for Name: routes; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.routes (id, "fromLocationId", "toLocationId", "distanceKm", "durationMins", "isActive", "createdAt", "updatedAt") FROM stdin;
05e6564b-ee88-4fe2-a109-cc89736b0332	e69ae0e3-74d7-445c-a0ce-5f9f0d441a3e	234cda87-2417-4840-81cd-5716cfb59955	233.00	240	t	2026-01-30 16:32:13.678	2026-02-01 18:52:17.667
283a5dad-627c-4aeb-a987-02f7fcfa4370	234cda87-2417-4840-81cd-5716cfb59955	e69ae0e3-74d7-445c-a0ce-5f9f0d441a3e	233.00	240	t	2026-01-30 16:32:13.688	2026-02-01 18:52:17.67
50925fc1-d713-4b4d-8558-7ac327e60a6e	e69ae0e3-74d7-445c-a0ce-5f9f0d441a3e	675947cc-1b7c-4a07-9447-9f70ce92e6c7	280.00	300	t	2026-01-30 16:32:13.69	2026-02-01 18:52:17.672
52123a2c-8c6a-400e-8b43-fe70055c8986	675947cc-1b7c-4a07-9447-9f70ce92e6c7	e69ae0e3-74d7-445c-a0ce-5f9f0d441a3e	280.00	300	t	2026-01-30 16:32:13.692	2026-02-01 18:52:17.673
c61edd17-64ee-4631-ba75-2c19aedd6e71	e69ae0e3-74d7-445c-a0ce-5f9f0d441a3e	f8cd5786-35a4-4d9a-941e-b5ed7c8042d2	250.00	270	t	2026-01-30 16:32:13.694	2026-02-01 18:52:17.674
76ff28a3-0e9d-4407-b3d2-a731e18977d5	f8cd5786-35a4-4d9a-941e-b5ed7c8042d2	e69ae0e3-74d7-445c-a0ce-5f9f0d441a3e	250.00	270	t	2026-01-30 16:32:13.697	2026-02-01 18:52:17.676
3aa7755a-eda7-4948-aa62-5e25297fa2df	e69ae0e3-74d7-445c-a0ce-5f9f0d441a3e	b967211f-b985-41ae-a1a6-505f268b1c19	450.00	420	t	2026-01-30 16:32:13.699	2026-02-01 18:52:17.678
f8258297-3fed-47a8-91dc-803be9863f47	b967211f-b985-41ae-a1a6-505f268b1c19	e69ae0e3-74d7-445c-a0ce-5f9f0d441a3e	450.00	420	t	2026-01-30 16:32:13.701	2026-02-01 18:52:17.68
367224f2-2c3e-4d42-a819-3311b0c03e41	b83e98ac-6aae-493c-b7ad-4f95ad917e01	041ecc2c-f671-4197-a094-f8abd3206f6d	150.00	180	t	2026-01-30 16:32:13.702	2026-02-01 18:52:17.682
5ffe2659-88bf-487e-b3b1-2f6c74229d0f	041ecc2c-f671-4197-a094-f8abd3206f6d	b83e98ac-6aae-493c-b7ad-4f95ad917e01	150.00	180	t	2026-01-30 16:32:13.704	2026-02-01 18:52:17.683
050ec7a7-d1a0-4e52-bdb9-f2d1f2672734	b83e98ac-6aae-493c-b7ad-4f95ad917e01	83ce1bb5-1a37-492e-8e48-c2e380ddf8f4	590.00	600	t	2026-01-30 16:32:13.706	2026-02-01 18:52:17.685
a488ed25-c356-4320-85f6-0b9f505c8449	83ce1bb5-1a37-492e-8e48-c2e380ddf8f4	b83e98ac-6aae-493c-b7ad-4f95ad917e01	590.00	600	t	2026-01-30 16:32:13.708	2026-02-01 18:52:17.686
\.


--
-- Data for Name: seasonal_pricing; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.seasonal_pricing (id, property_id, start_date, end_date, price, created_at) FROM stdin;
\.


--
-- Data for Name: seasonal_pricing_rules; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.seasonal_pricing_rules (id, rule_set_id, label_id, scope, property_id, host_id, property_type, start_date, end_date, days_of_week, price_mode, value, min_nights, is_active, priority, created_at, updated_at, name, price_type, price_value) FROM stdin;
\.


--
-- Data for Name: seasonal_rates; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.seasonal_rates (id, property_id, rate_plan_id, season_name, start_date, end_date, nightly_rate_override, min_nights_override, priority, created_at) FROM stdin;
\.


--
-- Data for Name: seat_configs; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.seat_configs (id, name, "seatCapacity", "luggageCapacity", "layoutJson", "isActive", "createdAt", "updatedAt") FROM stdin;
a9f8de2e-a70d-4e99-8841-c4946af239a7	4 Seater	4	2	\N	t	2026-01-30 16:32:13.465	2026-01-30 16:32:13.465
e0d0dcfe-6d80-43e6-8ea4-224085b4b4bb	5 Seater	5	3	\N	t	2026-01-30 16:32:13.469	2026-01-30 16:32:13.469
8c84ac34-cbb1-44b6-b934-7f76bab8b680	6 Seater	6	3	\N	t	2026-01-30 16:32:13.472	2026-01-30 16:32:13.472
6308297a-5560-4f45-ab71-acd69f9c22c6	7 Seater	7	4	\N	t	2026-01-30 16:32:13.474	2026-01-30 16:32:13.474
7141228b-a0c7-46d2-a78b-eee8e11af416	8 Seater	8	4	\N	t	2026-01-30 16:32:13.477	2026-01-30 16:32:13.477
747259b8-5100-4b50-8f22-62c15e1a12cb	9 Seater	9	5	\N	t	2026-01-30 16:32:13.48	2026-01-30 16:32:13.48
81641fd5-2f1a-446f-aa61-48f3651b3148	10 Seater	10	5	\N	t	2026-01-30 16:32:13.482	2026-01-30 16:32:13.482
2ad670c2-d17e-4c5d-a004-af12a5c79235	11 Seater	11	6	\N	t	2026-01-30 16:32:13.485	2026-01-30 16:32:13.485
eb03bf32-c8fb-4b94-9ba2-e382cbcc547b	12 Seater	12	6	\N	t	2026-01-30 16:32:13.487	2026-01-30 16:32:13.487
df6d0351-b815-49a8-bfc5-b9cd7348734e	13 Seater	13	7	\N	t	2026-01-30 16:32:13.489	2026-01-30 16:32:13.489
2116c06f-8d09-41c1-9e82-17fb080bc72b	14 Seater	14	7	\N	t	2026-01-30 16:32:13.492	2026-01-30 16:32:13.492
32854476-d572-43a3-bc4e-0fdd64d8c4ba	15 Seater	15	8	\N	t	2026-01-30 16:32:13.494	2026-01-30 16:32:13.494
174a3ff3-c5c1-4239-a062-1a45b9e4eae7	16 Seater	16	8	\N	t	2026-01-30 16:32:13.496	2026-01-30 16:32:13.496
056ac388-60ff-4edb-94f0-8db7368201f9	17 Seater	17	9	\N	t	2026-01-30 16:32:13.498	2026-01-30 16:32:13.498
21362044-5153-405b-a0b1-dd5a27dfc441	18 Seater	18	9	\N	t	2026-01-30 16:32:13.5	2026-01-30 16:32:13.5
762554e6-c5eb-490b-80d8-d016954f2e1c	19 Seater	19	10	\N	t	2026-01-30 16:32:13.502	2026-01-30 16:32:13.502
fb46f0a1-001f-421b-a155-369b5203489c	20 Seater	20	10	\N	t	2026-01-30 16:32:13.503	2026-01-30 16:32:13.503
93a64be0-30d6-4712-b846-27029f7979ba	21 Seater	21	11	\N	t	2026-01-30 16:32:13.505	2026-01-30 16:32:13.505
5a2e4258-7f77-42d1-a769-cf8a338c9b65	22 Seater	22	11	\N	t	2026-01-30 16:32:13.507	2026-01-30 16:32:13.507
631de394-cf91-4aca-ad3e-3821673af6d7	23 Seater	23	12	\N	t	2026-01-30 16:32:13.509	2026-01-30 16:32:13.509
260e79c0-0a06-4aad-a12d-1570bf70e99b	24 Seater	24	12	\N	t	2026-01-30 16:32:13.511	2026-01-30 16:32:13.511
2f9e0940-4f19-4f09-8c33-c6bbb6eee352	25 Seater	25	13	\N	t	2026-01-30 16:32:13.513	2026-01-30 16:32:13.513
2324c37b-b8d6-4b8b-b15a-75afe615ffec	26 Seater	26	13	\N	t	2026-01-30 16:32:13.514	2026-01-30 16:32:13.514
f36b765c-591e-4ce3-ada5-2b4b6efa5433	27 Seater	27	14	\N	t	2026-01-30 16:32:13.516	2026-01-30 16:32:13.516
4e87ecd1-38eb-4593-860c-ede34e9cbd11	28 Seater	28	14	\N	t	2026-01-30 16:32:13.518	2026-01-30 16:32:13.518
0b477f65-2329-4826-901b-c1a0d83c8427	29 Seater	29	15	\N	t	2026-01-30 16:32:13.519	2026-01-30 16:32:13.519
16dc271e-7816-4340-8bb6-fbe66f725b87	30 Seater	30	15	\N	t	2026-01-30 16:32:13.521	2026-01-30 16:32:13.521
f3e27d12-5229-42c9-84fc-7377b40ed490	31 Seater	31	16	\N	t	2026-01-30 16:32:13.523	2026-01-30 16:32:13.523
43014a76-21e9-4da7-87e6-c75cc8001701	32 Seater	32	16	\N	t	2026-01-30 16:32:13.525	2026-01-30 16:32:13.525
bf3743bf-ce1e-4bb2-a396-94be9a6dab40	33 Seater	33	17	\N	t	2026-01-30 16:32:13.526	2026-01-30 16:32:13.526
e0d4cd0e-63b3-49d0-ae75-03d75006a2fa	34 Seater	34	17	\N	t	2026-01-30 16:32:13.528	2026-01-30 16:32:13.528
a4aea7ae-d795-4bdb-aead-be5fae147d2c	35 Seater	35	18	\N	t	2026-01-30 16:32:13.53	2026-01-30 16:32:13.53
f7d4fddc-d2f7-48b0-bf44-04141d9f4551	36 Seater	36	18	\N	t	2026-01-30 16:32:13.532	2026-01-30 16:32:13.532
0e3b8c54-732e-406e-b857-db6999385d46	37 Seater	37	19	\N	t	2026-01-30 16:32:13.533	2026-01-30 16:32:13.533
7b2b9338-ec69-40a8-8c8e-57715f83711e	38 Seater	38	19	\N	t	2026-01-30 16:32:13.535	2026-01-30 16:32:13.535
4554be7e-e266-480b-9541-78d1ae1d80aa	39 Seater	39	20	\N	t	2026-01-30 16:32:13.537	2026-01-30 16:32:13.537
f0c135b0-311b-4be1-ac20-5b7658d0d3a9	40 Seater	40	20	\N	t	2026-01-30 16:32:13.539	2026-01-30 16:32:13.539
23f999b0-5410-41d0-9fa4-93bf013538db	41 Seater	41	21	\N	t	2026-01-30 16:32:13.541	2026-01-30 16:32:13.541
6072b705-c87d-4565-b967-39ca731e3ca4	42 Seater	42	21	\N	t	2026-01-30 16:32:13.542	2026-01-30 16:32:13.542
2c58ec25-1c21-4196-ad41-89147c450abc	43 Seater	43	22	\N	t	2026-01-30 16:32:13.544	2026-01-30 16:32:13.544
68d1b86d-8025-4a2e-849c-f35beaeb5b2b	44 Seater	44	22	\N	t	2026-01-30 16:32:13.546	2026-01-30 16:32:13.546
15975698-8433-4241-a0e9-18c398474b2b	45 Seater	45	23	\N	t	2026-01-30 16:32:13.548	2026-01-30 16:32:13.548
9263de85-1c63-4be8-ae97-880c17f46609	46 Seater	46	23	\N	t	2026-01-30 16:32:13.549	2026-01-30 16:32:13.549
d2f4db0d-0a0d-4009-bd09-a019e3d9303c	47 Seater	47	24	\N	t	2026-01-30 16:32:13.551	2026-01-30 16:32:13.551
16bc3d86-ad1c-4748-a90f-1e9f99937466	48 Seater	48	24	\N	t	2026-01-30 16:32:13.553	2026-01-30 16:32:13.553
0de0c6f0-efa1-4ca7-b4b2-63d179767584	49 Seater	49	25	\N	t	2026-01-30 16:32:13.555	2026-01-30 16:32:13.555
bee74301-86da-48e2-a3af-beef2869480e	50 Seater	50	25	\N	t	2026-01-30 16:32:13.556	2026-01-30 16:32:13.556
b7ff4431-914c-46d7-a5d5-8a197c52499b	51 Seater	51	26	\N	t	2026-01-30 16:32:13.558	2026-01-30 16:32:13.558
e43f27c1-4d58-4fe1-b2b0-fcef42efe048	52 Seater	52	26	\N	t	2026-01-30 16:32:13.56	2026-01-30 16:32:13.56
\.


--
-- Data for Name: services; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.services (id, name, description, charge_type, pricing_model, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: special_offer_rules; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.special_offer_rules (id, rule_set_id, label_id, scope, property_id, host_id, property_type, start_date, end_date, discount_type, discount_value, min_nights, max_uses_total, max_uses_per_guest, stack_rule, is_active, priority, created_at, updated_at, title, description, offer_type, booking_window_days, stay_start_date, stay_end_date) FROM stdin;
\.


--
-- Data for Name: special_offers; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.special_offers (id, title, description, start_date, end_date, discount_amount, active, created_at) FROM stdin;
\.


--
-- Data for Name: states; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.states (id, country_id, name, code, created_at, updated_at) FROM stdin;
3	2	California	CA	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
4	2	New York	NY	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
5	3	England	ENG	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
6	4	Ontario	ON	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
7	5	New South Wales	NSW	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
8	6	Berlin	BE	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
9	7	Île-de-France	IDF	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
10	8	Lazio	LAZ	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
11	9	Catalonia	CAT	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
12	10	São Paulo	SP	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
13	11	Ciudad de México	CMX	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
14	12	Tokyo	13	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
15	13	Beijing	BJ	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
16	14	Singapore	SG	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
17	15	Dubai	DU	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
18	16	Western Cape	WC	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
19	17	Nairobi County	NRB	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
20	18	Jakarta	JK	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
21	19	Bangkok	BKK	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
22	20	Istanbul	IST	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
23	1	Andaman and Nicobar Islands	AN	2025-12-30 21:48:14.31633+03	2025-12-30 21:48:14.31633+03
25	1	Andhra Pradesh	AP	2025-12-30 21:48:16.819193+03	2025-12-30 21:48:16.819193+03
26	1	Arunachal Pradesh	AR	2025-12-30 21:48:16.960274+03	2025-12-30 21:48:16.960274+03
27	1	Assam	AS	2025-12-30 21:48:16.980778+03	2025-12-30 21:48:16.980778+03
28	1	Bihar	BR	2025-12-30 21:48:17.045476+03	2025-12-30 21:48:17.045476+03
29	1	Chandigarh	CH	2025-12-30 21:48:17.069357+03	2025-12-30 21:48:17.069357+03
30	1	Chhattisgarh	CT	2025-12-30 21:48:17.078792+03	2025-12-30 21:48:17.078792+03
31	1	Dadra and Nagar Haveli and Daman and Diu	DH	2025-12-30 21:48:17.097603+03	2025-12-30 21:48:17.097603+03
32	1	Delhi	DL	2025-12-30 21:48:17.109261+03	2025-12-30 21:48:17.109261+03
2	1	Goa	GA	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
34	1	Gujarat	GJ	2025-12-30 21:48:17.142397+03	2025-12-30 21:48:17.142397+03
35	1	Haryana	HR	2025-12-30 21:48:17.169731+03	2025-12-30 21:48:17.169731+03
36	1	Himachal Pradesh	HP	2025-12-30 21:48:17.187837+03	2025-12-30 21:48:17.187837+03
37	1	Jammu and Kashmir	JK	2025-12-30 21:48:17.202462+03	2025-12-30 21:48:17.202462+03
38	1	Jharkhand	JH	2025-12-30 21:48:17.217276+03	2025-12-30 21:48:17.217276+03
39	1	Karnataka	KA	2025-12-30 21:48:17.236855+03	2025-12-30 21:48:17.236855+03
40	1	Kerala	KL	2025-12-30 21:48:17.265485+03	2025-12-30 21:48:17.265485+03
41	1	Ladakh	LA	2025-12-30 21:48:17.292683+03	2025-12-30 21:48:17.292683+03
42	1	Lakshadweep	LD	2025-12-30 21:48:17.313409+03	2025-12-30 21:48:17.313409+03
43	1	Madhya Pradesh	MP	2025-12-30 21:48:17.328724+03	2025-12-30 21:48:17.328724+03
1	1	Maharashtra	MH	2025-12-29 05:51:17.946219+03	2025-12-29 05:51:17.946219+03
45	1	Manipur	MN	2025-12-30 21:48:17.69667+03	2025-12-30 21:48:17.69667+03
46	1	Meghalaya	ML	2025-12-30 21:48:17.784291+03	2025-12-30 21:48:17.784291+03
47	1	Mizoram	MZ	2025-12-30 21:48:17.800081+03	2025-12-30 21:48:17.800081+03
48	1	Nagaland	NL	2025-12-30 21:48:17.815059+03	2025-12-30 21:48:17.815059+03
49	1	Odisha	OR	2025-12-30 21:48:17.830716+03	2025-12-30 21:48:17.830716+03
50	1	Puducherry	PY	2025-12-30 21:48:17.848799+03	2025-12-30 21:48:17.848799+03
51	1	Punjab	PB	2025-12-30 21:48:17.860889+03	2025-12-30 21:48:17.860889+03
52	1	Rajasthan	RJ	2025-12-30 21:48:17.880873+03	2025-12-30 21:48:17.880873+03
53	1	Sikkim	SK	2025-12-30 21:48:17.897597+03	2025-12-30 21:48:17.897597+03
54	1	Tamil Nadu	TN	2025-12-30 21:48:17.906778+03	2025-12-30 21:48:17.906778+03
55	1	Telangana	TG	2025-12-30 21:48:17.935756+03	2025-12-30 21:48:17.935756+03
56	1	Tripura	TR	2025-12-30 21:48:17.954988+03	2025-12-30 21:48:17.954988+03
57	1	Uttar Pradesh	UP	2025-12-30 21:48:17.968567+03	2025-12-30 21:48:17.968567+03
58	1	Uttarakhand	UK	2025-12-30 21:48:18.019011+03	2025-12-30 21:48:18.019011+03
59	1	West Bengal	WB	2025-12-30 21:48:18.031968+03	2025-12-30 21:48:18.031968+03
\.


--
-- Data for Name: static_pages; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.static_pages (id, title, slug, body, status, created_at, updated_at) FROM stdin;
1	Terms & Conditions	terms	Sure — below is a **clean, professional Terms & Conditions template** for **HomeVilas**.\nIt’s written in clear language and suitable for a **home rental / vacation villa / homestay / property booking business**. You can customize names, locations, and policies as needed.\n\n---\n\n# **Terms & Conditions**\n\n**Last Updated:** [Insert Date]\n\nWelcome to **HomeVilas**. By accessing our website, booking a property, or using our services, you agree to comply with and be bound by the following Terms & Conditions. Please read them carefully.\n\n---\n\n## **1. About HomeVilas**\n\nHomeVilas provides short-term and long-term accommodation services, including villas, vacation homes, and residential properties, either directly or through partner property owners.\n\n---\n\n## **2. Eligibility**\n\n* You must be at least **18 years old** to make a booking.\n* The person making the booking is responsible for all guests staying at the property.\n\n---\n\n## **3. Bookings & Payments**\n\n* All bookings are subject to availability and confirmation.\n* Prices are displayed in [currency] and may include applicable taxes unless stated otherwise.\n* Full or partial payment must be made as per the booking policy to confirm a reservation.\n* HomeVilas reserves the right to cancel bookings due to incorrect pricing, availability issues, or payment failure.\n\n---\n\n## **4. Check-in & Check-out**\n\n* **Check-in:** [e.g., 2:00 PM onwards]\n* **Check-out:** [e.g., 11:00 AM]\n* Early check-in or late check-out is subject to availability and may incur additional charges.\n\n---\n\n## **5. Cancellation & Refund Policy**\n\n* Cancellation policies vary by property and will be clearly mentioned at the time of booking.\n* Refunds (if applicable) will be processed within [X] business days.\n* No-shows may result in **no refund**.\n\n---\n\n## **6. Use of Property**\n\nGuests agree to:\n\n* Use the property for **residential purposes only**\n* Maintain cleanliness and hygiene\n* Respect neighbors and local community rules\n* Avoid illegal, disruptive, or commercial activities\n\nThe following are strictly prohibited:\n\n* Parties or events (unless explicitly permitted)\n* Smoking inside the property (if designated as non-smoking)\n* Pets (unless allowed in the property listing)\n\n---\n\n## **7. Damage & Security Deposit**\n\n* Guests are responsible for any damage caused during their stay.\n* A **security deposit** (if applicable) may be collected and refunded after inspection.\n* Repair or replacement costs will be deducted if damages are found.\n\n---\n\n## **8. House Rules**\n\nEach property may have specific house rules. Guests must follow all rules provided during booking or displayed at the property. Failure to comply may result in immediate eviction without refund.\n\n---\n\n## **9. Liability Disclaimer**\n\n* HomeVilas is not responsible for personal injuries, loss of belongings, or accidents during the stay.\n* Guests stay at the property at their own risk.\n* HomeVilas is not liable for service interruptions due to events beyond control (natural disasters, power outages, government restrictions, etc.).\n\n---\n\n## **10. Third-Party Services**\n\nHomeVilas may feature third-party services (transport, food, activities). We are not responsible for their actions, services, or availability.\n\n---\n\n## **11. Intellectual Property**\n\nAll content on the HomeVilas website, including logos, text, images, and design, is the property of HomeVilas and may not be copied or used without written permission.\n\n---\n\n## **12. Privacy**\n\nYour personal information is handled in accordance with our **Privacy Policy**. By using our services, you consent to the collection and use of information as described therein.\n\n---\n\n## **13. Modifications**\n\nHomeVilas reserves the right to update or modify these Terms & Conditions at any time without prior notice. Continued use of our services constitutes acceptance of the updated terms.\n\n---\n\n## **14. Governing Law**\n\nThese Terms & Conditions shall be governed by and interpreted in accordance with the laws of **[Country/State]**. Any disputes shall be subject to the jurisdiction of **[City/Courts]**.\n\n---\n\n## **15. Contact Information**\n\nFor questions or support, please contact us:\n\n**HomeVilas**\n📧 Email: [your email]\n📞 Phone: [your number]\n🌐 Website: [your website]\n	published	2025-12-16 21:46:15.930511+03	2025-12-16 21:46:15.930511+03
2	Privacy Policy	privacy	Sure — below is a **clean, professional Terms & Conditions template** for **HomeVilas**.\nIt’s written in clear language and suitable for a **home rental / vacation villa / homestay / property booking business**. You can customize names, locations, and policies as needed.\n\n---\n\n# **Terms & Conditions**\n\n**Last Updated:** [Insert Date]\n\nWelcome to **HomeVilas**. By accessing our website, booking a property, or using our services, you agree to comply with and be bound by the following Terms & Conditions. Please read them carefully.\n\n---\n\n## **1. About HomeVilas**\n\nHomeVilas provides short-term and long-term accommodation services, including villas, vacation homes, and residential properties, either directly or through partner property owners.\n\n---\n\n## **2. Eligibility**\n\n* You must be at least **18 years old** to make a booking.\n* The person making the booking is responsible for all guests staying at the property.\n\n---\n\n## **3. Bookings & Payments**\n\n* All bookings are subject to availability and confirmation.\n* Prices are displayed in [currency] and may include applicable taxes unless stated otherwise.\n* Full or partial payment must be made as per the booking policy to confirm a reservation.\n* HomeVilas reserves the right to cancel bookings due to incorrect pricing, availability issues, or payment failure.\n\n---\n\n## **4. Check-in & Check-out**\n\n* **Check-in:** [e.g., 2:00 PM onwards]\n* **Check-out:** [e.g., 11:00 AM]\n* Early check-in or late check-out is subject to availability and may incur additional charges.\n\n---\n\n## **5. Cancellation & Refund Policy**\n\n* Cancellation policies vary by property and will be clearly mentioned at the time of booking.\n* Refunds (if applicable) will be processed within [X] business days.\n* No-shows may result in **no refund**.\n\n---\n\n## **6. Use of Property**\n\nGuests agree to:\n\n* Use the property for **residential purposes only**\n* Maintain cleanliness and hygiene\n* Respect neighbors and local community rules\n* Avoid illegal, disruptive, or commercial activities\n\nThe following are strictly prohibited:\n\n* Parties or events (unless explicitly permitted)\n* Smoking inside the property (if designated as non-smoking)\n* Pets (unless allowed in the property listing)\n\n---\n\n## **7. Damage & Security Deposit**\n\n* Guests are responsible for any damage caused during their stay.\n* A **security deposit** (if applicable) may be collected and refunded after inspection.\n* Repair or replacement costs will be deducted if damages are found.\n\n---\n\n## **8. House Rules**\n\nEach property may have specific house rules. Guests must follow all rules provided during booking or displayed at the property. Failure to comply may result in immediate eviction without refund.\n\n---\n\n## **9. Liability Disclaimer**\n\n* HomeVilas is not responsible for personal injuries, loss of belongings, or accidents during the stay.\n* Guests stay at the property at their own risk.\n* HomeVilas is not liable for service interruptions due to events beyond control (natural disasters, power outages, government restrictions, etc.).\n\n---\n\n## **10. Third-Party Services**\n\nHomeVilas may feature third-party services (transport, food, activities). We are not responsible for their actions, services, or availability.\n\n---\n\n## **11. Intellectual Property**\n\nAll content on the HomeVilas website, including logos, text, images, and design, is the property of HomeVilas and may not be copied or used without written permission.\n\n---\n\n## **12. Privacy**\n\nYour personal information is handled in accordance with our **Privacy Policy**. By using our services, you consent to the collection and use of information as described therein.\n\n---\n\n## **13. Modifications**\n\nHomeVilas reserves the right to update or modify these Terms & Conditions at any time without prior notice. Continued use of our services constitutes acceptance of the updated terms.\n\n---\n\n## **14. Governing Law**\n\nThese Terms & Conditions shall be governed by and interpreted in accordance with the laws of **[Country/State]**. Any disputes shall be subject to the jurisdiction of **[City/Courts]**.\n\n---\n\n## **15. Contact Information**\n\nFor questions or support, please contact us:\n\n**HomeVilas**\n📧 Email: [your email]\n📞 Phone: [your number]\n🌐 Website: [your website]\n\n	published	2025-12-16 21:46:36.911409+03	2025-12-16 21:46:36.911409+03
3	About Us	about	Sure — below is a **clean, professional Terms & Conditions template** for **HomeVilas**.\nIt’s written in clear language and suitable for a **home rental / vacation villa / homestay / property booking business**. You can customize names, locations, and policies as needed.\n\n---\n\n# **Terms & Conditions**\n\n**Last Updated:** [Insert Date]\n\nWelcome to **HomeVilas**. By accessing our website, booking a property, or using our services, you agree to comply with and be bound by the following Terms & Conditions. Please read them carefully.\n\n---\n\n## **1. About HomeVilas**\n\nHomeVilas provides short-term and long-term accommodation services, including villas, vacation homes, and residential properties, either directly or through partner property owners.\n\n---\n\n## **2. Eligibility**\n\n* You must be at least **18 years old** to make a booking.\n* The person making the booking is responsible for all guests staying at the property.\n\n---\n\n## **3. Bookings & Payments**\n\n* All bookings are subject to availability and confirmation.\n* Prices are displayed in [currency] and may include applicable taxes unless stated otherwise.\n* Full or partial payment must be made as per the booking policy to confirm a reservation.\n* HomeVilas reserves the right to cancel bookings due to incorrect pricing, availability issues, or payment failure.\n\n---\n\n## **4. Check-in & Check-out**\n\n* **Check-in:** [e.g., 2:00 PM onwards]\n* **Check-out:** [e.g., 11:00 AM]\n* Early check-in or late check-out is subject to availability and may incur additional charges.\n\n---\n\n## **5. Cancellation & Refund Policy**\n\n* Cancellation policies vary by property and will be clearly mentioned at the time of booking.\n* Refunds (if applicable) will be processed within [X] business days.\n* No-shows may result in **no refund**.\n\n---\n\n## **6. Use of Property**\n\nGuests agree to:\n\n* Use the property for **residential purposes only**\n* Maintain cleanliness and hygiene\n* Respect neighbors and local community rules\n* Avoid illegal, disruptive, or commercial activities\n\nThe following are strictly prohibited:\n\n* Parties or events (unless explicitly permitted)\n* Smoking inside the property (if designated as non-smoking)\n* Pets (unless allowed in the property listing)\n\n---\n\n## **7. Damage & Security Deposit**\n\n* Guests are responsible for any damage caused during their stay.\n* A **security deposit** (if applicable) may be collected and refunded after inspection.\n* Repair or replacement costs will be deducted if damages are found.\n\n---\n\n## **8. House Rules**\n\nEach property may have specific house rules. Guests must follow all rules provided during booking or displayed at the property. Failure to comply may result in immediate eviction without refund.\n\n---\n\n## **9. Liability Disclaimer**\n\n* HomeVilas is not responsible for personal injuries, loss of belongings, or accidents during the stay.\n* Guests stay at the property at their own risk.\n* HomeVilas is not liable for service interruptions due to events beyond control (natural disasters, power outages, government restrictions, etc.).\n\n---\n\n## **10. Third-Party Services**\n\nHomeVilas may feature third-party services (transport, food, activities). We are not responsible for their actions, services, or availability.\n\n---\n\n## **11. Intellectual Property**\n\nAll content on the HomeVilas website, including logos, text, images, and design, is the property of HomeVilas and may not be copied or used without written permission.\n\n---\n\n## **12. Privacy**\n\nYour personal information is handled in accordance with our **Privacy Policy**. By using our services, you consent to the collection and use of information as described therein.\n\n---\n\n## **13. Modifications**\n\nHomeVilas reserves the right to update or modify these Terms & Conditions at any time without prior notice. Continued use of our services constitutes acceptance of the updated terms.\n\n---\n\n## **14. Governing Law**\n\nThese Terms & Conditions shall be governed by and interpreted in accordance with the laws of **[Country/State]**. Any disputes shall be subject to the jurisdiction of **[City/Courts]**.\n\n---\n\n## **15. Contact Information**\n\nFor questions or support, please contact us:\n\n**HomeVilas**\n📧 Email: [your email]\n📞 Phone: [your number]\n🌐 Website: [your website]\n\n	published	2025-12-16 21:47:00.732221+03	2025-12-16 21:47:00.732221+03
4	Contact Us	contact	Contact Us\n\n📍 [City, Country]\n📞 [Phone Number]\n📧 [Email Address]\n\n🕘 Daily: [Business Hours]\n	published	2025-12-16 21:48:55.313145+03	2025-12-16 21:48:55.313145+03
\.


--
-- Data for Name: support_messages; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.support_messages (id, ticket_id, sender_type, sender_id, message, attachment_url, created_at) FROM stdin;
\.


--
-- Data for Name: support_tickets; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.support_tickets (id, customer_id, subject, status, assigned_admin_id, notes, created_at, updated_at, host_id, ticket_number, category, priority, last_message_at, created_by, message, assigned_to) FROM stdin;
1	4	Support test ticket	CLOSED	1	\N	2026-01-09 17:46:34.357185+03	2026-01-09 18:56:37.769728+03	\N	\N	BOOKINGS	LOW	2026-01-09 17:46:34.357185+03	4	Testing guest support create/list/detail/close.	1
2	4	cvdfvd	OPEN	\N	\N	2026-01-29 21:25:17.621498+03	2026-01-29 21:25:17.621498+03	\N	\N	PAYMENTS	LOW	2026-01-29 21:25:17.621498+03	4	sd n ck,dmv.dsm	\N
\.


--
-- Data for Name: tax_rules; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tax_rules (id, property_id, tax_name, tax_type, tax_value, applies_to, created_at) FROM stdin;
\.


--
-- Data for Name: taxes_and_fees_rules; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.taxes_and_fees_rules (id, rule_set_id, label_id, scope, region, property_type, property_id, charge_type, name, calc_type, value, applies_to, is_included_in_price, is_refundable, is_active, priority, created_at, updated_at, host_id, per_night) FROM stdin;
\.


--
-- Data for Name: taxes_fees; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.taxes_fees (id, name, rate, is_percentage, created_at) FROM stdin;
\.


--
-- Data for Name: tour_bookings; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tour_bookings (id, tour_id, host_id, customer_id, booking_date, qty, status, total_amount, platform_fee, host_earnings, currency, created_at, client_id) FROM stdin;
\.


--
-- Data for Name: tours; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tours (id, host_id, title, status, created_at) FROM stdin;
\.


--
-- Data for Name: transactions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.transactions (id, booking_id, method, txn_id, amount, status, created_at) FROM stdin;
\.


--
-- Data for Name: transport_package_media; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.transport_package_media (id, "packageId", url, "altText", "isCover", "sortOrder", "createdAt", "updatedAt") FROM stdin;
e3993119-e4ef-4ed7-bb48-5a8587f82315	7c3cb683-a1b8-4d5c-9902-310d57e42054	https://picsum.photos/seed/delhi-delhi-heritage-trail-cover/1200/800	Delhi Heritage Trail cover	t	1	2026-01-30 16:32:14.399	2026-01-30 16:32:14.399
2ec1d443-986d-493c-918a-e130cda5b1aa	7c3cb683-a1b8-4d5c-9902-310d57e42054	https://picsum.photos/seed/delhi-delhi-heritage-trail-1/1200/800	Delhi Heritage Trail gallery 1	f	2	2026-01-30 16:32:14.399	2026-01-30 16:32:14.399
34b0214e-1a70-49a3-978e-bc0530a6ff54	7c3cb683-a1b8-4d5c-9902-310d57e42054	https://picsum.photos/seed/delhi-delhi-heritage-trail-2/1200/800	Delhi Heritage Trail gallery 2	f	3	2026-01-30 16:32:14.399	2026-01-30 16:32:14.399
5e53262f-f502-4dd0-8ede-9f42440ef5e5	65c9bc36-430b-455d-9d08-218c4d4ee536	https://picsum.photos/seed/delhi-delhi-agra-express-cover/1200/800	Delhi + Agra Express cover	t	1	2026-01-30 16:32:14.404	2026-01-30 16:32:14.404
8ec88283-e971-49fa-a69a-3b3fe09ce3c5	65c9bc36-430b-455d-9d08-218c4d4ee536	https://picsum.photos/seed/delhi-delhi-agra-express-1/1200/800	Delhi + Agra Express gallery 1	f	2	2026-01-30 16:32:14.404	2026-01-30 16:32:14.404
f501ac5d-bb4f-484f-865a-da78caf25973	65c9bc36-430b-455d-9d08-218c4d4ee536	https://picsum.photos/seed/delhi-delhi-agra-express-2/1200/800	Delhi + Agra Express gallery 2	f	3	2026-01-30 16:32:14.404	2026-01-30 16:32:14.404
cc524d6a-d9d1-4fa6-96d8-d9b768667e20	74fbd78c-ff66-4377-923e-1e5e879c2404	https://picsum.photos/seed/delhi-golden-triangle-express-cover/1200/800	Golden Triangle Express cover	t	1	2026-01-30 16:32:14.407	2026-01-30 16:32:14.407
9d59fd8f-eecc-4c8c-85bc-47a71d7d9238	74fbd78c-ff66-4377-923e-1e5e879c2404	https://picsum.photos/seed/delhi-golden-triangle-express-1/1200/800	Golden Triangle Express gallery 1	f	2	2026-01-30 16:32:14.407	2026-01-30 16:32:14.407
47a971c2-ebd0-4adf-a7cc-e6dfddcf6980	74fbd78c-ff66-4377-923e-1e5e879c2404	https://picsum.photos/seed/delhi-golden-triangle-express-2/1200/800	Golden Triangle Express gallery 2	f	3	2026-01-30 16:32:14.407	2026-01-30 16:32:14.407
05b14b27-63fc-4323-b7df-f893385c2974	97f9fdad-67ce-4279-aa32-0c6b005658ad	https://picsum.photos/seed/mumbai-mumbai-coastal-escape-cover/1200/800	Mumbai Coastal Escape cover	t	1	2026-01-30 16:32:14.409	2026-01-30 16:32:14.409
1d7801cf-8610-441e-9c4a-faa9ec8ff44e	97f9fdad-67ce-4279-aa32-0c6b005658ad	https://picsum.photos/seed/mumbai-mumbai-coastal-escape-1/1200/800	Mumbai Coastal Escape gallery 1	f	2	2026-01-30 16:32:14.409	2026-01-30 16:32:14.409
ac5b8c52-4603-48b8-9734-2dc6f4cbd7ac	97f9fdad-67ce-4279-aa32-0c6b005658ad	https://picsum.photos/seed/mumbai-mumbai-coastal-escape-2/1200/800	Mumbai Coastal Escape gallery 2	f	3	2026-01-30 16:32:14.409	2026-01-30 16:32:14.409
8c2319e0-4d6d-45d7-acf2-8cb88daaea0f	72b3a691-afac-499e-91ff-26918e6ac34a	https://picsum.photos/seed/mumbai-mumbai-pune-retreat-cover/1200/800	Mumbai + Pune Retreat cover	t	1	2026-01-30 16:32:14.411	2026-01-30 16:32:14.411
6d7c6015-1c80-4906-8d49-9edbad641959	72b3a691-afac-499e-91ff-26918e6ac34a	https://picsum.photos/seed/mumbai-mumbai-pune-retreat-1/1200/800	Mumbai + Pune Retreat gallery 1	f	2	2026-01-30 16:32:14.411	2026-01-30 16:32:14.411
dc967994-5560-4ebf-9f80-c8fee5b76f10	72b3a691-afac-499e-91ff-26918e6ac34a	https://picsum.photos/seed/mumbai-mumbai-pune-retreat-2/1200/800	Mumbai + Pune Retreat gallery 2	f	3	2026-01-30 16:32:14.411	2026-01-30 16:32:14.411
e5c036e8-1d0f-4bf5-bf56-5c78233a3aba	b77600bf-59da-4816-97c1-5e8697cdef2a	https://picsum.photos/seed/mumbai-western-ghats-trail-cover/1200/800	Western Ghats Trail cover	t	1	2026-01-30 16:32:14.414	2026-01-30 16:32:14.414
1492721d-d4df-4e11-82d8-916c951db364	b77600bf-59da-4816-97c1-5e8697cdef2a	https://picsum.photos/seed/mumbai-western-ghats-trail-1/1200/800	Western Ghats Trail gallery 1	f	2	2026-01-30 16:32:14.414	2026-01-30 16:32:14.414
524cfef1-fcac-4f32-95a5-5dddb4574276	b77600bf-59da-4816-97c1-5e8697cdef2a	https://picsum.photos/seed/mumbai-western-ghats-trail-2/1200/800	Western Ghats Trail gallery 2	f	3	2026-01-30 16:32:14.414	2026-01-30 16:32:14.414
b9f1c471-cf84-4d2e-8593-8b03bc6c5ba1	4d75e753-1d05-4537-87e1-f26023dbc0f8	https://picsum.photos/seed/goa-goa-beach-hopper-cover/1200/800	Goa Beach Hopper cover	t	1	2026-01-30 16:32:14.416	2026-01-30 16:32:14.416
9915c934-892f-49d7-b1fd-ba2eea951963	4d75e753-1d05-4537-87e1-f26023dbc0f8	https://picsum.photos/seed/goa-goa-beach-hopper-1/1200/800	Goa Beach Hopper gallery 1	f	2	2026-01-30 16:32:14.416	2026-01-30 16:32:14.416
e1b15684-d5fe-4f88-ae3f-30965ff49b9d	4d75e753-1d05-4537-87e1-f26023dbc0f8	https://picsum.photos/seed/goa-goa-beach-hopper-2/1200/800	Goa Beach Hopper gallery 2	f	3	2026-01-30 16:32:14.416	2026-01-30 16:32:14.416
29d3cc3e-94a4-4bf4-b5ed-9dd19c9b5f08	61e94d9a-2824-40d2-bbe5-d0a84e5f11d7	https://picsum.photos/seed/goa-goa-heritage-and-nature-cover/1200/800	Goa Heritage & Nature cover	t	1	2026-01-30 16:32:14.418	2026-01-30 16:32:14.418
c3baf15a-684d-4652-a732-fa8e1071f0a7	61e94d9a-2824-40d2-bbe5-d0a84e5f11d7	https://picsum.photos/seed/goa-goa-heritage-and-nature-1/1200/800	Goa Heritage & Nature gallery 1	f	2	2026-01-30 16:32:14.418	2026-01-30 16:32:14.418
505d198d-34cd-4b94-9709-1391f64ea914	61e94d9a-2824-40d2-bbe5-d0a84e5f11d7	https://picsum.photos/seed/goa-goa-heritage-and-nature-2/1200/800	Goa Heritage & Nature gallery 2	f	3	2026-01-30 16:32:14.418	2026-01-30 16:32:14.418
a7296c08-3882-417f-a3f0-1779f3d9b4c9	93205c3c-5c4e-487f-b5b3-14a7cef59494	https://picsum.photos/seed/goa-goa-adventure-loop-cover/1200/800	Goa Adventure Loop cover	t	1	2026-01-30 16:32:14.421	2026-01-30 16:32:14.421
a8295067-dd4a-426b-971a-45d0f3a50989	93205c3c-5c4e-487f-b5b3-14a7cef59494	https://picsum.photos/seed/goa-goa-adventure-loop-1/1200/800	Goa Adventure Loop gallery 1	f	2	2026-01-30 16:32:14.421	2026-01-30 16:32:14.421
a6536ad2-4e63-46db-8f6e-854b89887e65	93205c3c-5c4e-487f-b5b3-14a7cef59494	https://picsum.photos/seed/goa-goa-adventure-loop-2/1200/800	Goa Adventure Loop gallery 2	f	3	2026-01-30 16:32:14.421	2026-01-30 16:32:14.421
\.


--
-- Data for Name: transport_package_variants; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.transport_package_variants (id, "packageId", "vehicleCategoryId", "seatConfigId", "maxPax", "priceTotal", "kmsIncluded", "extraKmRate", "driverAllowanceIncluded", "tollIncluded", "gstPct", priority, "isActive", "createdAt", "updatedAt") FROM stdin;
fe88c5ac-c390-4ef0-9834-9121874af33b	7c3cb683-a1b8-4d5c-9902-310d57e42054	2fc930a9-cb52-4813-b0a9-5dff78121d1c	a9f8de2e-a70d-4e99-8841-c4946af239a7	4	15000.00	300	20.00	t	f	5.00	3	t	2026-01-30 16:32:14.423	2026-02-01 18:52:18.069
24c03194-21a1-4c5c-b5db-451844dd503f	7c3cb683-a1b8-4d5c-9902-310d57e42054	48c33bc8-491d-4c86-9b00-75f89903d72a	8c84ac34-cbb1-44b6-b934-7f76bab8b680	6	22000.00	300	20.00	t	f	5.00	2	t	2026-01-30 16:32:14.451	2026-02-01 18:52:18.072
2624f0d9-ae75-48f7-8418-3648cc317d5d	7c3cb683-a1b8-4d5c-9902-310d57e42054	04cc25fc-7d90-4f07-aae8-250b6f9946d8	eb03bf32-c8fb-4b94-9ba2-e382cbcc547b	10	32000.00	300	20.00	t	f	5.00	1	t	2026-01-30 16:32:14.454	2026-02-01 18:52:18.075
d1ffc76e-836f-4c3e-8c83-2251a547bf2c	65c9bc36-430b-455d-9d08-218c4d4ee536	2fc930a9-cb52-4813-b0a9-5dff78121d1c	a9f8de2e-a70d-4e99-8841-c4946af239a7	4	15000.00	300	20.00	t	f	5.00	3	t	2026-01-30 16:32:14.457	2026-02-01 18:52:18.077
34b43bb3-faee-4335-9df0-8267feba9eb6	65c9bc36-430b-455d-9d08-218c4d4ee536	48c33bc8-491d-4c86-9b00-75f89903d72a	8c84ac34-cbb1-44b6-b934-7f76bab8b680	6	22000.00	300	20.00	t	f	5.00	2	t	2026-01-30 16:32:14.46	2026-02-01 18:52:18.08
75a794c9-5335-4915-859f-3ba2cebe0a19	65c9bc36-430b-455d-9d08-218c4d4ee536	04cc25fc-7d90-4f07-aae8-250b6f9946d8	eb03bf32-c8fb-4b94-9ba2-e382cbcc547b	10	32000.00	300	20.00	t	f	5.00	1	t	2026-01-30 16:32:14.463	2026-02-01 18:52:18.082
5a62f150-676f-4d6a-a941-dc44d29d5b61	97f9fdad-67ce-4279-aa32-0c6b005658ad	04cc25fc-7d90-4f07-aae8-250b6f9946d8	eb03bf32-c8fb-4b94-9ba2-e382cbcc547b	10	32000.00	300	20.00	t	f	5.00	1	t	2026-01-30 16:32:14.481	2026-02-01 18:52:18.095
a3b4cc56-7468-4fee-a6c5-c46d1e2343f5	72b3a691-afac-499e-91ff-26918e6ac34a	2fc930a9-cb52-4813-b0a9-5dff78121d1c	a9f8de2e-a70d-4e99-8841-c4946af239a7	4	15000.00	300	20.00	t	f	5.00	3	t	2026-01-30 16:32:14.483	2026-02-01 18:52:18.098
bdad9f34-748b-4e4a-8b2f-13cbd169186b	72b3a691-afac-499e-91ff-26918e6ac34a	48c33bc8-491d-4c86-9b00-75f89903d72a	8c84ac34-cbb1-44b6-b934-7f76bab8b680	6	22000.00	300	20.00	t	f	5.00	2	t	2026-01-30 16:32:14.485	2026-02-01 18:52:18.1
e25be1b7-d60e-408b-bda7-065301bdd8c5	72b3a691-afac-499e-91ff-26918e6ac34a	04cc25fc-7d90-4f07-aae8-250b6f9946d8	eb03bf32-c8fb-4b94-9ba2-e382cbcc547b	10	32000.00	300	20.00	t	f	5.00	1	t	2026-01-30 16:32:14.487	2026-02-01 18:52:18.101
2217b8a0-04f9-4461-8b15-05febb7709a0	b77600bf-59da-4816-97c1-5e8697cdef2a	2fc930a9-cb52-4813-b0a9-5dff78121d1c	a9f8de2e-a70d-4e99-8841-c4946af239a7	4	15000.00	300	20.00	t	f	5.00	3	t	2026-01-30 16:32:14.489	2026-02-01 18:52:18.103
b83bc9c4-00a3-4b81-ac03-a7f2c4d4062b	b77600bf-59da-4816-97c1-5e8697cdef2a	48c33bc8-491d-4c86-9b00-75f89903d72a	8c84ac34-cbb1-44b6-b934-7f76bab8b680	6	22000.00	300	20.00	t	f	5.00	2	t	2026-01-30 16:32:14.491	2026-02-01 18:52:18.105
62fed2c0-a516-493d-85d7-6037f02af602	b77600bf-59da-4816-97c1-5e8697cdef2a	04cc25fc-7d90-4f07-aae8-250b6f9946d8	eb03bf32-c8fb-4b94-9ba2-e382cbcc547b	10	32000.00	300	20.00	t	f	5.00	1	t	2026-01-30 16:32:14.493	2026-02-01 18:52:18.107
80426449-f00d-428f-a32b-aa47de0d1ec3	4d75e753-1d05-4537-87e1-f26023dbc0f8	2fc930a9-cb52-4813-b0a9-5dff78121d1c	a9f8de2e-a70d-4e99-8841-c4946af239a7	4	15000.00	300	20.00	t	f	5.00	3	t	2026-01-30 16:32:14.495	2026-02-01 18:52:18.109
c432bbce-aca7-4800-bb8b-b03267d64440	4d75e753-1d05-4537-87e1-f26023dbc0f8	48c33bc8-491d-4c86-9b00-75f89903d72a	8c84ac34-cbb1-44b6-b934-7f76bab8b680	6	22000.00	300	20.00	t	f	5.00	2	t	2026-01-30 16:32:14.497	2026-02-01 18:52:18.111
8729f651-8e2b-40c2-b554-54939cca3665	4d75e753-1d05-4537-87e1-f26023dbc0f8	04cc25fc-7d90-4f07-aae8-250b6f9946d8	eb03bf32-c8fb-4b94-9ba2-e382cbcc547b	10	32000.00	300	20.00	t	f	5.00	1	t	2026-01-30 16:32:14.5	2026-02-01 18:52:18.113
b9692660-8523-4241-b632-ae2acf28923d	61e94d9a-2824-40d2-bbe5-d0a84e5f11d7	2fc930a9-cb52-4813-b0a9-5dff78121d1c	a9f8de2e-a70d-4e99-8841-c4946af239a7	4	15000.00	300	20.00	t	f	5.00	3	t	2026-01-30 16:32:14.503	2026-02-01 18:52:18.115
d524aba3-56f5-4dba-8a0a-ba1a90e4e42c	61e94d9a-2824-40d2-bbe5-d0a84e5f11d7	48c33bc8-491d-4c86-9b00-75f89903d72a	8c84ac34-cbb1-44b6-b934-7f76bab8b680	6	22000.00	300	20.00	t	f	5.00	2	t	2026-01-30 16:32:14.505	2026-02-01 18:52:18.117
f507e484-5cdb-4501-9473-fbd7a5fdc3ed	61e94d9a-2824-40d2-bbe5-d0a84e5f11d7	04cc25fc-7d90-4f07-aae8-250b6f9946d8	eb03bf32-c8fb-4b94-9ba2-e382cbcc547b	10	32000.00	300	20.00	t	f	5.00	1	t	2026-01-30 16:32:14.507	2026-02-01 18:52:18.119
1e788619-96ad-4f6b-8bae-3514f305aedf	93205c3c-5c4e-487f-b5b3-14a7cef59494	2fc930a9-cb52-4813-b0a9-5dff78121d1c	a9f8de2e-a70d-4e99-8841-c4946af239a7	4	15000.00	300	20.00	t	f	5.00	3	t	2026-01-30 16:32:14.509	2026-02-01 18:52:18.121
94894905-32a9-4aa8-84cf-f189ff6d00f0	93205c3c-5c4e-487f-b5b3-14a7cef59494	48c33bc8-491d-4c86-9b00-75f89903d72a	8c84ac34-cbb1-44b6-b934-7f76bab8b680	6	22000.00	300	20.00	t	f	5.00	2	t	2026-01-30 16:32:14.511	2026-02-01 18:52:18.122
3aa063d3-9c62-418e-92a9-4e4ef36b06d0	93205c3c-5c4e-487f-b5b3-14a7cef59494	04cc25fc-7d90-4f07-aae8-250b6f9946d8	eb03bf32-c8fb-4b94-9ba2-e382cbcc547b	10	32000.00	300	20.00	t	f	5.00	1	t	2026-01-30 16:32:14.513	2026-02-01 18:52:18.124
33d4c3f5-1111-4ae5-a15b-3fd0a7986d2e	74fbd78c-ff66-4377-923e-1e5e879c2404	2fc930a9-cb52-4813-b0a9-5dff78121d1c	a9f8de2e-a70d-4e99-8841-c4946af239a7	4	15000.00	300	20.00	t	f	5.00	3	t	2026-01-30 16:32:14.466	2026-02-01 18:52:18.084
a035200d-2203-465e-a1a9-3029eedd9cf9	74fbd78c-ff66-4377-923e-1e5e879c2404	48c33bc8-491d-4c86-9b00-75f89903d72a	8c84ac34-cbb1-44b6-b934-7f76bab8b680	6	22000.00	300	20.00	t	f	5.00	2	t	2026-01-30 16:32:14.468	2026-02-01 18:52:18.086
a294e634-fc51-4cb3-b20d-6778123eeed2	74fbd78c-ff66-4377-923e-1e5e879c2404	04cc25fc-7d90-4f07-aae8-250b6f9946d8	eb03bf32-c8fb-4b94-9ba2-e382cbcc547b	10	32000.00	300	20.00	t	f	5.00	1	t	2026-01-30 16:32:14.475	2026-02-01 18:52:18.088
ed826ae7-7f84-4823-b6a8-f76097b3ba92	97f9fdad-67ce-4279-aa32-0c6b005658ad	2fc930a9-cb52-4813-b0a9-5dff78121d1c	a9f8de2e-a70d-4e99-8841-c4946af239a7	4	15000.00	300	20.00	t	f	5.00	3	t	2026-01-30 16:32:14.477	2026-02-01 18:52:18.09
a48e114a-00d7-4c36-80a6-dfd3ba877a1a	97f9fdad-67ce-4279-aa32-0c6b005658ad	48c33bc8-491d-4c86-9b00-75f89903d72a	8c84ac34-cbb1-44b6-b934-7f76bab8b680	6	22000.00	300	20.00	t	f	5.00	2	t	2026-01-30 16:32:14.479	2026-02-01 18:52:18.093
\.


--
-- Data for Name: transport_packages; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.transport_packages (id, title, slug, "locationId", days, nights, description, highlights, inclusions, exclusions, "itineraryJson", terms, "sortOrder", "isActive", "createdAt", "updatedAt", "durationDays", "coverImageUrl", "galleryJson") FROM stdin;
93205c3c-5c4e-487f-b5b3-14a7cef59494	Goa Adventure Loop	goa-goa-adventure-loop	83ce1bb5-1a37-492e-8e48-c2e380ddf8f4	5	4	Goa Adventure Loop with curated stays and routes.	Comfortable ride, curated stops, verified drivers.	Vehicle, driver allowance, fuel, GST	Tolls, parking, entry tickets	[{"day": 1, "title": "Arrival & city tour", "description": "Pick up and local sightseeing."}, {"day": 2, "title": "Experience highlights", "description": "Top attractions with flexible stops."}]	Package is non-refundable within 24 hours of departure.	1	t	2026-01-30 16:32:14.345	2026-02-01 18:52:18.052	\N	\N	\N
7c3cb683-a1b8-4d5c-9902-310d57e42054	Delhi Heritage Trail	delhi-delhi-heritage-trail	e69ae0e3-74d7-445c-a0ce-5f9f0d441a3e	2	1	Delhi Heritage Trail with curated stays and routes.	Comfortable ride, curated stops, verified drivers.	Vehicle, driver allowance, fuel, GST	Tolls, parking, entry tickets	[{"day": 1, "title": "Arrival & city tour", "description": "Pick up and local sightseeing."}, {"day": 2, "title": "Experience highlights", "description": "Top attractions with flexible stops."}]	Package is non-refundable within 24 hours of departure.	1	t	2026-01-30 16:32:14.303	2026-02-01 18:52:18.029	\N	\N	\N
65c9bc36-430b-455d-9d08-218c4d4ee536	Delhi + Agra Express	delhi-delhi-agra-express	e69ae0e3-74d7-445c-a0ce-5f9f0d441a3e	3	2	Delhi + Agra Express with curated stays and routes.	Comfortable ride, curated stops, verified drivers.	Vehicle, driver allowance, fuel, GST	Tolls, parking, entry tickets	[{"day": 1, "title": "Arrival & city tour", "description": "Pick up and local sightseeing."}, {"day": 2, "title": "Experience highlights", "description": "Top attractions with flexible stops."}]	Package is non-refundable within 24 hours of departure.	1	t	2026-01-30 16:32:14.315	2026-02-01 18:52:18.033	\N	\N	\N
74fbd78c-ff66-4377-923e-1e5e879c2404	Golden Triangle Express	delhi-golden-triangle-express	e69ae0e3-74d7-445c-a0ce-5f9f0d441a3e	4	3	Golden Triangle Express with curated stays and routes.	Comfortable ride, curated stops, verified drivers.	Vehicle, driver allowance, fuel, GST	Tolls, parking, entry tickets	[{"day": 1, "title": "Arrival & city tour", "description": "Pick up and local sightseeing."}, {"day": 2, "title": "Experience highlights", "description": "Top attractions with flexible stops."}]	Package is non-refundable within 24 hours of departure.	1	t	2026-01-30 16:32:14.32	2026-02-01 18:52:18.036	\N	\N	\N
97f9fdad-67ce-4279-aa32-0c6b005658ad	Mumbai Coastal Escape	mumbai-mumbai-coastal-escape	b83e98ac-6aae-493c-b7ad-4f95ad917e01	2	1	Mumbai Coastal Escape with curated stays and routes.	Comfortable ride, curated stops, verified drivers.	Vehicle, driver allowance, fuel, GST	Tolls, parking, entry tickets	[{"day": 1, "title": "Arrival & city tour", "description": "Pick up and local sightseeing."}, {"day": 2, "title": "Experience highlights", "description": "Top attractions with flexible stops."}]	Package is non-refundable within 24 hours of departure.	1	t	2026-01-30 16:32:14.325	2026-02-01 18:52:18.038	\N	\N	\N
72b3a691-afac-499e-91ff-26918e6ac34a	Mumbai + Pune Retreat	mumbai-mumbai-pune-retreat	b83e98ac-6aae-493c-b7ad-4f95ad917e01	3	2	Mumbai + Pune Retreat with curated stays and routes.	Comfortable ride, curated stops, verified drivers.	Vehicle, driver allowance, fuel, GST	Tolls, parking, entry tickets	[{"day": 1, "title": "Arrival & city tour", "description": "Pick up and local sightseeing."}, {"day": 2, "title": "Experience highlights", "description": "Top attractions with flexible stops."}]	Package is non-refundable within 24 hours of departure.	1	t	2026-01-30 16:32:14.33	2026-02-01 18:52:18.041	\N	\N	\N
b77600bf-59da-4816-97c1-5e8697cdef2a	Western Ghats Trail	mumbai-western-ghats-trail	b83e98ac-6aae-493c-b7ad-4f95ad917e01	4	3	Western Ghats Trail with curated stays and routes.	Comfortable ride, curated stops, verified drivers.	Vehicle, driver allowance, fuel, GST	Tolls, parking, entry tickets	[{"day": 1, "title": "Arrival & city tour", "description": "Pick up and local sightseeing."}, {"day": 2, "title": "Experience highlights", "description": "Top attractions with flexible stops."}]	Package is non-refundable within 24 hours of departure.	1	t	2026-01-30 16:32:14.334	2026-02-01 18:52:18.044	\N	\N	\N
4d75e753-1d05-4537-87e1-f26023dbc0f8	Goa Beach Hopper	goa-goa-beach-hopper	83ce1bb5-1a37-492e-8e48-c2e380ddf8f4	3	2	Goa Beach Hopper with curated stays and routes.	Comfortable ride, curated stops, verified drivers.	Vehicle, driver allowance, fuel, GST	Tolls, parking, entry tickets	[{"day": 1, "title": "Arrival & city tour", "description": "Pick up and local sightseeing."}, {"day": 2, "title": "Experience highlights", "description": "Top attractions with flexible stops."}]	Package is non-refundable within 24 hours of departure.	1	t	2026-01-30 16:32:14.337	2026-02-01 18:52:18.047	\N	\N	\N
61e94d9a-2824-40d2-bbe5-d0a84e5f11d7	Goa Heritage & Nature	goa-goa-heritage-and-nature	83ce1bb5-1a37-492e-8e48-c2e380ddf8f4	4	3	Goa Heritage & Nature with curated stays and routes.	Comfortable ride, curated stops, verified drivers.	Vehicle, driver allowance, fuel, GST	Tolls, parking, entry tickets	[{"day": 1, "title": "Arrival & city tour", "description": "Pick up and local sightseeing."}, {"day": 2, "title": "Experience highlights", "description": "Top attractions with flexible stops."}]	Package is non-refundable within 24 hours of departure.	1	t	2026-01-30 16:32:14.341	2026-02-01 18:52:18.05	\N	\N	\N
\.


--
-- Data for Name: travel_custom_tour_requests; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.travel_custom_tour_requests (id, name, email, phone, destination_id, destination_text, start_date, end_date, budget_min, budget_max, travelers, message, status, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: travel_newsletter_subscribers; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.travel_newsletter_subscribers (id, email, source, created_at) FROM stdin;
\.


--
-- Data for Name: travel_package_articles; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.travel_package_articles (id, title, slug, category, read_time, image_url, excerpt, content, is_active, published_at, created_at, updated_at) FROM stdin;
1	7 Coastal Escapes for Slow Travel	coastal-escapes-slow-travel	Destinations	5 min read	https://picsum.photos/seed/homevilas-article-1/900/600	From Goa to the Andamans, explore coastal escapes built for relaxation.	Curated coastal itineraries with boutique stays and private experiences.	t	2026-01-27 16:58:38.68+03	2026-01-27 16:58:38.681113+03	2026-01-27 16:58:38.681113+03
2	Designing the Perfect Honeymoon Itinerary	honeymoon-itinerary-design	Guides	6 min read	https://picsum.photos/seed/homevilas-article-2/900/600	Tips for crafting a honeymoon that blends adventure with rest.	Mix private dining with wellness and curated day trips.	t	2026-01-27 16:58:38.68+03	2026-01-27 16:58:38.681113+03	2026-01-27 16:58:38.681113+03
3	Wellness Travel: What to Expect	wellness-travel-expectations	Wellness	4 min read	https://picsum.photos/seed/homevilas-article-3/900/600	A guide to wellness-focused itineraries and mindful experiences.	Expect wellness consultations, healing cuisine, and calm retreats.	t	2026-01-27 16:58:38.68+03	2026-01-27 16:58:38.681113+03	2026-01-27 16:58:38.681113+03
4	Mountain Escapes for Families	mountain-escapes-families	Family	5 min read	https://picsum.photos/seed/homevilas-article-4/900/600	Family-friendly mountain trips with soft adventure activities.	Bonfire evenings, guided hikes, and cozy stays.	t	2026-01-27 16:58:38.68+03	2026-01-27 16:58:38.681113+03	2026-01-27 16:58:38.681113+03
\.


--
-- Data for Name: travel_package_destinations; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.travel_package_destinations (id, name, slug, image_url, summary, is_active, created_at, updated_at) FROM stdin;
1	Goa	goa	https://picsum.photos/seed/homevilas-goa/900/700	Sun-kissed beaches, heritage quarters, and laid-back coastal luxury.	t	2026-01-27 16:58:38.586677+03	2026-01-27 16:58:38.586677+03
2	Kerala	kerala	https://picsum.photos/seed/homevilas-kerala/900/700	Backwaters, spice trails, and wellness stays in lush landscapes.	t	2026-01-27 16:58:38.586677+03	2026-01-27 16:58:38.586677+03
3	Rajasthan	rajasthan	https://picsum.photos/seed/homevilas-rajasthan/900/700	Palatial forts, desert safaris, and curated cultural journeys.	t	2026-01-27 16:58:38.586677+03	2026-01-27 16:58:38.586677+03
4	Ladakh	ladakh	https://picsum.photos/seed/homevilas-ladakh/900/700	High-altitude monasteries, alpine lakes, and adventure routes.	t	2026-01-27 16:58:38.586677+03	2026-01-27 16:58:38.586677+03
5	Andaman	andaman	https://picsum.photos/seed/homevilas-andaman/900/700	Turquoise waters, private islands, and serene snorkeling escapes.	t	2026-01-27 16:58:38.586677+03	2026-01-27 16:58:38.586677+03
6	Himachal	himachal	https://picsum.photos/seed/homevilas-himachal/900/700	Hill retreats, pine forests, and boutique mountain experiences.	t	2026-01-27 16:58:38.586677+03	2026-01-27 16:58:38.586677+03
\.


--
-- Data for Name: travel_package_enquiries; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.travel_package_enquiries (id, package_id, package_title, destination_snapshot, package_price, package_currency, name, email, phone, whatsapp, travel_start_date, travel_end_date, preferred_month, travellers_count, budget_min, budget_max, message, contact_method, status, admin_notes, source, utm_source, utm_campaign, newsletter_opt_in, created_at, updated_at, is_read, read_at) FROM stdin;
\.


--
-- Data for Name: travel_package_images; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.travel_package_images (id, package_id, image_url, is_cover, sort_order, alt_text, created_at, updated_at) FROM stdin;
1	1	https://picsum.photos/seed/homevilas-goa-luxe-coastline-retreat-1/1200/800	t	0	\N	2026-01-27 16:58:38.642407+03	2026-01-27 16:58:38.642407+03
2	1	https://picsum.photos/seed/homevilas-goa-luxe-coastline-retreat-2/1200/800	f	1	\N	2026-01-27 16:58:38.642407+03	2026-01-27 16:58:38.642407+03
3	1	https://picsum.photos/seed/homevilas-goa-luxe-coastline-retreat-3/1200/800	f	2	\N	2026-01-27 16:58:38.642407+03	2026-01-27 16:58:38.642407+03
4	2	https://picsum.photos/seed/homevilas-kerala-backwater-wellness-escape-1/1200/800	t	0	\N	2026-01-27 16:58:38.642407+03	2026-01-27 16:58:38.642407+03
5	2	https://picsum.photos/seed/homevilas-kerala-backwater-wellness-escape-2/1200/800	f	1	\N	2026-01-27 16:58:38.642407+03	2026-01-27 16:58:38.642407+03
6	2	https://picsum.photos/seed/homevilas-kerala-backwater-wellness-escape-3/1200/800	f	2	\N	2026-01-27 16:58:38.642407+03	2026-01-27 16:58:38.642407+03
7	3	https://picsum.photos/seed/homevilas-rajasthan-royal-heritage-circuit-1/1200/800	t	0	\N	2026-01-27 16:58:38.642407+03	2026-01-27 16:58:38.642407+03
8	3	https://picsum.photos/seed/homevilas-rajasthan-royal-heritage-circuit-2/1200/800	f	1	\N	2026-01-27 16:58:38.642407+03	2026-01-27 16:58:38.642407+03
9	3	https://picsum.photos/seed/homevilas-rajasthan-royal-heritage-circuit-3/1200/800	f	2	\N	2026-01-27 16:58:38.642407+03	2026-01-27 16:58:38.642407+03
10	4	https://picsum.photos/seed/homevilas-ladakh-adventure-and-monastery-trail-1/1200/800	t	0	\N	2026-01-27 16:58:38.642407+03	2026-01-27 16:58:38.642407+03
11	4	https://picsum.photos/seed/homevilas-ladakh-adventure-and-monastery-trail-2/1200/800	f	1	\N	2026-01-27 16:58:38.642407+03	2026-01-27 16:58:38.642407+03
12	4	https://picsum.photos/seed/homevilas-ladakh-adventure-and-monastery-trail-3/1200/800	f	2	\N	2026-01-27 16:58:38.642407+03	2026-01-27 16:58:38.642407+03
13	5	https://picsum.photos/seed/homevilas-andaman-island-hopping-romance-1/1200/800	t	0	\N	2026-01-27 16:58:38.642407+03	2026-01-27 16:58:38.642407+03
14	5	https://picsum.photos/seed/homevilas-andaman-island-hopping-romance-2/1200/800	f	1	\N	2026-01-27 16:58:38.642407+03	2026-01-27 16:58:38.642407+03
15	5	https://picsum.photos/seed/homevilas-andaman-island-hopping-romance-3/1200/800	f	2	\N	2026-01-27 16:58:38.642407+03	2026-01-27 16:58:38.642407+03
16	6	https://picsum.photos/seed/homevilas-himachal-family-adventure-escape-1/1200/800	t	0	\N	2026-01-27 16:58:38.642407+03	2026-01-27 16:58:38.642407+03
17	6	https://picsum.photos/seed/homevilas-himachal-family-adventure-escape-2/1200/800	f	1	\N	2026-01-27 16:58:38.642407+03	2026-01-27 16:58:38.642407+03
18	6	https://picsum.photos/seed/homevilas-himachal-family-adventure-escape-3/1200/800	f	2	\N	2026-01-27 16:58:38.642407+03	2026-01-27 16:58:38.642407+03
19	7	https://picsum.photos/seed/homevilas-goa-serenity-yoga-retreat-1/1200/800	t	0	\N	2026-01-28 01:13:17.087797+03	2026-01-28 01:13:17.087797+03
20	7	https://picsum.photos/seed/homevilas-goa-serenity-yoga-retreat-2/1200/800	f	1	\N	2026-01-28 01:13:17.087797+03	2026-01-28 01:13:17.087797+03
21	7	https://picsum.photos/seed/homevilas-goa-serenity-yoga-retreat-3/1200/800	f	2	\N	2026-01-28 01:13:17.087797+03	2026-01-28 01:13:17.087797+03
22	8	https://picsum.photos/seed/homevilas-kerala-tea-country-slow-travel-1/1200/800	t	0	\N	2026-01-28 01:13:17.087797+03	2026-01-28 01:13:17.087797+03
23	8	https://picsum.photos/seed/homevilas-kerala-tea-country-slow-travel-2/1200/800	f	1	\N	2026-01-28 01:13:17.087797+03	2026-01-28 01:13:17.087797+03
24	8	https://picsum.photos/seed/homevilas-kerala-tea-country-slow-travel-3/1200/800	f	2	\N	2026-01-28 01:13:17.087797+03	2026-01-28 01:13:17.087797+03
25	9	https://picsum.photos/seed/homevilas-udaipur-lakeside-palace-escape-1/1200/800	t	0	\N	2026-01-28 01:13:17.087797+03	2026-01-28 01:13:17.087797+03
26	9	https://picsum.photos/seed/homevilas-udaipur-lakeside-palace-escape-2/1200/800	f	1	\N	2026-01-28 01:13:17.087797+03	2026-01-28 01:13:17.087797+03
27	9	https://picsum.photos/seed/homevilas-udaipur-lakeside-palace-escape-3/1200/800	f	2	\N	2026-01-28 01:13:17.087797+03	2026-01-28 01:13:17.087797+03
28	10	https://picsum.photos/seed/homevilas-andaman-dive-and-dine-getaway-1/1200/800	t	0	\N	2026-01-28 01:13:17.087797+03	2026-01-28 01:13:17.087797+03
29	10	https://picsum.photos/seed/homevilas-andaman-dive-and-dine-getaway-2/1200/800	f	1	\N	2026-01-28 01:13:17.087797+03	2026-01-28 01:13:17.087797+03
30	10	https://picsum.photos/seed/homevilas-andaman-dive-and-dine-getaway-3/1200/800	f	2	\N	2026-01-28 01:13:17.087797+03	2026-01-28 01:13:17.087797+03
31	11	https://picsum.photos/seed/homevilas-goa-heritage-boutique-escape-1/1200/800	t	0	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
32	11	https://picsum.photos/seed/homevilas-goa-heritage-boutique-escape-2/1200/800	f	1	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
33	11	https://picsum.photos/seed/homevilas-goa-heritage-boutique-escape-3/1200/800	f	2	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
34	13	https://picsum.photos/seed/homevilas-goa-monsoon-villa-retreat-1/1200/800	t	0	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
35	13	https://picsum.photos/seed/homevilas-goa-monsoon-villa-retreat-2/1200/800	f	1	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
36	13	https://picsum.photos/seed/homevilas-goa-monsoon-villa-retreat-3/1200/800	f	2	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
37	14	https://picsum.photos/seed/homevilas-goa-family-beach-carnival-1/1200/800	t	0	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
38	14	https://picsum.photos/seed/homevilas-goa-family-beach-carnival-2/1200/800	f	1	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
39	14	https://picsum.photos/seed/homevilas-goa-family-beach-carnival-3/1200/800	f	2	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
40	15	https://picsum.photos/seed/homevilas-goa-surf-and-stay-adventure-1/1200/800	t	0	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
41	15	https://picsum.photos/seed/homevilas-goa-surf-and-stay-adventure-2/1200/800	f	1	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
42	15	https://picsum.photos/seed/homevilas-goa-surf-and-stay-adventure-3/1200/800	f	2	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
43	16	https://picsum.photos/seed/homevilas-goa-culinary-trails-and-markets-1/1200/800	t	0	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
44	16	https://picsum.photos/seed/homevilas-goa-culinary-trails-and-markets-2/1200/800	f	1	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
45	16	https://picsum.photos/seed/homevilas-goa-culinary-trails-and-markets-3/1200/800	f	2	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
46	17	https://picsum.photos/seed/homevilas-goa-south-coast-seclusion-1/1200/800	t	0	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
47	17	https://picsum.photos/seed/homevilas-goa-south-coast-seclusion-2/1200/800	f	1	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
48	17	https://picsum.photos/seed/homevilas-goa-south-coast-seclusion-3/1200/800	f	2	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
49	18	https://picsum.photos/seed/homevilas-goa-island-hopping-explorer-1/1200/800	t	0	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
50	18	https://picsum.photos/seed/homevilas-goa-island-hopping-explorer-2/1200/800	f	1	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
51	18	https://picsum.photos/seed/homevilas-goa-island-hopping-explorer-3/1200/800	f	2	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
52	19	https://picsum.photos/seed/homevilas-goa-art-and-cafe-circuit-1/1200/800	t	0	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
53	19	https://picsum.photos/seed/homevilas-goa-art-and-cafe-circuit-2/1200/800	f	1	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
54	19	https://picsum.photos/seed/homevilas-goa-art-and-cafe-circuit-3/1200/800	f	2	\N	2026-01-28 12:13:02.187314+03	2026-01-28 12:13:02.187314+03
\.


--
-- Data for Name: travel_package_itineraries; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.travel_package_itineraries (id, package_id, day_number, day_title, description, image_url, created_at, updated_at) FROM stdin;
1	1	1	Arrival & Welcome	Private transfer, welcome drinks, and a curated local dinner experience.	https://picsum.photos/seed/homevilas-itin-1/900/600	2026-01-27 16:58:38.636978+03	2026-01-27 16:58:38.636978+03
2	1	2	Signature Experience	A guided signature experience tailored to the destination.	https://picsum.photos/seed/homevilas-itin-2/900/600	2026-01-27 16:58:38.636978+03	2026-01-27 16:58:38.636978+03
3	1	3	Leisure & Exploration	Leisure morning, optional excursions, and sunset gathering.	https://picsum.photos/seed/homevilas-itin-3/900/600	2026-01-27 16:58:38.636978+03	2026-01-27 16:58:38.636978+03
4	2	1	Arrival & Welcome	Private transfer, welcome drinks, and a curated local dinner experience.	https://picsum.photos/seed/homevilas-itin-1/900/600	2026-01-27 16:58:38.636978+03	2026-01-27 16:58:38.636978+03
5	2	2	Signature Experience	A guided signature experience tailored to the destination.	https://picsum.photos/seed/homevilas-itin-2/900/600	2026-01-27 16:58:38.636978+03	2026-01-27 16:58:38.636978+03
6	2	3	Leisure & Exploration	Leisure morning, optional excursions, and sunset gathering.	https://picsum.photos/seed/homevilas-itin-3/900/600	2026-01-27 16:58:38.636978+03	2026-01-27 16:58:38.636978+03
7	3	1	Arrival & Welcome	Private transfer, welcome drinks, and a curated local dinner experience.	https://picsum.photos/seed/homevilas-itin-1/900/600	2026-01-27 16:58:38.636978+03	2026-01-27 16:58:38.636978+03
8	3	2	Signature Experience	A guided signature experience tailored to the destination.	https://picsum.photos/seed/homevilas-itin-2/900/600	2026-01-27 16:58:38.636978+03	2026-01-27 16:58:38.636978+03
9	3	3	Leisure & Exploration	Leisure morning, optional excursions, and sunset gathering.	https://picsum.photos/seed/homevilas-itin-3/900/600	2026-01-27 16:58:38.636978+03	2026-01-27 16:58:38.636978+03
10	4	1	Arrival & Welcome	Private transfer, welcome drinks, and a curated local dinner experience.	https://picsum.photos/seed/homevilas-itin-1/900/600	2026-01-27 16:58:38.636978+03	2026-01-27 16:58:38.636978+03
11	4	2	Signature Experience	A guided signature experience tailored to the destination.	https://picsum.photos/seed/homevilas-itin-2/900/600	2026-01-27 16:58:38.636978+03	2026-01-27 16:58:38.636978+03
12	4	3	Leisure & Exploration	Leisure morning, optional excursions, and sunset gathering.	https://picsum.photos/seed/homevilas-itin-3/900/600	2026-01-27 16:58:38.636978+03	2026-01-27 16:58:38.636978+03
13	5	1	Arrival & Welcome	Private transfer, welcome drinks, and a curated local dinner experience.	https://picsum.photos/seed/homevilas-itin-1/900/600	2026-01-27 16:58:38.636978+03	2026-01-27 16:58:38.636978+03
14	5	2	Signature Experience	A guided signature experience tailored to the destination.	https://picsum.photos/seed/homevilas-itin-2/900/600	2026-01-27 16:58:38.636978+03	2026-01-27 16:58:38.636978+03
15	5	3	Leisure & Exploration	Leisure morning, optional excursions, and sunset gathering.	https://picsum.photos/seed/homevilas-itin-3/900/600	2026-01-27 16:58:38.636978+03	2026-01-27 16:58:38.636978+03
16	6	1	Arrival & Welcome	Private transfer, welcome drinks, and a curated local dinner experience.	https://picsum.photos/seed/homevilas-itin-1/900/600	2026-01-27 16:58:38.636978+03	2026-01-27 16:58:38.636978+03
17	6	2	Signature Experience	A guided signature experience tailored to the destination.	https://picsum.photos/seed/homevilas-itin-2/900/600	2026-01-27 16:58:38.636978+03	2026-01-27 16:58:38.636978+03
18	6	3	Leisure & Exploration	Leisure morning, optional excursions, and sunset gathering.	https://picsum.photos/seed/homevilas-itin-3/900/600	2026-01-27 16:58:38.636978+03	2026-01-27 16:58:38.636978+03
19	7	1	Arrival & Welcome	Private transfer, welcome drinks, and a curated local dinner experience.	https://picsum.photos/seed/homevilas-itin-1/900/600	2026-01-28 01:13:17.064333+03	2026-01-28 01:13:17.064333+03
20	7	2	Signature Experience	A guided signature experience tailored to the destination.	https://picsum.photos/seed/homevilas-itin-2/900/600	2026-01-28 01:13:17.064333+03	2026-01-28 01:13:17.064333+03
21	7	3	Leisure & Exploration	Leisure morning, optional excursions, and sunset gathering.	https://picsum.photos/seed/homevilas-itin-3/900/600	2026-01-28 01:13:17.064333+03	2026-01-28 01:13:17.064333+03
22	8	1	Arrival & Welcome	Private transfer, welcome drinks, and a curated local dinner experience.	https://picsum.photos/seed/homevilas-itin-1/900/600	2026-01-28 01:13:17.064333+03	2026-01-28 01:13:17.064333+03
23	8	2	Signature Experience	A guided signature experience tailored to the destination.	https://picsum.photos/seed/homevilas-itin-2/900/600	2026-01-28 01:13:17.064333+03	2026-01-28 01:13:17.064333+03
24	8	3	Leisure & Exploration	Leisure morning, optional excursions, and sunset gathering.	https://picsum.photos/seed/homevilas-itin-3/900/600	2026-01-28 01:13:17.064333+03	2026-01-28 01:13:17.064333+03
25	9	1	Arrival & Welcome	Private transfer, welcome drinks, and a curated local dinner experience.	https://picsum.photos/seed/homevilas-itin-1/900/600	2026-01-28 01:13:17.064333+03	2026-01-28 01:13:17.064333+03
26	9	2	Signature Experience	A guided signature experience tailored to the destination.	https://picsum.photos/seed/homevilas-itin-2/900/600	2026-01-28 01:13:17.064333+03	2026-01-28 01:13:17.064333+03
27	9	3	Leisure & Exploration	Leisure morning, optional excursions, and sunset gathering.	https://picsum.photos/seed/homevilas-itin-3/900/600	2026-01-28 01:13:17.064333+03	2026-01-28 01:13:17.064333+03
28	10	1	Arrival & Welcome	Private transfer, welcome drinks, and a curated local dinner experience.	https://picsum.photos/seed/homevilas-itin-1/900/600	2026-01-28 01:13:17.064333+03	2026-01-28 01:13:17.064333+03
29	10	2	Signature Experience	A guided signature experience tailored to the destination.	https://picsum.photos/seed/homevilas-itin-2/900/600	2026-01-28 01:13:17.064333+03	2026-01-28 01:13:17.064333+03
30	10	3	Leisure & Exploration	Leisure morning, optional excursions, and sunset gathering.	https://picsum.photos/seed/homevilas-itin-3/900/600	2026-01-28 01:13:17.064333+03	2026-01-28 01:13:17.064333+03
31	11	1	Arrival & Welcome	Private transfer, welcome drinks, and a curated local dinner experience.	https://picsum.photos/seed/homevilas-itin-1/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
32	11	2	Signature Experience	A guided signature experience tailored to the destination.	https://picsum.photos/seed/homevilas-itin-2/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
33	11	3	Leisure & Exploration	Leisure morning, optional excursions, and sunset gathering.	https://picsum.photos/seed/homevilas-itin-3/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
34	13	1	Arrival & Welcome	Private transfer, welcome drinks, and a curated local dinner experience.	https://picsum.photos/seed/homevilas-itin-1/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
35	13	2	Signature Experience	A guided signature experience tailored to the destination.	https://picsum.photos/seed/homevilas-itin-2/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
36	13	3	Leisure & Exploration	Leisure morning, optional excursions, and sunset gathering.	https://picsum.photos/seed/homevilas-itin-3/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
37	14	1	Arrival & Welcome	Private transfer, welcome drinks, and a curated local dinner experience.	https://picsum.photos/seed/homevilas-itin-1/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
38	14	2	Signature Experience	A guided signature experience tailored to the destination.	https://picsum.photos/seed/homevilas-itin-2/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
39	14	3	Leisure & Exploration	Leisure morning, optional excursions, and sunset gathering.	https://picsum.photos/seed/homevilas-itin-3/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
40	15	1	Arrival & Welcome	Private transfer, welcome drinks, and a curated local dinner experience.	https://picsum.photos/seed/homevilas-itin-1/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
41	15	2	Signature Experience	A guided signature experience tailored to the destination.	https://picsum.photos/seed/homevilas-itin-2/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
42	15	3	Leisure & Exploration	Leisure morning, optional excursions, and sunset gathering.	https://picsum.photos/seed/homevilas-itin-3/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
43	16	1	Arrival & Welcome	Private transfer, welcome drinks, and a curated local dinner experience.	https://picsum.photos/seed/homevilas-itin-1/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
44	16	2	Signature Experience	A guided signature experience tailored to the destination.	https://picsum.photos/seed/homevilas-itin-2/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
45	16	3	Leisure & Exploration	Leisure morning, optional excursions, and sunset gathering.	https://picsum.photos/seed/homevilas-itin-3/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
46	17	1	Arrival & Welcome	Private transfer, welcome drinks, and a curated local dinner experience.	https://picsum.photos/seed/homevilas-itin-1/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
47	17	2	Signature Experience	A guided signature experience tailored to the destination.	https://picsum.photos/seed/homevilas-itin-2/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
48	17	3	Leisure & Exploration	Leisure morning, optional excursions, and sunset gathering.	https://picsum.photos/seed/homevilas-itin-3/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
49	18	1	Arrival & Welcome	Private transfer, welcome drinks, and a curated local dinner experience.	https://picsum.photos/seed/homevilas-itin-1/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
50	18	2	Signature Experience	A guided signature experience tailored to the destination.	https://picsum.photos/seed/homevilas-itin-2/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
51	18	3	Leisure & Exploration	Leisure morning, optional excursions, and sunset gathering.	https://picsum.photos/seed/homevilas-itin-3/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
52	19	1	Arrival & Welcome	Private transfer, welcome drinks, and a curated local dinner experience.	https://picsum.photos/seed/homevilas-itin-1/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
53	19	2	Signature Experience	A guided signature experience tailored to the destination.	https://picsum.photos/seed/homevilas-itin-2/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
54	19	3	Leisure & Exploration	Leisure morning, optional excursions, and sunset gathering.	https://picsum.photos/seed/homevilas-itin-3/900/600	2026-01-28 12:13:02.15984+03	2026-01-28 12:13:02.15984+03
\.


--
-- Data for Name: travel_package_landing_config; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.travel_package_landing_config (id, seo_title, seo_description, sections, created_at, updated_at) FROM stdin;
1	Homevilas Travel Packages	Discover curated travel packages across India with luxury stays and custom experiences.	[{"order": 1, "content": {"ctaLink": "/packages", "ctaText": "Explore packages", "heading": "Journeys crafted for refined travel.", "videoUrl": "", "showVideo": false, "subheading": "Handpicked luxury packages, curated experiences, and effortless planning.", "showSearchBar": true, "heroImageMobile": "https://picsum.photos/seed/homevilas-packages-hero-mobile/900/1200", "heroImageDesktop": "https://picsum.photos/seed/homevilas-packages-hero/1600/900"}, "enabled": true, "sectionKey": "hero"}, {"order": 2, "content": {"heading": "Featured destinations", "maxItems": 6, "subheading": "Signature regions loved by Homevilas travelers."}, "enabled": true, "sectionKey": "destinations"}, {"order": 3, "content": {"heading": "Trending packages", "maxItems": 6, "subheading": "Handpicked itineraries trending this season."}, "enabled": true, "sectionKey": "trending"}, {"order": 4, "content": {"heading": "Explore by theme", "subheading": "Choose the journey that matches your style."}, "enabled": true, "sectionKey": "themes"}, {"order": 5, "content": {"heading": "Tailor-made packages", "pageSize": 6, "defaultSort": "popularity"}, "enabled": true, "sectionKey": "listing"}, {"order": 6, "content": {"heading": "Limited-time offers", "showCountdown": true}, "enabled": true, "sectionKey": "offers"}, {"order": 7, "content": {"heading": "Traveler stories", "trustBadgeText": "Trusted by discerning travelers", "totalReviewsNumber": 2480}, "enabled": true, "sectionKey": "testimonials"}, {"order": 8, "content": {"heading": "Travel journal", "maxItems": 4}, "enabled": true, "sectionKey": "articles"}, {"order": 9, "content": {"heading": "Get the latest curated journeys", "subheading": "Insider access to new packages, seasonal offers, and experiences.", "backgroundImage": "https://picsum.photos/seed/homevilas-newsletter/1600/600"}, "enabled": true, "sectionKey": "newsletter"}, {"order": 10, "content": {"heading": "Ready to design your next journey?", "buttonLink": "/packages", "buttonText": "Request a custom tour", "subheading": "Talk to a Homevilas travel designer today."}, "enabled": true, "sectionKey": "footerCta"}]	2026-01-27 16:58:38.684983+03	2026-01-27 16:58:38.684983+03
\.


--
-- Data for Name: travel_package_listing_config; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.travel_package_listing_config (id, title, subtitle, default_sort, show_trending_row, show_theme_chips, results_mode, seo_title, seo_description, seo_image, labels, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: travel_package_offers; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.travel_package_offers (id, title, subtitle, discount_text, cta_text, cta_link, image_url, starts_at, ends_at, is_active, created_at, updated_at) FROM stdin;
1	Monsoon Luxe Escape	Stay 3 nights, pay for 2	Save 35%	Book now	/packages	https://picsum.photos/seed/homevilas-offer-1/900/700	2025-01-01	2027-12-31	t	2026-01-27 16:58:38.67451+03	2026-01-27 16:58:38.67451+03
2	Honeymoon Upgrade	Complimentary spa ritual for couples	Up to 25% off	Plan trip	/packages	https://picsum.photos/seed/homevilas-offer-2/900/700	2025-01-01	2027-12-31	t	2026-01-27 16:58:38.67451+03	2026-01-27 16:58:38.67451+03
3	Family Adventure Bundle	Kids stay free on select tours	Save 20%	Explore	/packages	https://picsum.photos/seed/homevilas-offer-3/900/700	2025-01-01	2027-12-31	t	2026-01-27 16:58:38.67451+03	2026-01-27 16:58:38.67451+03
\.


--
-- Data for Name: travel_package_testimonials; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.travel_package_testimonials (id, name, role, avatar_url, rating, review, is_active, created_at, updated_at) FROM stdin;
1	Aria Kapoor	Founder, Studio North	https://picsum.photos/seed/homevilas-review-1/200/200	4.90	Everything was curated down to the last detail. The villa, transfers, and local experiences felt incredibly personal.	t	2026-01-27 16:58:38.676985+03	2026-01-27 16:58:38.676985+03
2	Rohan Mehta	Product Lead	https://picsum.photos/seed/homevilas-review-2/200/200	4.80	Homevilas delivered a seamless family holiday. The itinerary balanced adventure with downtime perfectly.	t	2026-01-27 16:58:38.676985+03	2026-01-27 16:58:38.676985+03
3	Nisha Rao	Travel Editor	https://picsum.photos/seed/homevilas-review-3/200/200	4.70	The culinary moments and local hosts were standout. We felt cared for throughout the journey.	t	2026-01-27 16:58:38.676985+03	2026-01-27 16:58:38.676985+03
\.


--
-- Data for Name: travel_package_theme_links; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.travel_package_theme_links (id, package_id, theme_id) FROM stdin;
1	1	1
2	1	2
3	2	5
4	2	1
5	3	6
6	3	3
7	4	4
8	4	6
9	5	2
10	5	1
11	6	3
12	6	4
13	7	5
14	7	1
15	8	5
16	8	6
17	9	1
18	9	6
19	10	4
20	10	2
21	11	6
22	11	1
23	13	5
24	13	1
25	14	3
26	15	4
27	16	6
28	16	3
29	17	2
30	17	1
31	18	4
32	18	2
33	19	6
34	19	5
\.


--
-- Data for Name: travel_package_themes; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.travel_package_themes (id, name, slug, icon, is_active, created_at, updated_at) FROM stdin;
1	Luxury Stays	luxury-stays	ri-hotel-line	t	2026-01-27 16:58:38.589406+03	2026-01-27 16:58:38.589406+03
2	Honeymoon	honeymoon	ri-heart-2-line	t	2026-01-27 16:58:38.589406+03	2026-01-27 16:58:38.589406+03
3	Family	family	ri-group-line	t	2026-01-27 16:58:38.589406+03	2026-01-27 16:58:38.589406+03
4	Adventure	adventure	ri-compass-3-line	t	2026-01-27 16:58:38.589406+03	2026-01-27 16:58:38.589406+03
5	Wellness	wellness	ri-leaf-line	t	2026-01-27 16:58:38.589406+03	2026-01-27 16:58:38.589406+03
6	Cultural	cultural	ri-ancient-gate-line	t	2026-01-27 16:58:38.589406+03	2026-01-27 16:58:38.589406+03
\.


--
-- Data for Name: travel_packages; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.travel_packages (id, package_code, title, slug, short_description, description, destination_country, destination_state, destination_city, start_city, duration_days, duration_nights, price_per_person, currency, min_persons, max_persons, inclusions, exclusions, highlights, categories, status, seo_title, seo_description, seo_keywords, created_at, updated_at, destination_id, price_from, rating, difficulty_level, availability_start_date, availability_end_date, seasonal_text, max_guests, is_trending, is_top_rated, is_featured, is_active) FROM stdin;
2	HVPKG-6022	Kerala Backwater Wellness Escape	kerala-backwater-wellness-escape	Houseboat stay, Ayurveda rituals, and coastal heritage trails.	Slow down with a curated wellness program featuring Ayurveda spa sessions, backwater cruises, and coastal cuisine.	\N	\N	Kochi	\N	6	5	\N	INR	\N	\N	["Daily breakfast", "Wellness sessions", "Private transfers"]	["Flights", "Travel insurance"]	["Houseboat night", "Wellness consultation", "Spice plantation visit"]	\N	published	\N	\N	\N	2026-01-27 16:58:38.594648+03	2026-01-27 16:58:38.594648+03	2	28000.00	4.70	Easy	\N	\N	\N	6	t	f	t	t
19	HVPKG-5290	Goa Art & Cafe Circuit	goa-art-and-cafe-circuit	Gallery visits, boutique cafes, and artisan showcases.	A four-day art-forward journey with gallery visits, artisan showcases, and curated cafe stops.	\N	\N	Goa	\N	4	3	\N	INR	\N	\N	["Stay with breakfast", "Art tour", "Private transfers"]	["Flights", "Personal expenses"]	["Gallery trail", "Artisan workshop", "Cafe hopping"]	\N	published	\N	\N	\N	2026-01-28 12:13:02.106726+03	2026-01-28 12:13:02.106726+03	1	25000.00	4.50	Easy	\N	\N	\N	4	t	f	f	t
10	HVPKG-2623	Andaman Dive & Dine Getaway	andaman-dive-and-dine-getaway	Reef dives, island feasts, and secluded beach time.	Spend five days around Havelock with guided dives, sunset beach dinners, and island hopping.	\N	\N	Havelock	\N	5	4	\N	INR	\N	\N	["Stay with breakfast", "Dive session", "Island transfers"]	["Flights", "Personal expenses"]	["Guided reef dive", "Island hopping", "Private beach dinner"]	\N	published	\N	\N	\N	2026-01-28 01:13:16.985835+03	2026-01-28 01:13:16.985835+03	5	42000.00	4.70	Moderate	\N	\N	\N	4	t	f	f	t
16	HVPKG-5677	Goa Culinary Trails & Markets	goa-culinary-trails-and-markets	Chef-led tastings, spice markets, and coastal kitchens.	A three-day culinary escape featuring market visits, chef-led tastings, and heritage kitchens.	\N	\N	Goa	\N	3	2	\N	INR	\N	\N	["Stay with breakfast", "Tasting menu", "Market tour"]	["Flights", "Personal expenses"]	["Chef tasting menu", "Spice market tour", "Cooking demo"]	\N	published	\N	\N	\N	2026-01-28 12:13:02.106726+03	2026-01-28 12:13:02.106726+03	1	22000.00	4.50	Easy	\N	\N	\N	4	t	f	f	t
9	HVPKG-4345	Udaipur Lakeside Palace Escape	udaipur-lakeside-palace-escape	Lakeside palaces, heritage walks, and private dining.	Experience Udaipur with heritage stays, curated palace visits, and sunset lake cruises.	\N	\N	Udaipur	\N	4	3	\N	INR	\N	\N	["Stay with breakfast", "Private transfers", "Guided heritage walk"]	["Flights", "Personal expenses"]	["Palace stay", "Sunset lake cruise", "Heritage market tour"]	\N	published	\N	\N	\N	2026-01-28 01:13:16.985835+03	2026-01-28 01:13:16.985835+03	3	38000.00	4.80	Easy	\N	\N	\N	4	t	t	f	t
6	HVPKG-5573	Himachal Family Adventure Escape	himachal-family-adventure-escape	Mountain stays, soft adventure, and family-friendly experiences.	Perfect for families seeking gentle adventure, bonfire evenings, and guided nature walks.	\N	\N	Manali	\N	5	4	\N	INR	\N	\N	["Stay with breakfast", "Private transfers", "Family activities"]	["Flights", "Adventure upgrades"]	["River-side picnic", "Guided nature walk", "Mountain bonfire"]	\N	published	\N	\N	\N	2026-01-27 16:58:38.594648+03	2026-01-27 16:58:38.594648+03	6	25000.00	4.50	Easy	\N	\N	\N	6	t	f	t	t
3	HVPKG-5767	Rajasthan Royal Heritage Circuit	rajasthan-royal-heritage-circuit	Fort tours, palace stays, and desert experiences across Rajasthan.	An eight-day cultural immersion featuring heritage hotels, private guided tours, and desert safaris.	\N	\N	Jaipur	\N	8	7	\N	INR	\N	\N	["Stay with breakfast", "Guided tours", "Private transfers"]	["Flights", "Lunch & dinner"]	["Palace stay", "Desert safari", "Private heritage walk"]	\N	published	\N	\N	\N	2026-01-27 16:58:38.594648+03	2026-01-27 16:58:38.594648+03	3	45000.00	4.60	Moderate	\N	\N	\N	8	t	t	f	t
1	HVPKG-4649	Goa Luxe Coastline Retreat	goa-luxe-coastline-retreat	Private villas, sunset cruises, and curated dining in Goa.	A five-day escape across North and South Goa with private transfers, boutique stays, and bespoke culinary experiences.	\N	\N	Goa	\N	5	4	\N	INR	\N	\N	["Stay with breakfast", "Private airport transfers", "Cruise experience"]	["Flights", "Personal expenses", "Tips"]	["Private beach access", "Sunset yacht cruise", "Chef-curated meals"]	\N	published	\N	\N	\N	2026-01-27 16:58:38.594648+03	2026-01-27 16:58:38.594648+03	1	32000.00	4.80	Easy	\N	\N	\N	4	t	t	t	t
18	HVPKG-9385	Goa Island Hopping Explorer	goa-island-hopping-explorer	Island cruises, snorkeling, and private cove stops.	A five-day itinerary covering island cruises, snorkeling sessions, and curated beach picnics.	\N	\N	Goa	\N	5	4	\N	INR	\N	\N	["Stay with breakfast", "Cruise tickets", "Private transfers"]	["Flights", "Personal expenses"]	["Island cruise", "Snorkeling session", "Private beach picnic"]	\N	published	\N	\N	\N	2026-01-28 12:13:02.106726+03	2026-01-28 12:13:02.106726+03	1	33000.00	4.60	Moderate	\N	\N	\N	4	t	f	f	t
14	HVPKG-1629	Goa Family Beach Carnival	goa-family-beach-carnival	Family-friendly beaches, interactive experiences, and easy transfers.	A five-day family escape with kid-friendly activities, gentle excursions, and beachfront stays.	\N	\N	Goa	\N	5	4	\N	INR	\N	\N	["Stay with breakfast", "Family activities", "Private transfers"]	["Flights", "Personal expenses"]	["Beach games", "Family villa stay", "Guided sunset cruise"]	\N	published	\N	\N	\N	2026-01-28 12:13:02.106726+03	2026-01-28 12:13:02.106726+03	1	31000.00	4.40	Easy	\N	\N	\N	6	t	f	f	t
7	HVPKG-2059	Goa Serenity Yoga Retreat	goa-serenity-yoga-retreat	Beachfront yoga, mindful dining, and slow coastal mornings.	A restorative four-day retreat with sunrise yoga, wellness cuisine, and guided shoreline meditation.	\N	\N	Goa	\N	4	3	\N	INR	\N	\N	["Stay with breakfast", "Daily yoga", "Airport transfers"]	["Flights", "Personal expenses"]	["Sunrise yoga sessions", "Wellness cuisine", "Beachside meditation"]	\N	published	\N	\N	\N	2026-01-28 01:13:16.985835+03	2026-01-28 01:13:16.985835+03	1	26000.00	4.60	Easy	\N	\N	\N	4	t	f	t	t
8	HVPKG-7263	Kerala Tea Country Slow Travel	kerala-tea-country-slow-travel	Tea estates, plantation stays, and curated local flavors.	A slow-travel escape across Munnar with boutique stays, plantation walks, and chef-led tastings.	\N	\N	Munnar	\N	5	4	\N	INR	\N	\N	["Stay with breakfast", "Guided estate visit", "Private transfers"]	["Flights", "Personal expenses"]	["Tea estate tour", "Chef tasting menu", "Scenic hill drives"]	\N	published	\N	\N	\N	2026-01-28 01:13:16.985835+03	2026-01-28 01:13:16.985835+03	2	30000.00	4.70	Easy	\N	\N	\N	6	t	f	f	t
4	HVPKG-7603	Ladakh Adventure & Monastery Trail	ladakh-adventure-and-monastery-trail	High-altitude lakes, monasteries, and adventure trails.	Explore Ladakh with curated stays, monastery visits, and scenic drives through mountain passes.	\N	\N	Leh	\N	7	6	\N	INR	\N	\N	["Stay with breakfast", "Inner line permits", "Private guide"]	["Flights", "Adventure gear"]	["Pangong Lake camp", "Monastery tour", "Local experiences"]	\N	published	\N	\N	\N	2026-01-27 16:58:38.594648+03	2026-01-27 16:58:38.594648+03	4	52000.00	4.90	Challenging	\N	\N	\N	6	t	f	t	t
5	HVPKG-8880	Andaman Island Hopping Romance	andaman-island-hopping-romance	Island cruises, snorkeling, and private beach dinners.	A romantic getaway covering Port Blair, Havelock, and Neil Island with premium stays and curated activities.	\N	\N	Port Blair	\N	6	5	\N	INR	\N	\N	["Stay with breakfast", "All transfers", "Activity tickets"]	["Flights", "Personal expenses"]	["Private beach dinner", "Snorkeling excursion", "Island ferry"]	\N	published	\N	\N	\N	2026-01-27 16:58:38.594648+03	2026-01-27 16:58:38.594648+03	5	48000.00	4.80	Easy	\N	\N	\N	2	t	t	f	t
11	HVPKG-8591	Goa Heritage Boutique Escape	goa-heritage-boutique-escape	Portuguese heritage walks, boutique stays, and curated dining.	A four-day itinerary through Old Goa and Fontainhas with private guides, boutique stays, and local tastings.	\N	\N	Goa	\N	4	3	\N	INR	\N	\N	["Stay with breakfast", "Private guide", "Airport transfers"]	["Flights", "Personal expenses"]	["Heritage walk", "Boutique heritage stay", "Market tastings"]	\N	published	\N	\N	\N	2026-01-28 12:13:02.106726+03	2026-01-28 12:13:02.106726+03	1	24000.00	4.50	Easy	\N	\N	\N	4	t	f	t	t
17	HVPKG-5812	Goa South Coast Seclusion	goa-south-coast-seclusion	Quiet beaches, sunset dinners, and secluded stays.	A peaceful coastal escape with private villas, romantic dinners, and curated day trips.	\N	\N	Goa	\N	5	4	\N	INR	\N	\N	["Stay with breakfast", "Private transfers", "Dining credit"]	["Flights", "Personal expenses"]	["Private villa stay", "Sunset dining", "Hidden beach visit"]	\N	published	\N	\N	\N	2026-01-28 12:13:02.106726+03	2026-01-28 12:13:02.106726+03	1	36000.00	4.80	Easy	\N	\N	\N	2	t	t	f	t
13	HVPKG-6794	Goa Monsoon Villa Retreat	goa-monsoon-villa-retreat	Rain-kissed villas, spa rituals, and slow coastal evenings.	A monsoon-ready escape with private villas, curated spa rituals, and coastal dining experiences.	\N	\N	Goa	\N	4	3	\N	INR	\N	\N	["Stay with breakfast", "Spa session", "Private transfers"]	["Flights", "Personal expenses"]	["Private plunge pool", "Wellness spa ritual", "Chef tasting menu"]	\N	published	\N	\N	\N	2026-01-28 12:13:02.106726+03	2026-01-28 12:13:02.106726+03	1	29000.00	4.60	Easy	\N	\N	\N	4	t	f	t	t
15	HVPKG-6395	Goa Surf & Stay Adventure	goa-surf-and-stay-adventure	Surf lessons, coastal trails, and energetic beach days.	A six-day adventure that combines surf coaching, coastal trails, and curated nightlife.	\N	\N	Goa	\N	6	5	\N	INR	\N	\N	["Stay with breakfast", "Surf lessons", "Private transfers"]	["Flights", "Adventure gear"]	["Surf coaching", "Coastal trail", "Sunset bonfire"]	\N	published	\N	\N	\N	2026-01-28 12:13:02.106726+03	2026-01-28 12:13:02.106726+03	1	34000.00	4.70	Moderate	\N	\N	\N	4	t	f	f	t
\.


--
-- Data for Name: vehicle_amenities; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.vehicle_amenities (id, "vehicleId", "amenityId", "createdAt", "updatedAt") FROM stdin;
2592ca49-3542-40ea-83eb-9dad2f071c26	9fd07256-aafb-4772-9028-5750fa61c907	edd5e199-0a43-4f3e-a6a7-f3eef42bdb42	2026-01-30 16:32:13.892	2026-01-30 16:32:13.892
3ae850e2-3fef-4633-82e3-c1d830f88ed5	9fd07256-aafb-4772-9028-5750fa61c907	ad4cdf06-b803-42f5-a54c-c6997ee77082	2026-01-30 16:32:13.892	2026-01-30 16:32:13.892
27032c83-c2a3-40e4-8c17-7a8cf807bee2	9fd07256-aafb-4772-9028-5750fa61c907	06e62a1d-cb9c-4f78-a925-103722dfc5da	2026-01-30 16:32:13.892	2026-01-30 16:32:13.892
102c081b-e03a-4ee1-a014-d3034e2e1c2d	9fd07256-aafb-4772-9028-5750fa61c907	86073199-4942-4882-8fa8-2db3a72b9ccb	2026-01-30 16:32:13.892	2026-01-30 16:32:13.892
06b60cb0-bf90-4f52-ad75-063c10b4a4cd	bd6ab8d2-eefe-4731-819b-10c6cdaf0c9f	edd5e199-0a43-4f3e-a6a7-f3eef42bdb42	2026-01-30 16:32:13.935	2026-01-30 16:32:13.935
05e5a9d8-a232-4a5c-ae2c-87ff162967cf	bd6ab8d2-eefe-4731-819b-10c6cdaf0c9f	ad4cdf06-b803-42f5-a54c-c6997ee77082	2026-01-30 16:32:13.935	2026-01-30 16:32:13.935
db0a00ee-3c1c-4e4b-a0ed-b3610e6f045c	bd6ab8d2-eefe-4731-819b-10c6cdaf0c9f	06e62a1d-cb9c-4f78-a925-103722dfc5da	2026-01-30 16:32:13.935	2026-01-30 16:32:13.935
fe037ed3-2082-4c16-a1a7-653459d10b37	bd6ab8d2-eefe-4731-819b-10c6cdaf0c9f	86073199-4942-4882-8fa8-2db3a72b9ccb	2026-01-30 16:32:13.935	2026-01-30 16:32:13.935
afae7e03-b1f8-4b93-a5dd-48311a3f5c74	43e43238-8e97-4fe5-ae07-95f0e897a41c	edd5e199-0a43-4f3e-a6a7-f3eef42bdb42	2026-01-30 16:32:13.937	2026-01-30 16:32:13.937
5a185f61-8792-4178-846f-c466560fa196	43e43238-8e97-4fe5-ae07-95f0e897a41c	ad4cdf06-b803-42f5-a54c-c6997ee77082	2026-01-30 16:32:13.937	2026-01-30 16:32:13.937
18eaa42d-b44c-4019-b52f-009de5e2e6e2	43e43238-8e97-4fe5-ae07-95f0e897a41c	06e62a1d-cb9c-4f78-a925-103722dfc5da	2026-01-30 16:32:13.937	2026-01-30 16:32:13.937
4745cfff-93c2-49a7-b23f-3964bea3e22f	43e43238-8e97-4fe5-ae07-95f0e897a41c	86073199-4942-4882-8fa8-2db3a72b9ccb	2026-01-30 16:32:13.937	2026-01-30 16:32:13.937
3ff53959-e480-41c8-b996-deafa07186cb	43e43238-8e97-4fe5-ae07-95f0e897a41c	11a928eb-ba12-4c4d-90ae-dfa8500c6e9c	2026-01-30 16:32:13.937	2026-01-30 16:32:13.937
0bd48c96-45c0-422c-bd22-5034383e987d	c04bdbaf-4db9-4116-9ba0-b54fb36606fa	edd5e199-0a43-4f3e-a6a7-f3eef42bdb42	2026-01-30 16:32:13.939	2026-01-30 16:32:13.939
1527aa61-821f-4c6e-ac09-98e2569eff54	c04bdbaf-4db9-4116-9ba0-b54fb36606fa	ad4cdf06-b803-42f5-a54c-c6997ee77082	2026-01-30 16:32:13.939	2026-01-30 16:32:13.939
2e3497f6-bdcf-4800-8443-10952b628abd	c04bdbaf-4db9-4116-9ba0-b54fb36606fa	06e62a1d-cb9c-4f78-a925-103722dfc5da	2026-01-30 16:32:13.939	2026-01-30 16:32:13.939
87ddda0f-6942-4253-a39c-73e0af909e94	c04bdbaf-4db9-4116-9ba0-b54fb36606fa	86073199-4942-4882-8fa8-2db3a72b9ccb	2026-01-30 16:32:13.939	2026-01-30 16:32:13.939
e2cd6171-25ac-4f72-84af-b4c32218a766	e49fd8d7-07b7-4759-b24f-5b5e4f8ebab4	edd5e199-0a43-4f3e-a6a7-f3eef42bdb42	2026-01-30 16:32:13.941	2026-01-30 16:32:13.941
43f1271f-820d-4398-a294-54fcee9c074b	e49fd8d7-07b7-4759-b24f-5b5e4f8ebab4	ad4cdf06-b803-42f5-a54c-c6997ee77082	2026-01-30 16:32:13.941	2026-01-30 16:32:13.941
5cb8a954-a459-4b9e-8ddb-8267c0b2359c	e49fd8d7-07b7-4759-b24f-5b5e4f8ebab4	06e62a1d-cb9c-4f78-a925-103722dfc5da	2026-01-30 16:32:13.941	2026-01-30 16:32:13.941
e5554eec-d78d-46c3-bdb9-ee8c7c0db062	e49fd8d7-07b7-4759-b24f-5b5e4f8ebab4	86073199-4942-4882-8fa8-2db3a72b9ccb	2026-01-30 16:32:13.941	2026-01-30 16:32:13.941
ce30e30c-f7e6-42d3-8fab-aeb9e1e49c4a	418d16ac-911f-4c53-b98c-bf354b0c68e5	edd5e199-0a43-4f3e-a6a7-f3eef42bdb42	2026-01-30 16:32:13.942	2026-01-30 16:32:13.942
9c42a27d-62ed-4480-8bc2-d2af53f5479b	418d16ac-911f-4c53-b98c-bf354b0c68e5	ad4cdf06-b803-42f5-a54c-c6997ee77082	2026-01-30 16:32:13.942	2026-01-30 16:32:13.942
7e292887-5a52-4ffb-bb3e-51d33659b5e4	418d16ac-911f-4c53-b98c-bf354b0c68e5	06e62a1d-cb9c-4f78-a925-103722dfc5da	2026-01-30 16:32:13.942	2026-01-30 16:32:13.942
2c53b7f6-341e-4149-a79f-155af70a0352	418d16ac-911f-4c53-b98c-bf354b0c68e5	86073199-4942-4882-8fa8-2db3a72b9ccb	2026-01-30 16:32:13.942	2026-01-30 16:32:13.942
7544a72f-2dbf-4c0b-bec2-805c7278eec0	5e89bfce-5f26-4f84-9249-bd489a510cbe	edd5e199-0a43-4f3e-a6a7-f3eef42bdb42	2026-01-30 16:32:13.944	2026-01-30 16:32:13.944
390216a1-0e48-4a38-92d3-cb95b8cf9c1b	5e89bfce-5f26-4f84-9249-bd489a510cbe	ad4cdf06-b803-42f5-a54c-c6997ee77082	2026-01-30 16:32:13.944	2026-01-30 16:32:13.944
ac534107-6c41-42b0-abc9-49649d7b60ce	5e89bfce-5f26-4f84-9249-bd489a510cbe	06e62a1d-cb9c-4f78-a925-103722dfc5da	2026-01-30 16:32:13.944	2026-01-30 16:32:13.944
3b9e0da5-cc5c-46e0-b23c-cc7547a53ac9	5e89bfce-5f26-4f84-9249-bd489a510cbe	86073199-4942-4882-8fa8-2db3a72b9ccb	2026-01-30 16:32:13.944	2026-01-30 16:32:13.944
5c46a3c3-ea39-4f5a-8bc1-cd601b46ee77	5e89bfce-5f26-4f84-9249-bd489a510cbe	2b8afa7a-11fe-4ac4-a2a6-609c2fd569b7	2026-01-30 16:32:13.944	2026-01-30 16:32:13.944
a40fee06-b00d-46d1-9c18-7fac43ff0ac0	1e6e1240-f6a3-4c28-be3f-b05d12dfe77a	edd5e199-0a43-4f3e-a6a7-f3eef42bdb42	2026-01-30 16:32:13.948	2026-01-30 16:32:13.948
aad1742b-9ad5-4d88-9675-dfe75a180544	1e6e1240-f6a3-4c28-be3f-b05d12dfe77a	ad4cdf06-b803-42f5-a54c-c6997ee77082	2026-01-30 16:32:13.948	2026-01-30 16:32:13.948
2dba8aff-ce63-4418-8821-ef72b72164c6	1e6e1240-f6a3-4c28-be3f-b05d12dfe77a	06e62a1d-cb9c-4f78-a925-103722dfc5da	2026-01-30 16:32:13.948	2026-01-30 16:32:13.948
a4bc5199-1d48-47da-a9bf-762b6b445fbb	1e6e1240-f6a3-4c28-be3f-b05d12dfe77a	86073199-4942-4882-8fa8-2db3a72b9ccb	2026-01-30 16:32:13.948	2026-01-30 16:32:13.948
f63b6b97-26ad-4984-b13b-b532ff72e17e	9f99fbd0-858e-46e3-9b08-15f382813803	edd5e199-0a43-4f3e-a6a7-f3eef42bdb42	2026-02-01 16:11:36.316	2026-02-01 16:11:36.316
1a562628-6ebd-4e5b-b14d-0b491ef3933b	9f99fbd0-858e-46e3-9b08-15f382813803	ad4cdf06-b803-42f5-a54c-c6997ee77082	2026-02-01 16:11:36.316	2026-02-01 16:11:36.316
527b8e7d-a0e7-4076-8eaa-361514c4432b	9f99fbd0-858e-46e3-9b08-15f382813803	06e62a1d-cb9c-4f78-a925-103722dfc5da	2026-02-01 16:11:36.316	2026-02-01 16:11:36.316
3d182068-6276-4bf6-adaf-463742d8e7c0	9f99fbd0-858e-46e3-9b08-15f382813803	86073199-4942-4882-8fa8-2db3a72b9ccb	2026-02-01 16:11:36.316	2026-02-01 16:11:36.316
53c1a7d0-be86-4707-9317-02299ff0bbf1	7cb6e453-b49c-460c-849f-2088087a339d	edd5e199-0a43-4f3e-a6a7-f3eef42bdb42	2026-02-01 16:11:36.353	2026-02-01 16:11:36.353
c4d41703-1c33-4e64-8f68-73d56e0c3e15	7cb6e453-b49c-460c-849f-2088087a339d	ad4cdf06-b803-42f5-a54c-c6997ee77082	2026-02-01 16:11:36.353	2026-02-01 16:11:36.353
a2e75c5c-6236-46bb-8e0f-7dc3ac63129a	7cb6e453-b49c-460c-849f-2088087a339d	06e62a1d-cb9c-4f78-a925-103722dfc5da	2026-02-01 16:11:36.353	2026-02-01 16:11:36.353
35c1a280-4be6-4034-9291-b696293241c0	7cb6e453-b49c-460c-849f-2088087a339d	86073199-4942-4882-8fa8-2db3a72b9ccb	2026-02-01 16:11:36.353	2026-02-01 16:11:36.353
76f7f039-b087-4bf9-bb64-1c001169b9cb	7cb6e453-b49c-460c-849f-2088087a339d	11a928eb-ba12-4c4d-90ae-dfa8500c6e9c	2026-02-01 16:11:36.353	2026-02-01 16:11:36.353
85d0bf2b-a765-4670-bd00-2b0cdb398d9e	f3076517-03f5-40d0-a995-d6026bb515ed	edd5e199-0a43-4f3e-a6a7-f3eef42bdb42	2026-02-01 16:11:36.358	2026-02-01 16:11:36.358
aaee2b3d-85b3-48a9-980d-b73d40f54d92	f3076517-03f5-40d0-a995-d6026bb515ed	ad4cdf06-b803-42f5-a54c-c6997ee77082	2026-02-01 16:11:36.358	2026-02-01 16:11:36.358
3079310a-6446-47a5-97c8-b1b8919804f7	f3076517-03f5-40d0-a995-d6026bb515ed	06e62a1d-cb9c-4f78-a925-103722dfc5da	2026-02-01 16:11:36.358	2026-02-01 16:11:36.358
88fdfecb-4a33-42ad-b189-1b4058c8d9cd	f3076517-03f5-40d0-a995-d6026bb515ed	86073199-4942-4882-8fa8-2db3a72b9ccb	2026-02-01 16:11:36.358	2026-02-01 16:11:36.358
1d18fe41-a941-46d7-a260-bdab3c324cdb	a898c3e5-da04-4f88-9557-960a37df5c3c	edd5e199-0a43-4f3e-a6a7-f3eef42bdb42	2026-02-01 16:11:36.36	2026-02-01 16:11:36.36
46cc25f1-afb8-4800-baed-27a8d42b315b	a898c3e5-da04-4f88-9557-960a37df5c3c	ad4cdf06-b803-42f5-a54c-c6997ee77082	2026-02-01 16:11:36.36	2026-02-01 16:11:36.36
ad7f5657-5f34-4094-a08a-bd0f3f6697a4	a898c3e5-da04-4f88-9557-960a37df5c3c	06e62a1d-cb9c-4f78-a925-103722dfc5da	2026-02-01 16:11:36.36	2026-02-01 16:11:36.36
8c94c59d-db26-4e99-8332-7a05bc690500	a898c3e5-da04-4f88-9557-960a37df5c3c	86073199-4942-4882-8fa8-2db3a72b9ccb	2026-02-01 16:11:36.36	2026-02-01 16:11:36.36
710674f9-66de-4b10-9c00-a1f1141b8c3e	a898c3e5-da04-4f88-9557-960a37df5c3c	11a928eb-ba12-4c4d-90ae-dfa8500c6e9c	2026-02-01 16:11:36.36	2026-02-01 16:11:36.36
\.


--
-- Data for Name: vehicle_categories; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.vehicle_categories (id, name, slug, description, "isOutstationSupported", "isActive", "sortOrder", "createdAt", "updatedAt", "imageUrl") FROM stdin;
2fc930a9-cb52-4813-b0a9-5dff78121d1c	Sedan	sedan	Comfortable sedans for city and outstation rides.	t	t	1	2026-01-30 16:32:13.432	2026-02-01 18:52:17.564	https://picsum.photos/seed/oxitaxi-sedan/900/700
48c33bc8-491d-4c86-9b00-75f89903d72a	SUV	suv	Spacious SUVs for families and business travel.	t	t	2	2026-01-30 16:32:13.454	2026-02-01 18:52:17.571	https://picsum.photos/seed/oxitaxi-suv/900/700
04cc25fc-7d90-4f07-aae8-250b6f9946d8	Tempo Traveller	tempo-traveller	Group-friendly tempo travellers with extra luggage space.	t	t	3	2026-01-30 16:32:13.457	2026-02-01 18:52:17.573	https://picsum.photos/seed/oxitaxi-tempo/900/700
23419a74-bb7b-422a-8dbf-af15d8ca56ab	Bus	bus	Mini and luxury buses for large groups.	t	t	4	2026-01-30 16:32:13.459	2026-02-01 18:52:17.575	https://picsum.photos/seed/oxitaxi-bus/900/700
\.


--
-- Data for Name: vehicle_images; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.vehicle_images (id, "vehicleId", url, "altText", "isCover", "sortOrder", "createdAt", "updatedAt") FROM stdin;
68aa74eb-634c-45fa-97ea-82e738c0c40a	9fd07256-aafb-4772-9028-5750fa61c907	https://picsum.photos/seed/sed-et-001-cover/1200/800	Toyota Etios cover	t	1	2026-01-30 16:32:13.845	2026-01-30 16:32:13.845
9748106e-859b-4735-94cf-775d96a36790	9fd07256-aafb-4772-9028-5750fa61c907	https://picsum.photos/seed/sed-et-001-1/1200/800	Toyota Etios gallery 1	f	2	2026-01-30 16:32:13.845	2026-01-30 16:32:13.845
eed07dc0-2369-4fae-97fb-d6db59c17a59	9fd07256-aafb-4772-9028-5750fa61c907	https://picsum.photos/seed/sed-et-001-2/1200/800	Toyota Etios gallery 2	f	3	2026-01-30 16:32:13.845	2026-01-30 16:32:13.845
4119c068-6144-49d9-a94e-19f44ae36b8e	bd6ab8d2-eefe-4731-819b-10c6cdaf0c9f	https://picsum.photos/seed/sed-dz-002-cover/1200/800	Maruti Dzire cover	t	1	2026-01-30 16:32:13.874	2026-01-30 16:32:13.874
f5ee110e-aa3a-458d-a485-ed95fbe49007	bd6ab8d2-eefe-4731-819b-10c6cdaf0c9f	https://picsum.photos/seed/sed-dz-002-1/1200/800	Maruti Dzire gallery 1	f	2	2026-01-30 16:32:13.874	2026-01-30 16:32:13.874
cc97a58a-3e5b-4b96-9cae-2b792e77aadd	bd6ab8d2-eefe-4731-819b-10c6cdaf0c9f	https://picsum.photos/seed/sed-dz-002-2/1200/800	Maruti Dzire gallery 2	f	3	2026-01-30 16:32:13.874	2026-01-30 16:32:13.874
6759374c-33ef-4394-adfc-8079d500564b	43e43238-8e97-4fe5-ae07-95f0e897a41c	https://picsum.photos/seed/suv-in-001-cover/1200/800	Toyota Innova cover	t	1	2026-01-30 16:32:13.877	2026-01-30 16:32:13.877
618c1a83-7d36-4d22-91f0-536a9638bc4b	43e43238-8e97-4fe5-ae07-95f0e897a41c	https://picsum.photos/seed/suv-in-001-1/1200/800	Toyota Innova gallery 1	f	2	2026-01-30 16:32:13.877	2026-01-30 16:32:13.877
67f2cc5f-056a-47e3-abda-a342eb8ec379	43e43238-8e97-4fe5-ae07-95f0e897a41c	https://picsum.photos/seed/suv-in-001-2/1200/800	Toyota Innova gallery 2	f	3	2026-01-30 16:32:13.877	2026-01-30 16:32:13.877
78e6de7c-b7ad-490f-a56a-99999a3d4bac	c04bdbaf-4db9-4116-9ba0-b54fb36606fa	https://picsum.photos/seed/suv-xu-002-cover/1200/800	Mahindra XUV700 cover	t	1	2026-01-30 16:32:13.88	2026-01-30 16:32:13.88
9d0dd51d-0ff9-4090-8a57-914c3ea04a6a	c04bdbaf-4db9-4116-9ba0-b54fb36606fa	https://picsum.photos/seed/suv-xu-002-1/1200/800	Mahindra XUV700 gallery 1	f	2	2026-01-30 16:32:13.88	2026-01-30 16:32:13.88
2f8470cf-e3c7-4f93-94f4-7e82c438a6b1	c04bdbaf-4db9-4116-9ba0-b54fb36606fa	https://picsum.photos/seed/suv-xu-002-2/1200/800	Mahindra XUV700 gallery 2	f	3	2026-01-30 16:32:13.88	2026-01-30 16:32:13.88
290a82c6-5901-4709-bbe5-8ea21474f997	e49fd8d7-07b7-4759-b24f-5b5e4f8ebab4	https://picsum.photos/seed/tmp-12-001-cover/1200/800	Tempo Traveller 12 cover	t	1	2026-01-30 16:32:13.882	2026-01-30 16:32:13.882
d5c3a870-3dc7-482e-8056-ce0381c3a573	e49fd8d7-07b7-4759-b24f-5b5e4f8ebab4	https://picsum.photos/seed/tmp-12-001-1/1200/800	Tempo Traveller 12 gallery 1	f	2	2026-01-30 16:32:13.882	2026-01-30 16:32:13.882
2aa42556-8952-447a-9ce0-ce696b4c3f9c	e49fd8d7-07b7-4759-b24f-5b5e4f8ebab4	https://picsum.photos/seed/tmp-12-001-2/1200/800	Tempo Traveller 12 gallery 2	f	3	2026-01-30 16:32:13.882	2026-01-30 16:32:13.882
4be8b3e8-2ef0-450a-b71a-8bfd9aee4819	418d16ac-911f-4c53-b98c-bf354b0c68e5	https://picsum.photos/seed/tmp-14-002-cover/1200/800	Tempo Traveller 14 cover	t	1	2026-01-30 16:32:13.885	2026-01-30 16:32:13.885
2a22df50-3314-4a92-9bcb-7de5d997a334	418d16ac-911f-4c53-b98c-bf354b0c68e5	https://picsum.photos/seed/tmp-14-002-1/1200/800	Tempo Traveller 14 gallery 1	f	2	2026-01-30 16:32:13.885	2026-01-30 16:32:13.885
13627a7a-4ad0-44b8-bb3b-4dc138677c11	418d16ac-911f-4c53-b98c-bf354b0c68e5	https://picsum.photos/seed/tmp-14-002-2/1200/800	Tempo Traveller 14 gallery 2	f	3	2026-01-30 16:32:13.885	2026-01-30 16:32:13.885
ce2d0499-3a7a-495c-b944-f6ac13e8afc0	5e89bfce-5f26-4f84-9249-bd489a510cbe	https://picsum.photos/seed/bus-32-001-cover/1200/800	Mini Bus 32 cover	t	1	2026-01-30 16:32:13.887	2026-01-30 16:32:13.887
6ef48a5f-9e9c-4917-878d-8fb8774a8e99	5e89bfce-5f26-4f84-9249-bd489a510cbe	https://picsum.photos/seed/bus-32-001-1/1200/800	Mini Bus 32 gallery 1	f	2	2026-01-30 16:32:13.887	2026-01-30 16:32:13.887
a87b2739-2f86-4a1f-984e-38bf1a4e7a19	5e89bfce-5f26-4f84-9249-bd489a510cbe	https://picsum.photos/seed/bus-32-001-2/1200/800	Mini Bus 32 gallery 2	f	3	2026-01-30 16:32:13.887	2026-01-30 16:32:13.887
0671fa24-a18d-4207-9d27-524fc28dba24	1e6e1240-f6a3-4c28-be3f-b05d12dfe77a	https://picsum.photos/seed/bus-45-002-cover/1200/800	Luxury Coach 45 cover	t	1	2026-01-30 16:32:13.89	2026-01-30 16:32:13.89
c993a030-6d23-4a2b-b00c-eb618d731591	1e6e1240-f6a3-4c28-be3f-b05d12dfe77a	https://picsum.photos/seed/bus-45-002-1/1200/800	Luxury Coach 45 gallery 1	f	2	2026-01-30 16:32:13.89	2026-01-30 16:32:13.89
3cae4e0c-1434-4a58-8362-6e11a03f7d52	1e6e1240-f6a3-4c28-be3f-b05d12dfe77a	https://picsum.photos/seed/bus-45-002-2/1200/800	Luxury Coach 45 gallery 2	f	3	2026-01-30 16:32:13.89	2026-01-30 16:32:13.89
676dfe78-8637-4b0f-98aa-88afc55db67f	9f99fbd0-858e-46e3-9b08-15f382813803	https://picsum.photos/seed/sed-au-003-cover/1200/800	Hyundai Aura cover	t	1	2026-02-01 16:11:36.234	2026-02-01 16:11:36.234
518211f8-e384-4c99-bb92-65fd629fdf2e	9f99fbd0-858e-46e3-9b08-15f382813803	https://picsum.photos/seed/sed-au-003-1/1200/800	Hyundai Aura gallery 1	f	2	2026-02-01 16:11:36.234	2026-02-01 16:11:36.234
ebc7b155-057c-49e4-b779-9873361bc7a8	9f99fbd0-858e-46e3-9b08-15f382813803	https://picsum.photos/seed/sed-au-003-2/1200/800	Hyundai Aura gallery 2	f	3	2026-02-01 16:11:36.234	2026-02-01 16:11:36.234
7a1d2288-9629-47d5-acd9-2d157b48a823	7cb6e453-b49c-460c-849f-2088087a339d	https://picsum.photos/seed/suv-kc-003-cover/1200/800	Kia Carens cover	t	1	2026-02-01 16:11:36.258	2026-02-01 16:11:36.258
52f3ace4-4dd3-485f-8fdd-2b967e1021ca	7cb6e453-b49c-460c-849f-2088087a339d	https://picsum.photos/seed/suv-kc-003-1/1200/800	Kia Carens gallery 1	f	2	2026-02-01 16:11:36.258	2026-02-01 16:11:36.258
6dfbb40f-3e66-49cc-ae4e-ea2013c623bd	7cb6e453-b49c-460c-849f-2088087a339d	https://picsum.photos/seed/suv-kc-003-2/1200/800	Kia Carens gallery 2	f	3	2026-02-01 16:11:36.258	2026-02-01 16:11:36.258
be4b031a-9acf-4ce1-90fa-9fdf7520fe97	f3076517-03f5-40d0-a995-d6026bb515ed	https://picsum.photos/seed/tmp-16-003-cover/1200/800	Tempo Traveller 16 cover	t	1	2026-02-01 16:11:36.261	2026-02-01 16:11:36.261
bd72ee0d-2b18-4967-84f5-43f59a0faad9	f3076517-03f5-40d0-a995-d6026bb515ed	https://picsum.photos/seed/tmp-16-003-1/1200/800	Tempo Traveller 16 gallery 1	f	2	2026-02-01 16:11:36.261	2026-02-01 16:11:36.261
79a5bf25-a65e-4bf4-87e6-e3cc9c363ea9	f3076517-03f5-40d0-a995-d6026bb515ed	https://picsum.photos/seed/tmp-16-003-2/1200/800	Tempo Traveller 16 gallery 2	f	3	2026-02-01 16:11:36.261	2026-02-01 16:11:36.261
bf7754f1-3e29-4322-8a0c-0d011fc7a4d0	a898c3e5-da04-4f88-9557-960a37df5c3c	https://picsum.photos/seed/bus-40-003-cover/1200/800	Mini Coach 40 cover	t	1	2026-02-01 16:11:36.264	2026-02-01 16:11:36.264
a2af9e4b-b864-4ba2-bb4b-e00701c62f64	a898c3e5-da04-4f88-9557-960a37df5c3c	https://picsum.photos/seed/bus-40-003-1/1200/800	Mini Coach 40 gallery 1	f	2	2026-02-01 16:11:36.264	2026-02-01 16:11:36.264
bb53b62b-715e-42f3-a6bd-3bbd72436849	a898c3e5-da04-4f88-9557-960a37df5c3c	https://picsum.photos/seed/bus-40-003-2/1200/800	Mini Coach 40 gallery 2	f	3	2026-02-01 16:11:36.264	2026-02-01 16:11:36.264
\.


--
-- Data for Name: vehicles; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.vehicles (id, "categoryId", "seatConfigId", name, code, brand, model, "modelYear", "fuelType", transmission, color, "isActive", "createdAt", "updatedAt") FROM stdin;
9f99fbd0-858e-46e3-9b08-15f382813803	2fc930a9-cb52-4813-b0a9-5dff78121d1c	a9f8de2e-a70d-4e99-8841-c4946af239a7	Hyundai Aura	SED-AU-003	Hyundai	Aura	2024	Petrol	Manual	Red	t	2026-02-01 16:11:36.01	2026-02-01 18:52:17.707
7cb6e453-b49c-460c-849f-2088087a339d	48c33bc8-491d-4c86-9b00-75f89903d72a	8c84ac34-cbb1-44b6-b934-7f76bab8b680	Kia Carens	SUV-KC-003	Kia	Carens	2024	Diesel	Automatic	Grey	t	2026-02-01 16:11:36.097	2026-02-01 18:52:17.709
f3076517-03f5-40d0-a995-d6026bb515ed	04cc25fc-7d90-4f07-aae8-250b6f9946d8	174a3ff3-c5c1-4239-a062-1a45b9e4eae7	Tempo Traveller 16	TMP-16-003	Force	Traveller	2024	Diesel	Manual	White	t	2026-02-01 16:11:36.099	2026-02-01 18:52:17.711
a898c3e5-da04-4f88-9557-960a37df5c3c	23419a74-bb7b-422a-8dbf-af15d8ca56ab	f0c135b0-311b-4be1-ac20-5b7658d0d3a9	Mini Coach 40	BUS-40-003	Tata	LP 512	2023	Diesel	Manual	Blue	t	2026-02-01 16:11:36.101	2026-02-01 18:52:17.714
9fd07256-aafb-4772-9028-5750fa61c907	2fc930a9-cb52-4813-b0a9-5dff78121d1c	a9f8de2e-a70d-4e99-8841-c4946af239a7	Toyota Etios	SED-ET-001	Toyota	Etios	2022	Diesel	Manual	White	t	2026-01-30 16:32:13.711	2026-02-01 18:52:17.688
bd6ab8d2-eefe-4731-819b-10c6cdaf0c9f	2fc930a9-cb52-4813-b0a9-5dff78121d1c	a9f8de2e-a70d-4e99-8841-c4946af239a7	Maruti Dzire	SED-DZ-002	Maruti	Dzire	2023	Petrol	Manual	Silver	t	2026-01-30 16:32:13.734	2026-02-01 18:52:17.691
43e43238-8e97-4fe5-ae07-95f0e897a41c	48c33bc8-491d-4c86-9b00-75f89903d72a	8c84ac34-cbb1-44b6-b934-7f76bab8b680	Toyota Innova	SUV-IN-001	Toyota	Innova Crysta	2023	Diesel	Automatic	Black	t	2026-01-30 16:32:13.738	2026-02-01 18:52:17.694
c04bdbaf-4db9-4116-9ba0-b54fb36606fa	48c33bc8-491d-4c86-9b00-75f89903d72a	6308297a-5560-4f45-ab71-acd69f9c22c6	Mahindra XUV700	SUV-XU-002	Mahindra	XUV700	2024	Diesel	Automatic	Blue	t	2026-01-30 16:32:13.743	2026-02-01 18:52:17.697
e49fd8d7-07b7-4759-b24f-5b5e4f8ebab4	04cc25fc-7d90-4f07-aae8-250b6f9946d8	eb03bf32-c8fb-4b94-9ba2-e382cbcc547b	Tempo Traveller 12	TMP-12-001	Force	Traveller	2022	Diesel	Manual	White	t	2026-01-30 16:32:13.75	2026-02-01 18:52:17.699
418d16ac-911f-4c53-b98c-bf354b0c68e5	04cc25fc-7d90-4f07-aae8-250b6f9946d8	2116c06f-8d09-41c1-9e82-17fb080bc72b	Tempo Traveller 14	TMP-14-002	Force	Traveller	2023	Diesel	Manual	White	t	2026-01-30 16:32:13.759	2026-02-01 18:52:17.701
5e89bfce-5f26-4f84-9249-bd489a510cbe	23419a74-bb7b-422a-8dbf-af15d8ca56ab	43014a76-21e9-4da7-87e6-c75cc8001701	Mini Bus 32	BUS-32-001	Tata	LP 410	2021	Diesel	Manual	White	t	2026-01-30 16:32:13.766	2026-02-01 18:52:17.703
1e6e1240-f6a3-4c28-be3f-b05d12dfe77a	23419a74-bb7b-422a-8dbf-af15d8ca56ab	15975698-8433-4241-a0e9-18c398474b2b	Luxury Coach 45	BUS-45-002	Ashok Leyland	Luxury Coach	2022	Diesel	Manual	Black	t	2026-01-30 16:32:13.773	2026-02-01 18:52:17.705
\.


--
-- Data for Name: webhook_events; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.webhook_events (id, provider, event_id, received_at, payload_json) FROM stdin;
1	RAZORPAY	payment.failed:pay_test_123	2026-02-04 22:25:38.292688+03	{"event": "payment.failed", "payload": {"payment": {"entity": {"id": "pay_test_123", "status": "failed"}}}}
\.


--
-- Data for Name: wishlist_items; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.wishlist_items (id, wishlist_id, property_id, created_at) FROM stdin;
1	1	85	2026-01-08 23:53:47.757643+03
\.


--
-- Data for Name: wishlists; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.wishlists (id, guest_id, created_at, updated_at) FROM stdin;
1	4	2026-01-08 23:53:47.647212+03	2026-01-08 23:53:47.647212+03
\.



--
-- Name: _prisma_migrations _prisma_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public._prisma_migrations
    ADD CONSTRAINT _prisma_migrations_pkey PRIMARY KEY (id);


--
-- Name: admin_adjustments admin_adjustments_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.admin_adjustments
    ADD CONSTRAINT admin_adjustments_pkey PRIMARY KEY (id);


--
-- Name: admin_audit_logs admin_audit_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.admin_audit_logs
    ADD CONSTRAINT admin_audit_logs_pkey PRIMARY KEY (id);


--
-- Name: admin_conversation_notes admin_conversation_notes_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.admin_conversation_notes
    ADD CONSTRAINT admin_conversation_notes_pkey PRIMARY KEY (id);


--
-- Name: amenities amenities_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.amenities
    ADD CONSTRAINT amenities_pkey PRIMARY KEY (id);


--
-- Name: api_integrations api_integrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.api_integrations
    ADD CONSTRAINT api_integrations_pkey PRIMARY KEY (id);


--
-- Name: audit_logs audit_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit_logs
    ADD CONSTRAINT audit_logs_pkey PRIMARY KEY (id);


--
-- Name: availability_blocks availability_blocks_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.availability_blocks
    ADD CONSTRAINT availability_blocks_pkey PRIMARY KEY (id);


--
-- Name: banners banners_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.banners
    ADD CONSTRAINT banners_pkey PRIMARY KEY (id);


--
-- Name: blog_posts blog_posts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.blog_posts
    ADD CONSTRAINT blog_posts_pkey PRIMARY KEY (id);


--
-- Name: blog_posts blog_posts_slug_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.blog_posts
    ADD CONSTRAINT blog_posts_slug_unique UNIQUE (slug);


--
-- Name: blogs blogs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.blogs
    ADD CONSTRAINT blogs_pkey PRIMARY KEY (id);


--
-- Name: blogs blogs_slug_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.blogs
    ADD CONSTRAINT blogs_slug_key UNIQUE (slug);


--
-- Name: booking_discounts booking_discounts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking_discounts
    ADD CONSTRAINT booking_discounts_pkey PRIMARY KEY (id);


--
-- Name: booking_events booking_events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking_events
    ADD CONSTRAINT booking_events_pkey PRIMARY KEY (id);


--
-- Name: booking_items booking_items_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking_items
    ADD CONSTRAINT booking_items_pkey PRIMARY KEY (id);


--
-- Name: booking_notes booking_notes_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking_notes
    ADD CONSTRAINT booking_notes_pkey PRIMARY KEY (id);


--
-- Name: bookings bookings_booking_code_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bookings
    ADD CONSTRAINT bookings_booking_code_unique UNIQUE (booking_code);


--
-- Name: bookings bookings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bookings
    ADD CONSTRAINT bookings_pkey PRIMARY KEY (id);


--
-- Name: cab_amenities cab_amenities_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cab_amenities
    ADD CONSTRAINT cab_amenities_pkey PRIMARY KEY (id);


--
-- Name: cab_amenities cab_amenities_slug_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cab_amenities
    ADD CONSTRAINT cab_amenities_slug_key UNIQUE (slug);


--
-- Name: cab_packages cab_packages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cab_packages
    ADD CONSTRAINT cab_packages_pkey PRIMARY KEY (id);


--
-- Name: cab_packages cab_packages_slug_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cab_packages
    ADD CONSTRAINT cab_packages_slug_key UNIQUE (slug);


--
-- Name: cabs_hero_banners cabs_hero_banners_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cabs_hero_banners
    ADD CONSTRAINT cabs_hero_banners_pkey PRIMARY KEY (id);


--
-- Name: cabs_vehicle_banners cabs_vehicle_banners_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cabs_vehicle_banners
    ADD CONSTRAINT cabs_vehicle_banners_pkey PRIMARY KEY (id);


--
-- Name: cancellation_policies cancellation_policies_code_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cancellation_policies
    ADD CONSTRAINT cancellation_policies_code_unique UNIQUE (code);


--
-- Name: cancellation_policies cancellation_policies_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cancellation_policies
    ADD CONSTRAINT cancellation_policies_pkey PRIMARY KEY (id);


--
-- Name: cancellation_requests cancellation_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cancellation_requests
    ADD CONSTRAINT cancellation_requests_pkey PRIMARY KEY (id);


--
-- Name: card_offers card_offers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.card_offers
    ADD CONSTRAINT card_offers_pkey PRIMARY KEY (id);


--
-- Name: channel_audit_logs channel_audit_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.channel_audit_logs
    ADD CONSTRAINT channel_audit_logs_pkey PRIMARY KEY (id);


--
-- Name: channel_events channel_events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.channel_events
    ADD CONSTRAINT channel_events_pkey PRIMARY KEY (id);


--
-- Name: channel_sync_jobs channel_sync_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.channel_sync_jobs
    ADD CONSTRAINT channel_sync_jobs_pkey PRIMARY KEY (id);


--
-- Name: cities cities_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cities
    ADD CONSTRAINT cities_pkey PRIMARY KEY (id);


--
-- Name: cities cities_state_id_code_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cities
    ADD CONSTRAINT cities_state_id_code_unique UNIQUE (state_id, code);


--
-- Name: clients clients_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.clients
    ADD CONSTRAINT clients_pkey PRIMARY KEY (id);


--
-- Name: conversation_events conversation_events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.conversation_events
    ADD CONSTRAINT conversation_events_pkey PRIMARY KEY (id);


--
-- Name: conversations conversations_booking_id_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.conversations
    ADD CONSTRAINT conversations_booking_id_unique UNIQUE (booking_id);


--
-- Name: conversations conversations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.conversations
    ADD CONSTRAINT conversations_pkey PRIMARY KEY (id);


--
-- Name: countries countries_code_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.countries
    ADD CONSTRAINT countries_code_unique UNIQUE (code);


--
-- Name: countries countries_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.countries
    ADD CONSTRAINT countries_pkey PRIMARY KEY (id);


--
-- Name: coupon_property_scope coupon_property_scope_coupon_id_property_id_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.coupon_property_scope
    ADD CONSTRAINT coupon_property_scope_coupon_id_property_id_unique UNIQUE (coupon_id, property_id);


--
-- Name: coupon_property_scope coupon_property_scope_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.coupon_property_scope
    ADD CONSTRAINT coupon_property_scope_pkey PRIMARY KEY (id);


--
-- Name: coupons coupons_code_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.coupons
    ADD CONSTRAINT coupons_code_unique UNIQUE (code);


--
-- Name: coupons coupons_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.coupons
    ADD CONSTRAINT coupons_pkey PRIMARY KEY (id);


--
-- Name: customer_reviews customer_reviews_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.customer_reviews
    ADD CONSTRAINT customer_reviews_pkey PRIMARY KEY (id);


--
-- Name: daily_rate_overrides daily_rate_overrides_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.daily_rate_overrides
    ADD CONSTRAINT daily_rate_overrides_pkey PRIMARY KEY (id);


--
-- Name: daily_rate_overrides daily_rate_overrides_property_id_rate_plan_id_date_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.daily_rate_overrides
    ADD CONSTRAINT daily_rate_overrides_property_id_rate_plan_id_date_unique UNIQUE (property_id, rate_plan_id, date);


--
-- Name: enquiry_leads enquiry_leads_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.enquiry_leads
    ADD CONSTRAINT enquiry_leads_pkey PRIMARY KEY (id);


--
-- Name: faqs faqs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.faqs
    ADD CONSTRAINT faqs_pkey PRIMARY KEY (id);


--
-- Name: fees fees_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.fees
    ADD CONSTRAINT fees_pkey PRIMARY KEY (id);


--
-- Name: footer_configs footer_configs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.footer_configs
    ADD CONSTRAINT footer_configs_pkey PRIMARY KEY (id);


--
-- Name: guest_trips guest_trips_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.guest_trips
    ADD CONSTRAINT guest_trips_pkey PRIMARY KEY (id);


--
-- Name: host_bank_accounts host_bank_accounts_host_id_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_bank_accounts
    ADD CONSTRAINT host_bank_accounts_host_id_unique UNIQUE (host_id);


--
-- Name: host_bank_accounts host_bank_accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_bank_accounts
    ADD CONSTRAINT host_bank_accounts_pkey PRIMARY KEY (id);


--
-- Name: host_earnings_ledger host_earnings_ledger_booking_id_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_earnings_ledger
    ADD CONSTRAINT host_earnings_ledger_booking_id_unique UNIQUE (booking_id);


--
-- Name: host_earnings_ledger host_earnings_ledger_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_earnings_ledger
    ADD CONSTRAINT host_earnings_ledger_pkey PRIMARY KEY (id);


--
-- Name: host_kyc_documents host_kyc_documents_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_kyc_documents
    ADD CONSTRAINT host_kyc_documents_pkey PRIMARY KEY (id);


--
-- Name: host_kyc host_kyc_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_kyc
    ADD CONSTRAINT host_kyc_pkey PRIMARY KEY (id);


--
-- Name: host_kyc_submissions host_kyc_submissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_kyc_submissions
    ADD CONSTRAINT host_kyc_submissions_pkey PRIMARY KEY (id);


--
-- Name: host_payout_accounts host_payout_accounts_host_id_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_payout_accounts
    ADD CONSTRAINT host_payout_accounts_host_id_unique UNIQUE (host_id);


--
-- Name: host_payout_accounts host_payout_accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_payout_accounts
    ADD CONSTRAINT host_payout_accounts_pkey PRIMARY KEY (id);


--
-- Name: host_payout_events host_payout_events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_payout_events
    ADD CONSTRAINT host_payout_events_pkey PRIMARY KEY (id);


--
-- Name: host_stripe_accounts host_stripe_accounts_host_id_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_stripe_accounts
    ADD CONSTRAINT host_stripe_accounts_host_id_unique UNIQUE (host_id);


--
-- Name: host_stripe_accounts host_stripe_accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_stripe_accounts
    ADD CONSTRAINT host_stripe_accounts_pkey PRIMARY KEY (id);


--
-- Name: host_stripe_accounts host_stripe_accounts_stripe_account_id_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_stripe_accounts
    ADD CONSTRAINT host_stripe_accounts_stripe_account_id_unique UNIQUE (stripe_account_id);


--
-- Name: invoices invoices_booking_id_invoice_type_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invoices
    ADD CONSTRAINT invoices_booking_id_invoice_type_unique UNIQUE (booking_id, invoice_type);


--
-- Name: invoices invoices_invoice_number_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invoices
    ADD CONSTRAINT invoices_invoice_number_unique UNIQUE (invoice_number);


--
-- Name: invoices invoices_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invoices
    ADD CONSTRAINT invoices_pkey PRIMARY KEY (id);


--
-- Name: knex_migrations_lock knex_migrations_lock_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.knex_migrations_lock
    ADD CONSTRAINT knex_migrations_lock_pkey PRIMARY KEY (index);


--
-- Name: knex_migrations knex_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.knex_migrations
    ADD CONSTRAINT knex_migrations_pkey PRIMARY KEY (id);


--
-- Name: landing_modules landing_modules_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.landing_modules
    ADD CONSTRAINT landing_modules_pkey PRIMARY KEY (id);


--
-- Name: ledger_accounts ledger_accounts_code_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.ledger_accounts
    ADD CONSTRAINT ledger_accounts_code_unique UNIQUE (code);


--
-- Name: ledger_accounts ledger_accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.ledger_accounts
    ADD CONSTRAINT ledger_accounts_pkey PRIMARY KEY (id);


--
-- Name: ledger_entries ledger_entries_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.ledger_entries
    ADD CONSTRAINT ledger_entries_pkey PRIMARY KEY (id);


--
-- Name: length_of_stay_discounts length_of_stay_discounts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.length_of_stay_discounts
    ADD CONSTRAINT length_of_stay_discounts_pkey PRIMARY KEY (id);


--
-- Name: location_nodes location_nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.location_nodes
    ADD CONSTRAINT location_nodes_pkey PRIMARY KEY (id);


--
-- Name: locations locations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.locations
    ADD CONSTRAINT locations_pkey PRIMARY KEY (id);


--
-- Name: locations locations_slug_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.locations
    ADD CONSTRAINT locations_slug_key UNIQUE (slug);


--
-- Name: message_reads message_reads_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.message_reads
    ADD CONSTRAINT message_reads_pkey PRIMARY KEY (message_id, user_id);


--
-- Name: messages messages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.messages
    ADD CONSTRAINT messages_pkey PRIMARY KEY (id);


--
-- Name: notification_templates notification_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.notification_templates
    ADD CONSTRAINT notification_templates_pkey PRIMARY KEY (id);


--
-- Name: occupancy_pricing_rules occupancy_pricing_rules_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.occupancy_pricing_rules
    ADD CONSTRAINT occupancy_pricing_rules_pkey PRIMARY KEY (id);


--
-- Name: payment_settings payment_settings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.payment_settings
    ADD CONSTRAINT payment_settings_pkey PRIMARY KEY (id);


--
-- Name: payouts payouts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.payouts
    ADD CONSTRAINT payouts_pkey PRIMARY KEY (id);


--
-- Name: platform_ledger_entries platform_ledger_entries_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.platform_ledger_entries
    ADD CONSTRAINT platform_ledger_entries_pkey PRIMARY KEY (id);


--
-- Name: policy_templates policy_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.policy_templates
    ADD CONSTRAINT policy_templates_pkey PRIMARY KEY (id);


--
-- Name: policy_templates policy_templates_slug_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.policy_templates
    ADD CONSTRAINT policy_templates_slug_unique UNIQUE (slug);


--
-- Name: popular_route_groups popular_route_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.popular_route_groups
    ADD CONSTRAINT popular_route_groups_pkey PRIMARY KEY (id);


--
-- Name: popular_route_items popular_route_items_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.popular_route_items
    ADD CONSTRAINT popular_route_items_pkey PRIMARY KEY (id);


--
-- Name: pricing_labels pricing_labels_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.pricing_labels
    ADD CONSTRAINT pricing_labels_name_unique UNIQUE (name);


--
-- Name: pricing_labels pricing_labels_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.pricing_labels
    ADD CONSTRAINT pricing_labels_pkey PRIMARY KEY (id);


--
-- Name: pricing_rule_sets pricing_rule_sets_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.pricing_rule_sets
    ADD CONSTRAINT pricing_rule_sets_name_unique UNIQUE (name);


--
-- Name: pricing_rule_sets pricing_rule_sets_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.pricing_rule_sets
    ADD CONSTRAINT pricing_rule_sets_pkey PRIMARY KEY (id);


--
-- Name: pricing_rules pricing_rules_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.pricing_rules
    ADD CONSTRAINT pricing_rules_pkey PRIMARY KEY (id);


--
-- Name: promo_code_properties promo_code_properties_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.promo_code_properties
    ADD CONSTRAINT promo_code_properties_pkey PRIMARY KEY (id);


--
-- Name: promo_code_properties promo_code_properties_promo_code_id_property_id_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.promo_code_properties
    ADD CONSTRAINT promo_code_properties_promo_code_id_property_id_unique UNIQUE (promo_code_id, property_id);


--
-- Name: promo_code_redemptions promo_code_redemptions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.promo_code_redemptions
    ADD CONSTRAINT promo_code_redemptions_pkey PRIMARY KEY (id);


--
-- Name: promo_codes promo_codes_code_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.promo_codes
    ADD CONSTRAINT promo_codes_code_unique UNIQUE (code);


--
-- Name: promo_codes promo_codes_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.promo_codes
    ADD CONSTRAINT promo_codes_pkey PRIMARY KEY (id);


--
-- Name: promo_videos promo_videos_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.promo_videos
    ADD CONSTRAINT promo_videos_pkey PRIMARY KEY (id);


--
-- Name: promotions promotions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.promotions
    ADD CONSTRAINT promotions_pkey PRIMARY KEY (id);


--
-- Name: properties properties_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.properties
    ADD CONSTRAINT properties_pkey PRIMARY KEY (id);


--
-- Name: properties properties_property_code_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.properties
    ADD CONSTRAINT properties_property_code_unique UNIQUE (property_code);


--
-- Name: properties properties_slug_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.properties
    ADD CONSTRAINT properties_slug_unique UNIQUE (slug);


--
-- Name: property_amenities property_amenities_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_amenities
    ADD CONSTRAINT property_amenities_pkey PRIMARY KEY (id);


--
-- Name: property_availability property_availability_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_availability
    ADD CONSTRAINT property_availability_pkey PRIMARY KEY (id);


--
-- Name: property_availability property_availability_property_id_date_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_availability
    ADD CONSTRAINT property_availability_property_id_date_unique UNIQUE (property_id, date);


--
-- Name: property_availability_rules property_availability_rules_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_availability_rules
    ADD CONSTRAINT property_availability_rules_pkey PRIMARY KEY (id);


--
-- Name: property_availability_rules property_availability_rules_property_id_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_availability_rules
    ADD CONSTRAINT property_availability_rules_property_id_unique UNIQUE (property_id);


--
-- Name: property_base_pricing property_base_pricing_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_base_pricing
    ADD CONSTRAINT property_base_pricing_pkey PRIMARY KEY (id);


--
-- Name: property_base_pricing property_base_pricing_property_id_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_base_pricing
    ADD CONSTRAINT property_base_pricing_property_id_unique UNIQUE (property_id);


--
-- Name: property_blackout_dates property_blackout_dates_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_blackout_dates
    ADD CONSTRAINT property_blackout_dates_pkey PRIMARY KEY (id);


--
-- Name: property_calendar_days property_calendar_days_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_calendar_days
    ADD CONSTRAINT property_calendar_days_pkey PRIMARY KEY (id);


--
-- Name: property_calendar_days property_calendar_days_property_id_date_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_calendar_days
    ADD CONSTRAINT property_calendar_days_property_id_date_unique UNIQUE (property_id, date);


--
-- Name: property_calendar_overrides property_calendar_overrides_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_calendar_overrides
    ADD CONSTRAINT property_calendar_overrides_pkey PRIMARY KEY (id);


--
-- Name: property_calendar_overrides property_calendar_overrides_property_id_date_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_calendar_overrides
    ADD CONSTRAINT property_calendar_overrides_property_id_date_unique UNIQUE (property_id, date);


--
-- Name: property_calendar property_calendar_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_calendar
    ADD CONSTRAINT property_calendar_pkey PRIMARY KEY (property_id, date);


--
-- Name: property_cancellation_policy property_cancellation_policy_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_cancellation_policy
    ADD CONSTRAINT property_cancellation_policy_pkey PRIMARY KEY (property_id);


--
-- Name: property_categories property_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_categories
    ADD CONSTRAINT property_categories_pkey PRIMARY KEY (id);


--
-- Name: property_categories property_categories_slug_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_categories
    ADD CONSTRAINT property_categories_slug_unique UNIQUE (slug);


--
-- Name: property_channel_mappings property_channel_mappings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_channel_mappings
    ADD CONSTRAINT property_channel_mappings_pkey PRIMARY KEY (id);


--
-- Name: property_images property_images_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_images
    ADD CONSTRAINT property_images_pkey PRIMARY KEY (id);


--
-- Name: property_policy_templates property_policy_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_policy_templates
    ADD CONSTRAINT property_policy_templates_pkey PRIMARY KEY (id);


--
-- Name: property_pricing_rules property_pricing_rules_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_pricing_rules
    ADD CONSTRAINT property_pricing_rules_pkey PRIMARY KEY (id);


--
-- Name: property_rating_stats property_rating_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_rating_stats
    ADD CONSTRAINT property_rating_stats_pkey PRIMARY KEY (property_id);


--
-- Name: property_room_types property_room_types_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_room_types
    ADD CONSTRAINT property_room_types_pkey PRIMARY KEY (id);


--
-- Name: property_services property_services_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_services
    ADD CONSTRAINT property_services_pkey PRIMARY KEY (id);


--
-- Name: property_services property_services_property_id_service_id_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_services
    ADD CONSTRAINT property_services_property_id_service_id_unique UNIQUE (property_id, service_id);


--
-- Name: property_spaces property_spaces_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_spaces
    ADD CONSTRAINT property_spaces_pkey PRIMARY KEY (id);


--
-- Name: property_types property_types_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_types
    ADD CONSTRAINT property_types_pkey PRIMARY KEY (id);


--
-- Name: property_types property_types_slug_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_types
    ADD CONSTRAINT property_types_slug_unique UNIQUE (slug);


--
-- Name: rate_plans rate_plans_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rate_plans
    ADD CONSTRAINT rate_plans_pkey PRIMARY KEY (id);


--
-- Name: review_events review_events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.review_events
    ADD CONSTRAINT review_events_pkey PRIMARY KEY (id);


--
-- Name: review_media review_media_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.review_media
    ADD CONSTRAINT review_media_pkey PRIMARY KEY (id);


--
-- Name: reviews reviews_booking_id_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_booking_id_unique UNIQUE (booking_id);


--
-- Name: reviews reviews_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_pkey PRIMARY KEY (review_id);


--
-- Name: routes routes_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.routes
    ADD CONSTRAINT routes_pkey PRIMARY KEY (id);


--
-- Name: seasonal_pricing seasonal_pricing_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.seasonal_pricing
    ADD CONSTRAINT seasonal_pricing_pkey PRIMARY KEY (id);


--
-- Name: seasonal_pricing_rules seasonal_pricing_rules_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.seasonal_pricing_rules
    ADD CONSTRAINT seasonal_pricing_rules_pkey PRIMARY KEY (id);


--
-- Name: seasonal_rates seasonal_rates_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.seasonal_rates
    ADD CONSTRAINT seasonal_rates_pkey PRIMARY KEY (id);


--
-- Name: seat_configs seat_configs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.seat_configs
    ADD CONSTRAINT seat_configs_pkey PRIMARY KEY (id);


--
-- Name: services services_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.services
    ADD CONSTRAINT services_pkey PRIMARY KEY (id);


--
-- Name: special_offer_rules special_offer_rules_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.special_offer_rules
    ADD CONSTRAINT special_offer_rules_pkey PRIMARY KEY (id);


--
-- Name: special_offers special_offers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.special_offers
    ADD CONSTRAINT special_offers_pkey PRIMARY KEY (id);


--
-- Name: states states_country_id_code_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.states
    ADD CONSTRAINT states_country_id_code_unique UNIQUE (country_id, code);


--
-- Name: states states_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.states
    ADD CONSTRAINT states_pkey PRIMARY KEY (id);


--
-- Name: static_pages static_pages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.static_pages
    ADD CONSTRAINT static_pages_pkey PRIMARY KEY (id);


--
-- Name: static_pages static_pages_slug_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.static_pages
    ADD CONSTRAINT static_pages_slug_unique UNIQUE (slug);


--
-- Name: support_messages support_messages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.support_messages
    ADD CONSTRAINT support_messages_pkey PRIMARY KEY (id);


--
-- Name: support_tickets support_tickets_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.support_tickets
    ADD CONSTRAINT support_tickets_pkey PRIMARY KEY (id);


--
-- Name: support_tickets support_tickets_ticket_number_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.support_tickets
    ADD CONSTRAINT support_tickets_ticket_number_unique UNIQUE (ticket_number);


--
-- Name: tax_rules tax_rules_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tax_rules
    ADD CONSTRAINT tax_rules_pkey PRIMARY KEY (id);


--
-- Name: taxes_and_fees_rules taxes_and_fees_rules_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.taxes_and_fees_rules
    ADD CONSTRAINT taxes_and_fees_rules_pkey PRIMARY KEY (id);


--
-- Name: taxes_fees taxes_fees_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.taxes_fees
    ADD CONSTRAINT taxes_fees_pkey PRIMARY KEY (id);


--
-- Name: tour_bookings tour_bookings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tour_bookings
    ADD CONSTRAINT tour_bookings_pkey PRIMARY KEY (id);


--
-- Name: tours tours_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tours
    ADD CONSTRAINT tours_pkey PRIMARY KEY (id);


--
-- Name: transactions transactions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transactions
    ADD CONSTRAINT transactions_pkey PRIMARY KEY (id);


--
-- Name: transport_package_media transport_package_media_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transport_package_media
    ADD CONSTRAINT transport_package_media_pkey PRIMARY KEY (id);


--
-- Name: transport_package_variants transport_package_variants_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transport_package_variants
    ADD CONSTRAINT transport_package_variants_pkey PRIMARY KEY (id);


--
-- Name: transport_packages transport_packages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transport_packages
    ADD CONSTRAINT transport_packages_pkey PRIMARY KEY (id);


--
-- Name: transport_packages transport_packages_slug_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transport_packages
    ADD CONSTRAINT transport_packages_slug_key UNIQUE (slug);


--
-- Name: travel_custom_tour_requests travel_custom_tour_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_custom_tour_requests
    ADD CONSTRAINT travel_custom_tour_requests_pkey PRIMARY KEY (id);


--
-- Name: travel_newsletter_subscribers travel_newsletter_subscribers_email_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_newsletter_subscribers
    ADD CONSTRAINT travel_newsletter_subscribers_email_unique UNIQUE (email);


--
-- Name: travel_newsletter_subscribers travel_newsletter_subscribers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_newsletter_subscribers
    ADD CONSTRAINT travel_newsletter_subscribers_pkey PRIMARY KEY (id);


--
-- Name: travel_package_articles travel_package_articles_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_articles
    ADD CONSTRAINT travel_package_articles_pkey PRIMARY KEY (id);


--
-- Name: travel_package_articles travel_package_articles_slug_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_articles
    ADD CONSTRAINT travel_package_articles_slug_unique UNIQUE (slug);


--
-- Name: travel_package_destinations travel_package_destinations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_destinations
    ADD CONSTRAINT travel_package_destinations_pkey PRIMARY KEY (id);


--
-- Name: travel_package_destinations travel_package_destinations_slug_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_destinations
    ADD CONSTRAINT travel_package_destinations_slug_unique UNIQUE (slug);


--
-- Name: travel_package_enquiries travel_package_enquiries_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_enquiries
    ADD CONSTRAINT travel_package_enquiries_pkey PRIMARY KEY (id);


--
-- Name: travel_package_images travel_package_images_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_images
    ADD CONSTRAINT travel_package_images_pkey PRIMARY KEY (id);


--
-- Name: travel_package_itineraries travel_package_itineraries_package_id_day_number_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_itineraries
    ADD CONSTRAINT travel_package_itineraries_package_id_day_number_unique UNIQUE (package_id, day_number);


--
-- Name: travel_package_itineraries travel_package_itineraries_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_itineraries
    ADD CONSTRAINT travel_package_itineraries_pkey PRIMARY KEY (id);


--
-- Name: travel_package_landing_config travel_package_landing_config_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_landing_config
    ADD CONSTRAINT travel_package_landing_config_pkey PRIMARY KEY (id);


--
-- Name: travel_package_listing_config travel_package_listing_config_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_listing_config
    ADD CONSTRAINT travel_package_listing_config_pkey PRIMARY KEY (id);


--
-- Name: travel_package_offers travel_package_offers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_offers
    ADD CONSTRAINT travel_package_offers_pkey PRIMARY KEY (id);


--
-- Name: travel_package_testimonials travel_package_testimonials_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_testimonials
    ADD CONSTRAINT travel_package_testimonials_pkey PRIMARY KEY (id);


--
-- Name: travel_package_theme_links travel_package_theme_links_package_id_theme_id_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_theme_links
    ADD CONSTRAINT travel_package_theme_links_package_id_theme_id_unique UNIQUE (package_id, theme_id);


--
-- Name: travel_package_theme_links travel_package_theme_links_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_theme_links
    ADD CONSTRAINT travel_package_theme_links_pkey PRIMARY KEY (id);


--
-- Name: travel_package_themes travel_package_themes_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_themes
    ADD CONSTRAINT travel_package_themes_pkey PRIMARY KEY (id);


--
-- Name: travel_package_themes travel_package_themes_slug_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_themes
    ADD CONSTRAINT travel_package_themes_slug_unique UNIQUE (slug);


--
-- Name: travel_packages travel_packages_package_code_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_packages
    ADD CONSTRAINT travel_packages_package_code_unique UNIQUE (package_code);


--
-- Name: travel_packages travel_packages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_packages
    ADD CONSTRAINT travel_packages_pkey PRIMARY KEY (id);


--
-- Name: travel_packages travel_packages_slug_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_packages
    ADD CONSTRAINT travel_packages_slug_unique UNIQUE (slug);


--
-- Name: property_policy_templates uq_property_policy_template; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_policy_templates
    ADD CONSTRAINT uq_property_policy_template UNIQUE (property_id, policy_template_id, policy_type);


--
-- Name: vehicle_amenities vehicle_amenities_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.vehicle_amenities
    ADD CONSTRAINT vehicle_amenities_pkey PRIMARY KEY (id);


--
-- Name: vehicle_categories vehicle_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.vehicle_categories
    ADD CONSTRAINT vehicle_categories_pkey PRIMARY KEY (id);


--
-- Name: vehicle_categories vehicle_categories_slug_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.vehicle_categories
    ADD CONSTRAINT vehicle_categories_slug_key UNIQUE (slug);


--
-- Name: vehicle_images vehicle_images_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.vehicle_images
    ADD CONSTRAINT vehicle_images_pkey PRIMARY KEY (id);


--
-- Name: vehicles vehicles_code_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.vehicles
    ADD CONSTRAINT vehicles_code_key UNIQUE (code);


--
-- Name: vehicles vehicles_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.vehicles
    ADD CONSTRAINT vehicles_pkey PRIMARY KEY (id);


--
-- Name: webhook_events webhook_events_event_id_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.webhook_events
    ADD CONSTRAINT webhook_events_event_id_unique UNIQUE (event_id);


--
-- Name: webhook_events webhook_events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.webhook_events
    ADD CONSTRAINT webhook_events_pkey PRIMARY KEY (id);


--
-- Name: wishlist_items wishlist_items_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.wishlist_items
    ADD CONSTRAINT wishlist_items_pkey PRIMARY KEY (id);


--
-- Name: wishlist_items wishlist_items_wishlist_id_property_id_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.wishlist_items
    ADD CONSTRAINT wishlist_items_wishlist_id_property_id_unique UNIQUE (wishlist_id, property_id);


--
-- Name: wishlists wishlists_guest_id_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.wishlists
    ADD CONSTRAINT wishlists_guest_id_unique UNIQUE (guest_id);


--
-- Name: wishlists wishlists_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.wishlists
    ADD CONSTRAINT wishlists_pkey PRIMARY KEY (id);


--
-- Name: admin_adjustments_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX admin_adjustments_host_id_index ON public.admin_adjustments USING btree (host_id);


--
-- Name: admin_conversation_notes_conversation_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX admin_conversation_notes_conversation_id_index ON public.admin_conversation_notes USING btree (conversation_id);


--
-- Name: availability_blocks_property_id_end_date_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX availability_blocks_property_id_end_date_index ON public.availability_blocks USING btree (property_id, end_date);


--
-- Name: availability_blocks_property_id_start_date_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX availability_blocks_property_id_start_date_index ON public.availability_blocks USING btree (property_id, start_date);


--
-- Name: booking_discounts_booking_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX booking_discounts_booking_id_index ON public.booking_discounts USING btree (booking_id);


--
-- Name: booking_events_booking_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX booking_events_booking_id_index ON public.booking_events USING btree (booking_id);


--
-- Name: booking_items_booking_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX booking_items_booking_id_index ON public.booking_items USING btree (booking_id);


--
-- Name: booking_notes_booking_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX booking_notes_booking_id_index ON public.booking_notes USING btree (booking_id);


--
-- Name: bookings_client_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX bookings_client_id_index ON public.bookings USING btree (client_id);


--
-- Name: bookings_customer_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX bookings_customer_id_index ON public.bookings USING btree (customer_id);


--
-- Name: bookings_guest_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX bookings_guest_id_index ON public.bookings USING btree (guest_id);


--
-- Name: bookings_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX bookings_host_id_index ON public.bookings USING btree (host_id);


--
-- Name: cancellation_requests_booking_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX cancellation_requests_booking_id_index ON public.cancellation_requests USING btree (booking_id);


--
-- Name: cities_state_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX cities_state_id_index ON public.cities USING btree (state_id);


--
-- Name: clients_email_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX clients_email_index ON public.clients USING btree (email);


--
-- Name: clients_phone_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX clients_phone_index ON public.clients USING btree (phone);


--
-- Name: conversation_events_conversation_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX conversation_events_conversation_id_index ON public.conversation_events USING btree (conversation_id);


--
-- Name: conversations_booking_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX conversations_booking_id_index ON public.conversations USING btree (booking_id);


--
-- Name: conversations_customer_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX conversations_customer_id_index ON public.conversations USING btree (customer_id);


--
-- Name: conversations_guest_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX conversations_guest_id_index ON public.conversations USING btree (guest_id);


--
-- Name: conversations_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX conversations_host_id_index ON public.conversations USING btree (host_id);


--
-- Name: conversations_property_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX conversations_property_id_index ON public.conversations USING btree (property_id);


--
-- Name: host_bank_accounts_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX host_bank_accounts_host_id_index ON public.host_bank_accounts USING btree (host_id);


--
-- Name: host_earnings_ledger_booking_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX host_earnings_ledger_booking_id_index ON public.host_earnings_ledger USING btree (booking_id);


--
-- Name: host_earnings_ledger_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX host_earnings_ledger_host_id_index ON public.host_earnings_ledger USING btree (host_id);


--
-- Name: host_earnings_ledger_property_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX host_earnings_ledger_property_id_index ON public.host_earnings_ledger USING btree (property_id);


--
-- Name: host_kyc_documents_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX host_kyc_documents_host_id_index ON public.host_kyc_documents USING btree (host_id);


--
-- Name: host_kyc_submissions_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX host_kyc_submissions_host_id_index ON public.host_kyc_submissions USING btree (host_id);


--
-- Name: host_payout_accounts_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX host_payout_accounts_host_id_index ON public.host_payout_accounts USING btree (host_id);


--
-- Name: host_payout_events_payout_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX host_payout_events_payout_id_index ON public.host_payout_events USING btree (payout_id);


--
-- Name: host_stripe_accounts_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX host_stripe_accounts_host_id_index ON public.host_stripe_accounts USING btree (host_id);


--
-- Name: idx_amenities_slug; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX idx_amenities_slug ON public.amenities USING btree (slug);


--
-- Name: idx_audit_logs_created_at; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_audit_logs_created_at ON public.audit_logs USING btree (created_at);


--
-- Name: idx_audit_logs_entity; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_audit_logs_entity ON public.audit_logs USING btree (entity_type, entity_id);


--
-- Name: idx_blogs_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_blogs_active ON public.blogs USING btree ("isActive");


--
-- Name: idx_blogs_published; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_blogs_published ON public.blogs USING btree ("publishedAt");


--
-- Name: idx_blogs_sort; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_blogs_sort ON public.blogs USING btree ("sortOrder");


--
-- Name: idx_booking_events_booking_created; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_booking_events_booking_created ON public.booking_events USING btree (booking_id, created_at DESC);


--
-- Name: idx_bookings_host_client_status_created; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_bookings_host_client_status_created ON public.bookings USING btree (host_id, client_id, booking_status, created_at);


--
-- Name: idx_bookings_host_property_status_created; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_bookings_host_property_status_created ON public.bookings USING btree (host_id, property_id, booking_status, created_at);


--
-- Name: idx_bookings_host_status_created; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_bookings_host_status_created ON public.bookings USING btree (host_id, booking_status, created_at);


--
-- Name: idx_bookings_property_dates; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_bookings_property_dates ON public.bookings USING btree (property_id, check_in_date, check_out_date) WHERE ((booking_status)::text = ANY ((ARRAY['confirmed'::character varying, 'paid'::character varying, 'checked_in'::character varying])::text[]));


--
-- Name: idx_bookings_property_dates_v3; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_bookings_property_dates_v3 ON public.bookings USING btree (property_id, check_in_date, check_out_date);


--
-- Name: idx_cab_amenities_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_cab_amenities_active ON public.cab_amenities USING btree ("isActive");


--
-- Name: idx_cab_amenities_category; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_cab_amenities_category ON public.cab_amenities USING btree (category);


--
-- Name: idx_cab_amenities_name; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_cab_amenities_name ON public.cab_amenities USING btree (name);


--
-- Name: idx_cab_packages_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_cab_packages_active ON public.cab_packages USING btree ("isActive");


--
-- Name: idx_cab_packages_category; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_cab_packages_category ON public.cab_packages USING btree ("vehicleCategoryId");


--
-- Name: idx_cab_packages_location; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_cab_packages_location ON public.cab_packages USING btree ("locationId");


--
-- Name: idx_cab_packages_seat; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_cab_packages_seat ON public.cab_packages USING btree ("seatConfigId");


--
-- Name: idx_cab_packages_trip; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_cab_packages_trip ON public.cab_packages USING btree ("tripType");


--
-- Name: idx_cabs_hero_banners_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_cabs_hero_banners_active ON public.cabs_hero_banners USING btree ("isActive");


--
-- Name: idx_cabs_hero_banners_sort; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_cabs_hero_banners_sort ON public.cabs_hero_banners USING btree ("sortOrder");


--
-- Name: idx_cabs_vehicle_banners_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_cabs_vehicle_banners_active ON public.cabs_vehicle_banners USING btree ("isActive");


--
-- Name: idx_cabs_vehicle_banners_sort; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_cabs_vehicle_banners_sort ON public.cabs_vehicle_banners USING btree ("sortOrder");


--
-- Name: idx_calendar_overrides_property_date; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_calendar_overrides_property_date ON public.property_calendar_overrides USING btree (property_id, date);


--
-- Name: idx_cancellation_requests_booking_unique; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX idx_cancellation_requests_booking_unique ON public.cancellation_requests USING btree (booking_id);


--
-- Name: idx_cancellation_requests_host_status; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_cancellation_requests_host_status ON public.cancellation_requests USING btree (host_id, status, requested_at DESC);


--
-- Name: idx_cancellation_requests_status_date; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_cancellation_requests_status_date ON public.cancellation_requests USING btree (status, requested_at DESC);


--
-- Name: idx_card_offers_host_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_card_offers_host_active ON public.card_offers USING btree (host_id, is_active);


--
-- Name: idx_card_offers_property_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_card_offers_property_active ON public.card_offers USING btree (property_id, is_active);


--
-- Name: idx_channel_audit_logs_admin_id; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_channel_audit_logs_admin_id ON public.channel_audit_logs USING btree (admin_id);


--
-- Name: idx_channel_events_connection_id; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_channel_events_connection_id ON public.channel_events USING btree (provider_connection_id);


--
-- Name: idx_channel_events_processed; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_channel_events_processed ON public.channel_events USING btree (processed);


--
-- Name: idx_channel_sync_jobs_mapping_id; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_channel_sync_jobs_mapping_id ON public.channel_sync_jobs USING btree (mapping_id);


--
-- Name: idx_channel_sync_jobs_status; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_channel_sync_jobs_status ON public.channel_sync_jobs USING btree (status);


--
-- Name: idx_conversations_booking; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_conversations_booking ON public.conversations USING btree (booking_id);


--
-- Name: idx_conversations_guest_last; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_conversations_guest_last ON public.conversations USING btree (guest_id, last_message_at DESC);


--
-- Name: idx_conversations_host_last; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_conversations_host_last ON public.conversations USING btree (host_id, last_message_at DESC);


--
-- Name: idx_coupons_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_coupons_active ON public.coupons USING btree ("isActive");


--
-- Name: idx_coupons_code; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_coupons_code ON public.coupons USING btree (code);


--
-- Name: idx_coupons_ends; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_coupons_ends ON public.coupons USING btree ("endsAt");


--
-- Name: idx_coupons_starts; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_coupons_starts ON public.coupons USING btree ("startsAt");


--
-- Name: idx_coupons_transport_package; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_coupons_transport_package ON public.coupons USING btree ("transportPackageId");


--
-- Name: idx_coupons_vehicle_category; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_coupons_vehicle_category ON public.coupons USING btree ("vehicleCategoryId");


--
-- Name: idx_earnings_host_created; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_earnings_host_created ON public.host_earnings_ledger USING btree (host_id, created_at DESC);


--
-- Name: idx_earnings_host_status; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_earnings_host_status ON public.host_earnings_ledger USING btree (host_id, earning_status);


--
-- Name: idx_earnings_payout; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_earnings_payout ON public.host_earnings_ledger USING btree (payout_id);


--
-- Name: idx_enquiry_leads_created; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_enquiry_leads_created ON public.enquiry_leads USING btree ("createdAt");


--
-- Name: idx_enquiry_leads_drop; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_enquiry_leads_drop ON public.enquiry_leads USING btree ("dropLocationId");


--
-- Name: idx_enquiry_leads_enquiry_date; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_enquiry_leads_enquiry_date ON public.enquiry_leads USING btree ("enquiryDate");


--
-- Name: idx_enquiry_leads_pickup; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_enquiry_leads_pickup ON public.enquiry_leads USING btree ("pickupLocationId");


--
-- Name: idx_enquiry_leads_route; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_enquiry_leads_route ON public.enquiry_leads USING btree ("routeId");


--
-- Name: idx_enquiry_leads_stage; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_enquiry_leads_stage ON public.enquiry_leads USING btree (stage);


--
-- Name: idx_enquiry_leads_status; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_enquiry_leads_status ON public.enquiry_leads USING btree (status);


--
-- Name: idx_enquiry_leads_trip_start; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_enquiry_leads_trip_start ON public.enquiry_leads USING btree ("tripStartDate");


--
-- Name: idx_enquiry_leads_type; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_enquiry_leads_type ON public.enquiry_leads USING btree ("enquiryType");


--
-- Name: idx_guest_trips_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_guest_trips_active ON public.guest_trips USING btree ("isActive");


--
-- Name: idx_guest_trips_date; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_guest_trips_date ON public.guest_trips USING btree ("tripDate");


--
-- Name: idx_guest_trips_sort; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_guest_trips_sort ON public.guest_trips USING btree ("sortOrder");


--
-- Name: idx_host_kyc_documents_host; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_host_kyc_documents_host ON public.host_kyc_documents USING btree (host_id);


--
-- Name: idx_host_payout_events_payout_created; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_host_payout_events_payout_created ON public.host_payout_events USING btree (payout_id, created_at DESC);


--
-- Name: idx_ledger_accounts_owner; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_ledger_accounts_owner ON public.ledger_accounts USING btree (owner_type, owner_id);


--
-- Name: idx_ledger_entries_created; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_ledger_entries_created ON public.ledger_entries USING btree (created_at DESC);


--
-- Name: idx_ledger_entries_credit; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_ledger_entries_credit ON public.ledger_entries USING btree (credit_account_id);


--
-- Name: idx_ledger_entries_debit; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_ledger_entries_debit ON public.ledger_entries USING btree (debit_account_id);


--
-- Name: idx_ledger_entries_reference; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_ledger_entries_reference ON public.ledger_entries USING btree (reference_type, reference_id);


--
-- Name: idx_locations_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_locations_active ON public.locations USING btree ("isActive");


--
-- Name: idx_locations_city; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_locations_city ON public.locations USING btree (city);


--
-- Name: idx_locations_country; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_locations_country ON public.locations USING btree (country);


--
-- Name: idx_locations_geo; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_locations_geo ON public.locations USING btree (latitude, longitude);


--
-- Name: idx_locations_name; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_locations_name ON public.locations USING btree (name);


--
-- Name: idx_locations_state; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_locations_state ON public.locations USING btree (state);


--
-- Name: idx_message_reads_user; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_message_reads_user ON public.message_reads USING btree (user_id);


--
-- Name: idx_messages_conversation_created; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_messages_conversation_created ON public.messages USING btree (conversation_id, created_at);


--
-- Name: idx_messages_sender_created; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_messages_sender_created ON public.messages USING btree (sender_type, created_at DESC);


--
-- Name: idx_payment_settings_singleton; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX idx_payment_settings_singleton ON public.payment_settings USING btree (singleton_id);


--
-- Name: idx_platform_ledger_account_created; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_platform_ledger_account_created ON public.platform_ledger_entries USING btree (account, created_at DESC);


--
-- Name: idx_popular_route_groups_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_popular_route_groups_active ON public.popular_route_groups USING btree ("isActive");


--
-- Name: idx_popular_route_groups_from; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_popular_route_groups_from ON public.popular_route_groups USING btree ("fromLocationId");


--
-- Name: idx_popular_route_groups_sort; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_popular_route_groups_sort ON public.popular_route_groups USING btree ("sortOrder");


--
-- Name: idx_popular_route_items_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_popular_route_items_active ON public.popular_route_items USING btree ("isActive");


--
-- Name: idx_popular_route_items_group; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_popular_route_items_group ON public.popular_route_items USING btree ("groupId");


--
-- Name: idx_popular_route_items_sort; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_popular_route_items_sort ON public.popular_route_items USING btree ("sortOrder");


--
-- Name: idx_popular_route_items_to; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_popular_route_items_to ON public.popular_route_items USING btree ("toLocationId");


--
-- Name: idx_pricing_rules_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_pricing_rules_active ON public.pricing_rules USING btree ("isActive");


--
-- Name: idx_pricing_rules_category; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_pricing_rules_category ON public.pricing_rules USING btree ("vehicleCategoryId");


--
-- Name: idx_pricing_rules_destination; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_pricing_rules_destination ON public.pricing_rules USING btree ("destinationLocationId");


--
-- Name: idx_pricing_rules_effective_from; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_pricing_rules_effective_from ON public.pricing_rules USING btree ("effectiveFrom");


--
-- Name: idx_pricing_rules_effective_to; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_pricing_rules_effective_to ON public.pricing_rules USING btree ("effectiveTo");


--
-- Name: idx_pricing_rules_origin; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_pricing_rules_origin ON public.pricing_rules USING btree ("originLocationId");


--
-- Name: idx_pricing_rules_route; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_pricing_rules_route ON public.pricing_rules USING btree ("routeId");


--
-- Name: idx_pricing_rules_seat; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_pricing_rules_seat ON public.pricing_rules USING btree ("seatConfigId");


--
-- Name: idx_pricing_rules_trip; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_pricing_rules_trip ON public.pricing_rules USING btree ("tripType");


--
-- Name: idx_promo_codes_host_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_promo_codes_host_active ON public.promo_codes USING btree (host_id, is_active);


--
-- Name: idx_promo_codes_property_dates; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_promo_codes_property_dates ON public.promo_codes USING btree (property_id, start_date, end_date);


--
-- Name: idx_promo_codes_scope_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_promo_codes_scope_active ON public.promo_codes USING btree (scope, is_active);


--
-- Name: idx_promo_redemptions_code_guest; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_promo_redemptions_code_guest ON public.promo_code_redemptions USING btree (promo_code_id, guest_id);


--
-- Name: idx_promo_videos_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_promo_videos_active ON public.promo_videos USING btree ("isActive");


--
-- Name: idx_promo_videos_sort; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_promo_videos_sort ON public.promo_videos USING btree ("sortOrder");


--
-- Name: idx_promotions_dates; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_promotions_dates ON public.promotions USING btree (start_date, end_date);


--
-- Name: idx_promotions_host_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_promotions_host_active ON public.promotions USING btree (host_id, is_active);


--
-- Name: idx_promotions_property_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_promotions_property_active ON public.promotions USING btree (property_id, is_active);


--
-- Name: idx_properties_city_state; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_properties_city_state ON public.properties USING btree (city, state);


--
-- Name: idx_properties_featured_trending; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_properties_featured_trending ON public.properties USING btree (is_featured, is_trending);


--
-- Name: idx_properties_luxury; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_properties_luxury ON public.properties USING btree (is_luxury);


--
-- Name: idx_properties_type_status; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_properties_type_status ON public.properties USING btree (property_type, status);


--
-- Name: idx_property_availability_prop_status_date; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_property_availability_prop_status_date ON public.property_availability USING btree (property_id, status, date);


--
-- Name: idx_property_availability_source_mapping; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_property_availability_source_mapping ON public.property_availability USING btree (source_mapping_id);


--
-- Name: idx_property_channel_mappings_connection_id; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_property_channel_mappings_connection_id ON public.property_channel_mappings USING btree (provider_connection_id);


--
-- Name: idx_property_channel_mappings_property_id; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_property_channel_mappings_property_id ON public.property_channel_mappings USING btree (property_id);


--
-- Name: idx_property_images_cover; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_property_images_cover ON public.property_images USING btree (property_id, is_cover);


--
-- Name: idx_property_images_property_id; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_property_images_property_id ON public.property_images USING btree (property_id);


--
-- Name: idx_review_events_review_created; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_review_events_review_created ON public.review_events USING btree (review_id, created_at DESC);


--
-- Name: idx_reviews_host_created; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_reviews_host_created ON public.reviews USING btree (host_id, created_at DESC);


--
-- Name: idx_reviews_property_created; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_reviews_property_created ON public.reviews USING btree (property_id, created_at DESC);


--
-- Name: idx_reviews_status_created; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_reviews_status_created ON public.reviews USING btree (status, created_at DESC);


--
-- Name: idx_routes_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_routes_active ON public.routes USING btree ("isActive");


--
-- Name: idx_routes_distance; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_routes_distance ON public.routes USING btree ("distanceKm");


--
-- Name: idx_routes_from; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_routes_from ON public.routes USING btree ("fromLocationId");


--
-- Name: idx_routes_to; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_routes_to ON public.routes USING btree ("toLocationId");


--
-- Name: idx_seasonal_pricing_active_dates; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_seasonal_pricing_active_dates ON public.seasonal_pricing_rules USING btree (is_active, start_date, end_date);


--
-- Name: idx_seasonal_pricing_host_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_seasonal_pricing_host_active ON public.seasonal_pricing_rules USING btree (host_id, is_active);


--
-- Name: idx_seasonal_pricing_property_dates; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_seasonal_pricing_property_dates ON public.seasonal_pricing_rules USING btree (property_id, start_date, end_date);


--
-- Name: idx_seat_configs_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_seat_configs_active ON public.seat_configs USING btree ("isActive");


--
-- Name: idx_seat_configs_capacity; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_seat_configs_capacity ON public.seat_configs USING btree ("seatCapacity");


--
-- Name: idx_special_offer_host_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_special_offer_host_active ON public.special_offer_rules USING btree (host_id, is_active);


--
-- Name: idx_special_offer_property_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_special_offer_property_active ON public.special_offer_rules USING btree (property_id, is_active);


--
-- Name: idx_support_messages_ticket_id; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_support_messages_ticket_id ON public.support_messages USING btree (ticket_id);


--
-- Name: idx_taxes_fees_host_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_taxes_fees_host_active ON public.taxes_and_fees_rules USING btree (host_id, is_active);


--
-- Name: idx_taxes_fees_scope_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_taxes_fees_scope_active ON public.taxes_and_fees_rules USING btree (scope, is_active);


--
-- Name: idx_tour_bookings_host_client_status_created; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_tour_bookings_host_client_status_created ON public.tour_bookings USING btree (host_id, client_id, status, created_at);


--
-- Name: idx_transport_package_media_cover; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_transport_package_media_cover ON public.transport_package_media USING btree ("isCover");


--
-- Name: idx_transport_package_media_package; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_transport_package_media_package ON public.transport_package_media USING btree ("packageId");


--
-- Name: idx_transport_package_media_sort; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_transport_package_media_sort ON public.transport_package_media USING btree ("sortOrder");


--
-- Name: idx_transport_package_variants_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_transport_package_variants_active ON public.transport_package_variants USING btree ("isActive");


--
-- Name: idx_transport_package_variants_category; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_transport_package_variants_category ON public.transport_package_variants USING btree ("vehicleCategoryId");


--
-- Name: idx_transport_package_variants_maxpax; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_transport_package_variants_maxpax ON public.transport_package_variants USING btree ("maxPax");


--
-- Name: idx_transport_package_variants_package; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_transport_package_variants_package ON public.transport_package_variants USING btree ("packageId");


--
-- Name: idx_transport_package_variants_price; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_transport_package_variants_price ON public.transport_package_variants USING btree ("priceTotal");


--
-- Name: idx_transport_package_variants_priority; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_transport_package_variants_priority ON public.transport_package_variants USING btree (priority);


--
-- Name: idx_transport_package_variants_seat; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_transport_package_variants_seat ON public.transport_package_variants USING btree ("seatConfigId");


--
-- Name: idx_transport_packages_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_transport_packages_active ON public.transport_packages USING btree ("isActive");


--
-- Name: idx_transport_packages_location; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_transport_packages_location ON public.transport_packages USING btree ("locationId");


--
-- Name: idx_transport_packages_sort; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_transport_packages_sort ON public.transport_packages USING btree ("sortOrder");


--
-- Name: idx_travel_package_enquiries_is_read; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_travel_package_enquiries_is_read ON public.travel_package_enquiries USING btree (is_read);


--
-- Name: idx_vehicle_categories_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_vehicle_categories_active ON public.vehicle_categories USING btree ("isActive");


--
-- Name: idx_vehicle_categories_name; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_vehicle_categories_name ON public.vehicle_categories USING btree (name);


--
-- Name: idx_vehicle_categories_sort; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_vehicle_categories_sort ON public.vehicle_categories USING btree ("sortOrder");


--
-- Name: idx_vehicle_images_cover; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_vehicle_images_cover ON public.vehicle_images USING btree ("isCover");


--
-- Name: idx_vehicle_images_sort; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_vehicle_images_sort ON public.vehicle_images USING btree ("sortOrder");


--
-- Name: idx_vehicle_images_vehicle; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_vehicle_images_vehicle ON public.vehicle_images USING btree ("vehicleId");


--
-- Name: idx_vehicles_active; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_vehicles_active ON public.vehicles USING btree ("isActive");


--
-- Name: idx_vehicles_category; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_vehicles_category ON public.vehicles USING btree ("categoryId");


--
-- Name: idx_vehicles_seatconfig; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_vehicles_seatconfig ON public.vehicles USING btree ("seatConfigId");


--
-- Name: idx_webhook_events_provider; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_webhook_events_provider ON public.webhook_events USING btree (provider);


--
-- Name: invoices_booking_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX invoices_booking_id_index ON public.invoices USING btree (booking_id);


--
-- Name: invoices_guest_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX invoices_guest_id_index ON public.invoices USING btree (guest_id);


--
-- Name: invoices_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX invoices_host_id_index ON public.invoices USING btree (host_id);


--
-- Name: invoices_invoice_type_issued_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX invoices_invoice_type_issued_at_index ON public.invoices USING btree (invoice_type, issued_at);


--
-- Name: location_nodes_type_parent_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX location_nodes_type_parent_id_index ON public.location_nodes USING btree (type, parent_id);


--
-- Name: messages_conversation_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX messages_conversation_id_index ON public.messages USING btree (conversation_id);


--
-- Name: payouts_booking_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX payouts_booking_id_index ON public.payouts USING btree (booking_id);


--
-- Name: payouts_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX payouts_host_id_index ON public.payouts USING btree (host_id);


--
-- Name: pricing_rule_sets_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX pricing_rule_sets_host_id_index ON public.pricing_rule_sets USING btree (host_id);


--
-- Name: pricing_rule_sets_property_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX pricing_rule_sets_property_id_index ON public.pricing_rule_sets USING btree (property_id);


--
-- Name: promo_code_properties_promo_code_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX promo_code_properties_promo_code_id_index ON public.promo_code_properties USING btree (promo_code_id);


--
-- Name: promo_code_properties_property_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX promo_code_properties_property_id_index ON public.promo_code_properties USING btree (property_id);


--
-- Name: promo_code_redemptions_promo_code_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX promo_code_redemptions_promo_code_id_index ON public.promo_code_redemptions USING btree (promo_code_id);


--
-- Name: promotions_host_id_active_start_date_end_date_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX promotions_host_id_active_start_date_end_date_index ON public.promotions USING btree (host_id, is_active, start_date, end_date);


--
-- Name: promotions_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX promotions_host_id_index ON public.promotions USING btree (host_id);


--
-- Name: promotions_property_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX promotions_property_id_index ON public.promotions USING btree (property_id);


--
-- Name: properties_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX properties_host_id_index ON public.properties USING btree (host_id);


--
-- Name: property_amenities_amenity_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX property_amenities_amenity_id_index ON public.property_amenities USING btree (amenity_id);


--
-- Name: property_amenities_property_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX property_amenities_property_id_index ON public.property_amenities USING btree (property_id);


--
-- Name: property_availability_rules_property_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX property_availability_rules_property_id_index ON public.property_availability_rules USING btree (property_id);


--
-- Name: property_base_pricing_property_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX property_base_pricing_property_id_index ON public.property_base_pricing USING btree (property_id);


--
-- Name: property_blackout_dates_property_id_start_date_end_date_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX property_blackout_dates_property_id_start_date_end_date_index ON public.property_blackout_dates USING btree (property_id, start_date, end_date);


--
-- Name: property_calendar_days_property_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX property_calendar_days_property_id_index ON public.property_calendar_days USING btree (property_id);


--
-- Name: property_calendar_overrides_property_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX property_calendar_overrides_property_id_index ON public.property_calendar_overrides USING btree (property_id);


--
-- Name: property_calendar_property_id_date_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX property_calendar_property_id_date_index ON public.property_calendar USING btree (property_id, date);


--
-- Name: property_pricing_rules_property_id_rule_type_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX property_pricing_rules_property_id_rule_type_index ON public.property_pricing_rules USING btree (property_id, rule_type);


--
-- Name: property_pricing_rules_property_id_start_date_end_date_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX property_pricing_rules_property_id_start_date_end_date_index ON public.property_pricing_rules USING btree (property_id, start_date, end_date);


--
-- Name: property_room_types_property_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX property_room_types_property_id_index ON public.property_room_types USING btree (property_id);


--
-- Name: rate_plans_property_id_name_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX rate_plans_property_id_name_index ON public.rate_plans USING btree (property_id, name);


--
-- Name: review_events_review_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX review_events_review_id_index ON public.review_events USING btree (review_id);


--
-- Name: reviews_guest_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX reviews_guest_id_index ON public.reviews USING btree (guest_id);


--
-- Name: reviews_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX reviews_host_id_index ON public.reviews USING btree (host_id);


--
-- Name: routes_from_to_unique; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX routes_from_to_unique ON public.routes USING btree ("fromLocationId", "toLocationId");


--
-- Name: seasonal_pricing_rules_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX seasonal_pricing_rules_host_id_index ON public.seasonal_pricing_rules USING btree (host_id);


--
-- Name: seasonal_pricing_rules_property_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX seasonal_pricing_rules_property_id_index ON public.seasonal_pricing_rules USING btree (property_id);


--
-- Name: seasonal_rates_property_id_start_date_end_date_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX seasonal_rates_property_id_start_date_end_date_index ON public.seasonal_rates USING btree (property_id, start_date, end_date);


--
-- Name: special_offer_rules_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX special_offer_rules_host_id_index ON public.special_offer_rules USING btree (host_id);


--
-- Name: special_offer_rules_property_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX special_offer_rules_property_id_index ON public.special_offer_rules USING btree (property_id);


--
-- Name: states_country_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX states_country_id_index ON public.states USING btree (country_id);


--
-- Name: support_messages_ticket_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX support_messages_ticket_id_index ON public.support_messages USING btree (ticket_id);


--
-- Name: support_tickets_created_by_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX support_tickets_created_by_index ON public.support_tickets USING btree (created_by);


--
-- Name: support_tickets_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX support_tickets_host_id_index ON public.support_tickets USING btree (host_id);


--
-- Name: support_tickets_ticket_number_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX support_tickets_ticket_number_index ON public.support_tickets USING btree (ticket_number);


--
-- Name: taxes_and_fees_rules_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX taxes_and_fees_rules_host_id_index ON public.taxes_and_fees_rules USING btree (host_id);


--
-- Name: taxes_and_fees_rules_property_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX taxes_and_fees_rules_property_id_index ON public.taxes_and_fees_rules USING btree (property_id);


--
-- Name: tour_bookings_client_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX tour_bookings_client_id_index ON public.tour_bookings USING btree (client_id);


--
-- Name: tour_bookings_customer_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX tour_bookings_customer_id_index ON public.tour_bookings USING btree (customer_id);


--
-- Name: tour_bookings_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX tour_bookings_host_id_index ON public.tour_bookings USING btree (host_id);


--
-- Name: tour_bookings_tour_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX tour_bookings_tour_id_index ON public.tour_bookings USING btree (tour_id);


--
-- Name: tours_host_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX tours_host_id_index ON public.tours USING btree (host_id);


--
-- Name: transport_package_variants_unique; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX transport_package_variants_unique ON public.transport_package_variants USING btree ("packageId", "vehicleCategoryId", "seatConfigId", "maxPax");


--
-- Name: travel_package_enquiries_created_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX travel_package_enquiries_created_at_index ON public.travel_package_enquiries USING btree (created_at);


--
-- Name: travel_package_enquiries_package_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX travel_package_enquiries_package_id_index ON public.travel_package_enquiries USING btree (package_id);


--
-- Name: travel_package_enquiries_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX travel_package_enquiries_status_index ON public.travel_package_enquiries USING btree (status);


--
-- Name: travel_package_theme_links_package_id_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX travel_package_theme_links_package_id_idx ON public.travel_package_theme_links USING btree (package_id);


--
-- Name: travel_package_theme_links_theme_id_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX travel_package_theme_links_theme_id_idx ON public.travel_package_theme_links USING btree (theme_id);


--
-- Name: travel_packages_destination_id_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX travel_packages_destination_id_idx ON public.travel_packages USING btree (destination_id);


--
-- Name: travel_packages_flags_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX travel_packages_flags_idx ON public.travel_packages USING btree (is_featured, is_trending, is_top_rated);


--
-- Name: travel_packages_price_from_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX travel_packages_price_from_idx ON public.travel_packages USING btree (price_from);


--
-- Name: travel_packages_price_per_person_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX travel_packages_price_per_person_idx ON public.travel_packages USING btree (price_per_person);


--
-- Name: travel_packages_rating_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX travel_packages_rating_idx ON public.travel_packages USING btree (rating);


--
-- Name: travel_packages_slug_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX travel_packages_slug_idx ON public.travel_packages USING btree (slug);


--
-- Name: uq_property_amenities_property; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX uq_property_amenities_property ON public.property_amenities USING btree (property_id);


--
-- Name: vehicle_amenities_unique; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX vehicle_amenities_unique ON public.vehicle_amenities USING btree ("vehicleId", "amenityId");


--
-- Name: wishlist_items_property_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX wishlist_items_property_id_index ON public.wishlist_items USING btree (property_id);


--
-- Name: wishlist_items_wishlist_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX wishlist_items_wishlist_id_index ON public.wishlist_items USING btree (wishlist_id);


--
-- Name: reviews set_reviews_updated_at; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER set_reviews_updated_at BEFORE UPDATE ON public.reviews FOR EACH ROW EXECUTE FUNCTION public.update_updated_at_column();


--
-- Name: admin_adjustments admin_adjustments_booking_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.admin_adjustments
    ADD CONSTRAINT admin_adjustments_booking_id_foreign FOREIGN KEY (booking_id) REFERENCES public.bookings(id) ON DELETE SET NULL;


--
-- Name: admin_adjustments admin_adjustments_created_by_admin_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.admin_adjustments
    ADD CONSTRAINT admin_adjustments_created_by_admin_id_foreign FOREIGN KEY (created_by_admin_id) REFERENCES public.admins(id) ON DELETE SET NULL;


--
-- Name: admin_adjustments admin_adjustments_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.admin_adjustments
    ADD CONSTRAINT admin_adjustments_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE CASCADE;


--
-- Name: admin_adjustments admin_adjustments_ledger_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.admin_adjustments
    ADD CONSTRAINT admin_adjustments_ledger_id_foreign FOREIGN KEY (ledger_id) REFERENCES public.host_earnings_ledger(id) ON DELETE SET NULL;


--
-- Name: admin_audit_logs admin_audit_logs_admin_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.admin_audit_logs
    ADD CONSTRAINT admin_audit_logs_admin_user_id_foreign FOREIGN KEY (admin_user_id) REFERENCES public.admin_users(id) ON DELETE SET NULL;


--
-- Name: admin_conversation_notes admin_conversation_notes_admin_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.admin_conversation_notes
    ADD CONSTRAINT admin_conversation_notes_admin_id_foreign FOREIGN KEY (admin_id) REFERENCES public.admins(id) ON DELETE SET NULL;


--
-- Name: admin_conversation_notes admin_conversation_notes_conversation_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.admin_conversation_notes
    ADD CONSTRAINT admin_conversation_notes_conversation_id_foreign FOREIGN KEY (conversation_id) REFERENCES public.conversations(id) ON DELETE CASCADE;


--
-- Name: availability_blocks availability_blocks_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.availability_blocks
    ADD CONSTRAINT availability_blocks_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: booking_discounts booking_discounts_booking_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking_discounts
    ADD CONSTRAINT booking_discounts_booking_id_foreign FOREIGN KEY (booking_id) REFERENCES public.bookings(id) ON DELETE CASCADE;


--
-- Name: booking_events booking_events_booking_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking_events
    ADD CONSTRAINT booking_events_booking_id_foreign FOREIGN KEY (booking_id) REFERENCES public.bookings(id) ON DELETE CASCADE;


--
-- Name: booking_items booking_items_booking_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking_items
    ADD CONSTRAINT booking_items_booking_id_foreign FOREIGN KEY (booking_id) REFERENCES public.bookings(id) ON DELETE CASCADE;


--
-- Name: booking_notes booking_notes_booking_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking_notes
    ADD CONSTRAINT booking_notes_booking_id_foreign FOREIGN KEY (booking_id) REFERENCES public.bookings(id) ON DELETE CASCADE;


--
-- Name: booking_notes booking_notes_created_by_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking_notes
    ADD CONSTRAINT booking_notes_created_by_foreign FOREIGN KEY (created_by) REFERENCES public.admins(id) ON DELETE SET NULL;


--
-- Name: bookings bookings_card_offer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bookings
    ADD CONSTRAINT bookings_card_offer_id_foreign FOREIGN KEY (card_offer_id) REFERENCES public.card_offers(id) ON DELETE SET NULL;


--
-- Name: bookings bookings_client_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bookings
    ADD CONSTRAINT bookings_client_id_foreign FOREIGN KEY (client_id) REFERENCES public.clients(id) ON DELETE SET NULL;


--
-- Name: bookings bookings_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bookings
    ADD CONSTRAINT bookings_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE SET NULL;


--
-- Name: bookings bookings_guest_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bookings
    ADD CONSTRAINT bookings_guest_id_foreign FOREIGN KEY (guest_id) REFERENCES public.customers(id) ON DELETE SET NULL;


--
-- Name: bookings bookings_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bookings
    ADD CONSTRAINT bookings_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE SET NULL;


--
-- Name: bookings bookings_package_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bookings
    ADD CONSTRAINT bookings_package_id_foreign FOREIGN KEY (package_id) REFERENCES public.travel_packages(id) ON DELETE SET NULL;


--
-- Name: bookings bookings_promo_code_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bookings
    ADD CONSTRAINT bookings_promo_code_id_foreign FOREIGN KEY (promo_code_id) REFERENCES public.promo_codes(id) ON DELETE SET NULL;


--
-- Name: bookings bookings_promotion_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bookings
    ADD CONSTRAINT bookings_promotion_id_foreign FOREIGN KEY (promotion_id) REFERENCES public.promotions(id) ON DELETE SET NULL;


--
-- Name: bookings bookings_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bookings
    ADD CONSTRAINT bookings_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE SET NULL;


--
-- Name: bookings bookings_room_type_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bookings
    ADD CONSTRAINT bookings_room_type_id_foreign FOREIGN KEY (room_type_id) REFERENCES public.property_room_types(id) ON DELETE SET NULL;


--
-- Name: cab_packages cab_packages_location_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cab_packages
    ADD CONSTRAINT cab_packages_location_fkey FOREIGN KEY ("locationId") REFERENCES public.locations(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: cab_packages cab_packages_seat_config_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cab_packages
    ADD CONSTRAINT cab_packages_seat_config_fkey FOREIGN KEY ("seatConfigId") REFERENCES public.seat_configs(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: cab_packages cab_packages_vehicle_category_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cab_packages
    ADD CONSTRAINT cab_packages_vehicle_category_fkey FOREIGN KEY ("vehicleCategoryId") REFERENCES public.vehicle_categories(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: cancellation_requests cancellation_requests_booking_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cancellation_requests
    ADD CONSTRAINT cancellation_requests_booking_id_foreign FOREIGN KEY (booking_id) REFERENCES public.bookings(id) ON DELETE CASCADE;


--
-- Name: cancellation_requests cancellation_requests_guest_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cancellation_requests
    ADD CONSTRAINT cancellation_requests_guest_id_foreign FOREIGN KEY (guest_id) REFERENCES public.customers(id) ON DELETE SET NULL;


--
-- Name: cancellation_requests cancellation_requests_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cancellation_requests
    ADD CONSTRAINT cancellation_requests_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE SET NULL;


--
-- Name: cancellation_requests cancellation_requests_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cancellation_requests
    ADD CONSTRAINT cancellation_requests_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE SET NULL;


--
-- Name: card_offers card_offers_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.card_offers
    ADD CONSTRAINT card_offers_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE SET NULL;


--
-- Name: card_offers card_offers_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.card_offers
    ADD CONSTRAINT card_offers_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE SET NULL;


--
-- Name: channel_audit_logs channel_audit_logs_admin_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.channel_audit_logs
    ADD CONSTRAINT channel_audit_logs_admin_id_foreign FOREIGN KEY (admin_id) REFERENCES public.admins(id) ON DELETE SET NULL;


--
-- Name: channel_events channel_events_provider_connection_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.channel_events
    ADD CONSTRAINT channel_events_provider_connection_id_foreign FOREIGN KEY (provider_connection_id) REFERENCES public.provider_connections(id) ON DELETE CASCADE;


--
-- Name: channel_sync_jobs channel_sync_jobs_mapping_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.channel_sync_jobs
    ADD CONSTRAINT channel_sync_jobs_mapping_id_foreign FOREIGN KEY (mapping_id) REFERENCES public.property_channel_mappings(id) ON DELETE CASCADE;


--
-- Name: cities cities_state_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cities
    ADD CONSTRAINT cities_state_id_foreign FOREIGN KEY (state_id) REFERENCES public.states(id) ON DELETE CASCADE;


--
-- Name: conversation_events conversation_events_conversation_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.conversation_events
    ADD CONSTRAINT conversation_events_conversation_id_foreign FOREIGN KEY (conversation_id) REFERENCES public.conversations(id) ON DELETE CASCADE;


--
-- Name: conversations conversations_booking_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.conversations
    ADD CONSTRAINT conversations_booking_id_foreign FOREIGN KEY (booking_id) REFERENCES public.bookings(id) ON DELETE CASCADE;


--
-- Name: conversations conversations_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.conversations
    ADD CONSTRAINT conversations_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE SET NULL;


--
-- Name: conversations conversations_guest_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.conversations
    ADD CONSTRAINT conversations_guest_id_foreign FOREIGN KEY (guest_id) REFERENCES public.customers(id) ON DELETE SET NULL;


--
-- Name: conversations conversations_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.conversations
    ADD CONSTRAINT conversations_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE SET NULL;


--
-- Name: conversations conversations_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.conversations
    ADD CONSTRAINT conversations_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE SET NULL;


--
-- Name: coupon_property_scope coupon_property_scope_coupon_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.coupon_property_scope
    ADD CONSTRAINT coupon_property_scope_coupon_id_foreign FOREIGN KEY (coupon_id) REFERENCES public.coupons(id) ON DELETE CASCADE;


--
-- Name: coupon_property_scope coupon_property_scope_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.coupon_property_scope
    ADD CONSTRAINT coupon_property_scope_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: customer_reviews customer_reviews_booking_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.customer_reviews
    ADD CONSTRAINT customer_reviews_booking_id_foreign FOREIGN KEY (booking_id) REFERENCES public.bookings(id) ON DELETE SET NULL;


--
-- Name: customer_reviews customer_reviews_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.customer_reviews
    ADD CONSTRAINT customer_reviews_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE SET NULL;


--
-- Name: daily_rate_overrides daily_rate_overrides_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.daily_rate_overrides
    ADD CONSTRAINT daily_rate_overrides_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: daily_rate_overrides daily_rate_overrides_rate_plan_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.daily_rate_overrides
    ADD CONSTRAINT daily_rate_overrides_rate_plan_id_foreign FOREIGN KEY (rate_plan_id) REFERENCES public.rate_plans(id) ON DELETE CASCADE;


--
-- Name: enquiry_leads enquiry_leads_admin_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.enquiry_leads
    ADD CONSTRAINT enquiry_leads_admin_fkey FOREIGN KEY ("assignedToAdminId") REFERENCES public.admin_users(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: enquiry_leads enquiry_leads_drop_location_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.enquiry_leads
    ADD CONSTRAINT enquiry_leads_drop_location_fkey FOREIGN KEY ("dropLocationId") REFERENCES public.locations(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: enquiry_leads enquiry_leads_package_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.enquiry_leads
    ADD CONSTRAINT enquiry_leads_package_fkey FOREIGN KEY ("transportPackageId") REFERENCES public.transport_packages(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: enquiry_leads enquiry_leads_pickup_location_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.enquiry_leads
    ADD CONSTRAINT enquiry_leads_pickup_location_fkey FOREIGN KEY ("pickupLocationId") REFERENCES public.locations(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: enquiry_leads enquiry_leads_route_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.enquiry_leads
    ADD CONSTRAINT enquiry_leads_route_fkey FOREIGN KEY ("routeId") REFERENCES public.routes(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: enquiry_leads enquiry_leads_variant_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.enquiry_leads
    ADD CONSTRAINT enquiry_leads_variant_fkey FOREIGN KEY ("transportPackageVariantId") REFERENCES public.transport_package_variants(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: enquiry_leads enquiry_leads_vehicle_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.enquiry_leads
    ADD CONSTRAINT enquiry_leads_vehicle_fkey FOREIGN KEY ("vehicleId") REFERENCES public.vehicles(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: fees fees_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.fees
    ADD CONSTRAINT fees_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: host_bank_accounts host_bank_accounts_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_bank_accounts
    ADD CONSTRAINT host_bank_accounts_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE CASCADE;


--
-- Name: host_earnings_ledger host_earnings_ledger_booking_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_earnings_ledger
    ADD CONSTRAINT host_earnings_ledger_booking_id_foreign FOREIGN KEY (booking_id) REFERENCES public.bookings(id) ON DELETE SET NULL;


--
-- Name: host_earnings_ledger host_earnings_ledger_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_earnings_ledger
    ADD CONSTRAINT host_earnings_ledger_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE CASCADE;


--
-- Name: host_earnings_ledger host_earnings_ledger_payout_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_earnings_ledger
    ADD CONSTRAINT host_earnings_ledger_payout_id_foreign FOREIGN KEY (payout_id) REFERENCES public.payouts(id) ON DELETE SET NULL;


--
-- Name: host_earnings_ledger host_earnings_ledger_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_earnings_ledger
    ADD CONSTRAINT host_earnings_ledger_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE SET NULL;


--
-- Name: host_kyc_documents host_kyc_documents_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_kyc_documents
    ADD CONSTRAINT host_kyc_documents_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE CASCADE;


--
-- Name: host_kyc host_kyc_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_kyc
    ADD CONSTRAINT host_kyc_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE CASCADE;


--
-- Name: host_kyc_submissions host_kyc_submissions_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_kyc_submissions
    ADD CONSTRAINT host_kyc_submissions_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE CASCADE;


--
-- Name: host_payout_accounts host_payout_accounts_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_payout_accounts
    ADD CONSTRAINT host_payout_accounts_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE CASCADE;


--
-- Name: host_payout_events host_payout_events_payout_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_payout_events
    ADD CONSTRAINT host_payout_events_payout_id_foreign FOREIGN KEY (payout_id) REFERENCES public.host_payouts(id) ON DELETE CASCADE;


--
-- Name: host_stripe_accounts host_stripe_accounts_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.host_stripe_accounts
    ADD CONSTRAINT host_stripe_accounts_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE CASCADE;


--
-- Name: invoices invoices_booking_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invoices
    ADD CONSTRAINT invoices_booking_id_foreign FOREIGN KEY (booking_id) REFERENCES public.bookings(id) ON DELETE CASCADE;


--
-- Name: invoices invoices_guest_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invoices
    ADD CONSTRAINT invoices_guest_id_foreign FOREIGN KEY (guest_id) REFERENCES public.customers(id) ON DELETE SET NULL;


--
-- Name: invoices invoices_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invoices
    ADD CONSTRAINT invoices_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE SET NULL;


--
-- Name: ledger_entries ledger_entries_credit_account_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.ledger_entries
    ADD CONSTRAINT ledger_entries_credit_account_id_foreign FOREIGN KEY (credit_account_id) REFERENCES public.ledger_accounts(id) ON DELETE RESTRICT;


--
-- Name: ledger_entries ledger_entries_debit_account_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.ledger_entries
    ADD CONSTRAINT ledger_entries_debit_account_id_foreign FOREIGN KEY (debit_account_id) REFERENCES public.ledger_accounts(id) ON DELETE RESTRICT;


--
-- Name: length_of_stay_discounts length_of_stay_discounts_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.length_of_stay_discounts
    ADD CONSTRAINT length_of_stay_discounts_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: length_of_stay_discounts length_of_stay_discounts_rate_plan_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.length_of_stay_discounts
    ADD CONSTRAINT length_of_stay_discounts_rate_plan_id_foreign FOREIGN KEY (rate_plan_id) REFERENCES public.rate_plans(id) ON DELETE CASCADE;


--
-- Name: location_nodes location_nodes_parent_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.location_nodes
    ADD CONSTRAINT location_nodes_parent_id_foreign FOREIGN KEY (parent_id) REFERENCES public.location_nodes(id) ON DELETE CASCADE;


--
-- Name: message_reads message_reads_message_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.message_reads
    ADD CONSTRAINT message_reads_message_id_foreign FOREIGN KEY (message_id) REFERENCES public.messages(id) ON DELETE CASCADE;


--
-- Name: messages messages_conversation_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.messages
    ADD CONSTRAINT messages_conversation_id_foreign FOREIGN KEY (conversation_id) REFERENCES public.conversations(id) ON DELETE CASCADE;


--
-- Name: occupancy_pricing_rules occupancy_pricing_rules_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.occupancy_pricing_rules
    ADD CONSTRAINT occupancy_pricing_rules_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: occupancy_pricing_rules occupancy_pricing_rules_rate_plan_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.occupancy_pricing_rules
    ADD CONSTRAINT occupancy_pricing_rules_rate_plan_id_foreign FOREIGN KEY (rate_plan_id) REFERENCES public.rate_plans(id) ON DELETE CASCADE;


--
-- Name: payouts payouts_booking_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.payouts
    ADD CONSTRAINT payouts_booking_id_foreign FOREIGN KEY (booking_id) REFERENCES public.bookings(id) ON DELETE SET NULL;


--
-- Name: payouts payouts_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.payouts
    ADD CONSTRAINT payouts_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE CASCADE;


--
-- Name: popular_route_groups popular_route_groups_from_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.popular_route_groups
    ADD CONSTRAINT popular_route_groups_from_fkey FOREIGN KEY ("fromLocationId") REFERENCES public.locations(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: popular_route_items popular_route_items_group_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.popular_route_items
    ADD CONSTRAINT popular_route_items_group_fkey FOREIGN KEY ("groupId") REFERENCES public.popular_route_groups(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: popular_route_items popular_route_items_to_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.popular_route_items
    ADD CONSTRAINT popular_route_items_to_fkey FOREIGN KEY ("toLocationId") REFERENCES public.locations(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: pricing_rule_sets pricing_rule_sets_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.pricing_rule_sets
    ADD CONSTRAINT pricing_rule_sets_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE SET NULL;


--
-- Name: pricing_rule_sets pricing_rule_sets_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.pricing_rule_sets
    ADD CONSTRAINT pricing_rule_sets_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE SET NULL;


--
-- Name: pricing_rules pricing_rules_destination_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.pricing_rules
    ADD CONSTRAINT pricing_rules_destination_fkey FOREIGN KEY ("destinationLocationId") REFERENCES public.locations(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: pricing_rules pricing_rules_origin_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.pricing_rules
    ADD CONSTRAINT pricing_rules_origin_fkey FOREIGN KEY ("originLocationId") REFERENCES public.locations(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: pricing_rules pricing_rules_route_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.pricing_rules
    ADD CONSTRAINT pricing_rules_route_fkey FOREIGN KEY ("routeId") REFERENCES public.routes(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: pricing_rules pricing_rules_seat_config_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.pricing_rules
    ADD CONSTRAINT pricing_rules_seat_config_fkey FOREIGN KEY ("seatConfigId") REFERENCES public.seat_configs(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: pricing_rules pricing_rules_vehicle_category_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.pricing_rules
    ADD CONSTRAINT pricing_rules_vehicle_category_fkey FOREIGN KEY ("vehicleCategoryId") REFERENCES public.vehicle_categories(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: promo_code_properties promo_code_properties_promo_code_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.promo_code_properties
    ADD CONSTRAINT promo_code_properties_promo_code_id_foreign FOREIGN KEY (promo_code_id) REFERENCES public.promo_codes(id) ON DELETE CASCADE;


--
-- Name: promo_code_properties promo_code_properties_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.promo_code_properties
    ADD CONSTRAINT promo_code_properties_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: promo_code_redemptions promo_code_redemptions_booking_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.promo_code_redemptions
    ADD CONSTRAINT promo_code_redemptions_booking_id_foreign FOREIGN KEY (booking_id) REFERENCES public.bookings(id) ON DELETE SET NULL;


--
-- Name: promo_code_redemptions promo_code_redemptions_guest_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.promo_code_redemptions
    ADD CONSTRAINT promo_code_redemptions_guest_id_foreign FOREIGN KEY (guest_id) REFERENCES public.customers(id) ON DELETE SET NULL;


--
-- Name: promo_code_redemptions promo_code_redemptions_promo_code_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.promo_code_redemptions
    ADD CONSTRAINT promo_code_redemptions_promo_code_id_foreign FOREIGN KEY (promo_code_id) REFERENCES public.promo_codes(id) ON DELETE CASCADE;


--
-- Name: promo_codes promo_codes_created_by_admin_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.promo_codes
    ADD CONSTRAINT promo_codes_created_by_admin_id_foreign FOREIGN KEY (created_by_admin_id) REFERENCES public.admins(id) ON DELETE SET NULL;


--
-- Name: promo_codes promo_codes_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.promo_codes
    ADD CONSTRAINT promo_codes_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE SET NULL;


--
-- Name: promo_codes promo_codes_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.promo_codes
    ADD CONSTRAINT promo_codes_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE SET NULL;


--
-- Name: promotions promotions_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.promotions
    ADD CONSTRAINT promotions_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE CASCADE;


--
-- Name: promotions promotions_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.promotions
    ADD CONSTRAINT promotions_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE SET NULL;


--
-- Name: properties properties_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.properties
    ADD CONSTRAINT properties_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE SET NULL;


--
-- Name: property_amenities property_amenities_amenity_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_amenities
    ADD CONSTRAINT property_amenities_amenity_id_foreign FOREIGN KEY (amenity_id) REFERENCES public.amenities(id) ON DELETE CASCADE;


--
-- Name: property_amenities property_amenities_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_amenities
    ADD CONSTRAINT property_amenities_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: property_availability property_availability_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_availability
    ADD CONSTRAINT property_availability_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: property_availability_rules property_availability_rules_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_availability_rules
    ADD CONSTRAINT property_availability_rules_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: property_availability property_availability_source_mapping_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_availability
    ADD CONSTRAINT property_availability_source_mapping_id_foreign FOREIGN KEY (source_mapping_id) REFERENCES public.property_channel_mappings(id) ON DELETE SET NULL;


--
-- Name: property_base_pricing property_base_pricing_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_base_pricing
    ADD CONSTRAINT property_base_pricing_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: property_blackout_dates property_blackout_dates_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_blackout_dates
    ADD CONSTRAINT property_blackout_dates_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: property_calendar property_calendar_booking_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_calendar
    ADD CONSTRAINT property_calendar_booking_id_foreign FOREIGN KEY (booking_id) REFERENCES public.bookings(id) ON DELETE SET NULL;


--
-- Name: property_calendar_days property_calendar_days_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_calendar_days
    ADD CONSTRAINT property_calendar_days_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: property_calendar_overrides property_calendar_overrides_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_calendar_overrides
    ADD CONSTRAINT property_calendar_overrides_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: property_calendar property_calendar_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_calendar
    ADD CONSTRAINT property_calendar_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: property_cancellation_policy property_cancellation_policy_policy_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_cancellation_policy
    ADD CONSTRAINT property_cancellation_policy_policy_id_foreign FOREIGN KEY (policy_id) REFERENCES public.cancellation_policies(id) ON DELETE SET NULL;


--
-- Name: property_cancellation_policy property_cancellation_policy_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_cancellation_policy
    ADD CONSTRAINT property_cancellation_policy_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: property_channel_mappings property_channel_mappings_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_channel_mappings
    ADD CONSTRAINT property_channel_mappings_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: property_channel_mappings property_channel_mappings_provider_connection_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_channel_mappings
    ADD CONSTRAINT property_channel_mappings_provider_connection_id_foreign FOREIGN KEY (provider_connection_id) REFERENCES public.provider_connections(id) ON DELETE CASCADE;


--
-- Name: property_images property_images_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_images
    ADD CONSTRAINT property_images_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: property_policy_templates property_policy_templates_policy_template_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_policy_templates
    ADD CONSTRAINT property_policy_templates_policy_template_id_foreign FOREIGN KEY (policy_template_id) REFERENCES public.policy_templates(id) ON DELETE CASCADE;


--
-- Name: property_policy_templates property_policy_templates_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_policy_templates
    ADD CONSTRAINT property_policy_templates_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: property_pricing_rules property_pricing_rules_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_pricing_rules
    ADD CONSTRAINT property_pricing_rules_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: property_rating_stats property_rating_stats_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_rating_stats
    ADD CONSTRAINT property_rating_stats_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: property_room_types property_room_types_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_room_types
    ADD CONSTRAINT property_room_types_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: property_services property_services_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_services
    ADD CONSTRAINT property_services_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: property_services property_services_service_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_services
    ADD CONSTRAINT property_services_service_id_foreign FOREIGN KEY (service_id) REFERENCES public.services(id) ON DELETE CASCADE;


--
-- Name: property_spaces property_spaces_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_spaces
    ADD CONSTRAINT property_spaces_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: property_types property_types_category_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.property_types
    ADD CONSTRAINT property_types_category_id_foreign FOREIGN KEY (category_id) REFERENCES public.property_categories(id) ON DELETE SET NULL;


--
-- Name: rate_plans rate_plans_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rate_plans
    ADD CONSTRAINT rate_plans_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: review_events review_events_review_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.review_events
    ADD CONSTRAINT review_events_review_id_foreign FOREIGN KEY (review_id) REFERENCES public.reviews(review_id) ON DELETE CASCADE;


--
-- Name: review_media review_media_review_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.review_media
    ADD CONSTRAINT review_media_review_id_foreign FOREIGN KEY (review_id) REFERENCES public.reviews(review_id) ON DELETE CASCADE;


--
-- Name: reviews reviews_booking_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_booking_id_foreign FOREIGN KEY (booking_id) REFERENCES public.bookings(id) ON DELETE CASCADE;


--
-- Name: reviews reviews_guest_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_guest_id_foreign FOREIGN KEY (guest_id) REFERENCES public.customers(id) ON DELETE SET NULL;


--
-- Name: reviews reviews_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE SET NULL;


--
-- Name: reviews reviews_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: reviews reviews_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(user_id) ON DELETE CASCADE;


--
-- Name: routes routes_from_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.routes
    ADD CONSTRAINT routes_from_fkey FOREIGN KEY ("fromLocationId") REFERENCES public.locations(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: routes routes_to_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.routes
    ADD CONSTRAINT routes_to_fkey FOREIGN KEY ("toLocationId") REFERENCES public.locations(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: seasonal_pricing seasonal_pricing_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.seasonal_pricing
    ADD CONSTRAINT seasonal_pricing_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: seasonal_pricing_rules seasonal_pricing_rules_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.seasonal_pricing_rules
    ADD CONSTRAINT seasonal_pricing_rules_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE SET NULL;


--
-- Name: seasonal_pricing_rules seasonal_pricing_rules_label_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.seasonal_pricing_rules
    ADD CONSTRAINT seasonal_pricing_rules_label_id_foreign FOREIGN KEY (label_id) REFERENCES public.pricing_labels(id) ON DELETE SET NULL;


--
-- Name: seasonal_pricing_rules seasonal_pricing_rules_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.seasonal_pricing_rules
    ADD CONSTRAINT seasonal_pricing_rules_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE SET NULL;


--
-- Name: seasonal_pricing_rules seasonal_pricing_rules_rule_set_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.seasonal_pricing_rules
    ADD CONSTRAINT seasonal_pricing_rules_rule_set_id_foreign FOREIGN KEY (rule_set_id) REFERENCES public.pricing_rule_sets(id) ON DELETE SET NULL;


--
-- Name: seasonal_rates seasonal_rates_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.seasonal_rates
    ADD CONSTRAINT seasonal_rates_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: seasonal_rates seasonal_rates_rate_plan_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.seasonal_rates
    ADD CONSTRAINT seasonal_rates_rate_plan_id_foreign FOREIGN KEY (rate_plan_id) REFERENCES public.rate_plans(id) ON DELETE CASCADE;


--
-- Name: special_offer_rules special_offer_rules_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.special_offer_rules
    ADD CONSTRAINT special_offer_rules_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE SET NULL;


--
-- Name: special_offer_rules special_offer_rules_label_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.special_offer_rules
    ADD CONSTRAINT special_offer_rules_label_id_foreign FOREIGN KEY (label_id) REFERENCES public.pricing_labels(id) ON DELETE SET NULL;


--
-- Name: special_offer_rules special_offer_rules_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.special_offer_rules
    ADD CONSTRAINT special_offer_rules_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE SET NULL;


--
-- Name: special_offer_rules special_offer_rules_rule_set_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.special_offer_rules
    ADD CONSTRAINT special_offer_rules_rule_set_id_foreign FOREIGN KEY (rule_set_id) REFERENCES public.pricing_rule_sets(id) ON DELETE SET NULL;


--
-- Name: states states_country_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.states
    ADD CONSTRAINT states_country_id_foreign FOREIGN KEY (country_id) REFERENCES public.countries(id) ON DELETE CASCADE;


--
-- Name: support_messages support_messages_ticket_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.support_messages
    ADD CONSTRAINT support_messages_ticket_id_foreign FOREIGN KEY (ticket_id) REFERENCES public.support_tickets(id) ON DELETE CASCADE;


--
-- Name: support_tickets support_tickets_assigned_to_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.support_tickets
    ADD CONSTRAINT support_tickets_assigned_to_foreign FOREIGN KEY (assigned_to) REFERENCES public.admins(id) ON DELETE SET NULL;


--
-- Name: support_tickets support_tickets_created_by_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.support_tickets
    ADD CONSTRAINT support_tickets_created_by_foreign FOREIGN KEY (created_by) REFERENCES public.customers(id) ON DELETE SET NULL;


--
-- Name: support_tickets support_tickets_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.support_tickets
    ADD CONSTRAINT support_tickets_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE SET NULL;


--
-- Name: support_tickets support_tickets_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.support_tickets
    ADD CONSTRAINT support_tickets_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE CASCADE;


--
-- Name: tax_rules tax_rules_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tax_rules
    ADD CONSTRAINT tax_rules_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: taxes_and_fees_rules taxes_and_fees_rules_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.taxes_and_fees_rules
    ADD CONSTRAINT taxes_and_fees_rules_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE SET NULL;


--
-- Name: taxes_and_fees_rules taxes_and_fees_rules_label_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.taxes_and_fees_rules
    ADD CONSTRAINT taxes_and_fees_rules_label_id_foreign FOREIGN KEY (label_id) REFERENCES public.pricing_labels(id) ON DELETE SET NULL;


--
-- Name: taxes_and_fees_rules taxes_and_fees_rules_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.taxes_and_fees_rules
    ADD CONSTRAINT taxes_and_fees_rules_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE SET NULL;


--
-- Name: taxes_and_fees_rules taxes_and_fees_rules_rule_set_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.taxes_and_fees_rules
    ADD CONSTRAINT taxes_and_fees_rules_rule_set_id_foreign FOREIGN KEY (rule_set_id) REFERENCES public.pricing_rule_sets(id) ON DELETE SET NULL;


--
-- Name: tour_bookings tour_bookings_client_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tour_bookings
    ADD CONSTRAINT tour_bookings_client_id_foreign FOREIGN KEY (client_id) REFERENCES public.clients(id) ON DELETE SET NULL;


--
-- Name: tour_bookings tour_bookings_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tour_bookings
    ADD CONSTRAINT tour_bookings_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE SET NULL;


--
-- Name: tour_bookings tour_bookings_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tour_bookings
    ADD CONSTRAINT tour_bookings_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE CASCADE;


--
-- Name: tour_bookings tour_bookings_tour_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tour_bookings
    ADD CONSTRAINT tour_bookings_tour_id_foreign FOREIGN KEY (tour_id) REFERENCES public.tours(id) ON DELETE CASCADE;


--
-- Name: tours tours_host_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tours
    ADD CONSTRAINT tours_host_id_foreign FOREIGN KEY (host_id) REFERENCES public.hosts(id) ON DELETE CASCADE;


--
-- Name: transactions transactions_booking_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transactions
    ADD CONSTRAINT transactions_booking_id_foreign FOREIGN KEY (booking_id) REFERENCES public.bookings(id) ON DELETE CASCADE;


--
-- Name: transport_package_media transport_package_media_package_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transport_package_media
    ADD CONSTRAINT transport_package_media_package_fkey FOREIGN KEY ("packageId") REFERENCES public.transport_packages(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: transport_package_variants transport_package_variants_category_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transport_package_variants
    ADD CONSTRAINT transport_package_variants_category_fkey FOREIGN KEY ("vehicleCategoryId") REFERENCES public.vehicle_categories(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: transport_package_variants transport_package_variants_package_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transport_package_variants
    ADD CONSTRAINT transport_package_variants_package_fkey FOREIGN KEY ("packageId") REFERENCES public.transport_packages(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: transport_package_variants transport_package_variants_seat_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transport_package_variants
    ADD CONSTRAINT transport_package_variants_seat_fkey FOREIGN KEY ("seatConfigId") REFERENCES public.seat_configs(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: transport_packages transport_packages_location_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transport_packages
    ADD CONSTRAINT transport_packages_location_fkey FOREIGN KEY ("locationId") REFERENCES public.locations(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: travel_custom_tour_requests travel_custom_tour_requests_destination_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_custom_tour_requests
    ADD CONSTRAINT travel_custom_tour_requests_destination_id_foreign FOREIGN KEY (destination_id) REFERENCES public.travel_package_destinations(id) ON DELETE SET NULL;


--
-- Name: travel_package_enquiries travel_package_enquiries_package_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_enquiries
    ADD CONSTRAINT travel_package_enquiries_package_id_foreign FOREIGN KEY (package_id) REFERENCES public.travel_packages(id) ON DELETE SET NULL;


--
-- Name: travel_package_images travel_package_images_package_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_images
    ADD CONSTRAINT travel_package_images_package_id_foreign FOREIGN KEY (package_id) REFERENCES public.travel_packages(id) ON DELETE CASCADE;


--
-- Name: travel_package_itineraries travel_package_itineraries_package_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_itineraries
    ADD CONSTRAINT travel_package_itineraries_package_id_foreign FOREIGN KEY (package_id) REFERENCES public.travel_packages(id) ON DELETE CASCADE;


--
-- Name: travel_package_theme_links travel_package_theme_links_package_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_theme_links
    ADD CONSTRAINT travel_package_theme_links_package_id_foreign FOREIGN KEY (package_id) REFERENCES public.travel_packages(id) ON DELETE CASCADE;


--
-- Name: travel_package_theme_links travel_package_theme_links_theme_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_package_theme_links
    ADD CONSTRAINT travel_package_theme_links_theme_id_foreign FOREIGN KEY (theme_id) REFERENCES public.travel_package_themes(id) ON DELETE CASCADE;


--
-- Name: travel_packages travel_packages_destination_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.travel_packages
    ADD CONSTRAINT travel_packages_destination_id_foreign FOREIGN KEY (destination_id) REFERENCES public.travel_package_destinations(id) ON DELETE SET NULL;


--
-- Name: vehicle_amenities vehicle_amenities_amenity_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.vehicle_amenities
    ADD CONSTRAINT vehicle_amenities_amenity_fkey FOREIGN KEY ("amenityId") REFERENCES public.cab_amenities(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: vehicle_amenities vehicle_amenities_vehicle_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.vehicle_amenities
    ADD CONSTRAINT vehicle_amenities_vehicle_fkey FOREIGN KEY ("vehicleId") REFERENCES public.vehicles(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: vehicle_images vehicle_images_vehicle_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.vehicle_images
    ADD CONSTRAINT vehicle_images_vehicle_fkey FOREIGN KEY ("vehicleId") REFERENCES public.vehicles(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: vehicles vehicles_category_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.vehicles
    ADD CONSTRAINT vehicles_category_fkey FOREIGN KEY ("categoryId") REFERENCES public.vehicle_categories(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: vehicles vehicles_seatconfig_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.vehicles
    ADD CONSTRAINT vehicles_seatconfig_fkey FOREIGN KEY ("seatConfigId") REFERENCES public.seat_configs(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: wishlist_items wishlist_items_property_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.wishlist_items
    ADD CONSTRAINT wishlist_items_property_id_foreign FOREIGN KEY (property_id) REFERENCES public.properties(id) ON DELETE CASCADE;


--
-- Name: wishlist_items wishlist_items_wishlist_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.wishlist_items
    ADD CONSTRAINT wishlist_items_wishlist_id_foreign FOREIGN KEY (wishlist_id) REFERENCES public.wishlists(id) ON DELETE CASCADE;


--
-- Name: wishlists wishlists_guest_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.wishlists
    ADD CONSTRAINT wishlists_guest_id_foreign FOREIGN KEY (guest_id) REFERENCES public.customers(id) ON DELETE CASCADE;


--
--


