-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathc2-inventory-qa.sql
More file actions
2014 lines (1670 loc) · 247 KB
/
c2-inventory-qa.sql
File metadata and controls
2014 lines (1670 loc) · 247 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
--
-- Dumped from database version 14.3
-- Dumped by pg_dump version 14.4
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;
DROP INDEX public.voucher_applicable_index;
DROP INDEX public.index_voucher_applicable_targets_on_voucher_sku_id;
DROP INDEX public.index_versions_on_item_type_and_item_id;
DROP INDEX public.index_outlet_skus_on_sku_id;
DROP INDEX public.index_outlet_skus_on_outlet_id;
DROP INDEX public.index_mobility_text_translations_on_translatable_attribute;
DROP INDEX public.index_mobility_text_translations_on_keys;
DROP INDEX public.index_mobility_string_translations_on_translatable_attribute;
DROP INDEX public.index_mobility_string_translations_on_query_keys;
DROP INDEX public.index_mobility_string_translations_on_keys;
DROP INDEX public.index_inventory_timeslots_on_inventory_date_id;
DROP INDEX public.index_inventory_dates_on_sku_type_and_sku_id;
DROP INDEX public.index_images_on_target_type_and_target_id;
DROP INDEX public.index_custom_attributes_on_attributable;
ALTER TABLE ONLY public.voucher_skus DROP CONSTRAINT voucher_skus_pkey;
ALTER TABLE ONLY public.voucher_applicable_targets DROP CONSTRAINT voucher_applicable_targets_pkey;
ALTER TABLE ONLY public.versions DROP CONSTRAINT versions_pkey;
ALTER TABLE ONLY public.skus DROP CONSTRAINT skus_pkey;
ALTER TABLE ONLY public.schema_migrations DROP CONSTRAINT schema_migrations_pkey;
ALTER TABLE ONLY public.outlets DROP CONSTRAINT outlets_pkey;
ALTER TABLE ONLY public.outlet_skus DROP CONSTRAINT outlet_skus_pkey;
ALTER TABLE ONLY public.mobility_text_translations DROP CONSTRAINT mobility_text_translations_pkey;
ALTER TABLE ONLY public.mobility_string_translations DROP CONSTRAINT mobility_string_translations_pkey;
ALTER TABLE ONLY public.inventory_timeslots DROP CONSTRAINT inventory_timeslots_pkey;
ALTER TABLE ONLY public.inventory_dates DROP CONSTRAINT inventory_dates_pkey;
ALTER TABLE ONLY public.images DROP CONSTRAINT images_pkey;
ALTER TABLE ONLY public.custom_attributes DROP CONSTRAINT custom_attributes_pkey;
ALTER TABLE ONLY public.ar_internal_metadata DROP CONSTRAINT ar_internal_metadata_pkey;
ALTER TABLE public.voucher_skus ALTER COLUMN id DROP DEFAULT;
ALTER TABLE public.voucher_applicable_targets ALTER COLUMN id DROP DEFAULT;
ALTER TABLE public.versions ALTER COLUMN id DROP DEFAULT;
ALTER TABLE public.skus ALTER COLUMN id DROP DEFAULT;
ALTER TABLE public.outlets ALTER COLUMN id DROP DEFAULT;
ALTER TABLE public.outlet_skus ALTER COLUMN id DROP DEFAULT;
ALTER TABLE public.mobility_text_translations ALTER COLUMN id DROP DEFAULT;
ALTER TABLE public.mobility_string_translations ALTER COLUMN id DROP DEFAULT;
ALTER TABLE public.inventory_timeslots ALTER COLUMN id DROP DEFAULT;
ALTER TABLE public.inventory_dates ALTER COLUMN id DROP DEFAULT;
ALTER TABLE public.images ALTER COLUMN id DROP DEFAULT;
ALTER TABLE public.custom_attributes ALTER COLUMN id DROP DEFAULT;
DROP SEQUENCE public.voucher_skus_id_seq;
DROP TABLE public.voucher_skus;
DROP SEQUENCE public.voucher_applicable_targets_id_seq;
DROP TABLE public.voucher_applicable_targets;
DROP SEQUENCE public.versions_id_seq;
DROP TABLE public.versions;
DROP SEQUENCE public.skus_id_seq;
DROP TABLE public.skus;
DROP TABLE public.schema_migrations;
DROP SEQUENCE public.outlets_id_seq;
DROP TABLE public.outlets;
DROP SEQUENCE public.outlet_skus_id_seq;
DROP TABLE public.outlet_skus;
DROP SEQUENCE public.mobility_text_translations_id_seq;
DROP TABLE public.mobility_text_translations;
DROP SEQUENCE public.mobility_string_translations_id_seq;
DROP TABLE public.mobility_string_translations;
DROP SEQUENCE public.inventory_timeslots_id_seq;
DROP TABLE public.inventory_timeslots;
DROP SEQUENCE public.inventory_dates_id_seq;
DROP TABLE public.inventory_dates;
DROP SEQUENCE public.images_id_seq;
DROP TABLE public.images;
DROP SEQUENCE public.custom_attributes_id_seq;
DROP TABLE public.custom_attributes;
DROP TABLE public.ar_internal_metadata;
SET default_tablespace = '';
SET default_table_access_method = heap;
--
-- Name: ar_internal_metadata; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.ar_internal_metadata (
key character varying NOT NULL,
value character varying,
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone NOT NULL
);
ALTER TABLE public.ar_internal_metadata OWNER TO postgres;
--
-- Name: custom_attributes; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.custom_attributes (
id bigint NOT NULL,
attributable_id integer,
attributable_type character varying,
name jsonb,
value jsonb,
overwritten timestamp(6) without time zone,
deleted_at timestamp(6) without time zone,
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone NOT NULL
);
ALTER TABLE public.custom_attributes OWNER TO postgres;
--
-- Name: custom_attributes_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.custom_attributes_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.custom_attributes_id_seq OWNER TO postgres;
--
-- Name: custom_attributes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.custom_attributes_id_seq OWNED BY public.custom_attributes.id;
--
-- Name: images; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.images (
id bigint NOT NULL,
image character varying,
target_id integer,
target_type character varying,
tag character varying,
deleted_at timestamp(6) without time zone,
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone NOT NULL
);
ALTER TABLE public.images OWNER TO postgres;
--
-- Name: images_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.images_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.images_id_seq OWNER TO postgres;
--
-- Name: images_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.images_id_seq OWNED BY public.images.id;
--
-- Name: inventory_dates; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.inventory_dates (
id bigint NOT NULL,
date date,
price numeric(10,2) DEFAULT 0.0,
sku_id integer,
sku_type character varying,
deleted_at timestamp(6) without time zone,
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone NOT NULL
);
ALTER TABLE public.inventory_dates OWNER TO postgres;
--
-- Name: inventory_dates_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.inventory_dates_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.inventory_dates_id_seq OWNER TO postgres;
--
-- Name: inventory_dates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.inventory_dates_id_seq OWNED BY public.inventory_dates.id;
--
-- Name: inventory_timeslots; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.inventory_timeslots (
id bigint NOT NULL,
inventory_date_id integer,
start_time timestamp(6) without time zone,
end_time timestamp(6) without time zone,
quantity integer,
deleted_at timestamp(6) without time zone,
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone NOT NULL
);
ALTER TABLE public.inventory_timeslots OWNER TO postgres;
--
-- Name: inventory_timeslots_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.inventory_timeslots_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.inventory_timeslots_id_seq OWNER TO postgres;
--
-- Name: inventory_timeslots_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.inventory_timeslots_id_seq OWNED BY public.inventory_timeslots.id;
--
-- Name: mobility_string_translations; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.mobility_string_translations (
id bigint NOT NULL,
locale character varying NOT NULL,
key character varying NOT NULL,
value character varying,
translatable_type character varying,
translatable_id bigint,
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone NOT NULL
);
ALTER TABLE public.mobility_string_translations OWNER TO postgres;
--
-- Name: mobility_string_translations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.mobility_string_translations_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.mobility_string_translations_id_seq OWNER TO postgres;
--
-- Name: mobility_string_translations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.mobility_string_translations_id_seq OWNED BY public.mobility_string_translations.id;
--
-- Name: mobility_text_translations; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.mobility_text_translations (
id bigint NOT NULL,
locale character varying NOT NULL,
key character varying NOT NULL,
value text,
translatable_type character varying,
translatable_id bigint,
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone NOT NULL
);
ALTER TABLE public.mobility_text_translations OWNER TO postgres;
--
-- Name: mobility_text_translations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.mobility_text_translations_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.mobility_text_translations_id_seq OWNER TO postgres;
--
-- Name: mobility_text_translations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.mobility_text_translations_id_seq OWNED BY public.mobility_text_translations.id;
--
-- Name: outlet_skus; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.outlet_skus (
id bigint NOT NULL,
outlet_id integer,
sku_id integer,
quantity integer DEFAULT 0,
reserved_quantity integer DEFAULT 0,
allocated_quantity integer DEFAULT 0,
deleted_at timestamp(6) without time zone,
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone NOT NULL
);
ALTER TABLE public.outlet_skus OWNER TO postgres;
--
-- Name: outlet_skus_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.outlet_skus_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.outlet_skus_id_seq OWNER TO postgres;
--
-- Name: outlet_skus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.outlet_skus_id_seq OWNED BY public.outlet_skus.id;
--
-- Name: outlets; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.outlets (
id bigint NOT NULL,
master_outlet_ref character varying,
name jsonb,
address jsonb,
short_desc jsonb,
"desc" jsonb,
operation_time_start timestamp(6) without time zone,
operation_time_end timestamp(6) without time zone,
phone_number character varying,
whatsapp_number character varying,
email character varying,
deleted_at timestamp(6) without time zone,
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone NOT NULL
);
ALTER TABLE public.outlets OWNER TO postgres;
--
-- Name: outlets_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.outlets_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.outlets_id_seq OWNER TO postgres;
--
-- Name: outlets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.outlets_id_seq OWNED BY public.outlets.id;
--
-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.schema_migrations (
version character varying NOT NULL
);
ALTER TABLE public.schema_migrations OWNER TO postgres;
--
-- Name: skus; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.skus (
id bigint NOT NULL,
master_sku_ref character varying,
name jsonb,
recommended_price numeric(10,2) DEFAULT 0.0,
cost_price numeric(10,2) DEFAULT 0.0,
deleted_at timestamp(6) without time zone,
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone NOT NULL
);
ALTER TABLE public.skus OWNER TO postgres;
--
-- Name: skus_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.skus_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.skus_id_seq OWNER TO postgres;
--
-- Name: skus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.skus_id_seq OWNED BY public.skus.id;
--
-- Name: versions; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.versions (
id bigint NOT NULL,
item_type character varying NOT NULL,
item_id bigint NOT NULL,
event character varying NOT NULL,
whodunnit character varying,
object_changes text,
created_at timestamp(6) without time zone
);
ALTER TABLE public.versions OWNER TO postgres;
--
-- Name: versions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.versions_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.versions_id_seq OWNER TO postgres;
--
-- Name: versions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.versions_id_seq OWNED BY public.versions.id;
--
-- Name: voucher_applicable_targets; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.voucher_applicable_targets (
id bigint NOT NULL,
voucher_sku_id integer,
voucher_applicable_id integer,
voucher_applicable_type character varying,
voucher_applicable_name jsonb,
deleted_at timestamp(6) without time zone,
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone NOT NULL
);
ALTER TABLE public.voucher_applicable_targets OWNER TO postgres;
--
-- Name: voucher_applicable_targets_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.voucher_applicable_targets_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.voucher_applicable_targets_id_seq OWNER TO postgres;
--
-- Name: voucher_applicable_targets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.voucher_applicable_targets_id_seq OWNED BY public.voucher_applicable_targets.id;
--
-- Name: voucher_skus; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.voucher_skus (
id bigint NOT NULL,
name jsonb,
quantity integer DEFAULT 0,
recommended_price numeric(10,2) DEFAULT 0.0,
value_amount numeric(10,2) DEFAULT 0.0,
min_spend numeric(10,2) DEFAULT 0.0,
reserved_quantity integer DEFAULT 0,
allocated_quantity integer DEFAULT 0,
deleted_at timestamp(6) without time zone,
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone NOT NULL
);
ALTER TABLE public.voucher_skus OWNER TO postgres;
--
-- Name: voucher_skus_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.voucher_skus_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.voucher_skus_id_seq OWNER TO postgres;
--
-- Name: voucher_skus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.voucher_skus_id_seq OWNED BY public.voucher_skus.id;
--
-- Name: custom_attributes id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.custom_attributes ALTER COLUMN id SET DEFAULT nextval('public.custom_attributes_id_seq'::regclass);
--
-- Name: images id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.images ALTER COLUMN id SET DEFAULT nextval('public.images_id_seq'::regclass);
--
-- Name: inventory_dates id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.inventory_dates ALTER COLUMN id SET DEFAULT nextval('public.inventory_dates_id_seq'::regclass);
--
-- Name: inventory_timeslots id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.inventory_timeslots ALTER COLUMN id SET DEFAULT nextval('public.inventory_timeslots_id_seq'::regclass);
--
-- Name: mobility_string_translations id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.mobility_string_translations ALTER COLUMN id SET DEFAULT nextval('public.mobility_string_translations_id_seq'::regclass);
--
-- Name: mobility_text_translations id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.mobility_text_translations ALTER COLUMN id SET DEFAULT nextval('public.mobility_text_translations_id_seq'::regclass);
--
-- Name: outlet_skus id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.outlet_skus ALTER COLUMN id SET DEFAULT nextval('public.outlet_skus_id_seq'::regclass);
--
-- Name: outlets id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.outlets ALTER COLUMN id SET DEFAULT nextval('public.outlets_id_seq'::regclass);
--
-- Name: skus id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.skus ALTER COLUMN id SET DEFAULT nextval('public.skus_id_seq'::regclass);
--
-- Name: versions id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.versions ALTER COLUMN id SET DEFAULT nextval('public.versions_id_seq'::regclass);
--
-- Name: voucher_applicable_targets id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.voucher_applicable_targets ALTER COLUMN id SET DEFAULT nextval('public.voucher_applicable_targets_id_seq'::regclass);
--
-- Name: voucher_skus id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.voucher_skus ALTER COLUMN id SET DEFAULT nextval('public.voucher_skus_id_seq'::regclass);
--
-- Data for Name: ar_internal_metadata; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.ar_internal_metadata (key, value, created_at, updated_at) FROM stdin;
environment production 2022-08-26 15:44:53.693256 2022-08-26 15:44:53.693256
\.
--
-- Data for Name: custom_attributes; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.custom_attributes (id, attributable_id, attributable_type, name, value, overwritten, deleted_at, created_at, updated_at) FROM stdin;
3 1 Sku {"en": "brown", "zh-CN": "棕色"} {"en": "small", "zh-CN": "小号"} \N \N 2022-09-08 06:57:20.805366 2022-09-08 06:57:20.805366
4 2 Sku {"en": "gery", "zh-CN": "灰色"} {"en": "large", "zh-CN": "大号"} \N \N 2022-09-08 06:59:50.810391 2022-09-08 06:59:50.810391
5 3 Sku {"en": "medium", "zh-CN": "中号"} {"en": "yellow", "zh-CN": "黄色"} \N \N 2022-09-08 07:00:48.223434 2022-09-08 07:00:48.223434
2 50 Sku {"en": "12", "zh-CN": "34"} {"en": "45", "zh-CN": "56"} 2022-09-08 09:22:29.253273 \N 2022-09-08 06:19:39.501645 2022-09-08 09:22:29.253541
1 50 Sku {"en": "color", "zh-CN": "颜色1"} {"en": "blue", "zh-CN": "蓝"} 2022-09-09 01:53:53.721373 \N 2022-09-08 06:19:17.649164 2022-09-09 01:53:53.721995
6 4 Sku {"en": "anverage", "zh-CN": "均码"} {"en": "colorful", "zh-CN": "彩色"} 2022-09-09 02:30:23.101969 \N 2022-09-09 02:28:11.285027 2022-09-09 02:30:23.102319
8 7 Sku {"en": "large", "zh-CN": "大份"} {"en": "colorful", "zh-CN": "彩色"} \N \N 2022-09-09 02:32:11.047078 2022-09-09 02:32:11.047078
9 8 Sku {"en": "small", "zh-CN": "小份"} {"en": "colorful", "zh-CN": "彩色"} \N \N 2022-09-09 02:32:43.662843 2022-09-09 02:32:43.662843
10 16 Sku {"en": "same capacity", "zh-CN": "相同容量"} {"en": "pink", "zh-CN": "粉色"} \N \N 2022-09-09 02:34:43.376544 2022-09-09 02:34:43.376544
11 17 Sku {"en": "same capacity", "zh-CN": "相同容量"} {"en": "Purple", "zh-CN": "紫色"} 2022-09-09 02:36:30.882124 \N 2022-09-09 02:35:30.490584 2022-09-09 02:36:30.882549
12 18 Sku {"en": "small", "zh-CN": "x小号"} {"en": "pink", "zh-CN": "粉色"} \N \N 2022-09-09 02:37:47.102005 2022-09-09 02:37:47.102005
13 19 Sku {"en": "large", "zh-CN": "大号"} {"en": "pink", "zh-CN": "粉色"} \N \N 2022-09-09 02:38:20.575113 2022-09-09 02:38:20.575113
14 20 Sku {"en": "same size", "zh-CN": "相同大小"} {"en": "pink and white", "zh-CN": "粉白色"} \N \N 2022-09-09 02:39:27.328384 2022-09-09 02:39:27.328384
15 21 Sku {"en": "small", "zh-CN": "小尺寸"} {"en": "colorful", "zh-CN": "彩色"} \N \N 2022-09-09 02:40:11.155748 2022-09-09 02:40:11.155748
16 22 Sku {"en": "medium", "zh-CN": "中尺寸"} {"en": "colorful", "zh-CN": "彩色"} \N \N 2022-09-09 02:40:45.885049 2022-09-09 02:40:45.885049
17 23 Sku {"en": "large", "zh-CN": "大尺寸"} {"en": "colorful", "zh-CN": "彩色"} \N \N 2022-09-09 02:41:43.938174 2022-09-09 02:41:43.938174
18 24 Sku {"en": "large", "zh-CN": "大号"} {"en": "blue", "zh-CN": "蓝色"} \N \N 2022-09-09 02:42:15.673975 2022-09-09 02:42:15.673975
19 25 Sku {"en": "medium", "zh-CN": "中号"} {"en": "red", "zh-CN": "红色"} \N \N 2022-09-09 02:42:40.562917 2022-09-09 02:42:40.562917
20 26 Sku {"en": "small", "zh-CN": "小号"} {"en": "white", "zh-CN": "白色"} \N \N 2022-09-09 02:43:48.757029 2022-09-09 02:43:48.757029
21 34 Sku {"en": "large", "zh-CN": "大号"} {"en": "yellow", "zh-CN": "黄色"} \N \N 2022-09-09 02:44:34.338855 2022-09-09 02:44:34.338855
22 35 Sku {"en": "small", "zh-CN": "小号"} {"en": "yellow", "zh-CN": "黄色"} \N \N 2022-09-09 02:44:57.777114 2022-09-09 02:44:57.777114
23 36 Sku {"en": "medium", "zh-CN": "中号"} {"en": "yellow", "zh-CN": "黄色"} \N \N 2022-09-09 02:45:24.507776 2022-09-09 02:45:24.507776
24 42 Sku {"en": "small", "zh-CN": "小号"} {"en": "black and white", "zh-CN": "黑白相间"} \N \N 2022-09-09 02:46:18.972008 2022-09-09 02:46:18.972008
25 43 Sku {"en": "large", "zh-CN": "大号"} {"en": "black and white", "zh-CN": "黑白相间"} \N \N 2022-09-09 02:46:45.901984 2022-09-09 02:46:45.901984
26 44 Sku {"en": "average", "zh-CN": "均码"} {"en": " black and white", "zh-CN": "黑白相间"} \N \N 2022-09-09 02:47:16.231453 2022-09-09 02:47:16.231453
27 45 Sku {"en": "small", "zh-CN": "小号"} {"en": "brown", "zh-CN": "棕色"} \N \N 2022-09-09 02:47:49.311039 2022-09-09 02:47:49.311039
28 46 Sku {"en": "large", "zh-CN": "大号"} {"en": "brown", "zh-CN": "棕色"} \N \N 2022-09-09 02:48:27.46749 2022-09-09 02:48:27.46749
29 47 Sku {"en": "average", "zh-CN": "均码"} {"en": "green and white", "zh-CN": "绿白色"} \N \N 2022-09-09 02:49:18.720683 2022-09-09 02:49:18.720683
30 49 Sku {"en": "average", "zh-CN": "均码"} {"en": "blue and white", "zh-CN": "蓝白相间"} \N \N 2022-09-09 02:50:01.313883 2022-09-09 02:50:01.313883
7 5 Sku {"en": "average", "zh-CN": "均码"} {"en": "gery", "zh-CN": "灰色"} 2022-09-09 06:25:53.116823 \N 2022-09-09 02:30:03.508261 2022-09-09 06:25:53.117231
\.
--
-- Data for Name: images; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.images (id, image, target_id, target_type, tag, deleted_at, created_at, updated_at) FROM stdin;
1 kangaroo_doll.png \N \N \N \N 2022-08-31 02:13:48.964557 2022-08-31 02:13:48.964557
2 kangaroo_doll.jpeg \N \N \N \N 2022-08-31 02:16:23.874646 2022-08-31 02:16:23.874646
3 kangaroo_doll.jpeg 1 Sku \N \N 2022-08-31 03:16:55.520952 2022-08-31 03:18:10.628878
4 _kangaroo_doll_grey_.png 2 Sku \N \N 2022-08-31 03:23:10.582046 2022-08-31 03:25:31.548904
5 giraffe_pillow.png 3 Sku \N \N 2022-08-31 03:29:11.196621 2022-08-31 03:30:30.346361
6 Zebra_badge.png 4 Sku \N \N 2022-08-31 03:38:21.9923 2022-08-31 03:39:26.604227
7 Elephant_Keychain.png 5 Sku \N \N 2022-08-31 03:44:35.778353 2022-08-31 03:45:21.962773
8 牛肉拉面.jpeg \N \N \N \N 2022-08-31 06:42:06.447326 2022-08-31 06:42:06.447326
9 牛肉拉面.jpeg 6 Sku \N \N 2022-08-31 06:43:58.790527 2022-08-31 06:46:28.44584
10 beef_hamburger.png 7 Sku \N \N 2022-08-31 06:48:19.87201 2022-08-31 06:50:11.303629
11 beef_hamburger.png \N \N \N \N 2022-08-31 07:28:13.332017 2022-08-31 07:36:01.079738
12 bh_小份_.png 8 Sku \N \N 2022-08-31 07:36:12.371963 2022-08-31 07:36:13.977934
13 cola.png 9 Sku \N \N 2022-08-31 08:59:25.37882 2022-08-31 08:59:39.250432
14 cola.png 10 Sku \N \N 2022-08-31 09:02:22.776144 2022-08-31 09:02:37.375021
15 fries.png 11 Sku \N \N 2022-08-31 09:07:07.87299 2022-08-31 09:09:58.584377
16 小份薯条.png 12 Sku \N \N 2022-08-31 09:13:14.780786 2022-08-31 09:14:04.359302
17 印度黄姜饭.png 13 Sku \N \N 2022-08-31 09:18:01.344681 2022-08-31 09:19:13.427856
18 鸡饭.png 14 Sku \N \N 2022-08-31 09:21:25.477863 2022-08-31 09:22:55.030772
19 烤鸡.png 15 Sku \N \N 2022-08-31 09:24:33.612139 2022-08-31 09:25:21.846627
20 西柚汁.png 16 Sku \N \N 2022-08-31 09:28:41.475434 2022-08-31 09:29:35.49646
21 葡萄汁.png 17 Sku \N \N 2022-08-31 09:33:11.311023 2022-08-31 09:33:24.175352
22 火烈鸟体恤衫.npg.jpeg 18 Sku \N \N 2022-08-31 14:32:33.265782 2022-08-31 14:35:07.893475
23 火烈鸟体恤衫.npg.jpeg 19 Sku \N \N 2022-08-31 14:38:26.278903 2022-08-31 14:39:15.651955
24 火烈鸟杯子.png 20 Sku \N \N 2022-08-31 15:06:02.785539 2022-08-31 15:07:26.692688
25 qie.png 21 Sku \N \N 2022-09-01 01:11:45.029928 2022-09-01 01:13:58.272209
26 qie.png 22 Sku \N \N 2022-09-01 01:15:34.771925 2022-09-01 01:16:16.807356
27 qie.png 23 Sku \N \N 2022-09-01 01:17:40.362104 2022-09-01 01:18:14.43563
28 yingwu.blue.png 24 Sku \N \N 2022-09-01 01:23:35.596146 2022-09-01 01:24:47.974882
29 yingwu_red.png 25 Sku \N \N 2022-09-01 01:26:03.967562 2022-09-01 01:26:40.590732
30 yingwuwhite.png 26 Sku \N \N 2022-09-01 01:27:25.918685 2022-09-01 01:28:10.669091
31 ym.png \N \N \N \N 2022-09-01 01:58:55.126781 2022-09-01 01:58:55.126781
32 ym.png \N \N \N \N 2022-09-01 02:02:06.572924 2022-09-01 02:02:06.572924
33 意大利面.png 27 Sku \N \N 2022-09-01 02:02:37.755942 2022-09-01 02:04:40.753647
34 香草.png 28 Sku \N \N 2022-09-01 02:06:45.390614 2022-09-01 02:07:50.089055
35 榴莲.png 29 Sku \N \N 2022-09-01 02:09:55.326202 2022-09-01 02:11:42.773684
36 榴莲.png 30 Sku \N \N 2022-09-01 02:13:47.443672 2022-09-01 02:14:12.991811
37 海鲜.png 31 Sku \N \N 2022-09-01 02:17:02.70543 2022-09-01 02:18:45.155983
38 海鲜.png 32 Sku \N \N 2022-09-01 02:19:42.619891 2022-09-01 02:20:24.092514
39 黑椒牛排.png 33 Sku \N \N 2022-09-01 02:22:52.180143 2022-09-01 02:23:36.369536
40 狮子.png 34 Sku \N \N 2022-09-01 02:47:41.940262 2022-09-01 02:49:30.234631
41 狮子.png 35 Sku \N \N 2022-09-01 02:52:19.551866 2022-09-01 02:52:42.644181
42 狮子.png 36 Sku \N \N 2022-09-01 03:12:17.117518 2022-09-01 03:12:58.353404
43 手抓饭.png 37 Sku \N \N 2022-09-01 03:26:48.717953 2022-09-01 03:28:13.639396
44 飞饼.png 38 Sku \N \N 2022-09-01 03:31:14.976926 2022-09-01 03:31:43.302093
45 咖喱鸡饭.png 39 Sku \N \N 2022-09-01 03:34:50.51461 2022-09-01 03:36:03.448439
46 咖喱鸡饭.png 40 Sku \N \N 2022-09-01 03:38:08.746791 2022-09-01 03:38:18.593933
47 红豆冰.png 41 Sku \N \N 2022-09-01 03:39:49.300201 2022-09-01 03:40:36.316843
48 panda_s.png 42 Sku \N \N 2022-09-01 06:11:40.391168 2022-09-01 06:12:32.621296
49 pandal.png 43 Sku \N \N 2022-09-01 06:21:15.441415 2022-09-01 06:21:40.944299
50 panda_hat_.png 44 Sku \N \N 2022-09-01 06:22:45.112822 2022-09-01 06:23:37.52171
51 水獭s.png 45 Sku \N \N 2022-09-01 06:31:33.340652 2022-09-01 06:31:51.525683
52 水獭l.png 46 Sku \N \N 2022-09-01 06:34:37.045764 2022-09-01 06:35:24.374572
53 shuatabeigreen.png 47 Sku \N \N 2022-09-01 06:52:01.778497 2022-09-01 06:52:21.644961
54 水獭杯blue.png 48 Sku \N \N 2022-09-01 06:53:40.493578 2022-09-01 06:53:57.120514
55 水獭杯blue.png \N \N \N \N 2022-09-06 09:12:25.623216 2022-09-06 09:12:25.623216
56 水獭杯blue.png \N \N \N \N 2022-09-06 09:13:38.020139 2022-09-06 09:13:38.020139
57 水獭杯blue.png 49 Sku \N \N 2022-09-06 09:19:24.632832 2022-09-06 09:19:50.639466
58 panda_hat_.png \N \N \N \N 2022-09-08 03:53:01.404211 2022-09-08 03:53:01.404211
\.
--
-- Data for Name: inventory_dates; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.inventory_dates (id, date, price, sku_id, sku_type, deleted_at, created_at, updated_at) FROM stdin;
\.
--
-- Data for Name: inventory_timeslots; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.inventory_timeslots (id, inventory_date_id, start_time, end_time, quantity, deleted_at, created_at, updated_at) FROM stdin;
\.
--
-- Data for Name: mobility_string_translations; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.mobility_string_translations (id, locale, key, value, translatable_type, translatable_id, created_at, updated_at) FROM stdin;
6 en name Singapore Zoo Gift Shop Outlet 3 2022-08-31 03:16:08.349509 2022-08-31 03:16:08.349509
7 zh-CN name 新加坡动物园礼品店 Outlet 3 2022-08-31 03:16:08.35202 2022-08-31 03:16:08.35202
8 en address Entrance to Singapore Zoo Outlet 3 2022-08-31 03:16:08.357813 2022-08-31 03:16:08.357813
9 zh-CN address 新加坡动物园入口处 Outlet 3 2022-08-31 03:16:08.362355 2022-08-31 03:16:08.362355
15 zh-CN name 长劲鹿抱枕 Sku 3 2022-08-31 03:30:30.330272 2022-08-31 03:30:30.330272
16 en name Zebra Badge Sku 4 2022-08-31 03:39:26.575935 2022-08-31 03:39:26.575935
17 zh-CN name 斑马徽章 Sku 4 2022-08-31 03:39:26.578701 2022-08-31 03:39:26.578701
18 en name Elephant Keychain Sku 5 2022-08-31 03:45:21.943514 2022-08-31 03:45:21.943514
19 zh-CN name 大象钥匙扣 Sku 5 2022-08-31 03:45:21.945257 2022-08-31 03:45:21.945257
14 en name Giraffe Pillow M Sku 3 2022-08-31 03:30:30.327276 2022-08-31 04:24:37.059661
12 en name Kangaroo Doll Gery L Sku 2 2022-08-31 03:25:31.533461 2022-08-31 04:25:41.595617
13 zh-CN name 大号灰色袋鼠玩偶 Sku 2 2022-08-31 03:25:31.53569 2022-08-31 04:25:41.597796
10 en name Kangaroo Doll Brown S Sku 1 2022-08-31 03:18:10.613901 2022-08-31 04:26:55.789022
11 zh-CN name 小号棕色袋鼠玩偶 Sku 1 2022-08-31 03:18:10.616315 2022-08-31 04:26:55.790863
20 en name KFC Outlet 4 2022-08-31 06:46:06.48676 2022-08-31 06:46:06.48676
21 zh-CN name 肯德基 Outlet 4 2022-08-31 06:46:06.495092 2022-08-31 06:46:06.495092
22 en address Entrance to Singapore Zoo Outlet 4 2022-08-31 06:46:06.497445 2022-08-31 06:46:06.497445
23 zh-CN address 新加坡动物园入口处 Outlet 4 2022-08-31 06:46:06.499787 2022-08-31 06:46:06.499787
26 en name Beef Hamburger L Sku 7 2022-08-31 06:50:11.288449 2022-08-31 06:50:11.288449
28 en name Beef Hamburger S Sku 8 2022-08-31 07:29:23.71858 2022-08-31 07:29:23.71858
29 zh-CN name 小份牛肉汉堡 Sku 8 2022-08-31 07:29:23.722468 2022-08-31 07:29:23.722468
30 en name Ah Meng Restaurant Outlet 5 2022-08-31 07:50:17.218549 2022-08-31 07:50:17.218549
31 zh-CN name 阿明餐厅 Outlet 5 2022-08-31 07:50:17.220852 2022-08-31 07:50:17.220852
32 en address Inside the Singapore Zoo Outlet 5 2022-08-31 07:50:17.224271 2022-08-31 07:50:17.224271
33 zh-CN address 新加坡动物园区内 Outlet 5 2022-08-31 07:50:17.2268 2022-08-31 07:50:17.2268
27 zh-CN name 大份牛肉汉堡 Sku 7 2022-08-31 06:50:11.290457 2022-08-31 08:49:16.269329
34 en name Coke Large Sku 9 2022-08-31 08:59:39.233418 2022-08-31 08:59:39.233418
35 zh-CN name 大份可乐 Sku 9 2022-08-31 08:59:39.236718 2022-08-31 08:59:39.236718
36 en name Member Voucher VoucherSku 1 2022-08-31 09:01:02.418807 2022-08-31 09:01:02.418807
37 zh-CN name 会员优惠券 VoucherSku 1 2022-08-31 09:01:02.420896 2022-08-31 09:01:02.420896
38 en name Ranger Buddy Voucher VoucherSku 2 2022-08-31 09:02:02.715117 2022-08-31 09:02:02.715117
39 zh-CN name 游侠好友优惠券 VoucherSku 2 2022-08-31 09:02:02.721244 2022-08-31 09:02:02.721244
40 en name Coke Small Sku 10 2022-08-31 09:02:37.35265 2022-08-31 09:02:37.35265
41 zh-CN name 小份可乐 Sku 10 2022-08-31 09:02:37.361145 2022-08-31 09:02:37.361145
42 en name Family Voucher VoucherSku 3 2022-08-31 09:04:19.921325 2022-08-31 09:04:19.921325
43 zh-CN name 家庭优惠券 VoucherSku 3 2022-08-31 09:04:19.925188 2022-08-31 09:04:19.925188
44 en name Fries Large Sku 11 2022-08-31 09:09:58.570841 2022-08-31 09:09:58.570841
45 zh-CN name 大份薯条 Sku 11 2022-08-31 09:09:58.573569 2022-08-31 09:09:58.573569
46 en name Cash Voucher VoucherSku 4 2022-08-31 09:11:19.809609 2022-08-31 09:11:19.809609
47 zh-CN name 现金券 VoucherSku 4 2022-08-31 09:11:19.812112 2022-08-31 09:11:19.812112
48 en name Fries Small Sku 12 2022-08-31 09:14:04.335913 2022-08-31 09:14:04.335913
49 zh-CN name 小份薯条 Sku 12 2022-08-31 09:14:04.339027 2022-08-31 09:14:04.339027
52 en name Indian Turmeric Rice Sku 13 2022-08-31 09:19:13.410406 2022-08-31 09:19:13.410406
53 zh-CN name 印度黄姜饭 Sku 13 2022-08-31 09:19:13.41323 2022-08-31 09:19:13.41323
54 en voucher_applicable_name KFC VoucherApplicableTarget 1 2022-08-31 09:21:45.052535 2022-08-31 09:21:45.052535
55 en voucher_applicable_name Singapore Zoo Gift E-shop VoucherApplicableTarget 2 2022-08-31 09:21:45.068842 2022-08-31 09:21:45.068842
56 en name Hainan Chicken Rice Sku 14 2022-08-31 09:22:55.014475 2022-08-31 09:22:55.014475
57 zh-CN name 海南鸡饭 Sku 14 2022-08-31 09:22:55.017572 2022-08-31 09:22:55.017572
58 en name Roast Chicken Sku 15 2022-08-31 09:25:21.828414 2022-08-31 09:25:21.828414
59 zh-CN name 烤鸡 Sku 15 2022-08-31 09:25:21.831417 2022-08-31 09:25:21.831417
60 en name Grapefruit Guice Sku 16 2022-08-31 09:29:35.475587 2022-08-31 09:29:35.475587
61 zh-CN name 鲜榨西柚汁 Sku 16 2022-08-31 09:29:35.477764 2022-08-31 09:29:35.477764
62 en name Grape Guice Sku 17 2022-08-31 09:33:24.162354 2022-08-31 09:33:24.162354
63 zh-CN name 鲜榨葡萄汁 Sku 17 2022-08-31 09:33:24.164336 2022-08-31 09:33:24.164336
64 en name Feather House Gift Shop Outlet 6 2022-08-31 14:27:39.413988 2022-08-31 14:27:39.413988
65 zh-CN name 羽毛屋礼品店 Outlet 6 2022-08-31 14:27:39.416737 2022-08-31 14:27:39.416737
66 en address Bird Park Entrance Outlet 6 2022-08-31 14:27:39.41851 2022-08-31 14:27:39.41851
67 zh-CN address 飞禽公园入口 Outlet 6 2022-08-31 14:27:39.420326 2022-08-31 14:27:39.420326
71 zh-CN name 大号火烈鸟体恤衫 Sku 19 2022-08-31 14:39:15.64173 2022-08-31 14:39:15.64173
69 zh-CN name 小号火烈鸟T恤衫 Sku 18 2022-08-31 14:35:07.881687 2022-08-31 14:39:37.544516
72 en name Flamingo Water Cup Sku 20 2022-08-31 15:07:26.669856 2022-08-31 15:07:26.669856
73 zh-CN name 火烈鸟水杯 Sku 20 2022-08-31 15:07:26.672376 2022-08-31 15:07:26.672376
68 en name Flamingo T-Shirt Pink S Sku 18 2022-08-31 14:35:07.880248 2022-09-01 01:08:05.7235
70 en name Flamingo T-Shirt Pink L Sku 19 2022-08-31 14:39:15.639974 2022-09-01 01:08:42.214522
74 en name Penguin Doll S Sku 21 2022-09-01 01:13:58.256667 2022-09-01 01:13:58.256667
76 en name Penguin Doll M Sku 22 2022-09-01 01:16:16.796036 2022-09-01 01:16:16.796036
77 zh-CN name 中号企鹅玩偶 Sku 22 2022-09-01 01:16:16.797689 2022-09-01 01:16:16.797689
75 zh-CN name 小号企鹅玩偶 Sku 21 2022-09-01 01:13:58.259068 2022-09-01 01:16:38.784395
78 en name Penguin Doll L Sku 23 2022-09-01 01:18:14.419043 2022-09-01 01:18:14.419043
79 zh-CN name 大号企鹅玩偶 Sku 23 2022-09-01 01:18:14.420931 2022-09-01 01:18:14.420931
80 en name Parrot Doll Blue L Sku 24 2022-09-01 01:24:47.960402 2022-09-01 01:24:47.960402
81 zh-CN name 大号蓝色鹦鹉玩偶 Sku 24 2022-09-01 01:24:47.962407 2022-09-01 01:24:47.962407
82 en name Parrot Doll Red M Sku 25 2022-09-01 01:26:40.567132 2022-09-01 01:26:40.567132
83 zh-CN name 中号红色鹦鹉玩偶 Sku 25 2022-09-01 01:26:40.569478 2022-09-01 01:26:40.569478
84 en name Parrot Doll White S Sku 26 2022-09-01 01:28:10.634743 2022-09-01 01:28:10.634743
85 zh-CN name 小号白色鹦鹉玩偶 Sku 26 2022-09-01 01:28:10.636555 2022-09-01 01:28:10.636555
86 en name Pizza Hut Outlet 7 2022-09-01 01:56:01.447869 2022-09-01 01:56:01.447869
87 zh-CN name 必胜客 Outlet 7 2022-09-01 01:56:01.451073 2022-09-01 01:56:01.451073
88 en address Inside Jurong Bird Park Outlet 7 2022-09-01 01:56:01.453554 2022-09-01 01:56:01.453554
89 zh-CN address 裕廊飞禽公园内 Outlet 7 2022-09-01 01:56:01.455469 2022-09-01 01:56:01.455469
90 en name Tomato Pasta Sku 27 2022-09-01 02:04:40.738435 2022-09-01 02:04:40.738435
91 zh-CN name 番茄意大利面 Sku 27 2022-09-01 02:04:40.740721 2022-09-01 02:04:40.740721
92 en name Vanilla Anchovy Shrimp Sku 28 2022-09-01 02:07:50.073795 2022-09-01 02:07:50.073795
93 zh-CN name 香草凤尾虾 Sku 28 2022-09-01 02:07:50.076086 2022-09-01 02:07:50.076086
94 en name Durian Pizza S Sku 29 2022-09-01 02:11:42.753095 2022-09-01 02:11:42.753095
96 en name Durian Pizza L Sku 30 2022-09-01 02:14:12.954876 2022-09-01 02:14:12.954876
97 zh-CN name 大号榴莲披萨 Sku 30 2022-09-01 02:14:12.959607 2022-09-01 02:14:12.959607
95 zh-CN name 小号榴莲披萨 Sku 29 2022-09-01 02:11:42.75612 2022-09-01 02:14:30.452826
98 en name Seafood Pizza S Sku 31 2022-09-01 02:18:45.137135 2022-09-01 02:18:45.137135
99 zh-CN name 小号海鲜披萨 Sku 31 2022-09-01 02:18:45.139847 2022-09-01 02:18:45.139847
100 en name Seafood Pizza L Sku 32 2022-09-01 02:20:24.074882 2022-09-01 02:20:24.074882
101 zh-CN name 大号海鲜披萨 Sku 32 2022-09-01 02:20:24.076852 2022-09-01 02:20:24.076852
102 en name Black Pepper Steak Sku 33 2022-09-01 02:23:36.346334 2022-09-01 02:23:36.346334
103 zh-CN name 黑椒牛排 Sku 33 2022-09-01 02:23:36.348987 2022-09-01 02:23:36.348987
104 en name Night Safari Gift Shop Outlet 8 2022-09-01 02:41:03.109816 2022-09-01 02:41:03.109816
105 zh-CN name 夜间野生动物园礼品店 Outlet 8 2022-09-01 02:41:03.114728 2022-09-01 02:41:03.114728
106 en address Night Safari Entrance Outlet 8 2022-09-01 02:41:03.119123 2022-09-01 02:41:03.119123
107 zh-CN address 野生动物园入口 Outlet 8 2022-09-01 02:41:03.12345 2022-09-01 02:41:03.12345
108 en name Lion Toy L Sku 34 2022-09-01 02:49:30.218487 2022-09-01 02:49:30.218487
110 en name Lion Toy S Sku 35 2022-09-01 02:52:42.626009 2022-09-01 02:52:42.626009
111 zh-CN name 小号狮子玩具 Sku 35 2022-09-01 02:52:42.627704 2022-09-01 02:52:42.627704
109 zh-CN name 大号狮子玩具 Sku 34 2022-09-01 02:49:30.220458 2022-09-01 02:53:00.296232
112 en name Lion Toy M Sku 36 2022-09-01 03:12:58.324224 2022-09-01 03:12:58.324224
113 zh-CN name 中号狮子玩具 Sku 36 2022-09-01 03:12:58.327892 2022-09-01 03:12:58.327892
114 en name Ulu Ulu Wild Restaurant Outlet 9 2022-09-01 03:24:01.782166 2022-09-01 03:24:01.782166
115 zh-CN name 乌鲁乌鲁野生餐厅 Outlet 9 2022-09-01 03:24:01.792175 2022-09-01 03:24:01.792175
116 en address Night Safari Entrance Outlet 9 2022-09-01 03:24:01.794031 2022-09-01 03:24:01.794031
117 zh-CN address 夜间野生动物园入口 Outlet 9 2022-09-01 03:24:01.795974 2022-09-01 03:24:01.795974
118 en name Indian Pilaf Sku 37 2022-09-01 03:28:13.623703 2022-09-01 03:28:13.623703
119 zh-CN name 印度手抓饭 Sku 37 2022-09-01 03:28:13.626735 2022-09-01 03:28:13.626735
120 en name Indian Pancakes Sku 38 2022-09-01 03:31:43.284721 2022-09-01 03:31:43.284721
121 zh-CN name 印度飞饼 Sku 38 2022-09-01 03:31:43.28934 2022-09-01 03:31:43.28934
122 en name Curry Chicken Rice S Sku 39 2022-09-01 03:36:03.420254 2022-09-01 03:36:03.420254
123 zh-CN name 小份咖喱鸡肉饭 Sku 39 2022-09-01 03:36:03.422294 2022-09-01 03:36:03.422294
124 en name Curry Chicken Rices L Sku 40 2022-09-01 03:38:18.579401 2022-09-01 03:38:18.579401
125 zh-CN name 大份咖喱鸡肉饭 Sku 40 2022-09-01 03:38:18.581716 2022-09-01 03:38:18.581716
126 en name Red Bean Ice Sku 41 2022-09-01 03:40:36.297729 2022-09-01 03:40:36.297729
127 zh-CN name 红豆冰 Sku 41 2022-09-01 03:40:36.30011 2022-09-01 03:40:36.30011
128 en name River Wonders Gift Shop Outlet 10 2022-09-01 06:00:52.723462 2022-09-01 06:00:52.723462
129 zh-CN name 河川生态园礼品店 Outlet 10 2022-09-01 06:00:52.725391 2022-09-01 06:00:52.725391
130 en address Inside River Wonders Outlet 10 2022-09-01 06:00:52.726741 2022-09-01 06:00:52.726741
131 zh-CN address 河川生态园内 Outlet 10 2022-09-01 06:00:52.728058 2022-09-01 06:00:52.728058
132 en name Panda Doll S Sku 42 2022-09-01 06:12:32.604418 2022-09-01 06:12:32.604418
133 zh-CN name 小号熊猫玩偶 Sku 42 2022-09-01 06:12:32.606715 2022-09-01 06:12:32.606715
134 en name Education Voucher VoucherSku 6 2022-09-01 06:17:03.064259 2022-09-01 06:17:03.064259
135 zh-CN name 教育券 VoucherSku 6 2022-09-01 06:17:03.0666 2022-09-01 06:17:03.0666
136 en name Panda Doll L Sku 43 2022-09-01 06:21:40.924359 2022-09-01 06:21:40.924359
137 zh-CN name 大号熊猫玩具 Sku 43 2022-09-01 06:21:40.926348 2022-09-01 06:21:40.926348
138 en name Panda Hat Sku 44 2022-09-01 06:23:37.48193 2022-09-01 06:23:37.48193
139 zh-CN name 熊猫帽子 Sku 44 2022-09-01 06:23:37.491996 2022-09-01 06:23:37.491996
140 en name Otter Doll S Sku 45 2022-09-01 06:31:51.507564 2022-09-01 06:31:51.507564
141 zh-CN name 小号水獭公仔 Sku 45 2022-09-01 06:31:51.509628 2022-09-01 06:31:51.509628
142 en name Holiday Voucher VoucherSku 7 2022-09-01 06:34:23.226082 2022-09-01 06:34:23.226082
143 zh-CN name 节日券 VoucherSku 7 2022-09-01 06:34:23.227802 2022-09-01 06:34:23.227802
144 en name Otter Doll L Sku 46 2022-09-01 06:35:24.341469 2022-09-01 06:35:24.341469
145 zh-CN name 大号水獭公仔 Sku 46 2022-09-01 06:35:24.345252 2022-09-01 06:35:24.345252
146 en name Brand Voucher VoucherSku 8 2022-09-01 06:35:50.836624 2022-09-01 06:35:50.836624
147 zh-CN name 品牌券 VoucherSku 8 2022-09-01 06:35:50.849466 2022-09-01 06:35:50.849466
148 en name Otter Cup Green Sku 47 2022-09-01 06:52:21.618505 2022-09-01 06:52:21.618505
149 zh-CN name 绿色水獭杯子 Sku 47 2022-09-01 06:52:21.621065 2022-09-01 06:52:21.621065
150 en name Otter Cup Blue Sku 48 2022-09-01 06:53:57.088686 2022-09-01 06:53:57.088686
151 zh-CN name 蓝色水獭杯 Sku 48 2022-09-01 06:53:57.093662 2022-09-01 06:53:57.093662
153 zh-CN name 折扣券 VoucherSku 9 2022-09-01 09:02:36.438826 2022-09-01 09:02:36.438826
152 en name Discount Voucher VoucherSku 9 2022-09-01 09:02:36.436939 2022-09-01 09:03:11.344617
\.
--
-- Data for Name: mobility_text_translations; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.mobility_text_translations (id, locale, key, value, translatable_type, translatable_id, created_at, updated_at) FROM stdin;
1 en short_desc Stop by any of our gift shops and buy a few as souvenirs for your visit to the Singapore Zoo. Outlet 3 2022-08-31 03:16:08.364605 2022-08-31 03:16:08.364605
2 zh-CN short_desc 到我们的任何一家礼品店逛逛,买几个可作为游览新加坡动物园的纪念礼品。 Outlet 3 2022-08-31 03:16:08.367438 2022-08-31 03:16:08.367438
3 en desc You can add S$1.00 for a small reusable non-woven shopping bag or S$1.50 for a medium shopping bag before payment. Your little effort will help reduce plastic waste and fund our wildlife conservation efforts in the region Outlet 3 2022-08-31 03:16:08.372491 2022-08-31 03:16:08.372491
4 zh-CN desc 付款前您可以添加新币$1.00购买可重复使用的小号非编织购物袋,或添加新币$1.50购买一个中号购物袋。您的举手之劳将帮助减少塑料废弃物,并且资助我们在该区域的野生动物保育工作 Outlet 3 2022-08-31 03:16:08.374697 2022-08-31 03:16:08.374697
5 en short_desc With a casual atmosphere and a variety of food to choose from, Ah Meng Restaurant is the perfect food stop. Outlet 5 2022-08-31 07:50:17.229026 2022-08-31 07:50:17.229026
6 zh-CN short_desc 轻松惬意的就餐氛围,琳琅满目的美食选择,让阿明餐厅成为理想的就餐地点。 Outlet 5 2022-08-31 07:50:17.230698 2022-08-31 07:50:17.230698
7 en desc Enjoy local and western delights such as chicken rice, BBQ Half Spring Chicken, briyani and more! Outlet 5 2022-08-31 07:50:17.232469 2022-08-31 07:50:17.232469
8 zh-CN desc 中西经典美食如鸡饭、烧烤童子鸡、印度黄姜饭等一应俱全 Outlet 5 2022-08-31 07:50:17.234408 2022-08-31 07:50:17.234408
9 en short_desc Shop for bird-themed plush toys and other meaningful souvenirs like dolls and t-shirts. Outlet 6 2022-08-31 14:27:39.421897 2022-09-01 01:35:00.207954
10 zh-CN short_desc 选购飞禽主题的毛绒玩具以及其他意义非凡的纪念品,例如玩偶和T恤。 Outlet 6 2022-08-31 14:27:39.423743 2022-09-01 01:35:00.210078
11 en desc Pizza Hut has dozens of delicious pizzas, and the waiting time for a freshly baked pizza is never more than 15 minutes, and the pizzas you taste everywhere are exactly the same. Outlet 7 2022-09-01 01:56:01.457469 2022-09-01 01:56:01.457469
12 zh-CN desc 必胜客的美味比萨有数十种之多,而等待一份比萨新鲜出炉的时间永远不会超过15分钟,并且你在各地的必胜客,品尝到的比萨口味都完全一致。 Outlet 7 2022-09-01 01:56:01.45932 2022-09-01 01:56:01.45932
13 en short_desc Night Safari shopping options are dazzling, and bring home the unique plush animals of the night! Plus, buy chocolates, cookies, and local favorite kaya as souvenirs at the Village Shop. Outlet 8 2022-09-01 02:41:03.128222 2022-09-01 02:41:03.128222
14 zh-CN short_desc 夜间野生动物园购物选择琳琅满目,将独特的夜间动物毛绒玩具带回家!此外,还可以在 Village Shop 购买巧克力、饼干和当地最受欢迎的咖椰酱等食品作为纪念。 Outlet 8 2022-09-01 02:41:03.144666 2022-09-01 02:41:03.144666
15 en desc Enjoy Singapore's favourites such as chicken rice, pilaf, roti chicken and red bean ice in a charming rural setting. This is a dining experience full of warmth and nostalgia, perfect to start or end an unforgettable evening. Outlet 9 2022-09-01 03:24:01.797764 2022-09-01 03:24:01.797764
16 zh-CN desc 在迷人的乡村环境中享用新加坡最受欢迎的美食,如鸡饭、印度手抓饭、印度式烤鸡和红豆冰等。这是一个充满温暖和怀旧的用餐体验,绝对是开始或结束一个难忘夜晚的完美选择。 Outlet 9 2022-09-01 03:24:01.799918 2022-09-01 03:24:01.799918
17 en short_desc Don't forget to stop by our gift shop and bring some beautiful and meaningful keepsakes for your loved ones or for yourself. Outlet 10 2022-09-01 06:00:52.729712 2022-09-01 06:00:52.729712
18 zh-CN short_desc 别忘了到我们的礼品店逛一逛,为您的亲人或为自己带上几件漂亮且富有意义的纪念品。 Outlet 10 2022-09-01 06:00:52.731384 2022-09-01 06:00:52.731384
\.
--
-- Data for Name: outlet_skus; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.outlet_skus (id, outlet_id, sku_id, quantity, reserved_quantity, allocated_quantity, deleted_at, created_at, updated_at) FROM stdin;
2 3 2 1000 0 0 \N 2022-08-31 03:25:31.538241 2022-08-31 03:25:31.538241
3 3 3 500 0 0 \N 2022-08-31 03:30:30.33445 2022-08-31 03:30:30.33445
4 3 4 2000 0 0 \N 2022-08-31 03:39:26.582531 2022-08-31 03:39:26.582531
5 3 5 2000 0 0 \N 2022-08-31 03:45:21.949032 2022-08-31 03:45:21.949032
6 4 7 200 0 0 \N 2022-08-31 06:50:11.292168 2022-08-31 06:50:11.292168
7 4 8 200 0 0 \N 2022-08-31 07:29:23.726165 2022-08-31 07:29:23.726165
8 4 9 1000 0 0 \N 2022-08-31 08:59:39.23903 2022-08-31 08:59:39.23903
9 4 10 500 0 0 \N 2022-08-31 09:02:37.363127 2022-08-31 09:02:37.363127
10 4 11 500 0 0 \N 2022-08-31 09:09:58.576186 2022-08-31 09:09:58.576186
11 4 12 200 0 0 \N 2022-08-31 09:14:04.341385 2022-08-31 09:14:04.341385
12 5 13 100 0 0 \N 2022-08-31 09:19:13.416068 2022-08-31 09:19:13.416068
13 5 14 100 0 0 \N 2022-08-31 09:22:55.020233 2022-08-31 09:22:55.020233
14 5 15 50 0 0 \N 2022-08-31 09:25:21.834048 2022-08-31 09:25:21.834048