--
-- PostgreSQL database dump
--

-- Dumped from database version 16.2 (Ubuntu 16.2-1.pgdg22.04+1)
-- Dumped by pg_dump version 16.2 (Ubuntu 16.2-1.pgdg22.04+1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: chatbot_chat_data; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.chatbot_chat_data (
    chat_id uuid NOT NULL,
    chat_name character varying(50),
    chat_type character varying(20),
    message text NOT NULL,
    related_option_id_id uuid,
    option_type character varying(20),
    created_date timestamp with time zone NOT NULL,
    related_chat_id uuid,
    option_column_id uuid,
    option_table_id uuid,
    redirect character varying(20)
);


ALTER TABLE public.chatbot_chat_data OWNER TO postgres;

--
-- Name: chatbot_columnlist; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.chatbot_columnlist (
    id uuid NOT NULL,
    column_name character varying(255) NOT NULL,
    table_id uuid NOT NULL,
    column_id character varying(255) NOT NULL,
    created_date timestamp with time zone NOT NULL
);


ALTER TABLE public.chatbot_columnlist OWNER TO postgres;

--
-- Name: chatbot_maptables; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.chatbot_maptables (
    id uuid NOT NULL,
    map_name character varying(255) NOT NULL,
    created_date timestamp with time zone NOT NULL,
    table_name_id uuid NOT NULL
);


ALTER TABLE public.chatbot_maptables OWNER TO postgres;

--
-- Name: chatbot_options; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.chatbot_options (
    id uuid NOT NULL,
    option_value character varying(255) NOT NULL,
    column_id uuid,
    table_id uuid
);


ALTER TABLE public.chatbot_options OWNER TO postgres;

--
-- Name: chatbot_relatedoptiontable; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.chatbot_relatedoptiontable (
    id uuid NOT NULL,
    option_value character varying(255) NOT NULL
);


ALTER TABLE public.chatbot_relatedoptiontable OWNER TO postgres;

--
-- Name: chatbot_tablelist; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.chatbot_tablelist (
    id uuid NOT NULL,
    table_name character varying(255) NOT NULL,
    created_date timestamp with time zone NOT NULL
);


ALTER TABLE public.chatbot_tablelist OWNER TO postgres;

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

COPY public.chatbot_chat_data (chat_id, chat_name, chat_type, message, related_option_id_id, option_type, created_date, related_chat_id, option_column_id, option_table_id, redirect) FROM stdin;
5ce39b6c-6fdb-4c52-b940-d187918ba995	End of Ordering	End Message	Thank you for using my service	\N		2025-06-04 09:35:45.693266+05:30	e3861552-6374-40b0-b41d-50983795af33	\N	\N	No
af187749-010a-4335-a087-774fe1dc6b2e	Special Offer List	Related	🎉 Great Deals Await!\r\nCheck out the latest offers specially picked for you.	7c7de156-d152-4766-ba66-fda31e139152	Table	2025-05-15 11:52:56.307636+05:30	9dc3f295-796c-42fa-8045-922506da01db	70fdaf37-d404-4761-a5df-74612fbf94af	fee5bc0d-87ec-42d7-a0d1-0e8a2aca079e	Yes
ca6c13d1-0a6b-4bba-aa8d-60fcac37aaae	Payment Answer 3	End Message	We accept: \r\n ● Credit/Debit Cards (Visa, MasterCard, RuPay, etc.) \r\n ● UPI & Wallet Payments (Google Pay, Paytm, PhonePe, etc.) \r\n ● Net Banking \r\n ● Cash on Delivery (available in selected locations)	e09b4232-3390-47f9-8e35-664e6d317fa8		2025-06-05 09:31:49.458271+05:30	0430b16e-f226-4e05-b2e5-76eff602660d	\N	\N	No
1bed1788-439c-4395-b491-057e6d7ce09a	Payment Answer 4	End Message	Yes, COD is available for select locations and products. Additional charges may apply.	5a990021-3f33-4b38-b6a3-dc67c70b485f		2025-06-05 09:32:17.550247+05:30	0430b16e-f226-4e05-b2e5-76eff602660d	\N	\N	No
3172a27f-3e5a-43aa-b573-bfa160528c01	Welcome Message	Welcome Message	Hi there!! Welcome to Navya Bakeshop.	\N		2025-05-06 10:34:12.58317+05:30	\N	\N	\N	No
d7d5101c-5dc2-48e4-b631-ee91c95ddc83	Payment Answer 5	End Message	Yes, an invoice will be sent to your registered email once your order is confirmed.\r\n\r\nThank you	da2da1f3-4181-4d0e-82b3-6dcf14b88405		2025-06-05 09:32:48.832583+05:30	0430b16e-f226-4e05-b2e5-76eff602660d	\N	\N	No
9dc3f295-796c-42fa-8045-922506da01db	Related message	Related	What’s your favorite baked treat?	\N	Custom	2025-05-06 10:37:23.784339+05:30	3172a27f-3e5a-43aa-b573-bfa160528c01	ab16453b-8d3d-4586-b4c6-89c2bad687cd	646c9cd0-ee3f-44e3-bae2-41f87d01ad71	No
afb3342d-c711-40e0-bb5b-a819dfde2fea	End of Special Offers	End Message	Thank you for using our service!	\N		2025-06-04 10:37:15.685084+05:30	af187749-010a-4335-a087-774fe1dc6b2e	\N	\N	No
3d73bda2-9193-46f3-b917-b68011cbc893	Select Location	Related	Heyy! We have several locations around city. Pick any outlet for location details.	061c89a5-5064-41e4-aa9c-02a5b7b9b880	Table	2025-05-15 11:46:03.645795+05:30	9dc3f295-796c-42fa-8045-922506da01db	b2360679-8011-4649-b62e-f7b5249ee052	a5f15920-3aad-40bf-960b-b6c0e8952729	Yes
23687ac0-863a-4100-8f74-98f198de9b0f	Shipment	Related	Shipment Related Queries:	185733b0-6bee-4db5-8e39-a8f2a0e36a5a	Custom	2025-06-05 09:35:52.356067+05:30	e5774734-8787-4a02-b37e-8edade918a0f	\N	\N	No
ec5a5738-8141-4f7d-a8dc-273765175af5	CategoryList	Related	Great. What would you like to order? Checkout some of our popular categories: (here we will show some selected sub-categories that is fast moving)	724a7234-115e-4f4a-b2ae-7e60f4118808	Table	2025-05-15 11:34:07.109206+05:30	9dc3f295-796c-42fa-8045-922506da01db	f7719d60-99e1-4eaf-bc5b-3808d7354023	c4b40a73-3c0a-4f5b-ba36-a8fbeeb4a91f	No
0b78b70e-658d-49a6-879e-bcf4fb97ac76	SubCategoryList	Related	Fantastic Choice! Here are some of our yummy products in <category name>: (here we will show some selected products that is fast moving)	\N	Table	2025-06-04 09:33:34.641049+05:30	ec5a5738-8141-4f7d-a8dc-273765175af5	f0621fc7-9a9e-4fc9-a940-af38b882ba1c	3bf91025-fdb5-4884-9228-8c5d22c5ccdf	No
e3861552-6374-40b0-b41d-50983795af33	ProductList	Related	Select Product:	\N	Table	2025-06-04 09:35:05.306919+05:30	0b78b70e-658d-49a6-879e-bcf4fb97ac76	ab16453b-8d3d-4586-b4c6-89c2bad687cd	646c9cd0-ee3f-44e3-bae2-41f87d01ad71	Yes
e5774734-8787-4a02-b37e-8edade918a0f	FAQ  Categories	Related	Please select Related FAQ:	962918fc-2868-4623-9fe6-ac80ee26e544	Custom	2025-06-05 09:23:02.756301+05:30	9dc3f295-796c-42fa-8045-922506da01db	\N	\N	No
4cdd4cfe-82ad-466a-a14b-2b985118fc71	General Question 1	Related	Please check this:	9f0c6365-30f3-4978-a66e-6a12e2f38f28	Custom	2025-06-05 09:24:57.912822+05:30	e5774734-8787-4a02-b37e-8edade918a0f	\N	\N	No
ec650246-f1e0-4410-aa56-d72661b843a0	General Answer 1	End Message	We have 45 branches across Kerala. You can Locate your nearest store from our website https://www.navyabakers.com\r\n\r\nThank you.	58305aae-75ad-42f4-8175-a56ecc7e1190		2025-06-05 09:26:41.340265+05:30	4cdd4cfe-82ad-466a-a14b-2b985118fc71	\N	\N	No
ab02f238-115f-40bc-8310-2e3b2436dbeb	General Answer 2	End Message	Yes! We cater to bulk orders for events, corporate gifting, and celebrations.\r\nPlease contact us or call for inquiries.\r\n\r\nThank you	c9c181e6-3cb4-47ca-8aa4-96fe9aa444fc		2025-06-05 09:27:24.064504+05:30	4cdd4cfe-82ad-466a-a14b-2b985118fc71	\N	\N	No
0430b16e-f226-4e05-b2e5-76eff602660d	Payment Questions	Related	Payment related Queries:	97988da8-0de0-4856-a474-c68de4286223	Custom	2025-06-05 09:29:50.129684+05:30	e5774734-8787-4a02-b37e-8edade918a0f	\N	\N	No
023fd4ea-94c0-4e5d-937e-c3b5ccd49f6d	Payement Answer 1	End Message	We accept a variety of payment methods for your convenience, including credit cards, debit cards, UPI, online banking, and digital wallets like Paytm and Google Pay. For in-store purchases, cash payments are also accepted.\r\n\r\nThank you	878dc97a-fcc5-4a36-9be1-b1df445c0e46		2025-06-05 09:30:52.219075+05:30	0430b16e-f226-4e05-b2e5-76eff602660d	\N	\N	No
6df6fe46-1896-4a70-acf4-056d3bf12d8d	Payment Answer 2	End Message	Yes! We use SSL encryption and secure payment gateways to ensure your transactions are safe.	a1fb719d-019b-437c-a57e-6bde6758bb70		2025-06-05 09:31:20.976071+05:30	0430b16e-f226-4e05-b2e5-76eff602660d	\N	\N	No
4e7ab993-2314-4f58-a389-78bdca566945	Shipment Answers 1	End Message	Shipping charges depend on your location and order size. For local deliveries within [specific area], a flat rate applies.\r\n\r\nThank You	b9b64ed8-430c-4d59-b2df-848d722880b6		2025-06-05 09:36:47.382358+05:30	23687ac0-863a-4100-8f74-98f198de9b0f	\N	\N	No
a662cd31-1af2-4d0c-8777-5ba6b7b65d6a	Shipment Answer 2	End Message	When you place a Local Delivery Order, the system shows the available slots for you to choose from.\r\n\r\nThank You	3f89fd4a-dfc6-49d2-a476-8e37cb576855		2025-06-05 09:37:52.510718+05:30	23687ac0-863a-4100-8f74-98f198de9b0f	\N	\N	No
a914b771-1861-4df7-9b89-f5e1accc073b	Shipment Answer 3	End Message	Yes, you can choose from the available delivery slots displayed at checkout.\r\n\r\nThank You	dcc53425-b487-475b-bbe3-61408e565406		2025-06-05 09:38:26.256704+05:30	23687ac0-863a-4100-8f74-98f198de9b0f	\N	\N	No
d4db0bcb-6736-439a-94a4-c8976d08bbc8	Shipment Answer 4	End Message	A delivery delay setting is applied to ensure sufficient time for order preparation. The default delay is 120 minutes (2 hours), meaning only slots after this time will be shown for selection.\r\n\r\nThank You	3704db0b-14e4-49c8-ad44-93d59eb18d93		2025-06-05 09:38:56.249179+05:30	23687ac0-863a-4100-8f74-98f198de9b0f	\N	\N	No
d4767141-f4f8-4581-9265-78a908bf82ee	Shipment Answer 5	End Message	Free delivery is available if your order meets both of these conditions: \r\n● The delivery address is within 4 km of our store. \r\n● Your total order value is ₹400 or more\r\n\r\nThank You	1644cd2d-a080-4650-a8e5-f14adcb3f740		2025-06-05 09:39:35.628104+05:30	23687ac0-863a-4100-8f74-98f198de9b0f	\N	\N	No
fb87ec4e-e381-47fa-8a5d-971b58b2ac0c	Shipment Answer 6	End Message	No, free delivery is only applicable if your total order value is ₹400 or more within the free delivery distance. Otherwise, a delivery fee will apply.\r\n\r\nThank You	3aa3670c-55fd-401c-8d0e-92eb66deaa0f		2025-06-05 09:40:13.127862+05:30	23687ac0-863a-4100-8f74-98f198de9b0f	\N	\N	No
de076775-54e6-44bf-adef-1c80152c18ac	Shipment Answer 7	End Message	The system calculates the distance based on your delivery address and the nearest store location. If it falls within the default 4 km limit, your order may qualify for free delivery if the value condition is also met.	7b5269cf-b116-4be8-8980-7b29a6c35db0		2025-06-05 09:40:42.474149+05:30	23687ac0-863a-4100-8f74-98f198de9b0f	\N	\N	No
465dee91-4dc2-4d64-8c37-72261ee65f55	Shipment Answer 8	End Message	If your address is beyond the 4 km limit, a delivery fee will apply, regardless of the order value. The exact fee will be displayed at checkout.\r\n\r\nThank You	85372639-be33-4c28-b66b-eca44b0d6a90		2025-06-05 09:41:18.233138+05:30	23687ac0-863a-4100-8f74-98f198de9b0f	\N	\N	No
0a3b268a-01c8-4fb1-8c75-9fb7ae318ad2	Shipment Answer 9	End Message	If your order qualifies for free delivery, the actual delivery fee is shown as canceled (crossed-out) to indicate that no delivery charge applies.\r\n\r\nThank You	5476133b-cb44-4835-928c-37a0bdc739b9		2025-06-05 09:41:57.641626+05:30	23687ac0-863a-4100-8f74-98f198de9b0f	\N	\N	No
8a86f87c-1f75-4084-a5fc-f76f2821b647	Shipment Answer 10	End Message	Yes! Once your order is dispatched, you will receive details via Whatsapp, also it can be tracked in our mobile app.\r\n\r\nThank You	5758abd0-d535-4b5b-b1a2-1ab9abc12a0e		2025-06-05 09:42:35.90608+05:30	23687ac0-863a-4100-8f74-98f198de9b0f	\N	\N	No
16d773bb-5c1f-40a2-8362-0577cdfaea6a	Product Questions	Related	Here are the product related queries :	588f24a5-f9ef-4ea2-8154-0ebf9df6b9ab	Custom	2025-06-05 09:46:33.08588+05:30	e5774734-8787-4a02-b37e-8edade918a0f	\N	\N	No
033e66f2-e6f2-4667-9a9f-32e8f88588d0	Product Answer 1	End Message	We offer a variety of baked goods including cakes, cookies, pastries, breads, and more.\r\n\r\nThank You	ffc09c4a-9992-4bd1-90c8-b24af8e39b89		2025-06-05 09:47:07.72599+05:30	16d773bb-5c1f-40a2-8362-0577cdfaea6a	\N	\N	No
6982267d-2f4a-4ed7-ba62-f968af211242	Product Answer 2	End Message	Yes! All our products are baked fresh daily using the finest ingredients.\r\n\r\nThank You	e0080f9e-8976-4474-bf18-11be40a37c37		2025-06-05 09:47:38.647788+05:30	16d773bb-5c1f-40a2-8362-0577cdfaea6a	\N	\N	No
15cad848-d75f-474f-b9d6-56b69e006065	Product Answer 3	End Message	No, we take pride in using 100% natural flavors and colors, without any artificial preservatives.\r\n\r\nThank You	3bcd89d6-95bd-4b23-8b4f-47057d3ac6a4		2025-06-05 09:48:06.719722+05:30	16d773bb-5c1f-40a2-8362-0577cdfaea6a	\N	\N	No
d836353a-888b-473b-8899-002bb126c2dd	Product Answer 4	End Message	Absolutely! We offer custom cakes and pastries for birthdays, weddings, and special occasions. Contact us in advance for custom orders.\r\n\r\nThank You	a9d7b55b-55f5-4387-86aa-3caa8cebb81e		2025-06-05 09:48:33.857055+05:30	16d773bb-5c1f-40a2-8362-0577cdfaea6a	\N	\N	No
bcd24461-549a-4d93-9ef7-ccf82cfb7cf9	Product Answer 5	End Message	Yes, we have a selection of eggless, vegan, and gluten-free products. Please check the product description or contact us for details.\r\n\r\nThank You	e6ac1740-f6e8-4a35-8346-4abfab4ccd2a		2025-06-05 09:49:06.096088+05:30	16d773bb-5c1f-40a2-8362-0577cdfaea6a	\N	\N	No
4e214a10-aeba-4419-a24e-040451e2914d	Product Answer 6	End Message	Absolutely! You can add a custom message while ordering, and for special decorations, please contact us in advance, before delivery.\r\n\r\nThank You	a567dfe1-953d-48f9-90e5-ece4fe56df62		2025-06-05 09:49:42.455021+05:30	16d773bb-5c1f-40a2-8362-0577cdfaea6a	\N	\N	No
59e18f36-f617-4c07-b8fe-4863fb23ca60	Product Answer 7	End Message	Yes, we have gluten-free and sugar-free options. Please check the product description or filter by dietary preferences while browsing.\r\n\r\nThank You	7b83a88c-bc36-4439-93d8-502dc16bc391		2025-06-05 09:50:17.260926+05:30	16d773bb-5c1f-40a2-8362-0577cdfaea6a	\N	\N	No
216b80f4-b6b2-417a-a7c4-410cd6eb1f69	Product Answer 8	End Message	Our products are best consumed fresh. Please check the packaging for specific storage instructions.\r\n\r\nThank You	e2901682-442b-443f-a368-1a7c0c13b09f		2025-06-05 09:50:47.400637+05:30	16d773bb-5c1f-40a2-8362-0577cdfaea6a	\N	\N	No
fcda9cd8-afa0-48f8-8156-66bf59911b9e	End of Location	End Message	Thank You	\N		2025-06-05 09:52:04.518436+05:30	3d73bda2-9193-46f3-b917-b68011cbc893	\N	\N	No
\.


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

COPY public.chatbot_columnlist (id, column_name, table_id, column_id, created_date) FROM stdin;
f0621fc7-9a9e-4fc9-a940-af38b882ba1c	sub_category_name	3bf91025-fdb5-4884-9228-8c5d22c5ccdf	uuid	2025-04-28 12:36:01.397326+05:30
ab16453b-8d3d-4586-b4c6-89c2bad687cd	item_name	646c9cd0-ee3f-44e3-bae2-41f87d01ad71	id	2025-04-28 15:40:44.020906+05:30
f7719d60-99e1-4eaf-bc5b-3808d7354023	category_name	c4b40a73-3c0a-4f5b-ba36-a8fbeeb4a91f	uuid	2025-05-15 11:38:42.752893+05:30
70fdaf37-d404-4761-a5df-74612fbf94af	DiscountName	fee5bc0d-87ec-42d7-a0d1-0e8a2aca079e	id	2025-06-04 10:34:54.475813+05:30
b2360679-8011-4649-b62e-f7b5249ee052	unit_name	a5f15920-3aad-40bf-960b-b6c0e8952729	uuid	2025-06-04 10:45:46.280813+05:30
\.


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

COPY public.chatbot_maptables (id, map_name, created_date, table_name_id) FROM stdin;
c1cbc95f-f444-4e18-8ebe-16533a11f19e	Products	2025-05-21 11:37:39.659032+05:30	646c9cd0-ee3f-44e3-bae2-41f87d01ad71
b7206039-e948-46e6-b310-c8d72bec830e	Offers	2025-06-04 10:35:11.683909+05:30	fee5bc0d-87ec-42d7-a0d1-0e8a2aca079e
89d26681-a9f9-44c7-80ce-7d4b7528ec89	Address	2025-06-04 10:46:38.513355+05:30	a5f15920-3aad-40bf-960b-b6c0e8952729
\.


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

COPY public.chatbot_options (id, option_value, column_id, table_id) FROM stdin;
\.


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

COPY public.chatbot_relatedoptiontable (id, option_value) FROM stdin;
ea9dc62b-6dcf-4b01-908a-6d503f84a489	abc
1b14d541-265c-4922-84c1-6a8bfdd39875	bcd
996d1a86-8b32-48b2-8942-ade6198bbfaa	a
e818ee81-945d-4195-948b-8d8acae0feac	b
0223b822-9f9c-4ace-a804-ed63120f6ad7	aa
5e2e93ff-3281-40cc-af89-ccb040b7e398	bb
d814436b-e33a-4c58-9835-6918b5887fd5	Hai
28064bc1-5d83-4317-add4-01d40a651e38	Follow the gudeliness
0b4664bd-383e-4f8b-ba2b-669eed4bc10a	Welcome to the application
ebf910de-2a48-46ec-b10a-b3a6cad3970f	Welcome
55703038-b8b1-4ff6-8b3c-ba37b1aa6ded	query 1
ecf843aa-9dd5-4f10-ae51-6a523ffda957	query 2
724a7234-115e-4f4a-b2ae-7e60f4118808	Ordering
061c89a5-5064-41e4-aa9c-02a5b7b9b880	Store Location
7c7de156-d152-4766-ba66-fda31e139152	Special Offers
962918fc-2868-4623-9fe6-ac80ee26e544	FAQ
27b15efe-9992-4ca8-8045-7614c2839ec9	Enter Location
f250f53c-7348-4811-bb7a-98518fa456dc	Place 1
4ac8f4e5-ce54-490f-b545-f3845e45a996	Place 2
a63b835f-2ab1-4e7d-ba98-099d0f199ba0	Offer 1
ad8e03c6-c8f1-4251-82c4-61194eb38c55	Offer 2
883ac869-573d-48cc-83bb-fc4af2e5ed49	Offer 3
882738dc-e758-48e6-9aac-b14e8d4935c0	Offer 4
9f0c6365-30f3-4978-a66e-6a12e2f38f28	General
588f24a5-f9ef-4ea2-8154-0ebf9df6b9ab	Product
185733b0-6bee-4db5-8e39-a8f2a0e36a5a	Shipment
97988da8-0de0-4856-a474-c68de4286223	Payment
58305aae-75ad-42f4-8175-a56ecc7e1190	Where is your bakery located?
c9c181e6-3cb4-47ca-8aa4-96fe9aa444fc	Do you offer bulk or corporate orders?
878dc97a-fcc5-4a36-9be1-b1df445c0e46	What payment methods do you accept?
a1fb719d-019b-437c-a57e-6bde6758bb70	Is online payment secure?
e09b4232-3390-47f9-8e35-664e6d317fa8	What payment methods do you accept?
5a990021-3f33-4b38-b6a3-dc67c70b485f	Do you offer Cash on Delivery (COD)?
da2da1f3-4181-4d0e-82b3-6dcf14b88405	Do you provide invoices for online orders?
b9b64ed8-430c-4d59-b2df-848d722880b6	What are the shipping charges and delivery times?
3f89fd4a-dfc6-49d2-a476-8e37cb576855	What are delivery time slots?
dcc53425-b487-475b-bbe3-61408e565406	Can I select any delivery slot for my order?
3704db0b-14e4-49c8-ad44-93d59eb18d93	 Why can’t I see immediate delivery slots after placing an order?
1644cd2d-a080-4650-a8e5-f14adcb3f740	How does free delivery work?
3aa3670c-55fd-401c-8d0e-92eb66deaa0f	Can I get free delivery if my order is below ₹400?
7b5269cf-b116-4be8-8980-7b29a6c35db0	How is the free delivery distance calculated?
85372639-be33-4c28-b66b-eca44b0d6a90	What if address is beyond the free delivery distance?
5476133b-cb44-4835-928c-37a0bdc739b9	Why do I see a crossed-out delivery fee on my order summary?
5758abd0-d535-4b5b-b1a2-1ab9abc12a0e	Can I track my order?
ffc09c4a-9992-4bd1-90c8-b24af8e39b89	What types of baked goods do you offer?
e0080f9e-8976-4474-bf18-11be40a37c37	Are your products freshly baked?
3bcd89d6-95bd-4b23-8b4f-47057d3ac6a4	Do you use preservatives or artificial flavors?
a9d7b55b-55f5-4387-86aa-3caa8cebb81e	Can I customize my cake or pastries?
e6ac1740-f6e8-4a35-8346-4abfab4ccd2a	Do you offer eggless or vegan options?
a567dfe1-953d-48f9-90e5-ece4fe56df62	Can I request special decorations or a message on my cake?
7b83a88c-bc36-4439-93d8-502dc16bc391	Do you offer gluten-free or sugar-free options?
e2901682-442b-443f-a368-1a7c0c13b09f	How long will my baked goods stay fresh?
\.


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

COPY public.chatbot_tablelist (id, table_name, created_date) FROM stdin;
3bf91025-fdb5-4884-9228-8c5d22c5ccdf	ProductSubCategory	2025-04-28 12:36:01.395012+05:30
646c9cd0-ee3f-44e3-bae2-41f87d01ad71	Products	2025-04-28 15:40:44.01857+05:30
c4b40a73-3c0a-4f5b-ba36-a8fbeeb4a91f	ProductCategory	2025-05-15 11:38:42.749885+05:30
fee5bc0d-87ec-42d7-a0d1-0e8a2aca079e	Discount	2025-06-04 10:34:54.473123+05:30
a5f15920-3aad-40bf-960b-b6c0e8952729	Shop	2025-06-04 10:45:46.278792+05:30
\.


--
-- Name: chatbot_chat_data chatbot_chat_data_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chatbot_chat_data
    ADD CONSTRAINT chatbot_chat_data_pkey PRIMARY KEY (chat_id);


--
-- Name: chatbot_columnlist chatbot_columnlist_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chatbot_columnlist
    ADD CONSTRAINT chatbot_columnlist_pkey PRIMARY KEY (id);


--
-- Name: chatbot_maptables chatbot_maptables_map_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chatbot_maptables
    ADD CONSTRAINT chatbot_maptables_map_name_key UNIQUE (map_name);


--
-- Name: chatbot_maptables chatbot_maptables_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chatbot_maptables
    ADD CONSTRAINT chatbot_maptables_pkey PRIMARY KEY (id);


--
-- Name: chatbot_options chatbot_options_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chatbot_options
    ADD CONSTRAINT chatbot_options_pkey PRIMARY KEY (id);


--
-- Name: chatbot_relatedoptiontable chatbot_relatedoptiontable_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chatbot_relatedoptiontable
    ADD CONSTRAINT chatbot_relatedoptiontable_pkey PRIMARY KEY (id);


--
-- Name: chatbot_tablelist chatbot_tablelist_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chatbot_tablelist
    ADD CONSTRAINT chatbot_tablelist_pkey PRIMARY KEY (id);


--
-- Name: chatbot_tablelist chatbot_tablelist_table_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chatbot_tablelist
    ADD CONSTRAINT chatbot_tablelist_table_name_key UNIQUE (table_name);


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

CREATE INDEX chatbot_chat_data_option_column_id_16d6aa34 ON public.chatbot_chat_data USING btree (option_column_id);


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

CREATE INDEX chatbot_chat_data_option_table_id_cd601c06 ON public.chatbot_chat_data USING btree (option_table_id);


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

CREATE INDEX chatbot_chat_data_related_chat_id_866fad6b ON public.chatbot_chat_data USING btree (related_chat_id);


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

CREATE INDEX chatbot_chat_data_related_option_id_id_c888b96f ON public.chatbot_chat_data USING btree (related_option_id_id);


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

CREATE INDEX chatbot_columnlist_table_id_4054184d ON public.chatbot_columnlist USING btree (table_id);


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

CREATE INDEX chatbot_maptables_map_name_000b101e_like ON public.chatbot_maptables USING btree (map_name varchar_pattern_ops);


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

CREATE INDEX chatbot_maptables_table_name_id_c61c7999 ON public.chatbot_maptables USING btree (table_name_id);


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

CREATE INDEX chatbot_options_column_id_5d022efa ON public.chatbot_options USING btree (column_id);


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

CREATE INDEX chatbot_options_table_id_408e39aa ON public.chatbot_options USING btree (table_id);


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

CREATE INDEX chatbot_tablelist_table_name_fa161c58_like ON public.chatbot_tablelist USING btree (table_name varchar_pattern_ops);


--
-- Name: chatbot_chat_data chatbot_chat_data_option_column_id_16d6aa34_fk_chatbot_c; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chatbot_chat_data
    ADD CONSTRAINT chatbot_chat_data_option_column_id_16d6aa34_fk_chatbot_c FOREIGN KEY (option_column_id) REFERENCES public.chatbot_columnlist(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: chatbot_chat_data chatbot_chat_data_option_table_id_cd601c06_fk_chatbot_t; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chatbot_chat_data
    ADD CONSTRAINT chatbot_chat_data_option_table_id_cd601c06_fk_chatbot_t FOREIGN KEY (option_table_id) REFERENCES public.chatbot_tablelist(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: chatbot_chat_data chatbot_chat_data_related_chat_id_866fad6b_fk_chatbot_c; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chatbot_chat_data
    ADD CONSTRAINT chatbot_chat_data_related_chat_id_866fad6b_fk_chatbot_c FOREIGN KEY (related_chat_id) REFERENCES public.chatbot_chat_data(chat_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: chatbot_chat_data chatbot_chat_data_related_option_id_id_c888b96f_fk_chatbot_r; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chatbot_chat_data
    ADD CONSTRAINT chatbot_chat_data_related_option_id_id_c888b96f_fk_chatbot_r FOREIGN KEY (related_option_id_id) REFERENCES public.chatbot_relatedoptiontable(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: chatbot_columnlist chatbot_columnlist_table_id_4054184d_fk_chatbot_tablelist_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chatbot_columnlist
    ADD CONSTRAINT chatbot_columnlist_table_id_4054184d_fk_chatbot_tablelist_id FOREIGN KEY (table_id) REFERENCES public.chatbot_tablelist(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: chatbot_maptables chatbot_maptables_table_name_id_c61c7999_fk_chatbot_t; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chatbot_maptables
    ADD CONSTRAINT chatbot_maptables_table_name_id_c61c7999_fk_chatbot_t FOREIGN KEY (table_name_id) REFERENCES public.chatbot_tablelist(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: chatbot_options chatbot_options_column_id_5d022efa_fk_chatbot_columnlist_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chatbot_options
    ADD CONSTRAINT chatbot_options_column_id_5d022efa_fk_chatbot_columnlist_id FOREIGN KEY (column_id) REFERENCES public.chatbot_columnlist(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: chatbot_options chatbot_options_table_id_408e39aa_fk_chatbot_tablelist_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chatbot_options
    ADD CONSTRAINT chatbot_options_table_id_408e39aa_fk_chatbot_tablelist_id FOREIGN KEY (table_id) REFERENCES public.chatbot_tablelist(id) DEFERRABLE INITIALLY DEFERRED;


--
-- PostgreSQL database dump complete
--

