-
Notifications
You must be signed in to change notification settings - Fork 0
/
schema.sql
150 lines (140 loc) · 11.3 KB
/
schema.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
create database if not exists `loan`;
USE `loan`;
SET FOREIGN_KEY_CHECKS=0;
--
-- Table structure for table `customer`
--
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
`id` bigint(20) NOT NULL,
`name` varchar(100) NOT NULL,
`shippingaddress` varchar(255) default NULL,
`telephone` varchar(50) default NULL,
`level` varchar(50) default NULL,
`email` varchar(255) default NULL,
`creditscore` bigint(20) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `customer`
--
/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
LOCK TABLES `customer` WRITE;
INSERT INTO `customer` (id,name,shippingaddress,telephone,level,email,creditscore) VALUES
(1,'Garth Lara','3160 Nibh Av.','1-972-689-3830','Platinum','[email protected]',798),
(2,'Ross Huber','743-1481 Iaculis Ave','1-639-354-0740','Platinum','[email protected]',796),
(3,'Troy Phelps','262 Mauris Av.','1-324-295-9537','Platinum','[email protected]',794),
(4,'Allistair Higgins','Ap #104-5263 Cursus Street','1-768-128-7635','Platinum','[email protected]',792),
(5,'Murphy Cleveland','666-6734 Urna Rd.','1-700-468-2889','Platinum','[email protected]',790),
(6,'Berk Bass','310-2196 Sagittis St.','1-792-782-4048','Platinum','[email protected]',788),
(7,'Marsden Stanley','195-678 Mollis. Av.','1-971-860-6330','Platinum','[email protected]',786),
(8,'Levi Tyler','2991 Enim. Rd.','1-356-643-8760','Platinum','[email protected]',784),
(9,'Talon Moses','Ap #912-7099 Libero Avenue','1-652-484-9320','Platinum','[email protected]',782),
(10,'Ryan Middleton','P.O. Box 354 2085 Vitae Street','1-792-223-1651','Platinum','[email protected]',780),
(11,'Joel Singleton','Ap #658-7964 Sed Ave','1-113-315-7252','Gold','[email protected]',778),
(12,'Graiden Singleton','802 Orci, Rd.','1-230-502-0635','Gold','[email protected]',776),
(13,'Guy Hurst','7409 Sed Ave','1-839-995-4563','Gold','[email protected]',774),
(14,'Aladdin Flowers','346-7790 Quam. Avenue','1-131-572-7420','Gold','[email protected]',772),
(15,'Noah Washington','702-2083 Accumsan Av.','1-798-298-9468','Gold','[email protected]',770),
(16,'Guy Reynolds','4367 Fusce St.','1-516-591-4168','Gold','[email protected]',768),
(17,'Keefe Lynn','321 Magna St.','1-385-227-1621','Gold','[email protected]',766),
(18,'Ira Lambert','2684 Magnis Avenue','1-164-465-4287','Gold','[email protected]',764),
(19,'Levi Wells','Ap #579-955 Nullam Avenue','1-772-249-0773','Gold','[email protected]',762),
(20,'Wing Lindsay','4056 Facilisis. St.','1-419-331-8677','Gold','[email protected]',760),
(21,'Benjamin Ashley','1425 Nunc Av.','1-734-573-1176','Gold','[email protected]',758),
(22,'Xavier Harris','696-5069 Eu Av.','1-287-346-7331','Gold','[email protected]',756),
(23,'Steel Clay','Ap #176-3277 Vitae Rd.','1-907-659-9390','Gold','[email protected]',754),
(24,'Ivor Nicholson','513-1570 Ipsum. Avenue','1-117-830-5285','Gold','[email protected]',752),
(25,'Barclay Pena','1119 Sapien. Avenue','1-179-894-6173','Gold','[email protected]',750),
(26,'Wylie Lamb','7488 Ullamcorper. Street','1-634-341-1009','Gold','[email protected]',748),
(27,'Xander Stark','P.O. Box 405 , 7407 Metus Avenue','1-924-125-4541','Gold','[email protected]',746),
(28,'Henry Durham','P.O. Box 541 , 9867 Lacus. Ave','1-613-246-9869','Gold','[email protected]',744),
(29,'Darius Vargas','5605 Elit Street','1-128-246-5333','Gold','[email protected]',742),
(30,'Cody Hinton','Ap #284-8975 Sed, Rd.','1-358-100-3881','Gold','[email protected]',740),
(31,'Lance Payne','P.O. Box 280, 8309 Non Ave"','1-722-641-9848','Gold','[email protected]',738),
(32,'Xavier Carver','569-382 Sit St.','1-497-813-4778','Gold','[email protected]',736),
(33,'Silas Wynn','"P.O. Box 512, 7337 Curabitur St."','1-722-198-3215','Gold','[email protected]',734),
(34,'Leonard Parrish','293-958 Integer St.','1-621-392-2150','Gold','[email protected]',732),
(35,'Ryan Rodriquez','"P.O. Box 325, 2466 Adipiscing Rd."','1-210-397-7332','Gold','[email protected]',730),
(36,'Ian Lara','Ap #629-5476 Neque Road','1-876-966-1802','Gold','[email protected]',728),
(37,'Uriah Weber','979-2674 Molestie St.','1-733-988-4530','Gold','[email protected]',726),
(38,'William Watts','"P.O. Box 243, 6881 Magna. Av."','1-804-419-4040','Gold','[email protected]',724),
(39,'Leonard Skinner','"P.O. Box 599, 8930 Tellus Rd."','1-785-109-7372','Gold','[email protected]',722),
(40,'Rooney Gross','Ap #416-898 Phasellus Ave','1-662-176-3392','Gold','[email protected]',720),
(41,'Clinton Blackwell','"P.O. Box 981, 5747 Donec St."','1-513-811-0518','Gold','[email protected]',718),
(42,'Cruz Rush','769-5566 Ipsum. Avenue','1-940-368-8894','Gold','[email protected]',716),
(43,'Rigel Hull','168-7616 Euismod Ave','1-805-498-8329','Gold','[email protected]',714),
(44,'Abel Casey','"P.O. Box 924, 3500 Purus. St."','1-381-710-1147','Gold','[email protected]',712),
(45,'Plato Maddox','"651 Dui, Avenue"','1-531-454-0980','Gold','[email protected]',710),
(46,'Harper Mayo','"P.O. Box 205, 6002 Vel, Street"','1-340-586-9669','Gold','[email protected]',708),
(47,'Gavin Floyd','Ap #384-5165 Quis Street','1-719-441-7162','Gold','[email protected]',706),
(48,'Keefe Potts','"P.O. Box 741, 373 Parturient St."','1-430-229-4824','Gold','[email protected]',704),
(49,'Honorato Mayo','240-180 Sed Street','1-595-532-7026','Gold','[email protected]',702),
(50,'Austin Hicks','Ap #493-1483 Sed Street','1-576-939-1741','Gold','[email protected]',700),
(51,'Bert Dalton','5361 Augue Road','1-689-648-8674','Silver','[email protected]',698),
(52,'Jonas Barrett','Ap #500-4652 Nulla Ave','1-841-321-0990','Silver','[email protected]',696),
(53,'Tiger Hubbard','8173 Dignissim St.','1-669-243-4901','Silver','[email protected]',694),
(54,'Lars Poole','Ap #480-7145 Neque. Avenue','1-185-833-8115','Silver','[email protected]',692),
(55,'Kermit Jennings','9961 Sem Street','1-957-550-4510','Silver','[email protected]',690),
(56,'Travis Cantrell','5119 Bibendum Avenue','1-628-636-6198','Silver','[email protected]',688),
(57,'Caesar Schwartz','"P.O. Box 250, 5672 Lectus St."','1-427-527-1469','Silver','[email protected]',686),
(58,'Garth Pittman','"8777 Non, Street"','1-765-398-3969','Silver','[email protected]',684),
(59,'Darius Robertson','"Ap #952-2276 Non, Street"','1-645-361-0229','Silver','[email protected]',682),
(60,'Lucius Warren','435-6883 In Av.','1-377-639-2782','Silver','[email protected]',680),
(61,'Guy Guzman','"170-3805 Nec, Avenue"','1-324-426-0385','Silver','[email protected]',678),
(62,'Hedley Donovan','9073 Diam Rd.','1-857-295-9370','Silver','[email protected]',676),
(63,'Adrian Moore','Ap #336-9266 Donec St.','1-368-435-0528','Silver','[email protected]',674),
(64,'Dante Clayton','"756-4567 Tellus, Avenue"','1-587-835-3988','Silver','[email protected]',672),
(65,'Kyle Charles','Ap #114-7983 Phasellus Street','1-399-187-1447','Silver','[email protected]',670),
(66,'Ryder Copeland','Ap #375-1740 Enim Rd.','1-187-213-4607','Silver','[email protected]',668),
(67,'Cyrus Harding','Ap #877-7903 Tortor Avenue','1-933-602-9875','Silver','[email protected]',666),
(68,'Darius Reed','5622 Morbi Av.','1-719-603-7987','Silver','[email protected]',664),
(69,'Linus Anderson','"P.O. Box 213, 2671 Semper Ave"','1-223-991-2434','Silver','[email protected]',662),
(70,'Bert Soto','195-7017 Duis St.','1-947-680-3634','Silver','[email protected]',660),
(71,'Keefe Sears','169-6250 Sociis Rd.','1-631-777-2553','Silver','[email protected]',658),
(72,'Ray Duke','580-7875 Porttitor Street','1-336-804-1213','Silver','[email protected]',656),
(73,'Jermaine Larson','431 Quisque St.','1-681-435-6573','Silver','[email protected]',654),
(74,'Vincent Rodriquez','Ap #632-2156 Malesuada Rd.','1-666-666-4991','Silver','[email protected]',652),
(75,'Amir Jensen','5575 Aliquam Ave','1-566-984-6768','Silver','[email protected]',650),
(76,'Troy Dorsey','Ap #683-545 Velit Road','1-681-453-8894','Silver','[email protected]',648),
(77,'Lucas Lyons','"P.O. Box 445, 471 Nibh Avenue"','1-671-854-4650','Silver','[email protected]',646),
(78,'Wade Oliver','Ap #522-3687 Ornare St.','1-731-584-0132','Silver','[email protected]',644),
(79,'Hamish Mcneil','377-3973 Pede Ave','1-625-451-6282','Silver','[email protected]',642),
(80,'Alden Waller','7456 Adipiscing Avenue','1-675-135-5560','Silver','[email protected]',640),
(81,'Sawyer Montoya','551-596 Viverra Street','1-868-252-6798','Silver','[email protected]',638),
(82,'Phelan Knapp','1277 Vitae St.','1-365-579-0065','Silver','[email protected]',636),
(83,'Magee Maldonado','Ap #811-7325 Suspendisse St.','1-776-943-9121','Silver','[email protected]',634),
(84,'Dustin Hines','"5610 Amet, Ave"','1-177-785-2615','Silver','[email protected]',632),
(85,'Paki Parker','"P.O. Box 558, 3061 Fringilla Street"','1-869-876-9232','Silver','[email protected]',630),
(86,'Colin Berry','635-7578 Duis Street','1-663-225-0964','Silver','[email protected]',628),
(87,'Harper Stanley','8949 Ipsum Avenue','1-288-430-5422','Silver','[email protected]',626),
(88,'Dillon Mayo','231-1696 Aliquam Rd.','1-929-278-0156','Silver','[email protected]',624),
(89,'Hamish Moody','"P.O. Box 415, 9254 Mauris Road"','1-877-631-5403','Silver','[email protected]',622),
(90,'Aidan Hensley','Ap #547-4708 Lorem Avenue','1-746-826-2535','Silver','[email protected]',620),
(91,'Mark Trujillo','964-3467 Quis Rd.','1-441-860-0992','Silver','[email protected]',618),
(92,'Barrett Stephenson','Ap #781-395 Felis. Avenue','1-171-760-2543','Silver','[email protected]',616),
(93,'Ross Humphrey','2794 Faucibus St.','1-972-560-3542','Silver','[email protected]',614),
(94,'Adrian Cotton','"P.O. Box 833, 3769 Quisque Street"','1-442-276-0133','Silver','[email protected]',612),
(95,'Daquan Clemons','7539 Sit Ave','1-273-153-9038','Silver','[email protected]',610),
(96,'Hall Grimes','824-5976 Dignissim Road','1-664-888-7297','Silver','[email protected]',608),
(97,'Guy Alford','Ap #565-4517 Quisque Ave','1-497-348-0960','Silver','[email protected]',606),
(98,'Reed Bond','"P.O. Box 894, 4386 Odio. St."','1-458-820-4944','Silver','[email protected]',604),
(99,'Barry Vaughn','635-7482 Pellentesque St.','1-215-376-9606','Silver','[email protected]',602),
(100,'Kenyon Santos','401-2976 Massa. St.','1-492-757-0596','Silver','[email protected]',600);
UNLOCK TABLES;
/*!40000 ALTER TABLE `customer` ENABLE KEYS */;
--
-- Table structure for table `applications`
--
DROP TABLE IF EXISTS `applications`;
CREATE TABLE `applications` (
`applicationid` CHAR(36) NOT NULL,
`loantype` varchar(10) NOT NULL,
`amount` bigint(100) default NULL,
`customerid` bigint(10) default NULL,
`applicationstatus` varchar(10) default NULL,
PRIMARY KEY (`applicationid`),
UNIQUE KEY `applicationid` (`applicationid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
commit;