-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathreservation_dev_full.sql
More file actions
2148 lines (1693 loc) · 209 KB
/
Copy pathreservation_dev_full.sql
File metadata and controls
2148 lines (1693 loc) · 209 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
--
-- PostgreSQL database dump
--
\restrict 97HXEmaarvqB0LNih5agomOjpj74Pi4jQ4Xr0Wz7uAlk3SEReQITYMSuuFDGqdh
-- Dumped from database version 18.1
-- Dumped by pg_dump version 18.1
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_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;
--
-- Name: core; Type: SCHEMA; Schema: -; Owner: -
--
CREATE SCHEMA core;
--
-- Name: address_type_enum; Type: TYPE; Schema: core; Owner: -
--
CREATE TYPE core.address_type_enum AS ENUM (
'PRIMARY',
'BILLING',
'BRANCH'
);
--
-- Name: availability_exception_type_enum; Type: TYPE; Schema: core; Owner: -
--
CREATE TYPE core.availability_exception_type_enum AS ENUM (
'CLOSED',
'SPECIAL_OPEN'
);
--
-- Name: booking_status_enum; Type: TYPE; Schema: core; Owner: -
--
CREATE TYPE core.booking_status_enum AS ENUM (
'INITIATED',
'SLOT_SELECTED',
'CONTACT_COLLECTED',
'PAYMENT_PENDING',
'CONFIRMED',
'CANCELLED',
'FAILED',
'HUMAN_HANDOFF',
'PENDING_PAYMENT',
'CANCELED',
'RESCHEDULED',
'EXPIRED',
'PENDING'
);
--
-- Name: call_outcome_enum; Type: TYPE; Schema: core; Owner: -
--
CREATE TYPE core.call_outcome_enum AS ENUM (
'BOOKING_CREATED',
'BOOKING_CANCELLED',
'BOOKING_RESCHEDULED',
'STATUS_PROVIDED',
'INFO_PROVIDED',
'ESCALATED_TO_HUMAN',
'NO_ACTION',
'FAILED',
'PAY_LATER'
);
--
-- Name: call_resolution_enum; Type: TYPE; Schema: core; Owner: -
--
CREATE TYPE core.call_resolution_enum AS ENUM (
'AI_RESOLVED',
'HUMAN_ESCALATED',
'USER_ABANDONED',
'TECHNICAL_FAILURE',
'TRANSFERRED'
);
--
-- Name: call_status_enum; Type: TYPE; Schema: core; Owner: -
--
CREATE TYPE core.call_status_enum AS ENUM (
'IN_PROGRESS',
'COMPLETED',
'ESCALATED',
'ABANDONED',
'FAILED'
);
--
-- Name: conversation_channel_enum; Type: TYPE; Schema: core; Owner: -
--
CREATE TYPE core.conversation_channel_enum AS ENUM (
'CHAT',
'VOICE',
'HUMAN'
);
--
-- Name: conversation_outcome_enum; Type: TYPE; Schema: core; Owner: -
--
CREATE TYPE core.conversation_outcome_enum AS ENUM (
'BOOKED',
'ESCALATED',
'DROPPED'
);
--
-- Name: conversation_status_enum; Type: TYPE; Schema: core; Owner: -
--
CREATE TYPE core.conversation_status_enum AS ENUM (
'STARTED',
'IN_PROGRESS',
'RESOLVED',
'ABANDONED'
);
--
-- Name: handoff_status_enum; Type: TYPE; Schema: core; Owner: -
--
CREATE TYPE core.handoff_status_enum AS ENUM (
'OPEN',
'ASSIGNED',
'RESOLVED',
'CLOSED'
);
--
-- Name: industry_enum; Type: TYPE; Schema: core; Owner: -
--
CREATE TYPE core.industry_enum AS ENUM (
'HOTEL',
'RESTAURANT',
'SALON',
'CLINIC',
'OTHER',
'SPA'
);
--
-- Name: notification_channel_enum; Type: TYPE; Schema: core; Owner: -
--
CREATE TYPE core.notification_channel_enum AS ENUM (
'EMAIL',
'SMS',
'WHATSAPP'
);
--
-- Name: payment_provider_enum; Type: TYPE; Schema: core; Owner: -
--
CREATE TYPE core.payment_provider_enum AS ENUM (
'STRIPE',
'SSLCOMMERZ',
'RAZORPAY',
'OTHER'
);
--
-- Name: payment_status_enum; Type: TYPE; Schema: core; Owner: -
--
CREATE TYPE core.payment_status_enum AS ENUM (
'CREATED',
'PENDING',
'PAID',
'FAILED',
'EXPIRED',
'REFUNDED'
);
--
-- Name: resolution_type_enum; Type: TYPE; Schema: core; Owner: -
--
CREATE TYPE core.resolution_type_enum AS ENUM (
'AI_RESOLVED',
'HUMAN_HANDOFF',
'USER_ABANDONED',
'FAILED',
'HUMAN_ESCALATED',
'CALL_REQUESTED'
);
--
-- Name: update_call_transcript_search(); Type: FUNCTION; Schema: core; Owner: -
--
CREATE FUNCTION core.update_call_transcript_search() RETURNS trigger
LANGUAGE plpgsql
AS $$
BEGIN
NEW.transcript_search := to_tsvector('english', COALESCE(NEW.full_transcript, ''));
NEW.updated_at := NOW();
RETURN NEW;
END;
$$;
SET default_tablespace = '';
SET default_table_access_method = heap;
--
-- Name: admin_business_access; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.admin_business_access (
id uuid DEFAULT gen_random_uuid() NOT NULL,
admin_user_id uuid NOT NULL,
business_id uuid NOT NULL,
permission character varying(40) NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL
);
--
-- Name: admin_users; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.admin_users (
id uuid DEFAULT gen_random_uuid() NOT NULL,
email character varying(255) NOT NULL,
password_hash text NOT NULL,
full_name character varying(120),
role character varying(40) NOT NULL,
is_active boolean DEFAULT true,
last_login_at timestamp with time zone,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL
);
--
-- Name: booking_status_history; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.booking_status_history (
id uuid DEFAULT gen_random_uuid() NOT NULL,
business_id uuid NOT NULL,
booking_id uuid NOT NULL,
from_status core.booking_status_enum,
to_status core.booking_status_enum NOT NULL,
reason character varying(200),
note text,
changed_by_admin_id uuid,
changed_at timestamp with time zone DEFAULT now()
);
--
-- Name: bookings; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.bookings (
id uuid DEFAULT gen_random_uuid() NOT NULL,
business_id uuid NOT NULL,
conversation_id uuid,
service_id uuid NOT NULL,
public_tracking_id character varying(20) NOT NULL,
status core.booking_status_enum DEFAULT 'INITIATED'::core.booking_status_enum,
resolution_type core.resolution_type_enum,
slot_start timestamp with time zone,
slot_end timestamp with time zone,
customer_name character varying(120),
customer_phone character varying(40),
customer_email character varying(255),
contact_collected_at timestamp with time zone,
notes text,
created_at timestamp with time zone DEFAULT now(),
updated_at timestamp with time zone DEFAULT now(),
payment_status core.payment_status_enum DEFAULT 'CREATED'::core.payment_status_enum NOT NULL,
paid_at timestamp with time zone,
confirmed_at timestamp with time zone,
CONSTRAINT chk_booking_slot_range_valid CHECK (((slot_start IS NULL) OR (slot_end IS NULL) OR (slot_end > slot_start)))
);
--
-- Name: business_addresses; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.business_addresses (
id uuid DEFAULT gen_random_uuid() NOT NULL,
business_id uuid NOT NULL,
address_type core.address_type_enum DEFAULT 'PRIMARY'::core.address_type_enum NOT NULL,
street text,
city character varying(100),
state character varying(100),
zip_code character varying(30),
country character varying(100),
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL
);
--
-- Name: business_ai_settings; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.business_ai_settings (
id uuid DEFAULT gen_random_uuid() NOT NULL,
business_id uuid NOT NULL,
agent_name character varying(120) NOT NULL,
tone_of_voice character varying(120),
personality text,
business_display_name character varying(200),
is_ai_enabled boolean DEFAULT true,
fallback_to_human boolean DEFAULT true,
created_at timestamp with time zone DEFAULT now(),
updated_at timestamp with time zone DEFAULT now(),
voice_id character varying(120),
confidence_threshold numeric(4,3) DEFAULT 0.650 NOT NULL,
allow_cancel_bookings boolean DEFAULT false NOT NULL,
allow_reschedule_bookings boolean DEFAULT false NOT NULL,
mention_promotions boolean DEFAULT false NOT NULL,
welcome_message text,
fallback_message text,
escalation_message text,
max_retries integer DEFAULT 3,
language character varying(20) DEFAULT 'en'::character varying,
min_notice_hours integer DEFAULT 24,
max_per_slot integer DEFAULT 1,
cancellation_policy text,
CONSTRAINT chk_ai_confidence_threshold_range CHECK (((confidence_threshold >= 0.0) AND (confidence_threshold <= 1.0)))
);
--
-- Name: business_availability_exceptions; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.business_availability_exceptions (
id uuid DEFAULT gen_random_uuid() NOT NULL,
business_id uuid NOT NULL,
exception_type core.availability_exception_type_enum NOT NULL,
start_at timestamp with time zone NOT NULL,
end_at timestamp with time zone NOT NULL,
note text,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL,
CONSTRAINT chk_availability_exception_range_valid CHECK ((end_at > start_at))
);
--
-- Name: business_notification_settings; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.business_notification_settings (
id uuid DEFAULT gen_random_uuid() NOT NULL,
business_id uuid NOT NULL,
email_alerts_enabled boolean DEFAULT false,
sms_alerts_enabled boolean DEFAULT false,
whatsapp_alerts_enabled boolean DEFAULT false,
created_at timestamp with time zone DEFAULT now(),
updated_at timestamp with time zone DEFAULT now()
);
--
-- Name: business_operating_hours; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.business_operating_hours (
id uuid DEFAULT gen_random_uuid() NOT NULL,
business_id uuid NOT NULL,
day_of_week smallint NOT NULL,
open_time time without time zone,
close_time time without time zone,
is_closed boolean DEFAULT false,
created_at timestamp with time zone DEFAULT now(),
updated_at timestamp with time zone DEFAULT now(),
CONSTRAINT chk_business_day_of_week CHECK (((day_of_week >= 0) AND (day_of_week <= 6)))
);
--
-- Name: business_profiles; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.business_profiles (
business_id uuid NOT NULL,
contact_person character varying(120),
email character varying(255),
phone character varying(40),
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL
);
--
-- Name: businesses; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.businesses (
id uuid DEFAULT gen_random_uuid() NOT NULL,
slug character varying(120) NOT NULL,
business_name character varying(200) NOT NULL,
industry core.industry_enum NOT NULL,
timezone character varying(64) NOT NULL,
status character varying(30) DEFAULT 'ACTIVE'::character varying,
created_by_admin_id uuid,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL,
description text,
phone character varying(40),
email character varying(255),
website character varying(255),
address text,
city character varying(100),
country character varying(100),
default_currency character varying(3) DEFAULT 'BDT'::character varying,
is_active boolean DEFAULT true,
industry_label character varying(100),
contact_person character varying(120),
street_address text,
state character varying(100),
zip_code character varying(30)
);
--
-- Name: call_sessions; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.call_sessions (
id uuid DEFAULT gen_random_uuid() NOT NULL,
business_id uuid NOT NULL,
public_call_id character varying(20) NOT NULL,
provider_call_id character varying(100),
caller_phone character varying(40),
caller_country character varying(10),
channel character varying(20) DEFAULT 'VOICE'::character varying,
status core.call_status_enum DEFAULT 'IN_PROGRESS'::core.call_status_enum,
started_at timestamp with time zone DEFAULT now(),
answered_at timestamp with time zone,
ended_at timestamp with time zone,
duration_seconds integer,
total_ai_messages integer DEFAULT 0,
total_user_messages integer DEFAULT 0,
resolution_type core.call_resolution_enum,
outcome core.call_outcome_enum,
conversation_id uuid,
booking_id uuid,
handoff_id uuid,
full_transcript text,
transcript_search tsvector,
extra_data jsonb DEFAULT '{}'::jsonb,
created_at timestamp with time zone DEFAULT now(),
updated_at timestamp with time zone DEFAULT now()
);
--
-- Name: conversation_messages; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.conversation_messages (
id uuid DEFAULT gen_random_uuid() NOT NULL,
business_id uuid NOT NULL,
conversation_id uuid NOT NULL,
role character varying(20) NOT NULL,
content text NOT NULL,
metadata jsonb,
created_at timestamp with time zone DEFAULT now()
);
--
-- Name: conversations; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.conversations (
id uuid DEFAULT gen_random_uuid() NOT NULL,
business_id uuid NOT NULL,
channel core.conversation_channel_enum NOT NULL,
status core.conversation_status_enum DEFAULT 'STARTED'::core.conversation_status_enum,
resolution_type core.resolution_type_enum,
started_at timestamp with time zone DEFAULT now(),
resolved_at timestamp with time zone,
user_session_id character varying(120),
last_message_at timestamp with time zone,
created_at timestamp with time zone DEFAULT now(),
updated_at timestamp with time zone DEFAULT now(),
outcome core.conversation_outcome_enum,
last_activity_at timestamp with time zone,
closed_at timestamp with time zone
);
--
-- Name: handoff_requests; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.handoff_requests (
id uuid DEFAULT gen_random_uuid() NOT NULL,
business_id uuid NOT NULL,
conversation_id uuid NOT NULL,
booking_id uuid,
status core.handoff_status_enum DEFAULT 'OPEN'::core.handoff_status_enum,
reason character varying(80) NOT NULL,
contact_name character varying(120),
contact_phone character varying(40),
contact_email character varying(255),
assigned_to_admin_id uuid,
created_at timestamp with time zone DEFAULT now(),
updated_at timestamp with time zone DEFAULT now(),
resolved_at timestamp with time zone,
public_ticket_id character varying(24),
handoff_token character varying(80)
);
--
-- Name: payment_events; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.payment_events (
id uuid DEFAULT gen_random_uuid() NOT NULL,
business_id uuid NOT NULL,
provider character varying(30) NOT NULL,
provider_event_id character varying(255),
event_type character varying(120) NOT NULL,
payload jsonb NOT NULL,
received_at timestamp with time zone DEFAULT now()
);
--
-- Name: payment_sessions; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.payment_sessions (
id uuid DEFAULT gen_random_uuid() NOT NULL,
business_id uuid NOT NULL,
booking_id uuid NOT NULL,
provider character varying(30) NOT NULL,
provider_session_id character varying(255),
amount numeric(12,2) NOT NULL,
currency character(3) NOT NULL,
status character varying(30) DEFAULT 'PENDING'::character varying,
payment_url text,
paid_at timestamp with time zone,
created_at timestamp with time zone DEFAULT now(),
updated_at timestamp with time zone DEFAULT now()
);
--
-- Name: service_capacity_rules; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.service_capacity_rules (
id uuid DEFAULT gen_random_uuid() NOT NULL,
business_id uuid NOT NULL,
service_id uuid NOT NULL,
capacity integer NOT NULL,
slot_length_minutes integer DEFAULT 30,
created_at timestamp with time zone DEFAULT now(),
updated_at timestamp with time zone DEFAULT now()
);
--
-- Name: service_images; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.service_images (
id uuid DEFAULT gen_random_uuid() NOT NULL,
business_id uuid NOT NULL,
service_id uuid NOT NULL,
image_url text NOT NULL,
alt_text character varying(200),
sort_order integer DEFAULT 0,
created_at timestamp with time zone DEFAULT now()
);
--
-- Name: services; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.services (
id uuid DEFAULT gen_random_uuid() NOT NULL,
business_id uuid NOT NULL,
slug character varying(140) NOT NULL,
service_name character varying(200) NOT NULL,
description text,
base_price numeric(12,2),
currency character(3),
duration_minutes integer,
is_active boolean DEFAULT true,
created_at timestamp with time zone DEFAULT now(),
updated_at timestamp with time zone DEFAULT now(),
category character varying(50) DEFAULT 'GENERAL'::character varying,
location character varying(200),
is_popular boolean DEFAULT false,
service_type character varying(20) DEFAULT 'IN_PERSON'::character varying,
max_capacity integer DEFAULT 1,
icon character varying(50)
);
--
-- Name: system_events; Type: TABLE; Schema: core; Owner: -
--
CREATE TABLE core.system_events (
id uuid DEFAULT gen_random_uuid() NOT NULL,
business_id uuid NOT NULL,
event_name character varying(120) NOT NULL,
entity_type character varying(60),
entity_id uuid,
metadata jsonb,
created_at timestamp with time zone DEFAULT now()
);
--
-- Data for Name: admin_business_access; Type: TABLE DATA; Schema: core; Owner: -
--
COPY core.admin_business_access (id, admin_user_id, business_id, permission, created_at) FROM stdin;
3f22251b-be63-41e1-aa98-e9c5e4b3ea8a d4e73189-4763-4ada-9ac7-42d195b01a04 bfa73499-59af-41c4-a17a-8b739453f99a OWNER 2026-01-26 11:13:22.97845+06
\.
--
-- Data for Name: admin_users; Type: TABLE DATA; Schema: core; Owner: -
--
COPY core.admin_users (id, email, password_hash, full_name, role, is_active, last_login_at, created_at, updated_at) FROM stdin;
d4e73189-4763-4ada-9ac7-42d195b01a04 admin@yourdomain.com $2b$12$eK3TzMqbFywToRL18X2E1ui3ARcyFnwqvsTAvPalLZ9ZcpXUc0JR. System Admin ADMIN t 2026-02-10 05:44:48.472926+06 2026-01-26 11:12:42.58247+06 2026-02-10 05:44:48.473926+06
\.
--
-- Data for Name: booking_status_history; Type: TABLE DATA; Schema: core; Owner: -
--
COPY core.booking_status_history (id, business_id, booking_id, from_status, to_status, reason, note, changed_by_admin_id, changed_at) FROM stdin;
9a78a226-2c0c-48fe-b694-4b11f6104d3b b21b3707-fecd-4beb-af5b-470335a76577 beac3036-086e-448a-ae4e-1084aede702b INITIATED CONFIRMED stripe_confirm_payment paid session=cs_test_a1EUwcTFPIq5WZNuakqIB5AvqPoIontmst3Tb5aMSskUwLoqEp85tbkXP1 \N 2026-02-11 06:38:46.949419+06
\.
--
-- Data for Name: bookings; Type: TABLE DATA; Schema: core; Owner: -
--
COPY core.bookings (id, business_id, conversation_id, service_id, public_tracking_id, status, resolution_type, slot_start, slot_end, customer_name, customer_phone, customer_email, contact_collected_at, notes, created_at, updated_at, payment_status, paid_at, confirmed_at) FROM stdin;
cad25408-d38e-4905-a775-4ea4db70db2b b21b3707-fecd-4beb-af5b-470335a76577 0b58a87e-31a5-482e-b2aa-8d5342774ebd 85dc962d-6a4f-4059-9724-a9d352299829 BK-B62BDE PENDING_PAYMENT \N 2026-02-09 10:00:00+06 2026-02-09 11:00:00+06 Emon 01700000000 emon@test.com 2026-02-08 02:30:51.993464+06 \N 2026-02-08 02:29:41.046069+06 2026-02-08 02:30:51.997462+06 PENDING \N \N
3d88dc0d-1a8d-4226-a749-982786214903 bfa73499-59af-41c4-a17a-8b739453f99a dd36a591-9a78-4b6b-8c8c-2632a57d79ae dfbc3198-6147-4808-8cc9-a57b95b3469f BK-5CB49A CONFIRMED \N 2023-10-06 15:00:00+06 2023-10-06 16:00:00+06 Emon Karmoker 01712345678 emon@example.com 2026-01-28 02:44:39.811516+06 \N 2026-01-28 02:42:12.989041+06 2026-01-28 02:45:34.274942+06 CREATED \N 2026-01-28 02:45:34.274942+06
778ca7a4-a5e8-4dd8-b69e-7362def6d3ab bfa73499-59af-41c4-a17a-8b739453f99a e1e346bb-1539-431d-8aef-7874ca5f55a7 dfbc3198-6147-4808-8cc9-a57b95b3469f BK-90F085 INITIATED \N \N \N \N \N \N \N \N 2026-01-28 03:19:53.172513+06 2026-01-28 03:19:53.172513+06 CREATED \N \N
d1f60916-0b39-4e19-b7a5-da8ad5448a92 bfa73499-59af-41c4-a17a-8b739453f99a 76a0b0f2-7569-4a7f-9dcc-1399e1a85cd0 dfbc3198-6147-4808-8cc9-a57b95b3469f BK-327806 SLOT_SELECTED \N 2023-10-06 16:00:00+06 2023-10-06 17:00:00+06 \N \N \N \N \N 2026-01-28 03:27:56.994729+06 2026-01-28 03:40:35.2224+06 CREATED \N \N
09711c80-bd4b-4212-828d-0698d7c2a261 bfa73499-59af-41c4-a17a-8b739453f99a 86d0e2c6-8cdd-4cce-80aa-d68ae54f2bbc dfbc3198-6147-4808-8cc9-a57b95b3469f BK-31336F CANCELLED \N 2026-01-29 14:00:00+06 2026-01-29 15:00:00+06 \N \N \N \N \N 2026-01-28 08:28:21.649144+06 2026-01-28 08:56:02.383372+06 CREATED \N \N
e4dd2ceb-2587-48c3-850b-22490e5e6343 b21b3707-fecd-4beb-af5b-470335a76577 c5e30045-c8d3-462f-ae25-abc5828c5e10 85dc962d-6a4f-4059-9724-a9d352299829 BK-040613 CONFIRMED \N 2026-02-09 03:00:00+06 2026-02-09 04:00:00+06 Emon 01700000000 emon@test.com 2026-02-08 02:49:09.918031+06 \N 2026-02-08 02:48:35.290088+06 2026-02-08 08:35:33.43428+06 PAID 2026-02-08 08:35:33.433279+06 2026-02-08 08:35:33.433279+06
6859c63f-ca6e-4a1c-a92a-af00d9f188f9 bfa73499-59af-41c4-a17a-8b739453f99a 11a6fdcc-c203-45b7-b889-44615400abc1 57ee577a-073d-4e0b-9168-a68744959a51 BK-D14653 CANCELLED \N 2026-01-29 11:00:00+06 2026-01-29 12:00:00+06 Emon 01712345678 emon@test.com 2026-01-28 08:59:14.991438+06 \N 2026-01-28 08:58:30.21189+06 2026-01-28 08:59:54.026087+06 CREATED \N \N
f5fa014f-fa86-4a18-866b-dc63f0f027da bfa73499-59af-41c4-a17a-8b739453f99a 3e929134-a26b-4a74-ae34-186657a49084 dfbc3198-6147-4808-8cc9-a57b95b3469f BK-B48A7A CANCELLED \N 2026-01-30 15:00:00+06 2026-01-30 16:00:00+06 Emon 01712345678 emon@test.com 2026-01-29 10:58:55.330973+06 \N 2026-01-29 10:55:50.104022+06 2026-01-29 10:59:21.292132+06 CREATED \N \N
2583d0e1-f5d6-4d30-8d4d-b7cf3e5579d0 bfa73499-59af-41c4-a17a-8b739453f99a ee4e02d7-1205-4caf-809f-c54549032580 57ee577a-073d-4e0b-9168-a68744959a51 BK-D37057 CONFIRMED \N 2026-02-15 11:00:00+06 2026-02-15 12:00:00+06 Rahim Khan 01855555555 rahim@gmail.com 2026-01-29 11:08:23.337717+06 \N 2026-01-29 11:07:36.371849+06 2026-01-29 11:08:44.735848+06 CREATED \N 2026-01-29 11:08:44.735848+06
82e5f9ef-c3a3-4060-a76d-65b03c9f2c81 bfa73499-59af-41c4-a17a-8b739453f99a 97620902-198b-475c-a400-08278ee5f4f7 57ee577a-073d-4e0b-9168-a68744959a51 BK-53F0FD PENDING_PAYMENT \N 2026-02-11 15:00:00+06 2026-02-11 16:00:00+06 John 01712345678 john@test.com 2026-02-10 06:20:26.955691+06 \N 2026-02-10 06:20:26.929882+06 2026-02-10 06:24:51.922829+06 PENDING \N \N
44e7b83f-455c-4bd7-af9f-fe8099c5e984 4a048ca8-b311-499d-b088-ea92a9c2787f 2117b8fd-10e0-4b2d-8905-304be46f458d b178a366-c01f-4510-b80a-d1d3047c2022 BK-80C97D CANCELLED \N 2026-02-11 17:00:00+06 2026-02-11 18:00:00+06 John Doe +8801711111111 john@test.com 2026-02-10 05:53:27.571392+06 \N 2026-02-10 05:51:23.007978+06 2026-02-10 06:36:01.498986+06 PENDING \N \N
219bbac6-d515-4346-b440-e10b9cd55505 4a048ca8-b311-499d-b088-ea92a9c2787f a500c7d1-3f70-49fc-84d6-7b2276825881 b178a366-c01f-4510-b80a-d1d3047c2022 BK-8BE2CC CANCELLED \N 2026-02-12 10:00:00+06 2026-02-12 11:00:00+06 John Doe +8801711111111 john@test.com 2026-02-10 06:47:21.362181+06 \N 2026-02-10 06:47:21.334989+06 2026-02-10 07:06:39.979478+06 PENDING \N \N
ba64b3a1-65e1-4a3f-a376-848eea45acba bfa73499-59af-41c4-a17a-8b739453f99a aa2d9178-c8af-459f-9679-438086f3c0ad dfbc3198-6147-4808-8cc9-a57b95b3469f BK-B9E24E CANCELLED \N 2026-02-20 10:00:00+06 2026-02-20 11:00:00+06 Fatima Rahman 01677777777 fatima@gmail.com 2026-01-29 11:16:02.188895+06 \N 2026-01-29 11:16:02.175891+06 2026-01-29 11:22:48.240413+06 CREATED \N 2026-01-29 11:16:02.195404+06
228c2c9f-288a-4fd5-8ac0-c60190ca575d bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 dfbc3198-6147-4808-8cc9-a57b95b3469f BK-6E4541 CONTACT_COLLECTED \N 2026-01-30 16:00:00+06 2026-01-30 17:00:00+06 Emon 01712345678 emon@test.com 2026-01-29 11:23:32.465346+06 \N 2026-01-29 11:18:02.560437+06 2026-01-29 11:23:32.465346+06 CREATED \N 2026-01-29 11:20:51.86791+06
dcffb564-9883-492b-8f7e-8a5b5252f734 bfa73499-59af-41c4-a17a-8b739453f99a 9c3539cb-36c7-4905-ba04-47ff86dadc6e 57ee577a-073d-4e0b-9168-a68744959a51 BK-F1AA54 CONFIRMED \N 2026-03-05 11:00:00+06 2026-03-05 12:00:00+06 Voice User 01788888888 voice@test.com 2026-01-29 11:25:49.638577+06 \N 2026-01-29 11:25:00.433277+06 2026-01-29 11:26:14.310037+06 CREATED \N 2026-01-29 11:26:14.310037+06
0170cafb-d552-40bc-9e27-29126988414e 4a048ca8-b311-499d-b088-ea92a9c2787f a500c7d1-3f70-49fc-84d6-7b2276825881 b178a366-c01f-4510-b80a-d1d3047c2022 BK-052EA8 CANCELLED \N 2026-02-13 11:00:00+06 2026-02-13 12:00:00+06 John Doe +8801711111111 john@test.com 2026-02-10 07:10:12.593823+06 \N 2026-02-10 07:10:12.569346+06 2026-02-10 08:02:57.837522+06 PAID 2026-02-10 07:58:00.795582+06 2026-02-10 07:58:00.795582+06
54dd03cb-bee4-4920-b24f-a45328204bd1 bfa73499-59af-41c4-a17a-8b739453f99a 5a1465de-b5a6-4c6f-be17-b3a0f6d00827 57ee577a-073d-4e0b-9168-a68744959a51 BK-E2292F CONFIRMED \N 2026-02-03 10:00:00+06 2026-02-03 11:00:00+06 Test User 01700000000 test@test.com 2026-02-02 02:21:03.036975+06 \N 2026-02-02 02:21:03.025563+06 2026-02-02 02:21:03.040974+06 CREATED \N 2026-02-02 02:21:03.040974+06
b93dc91d-c088-4b02-97a2-c663190b9a73 bfa73499-59af-41c4-a17a-8b739453f99a 0555ab52-fa58-43a2-af36-24dac7ce0643 712720c7-235b-454c-a46e-69d806de9c29 BK-369747 RESCHEDULED \N 2026-02-05 14:00:00+06 2026-02-05 15:00:00+06 Emon Karmoker 01712345678 emon@example.com 2026-01-28 09:02:12.205089+06 \N 2026-01-28 09:01:22.277851+06 2026-02-02 02:21:44.234529+06 CREATED \N 2026-01-28 09:02:39.851135+06
a36c4c18-b4d9-4447-92b1-5f05fb46ba1f bfa73499-59af-41c4-a17a-8b739453f99a 3e929134-a26b-4a74-ae34-186657a49084 dfbc3198-6147-4808-8cc9-a57b95b3469f BK-DD31A0 CONFIRMED \N 2026-02-03 15:00:00+06 2026-02-03 16:00:00+06 Emon 01712345678 emon@test.com 2026-02-02 02:25:41.801417+06 \N 2026-02-02 02:25:09.286614+06 2026-02-02 02:25:56.758279+06 CREATED \N 2026-02-02 02:25:56.758279+06
fb70e147-07ee-4b03-8b97-477682208d84 bfa73499-59af-41c4-a17a-8b739453f99a e5f4e02f-5998-4646-bce7-d42e81c79073 712720c7-235b-454c-a46e-69d806de9c29 BK-9EE9A5 CONFIRMED \N 2026-02-10 14:00:00+06 2026-02-10 15:00:00+06 Karim Ahmed 01899999999 karim@test.com 2026-02-02 02:26:36.653329+06 \N 2026-02-02 02:26:36.612549+06 2026-02-02 02:26:36.659331+06 CREATED \N 2026-02-02 02:26:36.659331+06
beac3036-086e-448a-ae4e-1084aede702b b21b3707-fecd-4beb-af5b-470335a76577 7e4e669b-c098-4364-8952-79cbe4b24c42 85dc962d-6a4f-4059-9724-a9d352299829 BK-601AF4 CONFIRMED \N \N \N \N \N \N \N \N 2026-02-11 06:00:42.139291+06 2026-02-11 06:38:46.947407+06 PAID 2026-02-11 06:38:46.946408+06 2026-02-11 06:38:46.946408+06
dfccc7f3-243b-4c2b-9981-5b15bd50bdc1 0a20c0dc-c352-40f8-bc18-8ccbd8ce0a60 b81e25f2-d867-435d-a972-1c913de7e736 65024ad9-577d-482f-be76-ba36c9809f80 BK-26F1B2 CONFIRMED \N 2026-02-10 10:00:00+06 2026-02-10 11:00:00+06 Emon 01700000000 emon@example.com 2026-02-05 04:36:50.28711+06 \N 2026-02-05 04:36:50.275417+06 2026-02-05 04:36:50.291109+06 CREATED \N 2026-02-05 04:36:50.291109+06
b1f5274e-3826-426c-8bf0-8bb5ff30b2b3 0a20c0dc-c352-40f8-bc18-8ccbd8ce0a60 \N 65024ad9-577d-482f-be76-ba36c9809f80 BK-447D7D PENDING \N 2026-02-10 10:00:00+06 2026-02-10 11:00:00+06 Emon 01700000000 emon@example.com \N High floor, late check-in if possible 2026-02-07 03:30:40.661083+06 2026-02-07 03:53:03.494548+06 CREATED \N \N
ba941b6b-b383-4799-b185-dd12ad59bd1a 0a20c0dc-c352-40f8-bc18-8ccbd8ce0a60 1671fe69-5737-4352-b89e-c6dc1543e457 65024ad9-577d-482f-be76-ba36c9809f80 BK-E40D6A CONTACT_COLLECTED \N 2026-02-10 12:00:00+06 2026-02-10 13:00:00+06 Emon 01700000000 emon@test.com 2026-02-07 05:28:15.62762+06 \N 2026-02-07 05:25:35.804659+06 2026-02-07 05:28:15.62762+06 CREATED \N \N
0406da6e-25c6-48b8-8ec2-8335ad7326b9 0a20c0dc-c352-40f8-bc18-8ccbd8ce0a60 5ece81f5-2e8a-4bcc-97b6-d733862639e8 65024ad9-577d-482f-be76-ba36c9809f80 BK-7F6782 PENDING_PAYMENT \N 2026-02-10 00:00:00+06 2026-02-10 01:00:00+06 Emon 01700000000 emon@test.com 2026-02-07 06:22:32.555459+06 \N 2026-02-07 06:21:34.362428+06 2026-02-07 06:22:32.56446+06 PENDING \N \N
faabacc9-81bb-48b2-b4fd-b4bf171b5e48 b21b3707-fecd-4beb-af5b-470335a76577 52de165c-9c58-4209-a8c2-8e425821492e 85dc962d-6a4f-4059-9724-a9d352299829 BK-EA6411 PENDING_PAYMENT \N 2026-02-08 15:00:00+06 2026-02-08 16:00:00+06 Emon 01700000000 emon@test.com 2026-02-07 10:45:35.603587+06 \N 2026-02-07 10:44:09.727112+06 2026-02-07 10:45:35.609084+06 PENDING \N \N
\.
--
-- Data for Name: business_addresses; Type: TABLE DATA; Schema: core; Owner: -
--
COPY core.business_addresses (id, business_id, address_type, street, city, state, zip_code, country, created_at, updated_at) FROM stdin;
3618e2b3-8d71-4af6-a03d-278d33f67712 bfa73499-59af-41c4-a17a-8b739453f99a PRIMARY House 10, Road 5, Gulshan Dhaka Dhaka 1212 Bangladesh 2026-02-03 10:20:48.405617+06 2026-02-03 10:20:48.405617+06
8e7ca4b8-d7fb-4945-98a5-3691a4f692f5 b21b3707-fecd-4beb-af5b-470335a76577 PRIMARY Road 10, House 5 Dhaka Dhaka 1207 Bangladesh 2026-02-03 11:38:09.482385+06 2026-02-03 11:38:09.482385+06
b8739c44-d34a-4210-9298-22a9e3cf6a10 99eb1903-cbe3-46f7-9021-b34372f99f25 PRIMARY string string string string string 2026-02-03 11:44:28.417259+06 2026-02-03 11:44:28.417259+06
a2ef21be-9d28-4a81-91fa-e7ae8086072e d0f97639-5132-416c-81cf-b80aeb8a2405 PRIMARY Road 10, House 5 Dhaka Dhaka 1207 Bangladesh 2026-02-03 11:45:57.243444+06 2026-02-03 11:45:57.243444+06
56baa4d3-781c-4d96-9a3e-ab72f292313b 0a20c0dc-c352-40f8-bc18-8ccbd8ce0a60 PRIMARY Road 12, Block B Dhaka Dhaka Division 1212 Bangladesh 2026-02-05 10:25:51.941449+06 2026-02-05 10:25:51.941449+06
64a91636-5f7f-4c6e-adc4-5cbb9bc72b04 0b36696d-aa17-4190-81c9-6f731e030a9e PRIMARY House 12, Road 5, Gulshan-1 Dhaka Dhaka 1212 Bangladesh 2026-02-07 08:12:19.255201+06 2026-02-07 08:12:19.255201+06
\.
--
-- Data for Name: business_ai_settings; Type: TABLE DATA; Schema: core; Owner: -
--
COPY core.business_ai_settings (id, business_id, agent_name, tone_of_voice, personality, business_display_name, is_ai_enabled, fallback_to_human, created_at, updated_at, voice_id, confidence_threshold, allow_cancel_bookings, allow_reschedule_bookings, mention_promotions, welcome_message, fallback_message, escalation_message, max_retries, language, min_notice_hours, max_per_slot, cancellation_policy) FROM stdin;
4c0b0615-38c6-45fc-8cfd-db402fe380db 0520c248-a8be-47e6-ad58-efa2abd62ebf Assistant friendly and professional \N \N t t 2026-02-02 09:28:36.515047+06 2026-02-02 09:28:36.515047+06 \N 0.650 f f f Hello! How can I help you today? I'm sorry, I didn't understand that. I'll connect you with a human representative. 3 en 24 1 \N
2c9183e8-6e6f-404a-b7c7-3ad80af7b698 b21b3707-fecd-4beb-af5b-470335a76577 Assistant friendly and professional \N \N t t 2026-02-03 05:38:09.581107+06 2026-02-03 05:38:09.581107+06 \N 0.650 f f f Hello! How can I help you today? I'm sorry, I didn't understand that. I'll connect you with a human representative. 3 en 24 1 \N
12982f71-e582-482b-a7f6-2846964db355 99eb1903-cbe3-46f7-9021-b34372f99f25 Assistant friendly and professional \N \N t t 2026-02-03 05:44:28.426462+06 2026-02-03 05:44:28.426462+06 \N 0.650 f f f Hello! How can I help you today? I'm sorry, I didn't understand that. I'll connect you with a human representative. 3 en 24 1 \N
a26f5650-0f78-4f20-b791-7c7882c01d5c d0f97639-5132-416c-81cf-b80aeb8a2405 Assistant friendly and professional \N \N t t 2026-02-03 05:45:57.252499+06 2026-02-03 05:45:57.252499+06 \N 0.650 f f f Hello! How can I help you today? I'm sorry, I didn't understand that. I'll connect you with a human representative. 3 en 24 1 \N
61e592a2-5bca-4913-b3f3-871253f90230 bfa73499-59af-41c4-a17a-8b739453f99a Aida Friendly and professional You are a helpful hotel reservation assistant. Offer available services and time slots. Provide links to service pages when asked for pictures. If unsure, request human handoff. Demo Hotel t t 2026-01-26 11:13:14.851626+06 2026-02-03 08:32:59.021709+06 \N 0.650 f f f Hello! How can I assist you today? Sorry, I didn’t understand that. Could you please rephrase? Let me connect you with a human agent. 3 en 24 2 Cancellations must be made at least 24 hours in advance to avoid a service fee.
201b78e1-983f-4d75-80eb-9d347f165b85 0a20c0dc-c352-40f8-bc18-8ccbd8ce0a60 Assistant friendly and professional \N \N t t 2026-02-05 04:25:51.964515+06 2026-02-05 04:25:51.964515+06 \N 0.650 f f f Hello! How can I help you today? I'm sorry, I didn't understand that. I'll connect you with a human representative. 3 en 24 1 \N
e36d241c-88e4-4c7e-a2e8-3b656f133e3f 0b36696d-aa17-4190-81c9-6f731e030a9e Assistant friendly and professional \N \N t t 2026-02-07 02:12:19.327492+06 2026-02-07 02:12:19.327492+06 \N 0.650 f f f Hello! How can I help you today? I'm sorry, I didn't understand that. I'll connect you with a human representative. 3 en 24 1 \N
5d533870-9796-4352-804f-d23eaab8708f 4a048ca8-b311-499d-b088-ea92a9c2787f Assistant friendly and professional \N \N t t 2026-02-10 05:46:25.606537+06 2026-02-10 05:46:25.606537+06 \N 0.650 f f f Hello! How can I help you today? I'm sorry, I didn't understand that. I'll connect you with a human representative. 3 en 24 1 \N
\.
--
-- Data for Name: business_availability_exceptions; Type: TABLE DATA; Schema: core; Owner: -
--
COPY core.business_availability_exceptions (id, business_id, exception_type, start_at, end_at, note, created_at, updated_at) FROM stdin;
\.
--
-- Data for Name: business_notification_settings; Type: TABLE DATA; Schema: core; Owner: -
--
COPY core.business_notification_settings (id, business_id, email_alerts_enabled, sms_alerts_enabled, whatsapp_alerts_enabled, created_at, updated_at) FROM stdin;
ae2e7f6a-23e3-42f3-b14e-54432c30990f bfa73499-59af-41c4-a17a-8b739453f99a f f f 2026-01-26 11:13:18.729585+06 2026-01-26 11:13:18.729585+06
\.
--
-- Data for Name: business_operating_hours; Type: TABLE DATA; Schema: core; Owner: -
--
COPY core.business_operating_hours (id, business_id, day_of_week, open_time, close_time, is_closed, created_at, updated_at) FROM stdin;
4b306eab-bebf-45b0-a01c-cf6ab28855ac bfa73499-59af-41c4-a17a-8b739453f99a 0 09:00:00 22:00:00 f 2026-01-26 11:13:04.645561+06 2026-01-26 11:13:04.645561+06
e033f5da-16a4-47f7-9ebe-f8c36f9cf383 bfa73499-59af-41c4-a17a-8b739453f99a 1 09:00:00 22:00:00 f 2026-01-26 11:13:04.645561+06 2026-01-26 11:13:04.645561+06
aa0b408c-59b0-4f24-bdd4-11e19e2c6e11 bfa73499-59af-41c4-a17a-8b739453f99a 2 09:00:00 22:00:00 f 2026-01-26 11:13:04.645561+06 2026-01-26 11:13:04.645561+06
eb7d8685-8359-4b19-abd9-387558f96d47 bfa73499-59af-41c4-a17a-8b739453f99a 3 09:00:00 22:00:00 f 2026-01-26 11:13:04.645561+06 2026-01-26 11:13:04.645561+06
f382378b-3c47-42fd-8b7b-9db2deaaab62 bfa73499-59af-41c4-a17a-8b739453f99a 4 09:00:00 22:00:00 f 2026-01-26 11:13:04.645561+06 2026-01-26 11:13:04.645561+06
17c89d4e-2475-4e8a-af6a-0363b9590cdc bfa73499-59af-41c4-a17a-8b739453f99a 5 09:00:00 22:00:00 f 2026-01-26 11:13:04.645561+06 2026-01-26 11:13:04.645561+06
beae03f1-66fb-43da-a5c3-6e964cb5b704 bfa73499-59af-41c4-a17a-8b739453f99a 6 09:00:00 22:00:00 f 2026-01-26 11:13:04.645561+06 2026-01-26 11:13:04.645561+06
663d1c66-520a-491a-ad0a-e13a44867666 b21b3707-fecd-4beb-af5b-470335a76577 0 09:00:00 18:00:00 f 2026-02-03 05:38:09.577589+06 2026-02-03 05:38:09.577589+06
b7f3d587-50a3-4ec1-9c4e-355de34517ae b21b3707-fecd-4beb-af5b-470335a76577 1 09:00:00 18:00:00 f 2026-02-03 05:38:09.577589+06 2026-02-03 05:38:09.577589+06
40198fcc-f962-440b-8d45-fe899bff647c b21b3707-fecd-4beb-af5b-470335a76577 2 09:00:00 18:00:00 f 2026-02-03 05:38:09.577589+06 2026-02-03 05:38:09.577589+06
697d41c5-99b5-4c30-9882-d3058e77a285 b21b3707-fecd-4beb-af5b-470335a76577 3 09:00:00 18:00:00 f 2026-02-03 05:38:09.577589+06 2026-02-03 05:38:09.577589+06
9d0d4835-1f2b-42aa-9009-c1428712b527 b21b3707-fecd-4beb-af5b-470335a76577 4 09:00:00 18:00:00 f 2026-02-03 05:38:09.577589+06 2026-02-03 05:38:09.577589+06
43c592a6-da13-4c46-9280-74c9accb5837 b21b3707-fecd-4beb-af5b-470335a76577 5 09:00:00 18:00:00 f 2026-02-03 05:38:09.577589+06 2026-02-03 05:38:09.577589+06
222c0c75-56a2-4d20-8981-23218ff2f78b b21b3707-fecd-4beb-af5b-470335a76577 6 09:00:00 18:00:00 f 2026-02-03 05:38:09.577589+06 2026-02-03 05:38:09.577589+06
ad6f86dd-7a8d-4a84-9c81-84db240e900e 99eb1903-cbe3-46f7-9021-b34372f99f25 0 05:44:19.175 05:44:19.175 f 2026-02-03 05:44:28.424459+06 2026-02-03 05:44:28.424459+06
ac02e7ed-d62f-4814-95c4-2cb247136f2d 99eb1903-cbe3-46f7-9021-b34372f99f25 1 05:44:19.175 05:44:19.175 f 2026-02-03 05:44:28.424459+06 2026-02-03 05:44:28.424459+06
0183d91a-a22c-4c96-869c-41b45034d21d 99eb1903-cbe3-46f7-9021-b34372f99f25 2 05:44:19.175 05:44:19.175 f 2026-02-03 05:44:28.424459+06 2026-02-03 05:44:28.424459+06
1525d159-e337-44d8-9c8a-efd94f49dbe4 99eb1903-cbe3-46f7-9021-b34372f99f25 3 05:44:19.175 05:44:19.175 f 2026-02-03 05:44:28.424459+06 2026-02-03 05:44:28.424459+06
12bcad63-8e93-47d8-b666-5af1f0f7961d 99eb1903-cbe3-46f7-9021-b34372f99f25 4 05:44:19.175 05:44:19.175 f 2026-02-03 05:44:28.424459+06 2026-02-03 05:44:28.424459+06
87986548-4326-4bc0-816b-364266ccc5c3 99eb1903-cbe3-46f7-9021-b34372f99f25 5 05:44:19.175 05:44:19.175 f 2026-02-03 05:44:28.424459+06 2026-02-03 05:44:28.424459+06
30587200-5505-4ee5-84a6-78b6708a35a1 99eb1903-cbe3-46f7-9021-b34372f99f25 6 05:44:19.175 05:44:19.175 f 2026-02-03 05:44:28.424459+06 2026-02-03 05:44:28.424459+06
6d224244-5b6d-48c1-859e-16c183a0500f d0f97639-5132-416c-81cf-b80aeb8a2405 0 09:00:00 18:00:00 f 2026-02-03 05:45:57.251499+06 2026-02-03 05:45:57.251499+06
71b7d1eb-e253-4c89-853d-c555e0024a5f d0f97639-5132-416c-81cf-b80aeb8a2405 1 09:00:00 18:00:00 f 2026-02-03 05:45:57.251499+06 2026-02-03 05:45:57.251499+06
117211cb-f218-4010-9c9c-7f1e73d55227 d0f97639-5132-416c-81cf-b80aeb8a2405 2 09:00:00 18:00:00 f 2026-02-03 05:45:57.251499+06 2026-02-03 05:45:57.251499+06
cdda6e18-f574-4aeb-bd6a-ef94a84fc4ea d0f97639-5132-416c-81cf-b80aeb8a2405 3 09:00:00 18:00:00 f 2026-02-03 05:45:57.251499+06 2026-02-03 05:45:57.251499+06
e23a4baa-9a71-4a8d-8793-8de9fb6976f0 d0f97639-5132-416c-81cf-b80aeb8a2405 4 09:00:00 18:00:00 f 2026-02-03 05:45:57.251499+06 2026-02-03 05:45:57.251499+06
3a565e22-cbf4-49e4-b37b-2dc17e44c25f d0f97639-5132-416c-81cf-b80aeb8a2405 5 09:00:00 18:00:00 f 2026-02-03 05:45:57.251499+06 2026-02-03 05:45:57.251499+06
e5368416-ce03-494d-b146-bf0e42950068 d0f97639-5132-416c-81cf-b80aeb8a2405 6 09:00:00 18:00:00 f 2026-02-03 05:45:57.251499+06 2026-02-03 05:45:57.251499+06
9a8460f8-823f-401a-80f8-9ed30fbebd95 0a20c0dc-c352-40f8-bc18-8ccbd8ce0a60 0 09:00:00 18:00:00 f 2026-02-05 04:32:57.970156+06 2026-02-05 04:32:57.970156+06
5eaec199-eaa4-4f7e-a4dd-2be8b927f4c7 0a20c0dc-c352-40f8-bc18-8ccbd8ce0a60 1 09:00:00 18:00:00 f 2026-02-05 04:32:57.970156+06 2026-02-05 04:32:57.970156+06
791823bb-ae54-4c03-9924-58269ee0658a 0a20c0dc-c352-40f8-bc18-8ccbd8ce0a60 2 09:00:00 18:00:00 f 2026-02-05 04:32:57.970156+06 2026-02-05 04:32:57.970156+06
22508c3e-e06d-4264-856e-c19a43ca685e 0a20c0dc-c352-40f8-bc18-8ccbd8ce0a60 3 09:00:00 18:00:00 f 2026-02-05 04:32:57.970156+06 2026-02-05 04:32:57.970156+06
70ee609b-ca7a-4fb9-921f-9f15b82d49f6 0a20c0dc-c352-40f8-bc18-8ccbd8ce0a60 4 09:00:00 18:00:00 f 2026-02-05 04:32:57.970156+06 2026-02-05 04:32:57.970156+06
8d685171-2a57-4c64-a074-cf1587649531 0a20c0dc-c352-40f8-bc18-8ccbd8ce0a60 5 10:00:00 16:00:00 f 2026-02-05 04:32:57.970156+06 2026-02-05 04:32:57.970156+06
a372e8b7-dc4a-4959-b7a9-38f456313327 0a20c0dc-c352-40f8-bc18-8ccbd8ce0a60 6 00:00:00 00:00:00 f 2026-02-05 04:32:57.970156+06 2026-02-05 04:32:57.970156+06
9bd2d6c5-4925-4904-8eeb-d41b0405bba2 0b36696d-aa17-4190-81c9-6f731e030a9e 1 08:00:00 22:00:00 f 2026-02-07 02:12:19.354003+06 2026-02-07 02:12:19.354003+06
94a4af0e-f4aa-4104-8583-25d76c953a1b 0b36696d-aa17-4190-81c9-6f731e030a9e 2 08:00:00 22:00:00 f 2026-02-07 02:12:19.354003+06 2026-02-07 02:12:19.354003+06
61083b23-e92d-41f6-8432-3315f87a3763 0b36696d-aa17-4190-81c9-6f731e030a9e 3 08:00:00 22:00:00 f 2026-02-07 02:12:19.354003+06 2026-02-07 02:12:19.354003+06
3033ef40-beeb-4257-878f-2feef16ea490 0b36696d-aa17-4190-81c9-6f731e030a9e 4 08:00:00 22:00:00 f 2026-02-07 02:12:19.354003+06 2026-02-07 02:12:19.354003+06
d530ca50-4f41-4f59-bd36-0bbe591575eb 0b36696d-aa17-4190-81c9-6f731e030a9e 5 08:00:00 23:00:00 f 2026-02-07 02:12:19.354003+06 2026-02-07 02:12:19.354003+06
aa6d3368-a3f4-4846-ba79-b8614fa99629 0b36696d-aa17-4190-81c9-6f731e030a9e 6 09:00:00 23:00:00 f 2026-02-07 02:12:19.354003+06 2026-02-07 02:12:19.354003+06
a7783429-6ece-4067-be82-8f94ab701d83 0b36696d-aa17-4190-81c9-6f731e030a9e 0 09:00:00 21:00:00 f 2026-02-07 02:12:19.354003+06 2026-02-07 02:12:19.354003+06
b729e28c-68a2-4b84-ab05-bea0a565e7e3 4a048ca8-b311-499d-b088-ea92a9c2787f 0 09:00:00 18:00:00 f 2026-02-10 05:46:25.623345+06 2026-02-10 06:05:14.901779+06
ecd46716-e0a5-43ae-bad1-8e13fecab331 4a048ca8-b311-499d-b088-ea92a9c2787f 1 09:00:00 18:00:00 f 2026-02-10 05:46:25.623345+06 2026-02-10 06:05:14.90478+06
4a6590e6-4fb2-43f1-80f2-5995f40898d1 4a048ca8-b311-499d-b088-ea92a9c2787f 2 09:00:00 18:00:00 f 2026-02-10 05:46:25.623345+06 2026-02-10 06:05:14.905778+06
7eaef9cd-1663-4c61-861f-a5af5cfa9f99 4a048ca8-b311-499d-b088-ea92a9c2787f 3 09:00:00 18:00:00 f 2026-02-10 05:46:25.623345+06 2026-02-10 06:05:14.90678+06
fc1b9922-dd13-4eb8-89ca-5fb810f80810 4a048ca8-b311-499d-b088-ea92a9c2787f 4 09:00:00 18:00:00 f 2026-02-10 05:46:25.623345+06 2026-02-10 06:05:14.908779+06
8f17a1ec-ffcd-4692-beab-307629d37318 4a048ca8-b311-499d-b088-ea92a9c2787f 5 10:00:00 16:00:00 f 2026-02-10 05:46:25.623345+06 2026-02-10 06:05:14.910778+06
2a3629a7-2d67-42f7-a0a6-42ffb1a703af 4a048ca8-b311-499d-b088-ea92a9c2787f 6 \N \N t 2026-02-10 05:46:25.623345+06 2026-02-10 06:05:14.912778+06
\.
--
-- Data for Name: business_profiles; Type: TABLE DATA; Schema: core; Owner: -
--
COPY core.business_profiles (business_id, contact_person, email, phone, created_at, updated_at) FROM stdin;
bfa73499-59af-41c4-a17a-8b739453f99a Demo Manager manager@demohotel.com +8801711111111 2026-02-03 10:20:48.382818+06 2026-02-03 10:20:48.382818+06
b21b3707-fecd-4beb-af5b-470335a76577 Emon emon@example.com 01700000000 2026-02-03 11:38:09.482385+06 2026-02-03 11:38:09.482385+06
99eb1903-cbe3-46f7-9021-b34372f99f25 string user@example.com string 2026-02-03 11:44:28.417259+06 2026-02-03 11:44:28.417259+06
d0f97639-5132-416c-81cf-b80aeb8a2405 Emon emon@example.com 01700000000 2026-02-03 11:45:57.243444+06 2026-02-03 11:45:57.243444+06
0a20c0dc-c352-40f8-bc18-8ccbd8ce0a60 Emon Karmoker contact@sunrisehotel.com +8801700000000 2026-02-05 10:25:51.941449+06 2026-02-05 10:25:51.941449+06
0b36696d-aa17-4190-81c9-6f731e030a9e Fahim Rahman fahim.rahman@example.com +8801712345678 2026-02-07 08:12:19.255201+06 2026-02-07 08:12:19.255201+06
\.
--
-- Data for Name: businesses; Type: TABLE DATA; Schema: core; Owner: -
--
COPY core.businesses (id, slug, business_name, industry, timezone, status, created_by_admin_id, created_at, updated_at, description, phone, email, website, address, city, country, default_currency, is_active, industry_label, contact_person, street_address, state, zip_code) FROM stdin;
0520c248-a8be-47e6-ad58-efa2abd62ebf sunset-spa SPA SPA Asia/Dhaka ACTIVE d4e73189-4763-4ada-9ac7-42d195b01a04 2026-02-02 09:28:36.497857+06 2026-02-02 09:28:36.498864+06 \N \N \N \N \N \N \N BDT t SPA \N \N \N \N
bfa73499-59af-41c4-a17a-8b739453f99a hotel-demo Sunset Spa & Wellness HOTEL Asia/Dhaka ACTIVE d4e73189-4763-4ada-9ac7-42d195b01a04 2026-01-26 11:12:55.701654+06 2026-02-02 09:29:55.840836+06 A luxury hotel in the heart of Dhaka +8801700000000 info@demohotel.com \N \N Dhaka Bangladesh BDT t \N \N \N \N \N
b21b3707-fecd-4beb-af5b-470335a76577 demo-hotel Demo Hotel HOTEL Asia/Dhaka ACTIVE d4e73189-4763-4ada-9ac7-42d195b01a04 2026-02-03 05:38:09.556583+06 2026-02-03 05:38:09.556583+06 \N \N \N \N \N \N \N BDT t HOTEL \N \N \N \N
99eb1903-cbe3-46f7-9021-b34372f99f25 string string HOTEL Asia/Dhaka ACTIVE d4e73189-4763-4ada-9ac7-42d195b01a04 2026-02-03 05:44:28.418457+06 2026-02-03 05:44:28.418457+06 \N \N \N \N \N \N \N BDT t HOTEL \N \N \N \N
d0f97639-5132-416c-81cf-b80aeb8a2405 demo-hote Demo Hote HOTEL Asia/Dhaka ACTIVE d4e73189-4763-4ada-9ac7-42d195b01a04 2026-02-03 05:45:57.244329+06 2026-02-03 05:45:57.244329+06 \N \N \N \N \N \N \N BDT t HOTEL \N \N \N \N
0a20c0dc-c352-40f8-bc18-8ccbd8ce0a60 sunrise-grand-hotel Sunrise Grand Hotel HOTEL Asia/Dhaka ACTIVE d4e73189-4763-4ada-9ac7-42d195b01a04 2026-02-05 04:25:51.960515+06 2026-02-05 04:25:51.960515+06 \N \N \N \N \N \N \N BDT t HOTEL \N \N \N \N
0b36696d-aa17-4190-81c9-6f731e030a9e royal-orchid-hotel Royal Orchid Hotel HOTEL Asia/Dhaka ACTIVE d4e73189-4763-4ada-9ac7-42d195b01a04 2026-02-07 02:12:19.322469+06 2026-02-07 02:12:19.322469+06 \N \N \N \N \N \N \N BDT t HOTEL \N \N \N \N
4a048ca8-b311-499d-b088-ea92a9c2787f demo-hotel-20260210-1 Demo Hotel HOTEL Asia/Dhaka ACTIVE d4e73189-4763-4ada-9ac7-42d195b01a04 2026-02-10 05:46:25.601542+06 2026-02-10 05:46:25.601542+06 \N \N \N \N \N \N \N BDT t HOTEL \N \N \N \N
\.
--
-- Data for Name: call_sessions; Type: TABLE DATA; Schema: core; Owner: -
--
COPY core.call_sessions (id, business_id, public_call_id, provider_call_id, caller_phone, caller_country, channel, status, started_at, answered_at, ended_at, duration_seconds, total_ai_messages, total_user_messages, resolution_type, outcome, conversation_id, booking_id, handoff_id, full_transcript, transcript_search, extra_data, created_at, updated_at) FROM stdin;
3cc53f47-92b0-4b98-bcf8-096c76087ac4 bfa73499-59af-41c4-a17a-8b739453f99a CALL-676255 vapi-test-001 +8801712345678 \N VOICE IN_PROGRESS 2026-01-29 10:53:37.399518+06 2026-01-29 10:53:37.399518+06 \N \N 0 0 \N \N 3e929134-a26b-4a74-ae34-186657a49084 \N \N \N {} 2026-01-29 10:53:37.400518+06 2026-01-29 16:53:37.36559+06
a6503d95-d1ab-4d34-b964-47ddd0add448 bfa73499-59af-41c4-a17a-8b739453f99a CALL-6B4B54 \N +8801755555555 \N VOICE IN_PROGRESS 2026-01-29 11:07:09.001105+06 2026-01-29 11:07:09.001105+06 \N \N 0 0 \N \N ee4e02d7-1205-4caf-809f-c54549032580 \N \N \N {} 2026-01-29 11:07:09.003107+06 2026-01-29 17:07:08.982643+06
c91aba84-c720-4697-b649-4f3bbf3b697c bfa73499-59af-41c4-a17a-8b739453f99a CALL-517654 \N +8801777777777 \N VOICE IN_PROGRESS 2026-01-29 11:15:36.446721+06 2026-01-29 11:15:36.446721+06 \N \N 0 0 \N \N aa2d9178-c8af-459f-9679-438086f3c0ad \N \N \N {} 2026-01-29 11:15:36.448721+06 2026-01-29 17:15:36.42261+06
305fef45-2b17-4518-8ccb-546ff043da95 bfa73499-59af-41c4-a17a-8b739453f99a CALL-BC345D \N +8801700000000 \N VOICE COMPLETED 2026-01-29 11:23:52.974875+06 2026-01-29 11:23:52.974875+06 2026-01-29 11:26:33.485503+06 21760 0 0 AI_RESOLVED BOOKING_CREATED 9c3539cb-36c7-4905-ba04-47ff86dadc6e \N \N \N {} 2026-01-29 11:23:52.974875+06 2026-01-29 11:26:33.48651+06
f22c40ee-3879-4cfa-81b1-f13b76021b46 bfa73499-59af-41c4-a17a-8b739453f99a CALL-16E5F4 vapi-test-001 +8801712345678 \N VOICE IN_PROGRESS 2026-02-02 02:24:52.098562+06 2026-02-02 02:24:52.098562+06 \N \N 0 0 \N \N eaceb0a7-b928-454a-bed0-080d6d5056b0 \N \N \N {} 2026-02-02 02:24:52.09956+06 2026-02-02 08:24:52.070031+06
3f987179-dc5f-45b0-977b-10d5aafa80b7 bfa73499-59af-41c4-a17a-8b739453f99a CALL-DD41BC \N +8801799999999 \N VOICE ESCALATED 2026-01-29 11:00:16.607637+06 2026-01-29 11:00:16.607637+06 2026-02-02 02:27:34.808612+06 336438 0 0 HUMAN_ESCALATED ESCALATED_TO_HUMAN e5f4e02f-5998-4646-bce7-d42e81c79073 \N \N \N {} 2026-01-29 11:00:16.607637+06 2026-02-02 02:27:34.81061+06
6b1ed37a-eafb-4c53-b121-3d37db86f3e3 b21b3707-fecd-4beb-af5b-470335a76577 CALL-A0CCF1 twilio_call_9f3a2c7b1d +8801700000000 \N VOICE IN_PROGRESS 2026-02-05 03:38:17.177939+06 2026-02-05 03:38:17.177939+06 \N \N 0 0 \N \N 7141cc37-6b22-4b6c-b06b-4940ef84b5e3 \N \N \N {} 2026-02-05 03:38:17.178949+06 2026-02-05 09:38:17.124972+06
6f84502b-7f66-4d7f-aa18-4d70d166cf91 0a20c0dc-c352-40f8-bc18-8ccbd8ce0a60 CALL-C80976 twilio-call-001 +8801712345678 \N VOICE IN_PROGRESS 2026-02-05 04:33:51.155039+06 2026-02-05 04:33:51.155039+06 \N \N 0 0 \N \N b81e25f2-d867-435d-a972-1c913de7e736 \N \N \N {} 2026-02-05 04:33:51.156041+06 2026-02-05 10:33:51.146973+06
b97994c2-67cf-4dab-bfb2-c4c304461c00 0a20c0dc-c352-40f8-bc18-8ccbd8ce0a60 CALL-7F0A99 test-call-001 01700000000 \N VOICE IN_PROGRESS 2026-02-07 05:24:50.261026+06 2026-02-07 05:24:50.261026+06 \N \N 0 0 \N \N 1671fe69-5737-4352-b89e-c6dc1543e457 \N \N \N {} 2026-02-07 05:24:50.263023+06 2026-02-07 11:24:50.249801+06
c88085ae-a17d-4e12-9614-b59c4a5b10a8 0a20c0dc-c352-40f8-bc18-8ccbd8ce0a60 CALL-AA5E09 NULL string \N VOICE COMPLETED 2026-02-07 06:21:01.945702+06 2026-02-07 06:21:01.945702+06 2026-02-07 06:23:43.548874+06 21761 0 0 AI_RESOLVED BOOKING_CREATED 5ece81f5-2e8a-4bcc-97b6-d733862639e8 \N \N \N {} 2026-02-07 06:21:01.947706+06 2026-02-07 06:23:43.549872+06
7a71a170-3947-4e43-957e-583b9f2cf59a 4a048ca8-b311-499d-b088-ea92a9c2787f CALL-2F04D5 call_test_001 +8801712345678 \N VOICE COMPLETED 2026-02-10 06:38:16.648249+06 2026-02-10 06:38:16.648249+06 2026-02-10 06:45:12.634327+06 22015 0 0 AI_RESOLVED INFO_PROVIDED 60db455a-c3fe-4477-a74d-d685d767ee12 \N \N \N {"pressed_00": true, "call_ended_at": "2026-02-10T06:45:12.634327", "handoff_to_chat": true} 2026-02-10 06:38:16.650248+06 2026-02-10 06:45:12.636328+06
\.
--
-- Data for Name: conversation_messages; Type: TABLE DATA; Schema: core; Owner: -
--
COPY core.conversation_messages (id, business_id, conversation_id, role, content, metadata, created_at) FROM stdin;
6c130024-bb23-47f4-82b7-10ff280c9951 bfa73499-59af-41c4-a17a-8b739453f99a a4b2f505-8d7e-457f-bb15-01198af00bab user Hello \N 2026-01-27 08:24:25.274062+06
bd92211a-643a-42e4-8996-d2cec1b4944b bfa73499-59af-41c4-a17a-8b739453f99a a4b2f505-8d7e-457f-bb15-01198af00bab assistant Hello! It's great to hear from you. How can I assist you today? I can help you book services, check availability, or answer any questions you might have. \N 2026-01-27 08:24:32.016638+06
a4fd62a6-feae-4de5-8ed3-b6888313e44e bfa73499-59af-41c4-a17a-8b739453f99a a4b2f505-8d7e-457f-bb15-01198af00bab user What rooms do you have available? \N 2026-01-27 08:25:04.657335+06
244d6dbe-b9a0-4dc4-87b8-0a98cae87481 bfa73499-59af-41c4-a17a-8b739453f99a a4b2f505-8d7e-457f-bb15-01198af00bab assistant We have some wonderful room options available for you:\n\n1. **Deluxe Room**: Comfortable deluxe room with breakfast - **6000.0 BDT**\n2. **Premium Suite**: Spacious suite with premium amenities - **12000.0 BDT**\n3. **Family Room**: Large room perfect for families - **9000.0 BDT**\n\nWhich one would you like to book? \N 2026-01-27 08:25:11.099687+06
a0968c3e-6147-421b-8daa-8329555a8e85 bfa73499-59af-41c4-a17a-8b739453f99a a4b2f505-8d7e-457f-bb15-01198af00bab user I want to book the Deluxe Room \N 2026-01-27 08:25:44.27484+06
ee59f304-acaa-436f-a214-d98da71597be bfa73499-59af-41c4-a17a-8b739453f99a a4b2f505-8d7e-457f-bb15-01198af00bab assistant Great choice! You've selected the Deluxe Room. When would you like to book it? Please let me know your preferred date and time. \N 2026-01-27 08:25:49.711818+06
b84ad521-f5db-475a-99f2-5fb355eda6ba bfa73499-59af-41c4-a17a-8b739453f99a a4b2f505-8d7e-457f-bb15-01198af00bab user Tomorrow at 2pm \N 2026-01-27 08:26:18.354938+06
9344d963-9dbe-4450-9786-210f7f197bdf bfa73499-59af-41c4-a17a-8b739453f99a a4b2f505-8d7e-457f-bb15-01198af00bab assistant Thank you for your preference! Just to confirm, you would like to book the Deluxe Room for tomorrow at 2 PM. \n\nCould you please provide me with your name and any other details needed for the booking? \N 2026-01-27 08:26:21.80307+06
798771da-7028-4b26-9af5-e82539c436fa bfa73499-59af-41c4-a17a-8b739453f99a a4b2f505-8d7e-457f-bb15-01198af00bab user My name is Emon, phone 01712345678, email emon@test.com \N 2026-01-27 08:26:45.131612+06
f84180d6-b432-4630-94cc-f756baeaa92e bfa73499-59af-41c4-a17a-8b739453f99a a4b2f505-8d7e-457f-bb15-01198af00bab assistant Thank you, Emon! Here are the details of your booking:\n\n- **Service**: Deluxe Room\n- **Date and Time**: Tomorrow at 2 PM\n- **Name**: Emon\n- **Phone**: 01712345678\n- **Email**: emon@test.com\n\nPlease confirm that all the details are correct. Once you confirm, I will send you a payment link. \N 2026-01-27 08:26:51.222037+06
30ae69c8-4adf-4680-9545-77ed397fd30b bfa73499-59af-41c4-a17a-8b739453f99a a4b2f505-8d7e-457f-bb15-01198af00bab user Yes, confirmed \N 2026-01-27 08:27:08.113509+06
ad49149f-d977-426f-ba7e-7ad483736656 bfa73499-59af-41c4-a17a-8b739453f99a a4b2f505-8d7e-457f-bb15-01198af00bab assistant I don't have all the information needed to complete your booking. Let me help you provide the missing details. \N 2026-01-27 08:27:10.058082+06
59c5edb1-0aaf-43f3-b8c4-8ffade227bbc bfa73499-59af-41c4-a17a-8b739453f99a dd36a591-9a78-4b6b-8c8c-2632a57d79ae user I want to book the Deluxe Room \N 2026-01-28 02:42:06.838777+06
dc87167f-00b2-47aa-bdaa-35bd1269c5cd bfa73499-59af-41c4-a17a-8b739453f99a dd36a591-9a78-4b6b-8c8c-2632a57d79ae assistant Great choice with the Deluxe Room! When would you like to book your stay? Please provide your preferred date and time. \N 2026-01-28 02:42:12.998042+06
38cf516d-ff14-4759-a2dd-028ebcbee7b6 bfa73499-59af-41c4-a17a-8b739453f99a dd36a591-9a78-4b6b-8c8c-2632a57d79ae user Tomorrow at 3pm \N 2026-01-28 02:43:12.955768+06
c6613344-90c7-4d97-bf2e-3f66c501f74c bfa73499-59af-41c4-a17a-8b739453f99a dd36a591-9a78-4b6b-8c8c-2632a57d79ae assistant Just to confirm, you would like to book the Deluxe Room for tomorrow, October 6th, at 3:00 PM. \n\nCould you please provide your contact information?\n- Full name\n- Phone number\n- Email address \n\nThank you! \N 2026-01-28 02:43:19.429085+06
60748701-ff27-46b8-a9f5-f4a27fff3060 bfa73499-59af-41c4-a17a-8b739453f99a dd36a591-9a78-4b6b-8c8c-2632a57d79ae user My name is Emon Karmoker, phone 01712345678, email emon@example.com \N 2026-01-28 02:44:32.061979+06
3c76210d-e8b8-4b71-8e9d-005cfe4dc646 bfa73499-59af-41c4-a17a-8b739453f99a dd36a591-9a78-4b6b-8c8c-2632a57d79ae assistant Thank you, Emon Karmoker! Here are your booking details:\n\n- **Service:** Deluxe Room\n- **Date and Time:** October 6, 2023, at 3:00 PM\n- **Name:** Emon Karmoker\n- **Phone:** 01712345678\n- **Email:** emon@example.com\n\nPlease confirm if these details are correct. Once confirmed, I will send you a payment link. \N 2026-01-28 02:44:39.82743+06
74bde21b-4aae-406e-8d4e-13cb0df50877 bfa73499-59af-41c4-a17a-8b739453f99a dd36a591-9a78-4b6b-8c8c-2632a57d79ae user Yes, confirmed \N 2026-01-28 02:45:26.941069+06
c0c57557-36fc-43e6-974f-6e97f2b37ad7 bfa73499-59af-41c4-a17a-8b739453f99a dd36a591-9a78-4b6b-8c8c-2632a57d79ae assistant Thank you for confirming, Emon! Your booking has been created successfully!\n\n- **Service:** Deluxe Room\n- **Tracking ID:** BK-5CB49A\n\nYou will receive a payment link shortly to complete your reservation. You can use the tracking ID (BK-5CB49A) to check your booking status at any time.\n\nThank you for choosing us, and we look forward to welcoming you! If you have any other questions or need further assistance, feel free to ask. \N 2026-01-28 02:45:34.290321+06
808f7bd9-1bcc-4ae3-9e71-84314094110a bfa73499-59af-41c4-a17a-8b739453f99a e1e346bb-1539-431d-8aef-7874ca5f55a7 user I want to book the Deluxe Room \N 2026-01-28 03:19:47.875576+06
241cb308-9b41-4984-939d-84996466512c bfa73499-59af-41c4-a17a-8b739453f99a e1e346bb-1539-431d-8aef-7874ca5f55a7 assistant Great choice! You've selected the Deluxe Room. When would you like to book it? Please provide your preferred date and time. \N 2026-01-28 03:19:53.191831+06
e2ac9d54-8722-41ac-b9a1-cd8a493b4552 bfa73499-59af-41c4-a17a-8b739453f99a 76a0b0f2-7569-4a7f-9dcc-1399e1a85cd0 user I want the Deluxe Room \N 2026-01-28 03:27:50.769091+06
ecb785d6-a354-45d2-855c-19442247697a bfa73499-59af-41c4-a17a-8b739453f99a 76a0b0f2-7569-4a7f-9dcc-1399e1a85cd0 assistant Great choice! You've selected the Deluxe Room. When would you like to book it? Please provide your preferred date and time. \N 2026-01-28 03:27:57.001729+06
28632581-284d-417a-9b6d-a76f0c93eb32 bfa73499-59af-41c4-a17a-8b739453f99a 76a0b0f2-7569-4a7f-9dcc-1399e1a85cd0 user October 6, 2023 at 3pm \N 2026-01-28 03:28:03.985078+06
5b1ab1ac-4d7d-4879-a8c5-0cd51849b56f bfa73499-59af-41c4-a17a-8b739453f99a 76a0b0f2-7569-4a7f-9dcc-1399e1a85cd0 assistant I'm sorry, that time slot is no longer available. Here are some alternative times:\n- 2023-10-06T14:00:00\n- 2023-10-06T16:00:00\n- 2023-10-06T13:00:00\n- 2023-10-06T17:00:00\n- 2023-10-06T12:00:00\n\nWhich one would you prefer? \N 2026-01-28 03:28:07.817449+06
5c2d3828-fd39-4c72-9e20-96b6fe032c1e bfa73499-59af-41c4-a17a-8b739453f99a 76a0b0f2-7569-4a7f-9dcc-1399e1a85cd0 user I'll take 4pm \N 2026-01-28 03:39:36.782161+06
cd61756f-3456-422c-b7d4-396e2ace3c0b bfa73499-59af-41c4-a17a-8b739453f99a 76a0b0f2-7569-4a7f-9dcc-1399e1a85cd0 assistant Perfect! I have you booked for the Deluxe Room on October 6, 2023, at 4 PM. \n\nCould you please provide your contact information? \n- Full name\n- Phone number\n- Email address \n\nThank you! \N 2026-01-28 03:39:42.850173+06
d217b75e-b1e7-482d-a2b2-9a425b48beeb bfa73499-59af-41c4-a17a-8b739453f99a 76a0b0f2-7569-4a7f-9dcc-1399e1a85cd0 user October 6, 2023 at 4pm \N 2026-01-28 03:40:31.133227+06
06200762-11b7-444b-8237-43707e96af1a bfa73499-59af-41c4-a17a-8b739453f99a 76a0b0f2-7569-4a7f-9dcc-1399e1a85cd0 assistant Thank you for confirming the time! \n\nCould you please provide your contact information? \n- Full name\n- Phone number\n- Email address \n\nLooking forward to your details! \N 2026-01-28 03:40:35.2254+06
34e2796a-ddcd-4487-95ca-3a9f57635ff6 bfa73499-59af-41c4-a17a-8b739453f99a 387ced7b-1827-4717-ba19-e4e5b8b1b2ac user My name is Emon, phone 01712345678, email emon@test.com. I want to speak with a real person please. \N 2026-01-28 08:05:19.318244+06
b08f2b20-a570-41f8-b943-17771ec942b8 bfa73499-59af-41c4-a17a-8b739453f99a 387ced7b-1827-4717-ba19-e4e5b8b1b2ac assistant I've created a support ticket for you. Your ticket ID is **HO-5BA7C8**. A team member will contact you shortly at the phone number or email you provided. Thank you for your patience! \N 2026-01-28 08:05:27.409627+06
f7c6db41-5f3e-4cd7-bd0f-e71f1076658a bfa73499-59af-41c4-a17a-8b739453f99a 86d0e2c6-8cdd-4cce-80aa-d68ae54f2bbc user I want to book the Deluxe Room \N 2026-01-28 08:28:14.070839+06
cd2b2848-ea6c-43a0-9c4b-1fa2e8ef107d bfa73499-59af-41c4-a17a-8b739453f99a 86d0e2c6-8cdd-4cce-80aa-d68ae54f2bbc assistant Thank you for selecting the Deluxe Room! When would you like to book it? Please provide your preferred date and time. \N 2026-01-28 08:28:21.654657+06
a50609d4-39ae-4348-b736-f0295b7a70c7 bfa73499-59af-41c4-a17a-8b739453f99a 86d0e2c6-8cdd-4cce-80aa-d68ae54f2bbc user Tomorrow at 2pm \N 2026-01-28 08:28:31.783343+06
1b18c49f-bc18-4fb1-9c2d-04e81f93ce1d bfa73499-59af-41c4-a17a-8b739453f99a 86d0e2c6-8cdd-4cce-80aa-d68ae54f2bbc assistant Just to confirm, you would like to book the Deluxe Room for tomorrow, January 29th, at 2:00 PM. \n\nCould you please provide me with your contact information?\n- Full name\n- Phone number\n- Email address\n\nThank you! \N 2026-01-28 08:28:36.732979+06
48c97532-3cf7-486d-aa56-5929436c5608 bfa73499-59af-41c4-a17a-8b739453f99a 7fa7a750-b3c3-4e0e-b90a-2df7508db830 user What's the status of my booking BK-31336F? \N 2026-01-28 08:35:42.277148+06
1e7a707d-ca13-4f3d-8466-cccd59ee1b57 bfa73499-59af-41c4-a17a-8b739453f99a 7fa7a750-b3c3-4e0e-b90a-2df7508db830 assistant Thank you for your patience! I'm looking up the status of your booking BK-31336F and will provide the details shortly. \N 2026-01-28 08:35:46.678338+06
272604dd-0806-436d-8e56-1fd35d7e6699 bfa73499-59af-41c4-a17a-8b739453f99a 7fa7a750-b3c3-4e0e-b90a-2df7508db830 user I want to cancel my booking BK-31336F \N 2026-01-28 08:36:12.007352+06
84426044-61c9-47ab-951c-ab5b36185aa7 bfa73499-59af-41c4-a17a-8b739453f99a 7fa7a750-b3c3-4e0e-b90a-2df7508db830 assistant I understand you want to cancel your booking BK-31336F. Can you please confirm that you would like to proceed with the cancellation? Please note that this action cannot be undone. \N 2026-01-28 08:36:16.991695+06
6d89d239-2a1b-4b13-98dc-015abf8eb574 bfa73499-59af-41c4-a17a-8b739453f99a 7fa7a750-b3c3-4e0e-b90a-2df7508db830 user Actually, I want to reschedule my booking BK-31336F to next week \N 2026-01-28 08:36:43.453813+06
3cb5b12a-eb1e-42d6-b52e-3e88ad2587b3 bfa73499-59af-41c4-a17a-8b739453f99a 7fa7a750-b3c3-4e0e-b90a-2df7508db830 assistant Great! Please let me know your preferred new date and time for rescheduling your booking BK-31336F. \N 2026-01-28 08:36:47.030524+06
283be889-4826-4634-a15a-e6a332444b26 bfa73499-59af-41c4-a17a-8b739453f99a 661021ed-dd71-4655-b36d-70c83f79baed user What's the status of booking BK-31336F? \N 2026-01-28 08:44:33.436745+06
de7d2b70-7f44-47d2-9e51-36c3a8f477fa bfa73499-59af-41c4-a17a-8b739453f99a 661021ed-dd71-4655-b36d-70c83f79baed assistant Here are the details for booking **BK-31336F**:\n\n- **Service:** Deluxe Room\n- **Status:** SLOT_SELECTED\n- **Date/Time:** 2026-01-29T08:00:00+00:00\n- **Customer:** Not provided\n- **Payment:** CREATED\n\nIs there anything else I can help you with? \N 2026-01-28 08:44:38.736634+06
8ba4db6c-8521-42a8-8036-55a5c24f6c94 bfa73499-59af-41c4-a17a-8b739453f99a 661021ed-dd71-4655-b36d-70c83f79baed user I want to cancel booking BK-31336F \N 2026-01-28 08:45:03.708084+06
235486bb-9569-4b8c-85a0-6f87edb43852 bfa73499-59af-41c4-a17a-8b739453f99a 661021ed-dd71-4655-b36d-70c83f79baed assistant I understand you'd like to cancel booking **BK-31336F**. Can you please confirm that you want to proceed with the cancellation? Please note that this action cannot be undone. \N 2026-01-28 08:45:09.56533+06
f9f00de0-3b22-4914-9029-61b53cd5c4ee bfa73499-59af-41c4-a17a-8b739453f99a 661021ed-dd71-4655-b36d-70c83f79baed user Yes, please cancel it \N 2026-01-28 08:45:26.813754+06
7f238c77-867f-4463-abe3-e5c78bb61fd3 bfa73499-59af-41c4-a17a-8b739453f99a 661021ed-dd71-4655-b36d-70c83f79baed assistant I can't process cancellations directly, but I can connect you with a human representative who can assist you with that. Would you like me to do that? \N 2026-01-28 08:45:32.056844+06
bb950f5e-e580-4113-94a9-a2108c75b852 bfa73499-59af-41c4-a17a-8b739453f99a fc27ac1b-9450-4006-b35b-a8a0700c647a user I want to cancel my booking BK-31336F \N 2026-01-28 08:55:23.789266+06
e4596aef-dbb7-42b9-acec-f399c3535918 bfa73499-59af-41c4-a17a-8b739453f99a fc27ac1b-9450-4006-b35b-a8a0700c647a assistant I understand you want to cancel your booking BK-31336F. Can you please confirm that you would like to proceed with the cancellation? Please note that this action cannot be undone. \N 2026-01-28 08:55:28.921348+06
b801696a-c66c-4574-bee8-e53d5b86b973 bfa73499-59af-41c4-a17a-8b739453f99a fc27ac1b-9450-4006-b35b-a8a0700c647a user Yes, please cancel it \N 2026-01-28 08:55:33.342407+06
107447e2-31b1-4820-936f-4376ac4f886e bfa73499-59af-41c4-a17a-8b739453f99a fc27ac1b-9450-4006-b35b-a8a0700c647a assistant I don't have a booking ID to cancel. Could you please provide your booking tracking ID (like BK-XXXXXX)? \N 2026-01-28 08:55:36.444226+06
66b591eb-3226-423a-842e-1498ba64315b bfa73499-59af-41c4-a17a-8b739453f99a fc27ac1b-9450-4006-b35b-a8a0700c647a user Yes, cancel booking BK-31336F \N 2026-01-28 08:55:58.952939+06
05fd69c3-e4db-4c03-8ae5-1ba9ed4ad290 bfa73499-59af-41c4-a17a-8b739453f99a fc27ac1b-9450-4006-b35b-a8a0700c647a assistant Your booking **BK-31336F** has been successfully cancelled. If you'd like to make a new booking, just let me know! \N 2026-01-28 08:56:02.399228+06
46cfa4ef-98da-4c2a-ac56-a7c9b0e9f006 bfa73499-59af-41c4-a17a-8b739453f99a 11a6fdcc-c203-45b7-b889-44615400abc1 user Book the Premium Suite for tomorrow at 10am. My name is Test User, phone 01700000000, email test@test.com \N 2026-01-28 08:57:06.791965+06
9f607fc2-221c-40e6-b1e5-bbfb27bf134e bfa73499-59af-41c4-a17a-8b739453f99a 11a6fdcc-c203-45b7-b889-44615400abc1 assistant Congratulations, Test User! Your booking for the Premium Suite has been created successfully! 🎉\n\nYou will receive a payment link shortly to complete the process. In the meantime, you can use the tracking ID: PENDING to check your booking status at any time.\n\nThank you for choosing us! If you have any questions or need further assistance, feel free to reach out. We look forward to welcoming you! \N 2026-01-28 08:57:12.176164+06
e625886b-6c72-41b5-8207-4d197a02323e bfa73499-59af-41c4-a17a-8b739453f99a 11a6fdcc-c203-45b7-b889-44615400abc1 user I want to book the Premium Suite \N 2026-01-28 08:58:26.129509+06
e3f30e07-e151-4f72-9bfd-c562f6e8ecf7 bfa73499-59af-41c4-a17a-8b739453f99a 11a6fdcc-c203-45b7-b889-44615400abc1 assistant Great choice! You've selected the Premium Suite. When would you like to book it? Please provide your preferred date and time. \N 2026-01-28 08:58:30.235056+06
2b783e5f-2577-4c0a-a3d1-aceb5c8446de bfa73499-59af-41c4-a17a-8b739453f99a 11a6fdcc-c203-45b7-b889-44615400abc1 user Tomorrow at 11am \N 2026-01-28 08:58:50.420267+06
5a4fdc2b-b7cf-4239-a7b3-837630e09483 bfa73499-59af-41c4-a17a-8b739453f99a 11a6fdcc-c203-45b7-b889-44615400abc1 assistant Just to confirm, you would like to book the Premium Suite for tomorrow at 11:00 AM. Could you please provide me with your contact information? I’ll need your full name, phone number, and email address. Thank you! \N 2026-01-28 08:58:55.44106+06
04a595cb-ccb9-45ad-9769-c659a15f172e bfa73499-59af-41c4-a17a-8b739453f99a 11a6fdcc-c203-45b7-b889-44615400abc1 user My name is Emon, phone 01712345678, email emon@test.com \N 2026-01-28 08:59:10.675132+06
be598402-b725-4d15-8deb-bfbaec9dea47 bfa73499-59af-41c4-a17a-8b739453f99a 11a6fdcc-c203-45b7-b889-44615400abc1 assistant Thank you, Emon! Here are your booking details:\n\n- **Service:** Premium Suite\n- **Date and Time:** Tomorrow at 11:00 AM\n- **Name:** Emon\n- **Phone:** 01712345678\n- **Email:** emon@test.com\n\nPlease confirm if all the details are correct. After your confirmation, you will receive a payment link to finalize your booking. Thank you! \N 2026-01-28 08:59:15.000727+06
f0aeab35-a005-4fef-8115-80cccb55a160 bfa73499-59af-41c4-a17a-8b739453f99a 11a6fdcc-c203-45b7-b889-44615400abc1 user Yes, confirmed \N 2026-01-28 08:59:48.475473+06
46a73e25-8b9a-40ef-8985-47733ca75d1e bfa73499-59af-41c4-a17a-8b739453f99a 11a6fdcc-c203-45b7-b889-44615400abc1 assistant Your booking **BK-D14653** has been successfully cancelled. If you'd like to make a new booking, just let me know! \N 2026-01-28 08:59:54.04262+06
7534e57f-192a-43b1-b2c8-b857452a9b1f bfa73499-59af-41c4-a17a-8b739453f99a 0555ab52-fa58-43a2-af36-24dac7ce0643 user I want to book the Family Room \N 2026-01-28 09:01:17.78737+06
7b069792-3ba1-47e6-a4af-165fb8ad9a29 bfa73499-59af-41c4-a17a-8b739453f99a 0555ab52-fa58-43a2-af36-24dac7ce0643 assistant Great choice! When would you like to book the Family Room? Please provide your preferred date and time. \N 2026-01-28 09:01:22.296697+06
73d50fc2-e010-46ec-a759-543b9b6af8ed bfa73499-59af-41c4-a17a-8b739453f99a 0555ab52-fa58-43a2-af36-24dac7ce0643 user February 1st at 3pm \N 2026-01-28 09:01:41.019517+06
771d8008-787d-4391-84f1-fef52035b318 bfa73499-59af-41c4-a17a-8b739453f99a 0555ab52-fa58-43a2-af36-24dac7ce0643 assistant Got it! I’ll book the Family Room for February 1st at 3 PM. Could you please provide your contact information? \n- Full name \n- Phone number \n- Email address \N 2026-01-28 09:01:45.671106+06
3553852f-2ce9-471f-905b-ff0a2af3468f bfa73499-59af-41c4-a17a-8b739453f99a 0555ab52-fa58-43a2-af36-24dac7ce0643 user Emon Karmoker, 01712345678, emon@example.com \N 2026-01-28 09:02:03.934797+06
843d8dc2-7e38-4c29-b8b7-bc1d5a1e7254 bfa73499-59af-41c4-a17a-8b739453f99a 0555ab52-fa58-43a2-af36-24dac7ce0643 assistant Thank you, Emon Karmoker! Here are your booking details:\n\n- **Service:** Family Room\n- **Date and Time:** February 1st, 2026, at 3:00 PM\n- **Name:** Emon Karmoker\n- **Phone:** 01712345678\n- **Email:** emon@example.com\n\nPlease confirm that all the details are correct. After your confirmation, you will receive a payment link to secure your booking. \N 2026-01-28 09:02:12.20709+06
ae1db7a3-77cb-451d-9b94-f2faa9fda938 bfa73499-59af-41c4-a17a-8b739453f99a 0555ab52-fa58-43a2-af36-24dac7ce0643 user Yes, all correct. Please confirm the booking. \N 2026-01-28 09:02:33.556666+06
dfb88afd-7594-40ef-aeab-f84cfccb0499 bfa73499-59af-41c4-a17a-8b739453f99a 0555ab52-fa58-43a2-af36-24dac7ce0643 assistant The booking has been created successfully! Here are your details:\n\n- **Service:** Family Room\n- **Tracking ID:** BK-369747\n\nYou will receive a payment link shortly to complete your booking. You can use the tracking ID to check your booking status at any time.\n\nThank you for choosing us! If you have any further questions or need assistance, feel free to ask. Enjoy your stay! \N 2026-01-28 09:02:39.867195+06
3f4b46eb-ecaa-42e0-9c8f-2a174c7da24b bfa73499-59af-41c4-a17a-8b739453f99a 0555ab52-fa58-43a2-af36-24dac7ce0643 user I want to reschedule my booking BK-369747 to February 5th at 2pm \N 2026-01-28 09:10:39.271674+06
3327115d-6550-4fcc-ab11-522b30edc1bb bfa73499-59af-41c4-a17a-8b739453f99a 0555ab52-fa58-43a2-af36-24dac7ce0643 assistant Your booking **BK-369747** has been rescheduled to **February 05, 2026 at 02:00 PM**. Is there anything else I can help you with? \N 2026-01-28 09:10:45.390687+06
56949545-9c83-4ef4-9067-6ceb223043f7 bfa73499-59af-41c4-a17a-8b739453f99a 3e929134-a26b-4a74-ae34-186657a49084 user I want to book the Deluxe Room \N 2026-01-29 10:55:41.574091+06
1b20f9df-9729-4734-9dc4-4136c3faeaea bfa73499-59af-41c4-a17a-8b739453f99a 3e929134-a26b-4a74-ae34-186657a49084 assistant Great choice! You've selected the Deluxe Room. When would you like to book it? Please let me know your preferred date and time. \N 2026-01-29 10:55:50.123115+06
b7ffb371-ffdc-47eb-981a-fe4d9428b726 bfa73499-59af-41c4-a17a-8b739453f99a 3e929134-a26b-4a74-ae34-186657a49084 user Tomorrow at 3pm \N 2026-01-29 10:56:10.874795+06
34ba9257-0ffd-456d-a9c8-3bdee4958888 bfa73499-59af-41c4-a17a-8b739453f99a 3e929134-a26b-4a74-ae34-186657a49084 assistant Just to confirm, you would like to book the Deluxe Room for tomorrow, January 30th, at 3 PM. Could you please provide me with your full name, phone number, and email address? Thank you! \N 2026-01-29 10:56:15.925482+06
e1a1b959-e86b-442d-bc49-2921180d83e0 bfa73499-59af-41c4-a17a-8b739453f99a 3e929134-a26b-4a74-ae34-186657a49084 user Tomorrow at 3pm \N 2026-01-29 10:57:14.275923+06
27e2ed8e-3ce0-42c6-af88-dfa11742cdb4 bfa73499-59af-41c4-a17a-8b739453f99a 3e929134-a26b-4a74-ae34-186657a49084 assistant I'm sorry, that time slot is no longer available. Here are some alternative times:\n- 2026-01-30T14:00:00\n- 2026-01-30T16:00:00\n- 2026-01-30T13:00:00\n- 2026-01-30T17:00:00\n- 2026-01-30T12:00:00\n\nWhich one would you prefer? \N 2026-01-29 10:57:20.68933+06
39e78c1c-8a5d-4c10-8b37-1457b58d89d6 bfa73499-59af-41c4-a17a-8b739453f99a 3e929134-a26b-4a74-ae34-186657a49084 user 4pm is fine \N 2026-01-29 10:58:05.317525+06
6e3e78be-27f3-41ee-9b23-3d6312345c64 bfa73499-59af-41c4-a17a-8b739453f99a 3e929134-a26b-4a74-ae34-186657a49084 assistant Perfect! I've noted your booking for the Deluxe Room on January 30th at 4 PM. \n\nCould you please provide your full name, phone number, and email address to complete the reservation? Thank you! \N 2026-01-29 10:58:10.501987+06
96728e92-0cea-4487-b50d-af5dd1b8233d bfa73499-59af-41c4-a17a-8b739453f99a 3e929134-a26b-4a74-ae34-186657a49084 user My name is Emon, phone 01712345678, email emon@test.com \N 2026-01-29 10:58:49.229896+06
7eca9ca1-fa7a-4e31-808c-e67bc4b0e622 bfa73499-59af-41c4-a17a-8b739453f99a 3e929134-a26b-4a74-ae34-186657a49084 assistant Thank you, Emon! Here are your booking details:\n\n- **Service:** Deluxe Room\n- **Date and Time:** January 30, 2026, at 4 PM\n- **Name:** Emon\n- **Phone:** 01712345678\n- **Email:** emon@test.com\n\nPlease confirm that all the details are correct. After your confirmation, I will send you a payment link to finalize the booking. \N 2026-01-29 10:58:55.348408+06
f37ce934-8263-42f9-8bb5-b4ccda4e566b bfa73499-59af-41c4-a17a-8b739453f99a 3e929134-a26b-4a74-ae34-186657a49084 user Yes, everything is correct. Please confirm. \N 2026-01-29 10:59:16.690816+06
cbf09221-0259-4813-99ce-b2ea3774303d bfa73499-59af-41c4-a17a-8b739453f99a 3e929134-a26b-4a74-ae34-186657a49084 assistant Your booking **BK-B48A7A** has been successfully cancelled. If you'd like to make a new booking, just let me know! \N 2026-01-29 10:59:21.308165+06
32c48235-4f9f-4e69-bc97-9198ae843c3e bfa73499-59af-41c4-a17a-8b739453f99a 3e929134-a26b-4a74-ae34-186657a49084 user I confirm my booking for the Deluxe Room \N 2026-01-29 10:59:45.684214+06
1ce16bad-5ae3-42f8-8fd5-8fd8346cd32a bfa73499-59af-41c4-a17a-8b739453f99a 3e929134-a26b-4a74-ae34-186657a49084 assistant I don't have all the information needed to complete your booking. Let me help you provide the missing details. \N 2026-01-29 10:59:50.40289+06
7941c910-35e6-4fa5-83c3-7a8264715f44 bfa73499-59af-41c4-a17a-8b739453f99a e5f4e02f-5998-4646-bce7-d42e81c79073 user I want to book the Family Room for February 10th at 2pm. My name is Karim Ahmed, phone 01899999999, email karim@test.com \N 2026-01-29 11:00:38.505814+06
91a83432-7117-4ea9-a097-9f1878f676d5 bfa73499-59af-41c4-a17a-8b739453f99a e5f4e02f-5998-4646-bce7-d42e81c79073 assistant Congratulations, Karim! Your booking for the Family Room has been created successfully!\n\nYou will receive a payment link shortly, so please keep an eye on your email. You can also use the tracking ID, which is PENDING, to check your booking status at any time.\n\nThank you for choosing us! If you have any more questions or need further assistance, feel free to reach out. Enjoy your stay! \N 2026-01-29 11:00:46.33336+06
a9c3dc3c-096d-4293-b703-f06ff1cb5fae bfa73499-59af-41c4-a17a-8b739453f99a e5f4e02f-5998-4646-bce7-d42e81c79073 user I want to talk to a real person please \N 2026-01-29 11:01:11.134009+06
b90af237-5443-494e-99dd-f7be5551893b bfa73499-59af-41c4-a17a-8b739453f99a e5f4e02f-5998-4646-bce7-d42e81c79073 assistant I completely understand that you'd prefer to speak with a real person. Could you please provide me with your contact information, including your name, phone number, and email, if you haven't already? A team member will reach out to you shortly to assist you further. You'll also receive a ticket ID for reference. Thank you for your patience! \N 2026-01-29 11:01:16.590619+06
825c3cb6-5534-4d85-abe4-24cf3b622582 bfa73499-59af-41c4-a17a-8b739453f99a ee4e02d7-1205-4caf-809f-c54549032580 user I want to book the Premium Suite \N 2026-01-29 11:07:31.202254+06
da17abdf-f059-4aff-bef9-8dde7514550f bfa73499-59af-41c4-a17a-8b739453f99a ee4e02d7-1205-4caf-809f-c54549032580 assistant Great choice! You've selected the Premium Suite. When would you like to book it? Please provide your preferred date and time. \N 2026-01-29 11:07:36.390133+06
207b31b0-dcf5-4541-b3a1-621fcf6f44e0 bfa73499-59af-41c4-a17a-8b739453f99a ee4e02d7-1205-4caf-809f-c54549032580 user February 15th at 11am \N 2026-01-29 11:07:53.370665+06
0250793c-149b-419d-bf32-6ca4cd40274e bfa73499-59af-41c4-a17a-8b739453f99a ee4e02d7-1205-4caf-809f-c54549032580 assistant Got it! I’ll book the Premium Suite for you on February 15th at 11:00 AM. Could you please provide your contact information? I'll need your full name, phone number, and email address. Thank you! \N 2026-01-29 11:07:58.837327+06
e08fd424-3f68-44e7-8ed2-82eaaa0a0f7a bfa73499-59af-41c4-a17a-8b739453f99a ee4e02d7-1205-4caf-809f-c54549032580 user My name is Rahim Khan, phone 01855555555, email rahim@gmail.com \N 2026-01-29 11:08:15.698972+06
44f95b45-177b-4f5e-aed1-8cd01c18ea9c bfa73499-59af-41c4-a17a-8b739453f99a ee4e02d7-1205-4caf-809f-c54549032580 assistant Thank you, Rahim Khan! Here are your booking details:\n\n- **Service:** Premium Suite\n- **Date and Time:** February 15, 2026, at 11:00 AM\n- **Name:** Rahim Khan\n- **Phone:** 01855555555\n- **Email:** rahim@gmail.com\n\nPlease confirm if all the details are correct. Once you confirm, I will send you a payment link to finalize your booking. \N 2026-01-29 11:08:23.354106+06
1c19da7f-7b5d-45bf-9943-c4b7436173fd bfa73499-59af-41c4-a17a-8b739453f99a ee4e02d7-1205-4caf-809f-c54549032580 user Yes, all correct \N 2026-01-29 11:08:39.65111+06
c8ead1cf-77a5-4b3e-8663-46f5e6f5dd93 bfa73499-59af-41c4-a17a-8b739453f99a ee4e02d7-1205-4caf-809f-c54549032580 assistant Thank you for confirming, Rahim! Your booking for the Premium Suite has been created successfully!\n\n- **Tracking ID:** BK-D37057\n\nYou will receive a payment link shortly to complete your reservation. You can use the tracking ID to check your booking status anytime.\n\nThank you for choosing us! If you have any questions or need further assistance, feel free to ask. Have a wonderful day! \N 2026-01-29 11:08:44.751627+06
61ac5b08-a0aa-4a4c-8b78-3876ded7f60e bfa73499-59af-41c4-a17a-8b739453f99a aa2d9178-c8af-459f-9679-438086f3c0ad user I want to book the Deluxe Room for February 20th at 10am. My name is Fatima Rahman, phone 01677777777, email fatima@gmail.com \N 2026-01-29 11:15:56.086008+06
f451f457-8a35-4dff-89aa-5c7a8e46827c bfa73499-59af-41c4-a17a-8b739453f99a aa2d9178-c8af-459f-9679-438086f3c0ad assistant Congratulations, Fatima Rahman! Your booking for the Deluxe Room has been created successfully. \n\nYou will receive a payment link shortly to complete your reservation. In the meantime, you can use your tracking ID, which is PENDING, to check the status of your booking at any time.\n\nThank you for choosing us! If you have any further questions or need assistance, feel free to reach out. We look forward to welcoming you! \N 2026-01-29 11:16:02.197408+06
727aeecc-0c26-4921-a6e4-fac061c4c707 bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 user I want to book a room \N 2026-01-29 11:17:43.840138+06
5c49da1a-4fe5-4173-9340-67b2fb9907f6 bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 assistant Great choice! When would you like to book the room? Please let me know your preferred date and time. \N 2026-01-29 11:17:48.028721+06
47434eb3-a1ad-42f7-9f1e-4e488055a105 bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 user Deluxe Room please \N 2026-01-29 11:17:59.016688+06
031dc819-39ed-4302-bac2-fe09a849cdb8 bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 assistant You've selected the Deluxe Room! When would you like to book it? Please share your preferred date and time. \N 2026-01-29 11:18:02.578773+06
30891a5b-51bd-46a8-954f-10aae642e793 bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 user Tomorrow at 2pm \N 2026-01-29 11:18:23.751702+06
96542bc2-6e97-45d0-b1b9-5f3f188b5d5c bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 assistant Just to confirm, you'd like to book the Deluxe Room for tomorrow, January 30th, at 2:00 PM. Could you please provide your contact information? I need your full name, phone number, and email address. Thank you! \N 2026-01-29 11:18:28.088865+06
b3879123-9404-42ba-8f09-fdd4cca57ce0 bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 user id like to book the room Tomorrow at 2pm \N 2026-01-29 11:19:32.999044+06
130755bf-de80-434c-8dd1-df2949bdc4ef bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 assistant I'm sorry, that time slot is no longer available. Here are some alternative times:\n- 2026-01-30T13:00:00\n- 2026-01-30T15:00:00\n- 2026-01-30T12:00:00\n- 2026-01-30T16:00:00\n- 2026-01-30T11:00:00\n\nWhich one would you prefer? \N 2026-01-29 11:19:36.352096+06
97faa4b0-5c72-47a4-b69b-036bde6b8168 bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 user id like to book the room Tomorrow at 4pm \N 2026-01-29 11:19:49.396429+06
4ad00cfb-286c-4d1a-8c93-8c3efd01ac57 bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 assistant I don't have all the information needed to complete your booking. Let me help you provide the missing details. \N 2026-01-29 11:19:52.876447+06
986e8e71-09c1-43e8-b242-389809e595c7 bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 user My name is Test User, phone 01700000000, email test@example.com \N 2026-01-29 11:20:27.324707+06
24de3d20-41d0-4ef9-b14f-d485b73a8fc8 bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 assistant Thank you for providing your details! Here’s a summary of your booking:\n\n- **Service:** Deluxe Room\n- **Date:** January 30, 2026\n- **Time:** 4:00 PM\n- **Name:** Test User\n- **Phone:** 01700000000\n- **Email:** test@example.com\n\nPlease confirm if everything is correct. Once you confirm, I will send you a payment link to complete your booking. \N 2026-01-29 11:20:33.53476+06
d50e4b85-798a-4912-a4f1-0b0badcd5d6f bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 user Yes, confirm my booking \N 2026-01-29 11:20:45.808893+06
1668555d-cb93-4cfe-a52d-248ea8c4efc2 bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 assistant Your booking has been created successfully! \n\n- **Service:** Deluxe Room\n- **Date:** January 30, 2026\n- **Time:** 4:00 PM\n- **Tracking ID:** BK-6E4541\n\nYou will receive a payment link shortly to complete your booking. You can use the tracking ID (BK-6E4541) to check your booking status at any time.\n\nThank you for choosing us! If you have any further questions or need assistance, feel free to ask. Enjoy your stay! \N 2026-01-29 11:20:51.882773+06
07a84b14-5dec-4886-b0a0-50496daef341 bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 user What's the status of booking BK-B9E24E? \N 2026-01-29 11:21:06.53683+06
f10bde2f-1624-458d-b2a5-feb4b83217a4 bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 assistant Here are the details for booking **BK-B9E24E**:\n\n- **Service:** Deluxe Room\n- **Status:** CONFIRMED\n- **Date/Time:** 2026-02-20T04:00:00+00:00\n- **Customer:** Fatima Rahman\n- **Payment:** CREATED\n\nIs there anything else I can help you with? \N 2026-01-29 11:21:12.253196+06
a1ffda74-2f12-475c-ba2a-1e445adecd25 bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 user I want to cancel booking BK-XXXXXX \N 2026-01-29 11:21:23.421676+06
f93c2020-8318-4594-ab2c-48c1626940c3 bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 assistant I understand you want to cancel booking **BK-XXXXXX**. Please confirm that you wish to proceed with this cancellation, as it cannot be undone. \N 2026-01-29 11:21:28.141107+06
8e4ab607-78ff-4a24-a199-0508e4f215f3 bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 user Yes, cancel booking BK-XXXXXX \N 2026-01-29 11:21:47.839655+06
6d9faf5c-20f0-4d38-aaa7-c54c8fdaeac2 bfa73499-59af-41c4-a17a-8b739453f99a 3142d812-f581-46f7-981f-aef00342f582 assistant I couldn't cancel the booking: Booking not found: BK-XXXXXX \N 2026-01-29 11:21:53.203074+06