-
Notifications
You must be signed in to change notification settings - Fork 2
/
database.sql
599 lines (532 loc) · 140 KB
/
database.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
-- MySQL dump 10.13 Distrib 8.0.23, for Linux (x86_64)
--
-- Host: localhost Database: khidmatDB
-- ------------------------------------------------------
-- Server version 8.0.23-0ubuntu0.20.04.1
/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `Contains`
--
DROP TABLE IF EXISTS `Contains`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Contains` (
`foodID` varchar(8) NOT NULL,
`orderID` varchar(8) NOT NULL,
`quantity` int NOT NULL,
PRIMARY KEY (`foodID`,`orderID`),
KEY `foodID` (`foodID`),
KEY `orderID` (`orderID`),
CONSTRAINT `Contains_ibfk_1` FOREIGN KEY (`foodID`) REFERENCES `Food` (`itemID`),
CONSTRAINT `Contains_ibfk_2` FOREIGN KEY (`orderID`) REFERENCES `Orders` (`orderID`),
CONSTRAINT `Contains_chk_1` CHECK ((`quantity` > 0))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Contains`
--
LOCK TABLES `Contains` WRITE;
/*!40000 ALTER TABLE `Contains` DISABLE KEYS */;
INSERT INTO `Contains` VALUES ('F007801','O1201',1),('F007801','O1202',2),('F007802','O1203',3),('F007803','O1204',4),('F007804','O1205',1),('F007805','O1206',1),('F007806','O1207',2),('F007807','O1208',4),('F007808','O1209',1),('F007809','O1210',2),('F007810','O1211',3),('F007811','O1212',3),('F007812','O1213',1),('F007813','O1214',3),('F007814','O1215',4),('F007815','O1216',5),('F007816','O1217',1),('F007817','O1218',2),('F007818','O1219',3),('F007819','O1220',5),('F007820','O1221',2),('F007821','O1222',1),('F007822','O1223',3),('F007823','O1224',4),('F007824','O1225',1),('F007825','O1226',2),('F007826','O1227',4),('F007827','O1228',2),('F007828','O1229',1),('F007829','O1230',4),('F007830','O1231',1),('F007831','O1232',4),('F007832','O1233',3),('F007833','O1234',2),('F007834','O1235',4),('F007835','O1236',5),('F007836','O1237',2),('F007837','O1238',1),('F007838','O1239',2),('F007839','O1240',4),('F007840','O1241',2),('F007841','O1242',4),('F007842','O1243',5),('F007843','O1244',2),('F007844','O1245',4),('F007845','O1246',1),('F007846','O1247',4),('F007847','O1248',2),('F007848','O1249',4),('F007849','O1250',2),('F007850','O1251',2),('F007851','O1252',5),('F007852','O1253',3),('F007853','O1254',2),('F007854','O1255',2),('F007855','O1256',4),('F007856','O1257',1),('F007857','O1258',4),('F007858','O1259',5),('F007859','O1260',5),('F007860','O1261',3),('F007861','O1262',2),('F007862','O1263',1),('F007863','O1264',3),('F007864','O1265',5),('F007865','O1266',3),('F007866','O1267',5),('F007867','O1268',3),('F007868','O1269',4),('F007869','O1270',5),('F007870','O1271',3),('F007871','O1272',3),('F007872','O1273',5),('F007873','O1274',3),('F007874','O1275',5),('F007875','O1276',2),('F007876','O1277',5),('F007877','O1278',2),('F007878','O1279',1),('F007879','O1280',4),('F007880','O1281',3),('F007881','O1282',2),('F007882','O1283',4),('F007883','O1284',4),('F007884','O1285',5),('F007885','O1286',1),('F007886','O1287',5),('F007887','O1288',5),('F007888','O1289',5),('F007889','O1290',2),('F007890','O1291',2),('F007891','O1292',1),('F007892','O1293',2),('F007893','O1294',4),('F007894','O1295',2),('F007895','O1296',2),('F007896','O1297',3),('F007897','O1298',3),('F007898','O1299',4),('F007899','O1300',1),('F007900','O1301',1),('F007902','O1303',4),('F007903','O1304',5),('F007904','O1305',4),('F007905','O1306',2),('F007906','O1307',3),('F007907','O1308',4),('F007908','O1309',1),('F007909','O1310',3),('F007910','O1311',4),('F007911','O1312',2),('F007912','O1313',4),('F007913','O1314',4),('F007914','O1315',5),('F007915','O1316',2),('F007916','O1317',2),('F007917','O1318',4),('F007918','O1319',4),('F007919','O1320',5),('F007920','O1321',1),('F007921','O1322',2),('F007922','O1323',3),('F007923','O1324',3),('F007924','O1325',4),('F007925','O1326',5),('F007926','O1327',1),('F007927','O1328',1),('F007928','O1329',2),('F007929','O1330',4),('F007930','O1331',5),('F007931','O1332',5),('F007932','O1332',5),('F007933','O1334',3),('F007934','O1335',2),('F007935','O1336',1),('F007936','O1337',3),('F007937','O1338',4),('F007938','O1339',2),('F007939','O1340',1),('F007940','O1341',3),('F007941','O1342',5),('F007942','O1343',2),('F007943','O1344',1),('F007944','O1345',3),('F007945','O1346',4),('F007946','O1347',5),('F007947','O1348',2),('F007948','O1349',1),('F007949','O1350',2),('F007950','O1201',4),('F007951','O1202',5),('F007952','O1203',2),('F007953','O1204',2),('F007954','O1205',4),('F007955','O1206',1),('F007956','O1207',2),('F007957','O1208',4),('F007958','O1209',5),('F007959','O1210',2),('F007960','O1211',1),('F007961','O1212',3),('F007962','O1213',4),('F007963','O1214',4),('F007964','O1215',1),('F007965','O1216',2),('F007966','O1217',3),('F007967','O1218',4),('F007968','O1219',5),('F007969','O1220',4),('F007970','O1221',4),('F007971','O1222',3),('F007972','O1223',3),('F007973','O1224',5),('F007974','O1225',3),('F007975','O1226',3),('F007976','O1227',5),('F007977','O1228',5),('F007978','O1229',4),('F007979','O1230',3),('F007980','O1231',3),('F007981','O1232',3),('F007982','O1233',4),('F007983','O1234',4),('F007984','O1235',5),('F007985','O1236',5),('F007986','O1237',3),('F007987','O1238',3),('F007988','O1239',3),('F007989','O1240',4),('F007990','O1241',5),('F007991','O1242',5),('F007992','O1243',4),('F007993','O1244',3),('F007994','O1245',3),('F007995','O1246',3),('F007996','O1247',3),('F007998','O1249',3),('F007999','O1250',3),('F008000','O1251',4),('F008001','O1252',4),('F008002','O1253',4),('F008003','O1254',3),('F008004','O1255',2),('F008005','O1256',4),('F008006','O1257',4),('F008007','O1258',3),('F008008','O1259',3),('F008009','O1260',3),('F008010','O1261',3),('F008011','O1262',3),('F008012','O1263',2),('F008013','O1264',2),('F008014','O1265',4),('F008015','O1266',5),('F008016','O1267',5),('F008017','O1268',5),('F008018','O1269',5),('F008019','O1270',3),('F008020','O1271',5),('F008021','O1272',5),('F008022','O1273',5),('F008023','O1274',5),('F008024','O1201',5),('F008025','O1202',3),('F008026','O1203',3),('F008027','O1204',3),('F008028','O1205',2),('F008029','O1206',2),('F008030','O1207',2),('F008031','O1208',4),('F008032','O1209',4),('F008033','O1210',2),('F008034','O1211',2),('F008036','O1213',5),('F008037','O1214',3),('F008038','O1215',2),('F008039','O1216',2),('F008040','O1217',4),('F008041','O1218',2),('F008042','O1219',2),('F008043','O1220',4),('F008044','O1221',2),('F008045','O1222',2),('F008046','O1223',4),('F008047','O1224',5),('F008048','O1225',3),('F008049','O1226',2),('F008050','O1227',1),('F008051','O1228',1),('F008052','O1229',3),('F008053','O1230',4),('F008054','O1231',4),('F008055','O1232',4),('F008056','O1233',4),('F008057','O1234',2),('F008058','O1235',2),('F008059','O1236',1),('F008060','O1237',3),('F008061','O1238',3),('F008062','O1239',3),('F008063','O1240',2),('F008064','O1201',4),('F008065','O1202',2),('F008066','O1203',3),('F008067','O1204',3),('F008068','O1205',3),('F008069','O1206',1),('F008070','O1207',2),('F008071','O1208',3),('F008072','O1209',4),('F008073','O1210',2),('F008074','O1211',2),('F008075','O1212',4),('F008076','O1213',2),('F008077','O1214',2),('F008078','O1215',4),('F008079','O1216',2),('F008080','O1217',1),('F008081','O1218',2),('F008082','O1219',3),('F008083','O1220',5),('F008084','O1201',5),('F008085','O1202',2),('F008086','O1203',3),('F008087','O1204',3),('F008088','O1205',2),('F008089','O1203',3),('F008089','O1206',2),('F008090','O1201',1),('F008090','O1207',5),('F008091','O1202',1),('F008091','O1208',2),('F008092','O1201',1),('F008092','O1209',1),('F008093','O1210',1),('F008094','O1201',1),('F008095','O1202',2),('F008096','O1203',1),('F008097','O1204',1),('F008098','O1205',2),('F008099','O1201',3),('F008100','O1202',1),('F008101','O1203',2),('F008102','O1201',1),('F008103','O1202',1),('F008104','O1201',2),('F008105','O1202',1);
/*!40000 ALTER TABLE `Contains` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Customer`
--
DROP TABLE IF EXISTS `Customer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Customer` (
`phone` char(10) NOT NULL,
`fName` varchar(20) NOT NULL,
`lName` varchar(20) NOT NULL,
`hNo` varchar(6) NOT NULL,
`street` varchar(20) DEFAULT NULL,
`area` varchar(20) NOT NULL,
`city` varchar(20) NOT NULL,
`state` varchar(20) NOT NULL,
`pin` char(6) NOT NULL,
`email` varchar(50) NOT NULL,
`customerType` varchar(20) NOT NULL,
`dob` date DEFAULT NULL,
PRIMARY KEY (`phone`),
UNIQUE KEY `email` (`email`),
UNIQUE KEY `phone` (`phone`),
KEY `nearby_cust` (`area`),
CONSTRAINT `typeContraint` CHECK (((`customerType` = _utf8mb4'normal') or (`customerType` = _utf8mb4'premium')))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Customer`
--
LOCK TABLES `Customer` WRITE;
/*!40000 ALTER TABLE `Customer` DISABLE KEYS */;
INSERT INTO `Customer` VALUES ('8214556085','Jaibir','Dhillon','110078','10','Umred','New Delhi','Delhi','287957','[email protected]','normal','2002-03-27'),('8216384380','Tilakraj','Mann','110060','23','Ahmedabad','New Delhi','Delhi','136733','[email protected]','normal','1992-04-20'),('8223676845','Hardeep','Gupta','110097','5','City of Thane','New Delhi','Delhi','257238','[email protected]','normal','1999-10-16'),('8225465344','Bhupender','Chanda','110091','10','Narsipatnam','New Delhi','Delhi','195291','[email protected]','premium','1998-10-10'),('8235187078','Madhvi','Ghose','110037','13','Benipur','New Delhi','Delhi','189758','[email protected]','premium','1991-12-25'),('8238779654','Hardev','Deep','110009','12','Vasai','New Delhi','Delhi','284124','[email protected]','normal','2002-12-23'),('8239969188','Ganga','Dev','110024','5','Kavi Nagar','New Delhi','Delhi','177485','[email protected]','normal','1999-02-16'),('8244582810','Gandharv','Dasgupta','110048','13','Ratanada','New Delhi','Delhi','309539','[email protected]','premium','1998-03-19'),('8248731914','Bhudhi','Agarwal','110043','23','Mangalagiri','New Delhi','Delhi','209684','[email protected]','normal','1996-10-12'),('8249723570','Shilap','Mammen','110002','6','Madhavaram','New Delhi','Delhi','165335','[email protected]','premium','1990-10-14'),('8250461307','Bhushan','Agarwal','110074','5','Bally','New Delhi','Delhi','114073','[email protected]','premium','1997-01-06'),('8250784389','Pawna','Lad','110031','13','Raipur','New Delhi','Delhi','279273','[email protected]','normal','1993-05-08'),('8251714345','Bhudevi','Kumari','110001','13','Pandu Nagar','New Delhi','Delhi','237958','[email protected]','normal','1993-12-10'),('8252269402','Gambhir','Gupta','110052','17','City of Thane','New Delhi','Delhi','164121','[email protected]','normal','1991-05-20'),('8253117778','Shilpa','Sharma','110035','29','Vasai','New Delhi','Delhi','185604','[email protected]','normal','1993-02-09'),('8253226127','Kartar','Dugar','110058','24','Kalmeshwar','New Delhi','Delhi','394196','[email protected]','normal','1995-08-16'),('8254877528','Ishatkar','Dey','110067','9','Peelamedu','New Delhi','Delhi','145893','[email protected]','normal','1994-02-11'),('8259413178','Chitra','Magar','110022','21','Rajgarh','New Delhi','Delhi','107353','[email protected]','normal','1998-12-05'),('8260444682','Mohit','Kumar','110010','7','Ameerpet','New Delhi','Delhi','267762','[email protected]','normal','2000-08-19'),('8262465711','Chitrangan','Chokshi','110088','12','Gomti Nagar','New Delhi','Delhi','354368','[email protected]','premium','1993-03-08'),('8271602066','Payal','Ghosh','110033','6','Ellis Nagar','New Delhi','Delhi','269200','[email protected]','normal','1991-10-03'),('8273283350','Abhinay','Divan','110005','7','Rajgarh','New Delhi','Delhi','347999','[email protected]','normal','2001-10-15'),('8281719051','Gangadhar','Kapur','110068','13','Alandur','New Delhi','Delhi','165867','[email protected]','normal','1998-07-06'),('8311746817','Daljit','Choudhary','110085','18','Saket','New Delhi','Delhi','114389','[email protected]','normal','2002-05-27'),('8319749948','Mayur','Krishnamurthy','110046','21','Aamby Valley City','New Delhi','Delhi','131347','[email protected]','premium','1994-04-19'),('8319816209','Madhuri','Garg','110015','22','Volad','New Delhi','Delhi','118434','[email protected]','normal','1991-11-04'),('8326911298','Bijander','Choudhary','110078','12','Ellis Nagar','New Delhi','Delhi','106536','[email protected]','normal','1991-07-15'),('8328228156','Abhiraj','Singh','110045','6','City Centre','New Delhi','Delhi','312607','[email protected]','premium','1994-08-18'),('8332685102','Dalip','Choudhary','110008','28','Juhu','New Delhi','Delhi','299652','[email protected]','normal','1993-03-14'),('8334742120','Vijeta','Jain','110090','18','Howrah Uttar','New Delhi','Delhi','172376','[email protected]','premium','1999-12-08'),('8340727094','Gango','Dayal','110061','18','Gondal','New Delhi','Delhi','379866','[email protected]','premium','1996-06-25'),('8343873800','Ishawar','Dhaliwal','110049','10','Raisen','New Delhi','Delhi','144433','[email protected]','normal','2000-07-26'),('8345297210','Omwati','Kuruvilla','110079','18','City Centre','New Delhi','Delhi','325627','[email protected]','normal','2002-10-17'),('8349334205','Bhudhashen','Gujjar','110070','25','Indira Park','New Delhi','Delhi','274787','[email protected]','normal','2002-10-01'),('8357223451','Jayoti','Divan','110008','20','North Solapur','New Delhi','Delhi','103737','[email protected]','normal','1996-08-11'),('8360232680','Jiya','Dube','110004','25','Chandigarh','New Delhi','Delhi','228630','[email protected]','normal','1991-10-19'),('8364432786','Madhusudan','Gera','110028','11','Kolar','New Delhi','Delhi','152260','[email protected]','premium','1999-08-24'),('8365436688','Ishika','Dhar','110069','16','Chinchwad','New Delhi','Delhi','168136','[email protected]','premium','2002-09-26'),('8370636734','Vijendra','Bose','110037','18','Umred','New Delhi','Delhi','305862','[email protected]','normal','1995-12-20'),('8381574609','Seva','Mall','110015','10','Raipur','New Delhi','Delhi','287022','[email protected]','premium','1991-09-10'),('8381749123','Bhusan','Chandran','110026','4','Peelamedu','New Delhi','Delhi','206925','[email protected]','normal','1992-06-13'),('8389985485','Sevak','Mallick','110039','4','Shimoga','New Delhi','Delhi','180052','[email protected]','normal','1990-12-01'),('8391839493','Jitender','Dixit','110017','2','Vigyan Nagar','New Delhi','Delhi','332923','[email protected]','premium','1993-12-15'),('8711538567','Abhishekh','Dora','110018','15','Sewlakhas Nagar','New Delhi','Delhi','364640','[email protected]','premium','1993-03-09'),('8715761412','Lokindra','Jaiswal','110086','30','Mangalagiri','New Delhi','Delhi','143607','[email protected]','normal','1999-10-29'),('8716423251','Vijesh','Brahmbhatt','110059','10','Ghansoli','New Delhi','Delhi','207773','[email protected]','normal','1995-11-20'),('8717789968','Bhulaee','Kurian','110046','1','Faridabad','New Delhi','Delhi','364702','[email protected]','normal','1991-06-18'),('8723736048','Kashish','Gala','110001','10','Indira Nagar','New Delhi','Delhi','222208','[email protected]','normal','1992-02-28'),('8726791774','Maya','Baral','110039','18','Badalpura','New Delhi','Delhi','196492','[email protected]','normal','1995-01-22'),('8731849989','Bhuvneshwar','Chatterjee','110025','19','Chandra Nagar','New Delhi','Delhi','318124','[email protected]','normal','1990-08-12'),('8737219123','Abhinav','Singh','110040','19','Shivaji Nagar','New Delhi','Delhi','228959','[email protected]','premium','1998-05-11'),('8737601546','Madhu','Kumari','110074','7','Sirsi Road','New Delhi','Delhi','189332','[email protected]','normal','2000-12-20'),('8743061623','Jiwan','Dua','110017','4','Kundgol','New Delhi','Delhi','154187','[email protected]','normal','1994-07-18'),('8744637223','Maushid','Agarwal','110047','21','Badalpura','New Delhi','Delhi','341637','[email protected]','normal','1998-10-08'),('8747853781','Bhulan','Kuruvilla','110010','3','Sinnar','New Delhi','Delhi','379125','[email protected]','premium','1996-11-25'),('8748239785','Raghunandan','Gupta','110012','13','Badalpura','New Delhi','Delhi','158476','[email protected]','premium','1994-07-26'),('8749419471','Harender','Deol','110014','23','Shivaji Nagar','New Delhi','Delhi','156395','[email protected]','premium','2000-05-01'),('8752843845','Bhumika','Kumari','110095','25','Shivaji Nagar','New Delhi','Delhi','114965','[email protected]','normal','2002-07-19'),('8753386357','Dama','Dada','110088','19','Songadh','New Delhi','Delhi','277118','[email protected]','normal','1998-07-08'),('8760342422','Raghuvinder','Lata','110027','4','Ahmedabad','New Delhi','Delhi','187377','[email protected]','premium','1999-10-10'),('8764604488','Daman','Dalal','110021','14','Baba Bakala','New Delhi','Delhi','301471','[email protected]','premium','1990-11-25'),('8764761399','Shilly','Mand','110025','5','Jalna','New Delhi','Delhi','243319','[email protected]','premium','1995-12-13'),('8779776039','Lokender','Ganesan','110085','15','Andheri','New Delhi','Delhi','317491','[email protected]','premium','1999-08-28'),('8779918880','Adesh','Kayast','110061','15','Park Street','New Delhi','Delhi','123330','[email protected]','premium','1992-01-01'),('8780872603','Ishant','Devi','110041','6','Alandur','New Delhi','Delhi','140089','[email protected]','normal','1998-02-23'),('8781353271','Ganesi','Deenakar','110039','13','Alandur','New Delhi','Delhi','343615','[email protected]','normal','1994-12-03'),('8786614016','Madina','Singh','110018','2','Pandu Nagar','New Delhi','Delhi','132014','[email protected]','premium','1999-02-15'),('8793542612','Karshma','Dugal','110066','11','Aamby Valley City','New Delhi','Delhi','125862','[email protected]','premium','1997-02-02'),('8793877293','Chitu','Choudhary','110021','24','Dhanbad Road','New Delhi','Delhi','193838','[email protected]','premium','1992-10-13'),('8798964827','Bhupendar','Lala','110011','30','Sewlakhas Nagar','New Delhi','Delhi','106053','[email protected]','normal','2000-01-14'),('8799973366','Peena','Lala','110090','21','Faridabad','New Delhi','Delhi','119261','[email protected]','normal','1996-10-25'),('8826666390','Hardik','Sharma','110097','15','Mayur Vihar','New Delhi','Delhi','209772','[email protected]','normal','1995-09-17'),('8827481250','Adersen','Buch','110090','15','Songadh','New Delhi','Delhi','257845','[email protected]','normal','2002-07-12'),('8830712258','Ragib','Loyal','110014','27','Lekha Nagar','New Delhi','Delhi','286819','[email protected]','premium','1998-07-02'),('8836925784','Jaibhagwan','Dhawan','110060','11','Hazratganj','New Delhi','Delhi','142275','[email protected]','normal','2001-06-05'),('8852632786','Hariom','Deshmukh','110098','21','Kalmeshwar','New Delhi','Delhi','323664','[email protected]','normal','1993-09-01'),('8855589019','Yashoda','Ghosh','110023','14','Thane','New Delhi','Delhi','178790','[email protected]','normal','2002-04-07'),('8856713318','Chinku','Goel','110082','19','Gomti Nagar','New Delhi','Delhi','174909','[email protected]','normal','1995-05-28'),('8865228931','Omveer','Kurian','110013','27','Hirapur','New Delhi','Delhi','391887','[email protected]','normal','1998-07-16'),('8868904661','Adarsh','Kumar','110031','12','Bah','New Delhi','Delhi','178623','[email protected]','normal','1996-08-09'),('8870973947','Bhupendra','Chander','110046','12','Narsipatnam','New Delhi','Delhi','195291','[email protected]','normal','1995-12-27'),('8876874883','Chiranjavi','Madan','110077','18','Napier Town','New Delhi','Delhi','155359','[email protected]','premium','1990-07-08'),('8878681355','Karuna','Dutta','110039','26','Lajpat Nagar','New Delhi','Delhi','277896','[email protected]','premium','1993-07-25'),('8883448929','Sukheeya','Mane','110083','17','Chandkheda','New Delhi','Delhi','116791','[email protected]','premium','2001-07-28'),('8891141763','Chitranjan','Chopra','110057','1','Fatehpur','New Delhi','Delhi','187433','[email protected]','premium','1990-04-20'),('8891303372','Reshmi','Jain','110041','2','Pakhowal Road','New Delhi','Delhi','320984','[email protected]','premium','1991-02-21'),('8897462341','Sukhlal','Bose','110020','1','Ahmedabad','New Delhi','Delhi','125150','[email protected]','premium','2000-07-24'),('9217184983','Chinta','Sharma','110089','17','Chandigarh','New Delhi','Delhi','108799','[email protected]','normal','1997-12-10'),('9221298131','Gangajali','Datta','110014','21','Vigyan Nagar','New Delhi','Delhi','218943','[email protected]','premium','1994-10-11'),('9223767653','Karunakar','Dyal','110047','12','Benipur','New Delhi','Delhi','334728','[email protected]','normal','1992-01-28'),('9236479507','Bhuwan','Sharma','110053','7','Dharwad','New Delhi','Delhi','206505','[email protected]','normal','1993-05-07'),('9245656425','Madhwi','Singh','110014','30','Peelamedu','New Delhi','Delhi','143707','[email protected]','premium','1990-12-05'),('9247946673','Abhinwav','Dixit','110018','24','Dhanbad Road','New Delhi','Delhi','253954','[email protected]','normal','1997-11-18'),('9262878787','Jiyaul','Dubey','110075','22','Dwarka','New Delhi','Delhi','118531','[email protected]','normal','1997-05-14'),('9266049720','Sukhpal','Mani','110081','7','Chitradurga','New Delhi','Delhi','360369','[email protected]','premium','1992-09-26'),('9267696153','Bigan','Choudhary','110088','21','Jamshedpur','New Delhi','Delhi','272274','[email protected]','normal','1997-07-15'),('9270497728','Narander','Kulkarni','110027','12','Modinagar','New Delhi','Delhi','390011','[email protected]','normal','1991-11-25'),('9279956787','Gangaram','Kapur','110083','27','Thatipur','New Delhi','Delhi','264274','[email protected]','normal','1999-04-14'),('9280075034','Adhish','Kumar','110082','30','Narsipatnam','New Delhi','Delhi','195291','[email protected]','premium','2002-05-23'),('9311305685','Bhundki','Agarwal','110016','16','Pandu Nagar','New Delhi','Delhi','310364','[email protected]','premium','2001-11-02'),('9315709956','Chitro','Choudhary','110089','11','Ambli','New Delhi','Delhi','173048','[email protected]','premium','1992-08-17'),('9322979891','Bhuneshwar','Lal','110019','20','Modinagar','New Delhi','Delhi','134555','[email protected]','normal','1994-09-29'),('9323058627','Narayan','Kumar','110007','4','Badalpura','New Delhi','Delhi','245788','[email protected]','normal','2000-02-05'),('9324037167','Harendra','Desai','110025','14','Sinnar','New Delhi','Delhi','152879','[email protected]','premium','1996-09-05'),('9324511896','Ishan','Devan','110032','17','Pimpri','New Delhi','Delhi','369387','[email protected]','premium','1995-12-07'),('9324546523','Sukhmit','Mangat','110071','3','Shivaji Nagar','New Delhi','Delhi','277387','[email protected]','normal','1992-07-19'),('9343285253','Mayak','Baria','110032','13','Thane','New Delhi','Delhi','142056','[email protected]','premium','1997-09-06'),('9345399131','Mayank','Utthapa','110003','29','Ghansoli','New Delhi','Delhi','282705','[email protected]','normal','1997-07-02'),('9348125654','Kashi','Edwin','110050','12','City of Thane','New Delhi','Delhi','369843','[email protected]','premium','1998-05-10'),('9348781766','Raghuvir','Kumar','110005','24','Jalna','New Delhi','Delhi','365421','[email protected]','normal','2002-09-01'),('9356612424','Bhupesh','kumar','110072','24','Ajnala','New Delhi','Delhi','125417','[email protected]','premium','1992-12-23'),('9362408274','Dalpat','Rai','110031','4','South Solapur','New Delhi','Delhi','346998','[email protected]','premium','1994-08-06'),('9365104788','Abhishekh','Agarwal','110053','17','Fatehpur Sikri','New Delhi','Delhi','127421','[email protected]','normal','1998-10-04'),('9370356484','Jitu','Doshi','110070','13','Vijay Nagar','New Delhi','Delhi','137320','[email protected]','premium','1993-09-18'),('9370367071','Sukhdevi','Mander','110056','17','Jamshedpur','New Delhi','Delhi','364253','[email protected]','normal','1991-11-17'),('9377349557','Kashis','Gade','110025','18','Pimpri','New Delhi','Delhi','334204','[email protected]','normal','2000-05-12'),('9382432999','Bidhya','Chaudhary','110081','11','Narsipatnam','New Delhi','Delhi','143876','[email protected]','normal','1995-11-15'),('9388587088','Tikaram','Jaiswal','110026','2','Narsipatnam','New Delhi','Delhi','195291','[email protected]','premium','1994-10-03'),('9395179800','Chintan','Luthra','110081','13','Ellis Nagar','New Delhi','Delhi','279309','[email protected]','premium','1997-04-02'),('9398019429','Chirag','Madan','110025','17','Kalmeshwar','New Delhi','Delhi','110023','[email protected]','normal','2002-09-29'),('9719516787','Ishita','Dhar','110078','9','Wright Town','New Delhi','Delhi','340174','[email protected]','premium','1993-11-09'),('9749635297','Reshami','Bhasin','110068','19','Ahmedabad','New Delhi','Delhi','153469','[email protected]','premium','1996-09-26'),('9750354889','Isharar','Dewan','110007','26','Pimpri','New Delhi','Delhi','115907','[email protected]','normal','1998-08-03'),('9753784498','Daljeet','Comar','110023','21','City of Thane','New Delhi','Delhi','253643','[email protected]','normal','2001-06-12'),('9760197861','Pryanika','Lall','110053','20','Gomti Nagar','New Delhi','Delhi','179417','[email protected]','normal','2001-09-06'),('9768136477','Kashiram','Gaba','110095','13','Lajpat Nagar','New Delhi','Delhi','178519','[email protected]','premium','1992-06-14'),('9774452538','Lokendra','Ganesh','110023','12','Ahmedabad','New Delhi','Delhi','319150','[email protected]','normal','1992-04-01'),('9774452572','Narayani','Kumer','110007','24','Badalpura','New Delhi','Delhi','374945','[email protected]','normal','2000-03-16'),('9778557117','Bidami','Choudhary','110001','23','Bally','New Delhi','Delhi','185281','[email protected]','premium','2002-07-07'),('9780858351','Kartik','Dugar','110049','12','Prayagraj','New Delhi','Delhi','308844','[email protected]','normal','1999-08-06'),('9789978513','Jaideep','Din','110075','7','Rajgarh','New Delhi','Delhi','365610','[email protected]','premium','2001-01-14'),('9790538045','Gali','Dara','110026','14','Chinchwad','New Delhi','Delhi','392536','[email protected]','premium','1995-04-14'),('9791041459','Jitendra','Dora','110094','23','Prayagraj','New Delhi','Delhi','201640','[email protected]','premium','1994-08-09'),('9816247236','Dalima','Choudhary','110051','23','Defence Colony','New Delhi','Delhi','273063','[email protected]','premium','1997-08-25'),('9817917668','Jitendera','Sharma','110080','5','Indira Park','New Delhi','Delhi','268564','[email protected]','normal','1998-09-11'),('9821175217','Reshma','Jain','110086','5','Mangalagiri','New Delhi','Delhi','151789','[email protected]','normal','1996-11-09'),('9829692908','Pawni','Sharma','110053','20','City of Thane','New Delhi','Delhi','308521','[email protected]','normal','1991-03-25'),('9836053943','Jaichand','Dhingra','110007','6','Bandra','New Delhi','Delhi','236907','[email protected]','normal','1990-01-02'),('9845642338','Lokesh','Ganguly','110052','28','Salt Lake City','New Delhi','Delhi','288428','[email protected]','premium','1993-03-01'),('9854756162','Bhudev','Singh','110092','7','Pakhowal Road','New Delhi','Delhi','349327','[email protected]','premium','2002-11-10'),('9857569456','Harish','Deshpande','110098','19','Chandkheda','New Delhi','Delhi','348560','[email protected]','premium','1997-02-09'),('9867774159','Umesha','Mannan','110002','25','Ajmer Road','New Delhi','Delhi','125485','[email protected]','premium','1999-11-19'),('9876358350','Galiya','Sharma','110058','10','Ajnala','New Delhi','Delhi','147042','[email protected]','premium','2002-09-24'),('9877124785','Gajwanti','Kapur','110031','10','Sudder Street','New Delhi','Delhi','275637','[email protected]','normal','2001-07-06'),('9888568589','Kashiv','Gandhi','110011','6','Jagatpura','New Delhi','Delhi','337762','[email protected]','premium','1993-05-06'),('9891597562','Raghuveer','Sharma','110032','11','Ratanada','New Delhi','Delhi','186526','[email protected]','normal','2002-09-21'),('9892566135','Damanjeet','Dani','110009','1','Airohi','New Delhi','Delhi','125520','[email protected]','normal','2000-03-16'),('9892791731','Kartika','Dutt','110087','15','Modinagar','New Delhi','Delhi','224115','[email protected]','premium','2000-02-19'),('9894507978','Shilpi','Mandal','110040','27','Gondal','New Delhi','Delhi','260125','[email protected]','normal','2000-09-25'),('9899482940','Omprkesh','Kunda','110058','7','Aamby Valley City','New Delhi','Delhi','165461','[email protected]','normal','1996-11-06');
/*!40000 ALTER TABLE `Customer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Temporary view structure for view `CustomerDetails`
--
DROP TABLE IF EXISTS `CustomerDetails`;
/*!50001 DROP VIEW IF EXISTS `CustomerDetails`*/;
SET @saved_cs_client = @@character_set_client;
/*!50503 SET character_set_client = utf8mb4 */;
/*!50001 CREATE VIEW `CustomerDetails` AS SELECT
1 AS `phone`,
1 AS `fName`,
1 AS `lName`,
1 AS `email`,
1 AS `state`,
1 AS `customerType`,
1 AS `dob`*/;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `DeliveryWorker`
--
DROP TABLE IF EXISTS `DeliveryWorker`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `DeliveryWorker` (
`employeeID` varchar(8) NOT NULL,
`fName` varchar(20) NOT NULL,
`lName` varchar(20) NOT NULL,
`phone` char(10) NOT NULL,
`salary` int NOT NULL,
`dob` date NOT NULL,
`hNo` varchar(6) NOT NULL,
`street` varchar(20) DEFAULT NULL,
`area` varchar(20) NOT NULL,
`city` varchar(20) NOT NULL,
`state` varchar(20) NOT NULL,
`pin` char(6) NOT NULL,
`socialCause` tinyint(1) NOT NULL DEFAULT '0',
`tips` int NOT NULL DEFAULT '0',
`supervisorID` varchar(8) NOT NULL,
`fuelAmt` int NOT NULL DEFAULT '2000',
PRIMARY KEY (`employeeID`),
UNIQUE KEY `phone` (`phone`),
KEY `supervisorID` (`supervisorID`),
CONSTRAINT `DeliveryWorker_ibfk_1` FOREIGN KEY (`supervisorID`) REFERENCES `Management` (`employeeID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `DeliveryWorker`
--
LOCK TABLES `DeliveryWorker` WRITE;
/*!40000 ALTER TABLE `DeliveryWorker` DISABLE KEYS */;
INSERT INTO `DeliveryWorker` VALUES ('E250800','Kamakshya','Sharaf','8705208145',24200,'1987-02-05','129','14','Peelamedu','New Delhi','Delhi','110025',1,0,'S540990',2000),('E250802','Kesar','Shukla','9933512513',23200,'1986-08-03','21','10','Modinagar','New Delhi','Delhi','110047',0,0,'S540991',2000),('E250804','Kaptan','Mittal','8488872531',24100,'1987-10-24','230','26','Dhanbad Road','New Delhi','Delhi','110074',0,0,'S540989',2000),('E250806','Shela','Palla','8903424890',25400,'1977-06-29','175','7','City of Thane','New Delhi','Delhi','110076',1,0,'S540990',2000),('E250808','Ramnihor','Goel','8929400879',21900,'2000-05-16','162','26','Sirsi Road','New Delhi','Delhi','110045',0,0,'S540991',2000),('E250810','Yashmin','Taneja','8414780251',26700,'1993-02-28','184','24','Faridabad','New Delhi','Delhi','110005',1,0,'S540989',2000),('E250812','Marzina','Viswanathan','8381836777',20900,'1999-02-26','184','16','Pandu Nagar','New Delhi','Delhi','110087',0,0,'S540990',2000),('E250814','Deepka','Naidu','9859648598',24800,'1976-07-05','267','2','Dwarka','New Delhi','Delhi','110074',1,0,'S540991',2000),('E250816','Pankaj','Desai','9340713951',24000,'1975-01-23','257','19','Jamshedpur','New Delhi','Delhi','110010',1,0,'S540989',2000),('E250818','Subesh','Parsa','8704986828',26700,'1984-04-08','136','14','Napier Town','New Delhi','Delhi','110096',0,0,'S540990',2000),('E250820','Ravindera','Verma','9280786847',21100,'1985-01-04','254','30','Chandigarh','New Delhi','Delhi','110056',0,0,'S540991',2000),('E250822','Nitin','Murthy','8351200904',20100,'1992-01-18','140','1','Peelamedu','New Delhi','Delhi','110033',1,0,'S540989',2000),('E250824','Nibha','Prasad','9334807355',21600,'1989-06-01','141','12','Sinnar','New Delhi','Delhi','110073',0,0,'S540990',2000),('E250826','Baleshwer','Mohanty','8752386691',20300,'1999-05-03','73','30','Bandra','New Delhi','Delhi','110079',0,0,'S540991',2000),('E250828','Kismti','Goswami','8496526674',22400,'1987-07-13','245','17','Badalpura','New Delhi','Delhi','110088',0,0,'S540989',2000),('E250830','Rambir','Gupta','9231806535',25400,'1996-03-17','298','7','City of Thane','New Delhi','Delhi','110019',1,0,'S540990',2000),('E250832','Sushma','Dhaliwal','8268233798',22700,'1991-11-04','234','5','Bah','New Delhi','Delhi','110069',0,0,'S540991',2000),('E250834','Tunni','Reddy','8440164945',23800,'1999-10-29','48','29','Airohi','New Delhi','Delhi','110020',0,0,'S540989',2000),('E250836','Rustam','Seshadri','8308356704',24300,'1981-08-28','64','14','Volad','New Delhi','Delhi','110075',0,0,'S540990',2000),('E250838','Manvendra','Raja','9848116775',21200,'1985-03-05','235','23','Ellis Nagar','New Delhi','Delhi','110095',1,0,'S540991',2000),('E250840','Sanjogta','Deshmukh','8245146126',25100,'1990-01-27','200','13','Raisen','New Delhi','Delhi','110050',0,0,'S540989',2000),('E250842','Madhvi','Sidhu','9493245349',24100,'1996-04-22','140','2','Rajgarh','New Delhi','Delhi','110023',1,0,'S540990',2000),('E250844','Kashis','Sabharwal','8814878359',26500,'1999-03-09','253','17','Juhu','New Delhi','Delhi','110067',0,0,'S540991',2000),('E250846','Kumare','Sharma','8650129106',20600,'1988-12-13','172','2','Narsipatnam','New Delhi','Delhi','110005',1,0,'S540989',2000),('E250848','Krishan','Ghosh','9687879391',26800,'1995-06-04','7','10','Shivaji Nagar','New Delhi','Delhi','110084',0,0,'S540990',2000),('E250850','Ansu','Sarkar','9292297245',22800,'1983-11-20','194','22','South Solapur','New Delhi','Delhi','110078',0,0,'S540991',2000),('E250852','Rimzim','Khurana','8440276155',20100,'2000-08-05','195','1','Shivaji Nagar','New Delhi','Delhi','110021',0,0,'S540989',2000),('E250854','Dhramveer','Sandal','9809443217',26600,'1988-10-17','79','7','City of Thane','New Delhi','Delhi','110009',0,0,'S540990',2000),('E250856','Budho','Nath','9545817375',22000,'1977-04-08','61','30','Benipur','New Delhi','Delhi','110087',1,0,'S540991',2000),('E250858','Veeru','Pradhan','9442700486',24300,'1997-03-04','122','23','Gomti Nagar','New Delhi','Delhi','110008',1,0,'S540989',2000),('E250860','Mangelal','Bhalla','9362620532',21600,'1985-10-22','28','28','Pimpri','New Delhi','Delhi','110058',0,0,'S540990',2000),('E250862','Munish','Rajagopal','8695305111',23000,'1998-12-25','165','25','Prayagraj','New Delhi','Delhi','110057',0,0,'S540991',2000),('E250864','Rashimi','Pal','9666638176',25400,'1992-05-09','248','22','Badalpura','New Delhi','Delhi','110018',1,0,'S540989',2000),('E250866','Sobi','Tara','9512975244',20800,'1999-01-27','293','10','Gomti Nagar','New Delhi','Delhi','110051',1,0,'S540990',2000),('E250868','Roma','Guha','8783446052',23700,'1979-02-12','72','4','Chinchwad','New Delhi','Delhi','110041',1,0,'S540991',2000),('E250870','Saniya','Mehra','9789132579',24500,'1981-01-22','257','30','Ameerpet','New Delhi','Delhi','110078',0,0,'S540989',2000),('E250872','Panchuram','Shroff','9405648623',23000,'1993-11-09','290','28','North Solapur','New Delhi','Delhi','110096',0,0,'S540990',2000),('E250874','Khusbu','Grover','9509121140',21500,'1989-06-10','228','20','Ghansoli','New Delhi','Delhi','110055',0,0,'S540991',2000),('E250876','Imaman','Saxena','8374255198',20100,'1975-12-03','197','17','Wright Town','New Delhi','Delhi','110018',0,0,'S540989',2000),('E250878','Chatar','Kashyap','9939815208',23900,'1986-09-22','14','1','Narsipatnam','New Delhi','Delhi','110010',0,0,'S540990',2000),('E250880','Laldhari','Solanki','9590982428',26600,'1980-01-05','74','2','Ahmedabad','New Delhi','Delhi','110096',1,0,'S540991',2000),('E250882','Nishu','Varty','9290367248',24900,'1975-11-11','201','27','Defence Colony','New Delhi','Delhi','110088',1,0,'S540989',2000),('E250884','Laltha','Mehrotra','8204471598',21200,'1978-09-18','118','29','Aamby Valley City','New Delhi','Delhi','110073',1,0,'S540990',2000),('E250886','Salmakhatun','Sunder','9642322954',21900,'1975-05-08','196','20','Kavi Nagar','New Delhi','Delhi','110024',1,0,'S540991',2000),('E250888','Babali','Khanna','9366210656',22300,'1987-11-07','168','17','Songadh','New Delhi','Delhi','110004',0,0,'S540991',2000),('E250890','Jitendera','Joshi','9421132652',25300,'1984-11-18','266','25','Pimpri','New Delhi','Delhi','110019',0,0,'S540989',2000),('E250892','Surendr','Acharya','9987728730',24500,'1981-10-23','82','1','City of Thane','New Delhi','Delhi','110020',0,0,'S540990',2000),('E250894','Unkar','Garg','8233444543',26300,'1989-04-29','119','5','Ahmedabad','New Delhi','Delhi','110039',0,0,'S540991',2000),('E250896','Anjuman','Sundaram','9523775781',25800,'1994-08-07','32','16','Dharwad','New Delhi','Delhi','110016',1,0,'S540989',2000),('E250898','Majrula','Kohli','9241964675',25200,'1998-03-08','119','28','Chandra Nagar','New Delhi','Delhi','110063',1,0,'S540990',2000);
/*!40000 ALTER TABLE `DeliveryWorker` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Temporary view structure for view `DeliveryWorkerDetails`
--
DROP TABLE IF EXISTS `DeliveryWorkerDetails`;
/*!50001 DROP VIEW IF EXISTS `DeliveryWorkerDetails`*/;
SET @saved_cs_client = @@character_set_client;
/*!50503 SET character_set_client = utf8mb4 */;
/*!50001 CREATE VIEW `DeliveryWorkerDetails` AS SELECT
1 AS `employeeID`,
1 AS `fName`,
1 AS `lName`,
1 AS `phone`,
1 AS `socialCause`,
1 AS `supervisorID`,
1 AS `dob`*/;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `Donation`
--
DROP TABLE IF EXISTS `Donation`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Donation` (
`donationID` varchar(9) NOT NULL,
`donorID` varchar(8) NOT NULL,
`receiverID` varchar(8) DEFAULT NULL,
`deliveryWorkerID` varchar(8) NOT NULL,
`dateTime` date DEFAULT NULL,
`category` varchar(10) NOT NULL,
`status` varchar(15) NOT NULL DEFAULT 'active',
`quantity` int NOT NULL DEFAULT '1',
PRIMARY KEY (`donationID`),
KEY `donorID` (`donorID`),
KEY `receiverID` (`receiverID`),
KEY `deliveryWorkerID` (`deliveryWorkerID`),
KEY `delivery` (`deliveryWorkerID`),
CONSTRAINT `Donation_ibfk_1` FOREIGN KEY (`donorID`) REFERENCES `Donor` (`donorID`),
CONSTRAINT `Donation_ibfk_2` FOREIGN KEY (`receiverID`) REFERENCES `Receiver` (`receiverID`),
CONSTRAINT `Donation_ibfk_3` FOREIGN KEY (`deliveryWorkerID`) REFERENCES `DeliveryWorker` (`employeeID`),
CONSTRAINT `Donation_chk_2` CHECK (((`status` = _utf8mb4'active') or (`status` = _utf8mb4'delivered'))),
CONSTRAINT `donationType` CHECK (((`category` = _utf8mb4'Meals') or (`category` = _utf8mb4'Clothes') or (`category` = _utf8mb4'Money')))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Donation`
--
LOCK TABLES `Donation` WRITE;
/*!40000 ALTER TABLE `Donation` DISABLE KEYS */;
INSERT INTO `Donation` VALUES ('DO10000','D1087444','R320238','E250864','2020-11-10','Money','delivered',607),('DO10001','D1087444','R320103','E250896','2020-02-20','Meals','delivered',1),('DO10002','D1087308','R320109','E250880','2020-04-12','Clothes','delivered',1),('DO10003','D1087422','R320121','E250816','2020-10-11','Money','active',386),('DO10004','D1087382','R320208','E250896','2020-10-24','Meals','delivered',1),('DO10005','D1087340','R320160','E250816','2020-05-25','Meals','delivered',1),('DO10006','D1087420','R320172','E250868','2020-07-12','Meals','delivered',1),('DO10007','D1087408','R320196','E250822','2020-12-26','Meals','delivered',1),('DO10008','D1087396','R320145','E250884','2020-09-03','Money','delivered',909),('DO10009','D1087428','R320166','E250856','2020-06-09','Clothes','delivered',1),('DO10010','D1087336','R320163','E250838','2020-06-09','Money','delivered',909),('DO10011','D1087368','R320106','E250896','2020-08-15','Money','delivered',1348),('DO10012','D1087442','R320124','E250880','2020-09-25','Clothes','delivered',1),('DO10013','D1087408','R320211','E250846','2020-09-24','Meals','delivered',1),('DO10014','D1087420','R320100','E250898','2020-05-11','Money','delivered',133),('DO10015','D1087408','R320127','E250800','2020-05-24','Money','delivered',1609),('DO10016','D1087394','R320223','E250822','2020-12-08','Clothes','delivered',1),('DO10017','D1087340','R320223','E250864','2020-11-24','Clothes','delivered',1),('DO10018','D1087418','R320112','E250856','2020-09-03','Meals','active',1),('DO10019','D1087396','R320190','E250800','2020-07-08','Clothes','active',1),('DO10020','D1087370','R320175','E250866','2021-01-22','Money','delivered',653),('DO10021','D1087436','R320184','E250830','2020-01-15','Money','delivered',1575),('DO10022','D1087358','R320190','E250898','2020-06-08','Clothes','active',1),('DO10023','D1087430','R320166','E250822','2020-10-03','Clothes','delivered',1),('DO10024','D1087382','R320205','E250814','2020-11-10','Money','active',918),('DO10025','D1087396','R320172','E250868','2021-01-06','Meals','active',1),('DO10026','D1087312','R320202','E250880','2020-08-31','Money','delivered',1597),('DO10027','D1087304','R320106','E250896','2020-10-21','Money','delivered',453),('DO10028','D1087440','R320199','E250866','2020-09-06','Clothes','delivered',1),('DO10029','D1087416','R320202','E250830','2020-10-23','Money','delivered',1980),('DO10030','D1087412','R320145','E250880','2020-01-18','Money','delivered',740),('DO10031','D1087302','R320130','E250806','2020-08-12','Clothes','delivered',1),('DO10032','D1087328','R320217','E250882','2020-01-25','Money','delivered',154),('DO10033','D1087444','R320109','E250884','2020-11-17','Clothes','delivered',1),('DO10034','D1087420','R320184','E250800','2020-12-26','Money','delivered',960),('DO10035','D1087448','R320196','E250800','2020-06-27','Meals','delivered',1),('DO10036','D1087434','R320184','E250884','2020-02-19','Money','delivered',300),('DO10037','D1087300','R320160','E250810','2020-09-24','Meals','delivered',1),('DO10038','D1087392','R320112','E250866','2020-01-04','Meals','delivered',1),('DO10039','D1087322','R320118','E250816','2020-10-05','Money','active',1388),('DO10040','D1087322','R320241','E250800','2020-09-28','Meals','delivered',1),('DO10041','D1087354','R320205','E250880','2020-11-25','Money','delivered',1223),('DO10042','D1087318','R320121','E250800','2020-06-27','Money','delivered',1266),('DO10043','D1087414','R320241','E250856','2020-04-20','Meals','delivered',1),('DO10044','D1087390','R320127','E250822','2020-06-05','Money','delivered',1285),('DO10045','D1087302','R320172','E250898','2020-08-21','Meals','active',1),('DO10046','D1087402','R320109','E250896','2020-04-01','Clothes','delivered',1),('DO10047','D1087412','R320226','E250800','2020-11-01','Clothes','delivered',1),('DO10048','D1087312','R320127','E250866','2020-01-22','Money','delivered',244),('DO10049','D1087432','R320133','E250800','2020-07-01','Money','delivered',981),('DO10050','D1087436','R320220','E250886','2020-01-28','Money','delivered',1737),('DO10051','D1087302','R320157','E250866','2020-06-28','Meals','delivered',1),('DO10052','D1087446','R320208','E250806','2020-05-18','Meals','delivered',1),('DO10053','D1087300','R320133','E250822','2020-06-04','Money','delivered',439),('DO10054','D1087442','R320241','E250800','2020-04-22','Meals','delivered',1),('DO10055','D1087348','R320178','E250810','2020-12-24','Money','delivered',271),('DO10056','D1087370','R320112','E250810','2021-01-21','Meals','delivered',1),('DO10057','D1087342','R320244','E250884','2020-01-26','Meals','delivered',1),('DO10058','D1087320','R320211','E250846','2020-08-12','Meals','delivered',1),('DO10059','D1087420','R320199','E250822','2020-10-21','Clothes','delivered',1),('DO10060','D1087384','R320127','E250880','2020-01-01','Money','delivered',1723),('DO10061','D1087338','R320235','E250898','2020-08-12','Money','delivered',267),('DO10062','D1087418','R320106','E250800','2020-09-20','Money','delivered',1843),('DO10063','D1087352','R320148','E250868','2020-12-28','Money','delivered',1352),('DO10064','D1087300','R320172','E250866','2020-12-02','Meals','delivered',1),('DO10065','D1087336','R320163','E250810','2020-09-28','Money','delivered',1917),('DO10066','D1087446','R320181','E250880','2021-01-25','Money','delivered',1978),('DO10067','D1087312','R320148','E250856','2020-11-26','Money','active',1022),('DO10068','D1087340','R320109','E250810','2020-08-24','Clothes','delivered',1),('DO10069','D1087344','R320196','E250866','2020-10-07','Meals','delivered',1),('DO10070','D1087344','R320211','E250810','2020-01-03','Meals','delivered',1),('DO10071','D1087394','R320157','E250806','2020-05-12','Meals','delivered',1),('DO10072','D1087336','R320100','E250810','2020-01-10','Money','delivered',935),('DO10073','D1087426','R320157','E250898','2020-02-23','Meals','delivered',1),('DO10074','D1087344','R320157','E250882','2020-01-20','Meals','delivered',1),('DO10075','D1087448','R320127','E250846','2020-12-23','Money','delivered',868),('DO10076','D1087328','R320223','E250838','2020-09-07','Clothes','delivered',1),('DO10077','D1087342','R320193','E250838','2020-05-03','Meals','delivered',1),('DO10078','D1087324','R320160','E250838','2020-01-26','Meals','delivered',1),('DO10079','D1087360','R320187','E250806','2020-03-27','Money','delivered',775),('DO10080','D1087414','R320136','E250864','2020-08-14','Money','delivered',1919),('DO10081','D1087314','R320190','E250882','2020-02-29','Clothes','delivered',1),('DO10082','D1087364','R320232','E250800','2020-05-30','Meals','active',1),('DO10083','D1087382','R320241','E250884','2020-03-26','Meals','active',1),('DO10084','D1087398','R320157','E250800','2020-12-10','Meals','delivered',1),('DO10085','D1087376','R320124','E250838','2020-09-18','Clothes','delivered',1),('DO10086','D1087340','R320148','E250838','2020-03-16','Money','delivered',1200),('DO10087','D1087410','R320211','E250880','2020-04-02','Meals','delivered',1),('DO10088','D1087444','R320169','E250838','2020-11-17','Clothes','delivered',1),('DO10089','D1087324','R320238','E250880','2020-05-07','Money','delivered',536),('DO10090','D1087402','R320100','E250800','2020-04-07','Money','delivered',1119),('DO10091','D1087374','R320100','E250864','2020-10-11','Money','delivered',1533),('DO10092','D1087374','R320181','E250806','2020-02-13','Money','active',434),('DO10093','D1087334','R320220','E250800','2020-06-12','Money','delivered',945),('DO10094','D1087356','R320193','E250810','2020-12-15','Meals','active',1),('DO10095','D1087434','R320142','E250800','2020-03-22','Money','delivered',137),('DO10096','D1087340','R320160','E250810','2020-09-18','Meals','active',1),('DO10097','D1087328','R320190','E250866','2020-12-10','Clothes','delivered',1),('DO10098','D1087350','R320136','E250856','2021-01-22','Money','delivered',163),('DO10099','D1087300','R320181','E250838','2020-10-22','Money','delivered',200),('DO10100','D1087424','R320181','E250814','2020-02-23','Money','delivered',1205),('DO10101','D1087314','R320142','E250842','2020-04-25','Money','delivered',812),('DO10102','D1087390','R320100','E250868','2020-04-25','Money','delivered',197),('DO10103','D1087406','R320193','E250868','2020-09-08','Meals','delivered',1),('DO10104','D1087318','R320130','E250830','2020-01-30','Clothes','delivered',1),('DO10105','D1087416','R320187','E250814','2020-09-21','Money','active',344),('DO10106','D1087424','R320181','E250842','2020-04-30','Money','delivered',949),('DO10107','D1087362','R320151','E250898','2020-07-01','Meals','delivered',1),('DO10108','D1087430','R320232','E250868','2020-08-21','Meals','delivered',1),('DO10109','D1087370','R320241','E250816','2020-11-20','Meals','delivered',1),('DO10110','D1087368','R320235','E250868','2020-04-10','Money','active',1002),('DO10111','D1087418','R320175','E250846','2020-03-08','Money','delivered',581),('DO10112','D1087304','R320151','E250864','2020-05-03','Meals','delivered',1),('DO10113','D1087416','R320124','E250822','2020-11-11','Clothes','delivered',1),('DO10114','D1087426','R320166','E250856','2020-11-03','Clothes','delivered',1),('DO10115','D1087378','R320106','E250800','2021-01-12','Money','delivered',1687),('DO10116','D1087398','R320214','E250858','2020-06-14','Money','delivered',1758),('DO10117','D1087416','R320226','E250882','2020-09-03','Clothes','delivered',1),('DO10118','D1087434','R320109','E250868','2020-05-02','Clothes','delivered',1),('DO10119','D1087428','R320106','E250822','2020-10-04','Money','delivered',1704),('DO10120','D1087330','R320112','E250868','2020-11-27','Meals','delivered',1),('DO10121','D1087372','R320136','E250856','2020-07-15','Money','delivered',1485),('DO10122','D1087348','R320211','E250838','2020-08-08','Meals','delivered',1),('DO10123','D1087330','R320223','E250864','2020-12-16','Clothes','delivered',1),('DO10124','D1087430','R320211','E250864','2020-10-31','Meals','delivered',1),('DO10125','D1087408','R320106','E250884','2020-01-08','Money','delivered',1499),('DO10126','D1087314','R320211','E250822','2020-10-08','Meals','delivered',1),('DO10127','D1087416','R320163','E250838','2020-05-15','Money','delivered',1573),('DO10128','D1087330','R320175','E250822','2020-07-16','Money','active',1870),('DO10129','D1087410','R320247','E250884','2020-05-06','Clothes','delivered',1),('DO10130','D1087410','R320109','E250842','2020-06-19','Clothes','delivered',1),('DO10131','D1087300','R320214','E250838','2021-01-16','Money','delivered',529),('DO10132','D1087410','R320220','E250856','2020-08-17','Money','delivered',146),('DO10133','D1087400','R320148','E250822','2020-05-12','Money','delivered',785),('DO10134','D1087386','R320139','E250864','2020-05-21','Meals','active',1),('DO10135','D1087446','R320247','E250884','2020-03-25','Clothes','delivered',1),('DO10136','D1087304','R320121','E250842','2020-07-12','Money','delivered',366),('DO10137','D1087378','R320169','E250896','2020-08-29','Clothes','active',1),('DO10138','D1087434','R320118','E250846','2020-08-23','Money','active',205),('DO10139','D1087310','R320148','E250800','2020-08-27','Money','delivered',305),('DO10140','D1087340','R320229','E250806','2020-08-25','Meals','delivered',1),('DO10141','D1087412','R320202','E250846','2021-01-18','Money','active',1272),('DO10142','D1087440','R320127','E250830','2020-05-03','Money','delivered',333),('DO10143','D1087428','R320184','E250864','2020-02-18','Money','delivered',1162),('DO10144','D1087316','R320184','E250830','2021-01-18','Money','delivered',223),('DO10145','D1087354','R320115','E250884','2020-11-28','Money','delivered',113),('DO10146','D1087442','R320127','E250800','2020-06-01','Money','delivered',1274),('DO10147','D1087410','R320151','E250896','2020-01-11','Meals','delivered',1),('DO10148','D1087422','R320118','E250884','2020-05-30','Money','delivered',125),('DO10149','D1087320','R320115','E250800','2020-02-15','Money','delivered',1018),('DO10150','D1087388','R320244','E250898','2020-09-05','Meals','delivered',1),('DO10151','D1087416','R320229','E250856','2020-04-13','Meals','delivered',1),('DO10152','D1087394','R320244','E250842','2020-07-18','Meals','delivered',1),('DO10153','D1087394','R320217','E250882','2020-12-22','Money','delivered',940),('DO10154','D1087420','R320226','E250800','2020-09-11','Clothes','delivered',1),('DO10155','D1087372','R320223','E250806','2021-01-10','Clothes','active',1),('DO10156','D1087320','R320223','E250800','2020-06-03','Clothes','delivered',1),('DO10157','D1087312','R320190','E250866','2020-07-17','Clothes','delivered',1),('DO10158','D1087324','R320172','E250896','2020-09-17','Meals','delivered',1),('DO10159','D1087410','R320205','E250842','2020-09-27','Money','delivered',1587),('DO10160','D1087302','R320103','E250810','2020-03-23','Meals','delivered',1),('DO10161','D1087428','R320133','E250810','2021-01-25','Money','delivered',1193),('DO10162','D1087328','R320109','E250800','2020-05-23','Clothes','delivered',1),('DO10163','D1087432','R320190','E250838','2020-09-01','Clothes','delivered',1),('DO10164','D1087314','R320100','E250800','2020-03-20','Money','delivered',284),('DO10165','D1087382','R320172','E250800','2020-09-17','Meals','active',1),('DO10166','D1087326','R320157','E250898','2020-11-14','Meals','delivered',1),('DO10167','D1087418','R320196','E250866','2020-11-21','Meals','delivered',1),('DO10168','D1087356','R320133','E250868','2020-09-01','Money','delivered',987),('DO10169','D1087332','R320193','E250842','2021-01-01','Meals','delivered',1),('DO10170','D1087322','R320193','E250880','2020-01-02','Meals','delivered',1),('DO10171','D1087404','R320142','E250864','2020-05-21','Money','delivered',777),('DO10172','D1087394','R320157','E250898','2020-07-04','Meals','delivered',1),('DO10173','D1087342','R320217','E250810','2020-01-24','Money','delivered',1882),('DO10174','D1087362','R320151','E250810','2020-08-23','Meals','delivered',1),('DO10175','D1087412','R320100','E250838','2020-10-26','Money','delivered',908),('DO10176','D1087400','R320145','E250816','2020-04-04','Money','delivered',1812),('DO10177','D1087414','R320115','E250880','2020-08-13','Money','delivered',1938),('DO10178','D1087314','R320166','E250868','2020-10-06','Clothes','delivered',1),('DO10179','D1087392','R320154','E250896','2020-10-10','Money','delivered',1691),('DO10180','D1087300','R320226','E250884','2020-01-17','Clothes','delivered',1),('DO10181','D1087358','R320205','E250816','2021-01-05','Money','delivered',828),('DO10182','D1087392','R320118','E250822','2020-12-03','Money','delivered',1044),('DO10183','D1087358','R320127','E250896','2020-11-22','Money','delivered',1821),('DO10184','D1087362','R320196','E250884','2020-10-01','Meals','delivered',1),('DO10185','D1087382','R320103','E250856','2020-12-02','Meals','delivered',1),('DO10186','D1087374','R320127','E250898','2020-08-04','Money','delivered',1775),('DO10187','D1087316','R320124','E250898','2021-01-03','Clothes','delivered',1),('DO10188','D1087320','R320196','E250884','2020-11-06','Meals','delivered',1),('DO10189','D1087332','R320175','E250800','2020-09-10','Money','delivered',552),('DO10190','D1087378','R320235','E250810','2020-07-05','Money','delivered',1202),('DO10191','D1087318','R320223','E250806','2020-07-19','Clothes','delivered',1),('DO10192','D1087382','R320157','E250882','2020-06-10','Meals','delivered',1),('DO10193','D1087374','R320208','E250842','2020-05-21','Meals','delivered',1),('DO10194','D1087348','R320211','E250884','2020-03-04','Meals','delivered',1),('DO10195','D1087418','R320229','E250886','2020-05-08','Meals','delivered',1),('DO10196','D1087432','R320163','E250800','2020-09-22','Money','delivered',1669),('DO10197','D1087378','R320100','E250858','2020-01-07','Money','delivered',1302),('DO10198','D1087410','R320220','E250886','2020-05-15','Money','delivered',613),('DO10199','D1087380','R320220','E250898','2020-10-06','Money','delivered',764),('DO10200','D1087444','R320208','E250880','2020-01-01','Meals','active',1),('DO10201','D1087336','R320193','E250822','2020-04-08','Meals','delivered',1),('DO10202','D1087316','R320124','E250898','2020-11-21','Clothes','delivered',1),('DO10203','D1087324','R320133','E250858','2020-05-05','Money','delivered',1955),('DO10204','D1087408','R320169','E250800','2020-08-17','Clothes','delivered',1),('DO10205','D1087328','R320229','E250806','2020-09-20','Meals','delivered',1),('DO10206','D1087364','R320145','E250822','2020-07-20','Money','delivered',1566),('DO10207','D1087368','R320172','E250838','2020-06-05','Meals','active',1),('DO10208','D1087392','R320220','E250886','2020-03-03','Money','delivered',1813),('DO10209','D1087444','R320130','E250882','2020-02-15','Clothes','delivered',1),('DO10210','D1087326','R320193','E250814','2020-01-20','Meals','delivered',1),('DO10211','D1087312','R320232','E250864','2020-08-30','Meals','delivered',1),('DO10212','D1087300','R320130','E250846','2020-10-25','Clothes','delivered',1),('DO10213','D1087444','R320112','E250838','2020-01-14','Meals','delivered',1),('DO10214','D1087324','R320151','E250822','2020-11-17','Meals','delivered',1),('DO10215','D1087344','R320244','E250846','2021-01-11','Meals','delivered',1),('DO10216','D1087356','R320202','E250838','2020-09-30','Money','delivered',1183),('DO10217','D1087448','R320190','E250856','2020-04-23','Clothes','active',1),('DO10218','D1087330','R320241','E250880','2020-02-24','Meals','delivered',1),('DO10219','D1087358','R320127','E250884','2020-08-28','Money','delivered',212);
/*!40000 ALTER TABLE `Donation` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Donor`
--
DROP TABLE IF EXISTS `Donor`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Donor` (
`donorID` varchar(8) NOT NULL,
`phone` char(10) DEFAULT NULL,
`name` varchar(20) NOT NULL,
`hNo` varchar(6) NOT NULL,
`street` varchar(20) DEFAULT NULL,
`area` varchar(20) NOT NULL,
`city` varchar(20) NOT NULL,
`state` varchar(20) NOT NULL,
`pin` char(6) NOT NULL,
`points` int DEFAULT '0',
PRIMARY KEY (`donorID`),
UNIQUE KEY `phone` (`phone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Donor`
--
LOCK TABLES `Donor` WRITE;
/*!40000 ALTER TABLE `Donor` DISABLE KEYS */;
INSERT INTO `Donor` VALUES ('D1087300','9189307475','Ajay Khatri','232','15','Baba Bakala','New Delhi','Delhi','110096',79),('D1087302','9504807421','Sharjprit Upadhyay','194','11','Modinagar','New Delhi','Delhi','110032',102),('D1087304','8184704541','Alis Ramaswamy','232','7','Jalna','New Delhi','Delhi','110045',160),('D1087306','8048339067','Mini Misra','21','19','Gomti Nagar','New Delhi','Delhi','110046',61),('D1087308','9095126346','Bhagwat Rajan','300','13','Narsipatnam','New Delhi','Delhi','110053',94),('D1087310','9053348817','Satyavati Rao','54','10','Sewlakhas Nagar','New Delhi','Delhi','110093',110),('D1087312','8193095863','Anamika Natarajan','250','19','Jalna','New Delhi','Delhi','110082',130),('D1087314','9055433967','Punia Nayak','228','21','Chandra Nagar','New Delhi','Delhi','110097',80),('D1087316','9042038085','Vakesh Venkataraman','250','6','Aamby Valley City','New Delhi','Delhi','110083',129),('D1087318','8034389257','Sajini Sridhar','131','10','Andheri','New Delhi','Delhi','110019',198),('D1087320','8164636411','Jayanti Varughese','118','26','Chitradurga','New Delhi','Delhi','110076',170),('D1087322','8502286798','Parsi Tripathi','155','18','Narsipatnam','New Delhi','Delhi','110068',68),('D1087324','8142242722','Sunita Nagar','107','23','Ajnala','New Delhi','Delhi','110057',109),('D1087326','8057968265','Nisat Kumar','40','12','City of Thane','New Delhi','Delhi','110075',172),('D1087328','9148427487','Jainub Shah','177','10','Hazratganj','New Delhi','Delhi','110015',59),('D1087330','9048949221','Chanderkali Thakur','21','2','Songadh','New Delhi','Delhi','110056',104),('D1087332','9809946272','Narinder Kapoor','230','17','Jamshedpur','New Delhi','Delhi','110018',27),('D1087334','9035718756','Nrotam Sinha','116','4','Chandkheda','New Delhi','Delhi','110088',151),('D1087336','9508086765','Krish Srivastava','10','4','Vasai','New Delhi','Delhi','110090',15),('D1087338','8182126756','Para Bhardwaj','177','20','Mangalagiri','New Delhi','Delhi','110044',163),('D1087340','8164943939','Rahis Sood','149','2','Ahmedabad','New Delhi','Delhi','110025',148),('D1087342','9025001564','Usha Krishnamurthy','48','17','Ahmedabad','New Delhi','Delhi','110011',198),('D1087344','8505367426','Inkoo Rajagopalan','6','3','Rajgarh','New Delhi','Delhi','110081',165),('D1087346','8067242777','Sagir Khare','293','17','Chinchwad','New Delhi','Delhi','110004',179),('D1087348','9044582387','Ruksaar Choudhary','128','21','Mangalagiri','New Delhi','Delhi','110006',152),('D1087350','8067636456','Chetana Sethi','171','30','Napier Town','New Delhi','Delhi','110010',74),('D1087352','9195119240','Mustkim Prabhakar','68','18','Sinnar','New Delhi','Delhi','110084',109),('D1087354','9507511928','Sarfaraj Suresh','133','13','Pandu Nagar','New Delhi','Delhi','110081',21),('D1087356','8032516126','Sompal Walia','255','12','Fatehpur','New Delhi','Delhi','110054',135),('D1087358','8189137998','Narsingh Rai','144','13','Shivaji Nagar','New Delhi','Delhi','110043',133),('D1087360','9138623122','Rubbina Sandhu','276','24','Hirapur','New Delhi','Delhi','110081',173),('D1087362','9148729323','Hukamchand Dayal','3','24','Ellis Nagar','New Delhi','Delhi','110022',113),('D1087364','9045718392','Kamaldeep Bakshi','125','10','Volad','New Delhi','Delhi','110055',50),('D1087366','8057159339','Bhawari Uppal','160','1','Pakhowal Road','New Delhi','Delhi','110068',154),('D1087368','9193421651','Aru Rastogi','122','23','Ghansoli','New Delhi','Delhi','110074',94),('D1087370','8148043533','Gulafsa Wadhwa','151','18','Narsipatnam','New Delhi','Delhi','110018',26),('D1087372','9046373549','Sahdev Mehta','27','27','Shimoga','New Delhi','Delhi','110019',133),('D1087374','8507005970','Rajkali Devan','231','9','Indira Park','New Delhi','Delhi','110006',23),('D1087376','9067723108','Bhuri Anand','286','30','Peelamedu','New Delhi','Delhi','110059',155),('D1087378','8198826434','Geernish Bhakta','284','23','Ratanada','New Delhi','Delhi','110082',110),('D1087380','8024803185','Ramlal Modi','165','13','Modinagar','New Delhi','Delhi','110018',106),('D1087382','9184709730','Harbinder Bhatnagar','71','12','Saket','New Delhi','Delhi','110082',143),('D1087384','8184605773','Sarla Ramanathan','297','13','Ambli','New Delhi','Delhi','110019',32),('D1087386','9055015086','Yashpal Kaur','201','21','Howrah Uttar','New Delhi','Delhi','110003',117),('D1087388','9059298054','Anusoya Seth','57','25','Pimpri','New Delhi','Delhi','110012',120),('D1087390','9033285056','Manohar Tank','64','20','Thane','New Delhi','Delhi','110093',159),('D1087392','8194334142','Rishi Swaminathan','161','7','Dwarka','New Delhi','Delhi','110054',73),('D1087394','8073834855','Shavitri Srinivas','115','11','Pimpri','New Delhi','Delhi','110045',139),('D1087396','8186827368','Shubankar Sampath','250','16','Pandu Nagar','New Delhi','Delhi','110030',64),('D1087398','9809248022','Ramchandr Ganesh','208','24','Lajpat Nagar','New Delhi','Delhi','110023',92),('D1087400','9067393437','Naveeda Tandon','160','19','Narsipatnam','New Delhi','Delhi','110026',158),('D1087402','9043645889','Supriyal Setty','118','5','Umred','New Delhi','Delhi','110079',21),('D1087404','9807996418','Sablu Shankar','269','7','Modinagar','New Delhi','Delhi','110069',143),('D1087406','9062569309','Jalmi Tak','135','12','Shivaji Nagar','New Delhi','Delhi','110065',110),('D1087408','8506053501','Kauslender Gour','124','14','Juhu','New Delhi','Delhi','110029',42),('D1087410','9035139660','Shashibala Deshpande','181','21','North Solapur','New Delhi','Delhi','110027',158),('D1087412','9502268113','Nayan Chakraborty','186','1','Wright Town','New Delhi','Delhi','110053',35),('D1087414','8036408755','Ajara Pall','125','15','Kavi Nagar','New Delhi','Delhi','110037',150),('D1087416','8502726370','Popinder Prabhu','266','27','Ameerpet','New Delhi','Delhi','110059',154),('D1087418','9058383914','Babli Sankaran','205','14','Kundgol','New Delhi','Delhi','110089',69),('D1087420','8146571920','Saviha Doshi','201','29','Prayagraj','New Delhi','Delhi','110003',85),('D1087422','8067955209','Rubina Srinivasan','233','12','Kolar','New Delhi','Delhi','110086',167),('D1087424','8066727328','Gulshafa Chandra','78','5','Shivaji Nagar','New Delhi','Delhi','110031',148),('D1087426','9166816822','Depander Bhagat','126','6','Kalmeshwar','New Delhi','Delhi','110063',147),('D1087428','8068391630','Nishant Shetty','269','18','City of Thane','New Delhi','Delhi','110094',190),('D1087430','8068912346','Ramphal Arora','232','4','Benipur','New Delhi','Delhi','110070',146),('D1087432','9144726857','Chajju Venkatesh','291','5','Prayagraj','New Delhi','Delhi','110016',151),('D1087434','8033417208','Nikhad Pandya','115','11','Sewlakhas Nagar','New Delhi','Delhi','110029',14),('D1087436','8183629768','Vinayak Dhawan','23','6','Jalna','New Delhi','Delhi','110056',86),('D1087438','8163767867','Nancy Prashad','257','28','Chandra Nagar','New Delhi','Delhi','110093',184),('D1087440','9504091005','Sikender Talwar','65','22','Aamby Valley City','New Delhi','Delhi','110098',45),('D1087442','8066172607','Sabnur Chand','130','7','Andheri','New Delhi','Delhi','110062',34),('D1087444','9043444458','Shavani Malhotra','92','25','Chitradurga','New Delhi','Delhi','110093',189),('D1087446','8027822576','Imam Dube','68','17','Narsipatnam','New Delhi','Delhi','110029',171),('D1087448','9058608703','Surekha Thaman','229','13','Ajnala','New Delhi','Delhi','110077',168);
/*!40000 ALTER TABLE `Donor` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Temporary view structure for view `DonorDetails`
--
DROP TABLE IF EXISTS `DonorDetails`;
/*!50001 DROP VIEW IF EXISTS `DonorDetails`*/;
SET @saved_cs_client = @@character_set_client;
/*!50503 SET character_set_client = utf8mb4 */;
/*!50001 CREATE VIEW `DonorDetails` AS SELECT
1 AS `donorID`,
1 AS `phone`,
1 AS `name`,
1 AS `state`,
1 AS `points`*/;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `Food`
--
DROP TABLE IF EXISTS `Food`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Food` (
`itemID` varchar(8) NOT NULL,
`name` varchar(100) NOT NULL,
`price` decimal(7,2) NOT NULL,
`isAvailable` tinyint(1) NOT NULL DEFAULT '1',
`imagePath` varchar(200) DEFAULT NULL,
`isVeg` tinyint(1) NOT NULL,
`category` varchar(20) DEFAULT NULL,
`discount` int DEFAULT '0',
`restaurantID` varchar(8) NOT NULL,
PRIMARY KEY (`itemID`),
KEY `restaurantID` (`restaurantID`),
KEY `served_by` (`restaurantID`),
CONSTRAINT `Food_ibfk_1` FOREIGN KEY (`restaurantID`) REFERENCES `Restaurant` (`restaurantID`),
CONSTRAINT `Food_chk_1` CHECK (((`category` = _utf8mb4'Dessert') or (`category` = _utf8mb4'Main Course') or (`category` = _utf8mb4'Beverage') or (`category` = _utf8mb4'Starter')))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Food`
--
LOCK TABLES `Food` WRITE;
/*!40000 ALTER TABLE `Food` DISABLE KEYS */;
INSERT INTO `Food` VALUES ('F007801','Paneer Cutlet',150.00,1,'',1,'Starter',19,'R002176'),('F007802','Paneer Tikka',120.00,1,'',1,'Starter',7,'R002196'),('F007803','French Fries',70.00,1,'',1,'Starter',26,'R002177'),('F007804','Pav Bhaji',60.00,1,'',1,'Starter',22,'R002168'),('F007805','Samosa',15.00,1,'',1,'Starter',25,'R002153'),('F007806','Hara Bhara Kabab',250.00,1,'',1,'Starter',13,'R002155'),('F007807','Veg Chowmein',70.00,1,'',1,'Starter',3,'R002158'),('F007808','Chilli Garlic Chowmein',100.00,1,'',1,'Starter',3,'R002176'),('F007809','Pan Fried Noodles',300.00,1,'',1,'Starter',19,'R002183'),('F007810','Hakka Noodles',230.00,1,'',1,'Starter',22,'R002163'),('F007811','Singapore Style Noodles',230.00,1,'',1,'Starter',5,'R002187'),('F007812','Gobi Manchurian',250.00,1,'',1,'Starter',3,'R002181'),('F007813','Godi 65',250.00,1,'',1,'Starter',22,'R002171'),('F007814','Cheese Balls',70.00,1,'',1,'Starter',3,'R002150'),('F007815','Chilli Potatoes',120.00,1,'',1,'Starter',9,'R002151'),('F007816','Ragada Patties',30.00,1,'',1,'Starter',6,'R002173'),('F007817','Paneer 65',150.00,1,'',1,'Starter',4,'R002198'),('F007818','Crispy Corn',120.00,1,'',1,'Starter',16,'R002170'),('F007819','Chilli Mushrooms',120.00,1,'',1,'Starter',17,'R002190'),('F007820','Veg Momos',80.00,1,'',1,'Starter',10,'R002198'),('F007821','Paneer Momos',100.00,1,'',1,'Starter',16,'R002191'),('F007822','Veg Roll',40.00,1,'',1,'Starter',15,'R002165'),('F007823','Paneer Roll',60.00,1,'',1,'Starter',5,'R002157'),('F007824','Manchow Soup',130.00,1,'',1,'Starter',14,'R002162'),('F007825','Sweat Corn Soup',130.00,1,'',1,'Starter',13,'R002172'),('F007826','Hot N Sour Soup',130.00,1,'',1,'Starter',14,'R002153'),('F007827','Lemon and Coriander',150.00,1,'',1,'Starter',12,'R002167'),('F007828','Talumein Soup',150.00,1,'',1,'Starter',5,'R002166'),('F007829','Egg Roll',40.00,1,'',0,'Starter',11,'R002192'),('F007830','Chicken Roll',60.00,1,'',0,'Starter',3,'R002159'),('F007831','Kabab Roll',70.00,1,'',0,'Starter',21,'R002154'),('F007832','Chicken Momos',100.00,1,'',0,'Starter',20,'R002197'),('F007833','Egg Chowmein',120.00,1,'',0,'Starter',8,'R002177'),('F007834','Chicken Chowmein',150.00,1,'',0,'Starter',19,'R002155'),('F007835','Chilli Chicken',230.00,1,'',0,'Starter',24,'R002164'),('F007836','Tanduri Chicken',250.00,1,'',0,'Starter',11,'R002163'),('F007837','Chicken Kabab',250.00,1,'',0,'Starter',24,'R002175'),('F007838','Mutton Kabab',390.00,1,'',0,'Starter',1,'R002192'),('F007839','Chicken Afghani',300.00,1,'',0,'Starter',6,'R002159'),('F007840','Chicken 65',300.00,1,'',0,'Starter',24,'R002162'),('F007841','Prawns',280.00,1,'',0,'Starter',7,'R002165'),('F007842','chilli prawns',300.00,1,'',0,'Starter',7,'R002189'),('F007843','Chicken Nuggets',300.00,1,'',0,'Starter',26,'R002184'),('F007844','Mutton Skewers',360.00,1,'',0,'Starter',19,'R002172'),('F007845','Chicken Wings',250.00,1,'',0,'Starter',3,'R002152'),('F007846','Chicken Lollipop',250.00,1,'',0,'Starter',13,'R002160'),('F007847','Tangeri kabab',260.00,1,'',0,'Starter',10,'R002170'),('F007848','fish cutlet',280.00,1,'',0,'Starter',20,'R002193'),('F007849','Fish Fingers',280.00,1,'',0,'Starter',5,'R002181'),('F007850','Uttapam',70.00,1,'',1,'Main Course',4,'R002160'),('F007851','Dosa',60.00,1,'',1,'Main Course',3,'R002159'),('F007852','Masala Dosa',70.00,1,'',1,'Main Course',23,'R002150'),('F007853','Sambhar Vada',50.00,1,'',1,'Main Course',16,'R002174'),('F007854','Sambhar Idli',50.00,1,'',1,'Main Course',6,'R002187'),('F007855','Sambhar Rice',50.00,1,'',1,'Main Course',25,'R002181'),('F007856','Upma',60.00,1,'',1,'Main Course',13,'R002160'),('F007857','Mutter Paneer',250.00,1,'',1,'Main Course',23,'R002171'),('F007858','Mutter Masala',250.00,1,'',1,'Main Course',25,'R002166'),('F007859','Shahi Paneer',320.00,1,'',1,'Main Course',1,'R002161'),('F007860','Paneer Masala',300.00,1,'',1,'Main Course',4,'R002159'),('F007861','Tawa Paneer',300.00,1,'',1,'Main Course',10,'R002171'),('F007862','Handi Paneer',300.00,1,'',1,'Main Course',17,'R002155'),('F007863','Kadhai Paneer',300.00,1,'',1,'Main Course',10,'R002175'),('F007864','Paneer Lababdaar',280.00,1,'',1,'Main Course',5,'R002191'),('F007865','Paneer Do Pyaza',280.00,1,'',1,'Main Course',21,'R002187'),('F007866','Paneer Bhurji',280.00,1,'',1,'Main Course',11,'R002198'),('F007867','Pannner Nawabi',320.00,1,'',1,'Main Course',19,'R002168'),('F007868','Paneer Butter Masala',320.00,1,'',1,'Main Course',5,'R002170'),('F007869','Paneer Jaipuri',320.00,1,'',1,'Main Course',23,'R002153'),('F007870','Palak Paneer',250.00,1,'',1,'Main Course',8,'R002161'),('F007871','Paneer Korma',250.00,1,'',1,'Main Course',12,'R002180'),('F007872','Malai Kofta',150.00,1,'',1,'Main Course',18,'R002171'),('F007873','Mushroom Masala',200.00,1,'',1,'Main Course',8,'R002185'),('F007874','Tawa Chaap',200.00,1,'',1,'Main Course',17,'R002166'),('F007875','Aloo Gobi',130.00,1,'',1,'Main Course',21,'R002198'),('F007876','Kashmiri Gobi',130.00,1,'',1,'Main Course',25,'R002185'),('F007877','Gobi Masala',130.00,1,'',1,'Main Course',13,'R002197'),('F007878','Special Bharta',120.00,1,'',1,'Main Course',11,'R002177'),('F007879','Palak Kofta',150.00,1,'',1,'Main Course',4,'R002158'),('F007880','Mix Veg',110.00,1,'',1,'Main Course',20,'R002198'),('F007881','Chana Masala',140.00,1,'',1,'Main Course',3,'R002157'),('F007882','Aloo Palak',100.00,1,'',1,'Main Course',25,'R002184'),('F007883','Palak Chaap',150.00,1,'',1,'Main Course',6,'R002177'),('F007884','Jeera Aloo',80.00,1,'',1,'Main Course',4,'R002164'),('F007885','Dum Aloo',110.00,1,'',1,'Main Course',6,'R002181'),('F007886','Rajma',180.00,1,'',1,'Main Course',14,'R002197'),('F007887','Veg Korma',180.00,1,'',1,'Main Course',23,'R002189'),('F007888','Chaap Korma',180.00,1,'',1,'Main Course',17,'R002151'),('F007889','Dal Tadka',180.00,1,'',1,'Main Course',11,'R002191'),('F007890','Coke',60.00,1,'',1,'Beverage',22,'R002189'),('F007891','Lemonade',150.00,1,'',1,'Beverage',23,'R002170'),('F007892','Lassi',100.00,1,'',1,'Beverage',20,'R002153'),('F007893','Sprite',60.00,1,'',1,'Beverage',18,'R002179'),('F007894','Mirinda',60.00,1,'',1,'Beverage',11,'R002169'),('F007895','chachh',250.00,1,'',1,'Beverage',22,'R002171'),('F007896','Thandi Lassi',125.00,1,'',1,'Beverage',2,'R002150'),('F007897','Kadhai Chicken',520.00,1,'',0,'Main Course',18,'R002157'),('F007898','Rara Chicken',520.00,1,'',0,'Main Course',11,'R002162'),('F007899','Chicken Amritsari',520.00,1,'',0,'Main Course',10,'R002172'),('F007900','Patiala Chicken',520.00,1,'',0,'Main Course',17,'R002161'),('F007902','Chicken Lababdar',500.00,1,'',0,'Main Course',2,'R002171'),('F007903','Chicken Do Pyaza',500.00,1,'',0,'Main Course',14,'R002172'),('F007904','Beliram Chicken',450.00,1,'',0,'Main Course',26,'R002191'),('F007905','Hara Bhara Murga',450.00,1,'',0,'Main Course',25,'R002183'),('F007906','Lemon Chicken',450.00,1,'',0,'Main Course',26,'R002182'),('F007907','Chicken Bhuna',450.00,1,'',0,'Main Course',8,'R002194'),('F007908','Egg Bhurji',250.00,1,'',0,'Main Course',24,'R002189'),('F007909','Egg Curry',250.00,1,'',0,'Main Course',25,'R002196'),('F007910','Egg Palak',250.00,1,'',0,'Main Course',9,'R002177'),('F007911','Egg Keema Chicken',300.00,1,'',0,'Main Course',20,'R002174'),('F007912','Rara Mutton',600.00,1,'',0,'Main Course',22,'R002181'),('F007913','Handi Mutton',600.00,1,'',0,'Main Course',24,'R002198'),('F007914','Kadhai Mutton',600.00,1,'',0,'Main Course',18,'R002188'),('F007915','Bhuna Gosht',600.00,1,'',0,'Main Course',15,'R002176'),('F007916','Mutton Rogan Josh',650.00,1,'',0,'Main Course',20,'R002156'),('F007917','Mutton Do Pyaza',650.00,1,'',0,'Main Course',17,'R002178'),('F007918','Mutton Makhani',650.00,1,'',0,'Main Course',13,'R002190'),('F007919','Brain Curry',650.00,1,'',0,'Main Course',18,'R002164'),('F007920','Mutton Seekh Masala',650.00,1,'',0,'Main Course',6,'R002182'),('F007921','Mutton Keema',650.00,1,'',0,'Main Course',21,'R002196'),('F007922','Fish Curry',500.00,1,'',0,'Main Course',20,'R002167'),('F007923','Egg Biriayani',280.00,1,'',0,'Main Course',10,'R002177'),('F007924','Chicken Biriyani',320.00,1,'',0,'Main Course',4,'R002165'),('F007925','Mutton Biriyani',400.00,1,'',0,'Main Course',17,'R002190'),('F007926','Hyderabadi Dum Biriyani',400.00,1,'',0,'Main Course',8,'R002173'),('F007927','Plain Rice',200.00,1,'',1,'Main Course',21,'R002197'),('F007928','Jeera Rice',220.00,1,'',1,'Main Course',7,'R002186'),('F007929','Tawa Roti',7.00,1,'',1,'Main Course',5,'R002152'),('F007930','Butter Roti',10.00,1,'',1,'Main Course',21,'R002162'),('F007931','Plain Naan',25.00,1,'',1,'Main Course',17,'R002181'),('F007932','Butter Naan',30.00,1,'',1,'Main Course',8,'R002160'),('F007933','Garlic Naan',40.00,1,'',1,'Main Course',13,'R002170'),('F007934','Cheese Naan',50.00,1,'',1,'Main Course',22,'R002186'),('F007935','Tandoori Roti',10.00,1,'',1,'Main Course',16,'R002196'),('F007936','Tandoori Butter Roti',15.00,1,'',1,'Main Course',9,'R002191'),('F007937','Rumali Roti',20.00,1,'',1,'Main Course',19,'R002191'),('F007938','Lacha Paratha',20.00,1,'',1,'Main Course',11,'R002158'),('F007939','Fruit Custard',120.00,1,'',1,'Dessert',9,'R002168'),('F007940','Vanilla Ice Cream',90.00,1,'',1,'Dessert',13,'R002163'),('F007941','Chocolate IceCream',150.00,1,'',1,'Dessert',16,'R002156'),('F007942','Strawberry Punch',190.00,1,'',1,'Dessert',5,'R002150'),('F007943','Chocolate Mousse',140.00,1,'',0,'Dessert',3,'R002179'),('F007944','Pastries',90.00,1,'',0,'Dessert',11,'R002190'),('F007945','Molten Choco Burst',180.00,1,'',0,'Dessert',18,'R002171'),('F007946','Choco Lava Cake',160.00,1,'',0,'Dessert',4,'R002152'),('F007947','Brownies',100.00,1,'',0,'Dessert',15,'R002190'),('F007948','Red Velvet Jar',210.00,1,'',1,'Dessert',24,'R002198'),('F007949','Gulab Jamun',80.00,1,'',1,'Dessert',21,'R002187'),('F007950','Jalebi',80.00,1,'',1,'Dessert',25,'R002150'),('F007951','Kaju Katli',500.00,1,'',1,'Dessert',3,'R002154'),('F007952','Gajar Ka Halwa',260.00,1,'',1,'Dessert',22,'R002154'),('F007953','Chilli Paneer',250.00,1,'',1,'Starter',23,'R002177'),('F007954','Paneer Cutlet',150.00,1,'',1,'Starter',22,'R002163'),('F007955','Paneer Tikka',120.00,1,'',1,'Starter',22,'R002159'),('F007956','French Fries',70.00,1,'',1,'Starter',8,'R002168'),('F007957','Pav Bhaji',60.00,1,'',1,'Starter',24,'R002158'),('F007958','Samosa',15.00,1,'',1,'Starter',21,'R002192'),('F007959','Hara Bhara Kabab',250.00,1,'',1,'Starter',19,'R002154'),('F007960','Veg Chowmein',70.00,1,'',1,'Starter',13,'R002164'),('F007961','Chilli Garlic Chowmein',100.00,1,'',1,'Starter',3,'R002169'),('F007962','Pan Fried Noodles',300.00,1,'',1,'Starter',12,'R002179'),('F007963','Hakka Noodles',230.00,1,'',1,'Starter',6,'R002183'),('F007964','Singapore Style Noodles',230.00,1,'',1,'Starter',16,'R002186'),('F007965','Gobi Manchurian',250.00,1,'',1,'Starter',26,'R002188'),('F007966','Godi 65',250.00,1,'',1,'Starter',17,'R002156'),('F007967','Cheese Balls',70.00,1,'',1,'Starter',5,'R002194'),('F007968','Chilli Potatoes',120.00,1,'',1,'Starter',4,'R002179'),('F007969','Ragada Patties',30.00,1,'',1,'Starter',11,'R002186'),('F007970','Paneer 65',150.00,1,'',1,'Starter',11,'R002187'),('F007971','Crispy Corn',120.00,1,'',1,'Starter',7,'R002163'),('F007972','Chilli Mushrooms',120.00,1,'',1,'Starter',10,'R002195'),('F007973','Veg Momos',80.00,1,'',1,'Starter',26,'R002156'),('F007974','Paneer Momos',100.00,1,'',1,'Starter',17,'R002152'),('F007975','Veg Roll',40.00,1,'',1,'Starter',9,'R002173'),('F007976','Paneer Roll',60.00,1,'',1,'Starter',18,'R002150'),('F007977','Manchow Soup',130.00,1,'',1,'Starter',18,'R002169'),('F007978','Sweat Corn Soup',130.00,1,'',1,'Starter',16,'R002195'),('F007979','Hot N Sour Soup',130.00,1,'',1,'Starter',6,'R002170'),('F007980','Lemon and Coriander',150.00,1,'',1,'Starter',24,'R002193'),('F007981','Talumein Soup',150.00,1,'',1,'Starter',9,'R002179'),('F007982','Egg Roll',40.00,1,'',0,'Starter',12,'R002153'),('F007983','Chicken Roll',60.00,1,'',0,'Starter',10,'R002165'),('F007984','Kabab Roll',70.00,1,'',0,'Starter',4,'R002155'),('F007985','Chicken Momos',100.00,1,'',0,'Starter',5,'R002187'),('F007986','Egg Chowmein',120.00,1,'',0,'Starter',10,'R002172'),('F007987','Chicken Chowmein',150.00,1,'',0,'Starter',16,'R002192'),('F007988','Chilli Chicken',230.00,1,'',0,'Starter',5,'R002187'),('F007989','Tanduri Chicken',250.00,1,'',0,'Starter',5,'R002182'),('F007990','Chicken Kabab',250.00,1,'',0,'Starter',1,'R002197'),('F007991','Mutton Kabab',390.00,1,'',0,'Starter',6,'R002182'),('F007992','Chicken Afghani',300.00,1,'',0,'Starter',20,'R002184'),('F007993','Chicken 65',300.00,1,'',0,'Starter',7,'R002160'),('F007994','Prawns',280.00,1,'',0,'Starter',5,'R002187'),('F007995','chilli prawns',300.00,1,'',0,'Starter',14,'R002168'),('F007996','Chicken Nuggets',300.00,1,'',0,'Starter',15,'R002190'),('F007998','Chicken Wings',250.00,1,'',0,'Starter',26,'R002167'),('F007999','Chicken Lollipop',250.00,1,'',0,'Starter',21,'R002168'),('F008000','Tangeri kabab',260.00,1,'',0,'Starter',13,'R002186'),('F008001','fish cutlet',280.00,1,'',0,'Starter',15,'R002164'),('F008002','Fish Fingers',280.00,1,'',0,'Starter',17,'R002176'),('F008003','Uttapam',70.00,1,'',1,'Main Course',25,'R002180'),('F008004','Dosa',60.00,1,'',1,'Main Course',11,'R002169'),('F008005','Masala Dosa',70.00,1,'',1,'Main Course',21,'R002188'),('F008006','Sambhar Vada',50.00,1,'',1,'Main Course',3,'R002163'),('F008007','Sambhar Idli',50.00,1,'',1,'Main Course',26,'R002157'),('F008008','Sambhar Rice',50.00,1,'',1,'Main Course',10,'R002176'),('F008009','Upma',60.00,1,'',1,'Main Course',16,'R002176'),('F008010','Mutter Paneer',250.00,1,'',1,'Main Course',19,'R002173'),('F008011','Mutter Masala',250.00,1,'',1,'Main Course',8,'R002159'),('F008012','Shahi Paneer',320.00,1,'',1,'Main Course',7,'R002165'),('F008013','Paneer Masala',300.00,1,'',1,'Main Course',1,'R002183'),('F008014','Tawa Paneer',300.00,1,'',1,'Main Course',1,'R002155'),('F008015','Handi Paneer',300.00,1,'',1,'Main Course',3,'R002177'),('F008016','Kadhai Paneer',300.00,1,'',1,'Main Course',15,'R002194'),('F008017','Paneer Lababdaar',280.00,1,'',1,'Main Course',8,'R002168'),('F008018','Paneer Do Pyaza',280.00,1,'',1,'Main Course',19,'R002190'),('F008019','Paneer Bhurji',280.00,1,'',1,'Main Course',3,'R002155'),('F008020','Pannner Nawabi',320.00,1,'',1,'Main Course',20,'R002154'),('F008021','Paneer Butter Masala',320.00,1,'',1,'Main Course',3,'R002179'),('F008022','Paneer Jaipuri',320.00,1,'',1,'Main Course',25,'R002188'),('F008023','Palak Paneer',250.00,1,'',1,'Main Course',21,'R002155'),('F008024','Paneer Korma',250.00,1,'',1,'Main Course',22,'R002155'),('F008025','Malai Kofta',150.00,1,'',1,'Main Course',22,'R002190'),('F008026','Mushroom Masala',200.00,1,'',1,'Main Course',25,'R002197'),('F008027','Tawa Chaap',200.00,1,'',1,'Main Course',6,'R002162'),('F008028','Aloo Gobi',130.00,1,'',1,'Main Course',21,'R002188'),('F008029','Kashmiri Gobi',130.00,1,'',1,'Main Course',10,'R002170'),('F008030','Gobi Masala',130.00,1,'',1,'Main Course',11,'R002168'),('F008031','Special Bharta',120.00,1,'',1,'Main Course',13,'R002181'),('F008032','Palak Kofta',150.00,1,'',1,'Main Course',1,'R002190'),('F008033','Mix Veg',110.00,1,'',1,'Main Course',21,'R002155'),('F008034','Chana Masala',140.00,1,'',1,'Main Course',3,'R002186'),('F008036','Palak Chaap',150.00,1,'',1,'Main Course',19,'R002166'),('F008037','Jeera Aloo',80.00,1,'',1,'Main Course',9,'R002190'),('F008038','Dum Aloo',110.00,1,'',1,'Main Course',26,'R002198'),('F008039','Rajma',180.00,1,'',1,'Main Course',12,'R002183'),('F008040','Veg Korma',180.00,1,'',1,'Main Course',12,'R002170'),('F008041','Chaap Korma',180.00,1,'',1,'Main Course',20,'R002177'),('F008042','Dal Tadka',180.00,1,'',1,'Main Course',24,'R002174'),('F008043','Coke',60.00,1,'',1,'Beverage',14,'R002170'),('F008044','Lemonade',150.00,1,'',1,'Beverage',15,'R002185'),('F008045','Lassi',100.00,1,'',1,'Beverage',26,'R002150'),('F008046','Sprite',60.00,1,'',1,'Beverage',19,'R002157'),('F008047','Mirinda',60.00,1,'',1,'Beverage',10,'R002171'),('F008048','chachh',250.00,1,'',1,'Beverage',12,'R002179'),('F008049','Thandi Lassi',125.00,1,'',1,'Beverage',22,'R002197'),('F008050','Kadhai Chicken',520.00,1,'',0,'Main Course',14,'R002169'),('F008051','Rara Chicken',520.00,1,'',0,'Main Course',7,'R002163'),('F008052','Chicken Amritsari',520.00,1,'',0,'Main Course',7,'R002191'),('F008053','Patiala Chicken',520.00,1,'',0,'Main Course',24,'R002185'),('F008054','Chicken Seekh Masala',500.00,1,'',0,'Main Course',9,'R002194'),('F008055','Chicken Lababdar',500.00,1,'',0,'Main Course',25,'R002155'),('F008056','Chicken Do Pyaza',500.00,1,'',0,'Main Course',11,'R002174'),('F008057','Beliram Chicken',450.00,1,'',0,'Main Course',19,'R002181'),('F008058','Hara Bhara Murga',450.00,1,'',0,'Main Course',14,'R002170'),('F008059','Lemon Chicken',450.00,1,'',0,'Main Course',13,'R002196'),('F008060','Chicken Bhuna',450.00,1,'',0,'Main Course',2,'R002163'),('F008061','Egg Bhurji',250.00,1,'',0,'Main Course',24,'R002193'),('F008062','Egg Curry',250.00,1,'',0,'Main Course',26,'R002190'),('F008063','Egg Palak',250.00,1,'',0,'Main Course',12,'R002173'),('F008064','Egg Keema Chicken',300.00,1,'',0,'Main Course',24,'R002196'),('F008065','Rara Mutton',600.00,1,'',0,'Main Course',5,'R002183'),('F008066','Handi Mutton',600.00,1,'',0,'Main Course',15,'R002155'),('F008067','Kadhai Mutton',600.00,1,'',0,'Main Course',12,'R002154'),('F008068','Bhuna Gosht',600.00,1,'',0,'Main Course',17,'R002161'),('F008069','Mutton Rogan Josh',650.00,1,'',0,'Main Course',15,'R002186'),('F008070','Mutton Do Pyaza',650.00,1,'',0,'Main Course',21,'R002156'),('F008071','Mutton Makhani',650.00,1,'',0,'Main Course',5,'R002195'),('F008072','Brain Curry',650.00,1,'',0,'Main Course',26,'R002151'),('F008073','Mutton Seekh Masala',650.00,1,'',0,'Main Course',21,'R002165'),('F008074','Mutton Keema',650.00,1,'',0,'Main Course',3,'R002165'),('F008075','Fish Curry',500.00,1,'',0,'Main Course',9,'R002162'),('F008076','Egg Biriayani',280.00,1,'',0,'Main Course',3,'R002175'),('F008077','Chicken Biriyani',320.00,1,'',0,'Main Course',11,'R002150'),('F008078','Mutton Biriyani',400.00,1,'',0,'Main Course',11,'R002185'),('F008079','Hyderabadi Dum Biriyani',400.00,1,'',0,'Main Course',13,'R002160'),('F008080','Plain Rice',200.00,1,'',1,'Main Course',10,'R002159'),('F008081','Jeera Rice',220.00,1,'',1,'Main Course',6,'R002182'),('F008082','Tawa Roti',7.00,1,'',1,'Main Course',17,'R002195'),('F008083','Butter Roti',10.00,1,'',1,'Main Course',25,'R002195'),('F008084','Plain Naan',25.00,1,'',1,'Main Course',15,'R002172'),('F008085','Butter Naan',30.00,1,'',1,'Main Course',3,'R002191'),('F008086','Garlic Naan',40.00,1,'',1,'Main Course',9,'R002163'),('F008087','Cheese Naan',50.00,1,'',1,'Main Course',2,'R002171'),('F008088','Tandoori Roti',10.00,1,'',1,'Main Course',13,'R002198'),('F008089','Tandoori Butter Roti',15.00,1,'',1,'Main Course',18,'R002197'),('F008090','Rumali Roti',20.00,1,'',1,'Main Course',4,'R002169'),('F008091','Lacha Paratha',20.00,1,'',1,'Main Course',26,'R002174'),('F008092','Fruit Custard',120.00,1,'',1,'Dessert',23,'R002185'),('F008093','Vanilla Ice Cream',90.00,1,'',1,'Dessert',15,'R002197'),('F008094','Chocolate IceCream',150.00,1,'',1,'Dessert',17,'R002155'),('F008095','Strawberry Punch',190.00,1,'',1,'Dessert',25,'R002194'),('F008096','Chocolate Mousse',140.00,1,'',0,'Dessert',5,'R002155'),('F008097','Pastries',90.00,1,'',0,'Dessert',12,'R002160'),('F008098','Molten Choco Burst',180.00,1,'',0,'Dessert',14,'R002155'),('F008099','Choco Lava Cake',160.00,1,'',0,'Dessert',10,'R002198'),('F008100','Brownies',100.00,1,'',0,'Dessert',2,'R002162'),('F008101','Red Velvet Jar',210.00,1,'',1,'Dessert',22,'R002164'),('F008102','Gulab Jamun',80.00,1,'',1,'Dessert',7,'R002155'),('F008103','Jalebi',80.00,1,'',1,'Dessert',26,'R002170'),('F008104','Kaju Katli',500.00,1,'',1,'Dessert',21,'R002183'),('F008105','Gajar Ka Halwa',260.00,1,'',1,'Dessert',20,'R002198');
/*!40000 ALTER TABLE `Food` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Management`
--
DROP TABLE IF EXISTS `Management`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Management` (
`employeeID` varchar(8) NOT NULL,
`fName` varchar(20) NOT NULL,
`lName` varchar(20) NOT NULL,
`phone` char(10) NOT NULL,
`salary` int NOT NULL,
`hNo` varchar(6) NOT NULL,
`street` varchar(20) DEFAULT NULL,
`area` varchar(20) NOT NULL,
`city` varchar(20) NOT NULL,
`state` varchar(20) NOT NULL,
`pin` char(6) NOT NULL,
`designation` varchar(50) NOT NULL,
`dob` date NOT NULL,
PRIMARY KEY (`employeeID`),
UNIQUE KEY `phone` (`phone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Management`
--
LOCK TABLES `Management` WRITE;
/*!40000 ALTER TABLE `Management` DISABLE KEYS */;
INSERT INTO `Management` VALUES ('S540989','Amrudin','Khan','8151606180',18000,'44','3','Baba Bakala','New Delhi','Delhi','110079','Assistant Operations Manager','1999-07-24'),('S540990','Sayana','Malik','8135733333',18000,'264','1','Aamby Valley City','New Delhi','Delhi','110044','Assistant Operations Manager','1992-12-12'),('S540991','Budhi','Thakkar','9151773815',19500,'130','22','Modinagar','New Delhi','Delhi','110014','Assistant Operations Manager','1993-08-05'),('S540992','Dulichand','Setty','9157460710',19500,'92','12','Gomti Nagar','New Delhi','Delhi','110081','Assistant manager','1999-06-14'),('S540993','Khajan','Thaker','9138257445',19500,'238','17','Jalna','New Delhi','Delhi','110082','Assistant manager','1992-12-01'),('S540994','Binnu','Chakraborty','9168983353',19500,'177','11','Bally','New Delhi','Delhi','110027','Assistant manager','1975-05-18'),('S540995','Ajaypal','Arya','9185335054',19500,'175','17','Chandra Nagar','New Delhi','Delhi','110031','Assistant manager','1982-11-09'),('S540996','Koilu','Pall','9162571972',23000,'136','10','Rajgarh','New Delhi','Delhi','110056','Associate manager','1981-07-27'),('S540997','Chandu','Varghese','9162180931',26000,'102','2','Aamby Valley City','New Delhi','Delhi','110048','Coordinator','1995-06-26'),('S540998','Satendra','Prabhu','9177576318',26000,'138','26','Shivaji Nagar','New Delhi','Delhi','110046','Coordinator','1984-04-11'),('S540999','Kusum','Sehgal','8193479439',18000,'250','10','Andheri','New Delhi','Delhi','110084','Management trainee','1978-08-03'),('S541000','Bhulan','Sankaran','8198207421',15600,'298','11','Gondal','New Delhi','Delhi','110008','Shift manager','1992-03-23'),('S541001','Dhananjay','Bajaj','9188857515',23000,'188','16','Chitradurga','New Delhi','Delhi','110014','Associate manager','1998-03-28'),('S541002','Priti','Doshi','8187963638',19500,'243','12','Vigyan Nagar','New Delhi','Delhi','110022','Head of marketing','1989-05-07'),('S541003','Sanjai','Datta','8183700945',19500,'260','18','Narsipatnam','New Delhi','Delhi','110076','Assistant manager','1985-08-08'),('S541004','Parmjeet','Dhawan','8154190531',18000,'184','15','Vasai','New Delhi','Delhi','110063','Head of operations','1986-10-03'),('S541005','Karma','Ganguly','9135906646',23000,'163','18','Mangalagiri','New Delhi','Delhi','110098','Associate manager','1996-05-08'),('S541006','Vashudev','Prashad','9140700390',18000,'7','5','Ajnala','New Delhi','Delhi','110016','Management trainee','1997-06-29'),('S541007','Sayana','Vaidya','9180349902',19500,'12','15','Ahmedabad','New Delhi','Delhi','110092','Accountant','2000-01-07'),('S541008','Budhi','Talwar','9195497953',26000,'84','2','Vigyan Nagar','New Delhi','Delhi','110090','General manager','1998-12-07'),('S541009','Dulichand','Sekhon','9168678054',23000,'81','12','Ahmedabad','New Delhi','Delhi','110085','Associate manager','1988-08-23'),('S541010','Khajan','Chand','9163523740',19500,'211','7','Lekha Nagar','New Delhi','Delhi','110040','Junior accountant','1977-11-04'),('S541011','Chandni','Bhattacharyya','8195962781',18000,'91','8','Rajgarh','New Delhi','Delhi','110043','Chartered Accountant','1993-09-09'),('S541012','Naina','Malhotra','8181872937',19500,'270','13','Sudder Street','New Delhi','Delhi','110011','Assistant manager','1986-02-16'),('S541013','Umlesh','Yohannan','9171449960',23000,'42','30','Chinchwad','New Delhi','Delhi','110065','Associate manager','1981-06-29'),('S541014','Lajjavati','Dube','8143350784',19500,'53','9','Fatehpur Sikri','New Delhi','Delhi','110031','Operations Manager','1975-12-22'),('S541015','Pachuram','Vala','9143812225',19500,'209','24','Mangalagiri','New Delhi','Delhi','110077','CFO','1986-11-11'),('S541016','Gori','Thaman','8165933782',18000,'45','3','Raisen','New Delhi','Delhi','110044','CEO','1982-11-25');
/*!40000 ALTER TABLE `Management` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Temporary view structure for view `ManagementDetails`
--
DROP TABLE IF EXISTS `ManagementDetails`;
/*!50001 DROP VIEW IF EXISTS `ManagementDetails`*/;
SET @saved_cs_client = @@character_set_client;
/*!50503 SET character_set_client = utf8mb4 */;
/*!50001 CREATE VIEW `ManagementDetails` AS SELECT
1 AS `employeeID`,
1 AS `fName`,
1 AS `lName`,
1 AS `phone`,
1 AS `state`,
1 AS `dob`,
1 AS `designation`*/;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `Orders`
--
DROP TABLE IF EXISTS `Orders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Orders` (
`orderID` varchar(8) NOT NULL,
`status` varchar(20) NOT NULL DEFAULT 'Active',
`dateTime` datetime NOT NULL,
`billAmt` decimal(6,2) NOT NULL,
`paymentMode` varchar(20) NOT NULL,
`customerID` char(10) NOT NULL,
`restaurantID` varchar(8) NOT NULL,
`deliveryWorkerID` varchar(8) NOT NULL,
`discount` int DEFAULT '0',
`tip` decimal(5,2) DEFAULT (0),
PRIMARY KEY (`orderID`),
KEY `customerID` (`customerID`),
KEY `restaurantID` (`restaurantID`),
KEY `deliveryWorkerID` (`deliveryWorkerID`),
KEY `delivery` (`deliveryWorkerID`),
CONSTRAINT `Orders_ibfk_1` FOREIGN KEY (`customerID`) REFERENCES `Customer` (`phone`),
CONSTRAINT `Orders_ibfk_2` FOREIGN KEY (`restaurantID`) REFERENCES `Restaurant` (`restaurantID`),
CONSTRAINT `Orders_ibfk_3` FOREIGN KEY (`deliveryWorkerID`) REFERENCES `DeliveryWorker` (`employeeID`),
CONSTRAINT `Orders_chk_1` CHECK (((`status` = _utf8mb4'active') or (`status` = _utf8mb4'delivered')))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Orders`
--
LOCK TABLES `Orders` WRITE;
/*!40000 ALTER TABLE `Orders` DISABLE KEYS */;
INSERT INTO `Orders` VALUES ('O1201','Active','1970-01-01 00:00:00',148.00,'Paytm','8779776039','R002179','E250800',5,175.00),('O1202','Active','1970-01-01 00:00:00',90.00,'UPI','8826666390','R002191','E250800',1,330.00),('O1203','Active','1970-01-01 00:00:00',360.00,'Google Pay','8364432786','R002160','E250870',0,195.00),('O1204','Active','1970-01-01 00:00:00',125.00,'COD','8260444682','R002154','E250830',6,105.00),('O1205','Active','1970-01-01 00:00:00',458.00,'Paytm','9857569456','R002164','E250828',10,260.00),('O1206','Active','1970-01-01 00:00:00',89.00,'UPI','8281719051','R002160','E250846',4,430.00),('O1207','Active','1970-01-01 00:00:00',520.00,'Paytm','9877124785','R002192','E250870',4,130.00),('O1208','Active','1970-01-01 00:00:00',166.00,'UPI','8753386357','R002192','E250840',12,415.00),('O1209','Active','1970-01-01 00:00:00',203.00,'Google Pay','8319749948','R002173','E250890',5,95.00),('O1210','Active','1970-01-01 00:00:00',422.00,'VISA','9888568589','R002157','E250846',5,145.00),('O1211','Active','1970-01-01 00:00:00',154.00,'Paytm','8723736048','R002174','E250830',1,185.00),('O1212','Active','1970-01-01 00:00:00',620.00,'Phone Pe','8878681355','R002183','E250842',8,350.00),('O1213','Active','1970-01-01 00:00:00',102.00,'COD','8370636734','R002188','E250848',14,60.00),('O1214','Active','1970-01-01 00:00:00',504.00,'COD','8749419471','R002157','E250852',7,455.00),('O1215','Active','1970-01-01 00:00:00',356.00,'UPI','9348125654','R002185','E250882',2,230.00),('O1216','Active','1970-01-01 00:00:00',554.00,'Paytm','8343873800','R002151','E250860',7,365.00),('O1217','Active','1970-01-01 00:00:00',114.00,'Google Pay','9388587088','R002174','E250834',4,240.00),('O1218','Active','1970-01-01 00:00:00',287.00,'COD','9324511896','R002182','E250846',5,300.00),('O1219','Active','1970-01-01 00:00:00',297.00,'Paytm','9323058627','R002176','E250896',1,115.00),('O1220','Active','1970-01-01 00:00:00',344.00,'Google Pay','8760342422','R002150','E250884',12,340.00),('O1221','Active','1970-01-01 00:00:00',380.00,'Phone Pe','9322979891','R002166','E250836',14,130.00),('O1222','Active','1970-01-01 00:00:00',274.00,'UPI','8891303372','R002157','E250868',5,55.00),('O1223','Active','1970-01-01 00:00:00',602.00,'COD','9365104788','R002176','E250846',8,445.00),('O1224','Active','1970-01-01 00:00:00',554.00,'Paytm','8747853781','R002189','E250826',1,460.00),('O1225','Active','1970-01-01 00:00:00',206.00,'Paytm','9370367071','R002193','E250856',3,180.00),('O1226','Active','1970-01-01 00:00:00',389.00,'UPI','8799973366','R002188','E250862',8,335.00),('O1227','Active','1970-01-01 00:00:00',74.00,'Phone Pe','8798964827','R002189','E250860',4,275.00),('O1228','Active','1970-01-01 00:00:00',339.00,'Google Pay','8340727094','R002181','E250854',12,340.00),('O1229','Active','1970-01-01 00:00:00',272.00,'COD','9343285253','R002165','E250832',11,165.00),('O1230','Active','1970-01-01 00:00:00',187.00,'Google Pay','8238779654','R002187','E250824',7,400.00),('O1231','Active','1970-01-01 00:00:00',520.00,'UPI','8235187078','R002156','E250886',13,430.00),('O1232','Active','1970-01-01 00:00:00',156.00,'UPI','9348781766','R002169','E250890',4,270.00),('O1233','Active','1970-01-01 00:00:00',174.00,'Paytm','8793877293','R002169','E250886',4,60.00),('O1234','Active','1970-01-01 00:00:00',298.00,'VISA','9876358350','R002162','E250878',2,55.00),('O1235','Active','1970-01-01 00:00:00',400.00,'UPI','9892566135','R002167','E250844',10,300.00),('O1236','Active','1970-01-01 00:00:00',487.00,'Google Pay','9791041459','R002166','E250820',6,330.00),('O1237','Active','1970-01-01 00:00:00',629.00,'COD','8334742120','R002188','E250866',6,180.00),('O1238','Active','1970-01-01 00:00:00',807.00,'VISA','9279956787','R002166','E250876',15,165.00),('O1239','Active','1970-01-01 00:00:00',1107.00,'UPI','9719516787','R002192','E250806',7,395.00),('O1240','Active','1970-01-01 00:00:00',547.00,'Paytm','9245656425','R002167','E250836',9,415.00),('O1241','Active','1970-01-01 00:00:00',268.00,'Phone Pe','8248731914','R002150','E250828',12,430.00),('O1242','Active','1970-01-01 00:00:00',362.00,'UPI','8244582810','R002189','E250810',2,465.00),('O1243','Active','1970-01-01 00:00:00',189.00,'Google Pay','8326911298','R002180','E250854',5,120.00),('O1244','Active','1970-01-01 00:00:00',96.00,'Paytm','8250784389','R002197','E250802',14,415.00),('O1245','Active','1970-01-01 00:00:00',245.00,'VISA','9221298131','R002192','E250818',7,220.00),('O1246','Active','1970-01-01 00:00:00',466.00,'UPI','8360232680','R002186','E250858',7,465.00),('O1247','Active','1970-01-01 00:00:00',561.00,'COD','8357223451','R002150','E250826',9,125.00),('O1248','Active','1970-01-01 00:00:00',466.00,'Google Pay','9236479507','R002174','E250836',3,320.00),('O1249','Active','1970-01-01 00:00:00',466.00,'Paytm','8836925784','R002192','E250890',7,160.00),('O1250','Active','1970-01-01 00:00:00',264.00,'Paytm','9311305685','R002172','E250892',13,330.00),('O1251','Active','1970-01-01 00:00:00',255.00,'Google Pay','8253226127','R002176','E250870',2,280.00),('O1252','Active','1970-01-01 00:00:00',1009.00,'VISA','8737219123','R002182','E250848',2,425.00),('O1253','Active','1970-01-01 00:00:00',664.00,'COD','8223676845','R002172','E250812',5,470.00),('O1254','Active','1970-01-01 00:00:00',334.00,'Phone Pe','9789978513','R002186','E250858',11,175.00),('O1255','Active','1970-01-01 00:00:00',643.00,'UPI','8870973947','R002162','E250858',14,345.00),('O1256','Active','1970-01-01 00:00:00',364.00,'Google Pay','9790538045','R002186','E250816',8,245.00),('O1257','Active','1970-01-01 00:00:00',696.00,'UPI','8744637223','R002160','E250840',8,390.00),('O1258','Active','1970-01-01 00:00:00',1254.00,'Paytm','8897462341','R002176','E250838',6,165.00),('O1259','Active','1970-01-01 00:00:00',664.00,'Google Pay','9892791731','R002151','E250860',5,485.00),('O1260','Active','1970-01-01 00:00:00',354.00,'Google Pay','8865228931','R002160','E250820',5,460.00),('O1261','Active','1970-01-01 00:00:00',296.00,'Paytm','8764604488','R002159','E250872',15,495.00),('O1262','Active','1970-01-01 00:00:00',224.00,'UPI','9345399131','R002160','E250822',9,85.00),('O1263','Active','1970-01-01 00:00:00',316.00,'COD','9780858351','R002191','E250818',2,90.00),('O1264','Active','1970-01-01 00:00:00',149.00,'Google Pay','8250461307','R002176','E250864',7,110.00),('O1265','Active','1970-01-01 00:00:00',413.00,'Phone Pe','8328228156','R002193','E250826',5,100.00),('O1266','Active','1970-01-01 00:00:00',334.00,'Paytm','8876874883','R002153','E250860',11,100.00),('O1267','Active','1970-01-01 00:00:00',260.00,'Google Pay','8381749123','R002198','E250866',13,260.00),('O1268','Active','1970-01-01 00:00:00',75.00,'COD','9821175217','R002165','E250870',4,280.00),('O1269','Active','1970-01-01 00:00:00',336.00,'Paytm','9891597562','R002172','E250864',4,325.00),('O1270','Active','1970-01-01 00:00:00',196.00,'Phone Pe','8271602066','R002168','E250826',8,50.00),('O1271','Active','1970-01-01 00:00:00',504.00,'VISA','8332685102','R002178','E250822',12,70.00),('O1272','Active','1970-01-01 00:00:00',267.00,'COD','9262878787','R002177','E250840',15,260.00),('O1273','Active','1970-01-01 00:00:00',300.00,'Google Pay','9266049720','R002186','E250836',7,75.00),('O1274','Active','1970-01-01 00:00:00',666.00,'UPI','8349334205','R002158','E250836',9,100.00),('O1275','Active','1970-01-01 00:00:00',549.00,'COD','8883448929','R002198','E250844',6,420.00),('O1276','Active','1970-01-01 00:00:00',207.00,'VISA','8781353271','R002192','E250896',6,335.00),('O1277','Active','1970-01-01 00:00:00',450.00,'Google Pay','8779918880','R002156','E250804',5,325.00),('O1278','Active','1970-01-01 00:00:00',754.00,'Google Pay','8827481250','R002155','E250860',5,205.00),('O1279','Active','1970-01-01 00:00:00',136.00,'Phone Pe','8793542612','R002151','E250812',13,500.00),('O1280','Active','1970-01-01 00:00:00',192.00,'Paytm','8737601546','R002193','E250822',0,240.00),('O1281','Active','1970-01-01 00:00:00',543.00,'COD','8856713318','R002183','E250836',6,195.00),('O1282','Active','1970-01-01 00:00:00',91.00,'COD','9768136477','R002158','E250812',9,350.00),('O1283','Active','1970-01-01 00:00:00',344.00,'VISA','8214556085','R002158','E250874',11,495.00),('O1284','Active','1970-01-01 00:00:00',322.00,'Google Pay','8731849989','R002183','E250828',11,160.00),('O1285','Active','1970-01-01 00:00:00',472.00,'UPI','9753784498','R002194','E250824',2,400.00),('O1286','Active','1970-01-01 00:00:00',210.00,'Paytm','8780872603','R002184','E250816',0,475.00),('O1287','Active','1970-01-01 00:00:00',312.00,'UPI','8225465344','R002154','E250864',9,255.00),('O1288','Active','1970-01-01 00:00:00',602.00,'Phone Pe','9750354889','R002166','E250828',5,465.00),('O1289','Active','1970-01-01 00:00:00',175.00,'UPI','8726791774','R002184','E250874',14,95.00),('O1290','Active','1970-01-01 00:00:00',431.00,'VISA','8216384380','R002162','E250874',13,400.00),('O1291','Active','1970-01-01 00:00:00',172.00,'COD','9270497728','R002177','E250810',8,335.00),('O1292','Active','1970-01-01 00:00:00',116.00,'Google Pay','8381574609','R002188','E250858',9,225.00),('O1293','Active','1970-01-01 00:00:00',409.00,'Google Pay','8391839493','R002176','E250822',4,130.00),('O1294','Active','1970-01-01 00:00:00',615.00,'Phone Pe','9217184983','R002185','E250834',5,255.00),('O1295','Active','1970-01-01 00:00:00',466.00,'Paytm','9362408274','R002152','E250880',12,105.00),('O1296','Active','1970-01-01 00:00:00',357.00,'Google Pay','8743061623','R002152','E250806',18,430.00),('O1297','Active','1970-01-01 00:00:00',564.00,'UPI','9760197861','R002182','E250874',7,185.00),('O1298','Active','1970-01-01 00:00:00',2684.00,'VISA','8786614016','R002163','E250852',3,315.00),('O1299','Active','1970-01-01 00:00:00',234.00,'Paytm','9398019429','R002157','E250868',5,390.00),('O1300','Active','1970-01-01 00:00:00',436.00,'COD','9324546523','R002160','E250822',4,100.00),('O1301','Active','1970-01-01 00:00:00',185.00,'Google Pay','8252269402','R002177','E250836',9,250.00),('O1302','Active','1970-01-01 00:00:00',436.00,'VISA','8259413178','R002190','E250848',11,190.00),('O1303','Active','1970-01-01 00:00:00',134.00,'Phone Pe','9280075034','R002158','E250842',17,295.00),('O1304','Active','1970-01-01 00:00:00',365.00,'UPI','9377349557','R002179','E250856',8,165.00),('O1305','Active','1970-01-01 00:00:00',159.00,'Paytm','8748239785','R002196','E250862',4,70.00),('O1306','Active','1970-01-01 00:00:00',364.00,'COD','9774452538','R002155','E250840',12,340.00),('O1307','Active','1970-01-01 00:00:00',284.00,'Paytm','9370356484','R002195','E250872',6,225.00),('O1308','Active','1970-01-01 00:00:00',234.00,'Google Pay','9247946673','R002157','E250816',11,110.00),('O1309','Active','1970-01-01 00:00:00',14.00,'Phone Pe','9356612424','R002154','E250850',2,100.00),('O1310','Active','1970-01-01 00:00:00',310.00,'UPI','8716423251','R002159','E250814',9,210.00),('O1311','Active','1970-01-01 00:00:00',1039.00,'Google Pay','8891141763','R002196','E250842',5,200.00),('O1312','Active','1970-01-01 00:00:00',118.00,'COD','9778557117','R002154','E250818',14,415.00),('O1313','Active','1970-01-01 00:00:00',139.00,'VISA','8345297210','R002187','E250866',11,385.00),('O1314','Active','1970-01-01 00:00:00',218.00,'Phone Pe','8830712258','R002175','E250866',12,310.00),('O1315','Active','1970-01-01 00:00:00',377.00,'Phone Pe','8254877528','R002150','E250808',7,165.00),('O1316','Active','1970-01-01 00:00:00',844.00,'Google Pay','8715761412','R002183','E250830',6,140.00),('O1317','Active','1970-01-01 00:00:00',667.00,'Google Pay','9816247236','R002170','E250816',8,100.00),('O1318','Active','1970-01-01 00:00:00',59.00,'Paytm','9395179800','R002174','E250822',4,450.00),('O1319','Active','1970-01-01 00:00:00',996.00,'VISA','8262465711','R002195','E250884',15,175.00),('O1320','Active','1970-01-01 00:00:00',504.00,'Phone Pe','8251714345','R002164','E250836',0,320.00),('O1321','Active','1970-01-01 00:00:00',334.00,'Paytm','8852632786','R002150','E250850',4,170.00),('O1322','Active','1970-01-01 00:00:00',551.00,'Google Pay','8752843845','R002188','E250844',5,335.00),('O1323','Active','1970-01-01 00:00:00',264.00,'UPI','9829692908','R002183','E250852',6,250.00),('O1324','Active','1970-01-01 00:00:00',186.00,'Phone Pe','8273283350','R002187','E250872',10,85.00),('O1325','Active','1970-01-01 00:00:00',222.00,'Phone Pe','9382432999','R002158','E250844',2,205.00),('O1326','Active','1970-01-01 00:00:00',664.00,'Google Pay','8365436688','R002186','E250840',8,295.00),('O1327','Active','1970-01-01 00:00:00',354.00,'VISA','9774452572','R002182','E250834',11,255.00),('O1328','Active','1970-01-01 00:00:00',398.00,'Google Pay','9749635297','R002163','E250870',15,325.00),('O1329','Active','1970-01-01 00:00:00',106.00,'Phone Pe','8239969188','R002163','E250858',0,120.00),('O1330','Active','1970-01-01 00:00:00',294.00,'VISA','9854756162','R002154','E250828',3,465.00),('O1331','Active','1970-01-01 00:00:00',156.00,'Google Pay','8868904661','R002150','E250848',14,415.00),('O1332','Active','1970-01-01 00:00:00',334.00,'Paytm','9324037167','R002189','E250818',8,460.00),('O1334','Active','1970-01-01 00:00:00',556.00,'UPI','8717789968','R002151','E250834',7,135.00),('O1335','Active','1970-01-01 00:00:00',789.00,'VISA','8711538567','R002151','E250854',12,60.00),('O1336','Active','1970-01-01 00:00:00',334.00,'Paytm','9894507978','R002196','E250810',5,125.00),('O1337','Active','1970-01-01 00:00:00',991.00,'Google Pay','8855589019','R002192','E250852',0,380.00),('O1338','Active','1970-01-01 00:00:00',284.00,'VISA','8253117778','R002174','E250808',9,285.00),('O1339','Active','1970-01-01 00:00:00',3318.00,'COD','9223767653','R002186','E250870',18,440.00),('O1340','Active','1970-01-01 00:00:00',136.00,'COD','8764761399','R002152','E250826',2,110.00),('O1341','Active','1970-01-01 00:00:00',548.00,'Google Pay','9836053943','R002167','E250864',10,255.00),('O1342','Active','1970-01-01 00:00:00',151.00,'Google Pay','8311746817','R002170','E250832',8,495.00),('O1343','Active','1970-01-01 00:00:00',542.00,'Paytm','8389985485','R002151','E250826',5,280.00),('O1344','Active','1970-01-01 00:00:00',677.00,'COD','9817917668','R002170','E250878',15,290.00),('O1345','Active','1970-01-01 00:00:00',661.00,'Paytm','9315709956','R002167','E250864',4,235.00),('O1346','Active','1970-01-01 00:00:00',883.00,'Phone Pe','8249723570','R002175','E250800',2,165.00),('O1347','Active','1970-01-01 00:00:00',278.00,'UPI','9845642338','R002169','E250830',8,210.00),('O1348','Active','1970-01-01 00:00:00',1072.00,'VISA','8319816209','R002171','E250846',14,475.00),('O1349','Active','1970-01-01 00:00:00',313.00,'Paytm','9899482940','R002171','E250846',0,500.00),('O1350','Delivered','1970-01-01 00:00:00',512.00,'COD','9867774159','R002189','E250870',6,115.00);
/*!40000 ALTER TABLE `Orders` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Rates`
--
DROP TABLE IF EXISTS `Rates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Rates` (
`ratings` int DEFAULT NULL,
`customerID` char(10) NOT NULL,
`restaurantID` varchar(8) NOT NULL,
PRIMARY KEY (`customerID`,`restaurantID`),
KEY `customerID` (`customerID`),
KEY `restaurantID` (`restaurantID`),
KEY `rating_rest` (`restaurantID`,`ratings`),
CONSTRAINT `Rates_ibfk_1` FOREIGN KEY (`customerID`) REFERENCES `Customer` (`phone`),
CONSTRAINT `Rates_ibfk_2` FOREIGN KEY (`restaurantID`) REFERENCES `Restaurant` (`restaurantID`),
CONSTRAINT `Rates_chk_1` CHECK (((`ratings` > 0) and (`ratings` < 6)))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Rates`
--
LOCK TABLES `Rates` WRITE;
/*!40000 ALTER TABLE `Rates` DISABLE KEYS */;
INSERT INTO `Rates` VALUES (1,'8779776039','R002150'),(2,'8381749123','R002150'),(3,'8764761399','R002150'),(4,'8254877528','R002150'),(4,'9753784498','R002150'),(2,'8715761412','R002151'),(2,'8826666390','R002151'),(2,'9821175217','R002151'),(3,'9836053943','R002151'),(4,'8780872603','R002151'),(3,'8364432786','R002152'),(4,'8225465344','R002152'),(4,'8311746817','R002152'),(4,'9816247236','R002152'),(5,'9891597562','R002152'),(2,'9395179800','R002153'),(3,'8271602066','R002153'),(3,'9750354889','R002153'),(4,'8260444682','R002153'),(4,'9719516787','R002153'),(5,'8389985485','R002153'),(1,'9245656425','R002154'),(1,'9817917668','R002154'),(1,'9857569456','R002154'),(2,'8332685102','R002154'),(2,'8726791774','R002154'),(2,'9356612424','R002154'),(1,'8281719051','R002155'),(1,'9315709956','R002155'),(2,'8248731914','R002155'),(2,'9262878787','R002155'),(4,'8216384380','R002155'),(4,'8716423251','R002155'),(2,'8249723570','R002156'),(2,'9877124785','R002156'),(4,'8244582810','R002156'),(4,'9266049720','R002156'),(4,'9270497728','R002156'),(5,'8891141763','R002156'),(1,'8349334205','R002157'),(3,'8381574609','R002157'),(3,'9778557117','R002157'),(4,'9370367071','R002157'),(4,'9845642338','R002157'),(5,'8326911298','R002157'),(1,'8799973366','R002158'),(2,'8250784389','R002158'),(2,'8345297210','R002158'),(3,'8391839493','R002158'),(4,'8883448929','R002158'),(5,'8319816209','R002158'),(1,'8830712258','R002159'),(1,'9221298131','R002159'),(2,'8798964827','R002159'),(3,'9217184983','R002159'),(5,'8781353271','R002159'),(5,'9899482940','R002159'),(2,'9370356484','R002160'),(3,'8340727094','R002160'),(3,'8360232680','R002160'),(3,'9362408274','R002160'),(5,'8779918880','R002160'),(5,'9867774159','R002160'),(2,'9247946673','R002161'),(3,'8743061623','R002161'),(3,'8779776039','R002161'),(3,'8827481250','R002161'),(3,'9343285253','R002161'),(4,'8357223451','R002161'),(1,'8238779654','R002162'),(1,'9356612424','R002162'),(2,'8793542612','R002162'),(2,'8826666390','R002162'),(2,'9760197861','R002162'),(4,'9236479507','R002162'),(1,'8364432786','R002163'),(1,'8737601546','R002163'),(1,'8836925784','R002163'),(2,'8716423251','R002163'),(2,'8786614016','R002163'),(3,'8235187078','R002163'),(2,'9311305685','R002164'),(3,'8260444682','R002164'),(3,'8856713318','R002164'),(4,'8891141763','R002164'),(4,'9348781766','R002164'),(4,'9398019429','R002164'),(2,'9778557117','R002165'),(3,'8253226127','R002165'),(4,'9857569456','R002165'),(5,'8793877293','R002165'),(5,'9324546523','R002165'),(5,'9768136477','R002165'),(1,'9876358350','R002166'),(2,'8281719051','R002166'),(2,'8345297210','R002166'),(3,'8214556085','R002166'),(4,'8737219123','R002166'),(5,'8252269402','R002166'),(1,'9877124785','R002167'),(2,'9892566135','R002167'),(3,'8830712258','R002167'),(5,'8223676845','R002167'),(5,'8259413178','R002167'),(5,'8731849989','R002167'),(3,'8254877528','R002168'),(3,'9370367071','R002168'),(3,'9753784498','R002168'),(3,'9791041459','R002168'),(4,'9789978513','R002168'),(4,'8715761412','R002169'),(4,'8780872603','R002169'),(4,'8870973947','R002169'),(5,'8334742120','R002169'),(5,'8799973366','R002169'),(1,'9816247236','R002170'),(2,'8798964827','R002170'),(2,'9279956787','R002170'),(3,'9790538045','R002170'),(5,'8225465344','R002170'),(5,'9280075034','R002170'),(1,'8340727094','R002171'),(1,'9395179800','R002171'),(1,'9719516787','R002171'),(3,'8744637223','R002171'),(3,'9377349557','R002171'),(3,'9750354889','R002171'),(1,'8715761412','R002172'),(3,'8262465711','R002172'),(3,'8726791774','R002172'),(3,'9245656425','R002172'),(3,'9343285253','R002172'),(5,'8748239785','R002172'),(5,'8897462341','R002172'),(3,'9816247236','R002173'),(3,'9892791731','R002173'),(4,'8238779654','R002173'),(4,'8248731914','R002173'),(4,'8251714345','R002173'),(5,'8216384380','R002173'),(5,'9774452538','R002173'),(1,'8244582810','R002174'),(3,'8865228931','R002174'),(4,'9395179800','R002174'),(5,'8235187078','R002174'),(5,'8852632786','R002174'),(5,'9370356484','R002174'),(2,'8326911298','R002175'),(2,'9348781766','R002175'),(4,'8254877528','R002175'),(4,'8752843845','R002175'),(5,'8764604488','R002175'),(5,'9247946673','R002175'),(1,'8793877293','R002176'),(2,'9829692908','R002176'),(4,'8250784389','R002176'),(4,'8715761412','R002176'),(5,'9345399131','R002176'),(5,'9356612424','R002176'),(2,'9221298131','R002177'),(2,'9876358350','R002177'),(3,'8273283350','R002177'),(4,'9780858351','R002177'),(4,'9816247236','R002177'),(1,'8360232680','R002178'),(2,'9395179800','R002178'),(3,'8250461307','R002178'),(4,'9382432999','R002178'),(4,'9892566135','R002178'),(1,'8365436688','R002179'),(2,'8254877528','R002179'),(3,'8328228156','R002179'),(4,'8357223451','R002179'),(5,'9791041459','R002179'),(1,'8715761412','R002180'),(1,'9236479507','R002180'),(2,'8334742120','R002180'),(3,'8716423251','R002180'),(3,'8876874883','R002180'),(2,'9279956787','R002181'),(3,'8891141763','R002181'),(3,'9270497728','R002181'),(3,'9816247236','R002181'),(4,'8381749123','R002181'),(4,'8836925784','R002181'),(3,'9311305685','R002182'),(3,'9395179800','R002182'),(3,'9778557117','R002182'),(4,'9821175217','R002182'),(5,'8381574609','R002182'),(2,'8253226127','R002183'),(2,'8345297210','R002183'),(2,'8391839493','R002183'),(3,'9857569456','R002183'),(5,'9891597562','R002183'),(1,'8254877528','R002184'),(2,'8281719051','R002184'),(2,'8830712258','R002184'),(4,'8737219123','R002184'),(5,'8271602066','R002184'),(5,'9217184983','R002184'),(2,'8254877528','R002185'),(2,'8715761412','R002185'),(2,'9362408274','R002185'),(3,'8332685102','R002185'),(4,'9877124785','R002185'),(5,'8223676845','R002185'),(1,'8743061623','R002186'),(2,'9370367071','R002186'),(2,'9789978513','R002186'),(3,'9262878787','R002186'),(3,'9774452572','R002186'),(3,'9816247236','R002186'),(4,'8715761412','R002186'),(1,'8870973947','R002187'),(3,'8799973366','R002187'),(3,'9266049720','R002187'),(4,'9749635297','R002187'),(4,'9760197861','R002187'),(4,'9816247236','R002187'),(5,'9395179800','R002187'),(2,'8239969188','R002188'),(2,'9395179800','R002188'),(2,'9790538045','R002188'),(3,'8786614016','R002188'),(3,'8798964827','R002188'),(4,'8349334205','R002188'),(5,'9857569456','R002188'),(2,'8262465711','R002189'),(2,'8281719051','R002189'),(2,'9398019429','R002189'),(3,'8340727094','R002189'),(4,'8744637223','R002189'),(4,'9854756162','R002189'),(5,'8883448929','R002189'),(1,'9343285253','R002190'),(2,'8897462341','R002190'),(3,'9719516787','R002190'),(4,'8868904661','R002190'),(4,'9324546523','R002190'),(4,'9356612424','R002190'),(5,'8781353271','R002190'),(2,'8238779654','R002191'),(3,'9245656425','R002191'),(4,'8252269402','R002191'),(4,'8779918880','R002191'),(4,'9892791731','R002191'),(5,'8716423251','R002191'),(5,'9324037167','R002191'),(2,'8248731914','R002192'),(2,'9267696153','R002192'),(3,'8235187078','R002192'),(3,'8827481250','R002192'),(3,'8891141763','R002192'),(5,'8259413178','R002192'),(5,'8865228931','R002192'),(1,'9280075034','R002193'),(2,'8244582810','R002193'),(2,'8717789968','R002193'),(2,'8764604488','R002193'),(3,'8793542612','R002193'),(4,'9348781766','R002193'),(2,'8793877293','R002194'),(2,'9778557117','R002194'),(3,'8737601546','R002194'),(4,'8711538567','R002194'),(4,'9345399131','R002194'),(5,'8326911298','R002194'),(5,'9377349557','R002194'),(1,'9780858351','R002195'),(2,'8345297210','R002195'),(2,'9719516787','R002195'),(2,'9876358350','R002195'),(3,'8856713318','R002195'),(4,'9894507978','R002195'),(5,'8748239785','R002195'),(1,'9245656425','R002196'),(4,'8250461307','R002196'),(4,'8830712258','R002196'),(4,'9892566135','R002196'),(5,'8855589019','R002196'),(5,'9768136477','R002196'),(5,'9774452538','R002196'),(1,'8248731914','R002197'),(1,'8253117778','R002197'),(2,'8254877528','R002197'),(2,'8328228156','R002197'),(2,'9791041459','R002197'),(3,'8214556085','R002197'),(2,'8244582810','R002198'),(2,'8334742120','R002198'),(2,'8715761412','R002198'),(2,'9223767653','R002198'),(3,'8731849989','R002198'),(4,'8876874883','R002198');
/*!40000 ALTER TABLE `Rates` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Receiver`
--
DROP TABLE IF EXISTS `Receiver`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Receiver` (
`receiverID` varchar(8) NOT NULL,
`phone` char(10) DEFAULT NULL,
`name` varchar(100) NOT NULL,
`hNo` varchar(6) NOT NULL,
`street` varchar(20) DEFAULT NULL,
`area` varchar(20) NOT NULL,
`city` varchar(20) NOT NULL,
`state` varchar(20) NOT NULL,
`pin` char(6) NOT NULL,
`accepts` varchar(20) NOT NULL,
PRIMARY KEY (`receiverID`),
UNIQUE KEY `phone` (`phone`),
KEY `nearby_rec` (`area`),
KEY `accepted` (`accepts`),
CONSTRAINT `Receiver_chk_1` CHECK (((`accepts` = _utf8mb4'Meals') or (`accepts` = _utf8mb4'Money') or (`accepts` = _utf8mb4'Clothes')))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Receiver`
--
LOCK TABLES `Receiver` WRITE;
/*!40000 ALTER TABLE `Receiver` DISABLE KEYS */;
INSERT INTO `Receiver` VALUES ('R320100','8882089591','AAINA','20','27','Neb Sarai','New Delhi','Delhi','110016','Money'),('R320103','8826738535','Aatmaja Foundation','70','20','Andheri','New Delhi','Delhi','110014','Meals'),('R320106','7838908123','Action on Disability and Development (India)','132','30','Mangal Bazar','New Delhi','Delhi','110015','Money'),('R320109','9810202223','Agewell Foundation','54','53','A R Shala','New Delhi','Delhi','110083','Clothes'),('R320112','7890675533','Ambassadors Service Society','148','15','Anandnagar','New Delhi','Delhi','110024','Meals'),('R320115','8825468002','Angel Xpress Foundation','8','19','Tehsil','New Delhi','Delhi','110019','Money'),('R320118','8879066435','ASSOCIATION FOR REHABILITATION OF VILLAGE AND IMPAIRMENT (ARVI) TRUST','90','53','Badnapur','New Delhi','Delhi','110085','Money'),('R320121','8124377855','Avtar Human Capital Trust','60','56','Inderpuri','New Delhi','Delhi','110084','Money'),('R320124','8136638993','BALAJEE SEWA SANSTHAN','96','65','Ishanputr','New Delhi','Delhi','110016','Clothes'),('R320127','8223417890','Barefoot Edu Foundation','38','20','Chittoor Bazar','New Delhi','Delhi','110089','Money'),('R320130','8446700998','Bethany Society','88','47','Patel nagar','New Delhi','Delhi','110088','Clothes'),('R320133','9923099884','BOSCO REACH OUT','30','40','Adipir','New Delhi','Delhi','110067','Money'),('R320136','9857644576','CARE TRUST','112','54','Amber Nagar','New Delhi','Delhi','110032','Money'),('R320139','8800431290','Cause For Change','121','10','Alavala','New Delhi','Delhi','110032','Meals'),('R320142','8809299467','Centre for SBBC','16','37','Sector 7','New Delhi','Delhi','110023','Money'),('R320145','8229934519','CHANDRA DEV CHARITABLE SOCIETY','44','2','Anandapuram','New Delhi','Delhi','110060','Money'),('R320148','8442275513','Childline India Foundation','34','16','Gehra','New Delhi','Delhi','110041','Money'),('R320151','7440933553','IntegrityIndia','90','55','Agaram','New Delhi','Delhi','110034','Meals'),('R320154','9650996388','CRY - Child Rights and You','3','47','Durgapuram','New Delhi','Delhi','110049','Money'),('R320157','8801993874','DAKSHAYANI AND AMARAVATI HEALTH AND EDUCATION','1','49','Udaygarh','New Delhi','Delhi','110036','Meals'),('R320160','8990035566','DHAGAGIA SOCIAL WELFARE SOCIETY','256','32','Niman nagar','New Delhi','Delhi','110075','Meals'),('R320163','7639938494','Elder Care Trust','68','41','Pansa','New Delhi','Delhi','110071','Money'),('R320166','9650167892','Foster Care Society','12','4','Karol Bagh','New Delhi','Delhi','110080','Clothes'),('R320169','7806544887','Goodwill Social Work Centre','45','45','Walwa','New Delhi','Delhi','110052','Clothes'),('R320172','8976538763','Gramya Vikas Parishad Mangalpur','200','20','Jama Maszid','New Delhi','Delhi','110001','Meals'),('R320175','8204652748','Hariraj Charitable Trust','121','23','Shankar Saw Mill','New Delhi','Delhi','110016','Money'),('R320178','9992778530','Help The Blind Foundation','142','12','Anandnagar','New Delhi','Delhi','110088','Money'),('R320181','9560089591','Human Education for Liberation of the Poor - Trust','83','54','Ravanapuram','New Delhi','Delhi','110074','Money'),('R320184','8880288334','INDIA HIV/ AIDS ALLIANCE','22','19','Sarjepura','New Delhi','Delhi','110075','Money'),('R320187','7838907822','Isha Education','290','12','Khanpura','New Delhi','Delhi','110017','Money'),('R320190','8882067819','Janshakti Chetna foundation','80','5','Madhapur','New Delhi','Delhi','110091','Clothes'),('R320193','8800236582','Kaladanga Al-Qirat Charitable Society','9','38','Verna','New Delhi','Delhi','110008','Meals'),('R320196','9532448921','Katakhali Swapnopuron Welfare Society','177','24','Chandor','New Delhi','Delhi','110031','Meals'),('R320199','9802522361','Kidpower (A Welfare Society)','25','32','Ambale','New Delhi','Delhi','110055','Clothes'),('R320202','9553918226','LexQuest Foundation','71','56','Nadpura','New Delhi','Delhi','110016','Money'),('R320205','9802348225','Lokamata Rani Rashmoni Mission','269','60','Panihar','New Delhi','Delhi','110007','Money'),('R320208','7699377444','Maitreyi Mahila Mandal','18','10','Dudhani','New Delhi','Delhi','110084','Meals'),('R320211','8874492944','Makkal Vilipunarvu Kalvi Sangam','77','29','Kanki','New Delhi','Delhi','110073','Meals'),('R320214','9653884449','MANDRA LIONS CLUB','61','50','Noorwala','New Delhi','Delhi','110020','Money'),('R320217','7246008951','Mauli Multipurpose charitable society','149','22','Dhara','New Delhi','Delhi','110058','Money'),('R320220','8130902287','MOTIVATION INDIA','230','39','Ganesh Vatika','New Delhi','Delhi','110067','Money'),('R320223','9966003311','OSCAR Foundation','65','26','Kesari','New Delhi','Delhi','110031','Clothes'),('R320226','7650892240','Parents Association of Mentally Handicapped of Jamshedpur','87','28','Kanpura','New Delhi','Delhi','110090','Clothes'),('R320229','9992056720','Population First','321','23','Jalalshi','New Delhi','Delhi','110061','Meals'),('R320232','9900982633','PRAKRITI FOUNDATION','278','40','Narava','New Delhi','Delhi','110042','Meals'),('R320235','8800274830','Prayatna School of Excellence','219','44','Bulandsahr','New Delhi','Delhi','110074','Money'),('R320238','9810210973','Raah Foundation','66','31','Rajput','New Delhi','Delhi','110072','Money'),('R320241','7990136644','Ramparva Samajik Shaikshanik Seva Samiti','83','66','Tana','New Delhi','Delhi','110037','Meals'),('R320244','7556643257','RESOURCE FOUNDATION','56','64','Haripur','New Delhi','Delhi','110071','Meals'),('R320247','7654892256','Rostrum India Social Organisation','109','13','Eldams Road','New Delhi','Delhi','110038','Clothes');
/*!40000 ALTER TABLE `Receiver` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Temporary view structure for view `ReceiverDetails`
--
DROP TABLE IF EXISTS `ReceiverDetails`;
/*!50001 DROP VIEW IF EXISTS `ReceiverDetails`*/;
SET @saved_cs_client = @@character_set_client;
/*!50503 SET character_set_client = utf8mb4 */;
/*!50001 CREATE VIEW `ReceiverDetails` AS SELECT
1 AS `receiverID`,
1 AS `name`,
1 AS `phone`,
1 AS `state`,
1 AS `accepts`*/;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `Restaurant`
--
DROP TABLE IF EXISTS `Restaurant`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Restaurant` (
`restaurantID` varchar(8) NOT NULL,
`type` varchar(30) DEFAULT NULL,
`dayOfOpening` date DEFAULT NULL,
`description` varchar(200) DEFAULT NULL,
`name` varchar(50) NOT NULL,
`phone` char(10) NOT NULL,
`street` varchar(20) DEFAULT NULL,
`city` varchar(20) NOT NULL,
`state` varchar(20) NOT NULL,
`pin` varchar(6) NOT NULL,
`area` varchar(20) NOT NULL,
`isDineIn` tinyint(1) DEFAULT NULL,
`sNo` varchar(6) NOT NULL,
PRIMARY KEY (`restaurantID`),
KEY `nearby_rest` (`area`),
CONSTRAINT `checkRestaurantType` CHECK (((`type` = _utf8mb4'South Indian') or (`type` = _utf8mb4'Mexican') or (`type` = _utf8mb4'Continental') or (`type` = _utf8mb4'Fast Food') or (`type` = _utf8mb4'Mughlai') or (`type` = _utf8mb4'North Indian') or (`type` = _utf8mb4'Chinese')))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Restaurant`
--
LOCK TABLES `Restaurant` WRITE;
/*!40000 ALTER TABLE `Restaurant` DISABLE KEYS */;
INSERT INTO `Restaurant` VALUES ('R002150','North Indian','2000-07-24','Apna Dhaba was opened on 2000-07-24 and serves North Indian.','Apna Dhaba','8555453656','Bose Street','Udyog Bhawan','New Delhi','Delhi','110011',1,'211'),('R002151','Mexican','2013-12-12','Akira Back was opened on 2013-12-12 and serves Mexican.','Akira Back','7555836595','Setty Street','Niman nagar','Sonipath','Delhi','110023',1,'283'),('R002152','North Indian','2010-08-05','Andaz Bar was opened on 2010-08-05 and serves North Indian.','Andaz Bar','9955575519','Bajaj Street','Hasanpur','Gurugram','Delhi','122105',1,'185'),('R002153','South Indian','2008-06-14','AnnaMaya was opened on 2008-06-14 and serves South Indian.','AnnaMaya','9155504539','Rampersad Street','Karol Bagh','New Delhi','Delhi','110005',1,'13'),('R002154','South Indian','2014-12-01','Bangalore Spices was opened on 2014-12-01 and serves South Indian.','Bangalore Spices','9555575341','Saxena Street','Jama Maszid','Faridabad','Delhi','110066',0,'7'),('R002155','Chinese','2014-05-18','Berco\'s was opened on 2014-05-18 and serves Chinese.','Berco\'s','8555097907','Nagi Street','Abupur','Gaziabad','Delhi','201206',1,'63'),('R002156','Chinese','2012-11-09','Biejing Bites was opened on 2012-11-09 and serves Chinese.','Biejing Bites','9755580323','Sarkar Street','Hauz Khaz','New Delhi','Delhi','110006',1,'43'),('R002157','Mughlai','2010-07-27','Biryani Restaurant was opened on 2010-07-27 and serves Mughlai.','Biryani Restaurant','8555089685','Gobin Street','Indian Post Office','Connaught Place','Delhi','110001',0,'86'),('R002158','Mexican','2015-06-26','Blue Collar was opened on 2015-06-26 and serves Mexican.','Blue Collar','7555538850','Kohli Street','Malviya Nagar','New Delhi','Delhi','422002',1,'105'),('R002159','North Indian','2009-04-11','Bollywood Spice was opened on 2009-04-11 and serves North Indian.','Bollywood Spice','7555697056','Ghosh Street','Rajput','New Delhi','Delhi','388292',1,'137'),('R002160','South Indian','2004-08-03','Bombay Pakwaan was opened on 2004-08-03 and serves South Indian.','Bombay Pakwaan','8555856581','Meka Street','Chhatarpur','New Delhi','Delhi','898493',1,'11'),('R002161','Mexican','2007-03-23','Brewed Awakening was opened on 2007-03-23 and serves Mexican.','Brewed Awakening','8555115469','Sood Street','Gomtiput','New Delhi','Delhi','374844',0,'215'),('R002162','North Indian','2014-03-28','Burma Burma Restaurant was opened on 2014-03-28 and serves North Indian.','Burma Burma Restaurant','8555920913','Rampersad Street','Andheri','Gurugram','Delhi','232233',0,'258'),('R002163','Continental','2007-05-07','Bursty BiteContinental was opened on 2007-05-07 and serves Continental.','Bursty BiteContinental','8555968067','Chhabra Street','Ambli','Mehrauli','Delhi','983943',0,'188'),('R002164','Mexican','2010-08-08','Cafe Pluck was opened on 2010-08-08 and serves Mexican.','Cafe Pluck','8555945635','Parikh Street','Ameerpet','New Delhi','Delhi','110017',1,'246'),('R002165','Continental','2006-10-03','California Pizza Kitchen was opened on 2006-10-03 and serves Continental.','California Pizza Kitchen','7555458014','Mane Street','Balrampur','New Delhi','Delhi','110054',1,'190'),('R002166','Fast Food','2009-05-08','Chaat Mehal was opened on 2009-05-08 and serves Fast Food.','Chaat Mehal','8555330731','Bail Street','Amber Nagar','New Delhi','Delhi','471001',1,'292'),('R002167','North Indian','2001-06-29','Chai Marke was opened on 2001-06-29 and serves North Indian.','Chai Marke','8555831248','Bose Street','Udyog Bhawan','New Delhi','Delhi','110011',1,'154'),('R002168','North Indian','2006-01-07','Chamcha Lounge was opened on 2006-01-07 and serves North Indian.','Chamcha Lounge','7555689699','Setty Street','Niman nagar','Sonipath','Delhi','110023',0,'113'),('R002169','Fast Food','2010-12-07','Chart House was opened on 2010-12-07 and serves Fast Food.','Chart House','9955573265','Bajaj Street','Hasanpur','Gurugram','Delhi','122105',0,'96'),('R002170','Chinese','2005-08-23','Chez Billy Sud was opened on 2005-08-23 and serves Chinese.','Chez Billy Sud','9455568872','Rampersad Street','Karol Bagh','New Delhi','Delhi','110005',1,'267'),('R002171','Mexican','2010-11-04','Conch it Up Soul Food was opened on 2010-11-04 and serves Mexican.','Conch it Up Soul Food','9055582244','Saxena Street','Jama Maszid','Faridabad','Delhi','110066',1,'195'),('R002172','Mexican','2008-09-09','Crest Cafe was opened on 2008-09-09 and serves Mexican.','Crest Cafe','9255517943','Nagi Street','Abupur','Gaziabad','Delhi','201206',0,'213'),('R002173','Mughlai','2014-02-16','Curry Cafe was opened on 2014-02-16 and serves Mughlai.','Curry Cafe','7555373351','Sarkar Street','Hauz Khaz','New Delhi','Delhi','110006',0,'112'),('R002174','North Indian','2014-06-29','Curry Mahal was opened on 2014-06-29 and serves North Indian.','Curry Mahal','7555416933','Gobin Street','Indian Post Office','Connaught Place','Delhi','110001',0,'69'),('R002175','Continental','2013-12-22','Daily Grill was opened on 2013-12-22 and serves Continental.','Daily Grill','9755546124','Kohli Street','Malviya Nagar','New Delhi','Delhi','422002',1,'240'),('R002176','North Indian','2000-11-11','Delhi Club was opened on 2000-11-11 and serves North Indian.','Delhi Club','7555498644','Ghosh Street','Rajput','New Delhi','Delhi','388292',1,'241'),('R002177','North Indian','2007-11-25','Desi Palace was opened on 2007-11-25 and serves North Indian.','Desi Palace','7555872065','Meka Street','Chhatarpur','New Delhi','Delhi','898493',1,'177'),('R002178','North Indian','2012-07-24','DeviDining was opened on 2012-07-24 and serves North Indian.','DeviDining','8555379942','Sood Street','Gomtiput','New Delhi','Delhi','374844',1,'66'),('R002179','Mexican','2004-12-12','Dine Fine was opened on 2004-12-12 and serves Mexican.','Dine Fine','8555998514','Rampersad Street','Andheri','Gurugram','Delhi','232233',0,'269'),('R002180','Continental','2005-08-05','Dinner Club was opened on 2005-08-05 and serves Continental.','Dinner Club','7555606056','Chhabra Street','Ambli','Mehrauli','Delhi','983943',0,'204'),('R002181','South Indian','2001-06-14','Dosa Lounge was opened on 2001-06-14 and serves South Indian.','Dosa Lounge','8555206485','Parikh Street','Ameerpet','New Delhi','Delhi','110017',0,'142'),('R002182','North Indian','2011-12-01','Dosalon Chai was opened on 2011-12-01 and serves North Indian.','Dosalon Chai','9655566222','Mane Street','Balrampur','New Delhi','Delhi','110054',0,'16'),('R002183','Mexican','2014-05-18','Double Decker was opened on 2014-05-18 and serves Mexican.','Double Decker','8555969090','Bail Street','Amber Nagar','New Delhi','Delhi','471001',1,'6'),('R002184','Fast Food','2003-11-09','Double Knot was opened on 2003-11-09 and serves Fast Food.','Double Knot','8555798130','Bose Street','Udyog Bhawan','New Delhi','Delhi','110011',1,'230'),('R002185','Continental','2015-07-27','El Pirata Porch was opened on 2015-07-27 and serves Continental.','El Pirata Porch','7555974527','Setty Street','Niman nagar','Sonipath','Delhi','110023',1,'261'),('R002186','Mexican','2006-06-26','Exotic Rooftop Restaurant was opened on 2006-06-26 and serves Mexican.','Exotic Rooftop Restaurant','9055522857','Bajaj Street','Hasanpur','Gurugram','Delhi','122105',1,'278'),('R002187','North Indian','2004-04-11','Famous Lunch was opened on 2004-04-11 and serves North Indian.','Famous Lunch','9555570432','Rampersad Street','Karol Bagh','New Delhi','Delhi','110005',1,'214'),('R002188','Fast Food','2015-08-03','FatJar Cafe & Market was opened on 2015-08-03 and serves Fast Food.','FatJar Cafe & Market','7555101720','Saxena Street','Jama Maszid','Faridabad','Delhi','110066',1,'257'),('R002189','Continental','2001-03-23','Flavoroso was opened on 2001-03-23 and serves Continental.','Flavoroso','8555005247','Nagi Street','Abupur','Gaziabad','Delhi','201206',1,'8'),('R002190','Continental','2015-03-28','Fog Harbor Fish House was opened on 2015-03-28 and serves Thai.','Fog Harbor Fish House','9555537419','Sarkar Street','Hauz Khaz','New Delhi','Delhi','110006',1,'110'),('R002191','Continental','2008-05-07','Food Castle was opened on 2008-05-07 and serves Continental.','Food Castle','8555833241','Gobin Street','Indian Post Office','Connaught Place','Delhi','110001',0,'182'),('R002192','Mexican','2006-08-08','Food Exchange was opened on 2006-08-08 and serves Mexican.','Food Exchange','8555669058','Kohli Street','Malviya Nagar','New Delhi','Delhi','422002',0,'201'),('R002193','Chinese','2008-10-03','Fried Chicken was opened on 2008-10-03 and serves Chinese.','Fried Chicken','9755521446','Ghosh Street','Rajput','New Delhi','Delhi','388292',0,'218'),('R002194','Chinese','2013-05-08','Fuji Japanese Restaurant was opened on 2013-05-08 and serves Chinese.','Fuji Japanese Restaurant','8555009990','Meka Street','Chhatarpur','New Delhi','Delhi','898493',1,'145'),('R002195','South Indian','2011-06-29','Full Moon was opened on 2011-06-29 and serves South Indian.','Full Moon','6555209805','Sood Street','Gomtiput','New Delhi','Delhi','374844',1,'134'),('R002196','North Indian','2008-01-07','Garage Kitchen + Bar was opened on 2008-01-07 and serves North Indian.','Garage Kitchen + Bar','8555068368','Rampersad Street','Andheri','Gurugram','Delhi','232233',1,'136'),('R002197','Mexican','2001-12-07','Gaslamp Fish House was opened on 2001-12-07 and serves Mexican.','Gaslamp Fish House','9755507794','Chhabra Street','Ambli','Mehrauli','Delhi','983943',1,'57'),('R002198','North Indian','2011-08-23','Grandma’s Sweets was opened on 2011-08-23 and serves North Indian.','Grandma’s Sweets','8555361429','Parikh Street','Ameerpet','New Delhi','Delhi','110017',1,'153');
/*!40000 ALTER TABLE `Restaurant` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Final view structure for view `CustomerDetails`
--
/*!50001 DROP VIEW IF EXISTS `CustomerDetails`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = utf8mb4 */;
/*!50001 SET character_set_results = utf8mb4 */;
/*!50001 SET collation_connection = utf8mb4_0900_ai_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`nandikajain`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `CustomerDetails` AS select `Customer`.`phone` AS `phone`,`Customer`.`fName` AS `fName`,`Customer`.`lName` AS `lName`,`Customer`.`email` AS `email`,`Customer`.`state` AS `state`,`Customer`.`customerType` AS `customerType`,`Customer`.`dob` AS `dob` from `Customer` */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
--
-- Final view structure for view `DeliveryWorkerDetails`
--
/*!50001 DROP VIEW IF EXISTS `DeliveryWorkerDetails`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = utf8mb4 */;
/*!50001 SET character_set_results = utf8mb4 */;
/*!50001 SET collation_connection = utf8mb4_0900_ai_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`nandikajain`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `DeliveryWorkerDetails` AS select `DeliveryWorker`.`employeeID` AS `employeeID`,`DeliveryWorker`.`fName` AS `fName`,`DeliveryWorker`.`lName` AS `lName`,`DeliveryWorker`.`phone` AS `phone`,`DeliveryWorker`.`socialCause` AS `socialCause`,`DeliveryWorker`.`supervisorID` AS `supervisorID`,`DeliveryWorker`.`dob` AS `dob` from `DeliveryWorker` */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
--
-- Final view structure for view `DonorDetails`
--
/*!50001 DROP VIEW IF EXISTS `DonorDetails`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = utf8mb4 */;
/*!50001 SET character_set_results = utf8mb4 */;
/*!50001 SET collation_connection = utf8mb4_0900_ai_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`nandikajain`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `DonorDetails` AS select `Donor`.`donorID` AS `donorID`,`Donor`.`phone` AS `phone`,`Donor`.`name` AS `name`,`Donor`.`state` AS `state`,`Donor`.`points` AS `points` from `Donor` */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
--
-- Final view structure for view `ManagementDetails`
--
/*!50001 DROP VIEW IF EXISTS `ManagementDetails`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = utf8mb4 */;
/*!50001 SET character_set_results = utf8mb4 */;
/*!50001 SET collation_connection = utf8mb4_0900_ai_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`nandikajain`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `ManagementDetails` AS select `Management`.`employeeID` AS `employeeID`,`Management`.`fName` AS `fName`,`Management`.`lName` AS `lName`,`Management`.`phone` AS `phone`,`Management`.`state` AS `state`,`Management`.`dob` AS `dob`,`Management`.`designation` AS `designation` from `Management` */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
--
-- Final view structure for view `ReceiverDetails`
--
/*!50001 DROP VIEW IF EXISTS `ReceiverDetails`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = utf8mb4 */;
/*!50001 SET character_set_results = utf8mb4 */;
/*!50001 SET collation_connection = utf8mb4_0900_ai_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`nandikajain`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `ReceiverDetails` AS select `Receiver`.`receiverID` AS `receiverID`,`Receiver`.`name` AS `name`,`Receiver`.`phone` AS `phone`,`Receiver`.`state` AS `state`,`Receiver`.`accepts` AS `accepts` from `Receiver` */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2021-04-08 17:34:35