· 8 years ago · Jan 14, 2018, 02:26 PM
1USE master
2
3--Delete database if it exists--
4
5IF EXISTS(select * from sys.databases where name='BikeRentalSystem')
6DROP DATABASE BikeRentalSystem
7GO
8CREATE DATABASE BikeRentalSystem
9GO
10
11USE BikeRentalSystem
12
13
14--Delete tables if they exist--
15
16if exists(select * from sysobjects where id = object_id('CreditDebitTrans'))
17drop table CreditDebitTrans
18go
19
20if exists(select * from sysobjects where id = object_id('Ride'))
21drop table Ride
22go
23
24if exists(select * from sysobjects where id = object_id('BikeReservation'))
25drop table BikeReservation
26go
27
28if exists(select * from sysobjects where id = object_id('Fault'))
29drop table Fault
30go
31
32if exists(select * from sysobjects where id = object_id('Comment'))
33drop table Comment
34go
35
36if exists(select * from sysobjects where id = object_id('Feedback'))
37drop table Feedback
38go
39
40if exists(select * from sysobjects where id = object_id('Member'))
41drop table Member
42go
43
44if exists(select * from sysobjects where id = object_id('Bike'))
45drop table Bike
46go
47
48if exists(select * from sysobjects where id = object_id('BikeStop'))
49drop table BikeStop
50go
51
52if exists(select * from sysobjects where id = object_id('Promotion'))
53drop table Promotion
54go
55
56if exists(select * from sysobjects where id = object_id('FaultType'))
57drop table FaultType
58go
59
60if exists(select * from sysobjects where id = object_id('MaintItem'))
61drop table MaintItem
62go
63
64if exists(select * from sysobjects where id = object_id('MaintType'))
65drop table MaintType
66go
67
68if exists(select * from sysobjects where id = object_id('Repair'))
69drop table Repair
70go
71
72if exists(select * from sysobjects where id = object_id('Maintenance'))
73drop table Maintenance
74go
75
76if exists(select * from sysobjects where id = object_id('CreditCard'))
77drop table CreditCard
78go
79
80
81--Creating tables--
82
83
84Create table Member
85(
86 MemberID char(6) NOT NULL,
87 Name varchar(30) NOT NULL,
88 Email varchar(40) NULL,
89 Phone char(8) NOT NULL,
90 RewardPts smallint NOT NULL DEFAULT(0),
91 Deposit money NOT NULL DEFAULT(50),
92 CreditBalance money NOT NULL DEFAULT(0),
93 DateJoin date NOT NULL DEFAULT(GETDATE()),
94
95 CONSTRAINT Pk_Member PRIMARY KEY(MemberID),
96 CONSTRAINT Chk_Phone CHECK(Phone like '[6,8,9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'),
97 CONSTRAINT Chk_Email CHECK(Email like '[0-9A-Za-z]%@[A-Za-z]%.com' or Email like '[0-9A-Za-z]%@[A-Za-z]%.com.sg')
98)
99
100
101Create table BikeStop
102(
103 BikeStopID char(2) NOT NULL,
104 StopLat decimal(7,6) NOT NULL,
105 StopLong decimal(9,6) NOT NULL,
106 StopRadius smallint NOT NULL,
107
108 CONSTRAINT Pk_BikeStop PRIMARY KEY(BikeStopID),
109 CONSTRAINT Chk_StopRadius CHECK(StopRadius between 5 and 25)
110)
111
112Create table Bike
113(
114 BikeID char(4) NOT NULL,
115 Rate smallint NOT NULL,
116 Status varchar(2) NOT NULL CHECK(Status IN ('W', 'NR', 'R')),
117 LastServicedDate datetime NULL,
118 BikeStopID char(2) NOT NULL,
119
120 CONSTRAINT Pk_Bike PRIMARY KEY(BikeID),
121 CONSTRAINT Fk_Bike_BikeStopID FOREIGN KEY (BikeStopID) REFERENCES BikeStop(BikeStopID)
122)
123
124
125Create table BikeReservation
126(
127 ReservationID char(4) NOT NULL,
128 MemberID char(6) NOT NULL,
129 BikeID char(4) NOT NULL,
130 ResStatus char(1) NOT NULL,
131 DateTimeRes datetime NOT NULL DEFAULT(GETDATE()),
132 DateTimeReservedFor datetime NOT NULL,
133
134 CONSTRAINT Pk_ReservationID PRIMARY KEY(ReservationID),
135 CONSTRAINT Fk_BikeReservation_MemberID FOREIGN KEY(MemberID) REFERENCES Member(MemberID),
136 CONSTRAINT Fk_BikeReservation_BikeID FOREIGN KEY(BikeID) REFERENCES Bike(BikeID),
137 CONSTRAINT Chk_ResStatus CHECK(ResStatus IN ('O', 'F')),
138 CONSTRAINT Chk_DateTimeReservedFor CHECK(DateTimeReservedFor >= DateTimeRes)
139
140)
141
142Create table Promotion
143(
144 PromoCode varchar(10) NOT NULL,
145 PromoDesc varchar(50) NULL,
146 PromoRate decimal(3,2) NOT NULL,
147 StartDate date NOT NULL,
148 EndDate date NOT NULL,
149
150 CONSTRAINT Pk_Promotion PRIMARY KEY(PromoCode),
151 CONSTRAINT Chk_StartDate CHECK(StartDate <= GETDATE()),
152 CONSTRAINT Chk_EndDate CHECK(EndDate >= StartDate)
153)
154
155Create table Ride
156(
157 RideID char(6) NOT NULL,
158 DateTimeStart datetime NOT NULL,
159 DateTimeEnd datetime NULL,
160 Duration as DATEDIFF (minute, DateTimeStart, DateTimeEnd),
161 RidePts Int NOT NULL DEFAULT(0),
162 Distance Decimal(5,3) NULL,
163 PtsRedeemed Int NOT NULL DEFAULT(0),
164 Cost smallmoney NULL,
165 MemberID char(6) NULL,
166 BikeID char(4) NULL,
167 BikeStopID char(2) NULL,
168 PromoCode varchar(10) NULL,
169
170 CONSTRAINT Pk_Ride PRIMARY KEY(RideID),
171 CONSTRAINT Fk_Ride_MemberID FOREIGN KEY(MemberID) REFERENCES Member(MemberID),
172 CONSTRAINT Fk_Ride_BikeID FOREIGN KEY(BikeID) REFERENCES Bike(BikeID),
173 CONSTRAINT Fk_Ride_BikeStopID FOREIGN KEY(BikeStopID) REFERENCES BikeStop(BikeStopID),
174 CONSTRAINT Fk_Ride_PromoCode FOREIGN KEY(PromoCode) REFERENCES Promotion(PromoCode),
175 CONSTRAINT Chk_DateTimeEnd CHECK(DateTimeEnd > DateTimeStart),
176 CONSTRAINT Chk_PtsRedeemed CHECK(PtsRedeemed % 50 = 0)
177)
178
179Create table Feedback
180(
181 FBID char(5) NOT NULL,
182 FBDateTime datetime NOT NULL DEFAULT(GETDATE()),
183 MemberID char(6) NOT NULL,
184
185 CONSTRAINT Pk_Feedback PRIMARY KEY(FBID),
186 CONSTRAINT Fk_Feedback_MemberID FOREIGN KEY(MemberID) REFERENCES Member(MemberID)
187)
188
189
190Create table FaultType
191(
192 FaultCode char(4) NOT NULL,
193 FaultDesc varchar(500) NOT NULL,
194
195 CONSTRAINT Pk_FaultType PRIMARY KEY(FaultCode),
196)
197
198Create table Maintenance
199(
200 MaintID char(5) NOT NULL,
201 MaintDate date NOT NULL,
202 BikeID char(4) NOT NULL,
203
204 CONSTRAINT Pk_Maintenance PRIMARY KEY(MaintID),
205 CONSTRAINT Chk_MaintDate CHECK(MaintDate <= GETDATE()),
206 CONSTRAINT Fk_Maintenance_BikeID FOREIGN KEY(BikeID) REFERENCES Bike(BikeID)
207)
208
209
210Create table Repair
211(
212 MaintID char(5) NOT NULL,
213 MaintDate date NOT NULL,
214 BikeID char(4) NOT NULL,
215
216 CONSTRAINT Pk_Repair PRIMARY KEY(MaintID),
217 CONSTRAINT Fk_Repair_MaintID FOREIGN KEY(MaintID) REFERENCES Maintenance(MaintID),
218 CONSTRAINT Chk_Repair_MaintDate CHECK(MaintDate <= GETDATE()),
219 CONSTRAINT Fk_Repair_BikeID FOREIGN KEY(BikeID) REFERENCES Bike(BikeID)
220)
221
222Create table MaintType
223(
224 TypeCode char(5) NOT NULL,
225 TypeDesc varchar(50) NOT NULL,
226
227 CONSTRAINT Pk_MaintType PRIMARY KEY (TypeCode)
228)
229
230Create table MaintItem
231(
232 SNo char(2) NOT NULL,
233 MaintID char(5) NOT NULL,
234 MaintDesc varchar(100) NOT NULL,
235 TypeCode char(5) NULL,
236
237 CONSTRAINT Pk_MaintItem PRIMARY KEY (SNo, MaintID),
238 CONSTRAINT Fk_MaintItem_MaintID FOREIGN KEY (MaintID) REFERENCES Maintenance (MaintID) ON DELETE CASCADE,
239 CONSTRAINT Fk_MaintItem_TypeCode FOREIGN KEY (TypeCode) REFERENCES MaintType (TypeCode)
240)
241
242Create table Fault
243(
244 FBID char(5) NOT NULL,
245 FBDateTime datetime NOT NULL,
246 FaultCat varchar(15) NOT NULL,
247 MemberID char(6) NOT NULL,
248 FaultCode char(4) NULL,
249 BikeID char(4) NOT NULL,
250 MaintID char(5) NOT NULL,
251
252 CONSTRAINT Pk_Fault PRIMARY KEY (FBID),
253 CONSTRAINT FK_Fault_FBID FOREIGN KEY(FBID) REFERENCES Feedback(FBID),
254 CONSTRAINT Fk_Fault_MemberID FOREIGN KEY (MemberID) REFERENCES Member (MemberID),
255 CONSTRAINT Fk_Fault_FaultCode FOREIGN KEY(FaultCode) REFERENCES FaultType(FaultCode),
256 CONSTRAINT Fk_Fault_BikeID FOREIGN KEY(BikeID) REFERENCES Bike(BikeID),
257 CONSTRAINT Fk_Fault_MaintID FOREIGN KEY(MaintID) REFERENCES Maintenance(MaintID),
258 CONSTRAINT Chk_Fault_FaultCat CHECK(FaultCat IN ('Tire', 'Pedal', 'Seat', 'Basket', 'Lock', 'Frame', 'Others'))
259)
260
261Create table Comment
262(
263 FBID char(5) NOT NULL,
264 FBDateTime datetime NOT NULL,
265 FBMessage varchar(1000) NULL,
266 MemberID char(6) NOT NULL,
267
268 CONSTRAINT Pk_Comment PRIMARY KEY(FBID),
269 CONSTRAINT Fk_Comment_FBID FOREIGN KEY(FBID) REFERENCES Feedback(FBID),
270 CONSTRAINT Fk_Comment_MemberID FOREIGN KEY (MemberID) REFERENCES Member(MemberID),
271 CONSTRAINT Chk_FBDateTime CHECK(FBDateTime <= GETDATE())
272)
273
274Create table CreditCard
275(
276 CardNo char(6) NOT NULL,
277 CardType varchar(30) NOT NULL,
278 ExpiryDate date NOT NULL,
279 CVV char(3) NOT NULL,
280 MemberID char(6) NOT NULL,
281
282 CONSTRAINT Pk_CreditCard PRIMARY KEY(CardNo),
283 CONSTRAINT Chk_ExpiryDate CHECK(ExpiryDate >= GETDATE()),
284 CONSTRAINT Fk_MemberID FOREIGN KEY (MemberID) REFERENCES Member(MemberID),
285)
286
287Create table CreditDebitTrans
288(
289 TransID char(6) NOT NULL,
290 TransAmt smallmoney NOT NULL,
291 TransType varchar(6) NOT NULL,
292 TransDateTime datetime NOT NULL default(GETDATE()),
293 CardNo char(6) NOT NULL,
294 RideID char(6) NOT NULL,
295
296 CONSTRAINT Pk_CreditDebitTrans PRIMARY KEY(TransID),
297 CONSTRAINT Fk_CreditDebitTrans_CardNo FOREIGN KEY(CardNo) REFERENCES CreditCard(CardNo),
298 CONSTRAINT Fk_CreditDebitTrans_RideID FOREIGN KEY(RideID) REFERENCES Ride(RideID),
299 CONSTRAINT Chk_TransType CHECK(TransType in ('Credit','Debit'))
300)
301
302
303
304
305--Inserting values--
306
307insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AA',1.335512, 103.962087, 25)
308insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AB',1.340790, 103.950886, 20)
309insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AC',1.345273, 103.939234, 15)
310insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AD',1.334727, 103.764290, 10)
311insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AE',1.359096, 103.893723, 5)
312insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AF',1.366304, 103.947624, 25)
313insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AG',1.446274, 103.823685, 10)
314insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AH',1.394791, 103.906769, 15)
315insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AI',1.312760, 103.767380, 25)
316insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AJ',1.327176, 103.688416, 25)
317insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AK',1.444214, 103.788666, 20)
318insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AL',1.392389, 103.904709, 10)
319insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AM',1.381405, 103.890633, 5)
320insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AN',1.377630, 103.879646, 5)
321insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AO',1.328892, 103.744720, 25)
322
323insert into Bike VALUES ('1AAA', 0.5, 'W', '2016-10-10', 'AA')
324insert into Bike VALUES ('2BBB', 0.5, 'W', '2009-02-02', 'AB')
325insert into Bike VALUES ('3CCC', 0.5, 'W', '2010-03-03', 'AA')
326insert into Bike VALUES ('4DDD', 0.5, 'R', '2010-04-04', 'AC')
327insert into Bike VALUES ('5EEE', 0.5, 'W', '2011-05-05', 'AD')
328insert into Bike VALUES ('6FFF', 0.5, 'W', '2015-06-06', 'AE')
329insert into Bike VALUES ('7GGG', 0.5, 'NR', '2017-03-23','AB')
330insert into Bike VALUES ('8HHH', 0.5, 'W', '2012-03-03', 'AA')
331insert into Bike VALUES ('9III', 0.5, 'W', '2014-08-08', 'AG')
332insert into Bike VALUES ('JJJ1', 0.5, 'W', '2013-10-20', 'AH')
333insert into Bike VALUES ('KKK2', 0.5, 'W', '2013-07-12', 'AI')
334insert into Bike VALUES ('LLL3', 0.5, 'NR', '2014-11-21', 'AJ')
335insert into Bike VALUES ('MMM4', 0.5, 'W', '2010-03-15', 'AH')
336insert into Bike VALUES ('NNN5', 0.5, 'W', '2018-01-02', 'AA')
337insert into Bike VALUES ('OOO6', 0.5, 'W', '2018-01-10', 'AO')
338
339insert into Member (MemberID, Name, Email, Phone, RewardPts, Deposit, CreditBalance, DateJoin) values ('11111B','John Bruce', 'jhonbruce@gmail.com.sg', '90000001', 6, 100, 200, '2017-08-01')
340insert into Member values ('22222C','Tom Harrison', 'tomharrison@gmail.com', '90000002', 15, 60, 50, '2017-01-03')
341insert into Member (MemberID, Name, Email, Phone, Deposit, CreditBalance, DateJoin) values ('33333D','Zachary Tan', 'zacharytan@gmail.com', '90000003', 80, 200, '2016-12-01')
342insert into Member (MemberID, Name, Email, Phone, RewardPts, CreditBalance, DateJoin) values ('44444E','Tammy Lee', 'tammylee@hotmail.com.sg', '90000004', 24, 200, '2016-05-01')
343insert into Member values ('55555F','Monica Cheng', 'monicacheng@gmail.com', '90000005', 29, 140, 350, '2015-10-15')
344insert into Member values ('66666G','Javier Tang', 'javiertang@gmail.com', '90000006', 33, 120, 400, '2015-06-01')
345insert into Member (MemberID, Name, Email, Phone, RewardPts) values ('77777H','Shaun Jacob', 'shaunjacob@hotmail.com.sg', '90000007', 6)
346insert into Member values ('88888I','William Johnson', 'willianjohnson@gmail.com', '90000008', 42, 150, 25, '2014-09-09')
347insert into Member (MemberID, Name, Email, Phone, RewardPts, Deposit, DateJoin) values ('99999J','James Bruce', 'jamesbruce@gmail.com.sg', '90000009', 45, 170, '2013-06-09')
348insert into Member (MemberID, Name, Email, Phone, Deposit, DateJoin) values ('AAAAA1','Wayne', 'xxxwayne999@gmail.com', '80000000', 200, '2012-07-22')
349insert into Member (MemberID, Name, Email, Phone, RewardPts) values ('BBBBB2','Jennifer Pang', 'jenniferpang@gmail.com', '80000001', 6)
350insert into Member (MemberID, Name, Email, Phone, RewardPts, DateJoin) values ('CCCCC3','Ethan Bradberry', 'ethanbradberry@hotmail.com.sg', '80000002', 55, '2011-11-11')
351insert into Member values ('DDDDD4','Daniel Lim', 'daniellim@gmail.com', '80000003', 69, 170, 46, '2010-10-10')
352insert into Member (MemberID, Name, Email, Phone, CreditBalance, DateJoin) values ('EEEEE5','Lucas Paul', 'lucaspaul@gmail.com.sg', '80000004', 100, '2009-09-09')
353insert into Member values ('FFFFF6', 'Jack Lee', 'jacklee99@hotmail.com.sg', '80000005', 15, 55, 31, '2008-08-08')
354insert into Member values ('GGGGG7', 'Mary Tan', 'marytan@yahoo.com.sg', '80000006', 12, 60, 12, '2017-10-18')
355insert into Member values ('HHHHH8', 'Tom Everson', 'tomeve@yahoo.com', '80000007', 16, 56, 15, '2017-08-28')
356insert into Member values ('IIIII9', 'Claudia Koh', 'claudia13@yahoo.com.sg', '80000008', 21, 53, 35, '2008-09-17')
357insert into Member (MemberID, Name, Email, Phone, RewardPts, Deposit, DateJoin) values ('JJJJJ1', 'Nicholas Paris', 'parisnicalo@yahoo.com', '80000009', 34, 55, '2016-02-25')
358insert into Member (MemberID, Name, Email, Phone, RewardPts, CreditBalance, DateJoin) values ('KKKKK2', 'Jackson Yi', 'yi08@yahoo.com', '80000010', 56, 2, '2016-03-26')
359
360insert into BikeReservation values ('0001','55555F', '4DDD', 'F', '2011-04-04 04:04:04', '2011-04-04 04:34:04')
361insert into BikeReservation values ('0002','44444E', '5EEE', 'F', '2011-05-05 05:05:05', '2011-05-05 05:15:05')
362insert into BikeReservation values ('0003','77777H', '3CCC', 'F', '2010-03-03 03:03:03', '2010-03-03 03:23:03')
363insert into BikeReservation values ('0004','88888I', '9III', 'O', '2018-01-11 09:09:09', '2018-01-16 17:10:09')
364insert into BikeReservation values ('0005','CCCCC3', 'LLL3', 'O', '2018-01-10 11:11:11', '2018-01-16 11:15:20')
365insert into BikeReservation values ('0006','FFFFF6', '1AAA', 'F', '2008-01-01 01:01:01', '2008-01-01 01:11:01')
366insert into BikeReservation values ('0007','AAAAA1', 'NNN5', 'F', '2017-02-03 13:13:13', '2017-02-03 13:23:13')
367insert into BikeReservation values ('0008','EEEEE5', 'KKK2', 'F', '2014-11-11 10:10:10', '2014-11-11 10:20:10')
368insert into BikeReservation values ('0009','DDDDD4', 'OOO6', 'F', '2017-03-04 14:14:14', '2017-03-04 14:54:14')
369insert into BikeReservation values ('0010','55555F', '6FFF', 'O', '2018-01-10 06:06:06', '2018-01-16 18:16:06')
370insert into BikeReservation values ('0011','99999J', 'JJJ1', 'F', '2014-10-10 09:09:10', '2014-10-10 09:09:20')
371insert into BikeReservation values ('0012','66666G', '7GGG', 'F', '2013-07-07 07:07:07', '2013-07-07 07:27:07')
372insert into BikeReservation values ('0013','77777H', '8HHH', 'F', '2013-08-08 08:08:08', '2013-08-08 08:28:08')
373insert into BikeReservation values ('0014','BBBBB2', 'MMM4', 'F', '2017-01-02 12:12:12', '2017-01-02 12:15:12')
374insert into BikeReservation values ('0015','11111B', '2BBB', 'F', '2009-02-02 02:02:02', '2009-02-02 02:12:02')
375insert into BikeReservation values ('0016','55555F', '6FFF', 'F', '2017-12-25 16:06:05', '2018-01-10 20:18:27')
376insert into BikeReservation values ('0017','55555F', 'KKK2', 'O', '2018-01-10 19:34:56', '2018-01-15 18:16:06')
377insert into BikeReservation values ('0018','77777H', 'NNN5', 'O', '2018-01-13 10:05:05', '2018-01-16 15:22:46')
378insert into BikeReservation values ('0019','77777H', 'OOO6', 'F', '2017-12-20 09:35:23', '2017-12-25 12:20:36')
379insert into BikeReservation values ('0020','88888I', '4DDD', 'F', '2017-12-29 20:34:21', '2018-01-04 13:29:50')
380insert into BikeReservation values ('0021','CCCCC3', '8HHH', 'O', '2018-01-14 21:09:35', '2018-01-15 10:12:27')
381
382insert into Promotion values ('Promo01', 'Get 5% off of total price of the ride', 0.05, '2008-01-01', '2008-03-04')
383insert into Promotion values ('Promo02', 'Get 25% off of total price of the ride', 0.25, '2008-04-11', '2008-06-19')
384insert into Promotion values ('Promo03', 'Get 30% off of total price of the ride', 0.30, '2008-08-01', '2018-12-09')
385insert into Promotion values ('Promo04', 'Get 20% off of total price of the ride', 0.20, '2009-02-13', '2009-04-01')
386insert into Promotion values ('Promo05', 'Get 10% off of total price of the ride', 0.10, '2009-06-01', '2009-08-20')
387insert into Promotion values ('Promo06', 'Get 30% off of total price of the ride', 0.30, '2010-01-01', '2010-02-01')
388insert into Promotion values ('Promo07', 'Get 60% off of total price of the ride', 0.60, '2010-02-28', '2010-06-30')
389insert into Promotion values ('Promo08', 'Get 80% off of total price of the ride', 0.80, '2011-08-21', '2011-09-01')
390insert into Promotion values ('Promo09', 'Get 90% off of total price of the ride', 0.90, '2011-08-10', '2011-12-14')
391insert into Promotion values ('Promo10', 'Get 10% off of total price of the ride', 0.10, '2011-10-15', '2011-12-16')
392insert into Promotion values ('Promo11', 'Get 15% off of total price of the ride', 0.15, '2012-06-23', '2012-12-31')
393insert into Promotion values ('Promo12', 'Get 33% off of total price of the ride', 0.33, '2013-02-11', '2013-04-01')
394insert into Promotion values ('Promo13', 'Get 25% off of total price of the ride', 0.25, '2014-01-05', '2014-08-07')
395insert into Promotion values ('Promo14', 'Get 55% off of total price of the ride', 0.55, '2015-11-03', '2016-03-18')
396insert into Promotion values ('Promo15', 'Get 75% off of total price of the ride', 0.75, '2017-06-20', '2018-01-02')
397
398INSERT INTO Ride VALUES('1AAAAA', '2008-01-01 01:11:01', '2008-01-27 01:31:01', 20, 5.00, 0, 0.50, 'FFFFF6', '1AAA', 'AA', 'Promo01')
399INSERT INTO Ride VALUES('1BBBBB', '2008-03-04 13:01:01', '2008-03-04 13:31:01', 30, 6.50, 0, 0.50, '11111B', '2BBB', 'AC', 'Promo02')
400INSERT INTO Ride VALUES('1CCCCC', '2009-04-05 13:30:00', '2009-04-05 14:10:00', 40, 7.00, 0, 0.50, 'IIIII9', '3CCC', 'AD', Null)
401INSERT INTO Ride VALUES('1DDDDD', '2010-05-06 14:10:00', '2010-05-06 14:20:00', 50, 8.50, 50, 0.50, '33333D', '4DDD', 'AE', 'Promo07')
402INSERT INTO Ride VALUES('1EEEEE', '2011-08-30 16:35:00', '2011-09-10 17:30:00', 55, 9.00, 50, 0.50, '44444E', '1AAA', 'AG', 'Promo08')
403INSERT INTO Ride VALUES('1FFFFF', '2011-04-04 04:34:04', '2011-04-04 05:34:04', 60, 10.00, 50, 0.50, '55555F', '5EEE', 'AH', 'Promo10')
404INSERT INTO Ride VALUES('1GGGGG', '2013-08-08 08:28:08', '2013-08-08 08:43:08', 15, 4.50, 0, 0.50, 'GGGGG7', '7GGG', 'AJ', Null)
405INSERT INTO Ride VALUES('1HHHHH', '2011-07-07 09:00:00', '2011-07-07 09:10:00', 10, 4.00, 0, 0.50, '77777H', '9III', 'AK', 'Promo08')
406INSERT INTO Ride VALUES('1IIIII', '2012-06-06 01:16:06', '2012-06-06 06:46:06', 30, 6.35, 0, 0.50, '88888I', 'LLL3', 'AM', 'Promo11')
407INSERT INTO Ride VALUES('1JJJJJ', '2011-08-21 09:09:20', '2011-08-30 09:49:46', 40, 7.10, 0, 0.50, '44444E', 'JJJ1', 'AO', 'Promo08')
408INSERT INTO Ride VALUES('1KKKKK', '2013-01-01 01:01:01', '2013-01-01 02:01:01', 60, 10.10, 50, 0.50, 'AAAAA1', 'OOO6', 'AN', 'Promo09')
409INSERT INTO Ride VALUES('1LLLLL', '2014-01-01 01:01:01', '2014-01-01 01:51:01', 50, 9.45, 50, 0.50, 'BBBBB2', 'NNN5', 'AM', 'Promo13')
410INSERT INTO Ride VALUES('1MMMMM', '2015-01-01 01:01:01', '2015-01-01 03:01:01', 120, 21.10, 100, 1.40, 'HHHHH8', '8HHH', 'AA', Null)
411INSERT INTO Ride VALUES('1NNNNN', '2008-02-28 14:54:14', '2008-03-03 15:19:14', 25, 6.00, 0, 0.50, 'FFFFF6', 'OOO6', 'AB', 'Promo01')
412INSERT INTO Ride VALUES('1OOOOO', '2014-11-11 10:20:10', '2014-11-11 10:30:10', 10, 4.25, 0, 0.50, 'EEEEE5', 'KKK2', 'AC', Null)
413INSERT INTO Ride VALUES('1PPPPP', '2008-01-01 01:01:01', '2008-02-20 02:01:01', 60, 10.10, 50, 0.50, 'FFFFF6', 'OOO6', 'AN', 'Promo01')
414INSERT INTO Ride VALUES('1QQQQQ', '2014-01-01 01:01:01', '2014-01-01 01:51:01', 50, 9.45, 50, 0.50, 'GGGGG7', 'NNN5', 'AM', 'Promo13')
415INSERT INTO Ride VALUES('1RRRRR', '2011-07-29 13:30:00', '2011-08-21 14:30:00', 60, 18.00, 50, 0.50, 'JJJJJ1', '4DDD', 'AO', 'Promo08')
416INSERT INTO Ride VALUES('1SSSSS', '2017-05-05 15:00:00', '2018-01-01 16:00:00', 60, 15.00, 50, 0.50, 'KKKKK2', 'LLL3', 'AB', Null)
417
418INSERT INTO Feedback VALUES ('00001', '2017-03-04 00:14:14', 'FFFFF6')
419INSERT INTO Feedback VALUES ('00002', '2010-01-07 12:59:12', '22222C')
420INSERT INTO Feedback VALUES ('00003', '2016-12-14 02:49:45', '11111B')
421INSERT INTO Feedback VALUES ('00004', '2014-02-24 18:17:10', '33333D')
422INSERT INTO Feedback VALUES ('00005', '2015-02-15 19:37:20', 'FFFFF6')
423INSERT INTO Feedback VALUES ('00006', '2013-11-25 20:18:30', 'AAAAA1')
424INSERT INTO Feedback VALUES ('00007', '2017-05-05 11:58:40', '44444E')
425INSERT INTO Feedback VALUES ('00008', '2012-07-03 22:28:50', '66666G')
426INSERT INTO Feedback VALUES ('00009', '2012-04-30 19:54:12', '77777H')
427INSERT INTO Feedback VALUES ('00010', '2011-03-29 10:34:14', 'FFFFF6')
428INSERT INTO Feedback VALUES ('00011', '2017-11-19 03:45:17', '55555F')
429INSERT INTO Feedback VALUES ('00012', '2016-05-01 04:12:56', '55555F')
430INSERT INTO Feedback VALUES ('00013', '2011-01-03 11:27:45', '11111B')
431INSERT INTO Feedback VALUES ('00014', '2015-01-14 07:17:34', 'EEEEE5')
432INSERT INTO Feedback VALUES ('00015', '2012-04-02 09:09:21', 'BBBBB2')
433INSERT INTO Feedback VALUES ('10001', '2017-02-10 01:02:35', 'HHHHH8')
434INSERT INTO Feedback VALUES ('20002', '2017-05-13 03:09:23', 'CCCCC3')
435INSERT INTO Feedback VALUES ('30003', '2016-03-26 23:02:13', 'GGGGG7')
436INSERT INTO Feedback VALUES ('40004', '2016-07-17 12:24:45', '66666G')
437INSERT INTO Feedback VALUES ('50005', '2015-07-06 07:12:07', 'AAAAA1')
438INSERT INTO Feedback VALUES ('60006', '2015-10-09 06:23:46', 'HHHHH8')
439INSERT INTO Feedback VALUES ('70007', '2014-01-19 03:59:00', 'CCCCC3')
440INSERT INTO Feedback VALUES ('80008', '2014-04-03 14:34:25', '99999J')
441INSERT INTO Feedback VALUES ('90009', '2013-02-20 16:45:50', 'JJJJJ1')
442INSERT INTO Feedback VALUES ('11011', '2013-07-21 20:34:01', 'HHHHH8')
443INSERT INTO Feedback VALUES ('22022', '2012-08-26 18:09:23', 'BBBBB2')
444INSERT INTO Feedback VALUES ('33033', '2012-02-14 06:45:50', 'IIIII9')
445INSERT INTO Feedback VALUES ('44044', '2011-03-18 04:34:10', 'HHHHH8')
446INSERT INTO Feedback VALUES ('55055', '2011-06-22 16:23:57', 'IIIII9')
447INSERT INTO Feedback VALUES ('66066', '2010-04-22 18:34:49', 'CCCCC3')
448
449INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00001', '2017-03-04 00:14:14', 'Message01', 'FFFFF6')
450INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00002', '2010-01-07 12:59:12', 'Message02', '22222C')
451INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00003', '2016-12-14 02:49:45', 'Message03', '11111B')
452INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00004', '2014-02-24 18:17:10', 'Message04', '33333D')
453INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00005', '2015-02-15 19:37:20', 'Message05', 'FFFFF6')
454INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00006', '2013-11-25 20:18:30', 'Message06', 'AAAAA1')
455INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00007', '2017-08-05 11:58:40', 'Message07', '44444E')
456INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00008', '2012-07-03 22:28:50', 'Message08', '66666G')
457INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00009', '2012-04-30 19:54:12', 'Message09', '77777H')
458INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00010', '2011-03-29 10:34:14', 'Message10', 'FFFFF6')
459INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00011', '2017-11-19 03:45:17', 'Message11', '55555F')
460INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00012', '2016-12-01 04:12:56', 'Message12', '55555F')
461INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00013', '2011-01-03 11:27:45', 'Message13', '11111B')
462INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00014', '2015-01-14 07:17:34', 'Message14', 'EEEEE5')
463INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00015', '2012-04-02 09:09:21', 'Message15', 'BBBBB2')
464
465INSERT INTO FaultType VALUES('TI-1','Tires are punctured')
466INSERT INTO FaultType VALUES('TI-2','Tires are worn out')
467INSERT INTO FaultType VALUES('TI-3','Tires misshaped')
468INSERT INTO FaultType VALUES('BA-1','A part of the basket is broken off')
469INSERT INTO FaultType VALUES('BA-2','Basket has been misshaped by force')
470INSERT INTO FaultType VALUES('BA-3','Basket is almost / already detached from the rest of the bike' )
471INSERT INTO FaultType VALUES('SE-1','Seat covering is torn off (or a portion of it)')
472INSERT INTO FaultType VALUES('SE-2','Seat is physically damaged')
473INSERT INTO FaultType VALUES('LO-1','Lock is broken, completely insecure')
474INSERT INTO FaultType VALUES('LO-2','Lock does not work')
475INSERT INTO FaultType VALUES('PE-1','Pedal(s) is / are loose')
476INSERT INTO FaultType VALUES('PE-2','Pedal(s) is / are missing')
477INSERT INTO FaultType VALUES('FR-1','Frame is dented in')
478INSERT INTO FaultType VALUES('FR-2','Paint on frame has been scraped off')
479INSERT INTO FaultType VALUES('OO-1','Bicycle is unlocked')
480
481INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0001', '2010-06-01', '1AAA')
482INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0002', '2009-02-02', '2BBB')
483INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0003', '2010-03-03', '3CCC')
484INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0004', '2012-04-15', '4DDD')
485INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0005', '2011-05-05', '5EEE')
486INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0006', '2015-12-19', 'JJJ1')
487INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0007', '2013-07-07', '1AAA')
488INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0008', '2014-04-01', '9III')
489INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0009', '2014-03-19', 'KKK2')
490INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0010', '2016-10-10', '1AAA')
491INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0011', '2017-03-29', 'OOO6')
492INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0012', '2010-12-12', 'KKK2')
493INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0013', '2017-05-01', 'NNN5')
494INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0014', '2011-02-02', 'MMM4')
495INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0015', '2012-03-03', '8HHH')
496INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0016', '2013-07-30', '6FFF')
497INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0017', '2011-05-25', '3CCC')
498
499INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0001', '2008-01-01', '1AAA')
500INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0002', '2009-02-02', '2BBB')
501INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0003', '2010-03-03', '3CCC')
502INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0004', '2010-04-04', '4DDD')
503INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0005', '2011-05-05', '5EEE')
504INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0006', '2012-06-06', '6FFF')
505INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0007', '2013-07-07', '1AAA')
506INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0008', '2014-08-08', '9III')
507INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0009', '2015-09-09', 'KKK2')
508INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0010', '2016-10-10', '1AAA')
509INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0011', '2017-11-11', 'OOO6')
510INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0012', '2010-12-12', 'KKK2')
511INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0013', '2008-01-01', 'NNN5')
512INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0014', '2011-02-02', 'MMM4')
513INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0015', '2012-03-03', '8HHH')
514
515INSERT INTO Fault VALUES('10001','2017-02-10 01:02:35','tire', 'HHHHH8','TI-1','OOO6', 'A0015')
516INSERT INTO Fault VALUES('20002','2017-05-13 03:09:23','basket', 'CCCCC3','BA-1','NNN5', 'A0014')
517INSERT INTO Fault VALUES('30003','2016-03-26 23:02:13', 'lock', 'GGGGG7','TI-2','MMM4', 'A0013')
518INSERT INTO Fault VALUES('40004','2016-07-17 12:24:45', 'others', '66666G','SE-1','LLL3', 'A0012')
519INSERT INTO Fault VALUES('50005','2015-07-06 07:12:07', 'pedal', 'AAAAA1','LO-1','KKK2', 'A0011')
520INSERT INTO Fault VALUES('60006','2015-10-09 06:23:46', 'frame', 'HHHHH8','LO-2','JJJ1', 'A0010')
521INSERT INTO Fault VALUES('70007','2014-01-19 03:59:00', 'basket', 'CCCCC3','BA-2','9III', 'A0009')
522INSERT INTO Fault VALUES('80008','2014-04-03 14:34:25', 'tire', '99999J','PE-1','8HHH', 'A0008')
523INSERT INTO Fault VALUES('90009','2013-02-20 16:45:50', 'frame', 'JJJJJ1','OO-1','7GGG', 'A0007')
524INSERT INTO Fault VALUES('11011','2013-07-21 20:34:01', 'basket', 'HHHHH8','SE-2','6FFF', 'A0006')
525INSERT INTO Fault VALUES('22022','2012-08-26 18:09:23', 'pedal', 'BBBBB2','TI-3','5EEE', 'A0005')
526INSERT INTO Fault VALUES('33033','2012-02-14 06:45:50', 'tire', 'IIIII9','FR-2','4DDD', 'A0004')
527INSERT INTO Fault VALUES('44044','2011-03-18 04:34:10', 'others', 'HHHHH8','PE-2','3CCC', 'A0003')
528INSERT INTO Fault VALUES('55055','2011-06-22 16:23:57', 'lock', 'IIIII9','BA-3','2BBB', 'A0002')
529INSERT INTO Fault VALUES('66066','2010-04-22 18:34:49', 'basket', 'CCCCC3','FR-1','1AAA', 'A0001')
530
531INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA01', 'TDesc01')
532INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA02', 'TDesc02')
533INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA03', 'TDesc03')
534INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA04', 'TDesc04')
535INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA05', 'TDesc05')
536INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA06', 'TDesc06')
537INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA07', 'TDesc07')
538INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA08', 'TDesc08')
539INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA09', 'TDesc09')
540INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA10', 'TDesc10')
541INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA11', 'TDesc11')
542INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA12', 'TDesc12')
543INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA13', 'TDesc13')
544INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA14', 'TDesc14')
545INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA15', 'TDesc15')
546
547INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('01', 'A0015', 'Mdesc01', 'AAA15')
548INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('02', 'A0014', 'Mdesc04', 'AAA14')
549INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('03', 'A0013', 'Mdesc05', 'AAA13')
550INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('04', 'A0012', 'Mdesc06', 'AAA12')
551INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('05', 'A0011', 'Mdesc07', 'AAA11')
552INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('06', 'A0010', 'Mdesc02', 'AAA10')
553INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('07', 'A0009', 'Mdesc03', 'AAA09')
554INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('08', 'A0008', 'Mdesc02', 'AAA08')
555INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('09', 'A0007', 'Mdesc01', 'AAA07')
556INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('10', 'A0006', 'Mdesc05', 'AAA06')
557INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('11', 'A0005', 'Mdesc08', 'AAA05')
558INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('12', 'A0004', 'Mdesc10', 'AAA04')
559INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('13', 'A0003', 'Mdesc06', 'AAA03')
560INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('14', 'A0002', 'Mdesc04', 'AAA02')
561INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('15', 'A0001', 'Mdesc07', 'AAA01')
562
563INSERT INTO CreditCard VALUES('Card01', 'Visa', '2019-01-01', '000', 'FFFFF6')
564INSERT INTO CreditCard VALUES('Card02', 'Master', '2020-01-01', '001', '66666G')
565INSERT INTO CreditCard VALUES('Card03', 'Diners', '2021-01-01', '002', 'FFFFF6')
566INSERT INTO CreditCard VALUES('Card04', 'Master', '2021-01-01', '003', 'BBBBB2')
567INSERT INTO CreditCard VALUES('Card05', 'Express', '2022-01-01', '004', '22222C')
568INSERT INTO CreditCard VALUES('Card06', 'Chase', '2022-01-01', '005', '77777H')
569INSERT INTO CreditCard VALUES('Card07', 'Visa', '2022-01-01', '006', 'EEEEE5')
570INSERT INTO CreditCard VALUES('Card08', 'Visa', '2022-01-01', '007', '11111B')
571INSERT INTO CreditCard VALUES('Card09', 'Diners', '2022-01-01', '008', '55555F')
572INSERT INTO CreditCard VALUES('Card10', 'Express', '2022-01-01', '009', '11111B')
573INSERT INTO CreditCard VALUES('Card11', 'Visa', '2022-01-01', '010', '55555F')
574INSERT INTO CreditCard VALUES('Card12', 'Visa', '2022-01-01', '011', '44444E')
575INSERT INTO CreditCard VALUES('Card13', 'Visa', '2019-01-01', '012', 'FFFFF6')
576INSERT INTO CreditCard VALUES('Card14', 'Master', '2019-01-01', '013', '33333D')
577INSERT INTO CreditCard VALUES('Card15', 'Chase', '2019-01-01', '014', 'AAAAA1')
578INSERT INTO CreditCard VALUES('Card16', 'Master', '2020-04-04', '015', 'JJJJJ1')
579INSERT INTO CreditCard VALUES('Card17', 'Visa', '2021-05-05', '016', 'KKKKK2')
580
581INSERT INTO CreditDebitTrans VALUES ('A00001', '1.50', 'Debit', '2018-01-01 01:31:01', 'card01', '1AAAAA')
582INSERT INTO CreditDebitTrans VALUES ('A00002', '1.00', 'Credit', '2017-11-04 13:31:01', 'card11', '1BBBBB')
583INSERT INTO CreditDebitTrans VALUES ('A00003', '0.50', 'Debit', '2009-04-05 14:10:00', 'card03', '1CCCCC')
584INSERT INTO CreditDebitTrans VALUES ('A00004', '2.00', 'Credit', '2017-10-06 14:10:00', 'card01', '1DDDDD')
585INSERT INTO CreditDebitTrans VALUES ('A00005', '1.50', 'Debit', '2017-09-01 17:30:00', 'card05', '1EEEEE')
586INSERT INTO CreditDebitTrans VALUES ('A00006', '1.00', 'Credit', '2011-04-04 05:34:04', 'card10', '1FFFFF')
587INSERT INTO CreditDebitTrans VALUES ('A00007', '1.50', 'Debit', '2013-08-08 08:43:08', 'card01', '1GGGGG')
588INSERT INTO CreditDebitTrans VALUES ('A00008', '2.00', 'Credit', '2011-07-07 09:10:00', 'card05', '1HHHHH')
589INSERT INTO CreditDebitTrans VALUES ('A00009', '1.00', 'Debit', '2012-06-06 01:46:06', 'card06', '1IIIII')
590INSERT INTO CreditDebitTrans VALUES ('A00010', '0.50', 'Credit', '2012-10-10 09:49:46', 'card07', '1JJJJJ')
591INSERT INTO CreditDebitTrans VALUES ('A00011', '0.50', 'Debit', '2013-01-01 02:01:01', 'card08', '1KKKKK')
592INSERT INTO CreditDebitTrans VALUES ('A00012', '0.50', 'Credit', '2013-01-01 02:01:01', 'card09', '1LLLLL')
593INSERT INTO CreditDebitTrans VALUES ('A00013', '2.50', 'Debit', '2017-09-01 03:01:01', 'card05', '1MMMMM')
594INSERT INTO CreditDebitTrans VALUES ('A00014', '1.50', 'Credit', '2017-11-04 15:19:14', 'card03', '1NNNNN')
595INSERT INTO CreditDebitTrans VALUES ('A00015', '0.50', 'Debit', '2014-11-11 10:30:10', 'card13', '1OOOOO')
596INSERT INTO CreditDebitTrans VALUES ('A00016', '1.50', 'Debit', '2018-01-10 02:01:01', 'card03', '1PPPPP')
597INSERT INTO CreditDebitTrans VALUES ('A00017', '2.50', 'Credit', '2014-01-01 01:51:01', 'card07', '1QQQQQ')
598INSERT INTO CreditDebitTrans VALUES ('A00018', '0.50', 'Credit', '2017-02-02 13:30:00', 'Card16', '1RRRRR')
599INSERT INTO CreditDebitTrans VALUES ('A00019', '0.50', 'Debit', '2017-12-05 15:00:00', 'Card17', '1SSSSS')