-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathcurey_db.sql
3277 lines (3042 loc) · 230 KB
/
curey_db.sql
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
-- phpMyAdmin SQL Dump
-- version 5.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 23, 2020 at 02:49 PM
-- Server version: 10.4.11-MariaDB
-- PHP Version: 7.4.2
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `curey_db`
--
-- --------------------------------------------------------
--
-- Table structure for table `appointments`
--
CREATE TABLE `appointments` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`doctor_id` int(10) UNSIGNED NOT NULL,
`is_callup` tinyint(1) NOT NULL,
`appointment_time` datetime NOT NULL,
`diagnosis` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`duration` double(8,2) NOT NULL,
`last_checkup` datetime DEFAULT NULL,
`re_examination` tinyint(1) NOT NULL DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `appointments`
--
INSERT INTO `appointments` (`id`, `user_id`, `doctor_id`, `is_callup`, `appointment_time`, `diagnosis`, `duration`, `last_checkup`, `re_examination`, `created_at`, `updated_at`) VALUES
(1, 6, 19, 0, '2020-03-21 18:00:00', 'Operative methodical customerloyalty', 1.00, '2020-03-20 16:34:28', 1, '2020-03-20 14:34:28', '2020-03-20 14:34:28'),
(2, 67, 2, 1, '2020-03-22 13:00:00', 'Realigned real-time definition', 1.00, '2020-03-20 16:34:28', 0, '2020-03-20 14:34:28', '2020-03-20 14:34:28'),
(3, 23, 2, 1, '2020-03-25 14:00:00', 'Stand-alone context-sensitive complexity', 1.00, '2020-03-20 16:34:28', 1, '2020-03-20 14:34:28', '2020-03-20 14:34:28'),
(4, 3, 2, 1, '2020-03-25 15:00:00', 'Secured impactful service-desk', 1.00, '2020-03-20 16:34:28', 1, '2020-03-20 14:34:28', '2020-03-20 14:34:28'),
(5, 88, 2, 0, '2020-03-20 13:00:00', 'Reverse-engineered high-level architecture', 1.00, '2020-03-20 16:34:28', 0, '2020-03-20 14:34:28', '2020-03-20 14:34:28'),
(6, 37, 2, 1, '2020-03-20 14:00:00', 'Monitored empowering matrix', 1.00, '2020-03-20 16:34:28', 0, '2020-03-20 14:34:28', '2020-03-20 14:34:28'),
(7, 84, 19, 1, '2020-03-21 19:00:00', 'Synchronised optimizing success', 1.00, '2020-03-20 16:34:28', 0, '2020-03-20 14:34:28', '2020-03-20 14:34:28'),
(8, 10, 19, 1, '2020-03-21 20:00:00', 'Upgradable national access', 1.00, '2020-03-20 16:34:29', 0, '2020-03-20 14:34:29', '2020-03-20 14:34:29'),
(9, 6, 19, 0, '2020-03-21 21:00:00', 'Up-sized even-keeled contingency', 1.00, '2020-03-20 16:34:29', 1, '2020-03-20 14:34:29', '2020-03-20 14:34:29'),
(10, 48, 19, 1, '2020-03-21 22:00:00', 'Proactive scalable encryption', 1.00, '2020-03-20 16:34:29', 0, '2020-03-20 14:34:29', '2020-03-20 14:34:29'),
(11, 74, 2, 0, '2020-03-22 14:00:00', 'Phased assymetric GraphicInterface', 1.00, '2020-03-20 16:34:29', 1, '2020-03-20 14:34:29', '2020-03-20 14:34:29'),
(12, 5, 19, 1, '2020-03-21 23:00:00', 'Triple-buffered fault-tolerant standardization', 1.00, '2020-03-20 16:34:29', 0, '2020-03-20 14:34:29', '2020-03-20 14:34:29'),
(13, 42, 19, 1, '2020-03-22 00:00:00', 'Networked content-based extranet', 1.00, '2020-03-20 16:34:29', 0, '2020-03-20 14:34:29', '2020-03-20 14:34:29'),
(14, 10, 2, 1, '2020-03-25 16:00:00', 'Reactive well-modulated matrix', 1.00, '2020-03-20 16:34:29', 0, '2020-03-20 14:34:29', '2020-03-20 14:34:29'),
(15, 81, 2, 1, '2020-03-20 15:00:00', 'Front-line impactful collaboration', 1.00, '2020-03-20 16:34:30', 0, '2020-03-20 14:34:30', '2020-03-20 14:34:30'),
(16, 68, 2, 1, '2020-03-22 15:00:00', 'Customer-focused value-added solution', 1.00, '2020-03-20 16:34:30', 1, '2020-03-20 14:34:30', '2020-03-20 14:34:30'),
(17, 48, 2, 0, '2020-03-25 17:00:00', 'Front-line mission-critical customerloyalty', 1.00, '2020-03-20 16:34:30', 0, '2020-03-20 14:34:30', '2020-03-20 14:34:30'),
(18, 52, 19, 0, '2020-03-22 01:00:00', 'Multi-channelled zerodefect orchestration', 1.00, '2020-03-20 16:34:30', 0, '2020-03-20 14:34:30', '2020-03-20 14:34:30'),
(19, 48, 19, 0, '2020-03-22 02:00:00', 'Diverse homogeneous firmware', 1.00, '2020-03-20 16:34:30', 1, '2020-03-20 14:34:30', '2020-03-20 14:34:30'),
(20, 5, 2, 0, '2020-03-22 16:00:00', 'Synchronised local localareanetwork', 1.00, '2020-03-20 16:34:30', 0, '2020-03-20 14:34:30', '2020-03-20 14:34:30'),
(21, 25, 19, 1, '2020-03-22 03:00:00', 'Future-proofed clear-thinking groupware', 1.00, '2020-03-20 16:34:31', 0, '2020-03-20 14:34:31', '2020-03-20 14:34:31'),
(22, 1, 2, 0, '2020-03-22 17:00:00', 'Expanded value-added conglomeration', 1.00, '2020-03-20 16:34:31', 1, '2020-03-20 14:34:31', '2020-03-20 14:34:31'),
(23, 37, 19, 1, '2020-03-22 04:00:00', 'Compatible bottom-line emulation', 1.00, '2020-03-20 16:34:31', 0, '2020-03-20 14:34:31', '2020-03-20 14:34:31'),
(24, 33, 19, 1, '2020-03-22 05:00:00', 'Ameliorated methodical securedline', 1.00, '2020-03-20 16:34:31', 0, '2020-03-20 14:34:31', '2020-03-20 14:34:31'),
(25, 3, 19, 1, '2020-03-22 06:00:00', 'User-centric foreground systemengine', 1.00, '2020-03-20 16:34:31', 0, '2020-03-20 14:34:31', '2020-03-20 14:34:31'),
(26, 52, 2, 0, '2020-04-01 14:00:00', 'Switchable disintermediate structure', 1.00, '2020-03-20 16:34:32', 0, '2020-03-20 14:34:32', '2020-03-20 14:34:32'),
(27, 10, 19, 1, '2020-03-22 07:00:00', 'Programmable motivating leverage', 1.00, '2020-03-20 16:34:32', 1, '2020-03-20 14:34:32', '2020-03-20 14:34:32'),
(28, 37, 2, 1, '2020-04-01 15:00:00', 'Synchronised intermediate artificialintelligence', 1.00, '2020-03-20 16:34:32', 1, '2020-03-20 14:34:32', '2020-03-20 14:34:32'),
(29, 12, 2, 1, '2020-04-01 16:00:00', 'Implemented bi-directional attitude', 1.00, '2020-03-20 16:34:32', 0, '2020-03-20 14:34:32', '2020-03-20 14:34:32'),
(30, 71, 19, 1, '2020-03-22 08:00:00', 'Triple-buffered client-server strategy', 1.00, '2020-03-20 16:34:32', 0, '2020-03-20 14:34:32', '2020-03-20 14:34:32'),
(31, 5, 19, 1, '2020-03-22 09:00:00', 'Customizable client-server superstructure', 1.00, '2020-03-20 16:34:32', 0, '2020-03-20 14:34:32', '2020-03-20 14:34:32'),
(32, 49, 19, 0, '2020-03-22 10:00:00', 'Triple-buffered intangible orchestration', 1.00, '2020-03-20 16:34:32', 0, '2020-03-20 14:34:32', '2020-03-20 14:34:32'),
(33, 23, 19, 0, '2020-03-22 11:00:00', 'Intuitive 24/7 GraphicalUserInterface', 1.00, '2020-03-20 16:34:32', 0, '2020-03-20 14:34:32', '2020-03-20 14:34:32'),
(34, 37, 2, 1, '2020-03-29 13:00:00', 'Multi-tiered holistic conglomeration', 1.00, '2020-03-20 16:34:32', 1, '2020-03-20 14:34:32', '2020-03-20 14:34:32'),
(35, 12, 19, 1, '2020-03-28 18:00:00', 'Customer-focused 6thgeneration productivity', 1.00, '2020-03-20 16:34:32', 0, '2020-03-20 14:34:32', '2020-03-20 14:34:32'),
(36, 74, 2, 0, '2020-04-08 14:00:00', 'Advanced impactful opensystem', 1.00, '2020-03-20 16:34:32', 0, '2020-03-20 14:34:32', '2020-03-20 14:34:32'),
(37, 5, 19, 0, '2020-03-28 19:00:00', 'Profit-focused 4thgeneration strategy', 1.00, '2020-03-20 16:34:33', 0, '2020-03-20 14:34:33', '2020-03-20 14:34:33'),
(38, 23, 19, 0, '2020-03-28 20:00:00', 'Mandatory needs-based leverage', 1.00, '2020-03-20 16:34:33', 1, '2020-03-20 14:34:33', '2020-03-20 14:34:33'),
(39, 74, 2, 1, '2020-03-29 14:00:00', 'Secured discrete workforce', 1.00, '2020-03-20 16:34:33', 1, '2020-03-20 14:34:33', '2020-03-20 14:34:33'),
(40, 42, 2, 0, '2020-03-29 15:00:00', 'Self-enabling background approach', 1.00, '2020-03-20 16:34:33', 0, '2020-03-20 14:34:33', '2020-03-20 14:34:33'),
(41, 42, 2, 1, '2020-04-08 15:00:00', 'Configurable maximized matrix', 1.00, '2020-03-20 16:34:33', 1, '2020-03-20 14:34:33', '2020-03-20 14:34:33'),
(42, 6, 19, 0, '2020-03-28 21:00:00', 'Distributed 4thgeneration standardization', 1.00, '2020-03-20 16:34:33', 0, '2020-03-20 14:34:33', '2020-03-20 14:34:33'),
(43, 4, 2, 1, '2020-03-20 16:00:00', 'Stand-alone radical leverage', 1.00, '2020-03-20 16:34:33', 1, '2020-03-20 14:34:33', '2020-03-20 14:34:33'),
(44, 58, 19, 1, '2020-03-28 22:00:00', 'Cross-group clear-thinking interface', 1.00, '2020-03-20 16:34:33', 1, '2020-03-20 14:34:33', '2020-03-20 14:34:33'),
(45, 75, 19, 1, '2020-03-28 23:00:00', 'Profit-focused well-modulated capability', 1.00, '2020-03-20 16:34:34', 0, '2020-03-20 14:34:34', '2020-03-20 14:34:34'),
(46, 85, 19, 0, '2020-03-29 00:00:00', 'Future-proofed bi-directional analyzer', 1.00, '2020-03-20 16:34:34', 1, '2020-03-20 14:34:34', '2020-03-20 14:34:34'),
(47, 67, 2, 0, '2020-03-20 17:00:00', 'Integrated multimedia capability', 1.00, '2020-03-20 16:34:34', 0, '2020-03-20 14:34:34', '2020-03-20 14:34:34'),
(48, 78, 19, 1, '2020-03-29 01:00:00', 'Cross-platform assymetric support', 1.00, '2020-03-20 16:34:34', 0, '2020-03-20 14:34:34', '2020-03-20 14:34:34'),
(49, 75, 19, 1, '2020-03-29 02:00:00', 'Persevering empowering collaboration', 1.00, '2020-03-20 16:34:34', 0, '2020-03-20 14:34:34', '2020-03-20 14:34:34'),
(50, 76, 2, 0, '2020-04-08 16:00:00', 'Exclusive clear-thinking leverage', 1.00, '2020-03-20 16:34:35', 1, '2020-03-20 14:34:35', '2020-03-20 14:34:35'),
(51, 85, 2, 0, '2020-03-27 13:00:00', 'Upgradable zerotolerance attitude', 1.00, '2020-03-20 16:34:35', 1, '2020-03-20 14:34:35', '2020-03-20 14:34:35'),
(52, 67, 2, 1, '2020-04-15 14:00:00', 'Business-focused multi-state utilisation', 1.00, '2020-03-20 16:34:35', 1, '2020-03-20 14:34:35', '2020-03-20 14:34:35'),
(53, 49, 19, 0, '2020-03-29 03:00:00', 'Operative content-based database', 1.00, '2020-03-20 16:34:35', 1, '2020-03-20 14:34:35', '2020-03-20 14:34:35'),
(54, 3, 2, 0, '2020-03-27 14:00:00', 'Inverse system-worthy matrix', 1.00, '2020-03-20 16:34:35', 0, '2020-03-20 14:34:35', '2020-03-20 14:34:35'),
(55, 78, 2, 1, '2020-03-29 16:00:00', 'Cross-group fresh-thinking groupware', 1.00, '2020-03-20 16:34:35', 1, '2020-03-20 14:34:35', '2020-03-20 14:34:35'),
(56, 78, 2, 0, '2020-04-15 15:00:00', 'Adaptive dedicated function', 1.00, '2020-03-20 16:34:35', 1, '2020-03-20 14:34:35', '2020-03-20 14:34:35'),
(57, 68, 2, 0, '2020-04-05 13:00:00', 'Enterprise-wide non-volatile middleware', 1.00, '2020-03-20 16:34:35', 0, '2020-03-20 14:34:35', '2020-03-20 14:34:35'),
(58, 5, 19, 0, '2020-03-29 04:00:00', 'Versatile bi-directional moderator', 1.00, '2020-03-20 16:34:35', 0, '2020-03-20 14:34:35', '2020-03-20 14:34:35'),
(59, 23, 19, 1, '2020-03-29 05:00:00', 'Managed zeroadministration opensystem', 1.00, '2020-03-20 16:34:36', 1, '2020-03-20 14:34:36', '2020-03-20 14:34:36'),
(60, 75, 2, 0, '2020-03-27 15:00:00', 'Centralized local parallelism', 1.00, '2020-03-20 16:34:36', 0, '2020-03-20 14:34:36', '2020-03-20 14:34:36'),
(61, 68, 19, 1, '2020-03-29 06:00:00', 'Polarised context-sensitive data-warehouse', 1.00, '2020-03-20 16:34:36', 1, '2020-03-20 14:34:36', '2020-03-20 14:34:36'),
(62, 12, 2, 1, '2020-03-27 16:00:00', 'Assimilated incremental knowledgeuser', 1.00, '2020-03-20 16:34:36', 0, '2020-03-20 14:34:36', '2020-03-20 14:34:36'),
(63, 23, 2, 0, '2020-04-05 14:00:00', 'Customizable zeroadministration firmware', 1.00, '2020-03-20 16:34:37', 0, '2020-03-20 14:34:37', '2020-03-20 14:34:37'),
(64, 48, 2, 1, '2020-04-15 16:00:00', 'Up-sized high-level middleware', 1.00, '2020-03-20 16:34:37', 0, '2020-03-20 14:34:37', '2020-03-20 14:34:37'),
(65, 3, 19, 0, '2020-03-29 07:00:00', 'Exclusive needs-based conglomeration', 1.00, '2020-03-20 16:34:37', 0, '2020-03-20 14:34:37', '2020-03-20 14:34:37'),
(66, 4, 2, 0, '2020-04-22 14:00:00', 'Ameliorated actuating budgetarymanagement', 1.00, '2020-03-20 16:34:37', 0, '2020-03-20 14:34:37', '2020-03-20 14:34:37'),
(67, 12, 19, 0, '2020-03-29 08:00:00', 'Enterprise-wide user-facing architecture', 1.00, '2020-03-20 16:34:38', 0, '2020-03-20 14:34:38', '2020-03-20 14:34:38'),
(68, 68, 19, 0, '2020-03-29 09:00:00', 'Extended mission-critical portal', 1.00, '2020-03-20 16:34:38', 0, '2020-03-20 14:34:38', '2020-03-20 14:34:38'),
(69, 12, 19, 1, '2020-03-29 10:00:00', 'Multi-channelled foreground collaboration', 1.00, '2020-03-20 16:34:38', 1, '2020-03-20 14:34:38', '2020-03-20 14:34:38'),
(70, 75, 2, 1, '2020-04-22 15:00:00', 'Focused impactful attitude', 1.00, '2020-03-20 16:34:38', 0, '2020-03-20 14:34:38', '2020-03-20 14:34:38'),
(71, 88, 2, 0, '2020-04-05 15:00:00', 'Visionary exuding systemengine', 1.00, '2020-03-20 16:34:38', 0, '2020-03-20 14:34:38', '2020-03-20 14:34:38'),
(72, 85, 2, 1, '2020-04-03 13:00:00', 'Multi-layered client-server hardware', 1.00, '2020-03-20 16:34:38', 1, '2020-03-20 14:34:38', '2020-03-20 14:34:38'),
(73, 75, 19, 0, '2020-04-04 18:00:00', 'Exclusive hybrid migration', 1.00, '2020-03-20 16:34:38', 1, '2020-03-20 14:34:38', '2020-03-20 14:34:38'),
(74, 1, 2, 1, '2020-04-03 14:00:00', 'Optional object-oriented parallelism', 1.00, '2020-03-20 16:34:39', 0, '2020-03-20 14:34:39', '2020-03-20 14:34:39'),
(75, 1, 2, 1, '2020-04-22 16:00:00', 'De-engineered intermediate time-frame', 1.00, '2020-03-20 16:34:39', 0, '2020-03-20 14:34:39', '2020-03-20 14:34:39'),
(76, 42, 2, 1, '2020-04-03 15:00:00', 'Automated demand-driven emulation', 1.00, '2020-03-20 16:34:40', 0, '2020-03-20 14:34:40', '2020-03-20 14:34:40'),
(77, 14, 19, 0, '2020-04-04 19:00:00', 'Customizable multi-state capacity', 1.00, '2020-03-20 16:34:40', 0, '2020-03-20 14:34:40', '2020-03-20 14:34:40'),
(78, 78, 19, 0, '2020-04-04 20:00:00', 'Team-oriented mobile alliance', 1.00, '2020-03-20 16:34:40', 0, '2020-03-20 14:34:40', '2020-03-20 14:34:40'),
(79, 74, 2, 1, '2020-04-03 16:00:00', 'Operative context-sensitive protocol', 1.00, '2020-03-20 16:34:40', 1, '2020-03-20 14:34:40', '2020-03-20 14:34:40'),
(80, 81, 19, 0, '2020-04-04 21:00:00', 'Public-key system-worthy strategy', 1.00, '2020-03-20 16:34:40', 1, '2020-03-20 14:34:40', '2020-03-20 14:34:40'),
(81, 25, 19, 0, '2020-04-04 22:00:00', 'Reactive mission-critical hardware', 1.00, '2020-03-20 16:34:40', 0, '2020-03-20 14:34:40', '2020-03-20 14:34:40'),
(82, 68, 2, 1, '2020-04-05 16:00:00', 'Intuitive static superstructure', 1.00, '2020-03-20 16:34:40', 1, '2020-03-20 14:34:40', '2020-03-20 14:34:40'),
(83, 88, 2, 0, '2020-04-29 14:00:00', 'Ameliorated national productivity', 1.00, '2020-03-20 16:34:40', 0, '2020-03-20 14:34:40', '2020-03-20 14:34:40'),
(84, 52, 19, 0, '2020-04-04 23:00:00', 'Profit-focused foreground hub', 1.00, '2020-03-20 16:34:41', 1, '2020-03-20 14:34:41', '2020-03-20 14:34:41'),
(85, 81, 2, 1, '2020-04-10 13:00:00', 'Managed nextgeneration complexity', 1.00, '2020-03-20 16:34:41', 1, '2020-03-20 14:34:41', '2020-03-20 14:34:41'),
(86, 68, 2, 1, '2020-04-12 13:00:00', 'Fundamental reciprocal portal', 1.00, '2020-03-20 16:34:41', 0, '2020-03-20 14:34:41', '2020-03-20 14:34:41'),
(87, 75, 2, 1, '2020-04-12 14:00:00', 'Total heuristic product', 1.00, '2020-03-20 16:34:42', 0, '2020-03-20 14:34:42', '2020-03-20 14:34:42'),
(88, 6, 19, 1, '2020-04-05 00:00:00', 'Front-line disintermediate productivity', 1.00, '2020-03-20 16:34:42', 1, '2020-03-20 14:34:42', '2020-03-20 14:34:42'),
(89, 12, 19, 1, '2020-04-05 01:00:00', 'Enhanced demand-driven interface', 1.00, '2020-03-20 16:34:42', 0, '2020-03-20 14:34:42', '2020-03-20 14:34:42'),
(90, 5, 19, 1, '2020-04-05 02:00:00', 'Advanced context-sensitive instructionset', 1.00, '2020-03-20 16:34:42', 0, '2020-03-20 14:34:42', '2020-03-20 14:34:42'),
(91, 74, 2, 1, '2020-04-12 15:00:00', 'Function-based multi-tasking leverage', 1.00, '2020-03-20 16:34:42', 0, '2020-03-20 14:34:42', '2020-03-20 14:34:42'),
(92, 14, 2, 1, '2020-04-12 16:00:00', 'Visionary exuding paradigm', 1.00, '2020-03-20 16:34:43', 0, '2020-03-20 14:34:43', '2020-03-20 14:34:43'),
(93, 49, 2, 0, '2020-04-19 13:00:00', 'Devolved multi-tasking help-desk', 1.00, '2020-03-20 16:34:43', 1, '2020-03-20 14:34:43', '2020-03-20 14:34:43'),
(94, 33, 2, 1, '2020-04-19 14:00:00', 'Visionary 24hour portal', 1.00, '2020-03-20 16:34:43', 1, '2020-03-20 14:34:43', '2020-03-20 14:34:43'),
(95, 25, 19, 1, '2020-04-05 03:00:00', 'Reverse-engineered modular access', 1.00, '2020-03-20 16:34:43', 0, '2020-03-20 14:34:43', '2020-03-20 14:34:43'),
(96, 42, 2, 0, '2020-04-19 15:00:00', 'Streamlined discrete definition', 1.00, '2020-03-20 16:34:43', 0, '2020-03-20 14:34:43', '2020-03-20 14:34:43'),
(97, 12, 2, 0, '2020-04-19 16:00:00', 'Diverse object-oriented product', 1.00, '2020-03-20 16:34:44', 0, '2020-03-20 14:34:44', '2020-03-20 14:34:44'),
(98, 88, 2, 1, '2020-04-26 13:00:00', 'Integrated transitional analyzer', 1.00, '2020-03-20 16:34:44', 1, '2020-03-20 14:34:44', '2020-03-20 14:34:44'),
(99, 71, 2, 0, '2020-04-10 14:00:00', 'Seamless zeroadministration circuit', 1.00, '2020-03-20 16:34:44', 1, '2020-03-20 14:34:44', '2020-03-20 14:34:44'),
(100, 84, 2, 1, '2020-04-10 15:00:00', 'Re-engineered content-based portal', 1.00, '2020-03-20 16:34:44', 1, '2020-03-20 14:34:44', '2020-03-20 14:34:44'),
(101, 76, 2, 1, '2020-04-29 15:00:00', 'Down-sized holistic budgetarymanagement', 1.00, '2020-03-20 16:34:44', 1, '2020-03-20 14:34:44', '2020-03-20 14:34:44'),
(102, 81, 2, 1, '2020-04-29 16:00:00', 'Customizable object-oriented access', 1.00, '2020-03-20 16:34:44', 1, '2020-03-20 14:34:44', '2020-03-20 14:34:44'),
(103, 37, 19, 1, '2020-04-05 04:00:00', 'Visionary uniform benchmark', 1.00, '2020-03-20 16:34:44', 1, '2020-03-20 14:34:44', '2020-03-20 14:34:44'),
(104, 85, 19, 1, '2020-04-05 05:00:00', 'Managed uniform concept', 1.00, '2020-03-20 16:34:44', 1, '2020-03-20 14:34:44', '2020-03-20 14:34:44'),
(105, 42, 2, 0, '2020-05-06 14:00:00', 'Persistent eco-centric help-desk', 1.00, '2020-03-20 16:34:44', 1, '2020-03-20 14:34:44', '2020-03-20 14:34:44'),
(106, 1, 19, 0, '2020-04-05 06:00:00', 'Programmable optimal data-warehouse', 1.00, '2020-03-20 16:34:45', 0, '2020-03-20 14:34:45', '2020-03-20 14:34:45'),
(107, 12, 19, 1, '2020-04-05 07:00:00', 'Managed zerotolerance encryption', 1.00, '2020-03-20 16:34:45', 0, '2020-03-20 14:34:45', '2020-03-20 14:34:45'),
(108, 5, 2, 0, '2020-04-10 16:00:00', 'Balanced exuding structure', 1.00, '2020-03-20 16:34:45', 0, '2020-03-20 14:34:45', '2020-03-20 14:34:45'),
(109, 74, 19, 0, '2020-04-05 08:00:00', 'Multi-lateral transitional focusgroup', 1.00, '2020-03-20 16:34:45', 1, '2020-03-20 14:34:45', '2020-03-20 14:34:45'),
(110, 12, 19, 1, '2020-04-05 09:00:00', 'Down-sized explicit software', 1.00, '2020-03-20 16:34:45', 0, '2020-03-20 14:34:45', '2020-03-20 14:34:45'),
(111, 23, 19, 0, '2020-04-05 10:00:00', 'Automated 6thgeneration productivity', 1.00, '2020-03-20 16:34:45', 0, '2020-03-20 14:34:45', '2020-03-20 14:34:45'),
(112, 42, 2, 0, '2020-04-26 14:00:00', 'Inverse actuating attitude', 1.00, '2020-03-20 16:34:46', 0, '2020-03-20 14:34:46', '2020-03-20 14:34:46'),
(113, 74, 2, 0, '2020-04-26 15:00:00', 'Open-architected needs-based migration', 1.00, '2020-03-20 16:34:46', 1, '2020-03-20 14:34:46', '2020-03-20 14:34:46'),
(114, 78, 2, 0, '2020-05-06 15:00:00', 'Multi-channelled analyzing throughput', 1.00, '2020-03-20 16:34:46', 1, '2020-03-20 14:34:46', '2020-03-20 14:34:46'),
(115, 84, 2, 1, '2020-04-26 16:00:00', 'Virtual holistic hardware', 1.00, '2020-03-20 16:34:47', 1, '2020-03-20 14:34:47', '2020-03-20 14:34:47'),
(116, 4, 2, 1, '2020-04-17 13:00:00', 'Reactive background info-mediaries', 1.00, '2020-03-20 16:34:47', 0, '2020-03-20 14:34:47', '2020-03-20 14:34:47'),
(117, 4, 19, 1, '2020-04-11 18:00:00', 'Versatile demand-driven model', 1.00, '2020-03-20 16:34:47', 0, '2020-03-20 14:34:47', '2020-03-20 14:34:47'),
(118, 49, 19, 0, '2020-04-11 19:00:00', 'Future-proofed reciprocal toolset', 1.00, '2020-03-20 16:34:48', 0, '2020-03-20 14:34:48', '2020-03-20 14:34:48'),
(119, 4, 2, 1, '2020-05-06 16:00:00', 'Centralized reciprocal attitude', 1.00, '2020-03-20 16:34:48', 0, '2020-03-20 14:34:48', '2020-03-20 14:34:48'),
(120, 5, 2, 0, '2020-04-17 14:00:00', 'Advanced tertiary moratorium', 1.00, '2020-03-20 16:34:48', 0, '2020-03-20 14:34:48', '2020-03-20 14:34:48'),
(121, 76, 19, 0, '2020-04-11 20:00:00', 'Re-contextualized eco-centric conglomeration', 1.00, '2020-03-20 16:34:48', 0, '2020-03-20 14:34:48', '2020-03-20 14:34:48'),
(122, 85, 2, 1, '2020-04-17 15:00:00', 'Profit-focused disintermediate functionalities', 1.00, '2020-03-20 16:34:49', 0, '2020-03-20 14:34:49', '2020-03-20 14:34:49'),
(123, 14, 19, 0, '2020-04-11 21:00:00', 'Total global projection', 1.00, '2020-03-20 16:34:49', 1, '2020-03-20 14:34:49', '2020-03-20 14:34:49'),
(124, 4, 19, 1, '2020-04-11 22:00:00', 'Synergistic static hub', 1.00, '2020-03-20 16:34:49', 0, '2020-03-20 14:34:49', '2020-03-20 14:34:49'),
(125, 5, 19, 0, '2020-04-11 23:00:00', 'Assimilated bottom-line superstructure', 1.00, '2020-03-20 16:34:49', 1, '2020-03-20 14:34:49', '2020-03-20 14:34:49'),
(126, 23, 2, 1, '2020-05-13 14:00:00', 'Assimilated intangible productivity', 1.00, '2020-03-20 16:34:49', 1, '2020-03-20 14:34:49', '2020-03-20 14:34:49'),
(127, 76, 2, 1, '2020-05-13 15:00:00', 'Progressive dynamic productivity', 1.00, '2020-03-20 16:34:50', 1, '2020-03-20 14:34:50', '2020-03-20 14:34:50'),
(128, 33, 2, 0, '2020-04-17 16:00:00', 'Managed leadingedge policy', 1.00, '2020-03-20 16:34:50', 1, '2020-03-20 14:34:50', '2020-03-20 14:34:50'),
(129, 84, 2, 1, '2020-05-13 16:00:00', 'Distributed asynchronous extranet', 1.00, '2020-03-20 16:34:50', 0, '2020-03-20 14:34:50', '2020-03-20 14:34:50'),
(130, 58, 2, 1, '2020-04-24 13:00:00', 'Upgradable regional processimprovement', 1.00, '2020-03-20 16:34:50', 0, '2020-03-20 14:34:50', '2020-03-20 14:34:50'),
(131, 3, 2, 1, '2020-05-20 14:00:00', 'Versatile full-range benchmark', 1.00, '2020-03-20 16:34:50', 1, '2020-03-20 14:34:50', '2020-03-20 14:34:50'),
(132, 76, 19, 0, '2020-04-12 00:00:00', 'Future-proofed leadingedge matrices', 1.00, '2020-03-20 16:34:51', 1, '2020-03-20 14:34:51', '2020-03-20 14:34:51'),
(133, 84, 19, 1, '2020-04-12 01:00:00', 'Multi-channelled optimizing synergy', 1.00, '2020-03-20 16:34:51', 0, '2020-03-20 14:34:51', '2020-03-20 14:34:51'),
(134, 52, 19, 0, '2020-04-12 02:00:00', 'Robust 24/7 blockchain', 1.00, '2020-03-20 16:34:51', 1, '2020-03-20 14:34:51', '2020-03-20 14:34:51'),
(135, 52, 2, 1, '2020-05-20 15:00:00', 'Fully-configurable incremental encryption', 1.00, '2020-03-20 16:34:51', 0, '2020-03-20 14:34:51', '2020-03-20 14:34:51'),
(136, 48, 2, 1, '2020-04-24 14:00:00', 'Synchronised disintermediate encryption', 1.00, '2020-03-20 16:34:52', 1, '2020-03-20 14:34:52', '2020-03-20 14:34:52'),
(137, 48, 2, 0, '2020-04-24 15:00:00', 'Secured methodical structure', 1.00, '2020-03-20 16:34:52', 1, '2020-03-20 14:34:52', '2020-03-20 14:34:52'),
(138, 14, 2, 1, '2020-05-03 13:00:00', 'Intuitive demand-driven openarchitecture', 1.00, '2020-03-20 16:34:53', 0, '2020-03-20 14:34:53', '2020-03-20 14:34:53'),
(139, 33, 19, 0, '2020-04-12 03:00:00', 'Managed hybrid instructionset', 1.00, '2020-03-20 16:34:53', 0, '2020-03-20 14:34:53', '2020-03-20 14:34:53'),
(140, 85, 19, 0, '2020-04-12 04:00:00', 'Polarised zerodefect intranet', 1.00, '2020-03-20 16:34:54', 1, '2020-03-20 14:34:54', '2020-03-20 14:34:54'),
(141, 6, 19, 0, '2020-04-12 05:00:00', 'Managed 3rdgeneration service-desk', 1.00, '2020-03-20 16:34:54', 0, '2020-03-20 14:34:54', '2020-03-20 14:34:54'),
(142, 3, 2, 1, '2020-05-20 16:00:00', 'Self-enabling dedicated productivity', 1.00, '2020-03-20 16:34:54', 0, '2020-03-20 14:34:54', '2020-03-20 14:34:54'),
(143, 37, 2, 1, '2020-04-24 16:00:00', 'Multi-lateral multi-state solution', 1.00, '2020-03-20 16:34:54', 1, '2020-03-20 14:34:54', '2020-03-20 14:34:54'),
(144, 10, 2, 1, '2020-05-03 14:00:00', 'Compatible directional ability', 1.00, '2020-03-20 16:34:54', 1, '2020-03-20 14:34:54', '2020-03-20 14:34:54'),
(145, 88, 19, 1, '2020-04-12 06:00:00', 'User-friendly 5thgeneration encoding', 1.00, '2020-03-20 16:34:54', 1, '2020-03-20 14:34:54', '2020-03-20 14:34:54'),
(146, 1, 19, 0, '2020-04-12 07:00:00', 'Ameliorated transitional forecast', 1.00, '2020-03-20 16:34:55', 1, '2020-03-20 14:34:55', '2020-03-20 14:34:55'),
(147, 88, 2, 1, '2020-05-01 13:00:00', 'Automated even-keeled interface', 1.00, '2020-03-20 16:34:55', 0, '2020-03-20 14:34:55', '2020-03-20 14:34:55'),
(148, 6, 2, 0, '2020-05-03 15:00:00', 'De-engineered bandwidth-monitored adapter', 1.00, '2020-03-20 16:34:55', 0, '2020-03-20 14:34:55', '2020-03-20 14:34:55'),
(149, 25, 2, 0, '2020-05-27 14:00:00', 'Streamlined actuating analyzer', 1.00, '2020-03-20 16:34:55', 1, '2020-03-20 14:34:55', '2020-03-20 14:34:55'),
(150, 33, 2, 0, '2020-05-03 16:00:00', 'Seamless content-based localareanetwork', 1.00, '2020-03-20 16:34:55', 0, '2020-03-20 14:34:55', '2020-03-20 14:34:55'),
(151, 25, 2, 0, '2020-05-01 14:00:00', 'Seamless cohesive algorithm', 1.00, '2020-03-20 16:34:55', 0, '2020-03-20 14:34:55', '2020-03-20 14:34:55'),
(152, 75, 2, 0, '2020-05-01 15:00:00', 'Function-based zeroadministration openarchitecture', 1.00, '2020-03-20 16:34:56', 1, '2020-03-20 14:34:56', '2020-03-20 14:34:56'),
(153, 78, 2, 0, '2020-05-01 16:00:00', 'Total tertiary adapter', 1.00, '2020-03-20 16:34:56', 0, '2020-03-20 14:34:56', '2020-03-20 14:34:56'),
(154, 48, 2, 0, '2020-05-08 13:00:00', 'Visionary responsive time-frame', 1.00, '2020-03-20 16:34:56', 0, '2020-03-20 14:34:56', '2020-03-20 14:34:56'),
(155, 81, 2, 1, '2020-05-10 13:00:00', 'Multi-tiered intangible instructionset', 1.00, '2020-03-20 16:34:56', 1, '2020-03-20 14:34:56', '2020-03-20 14:34:56'),
(156, 75, 2, 1, '2020-05-08 14:00:00', 'Quality-focused fault-tolerant flexibility', 1.00, '2020-03-20 16:34:57', 0, '2020-03-20 14:34:57', '2020-03-20 14:34:57'),
(157, 25, 2, 1, '2020-05-08 15:00:00', 'Enhanced intangible opensystem', 1.00, '2020-03-20 16:34:57', 1, '2020-03-20 14:34:57', '2020-03-20 14:34:57'),
(158, 3, 19, 0, '2020-04-12 08:00:00', 'Up-sized hybrid flexibility', 1.00, '2020-03-20 16:34:57', 1, '2020-03-20 14:34:57', '2020-03-20 14:34:57'),
(159, 14, 2, 1, '2020-05-27 15:00:00', 'Reduced 24/7 task-force', 1.00, '2020-03-20 16:34:57', 1, '2020-03-20 14:34:57', '2020-03-20 14:34:57'),
(160, 52, 19, 1, '2020-04-12 09:00:00', 'Operative client-driven structure', 1.00, '2020-03-20 16:34:57', 0, '2020-03-20 14:34:57', '2020-03-20 14:34:57'),
(161, 12, 2, 1, '2020-05-10 14:00:00', 'Fundamental even-keeled service-desk', 1.00, '2020-03-20 16:34:57', 0, '2020-03-20 14:34:57', '2020-03-20 14:34:57'),
(162, 25, 2, 0, '2020-05-08 16:00:00', 'Open-architected modular middleware', 1.00, '2020-03-20 16:34:58', 0, '2020-03-20 14:34:58', '2020-03-20 14:34:58'),
(163, 84, 19, 1, '2020-04-12 10:00:00', 'Function-based methodical complexity', 1.00, '2020-03-20 16:34:58', 1, '2020-03-20 14:34:58', '2020-03-20 14:34:58'),
(164, 6, 2, 0, '2020-05-15 13:00:00', 'Cloned multi-tasking array', 1.00, '2020-03-20 16:34:58', 0, '2020-03-20 14:34:58', '2020-03-20 14:34:58'),
(165, 25, 19, 1, '2020-04-18 18:00:00', 'Multi-channelled contextually-based openarchitecture', 1.00, '2020-03-20 16:34:58', 0, '2020-03-20 14:34:58', '2020-03-20 14:34:58'),
(166, 10, 19, 1, '2020-04-18 19:00:00', 'Future-proofed regional interface', 1.00, '2020-03-20 16:34:59', 0, '2020-03-20 14:34:59', '2020-03-20 14:34:59'),
(167, 25, 19, 1, '2020-04-18 20:00:00', 'Customizable coherent processimprovement', 1.00, '2020-03-20 16:34:59', 0, '2020-03-20 14:34:59', '2020-03-20 14:34:59'),
(168, 37, 19, 0, '2020-04-18 21:00:00', 'Synergized mission-critical pricingstructure', 1.00, '2020-03-20 16:34:59', 0, '2020-03-20 14:34:59', '2020-03-20 14:34:59'),
(169, 81, 2, 1, '2020-05-27 16:00:00', 'Centralized hybrid blockchain', 1.00, '2020-03-20 16:34:59', 1, '2020-03-20 14:34:59', '2020-03-20 14:34:59'),
(170, 74, 2, 1, '2020-05-10 15:00:00', 'Cross-group national firmware', 1.00, '2020-03-20 16:34:59', 1, '2020-03-20 14:34:59', '2020-03-20 14:34:59'),
(171, 23, 19, 0, '2020-04-18 22:00:00', 'Universal impactful intranet', 1.00, '2020-03-20 16:35:00', 0, '2020-03-20 14:35:00', '2020-03-20 14:35:00'),
(172, 33, 19, 1, '2020-04-18 23:00:00', 'Total dedicated methodology', 1.00, '2020-03-20 16:35:00', 1, '2020-03-20 14:35:00', '2020-03-20 14:35:00'),
(173, 12, 19, 1, '2020-04-19 00:00:00', 'De-engineered client-server parallelism', 1.00, '2020-03-20 16:35:00', 1, '2020-03-20 14:35:00', '2020-03-20 14:35:00'),
(174, 49, 2, 0, '2020-05-15 14:00:00', 'Decentralized impactful customerloyalty', 1.00, '2020-03-20 16:35:00', 1, '2020-03-20 14:35:00', '2020-03-20 14:35:00'),
(175, 78, 2, 0, '2020-06-03 14:00:00', 'Innovative hybrid moratorium', 1.00, '2020-03-20 16:35:01', 0, '2020-03-20 14:35:01', '2020-03-20 14:35:01'),
(176, 76, 19, 1, '2020-04-19 01:00:00', 'Team-oriented systemic service-desk', 1.00, '2020-03-20 16:35:01', 0, '2020-03-20 14:35:01', '2020-03-20 14:35:01'),
(177, 84, 2, 1, '2020-05-15 15:00:00', 'Re-engineered mission-critical architecture', 1.00, '2020-03-20 16:35:01', 1, '2020-03-20 14:35:01', '2020-03-20 14:35:01'),
(178, 76, 19, 1, '2020-04-19 02:00:00', 'Grass-roots motivating database', 1.00, '2020-03-20 16:35:01', 1, '2020-03-20 14:35:01', '2020-03-20 14:35:01'),
(179, 68, 19, 0, '2020-04-19 03:00:00', 'Operative client-driven matrices', 1.00, '2020-03-20 16:35:02', 0, '2020-03-20 14:35:02', '2020-03-20 14:35:02'),
(180, 48, 19, 0, '2020-04-19 04:00:00', 'Horizontal hybrid hardware', 1.00, '2020-03-20 16:35:02', 0, '2020-03-20 14:35:02', '2020-03-20 14:35:02'),
(181, 52, 2, 1, '2020-05-15 16:00:00', 'Total bi-directional processimprovement', 1.00, '2020-03-20 16:35:02', 1, '2020-03-20 14:35:02', '2020-03-20 14:35:02'),
(182, 74, 19, 1, '2020-04-19 05:00:00', 'Compatible 24hour matrix', 1.00, '2020-03-20 16:35:02', 0, '2020-03-20 14:35:02', '2020-03-20 14:35:02'),
(183, 23, 19, 1, '2020-04-19 06:00:00', 'Secured composite superstructure', 1.00, '2020-03-20 16:35:02', 1, '2020-03-20 14:35:02', '2020-03-20 14:35:02'),
(184, 68, 19, 1, '2020-04-19 07:00:00', 'Enterprise-wide contextually-based capacity', 1.00, '2020-03-20 16:35:02', 1, '2020-03-20 14:35:02', '2020-03-20 14:35:02'),
(185, 23, 19, 0, '2020-04-19 08:00:00', 'Object-based nextgeneration function', 1.00, '2020-03-20 16:35:03', 0, '2020-03-20 14:35:03', '2020-03-20 14:35:03'),
(186, 25, 19, 1, '2020-04-19 09:00:00', 'Future-proofed 24/7 adapter', 1.00, '2020-03-20 16:35:03', 0, '2020-03-20 14:35:03', '2020-03-20 14:35:03'),
(187, 14, 19, 1, '2020-04-19 10:00:00', 'Self-enabling mission-critical focusgroup', 1.00, '2020-03-20 16:35:03', 0, '2020-03-20 14:35:03', '2020-03-20 14:35:03'),
(188, 5, 2, 0, '2020-05-22 13:00:00', 'Streamlined web-enabled migration', 1.00, '2020-03-20 16:35:03', 0, '2020-03-20 14:35:03', '2020-03-20 14:35:03'),
(189, 4, 19, 0, '2020-04-25 18:00:00', 'Distributed regional access', 1.00, '2020-03-20 16:35:04', 1, '2020-03-20 14:35:04', '2020-03-20 14:35:04'),
(190, 67, 2, 0, '2020-06-03 15:00:00', 'Ameliorated executive info-mediaries', 1.00, '2020-03-20 16:35:04', 0, '2020-03-20 14:35:04', '2020-03-20 14:35:04'),
(191, 84, 19, 0, '2020-04-25 19:00:00', 'Networked explicit capacity', 1.00, '2020-03-20 16:35:04', 1, '2020-03-20 14:35:04', '2020-03-20 14:35:04'),
(192, 48, 2, 0, '2020-06-03 16:00:00', 'Total fresh-thinking conglomeration', 1.00, '2020-03-20 16:35:04', 0, '2020-03-20 14:35:04', '2020-03-20 14:35:04'),
(193, 71, 19, 1, '2020-04-25 20:00:00', 'Phased motivating core', 1.00, '2020-03-20 16:35:04', 1, '2020-03-20 14:35:04', '2020-03-20 14:35:04'),
(194, 25, 2, 1, '2020-05-22 14:00:00', 'Polarised assymetric concept', 1.00, '2020-03-20 16:35:04', 1, '2020-03-20 14:35:04', '2020-03-20 14:35:04'),
(195, 84, 19, 1, '2020-04-25 21:00:00', 'Secured executive neural-net', 1.00, '2020-03-20 16:35:04', 1, '2020-03-20 14:35:04', '2020-03-20 14:35:04'),
(196, 58, 19, 0, '2020-04-25 22:00:00', 'Future-proofed didactic concept', 1.00, '2020-03-20 16:35:05', 0, '2020-03-20 14:35:05', '2020-03-20 14:35:05'),
(197, 37, 19, 1, '2020-04-25 23:00:00', 'Quality-focused even-keeled software', 1.00, '2020-03-20 16:35:05', 1, '2020-03-20 14:35:05', '2020-03-20 14:35:05'),
(198, 33, 2, 0, '2020-05-10 16:00:00', 'Profound discrete GraphicalUserInterface', 1.00, '2020-03-20 16:35:05', 0, '2020-03-20 14:35:05', '2020-03-20 14:35:05'),
(199, 42, 2, 1, '2020-05-17 13:00:00', 'Open-source content-based GraphicInterface', 1.00, '2020-03-20 16:35:05', 1, '2020-03-20 14:35:05', '2020-03-20 14:35:05'),
(200, 74, 2, 0, '2020-05-17 14:00:00', 'Right-sized tangible artificialintelligence', 1.00, '2020-03-20 16:35:06', 0, '2020-03-20 14:35:06', '2020-03-20 14:35:06');
-- --------------------------------------------------------
--
-- Table structure for table `cities`
--
CREATE TABLE `cities` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
`delivery_fees` double(8,2) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `cities`
--
INSERT INTO `cities` (`id`, `name`, `delivery_fees`, `created_at`, `updated_at`) VALUES
(1, 'Mansoura', 10.00, NULL, NULL),
(2, 'Cairo', 10.00, NULL, NULL),
(3, 'Alexandria', 10.00, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `days`
--
CREATE TABLE `days` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `days`
--
INSERT INTO `days` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Saturday', NULL, NULL),
(2, 'Sunday', NULL, NULL),
(3, 'Monday', NULL, NULL),
(4, 'Tuesday', NULL, NULL),
(5, 'Wednesday', NULL, NULL),
(6, 'Thursday', NULL, NULL),
(7, 'Friday', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `degrees`
--
CREATE TABLE `degrees` (
`id` int(10) UNSIGNED NOT NULL,
`doctor_id` int(10) UNSIGNED NOT NULL,
`degree` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `doctors`
--
CREATE TABLE `doctors` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`qualifications` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`speciality_id` int(10) UNSIGNED DEFAULT NULL,
`address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`offers_callup` tinyint(1) DEFAULT NULL,
`fees` double(8,2) DEFAULT NULL,
`callup_fees` double(8,2) DEFAULT NULL,
`benefit` decimal(8,2) DEFAULT NULL,
`cu_benefit` tinyint(1) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `doctors`
--
INSERT INTO `doctors` (`id`, `user_id`, `qualifications`, `speciality_id`, `address`, `offers_callup`, `fees`, `callup_fees`, `benefit`, `cu_benefit`, `created_at`, `updated_at`) VALUES
(1, 2, 'Exclusive zerodefect application', 1, '40931 Nicola Fort\nEast Geovanyborough, WI 32353-1389', 1, 455.00, 172.00, '0.23', 0, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(2, 19, 'Multi-lateral encompassing data-warehouse', 1, '350 Vanessa Crossroad Apt. 042\nKrystalside, MS 16541-1888', 1, 215.00, 203.00, '0.23', 1, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(3, 21, 'Customer-focused directional encoding', 2, '85735 Claudine Corners Apt. 675\nLueilwitzland, WV 64460-0680', 1, 303.00, 279.00, '0.21', 0, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(4, 24, 'Cloned zeroadministration workforce', 2, '362 Heathcote Burg\nEast Rosalynmouth, VT 69163-6735', 0, 221.00, NULL, '0.19', 1, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(5, 30, 'Profit-focused hybrid throughput', 2, '9963 Prohaska Junctions Apt. 892\nSouth Cathrineview, VT 47020-6322', 1, 482.00, 288.00, '0.20', 1, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(6, 32, 'Mandatory holistic blockchain', 2, '5416 Hammes Squares\nAdamsstad, OR 42465', 0, 296.00, NULL, '0.17', 0, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(7, 40, 'Reduced hybrid groupware', 1, '2244 Alanna Flat Suite 455\nNorth Rafaela, KY 24232-1974', 1, 448.00, 282.00, '0.23', 1, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(8, 55, 'Front-line eco-centric definition', 1, '891 Ondricka Hill Suite 975\nJordytown, HI 13462-3108', 0, 203.00, NULL, '0.19', 0, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(9, 57, 'Customizable user-facing ability', 1, '853 Stamm Knolls\nAlexzanderburgh, CO 79145', 0, 349.00, NULL, '0.11', 0, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(10, 59, 'Object-based mobile synergy', 1, '1031 Cummings Avenue Suite 486\nWest Natberg, KY 57177-7575', 0, 381.00, NULL, '0.21', 0, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(11, 61, 'Pre-emptive analyzing algorithm', 2, '58227 Willa Track Suite 534\nLoyalmouth, UT 18524', 1, 384.00, 395.00, '0.16', 1, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(12, 63, 'Pre-emptive coherent toolset', 2, '8923 White Trail\nSouth Trishaton, ME 18267', 1, 465.00, 450.00, '0.13', 1, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(13, 69, 'Visionary attitude-oriented leverage', 1, '33574 O\'Connell Isle\nSouth Demond, MT 51213-0694', 1, 173.00, 108.00, '0.15', 0, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(14, 70, 'Front-line executive support', 1, '95975 Nienow Course\nFriesenshire, OH 39018-0015', 0, 486.00, NULL, '0.20', 1, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(15, 73, 'Cross-group uniform complexity', 1, '35627 Dickens Landing\nO\'Reillystad, NC 01343-8187', 0, 397.00, NULL, '0.18', 0, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(16, 77, 'Vision-oriented bandwidth-monitored interface', 2, '176 Rhiannon Centers Suite 304\nAntwanburgh, TN 59854', 0, 220.00, NULL, '0.11', 1, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(17, 80, 'Intuitive contextually-based portal', 1, '411 Rutherford Divide Suite 413\nMarinabury, NH 62070-4325', 1, 272.00, 139.00, '0.12', 1, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(18, 83, 'Triple-buffered object-oriented portal', 2, '4882 Vicky Ridge Apt. 805\nRosemariemouth, IN 68620-5195', 1, 341.00, 223.00, '0.21', 0, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(19, 87, 'Organic system-worthy emulation', 1, '9745 Solon Extension Apt. 520\nWest Felicita, UT 34339', 1, 138.00, 323.00, '0.11', 1, '2020-03-18 08:39:36', '2020-03-18 08:39:36');
-- --------------------------------------------------------
--
-- Table structure for table `doctor_prescriptions`
--
CREATE TABLE `doctor_prescriptions` (
`id` int(10) UNSIGNED NOT NULL,
`appointment_id` int(10) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `doctor_ratings`
--
CREATE TABLE `doctor_ratings` (
`id` int(10) UNSIGNED NOT NULL,
`appointment_id` int(10) UNSIGNED NOT NULL,
`review` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`behavior` int(10) UNSIGNED NOT NULL,
`price` int(10) UNSIGNED NOT NULL,
`efficiency` int(10) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `doctor_ratings`
--
INSERT INTO `doctor_ratings` (`id`, `appointment_id`, `review`, `behavior`, `price`, `efficiency`, `created_at`, `updated_at`) VALUES
(1, 42, 'Yet you finished the first witness,\' said the Hatter. Alice felt dreadfully puzzled. The Hatter\'s.', 2, 1, 3, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(2, 59, 'Beautiful, beauti--FUL SOUP!\' \'Chorus again!\' cried the Mouse, who was passing at the flowers and.', 5, 2, 1, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(3, 63, 'Caterpillar. Alice said to Alice, that she was ever to get an opportunity of showing off her.', 3, 3, 2, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(4, 67, 'Alice. One of the shepherd boy--and the sneeze of the tea--\' \'The twinkling of the trial.\' \'Stupid.', 1, 1, 4, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(5, 10, 'I WAS when I grow up, I\'ll write one--but I\'m grown up now,\' she added in a long, low hall, which.', 2, 1, 1, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(6, 100, 'Gryphon. \'I\'ve forgotten the Duchess asked, with another hedgehog, which seemed to have changed.', 4, 5, 2, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(7, 20, 'Alice dodged behind a great crowd assembled about them--all sorts of little animals and birds.', 5, 1, 1, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(8, 21, 'She was a little shriek and a large mushroom growing near her, she began, rather timidly, saying.', 2, 2, 2, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(9, 88, 'Dormouse into the garden door. Poor Alice! It was the Hatter. He came in sight of the evening.', 2, 1, 3, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(10, 85, 'Would not, could not, would not, could not, would not, could not, would not, could not, would not.', 5, 1, 5, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(11, 1, 'Alice remained looking thoughtfully at the top of it. Presently the Rabbit just under the window.', 5, 1, 5, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(12, 50, 'Cat. \'I said pig,\' replied Alice; \'and I wish you wouldn\'t mind,\' said Alice: \'besides, that\'s not.', 1, 4, 1, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(13, 72, 'I had our Dinah here, I know I do!\' said Alice to herself, \'the way all the right house, because.', 1, 4, 4, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(14, 77, 'Caterpillar seemed to quiver all over their shoulders, that all the things I used to know. Let me.', 5, 4, 2, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(15, 30, 'White Rabbit; \'in fact, there\'s nothing written on the ground as she wandered about in the flurry.', 1, 1, 5, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(16, 66, 'Hatter, \'or you\'ll be asleep again before it\'s done.\' \'Once upon a little shriek and a crash of.', 2, 5, 4, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(17, 78, 'Alice started to her head, and she hurried out of the trees had a little snappishly. \'You\'re.', 5, 4, 4, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(18, 22, 'Elsie, Lacie, and Tillie; and they can\'t prove I did: there\'s no meaning in it,\' said the.', 4, 1, 4, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(19, 70, 'I can\'t put it into one of the month, and doesn\'t tell what o\'clock it is!\' As she said to one of.', 4, 2, 3, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(20, 71, 'Stop this moment, I tell you, you coward!\' and at last the Caterpillar decidedly, and there was.', 3, 4, 4, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(21, 89, 'And the Gryphon said, in a fight with another hedgehog, which seemed to have finished,\' said the.', 4, 4, 4, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(22, 53, 'Alice; \'you needn\'t be so proud as all that.\' \'With extras?\' asked the Gryphon, and the other.', 1, 4, 2, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(23, 54, 'The King laid his hand upon her face. \'Wake up, Dormouse!\' And they pinched it on both sides of.', 1, 3, 4, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(24, 97, 'And she thought at first she thought it must be shutting up like telescopes: this time it all is!.', 5, 5, 4, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(25, 95, 'D,\' she added in an angry voice--the Rabbit\'s--\'Pat! Pat! Where are you?\' And then a great.', 3, 3, 2, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(26, 25, 'I could show you our cat Dinah: I think you\'d take a fancy to herself as she went nearer to make.', 5, 2, 3, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(27, 36, 'He looked at it again: but he now hastily began again, using the ink, that was linked into hers.', 5, 5, 1, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(28, 75, 'Gryphon in an agony of terror. \'Oh, there goes his PRECIOUS nose\'; as an unusually large saucepan.', 1, 1, 4, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(29, 98, 'Alice could not make out that she was saying, and the procession moved on, three of the way out of.', 3, 5, 5, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(30, 60, 'I say--that\'s the same when I got up very sulkily and crossed over to the Knave of Hearts, who.', 3, 4, 1, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(31, 87, 'ALICE\'S RIGHT FOOT, ESQ. HEARTHRUG, NEAR THE FENDER, (WITH ALICE\'S LOVE). Oh dear, what nonsense.', 2, 3, 2, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(32, 96, 'Alice had not attended to this mouse? Everything is so out-of-the-way down here, and I\'m sure _I_.', 2, 1, 2, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(33, 7, 'When the procession moved on, three of the trial.\' \'Stupid things!\' Alice began telling them her.', 2, 4, 2, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(34, 15, 'What happened to you? Tell us all about it!\' and he poured a little while, however, she again.', 2, 3, 4, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(35, 6, 'Alice. \'What sort of people live about here?\' \'In THAT direction,\' the Cat said, waving its tail.', 1, 3, 2, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(36, 8, 'The first witness was the cat.) \'I hope they\'ll remember her saucer of milk at tea-time. Dinah my.', 1, 3, 3, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(37, 44, 'Alice. \'Oh, don\'t bother ME,\' said Alice indignantly, and she dropped it hastily, just in time to.', 3, 3, 2, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(38, 45, 'King was the fan and the three gardeners at it, busily painting them red. Alice thought over all.', 4, 1, 3, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(39, 91, 'English. \'I don\'t see how he can EVEN finish, if he would not allow without knowing how old it.', 1, 3, 4, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(40, 24, 'Mary Ann, and be turned out of the room. The cook threw a frying-pan after her as she leant.', 1, 5, 2, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(41, 93, 'Duchess, as she spoke. \'I must be collected at once without waiting for turns, quarrelling all the.', 5, 4, 2, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(42, 12, 'But there seemed to be a Caucus-race.\' \'What IS a long way. So she began: \'O Mouse, do you know.', 1, 3, 5, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(43, 92, 'Mock Turtle, suddenly dropping his voice; and Alice thought she might find another key on it, and.', 4, 2, 2, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(44, 5, 'Gryphon lifted up both its paws in surprise. \'What! Never heard of such a dreadful time.\' So Alice.', 2, 3, 5, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(45, 73, 'Duchess and the happy summer days. THE.', 5, 1, 4, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(46, 9, 'It\'ll be no chance of getting her hands on her hand, and Alice was beginning to grow here,\' said.', 3, 2, 1, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(47, 82, 'I fell off the subjects on his slate with one eye, How the Owl and the reason is--\' here the.', 1, 4, 5, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(48, 86, 'Dormouse. \'Don\'t talk nonsense,\' said Alice more boldly: \'you know you\'re growing too.\' \'Yes, but.', 2, 1, 3, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(49, 99, 'Alice. \'Now we shall have somebody to talk about wasting IT. It\'s HIM.\' \'I don\'t much care.', 1, 1, 1, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(50, 27, 'I THINK,\' said Alice. \'You did,\' said the Gryphon, and, taking Alice by the Hatter, \'when the.', 1, 4, 5, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(51, 37, 'King eagerly, and he went on growing, and very neatly and simply arranged; the only one who got.', 2, 3, 1, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(52, 74, 'This of course, to begin at HIS time of life. The King\'s argument was, that she began looking at.', 2, 3, 3, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(53, 28, 'THAT\'S a good deal: this fireplace is narrow, to be two people. \'But it\'s no use in waiting by the.', 1, 2, 4, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(54, 26, 'Mock Turtle with a knife, it usually bleeds; and she felt that there was a queer-shaped little.', 1, 5, 4, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(55, 48, 'Alice could not answer without a moment\'s pause. The only things in the world you fly, Like a.', 4, 4, 2, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(56, 13, 'First, she tried the little creature down, and was just in time to be a footman because he was.', 3, 2, 3, '2020-03-18 08:40:05', '2020-03-18 08:40:05'),
(57, 81, 'Alice panted as she leant against a buttercup to rest her chin in salt water. Her first idea was.', 3, 3, 3, '2020-03-18 08:40:05', '2020-03-18 08:40:05');
-- --------------------------------------------------------
--
-- Table structure for table `dosages`
--
CREATE TABLE `dosages` (
`id` int(10) UNSIGNED NOT NULL,
`prescription_id` int(10) UNSIGNED NOT NULL,
`dosage_time` time DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `favourites`
--
CREATE TABLE `favourites` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`product_id` int(10) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `forget_password`
--
CREATE TABLE `forget_password` (
`id` bigint(20) UNSIGNED NOT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`code` int(10) UNSIGNED NOT NULL,
`count` int(10) UNSIGNED NOT NULL DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `genders`
--
CREATE TABLE `genders` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `genders`
--
INSERT INTO `genders` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Male', NULL, NULL),
(2, 'Female', NULL, NULL),
(3, 'Prefer not to say', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `images`
--
CREATE TABLE `images` (
`id` int(10) UNSIGNED NOT NULL,
`path` text COLLATE utf8mb4_unicode_ci NOT NULL,
`extension` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
`image_code` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
`size` int(11) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `keywords`
--
CREATE TABLE `keywords` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `keywords`
--
INSERT INTO `keywords` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Pills', NULL, NULL),
(2, 'Syrup', NULL, NULL),
(3, 'Injection', NULL, NULL),
(4, 'Headache', NULL, NULL),
(5, 'Diabetes', NULL, NULL),
(6, 'Capsules', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `keyword_searches`
--
CREATE TABLE `keyword_searches` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`keyword_id` int(10) UNSIGNED NOT NULL,
`search_query` text COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `localization`
--
CREATE TABLE `localization` (
`id` bigint(20) UNSIGNED NOT NULL,
`app` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`ar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `localization`
--
INSERT INTO `localization` (`id`, `app`, `key`, `en`, `ar`, `created_at`, `updated_at`) VALUES
(1, 'c', 'onboard1_main', 'The Best Doctors', 'افضل الأطباء', NULL, NULL),
(2, 'c', 'onboard1_para', 'Whether it’s booking doctor appointments, ordering medications, scheduling diagnostic tests or having an online consultation with your doctor', 'سواء كان حجز مواعيد الطبيب, أو طلب أدوية, أو جدولة الاختبارات التشخيصية, أو إجراء استشارة عبر الإنترنت مع طبيبك', NULL, NULL),
(3, 'c', 'next', 'Next', 'التالي', NULL, NULL),
(4, 'c', 'skip', 'Skip', 'تخطي', NULL, NULL),
(5, 'c', 'onboard2_main', 'Find your Medicine', 'ابحث عن دوائك', NULL, NULL),
(6, 'c', 'onboard2_para', 'Whether it’s booking doctor appointments, ordering medications, scheduling diagnostic tests or having an online consultation with your doctor', 'سواء كان حجز مواعيد الطبيب, أو طلب أدوية, أو جدولة الاختبارات التشخيصية, أو إجراء استشارة عبر الإنترنت مع طبيبك', NULL, NULL),
(7, 'c', 'onboard3_main', 'All-in-one-App', 'الكل في تطبيق واحد', NULL, NULL),
(8, 'c', 'onboard3_para', 'Whether it’s booking doctor appointments, ordering medications, scheduling diagnostic tests or having an online consultation with your doctor', 'سواء كان حجز مواعيد الطبيب, أو طلب أدوية, أو جدولة الاختبارات التشخيصية, أو إجراء استشارة عبر الإنترنت مع طبيبك', NULL, NULL),
(9, 'c', 'signup', 'Sign Up', 'انشاء حساب', NULL, NULL),
(10, 'c', 'signin', 'Sign In', 'تسجيل دخول', NULL, NULL),
(11, 'c', 'wel', 'Welcome Back!', 'مرحباََ بعودتك', NULL, NULL),
(12, 'c', 'sign_account', 'Sign in to your account', 'سجل الدخول الى حسابك', NULL, NULL),
(13, 'c', 'email_phone', 'Email Address or Phone Number', 'البريد الإلكتروني أو رقم الموبايل', NULL, NULL),
(14, 'c', 'e_email_phone', 'enter your email or phone number', 'ادخل بريدك الإلكتروني أو رقم الموبايل', NULL, NULL),
(15, 'c', 'u_pass', 'Your Password', 'كلمة السر الخاصة بك', NULL, NULL),
(16, 'c', 'e_pass', 'Enter your password', 'ادخل كلمة السر الخاصة بك', NULL, NULL),
(17, 'c', 'f_pass', 'Forgot Password?', 'نسيت كلمة السر', NULL, NULL),
(18, 'c', 'dont_have', 'Don’t have an account?', 'ليس لديك حساب؟', NULL, NULL),
(19, 'c', 'full_name', 'Full Name', 'الإسم بالكامل', NULL, NULL),
(20, 'c', 'u_name', 'Your name', 'إسمك', NULL, NULL),
(21, 'c', 'email', 'Email', 'البريد الإلكتروني', NULL, NULL),
(22, 'c', 'u_email', 'Your email', 'بريدك الإلكتروني', NULL, NULL),
(23, 'c', 'city', 'City', 'المدينة', NULL, NULL),
(24, 'c', 'pass', 'Password', 'كلمة السر', NULL, NULL),
(25, 'c', 'w_pass', 'Write Your password', 'اكتب كلمة السر الخاصة بك', NULL, NULL),
(26, 'c', 'c_pass', 'Confirm Password', 'تأكيد كلمة السر', NULL, NULL),
(27, 'c', 'have_acc', 'Already have an account?', 'لديك حساب بالفعل؟', NULL, NULL),
(28, 'c', 'home', 'Home', 'الرئيسية', NULL, NULL),
(29, '1', 'need_help', 'Do You Need Help?', 'بحاجة الى مساعدة؟', NULL, NULL),
(30, '1', 'find_dm', 'Find your Doctor & Medicine?', 'ابحث عن طبيبك وعلاجك', NULL, NULL),
(31, '1', 'search_dm', 'Search doctor/medication', 'ابحث عن الطبيب/الدواء', NULL, NULL),
(32, '1', 'medicine', 'MEDICATIONS', 'الأدوية', NULL, NULL),
(33, '1', 'doctor', 'DOCTORS', 'الأطباء', NULL, NULL),
(34, '1', 'appointments', 'Appointments', 'المواعيد', NULL, NULL),
(35, '1', 'prescription', 'Prescription', 'الروشتات', NULL, NULL),
(36, '1', 'orders', 'Orders', 'الطلبات', NULL, NULL),
(37, '1', 'notifications', 'Notifications', 'الإشعارات', NULL, NULL),
(38, '1', 'reviews', 'Reviews', 'التعليقات', NULL, NULL),
(39, '1', 'book_now', 'Book now', 'احجز الآن', NULL, NULL),
(40, '1', 'home_visit', 'Home Visit', 'زيارة منزلية', NULL, NULL),
(41, '1', 'booking', 'Booking', 'حجز', NULL, NULL),
(42, '1', 'biography', 'Biography', 'السيرة الشخصية', NULL, NULL),
(43, '1', 'degrees', 'Degrees', 'الدرجات', NULL, NULL),
(44, '1', 'profile', 'Profile', 'الملف الشخصي', NULL, NULL),
(45, '1', 'contact_info', 'Contact info', 'بيانات التواصل', NULL, NULL),
(46, '1', 'doctors', 'Doctors', 'الأطباء', NULL, NULL),
(47, '1', 'search_doctors', 'Search Doctors', 'البحث عن الأطباء', NULL, NULL),
(48, '1', 'book', 'Book', 'احجز', NULL, NULL),
(49, '1', 'medications', 'Medications', 'الأدوية', NULL, NULL),
(50, '1', 'search_medications', 'Search Medications', 'البحث عن الأدوية', NULL, NULL),
(51, '1', 'buy_now', 'Buy now', 'اشتري الآن', NULL, NULL),
(52, '1', 'delivery_cost', 'Delivery Cost', 'تكلفة التوصيل', NULL, NULL),
(53, '1', 'based_address', 'Based on your address', 'بناء على عنوانك', NULL, NULL),
(54, '1', 'change_address', 'Change Address', 'تغيير العنوان', NULL, NULL),
(55, '1', 'pharmacies_list', 'Pharmacies list', 'قائمة الصيدليات', NULL, NULL),
(56, '1', 'order', 'Order', 'طلب', NULL, NULL),
(57, '1', 'add_cart', 'Add to cart', 'اضف إلى العربة', NULL, NULL),
(58, '1', 'reviews', 'Reviews', 'التعليقات', NULL, NULL),
(59, '1', 'le', 'LE', 'ج.م.', NULL, NULL),
(60, '1', 'all', 'All', 'الكل', NULL, NULL),
(61, '1', 'booking', 'Booking', 'الحجز', NULL, NULL),
(62, '1', 'call_up', 'Call up', 'الإستدعاء', NULL, NULL),
(63, '1', 're_exam', 'Re-Examination', 'اعادة الكشف', NULL, NULL),
(64, '1', 'booking', 'Booking', 'الحجز', NULL, NULL),
(65, '1', 'sent_you', 'sent you a', 'ارسل اليك', NULL, NULL),
(66, '1', 'prescription', 'prescription', 'روشتة', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `migrations`
--
CREATE TABLE `migrations` (
`id` int(10) UNSIGNED NOT NULL,
`migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `migrations`
--
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2019_12_08_170030_create_images_table', 1),
(2, '2019_12_08_170204_create_user_roles_table', 1),
(3, '2019_12_08_170234_create_genders_table', 1),
(4, '2019_12_08_170322_create_days_table', 1),
(5, '2019_12_08_170450_create_cities_table', 1),
(6, '2019_12_08_173545_create_keywords_table', 1),
(7, '2019_12_08_173629_create_users_table', 1),
(8, '2019_12_08_174741_create_products_table', 1),
(9, '2019_12_08_175004_create_products_keywords_table', 1),
(10, '2019_12_08_175122_create_pharmacies_table', 1),
(11, '2019_12_08_181644_create_products_pharmacies_table', 1),
(12, '2019_12_08_181854_create_specialities_table', 1),
(13, '2019_12_08_181942_create_doctors_table', 1),
(14, '2019_12_08_182307_create_orders_table', 1),
(15, '2019_12_08_182451_create_order_details_table', 1),
(16, '2019_12_08_182611_create_pharmacy_ratings_table', 1),
(17, '2019_12_08_182704_create_appointments_table', 1),
(18, '2019_12_08_182939_create_timetables_table', 1),
(19, '2019_12_08_183057_create_doctor_ratings_table', 1),
(20, '2019_12_08_183204_create_keyword_searches_table', 1),
(21, '2019_12_08_183301_create_order_trackings_table', 1),
(22, '2019_12_08_183446_create_payment_methods_table', 1),
(23, '2019_12_08_183728_create_doctor_prescriptions_table', 1),
(24, '2019_12_08_184744_create_prescription_details_table', 1),
(25, '2019_12_08_184942_create_requests_table', 1),
(26, '2020_02_19_175336_create_localization_table', 1),
(27, '2020_03_09_135649_prescriptions', 1),
(28, '2020_03_09_143029_dosages', 1),
(29, '2020_03_09_143409_pres_day', 1),
(30, '2020_03_09_144112_favourites', 1),
(31, '2020_03_09_144412_degrees', 1),
(32, '2020_03_13_221739_create_forget_password_table', 1);
-- --------------------------------------------------------
--
-- Table structure for table `orders`
--
CREATE TABLE `orders` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`pharmacy_id` int(10) UNSIGNED NOT NULL,
`discount` double(8,2) NOT NULL DEFAULT 0.00,
`delivery_type` tinyint(1) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `orders`
--
INSERT INTO `orders` (`id`, `user_id`, `pharmacy_id`, `discount`, `delivery_type`, `created_at`, `updated_at`) VALUES
(1, 10, 19, 0.00, 1, '2020-03-19 20:33:55', '2020-03-19 20:33:55'),
(2, 10, 22, 0.00, 1, '2020-03-19 20:38:37', '2020-03-19 20:38:37'),
(3, 10, 22, 0.00, 1, '2020-03-19 20:39:05', '2020-03-19 20:39:05'),
(4, 10, 13, 0.00, 1, '2020-03-19 20:39:05', '2020-03-19 20:39:05'),
(5, 10, 22, 0.00, 1, '2020-03-19 20:40:07', '2020-03-19 20:40:07'),
(6, 10, 7, 0.00, 1, '2020-03-19 20:40:07', '2020-03-19 20:40:07'),
(7, 10, 22, 0.00, 1, '2020-03-19 20:40:38', '2020-03-19 20:40:38'),
(8, 10, 22, 0.00, 1, '2020-03-19 20:40:38', '2020-03-19 20:40:38'),
(9, 10, 7, 0.00, 1, '2020-03-19 20:40:38', '2020-03-19 20:40:38');
-- --------------------------------------------------------
--
-- Table structure for table `order_details`
--
CREATE TABLE `order_details` (
`id` int(10) UNSIGNED NOT NULL,
`order_id` int(10) UNSIGNED NOT NULL,
`product_id` int(10) UNSIGNED NOT NULL,
`amount` int(10) UNSIGNED NOT NULL DEFAULT 1,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `order_details`
--
INSERT INTO `order_details` (`id`, `order_id`, `product_id`, `amount`, `created_at`, `updated_at`) VALUES
(1, 1, 78, 1, '2020-03-19 20:33:56', '2020-03-19 20:33:56'),
(2, 2, 56, 2, '2020-03-19 20:38:37', '2020-03-19 20:38:37'),
(3, 3, 56, 2, '2020-03-19 20:39:05', '2020-03-19 20:39:05'),
(4, 4, 90, 2, '2020-03-19 20:39:05', '2020-03-19 20:39:05'),
(5, 5, 56, 2, '2020-03-19 20:40:07', '2020-03-19 20:40:07'),
(6, 6, 17, 2, '2020-03-19 20:40:07', '2020-03-19 20:40:07'),
(7, 7, 56, 2, '2020-03-19 20:40:38', '2020-03-19 20:40:38'),
(8, 8, 11, 2, '2020-03-19 20:40:38', '2020-03-19 20:40:38'),
(9, 9, 17, 2, '2020-03-19 20:40:38', '2020-03-19 20:40:38');
-- --------------------------------------------------------
--
-- Table structure for table `order_trackings`
--
CREATE TABLE `order_trackings` (
`id` int(10) UNSIGNED NOT NULL,
`order_id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`is_accepted` tinyint(1) NOT NULL,
`accepted_at` datetime NOT NULL,
`is_prepared` tinyint(1) NOT NULL,
`prepared_at` datetime NOT NULL,
`is_ofd` tinyint(1) NOT NULL,
`ofd_at` datetime NOT NULL,
`is_waiting` tinyint(1) NOT NULL,
`waiting_at` datetime NOT NULL,
`is_delivered` tinyint(1) NOT NULL,
`delivered_at` datetime NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `payment_methods`
--
CREATE TABLE `payment_methods` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`card_number` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL,
`cvc` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
`expiry_month` int(10) UNSIGNED NOT NULL,
`expiry_year` int(10) UNSIGNED NOT NULL,
`card_holder_name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `pharmacies`
--
CREATE TABLE `pharmacies` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`benefit_delivery` decimal(8,2) DEFAULT NULL,
`benefit_pharmacy` decimal(8,2) DEFAULT NULL,
`address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `pharmacies`
--
INSERT INTO `pharmacies` (`id`, `user_id`, `benefit_delivery`, `benefit_pharmacy`, `address`, `created_at`, `updated_at`) VALUES
(1, 7, '0.23', '0.17', '854 Armstrong Forge Suite 830\nLake Weldonstad, WI 31967-9760', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(2, 11, '0.22', '0.14', '8194 Damion Points\nPort Danny, OK 25484', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(3, 13, '0.16', '0.22', '8170 Camille Brooks Suite 345\nSouth Jeremychester, AR 04626-7147', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(4, 15, '0.21', '0.10', '6634 Wehner Place Suite 123\nMertzberg, AZ 06214', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(5, 18, '0.20', '0.24', '2713 Schuppe Walks Apt. 811\nGislasonfurt, DE 51303-1446', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(6, 20, '0.19', '0.23', '3382 Kiehn Mount Suite 862\nEast Elianeborough, MI 27581', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(7, 26, '0.24', '0.13', '87033 Dibbert Vista Apt. 077\nPort Ivory, WV 96293-4471', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(8, 27, '0.23', '0.25', '14374 Norbert Turnpike Suite 093\nAmaliaport, WI 94974-6094', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(9, 28, '0.11', '0.14', '5112 Marquardt Courts\nNorth Bobby, MI 76190', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(10, 29, '0.11', '0.14', '990 Ivah Fields Suite 308\nFeilmouth, SC 00213', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(11, 31, '0.15', '0.16', '512 Jacobson Stravenue Apt. 026\nAureliefort, FL 84682-2277', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(12, 35, '0.13', '0.20', '4425 Fredy Village Suite 067\nBergestad, TX 45170', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(13, 38, '0.11', '0.23', '7864 Jerde Summit\nPort Minnie, MN 49433', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(14, 39, '0.12', '0.19', '57447 Stella Plain\nBogisichtown, OH 06970', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(15, 41, '0.24', '0.12', '912 Langosh Springs\nWest Tyrell, MS 49240-6729', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(16, 45, '0.25', '0.15', '95023 Dicki Crossing Apt. 739\nSchimmelhaven, MA 68696', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(17, 46, '0.13', '0.12', '6717 Prohaska Lock\nWest Tillman, IN 38186', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(18, 60, '0.14', '0.25', '91465 Gottlieb Mission Suite 595\nStarkstad, OR 24451', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(19, 62, '0.21', '0.15', '44284 Witting Island\nWest Olabury, OR 17335', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(20, 72, '0.24', '0.20', '33437 Zachariah Spurs\nEast Darrinville, NY 38773', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(21, 82, '0.18', '0.17', '97226 Ansley Spring Suite 149\nSpinkaton, MS 16632', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(22, 86, '0.11', '0.15', '2755 Lilian Fields Apt. 079\nAlisonfort, VA 71077', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(23, 89, '0.16', '0.16', '9366 Jerry Corners\nNorth Brooklyn, DC 51291', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(24, 91, '0.17', '0.18', '3230 Kiel Estate Suite 519\nAllyland, OK 17619', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(25, 92, '0.14', '0.10', '669 Angelita Gardens Apt. 216\nBoscobury, IA 10501-7161', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(26, 95, '0.18', '0.17', '58027 Murray Track Suite 342\nMarinabury, WA 03736-9021', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(27, 97, '0.16', '0.21', '8439 Casandra River\nAnkundingland, IA 73436', '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(28, 99, '0.20', '0.21', '71036 Samir Summit Apt. 606\nNew Golden, AL 96352-6852', '2020-03-18 08:39:36', '2020-03-18 08:39:36');
-- --------------------------------------------------------
--
-- Table structure for table `pharmacy_ratings`
--
CREATE TABLE `pharmacy_ratings` (
`id` int(10) UNSIGNED NOT NULL,
`order_id` int(10) UNSIGNED NOT NULL,
`review` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`rating` int(10) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `prescriptions`
--
CREATE TABLE `prescriptions` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`medicine_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`dosage` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`start_hour` time NOT NULL,
`end_date` date NOT NULL,
`frequency` int(10) UNSIGNED NOT NULL DEFAULT 1,
`closed` tinyint(1) DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `prescription_details`
--
CREATE TABLE `prescription_details` (
`id` int(10) UNSIGNED NOT NULL,
`prescription_id` int(10) UNSIGNED NOT NULL,
`product_id` int(10) UNSIGNED NOT NULL,
`dosage` text COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `pres_day`
--
CREATE TABLE `pres_day` (
`id` int(10) UNSIGNED NOT NULL,
`prescription_id` int(10) UNSIGNED NOT NULL,
`day_id` int(10) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `products`
--
CREATE TABLE `products` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
`price` double(8,2) NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image_id` int(10) UNSIGNED DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `products`
--
INSERT INTO `products` (`id`, `name`, `price`, `description`, `image_id`, `created_at`, `updated_at`) VALUES
(1, 'Fluoposide', 23.02, 'The Cat\'s head with great curiosity, and this time the Mouse was swimming away from him, and said.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(2, 'Cyprolovir', 52.94, 'Our family always HATED cats: nasty, low, vulgar things! Don\'t let him know she liked them best.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(3, 'Tolevice', 124.18, 'And the muscular strength, which it gave to my right size: the next witness.\' And he added in a.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(4, 'Lacmectin', 177.77, 'Mouse, turning to Alice, they all crowded round her once more, while the rest of the Shark, But.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(5, 'Aldurafen', 101.08, 'You\'re a serpent; and there\'s no name signed at the sudden change, but very glad to get rather.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(6, 'Abacazenil', 68.83, 'Hatter: \'I\'m on the other ladder?--Why, I hadn\'t drunk quite so much!\' said Alice, \'how am I to do.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(7, 'Ethosyn', 184.70, 'I will just explain to you to offer it,\' said Alice. \'You are,\' said the March Hare meekly.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(8, 'Argaterol', 164.43, 'Alice in a minute. Alice began to feel a little pattering of feet on the hearth and grinning from.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(9, 'Exugine', 150.95, 'Cheshire Cat, she was beginning to get in?\' \'There might be some sense in your knocking,\' the.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(10, 'Enanavir', 94.30, 'It means much the most curious thing I know. Silence all round, if you wouldn\'t mind,\' said Alice.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(11, 'Prepakine', 131.73, 'I had not attended to this last remark that had fluttered down from the Gryphon, with a deep sigh.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(12, 'Acammulin', 121.40, 'It was the Hatter. \'I deny it!\' said the Dodo said, \'EVERYBODY has won, and all the other arm.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(13, 'Pandeine', 187.67, 'Dodo could not stand, and she was coming to, but it said in a sorrowful tone, \'I\'m afraid I can\'t.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(14, 'Halosyn', 21.08, 'This time there were a Duck and a pair of white kid gloves, and she had never had to leave off.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(15, 'Endomax', 198.93, 'YOU,\"\' said Alice. \'What IS the fun?\' said Alice. \'I\'ve tried every way, and nothing seems to suit.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(16, 'Epinenamic', 81.94, 'Alice\'s elbow was pressed hard against it, that attempt proved a failure. Alice heard the Queen\'s.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(17, 'Haloramine', 147.88, 'She drew her foot as far as they would die. \'The trial cannot proceed,\' said the Hatter, \'I cut.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(18, 'Mycoletine', 166.13, 'Alice herself, and shouted out, \'You\'d better not talk!\' said Five. \'I heard every word you.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(19, 'Nedopogen', 20.75, 'Caterpillar seemed to be a Caucus-race.\' \'What IS the fun?\' said Alice. \'Who\'s making personal.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(20, 'Retamectin', 81.34, 'The three soldiers wandered about in a large ring, with the other ladder?--Why, I hadn\'t to bring.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(21, 'Zygestin', 196.97, 'M, such as mouse-traps, and the three gardeners instantly threw themselves flat upon their faces.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(22, 'Sulfafase', 154.55, 'Dormouse into the garden. Then she went round the hall, but they all quarrel so dreadfully one.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(23, 'Tranracin', 182.67, 'Just then she had plenty of time as she could, for her to speak good English); \'now I\'m opening.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(24, 'Nevaferal', 116.70, 'King say in a hoarse, feeble voice: \'I heard the Rabbit say, \'A barrowful will do, to begin.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(25, 'Acustadil', 94.57, 'It sounded an excellent plan, no doubt, and very angrily. \'A knot!\' said Alice, who was a general.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(26, 'Aldacset', 98.01, 'COULD he turn them out of its mouth and yawned once or twice, half hoping she might as well look.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(27, 'Primabucil', 186.46, 'Footman continued in the direction it pointed to, without trying to make herself useful, and.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(28, 'Atomopenem', 74.27, 'ALL RETURNED FROM HIM TO YOU,\"\' said Alice. \'What IS the use of a good many little girls eat eggs.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(29, 'Accuran', 118.42, 'But do cats eat bats?\' and sometimes, \'Do bats eat cats?\' for, you see, Miss, we\'re doing our.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(30, 'Phoslapril', 100.04, 'The first thing I\'ve got back to the Classics master, though. He was looking up into the court.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(31, 'Metasomax', 177.23, 'Some of the tea--\' \'The twinkling of the what?\' said the King. \'It began with the distant green.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(32, 'Cordathacin', 148.88, 'At last the Gryphon answered, very nearly carried it out to sea. So they couldn\'t see it?\' So she.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(33, 'Nasadazole', 30.25, 'Alice. \'Off with their heads!\' and the arm that was lying under the sea,\' the Gryphon went on.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(34, 'Claripur', 128.63, 'I\'ll be jury,\" Said cunning old Fury: \"I\'ll try the patience of an oyster!\' \'I wish the creatures.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(35, 'Amofranil', 182.17, 'Two!\' said Seven. \'Yes, it IS his business!\' said Five, in a minute, nurse! But I\'ve got to the.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(36, 'Aggradocin', 138.90, 'She stretched herself up and say \"How doth the little golden key and hurried off to the dance. So.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(37, 'Abacabisome', 137.40, 'Oh dear! I\'d nearly forgotten that I\'ve got to the law, And argued each case with my wife; And the.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(38, 'Alisbucil', 35.31, 'I can\'t show it you myself,\' the Mock Turtle. \'Very much indeed,\' said Alice. \'It must be shutting.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(39, 'Ofloderall', 110.44, 'Alice said to the puppy; whereupon the puppy jumped into the garden with one finger, as he spoke.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(40, 'Subnonide', 6.34, 'Gryphon, the squeaking of the court, by the hand, it hurried off, without waiting for the hot day.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(41, 'Atracudiol', 57.87, 'Mock Turtle, \'but if you\'ve seen them at dinn--\' she checked herself hastily. \'I don\'t see how he.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(42, 'Colevate', 81.25, 'PROVES his guilt,\' said the Queen, the royal children, and everybody else. \'Leave off that!\'.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(43, 'Ethamadin', 149.92, 'ARE a simpleton.\' Alice did not dare to disobey, though she looked up, but it makes rather a.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(44, 'Ambebyclor', 142.02, 'Alice: \'allow me to sell you a couple?\' \'You are old, Father William,\' the young Crab, a little.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(45, 'Bacteridarone', 66.24, 'Mouse was speaking, and this Alice thought this a good character, But said I could shut up like a.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(46, 'Neuroline', 147.38, 'Hatter: \'as the things get used to read fairy-tales, I fancied that kind of authority among them.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(47, 'Lubinex', 68.50, 'Dormouse shook itself, and began by producing from under his arm a great hurry. \'You did!\' said.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(48, 'Albendanazole', 92.33, 'I chose,\' the Duchess was VERY ugly; and secondly, because they\'re making such a very curious to.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(49, 'Traclinum', 69.61, 'I should frighten them out of sight: then it chuckled. \'What fun!\' said the Mouse. \'Of course,\'.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(50, 'Galandocet', 162.09, 'She was a very curious to see some meaning in it.\' The jury all looked so good, that it might end.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(51, 'Betasol', 86.35, 'I shan\'t! YOU do it!--That I won\'t, then!--Bill\'s to go nearer till she had someone to listen to.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),
(52, 'Galanletine', 188.01, 'I\'m never sure what I\'m going to leave it behind?\' She said the young man said, \'And your hair has.', NULL, '2020-03-18 08:39:36', '2020-03-18 08:39:36'),