API tools faq
paste
Advertisement
Guest User

DB SQL Assignment

a guest
Jan 14th, 2018
1,045
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.81 KB | None | 0 0
raw download clone embed print report
  1. USE master
  2.  
  3. --Delete database if it exists--
  4.  
  5. IF EXISTS(select * from sys.databases where name='BikeRentalSystem')
  6. DROP DATABASE BikeRentalSystem
  7. GO
  8. CREATE DATABASE BikeRentalSystem
  9. GO
  10.  
  11. USE BikeRentalSystem
  12.  
  13.  
  14. --Delete tables if they exist--
  15.  
  16. if exists(select * from sysobjects where id = object_id('CreditDebitTrans'))
  17. drop table CreditDebitTrans
  18. go
  19.  
  20. if exists(select * from sysobjects where id = object_id('Ride'))
  21. drop table Ride
  22. go
  23.  
  24. if exists(select * from sysobjects where id = object_id('BikeReservation'))
  25. drop table BikeReservation
  26. go
  27.  
  28. if exists(select * from sysobjects where id = object_id('Fault'))
  29. drop table Fault
  30. go
  31.  
  32. if exists(select * from sysobjects where id = object_id('Comment'))
  33. drop table Comment
  34. go
  35.  
  36. if exists(select * from sysobjects where id = object_id('Feedback'))
  37. drop table Feedback
  38. go
  39.  
  40. if exists(select * from sysobjects where id = object_id('Member'))
  41. drop table Member
  42. go
  43.  
  44. if exists(select * from sysobjects where id = object_id('Bike'))
  45. drop table Bike
  46. go
  47.  
  48. if exists(select * from sysobjects where id = object_id('BikeStop'))
  49. drop table BikeStop
  50. go
  51.  
  52. if exists(select * from sysobjects where id = object_id('Promotion'))
  53. drop table Promotion
  54. go
  55.  
  56. if exists(select * from sysobjects where id = object_id('FaultType'))
  57. drop table FaultType
  58. go
  59.  
  60. if exists(select * from sysobjects where id = object_id('MaintItem'))
  61. drop table MaintItem
  62. go
  63.  
  64. if exists(select * from sysobjects where id = object_id('MaintType'))
  65. drop table MaintType
  66. go
  67.  
  68. if exists(select * from sysobjects where id = object_id('Repair'))
  69. drop table Repair
  70. go
  71.  
  72. if exists(select * from sysobjects where id = object_id('Maintenance'))
  73. drop table Maintenance
  74. go
  75.  
  76. if exists(select * from sysobjects where id = object_id('CreditCard'))
  77. drop table CreditCard
  78. go
  79.  
  80.  
  81. --Creating tables--
  82.  
  83.  
  84. Create 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.  
  101. Create 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.  
  112. Create 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.  
  125. Create 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.  
  142. Create 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.  
  155. Create 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.  
  176. CONSTRAINT Chk_PtsRedeemed CHECK(PtsRedeemed % 50 = 0)
  177. )
  178.  
  179. Create 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.  
  190. Create 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.  
  198. Create 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.  
  210. Create 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.  
  222. Create 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.  
  230. Create 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.  
  242. Create table Fault
  243. (
  244. FBID char(5) NOT NULL,
  245. FBDateTime varchar(40) 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.  
  261. Create 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.  
  274. Create 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. CONSTRAINT Pk_CreditCard PRIMARY KEY(CardNo),
  282. CONSTRAINT Chk_ExpiryDate CHECK(ExpiryDate >= GETDATE()),
  283. CONSTRAINT Fk_MemberID FOREIGN KEY (MemberID) REFERENCES Member(MemberID),
  284. )
  285.  
  286. Create table CreditDebitTrans
  287. (
  288. TransID char(6) NOT NULL,
  289. TransAmt smallmoney NOT NULL,
  290. TransType varchar(6) NOT NULL,
  291. TransDateTime datetime NOT NULL default(GETDATE()),
  292. CardNo char(6) NOT NULL,
  293. RideID char(6) NOT NULL,
  294.  
  295. CONSTRAINT Pk_CreditDebitTrans PRIMARY KEY(TransID),
  296. CONSTRAINT Fk_CreditDebitTrans_CardNo FOREIGN KEY(CardNo) REFERENCES CreditCard(CardNo),
  297. CONSTRAINT Fk_CreditDebitTrans_RideID FOREIGN KEY(RideID) REFERENCES Ride(RideID),
  298. CONSTRAINT Chk_TransType CHECK(TransType in ('Credit','Debit'))
  299. )
  300.  
  301.  
  302.  
  303.  
  304. --Inserting values--
  305.  
  306. insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AA',1.335512, 103.962087, 25)
  307. insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AB',1.340790, 103.950886, 20)
  308. insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AC',1.345273, 103.939234, 15)
  309. insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AD',1.334727, 103.764290, 10)
  310. insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AE',1.359096, 103.893723, 5)
  311. insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AF',1.366304, 103.947624, 25)
  312. insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AG',1.446274, 103.823685, 10)
  313. insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AH',1.394791, 103.906769, 15)
  314. insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AI',1.312760, 103.767380, 25)
  315. insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AJ',1.327176, 103.688416, 25)
  316. insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AK',1.444214, 103.788666, 20)
  317. insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AL',1.392389, 103.904709, 10)
  318. insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AM',1.381405, 103.890633, 5)
  319. insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AN',1.377630, 103.879646, 5)
  320. insert into BikeStop(BikeStopID, StopLat, StopLong, StopRadius) values ('AO',1.328892, 103.744720, 25)
  321.  
  322. insert into Bike VALUES ('1AAA', 0.5, 'W', '2016-10-10', 'AA')
  323. insert into Bike VALUES ('2BBB', 0.5, 'W', '2009-02-02', 'AB')
  324. insert into Bike VALUES ('3CCC', 0.5, 'W', '2010-03-03', 'AA')
  325. insert into Bike VALUES ('4DDD', 0.5, 'R', '2010-04-04', 'AC')
  326. insert into Bike VALUES ('5EEE', 0.5, 'W', '2011-05-05', 'AD')
  327. insert into Bike VALUES ('6FFF', 0.5, 'W', '2015-06-06', 'AE')
  328. insert into Bike VALUES ('7GGG', 0.5, 'NR', '2017-03-23','AB')
  329. insert into Bike VALUES ('8HHH', 0.5, 'W', '2012-03-03', 'AA')
  330. insert into Bike VALUES ('9III', 0.5, 'W', '2014-08-08', 'AG')
  331. insert into Bike VALUES ('JJJ1', 0.5, 'W', '2013-10-20', 'AH')
  332. insert into Bike VALUES ('KKK2', 0.5, 'W', '2013-07-12', 'AI')
  333. insert into Bike VALUES ('LLL3', 0.5, 'NR', '2014-11-21', 'AJ')
  334. insert into Bike VALUES ('MMM4', 0.5, 'W', '2010-03-15', 'AH')
  335. insert into Bike VALUES ('NNN5', 0.5, 'W', '2018-01-02', 'AA')
  336. insert into Bike VALUES ('OOO6', 0.5, 'W', '2018-01-10', 'AO')
  337.  
  338. insert into Member (MemberID, Name, Email, Phone, Deposit, CreditBalance, DateJoin) values ('11111B','John Bruce', 'jhonbruce@gmail.com.sg', '90000001', 100, 200, '2017-08-01')
  339. insert into Member values ('22222C','Tom Harrison', 'tomharrison@gmail.com', '90000002', 15, 60, 50, '2017-01-03')
  340. insert into Member (MemberID, Name, Email, Phone, Deposit, CreditBalance, DateJoin) values ('33333D','Zachary Tan', 'zacharytan@gmail.com', '90000003', 80, 200, '2016-12-01')
  341. insert into Member (MemberID, Name, Email, Phone, RewardPts, CreditBalance, DateJoin) values ('44444E','Tammy Lee', 'tammylee@hotmail.com.sg', '90000004', 24, 200, '2016-05-01')
  342. insert into Member values ('55555F','Monica Cheng', 'monicacheng@gmail.com', '90000005', 29, 140, 350, '2015-10-15')
  343. insert into Member values ('66666G','Javier Tang', 'javiertang@gmail.com', '90000006', 33, 120, 400, '2015-06-01')
  344. insert into Member (MemberID, Name, Email, Phone, RewardPts) values ('77777H','Shaun Jacob', 'shaunjacob@hotmail.com.sg', '90000007', 38)
  345. insert into Member values ('88888I','William Johnson', 'willianjohnson@gmail.com', '90000008', 42, 150, 25, '2014-09-09')
  346. insert into Member (MemberID, Name, Email, Phone, RewardPts, Deposit, DateJoin) values ('99999J','James Bruce', 'jamesbruce@gmail.com.sg', '90000009', 45, 170, '2013-06-09')
  347. insert into Member (MemberID, Name, Email, Phone, Deposit, DateJoin) values ('AAAAA1','Wayne', 'xxxwayne999@gmail.com', '80000000', 200, '2012-07-22')
  348. insert into Member (MemberID, Name, Email, Phone, RewardPts) values ('BBBBB2','Jennifer Pang', 'jenniferpang@gmail.com', '80000001', 51)
  349. insert into Member (MemberID, Name, Email, Phone, RewardPts, DateJoin) values ('CCCCC3','Ethan Bradberry', 'ethanbradberry@hotmail.com.sg', '80000002', 55, '2011-11-11')
  350. insert into Member values ('DDDDD4','Daniel Lim', 'daniellim@gmail.com', '80000003', 69, 170, 46, '2010-10-10')
  351. insert into Member (MemberID, Name, Email, Phone, CreditBalance, DateJoin) values ('EEEEE5','Lucas Paul', 'lucaspaul@gmail.com.sg', '80000004', 100, '2009-09-09')
  352. insert into Member values ('FFFFF6', 'Jack Lee', 'jacklee99@hotmail.com.sg', '80000005', 1, 55, 31, '2008-08-08')
  353. insert into Member values ('GGGGG7', 'Mary Tan', 'marytan@yahoo.com.sg', '80000006', 10, 60, 12, '2017-10-18')
  354. insert into Member values ('HHHHH8', 'Tom Everson', 'tomeve@yahoo.com', '80000007', 12, 56, 15, '2017-08-28')
  355. insert into Member values ('IIIII9', 'Claudia Koh', 'claudia13@yahoo.com.sg', '80000008', 21, 53, 35, '2008-09-17')
  356. insert into Member (MemberID, Name, Email, Phone, RewardPts, Deposit, DateJoin) values ('JJJJJ1', 'Nicholas Paris', 'parisnicalo@yahoo.com', '80000009', 34, 55, '2016-02-25')
  357. insert into Member (MemberID, Name, Email, Phone, RewardPts, CreditBalance, DateJoin) values ('KKKKK2', 'Jackson Yi', 'yi08@yahoo.com', '80000010', 56, 2, '2016-03-26')
  358.  
  359. insert into BikeReservation values ('0001','55555F', '4DDD', 'F', '2011-04-04 04:04:04', '2011-04-04 04:34:04')
  360. insert into BikeReservation values ('0002','44444E', '5EEE', 'F', '2011-05-05 05:05:05', '2011-05-05 05:15:05')
  361. insert into BikeReservation values ('0003','77777H', '3CCC', 'F', '2010-03-03 03:03:03', '2010-03-03 03:23:03')
  362. insert into BikeReservation values ('0004','88888I', '9III', 'O', '2018-01-11 09:09:09', '2018-01-11 17:10:09')
  363. insert into BikeReservation values ('0005','CCCCC3', 'LLL3', 'O', '2018-01-10 11:11:11', '2018-01-10 11:15:20')
  364. insert into BikeReservation values ('0006','FFFFF6', '1AAA', 'F', '2008-01-01 01:01:01', '2008-01-01 01:11:01')
  365. insert into BikeReservation values ('0007','AAAAA1', 'NNN5', 'F', '2017-02-03 13:13:13', '2017-02-03 13:23:13')
  366. insert into BikeReservation values ('0008','EEEEE5', 'KKK2', 'F', '2014-11-11 10:10:10', '2014-11-11 10:20:10')
  367. insert into BikeReservation values ('0009','DDDDD4', 'OOO6', 'F', '2017-03-04 14:14:14', '2017-03-04 14:54:14')
  368. insert into BikeReservation values ('0010','55555F', '6FFF', 'O', '2018-01-10 06:06:06', '2018-01-11 18:16:06')
  369. insert into BikeReservation values ('0011','99999J', 'JJJ1', 'F', '2014-10-10 09:09:10', '2014-10-10 09:09:20')
  370. insert into BikeReservation values ('0012','66666G', '7GGG', 'F', '2013-07-07 07:07:07', '2013-07-07 07:27:07')
  371. insert into BikeReservation values ('0013','77777H', '8HHH', 'F', '2013-08-08 08:08:08', '2013-08-08 08:28:08')
  372. insert into BikeReservation values ('0014','BBBBB2', 'MMM4', 'F', '2017-01-02 12:12:12', '2017-01-02 12:15:12')
  373. insert into BikeReservation values ('0015','11111B', '2BBB', 'F', '2009-02-02 02:02:02', '2009-02-02 02:12:02')
  374.  
  375. insert into Promotion values ('Promo01', 'Get 5% off of total price of the ride', 0.05, '2008-01-01', '2008-03-04')
  376. insert into Promotion values ('Promo02', 'Get 25% off of total price of the ride', 0.25, '2008-04-11', '2008-06-19')
  377. insert into Promotion values ('Promo03', 'Get 30% off of total price of the ride', 0.30, '2008-08-01', '2018-12-09')
  378. insert into Promotion values ('Promo04', 'Get 20% off of total price of the ride', 0.20, '2009-02-13', '2009-04-01')
  379. insert into Promotion values ('Promo05', 'Get 10% off of total price of the ride', 0.10, '2009-06-01', '2009-08-20')
  380. insert into Promotion values ('Promo06', 'Get 30% off of total price of the ride', 0.30, '2010-01-01', '2010-02-01')
  381. insert into Promotion values ('Promo07', 'Get 60% off of total price of the ride', 0.60, '2010-02-28', '2010-06-30')
  382. insert into Promotion values ('Promo08', 'Get 80% off of total price of the ride', 0.80, '2011-08-21', '2011-09-01')
  383. insert into Promotion values ('Promo09', 'Get 90% off of total price of the ride', 0.90, '2011-08-10', '2011-12-14')
  384. insert into Promotion values ('Promo10', 'Get 10% off of total price of the ride', 0.10, '2011-10-15', '2011-12-16')
  385. insert into Promotion values ('Promo11', 'Get 15% off of total price of the ride', 0.15, '2012-06-23', '2012-12-31')
  386. insert into Promotion values ('Promo12', 'Get 33% off of total price of the ride', 0.33, '2013-02-11', '2013-04-01')
  387. insert into Promotion values ('Promo13', 'Get 25% off of total price of the ride', 0.25, '2014-01-05', '2014-08-07')
  388. insert into Promotion values ('Promo14', 'Get 55% off of total price of the ride', 0.55, '2015-11-03', '2016-03-18')
  389. insert into Promotion values ('Promo15', 'Get 75% off of total price of the ride', 0.75, '2017-06-20', '2018-01-02')
  390.  
  391. INSERT INTO Ride VALUES('1AAAAA', '2008-01-01 01:11:01', '2008-01-01 01:31:01', 20, 5.00, 0, 0.50, 'FFFFF6', '1AAA', 'AA', 'Promo01')
  392. INSERT 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')
  393. INSERT 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)
  394. INSERT INTO Ride VALUES('1DDDDD', '2010-05-06 14:20:00', '2010-05-06 14:10:00', 50, 8.50, 50, 0.50, '33333D', '4DDD', 'AE', 'Promo07')
  395. INSERT INTO Ride VALUES('1EEEEE', '2010-09-01 16:35:00', '2010-09-01 17:30:00', 55, 9.00, 50, 0.50, '44444E', '1AAA', 'AG', 'Promo08')
  396. INSERT 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')
  397. INSERT 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)
  398. INSERT 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')
  399. INSERT INTO Ride VALUES('1IIIII', '2012-06-06 06:16:06', '2012-06-06 01:46:06', 30, 6.35, 0, 0.50, '88888I', 'LLL3', 'AM', 'Promo11')
  400. INSERT INTO Ride VALUES('1JJJJJ', '2014-10-10 09:09:20', '2014-10-10 09:49:46', 40, 7.10, 0, 0.50, '99999J', 'JJJ1', 'AO', 'Promo08')
  401. INSERT 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')
  402. INSERT 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')
  403. INSERT 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)
  404. INSERT INTO Ride VALUES('1NNNNN', '2017-03-04 14:54:14', '2017-03-04 15:19:14', 25, 6.00, 0, 0.50, 'DDDDD4', 'OOO6', 'AB', Null)
  405. INSERT 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)
  406. INSERT INTO Ride VALUES('1PPPPP', '2013-01-01 01:01:01', '2013-01-01 02:01:01', 60, 10.10, 50, 0.50, 'AAAAA1', 'OOO6', 'AN', Null)
  407. INSERT 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')
  408. INSERT INTO Ride VALUES('1RRRRR', '2017-02-02 13:30:00', '2017-02-02 14:30:00', 60, 18.00, 50, 0.50, 'JJJJJ1', '4DDD', 'AO', Null)
  409. INSERT INTO Ride VALUES('1SSSSS', '2017-05-05 15:00:00', '2017-05-05 16:00:00', 60, 15.00, 50, 0.50, 'KKKKK2', 'LLL3', 'AB', Null)
  410.  
  411.  
  412. INSERT INTO Feedback VALUES ('00001', '2017-03-04 00:14:14', 'FFFFF6')
  413. INSERT INTO Feedback VALUES ('00002', '2010-01-07 12:59:12', '22222C')
  414. INSERT INTO Feedback VALUES ('00003', '2016-12-14 02:49:45', '11111B')
  415. INSERT INTO Feedback VALUES ('00004', '2014-02-24 18:17:10', '33333D')
  416. INSERT INTO Feedback VALUES ('00005', '2015-02-15 19:37:20', 'FFFFF6')
  417. INSERT INTO Feedback VALUES ('00006', '2013-11-25 20:18:30', 'AAAAA1')
  418. INSERT INTO Feedback VALUES ('00007', '2017-05-05 11:58:40', '44444E')
  419. INSERT INTO Feedback VALUES ('00008', '2012-07-03 22:28:50', '66666G')
  420. INSERT INTO Feedback VALUES ('00009', '2012-04-30 19:54:12', '77777H')
  421. INSERT INTO Feedback VALUES ('00010', '2011-03-29 10:34:14', 'FFFFF6')
  422. INSERT INTO Feedback VALUES ('00011', '2017-11-19 03:45:17', '55555F')
  423. INSERT INTO Feedback VALUES ('00012', '2016-05-01 04:12:56', '55555F')
  424. INSERT INTO Feedback VALUES ('00013', '2011-01-03 11:27:45', '11111B')
  425. INSERT INTO Feedback VALUES ('00014', '2015-01-14 07:17:34', 'EEEEE5')
  426. INSERT INTO Feedback VALUES ('00015', '2012-04-02 09:09:21', 'BBBBB2')
  427. INSERT INTO Feedback VALUES ('10001', '2017-02-10 01:02:35', 'HHHHH8')
  428. INSERT INTO Feedback VALUES ('20002', '2017-05-13 03:09:23', 'CCCCC3')
  429. INSERT INTO Feedback VALUES ('30003', '2016-03-26 23:02:13', 'GGGGG7')
  430. INSERT INTO Feedback VALUES ('40004', '2016-07-17 12:24:45', '66666G')
  431. INSERT INTO Feedback VALUES ('50005', '2015-07-06 07:12:07', 'AAAAA1')
  432. INSERT INTO Feedback VALUES ('60006', '2015-10-09 06:23:46', 'HHHHH8')
  433. INSERT INTO Feedback VALUES ('70007', '2014-01-19 03:59:00', 'CCCCC3')
  434. INSERT INTO Feedback VALUES ('80008', '2014-04-03 14:34:25', '99999J')
  435. INSERT INTO Feedback VALUES ('90009', '2013-02-20 16:45:50', 'JJJJJ1')
  436. INSERT INTO Feedback VALUES ('11011', '2013-07-21 20:34:01', 'HHHHH8')
  437. INSERT INTO Feedback VALUES ('22022', '2012-08-26 18:09:23', 'BBBBB2')
  438. INSERT INTO Feedback VALUES ('33033', '2012-02-14 06:45:50', 'IIIII9')
  439. INSERT INTO Feedback VALUES ('44044', '2011-03-18 04:34:10', 'HHHHH8')
  440. INSERT INTO Feedback VALUES ('55055', '2011-06-22 16:23:57', 'IIIII9')
  441. INSERT INTO Feedback VALUES ('66066', '2010-04-22 18:34:49', 'CCCCC3')
  442.  
  443. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00001', '2017-03-04 00:14:14', 'Message01', 'FFFFF6')
  444. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00002', '2010-01-07 12:59:12', 'Message02', '22222C')
  445. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00003', '2016-12-14 02:49:45', 'Message03', '11111B')
  446. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00004', '2014-02-24 18:17:10', 'Message04', '33333D')
  447. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00005', '2015-02-15 19:37:20', 'Message05', 'FFFFF6')
  448. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00006', '2013-11-25 20:18:30', 'Message06', 'AAAAA1')
  449. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00007', '2017-08-05 11:58:40', 'Message07', '44444E')
  450. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00008', '2012-07-03 22:28:50', 'Message08', '66666G')
  451. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00009', '2012-04-30 19:54:12', 'Message09', '77777H')
  452. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00010', '2011-03-29 10:34:14', 'Message10', 'FFFFF6')
  453. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00011', '2017-11-19 03:45:17', 'Message11', '55555F')
  454. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00012', '2016-12-01 04:12:56', 'Message12', '55555F')
  455. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00013', '2011-01-03 11:27:45', 'Message13', '11111B')
  456. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00014', '2015-01-14 07:17:34', 'Message14', 'EEEEE5')
  457. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00015', '2012-04-02 09:09:21', 'Message15', 'BBBBB2')
  458.  
  459. INSERT INTO FaultType VALUES('TI-1','Tires are punctured')
  460. INSERT INTO FaultType VALUES('TI-2','Tires are worn out')
  461. INSERT INTO FaultType VALUES('TI-3','Tires misshaped')
  462. INSERT INTO FaultType VALUES('BA-1','A part of the basket is broken off')
  463. INSERT INTO FaultType VALUES('BA-2','Basket has been misshaped by force')
  464. INSERT INTO FaultType VALUES('BA-3','Basket is almost / already detached from the rest of the bike' )
  465. INSERT INTO FaultType VALUES('SE-1','Seat covering is torn off (or a portion of it)')
  466. INSERT INTO FaultType VALUES('SE-2','Seat is physically damaged')
  467. INSERT INTO FaultType VALUES('LO-1','Lock is broken, completely insecure')
  468. INSERT INTO FaultType VALUES('LO-2','Lock does not work')
  469. INSERT INTO FaultType VALUES('PE-1','Pedal(s) is / are loose')
  470. INSERT INTO FaultType VALUES('PE-2','Pedal(s) is / are missing')
  471. INSERT INTO FaultType VALUES('FR-1','Frame is dented in')
  472. INSERT INTO FaultType VALUES('FR-2','Paint on frame has been scraped off')
  473. INSERT INTO FaultType VALUES('OO-1','Bicycle is unlocked')
  474.  
  475.  
  476. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0001', '2010-06-01', '1AAA')
  477. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0002', '2009-02-02', '2BBB')
  478. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0003', '2010-03-03', '3CCC')
  479. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0004', '2012-04-15', '4DDD')
  480. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0005', '2011-05-05', '5EEE')
  481. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0006', '2015-12-19', 'JJJ1')
  482. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0007', '2013-07-07', '1AAA')
  483. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0008', '2014-04-01', '9III')
  484. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0009', '2014-03-19', 'KKK2')
  485. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0010', '2016-10-10', '1AAA')
  486. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0011', '2017-03-29', 'OOO6')
  487. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0012', '2010-12-12', 'KKK2')
  488. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0013', '2017-05-01', 'NNN5')
  489. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0014', '2011-02-02', 'MMM4')
  490. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0015', '2012-03-03', '8HHH')
  491. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0016', '2013-07-30', '6FFF')
  492. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0017', '2011-05-25', '3CCC')
  493.  
  494. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0001', '2008-01-01', '1AAA')
  495. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0002', '2009-02-02', '2BBB')
  496. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0003', '2010-03-03', '3CCC')
  497. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0004', '2010-04-04', '4DDD')
  498. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0005', '2011-05-05', '5EEE')
  499. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0006', '2012-06-06', '6FFF')
  500. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0007', '2013-07-07', '1AAA')
  501. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0008', '2014-08-08', '9III')
  502. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0009', '2015-09-09', 'KKK2')
  503. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0010', '2016-10-10', '1AAA')
  504. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0011', '2017-11-11', 'OOO6')
  505. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0012', '2010-12-12', 'KKK2')
  506. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0013', '2008-01-01', 'NNN5')
  507. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0014', '2011-02-02', 'MMM4')
  508. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0015', '2012-03-03', '8HHH')
  509.  
  510. INSERT INTO Fault VALUES('10001','2017-02-10 01:02:35','tire', 'HHHHH8','TI-1','OOO6', 'A0015')
  511. INSERT INTO Fault VALUES('20002','2017-05-13 03:09:23','basket', 'CCCCC3','BA-1','NNN5', 'A0014')
  512. INSERT INTO Fault VALUES('30003','2016-03-26 23:02:13', 'lock', 'GGGGG7','TI-2','MMM4', 'A0013')
  513. INSERT INTO Fault VALUES('40004','2016-07-17 12:24:45', 'others', '66666G','SE-1','LLL3', 'A0012')
  514. INSERT INTO Fault VALUES('50005','2015-07-06 07-12-07', 'pedal', 'AAAAA1','LO-1','KKK2', 'A0011')
  515. INSERT INTO Fault VALUES('60006','2015-10-09 06-23-46', 'frame', 'HHHHH8','LO-2','JJJ1', 'A0010')
  516. INSERT INTO Fault VALUES('70007','2014-01-19 03:59:00', 'basket', 'CCCCC3','BA-2','9III', 'A0009')
  517. INSERT INTO Fault VALUES('80008','2014-04-03 14:34:25', 'tire', '99999J','PE-1','8HHH', 'A0008')
  518. INSERT INTO Fault VALUES('90009','2013-02-20 16:45:50', 'frame', 'JJJJJ1','OO-1','7GGG', 'A0007')
  519. INSERT INTO Fault VALUES('11011','2013-07-21 20:34:01', 'basket', 'HHHHH8','SE-2','6FFF', 'A0006')
  520. INSERT INTO Fault VALUES('22022','2012-08-26 18:09:23', 'pedal', 'BBBBB2','TI-3','5EEE', 'A0005')
  521. INSERT INTO Fault VALUES('33033','2012-02-14 06:45:50', 'tire', 'IIIII9','FR-2','4DDD', 'A0004')
  522. INSERT INTO Fault VALUES('44044','2011-03-18 04:34:10', 'others', 'HHHHH8','PE-2','3CCC', 'A0003')
  523. INSERT INTO Fault VALUES('55055','2011-06-22 16:23:57', 'lock', 'IIIII9','BA-3','2BBB', 'A0002')
  524. INSERT INTO Fault VALUES('66066','2010-04-22 18:34:49', 'basket', 'CCCCC3','FR-1','1AAA', 'A0001')
  525.  
  526. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA01', 'TDesc01')
  527. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA02', 'TDesc02')
  528. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA03', 'TDesc03')
  529. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA04', 'TDesc04')
  530. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA05', 'TDesc05')
  531. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA06', 'TDesc06')
  532. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA07', 'TDesc07')
  533. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA08', 'TDesc08')
  534. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA09', 'TDesc09')
  535. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA10', 'TDesc10')
  536. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA11', 'TDesc11')
  537. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA12', 'TDesc12')
  538. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA13', 'TDesc13')
  539. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA14', 'TDesc14')
  540. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA15', 'TDesc15')
  541.  
  542. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('01', 'A0015', 'Mdesc01', 'AAA15')
  543. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('02', 'A0014', 'Mdesc04', 'AAA14')
  544. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('03', 'A0013', 'Mdesc05', 'AAA13')
  545. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('04', 'A0012', 'Mdesc06', 'AAA12')
  546. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('05', 'A0011', 'Mdesc07', 'AAA11')
  547. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('06', 'A0010', 'Mdesc02', 'AAA10')
  548. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('07', 'A0009', 'Mdesc03', 'AAA09')
  549. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('08', 'A0008', 'Mdesc02', 'AAA08')
  550. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('09', 'A0007', 'Mdesc01', 'AAA07')
  551. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('10', 'A0006', 'Mdesc05', 'AAA06')
  552. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('11', 'A0005', 'Mdesc08', 'AAA05')
  553. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('12', 'A0004', 'Mdesc10', 'AAA04')
  554. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('13', 'A0003', 'Mdesc06', 'AAA03')
  555. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('14', 'A0002', 'Mdesc04', 'AAA02')
  556. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('15', 'A0001', 'Mdesc07', 'AAA01')
  557.  
  558. INSERT INTO CreditCard VALUES('Card01', 'Visa', '2019-01-01', '000', 'FFFFF6')
  559. INSERT INTO CreditCard VALUES('Card02', 'Master', '2020-01-01', '001', '66666G')
  560. INSERT INTO CreditCard VALUES('Card03', 'Diners', '2021-01-01', '002', 'FFFFF6')
  561. INSERT INTO CreditCard VALUES('Card04', 'Master', '2021-01-01', '003', 'BBBBB2')
  562. INSERT INTO CreditCard VALUES('Card05', 'Express', '2022-01-01', '004', '22222C')
  563. INSERT INTO CreditCard VALUES('Card06', 'Chase', '2022-01-01', '005', '77777H')
  564. INSERT INTO CreditCard VALUES('Card07', 'Visa', '2022-01-01', '006', 'EEEEE5')
  565. INSERT INTO CreditCard VALUES('Card08', 'Visa', '2022-01-01', '007', '11111B')
  566. INSERT INTO CreditCard VALUES('Card09', 'Diners', '2022-01-01', '008', '55555F')
  567. INSERT INTO CreditCard VALUES('Card10', 'Express', '2022-01-01', '009', '11111B')
  568. INSERT INTO CreditCard VALUES('Card11', 'Visa', '2022-01-01', '010', '55555F')
  569. INSERT INTO CreditCard VALUES('Card12', 'Visa', '2022-01-01', '011', '44444E')
  570. INSERT INTO CreditCard VALUES('Card13', 'Visa', '2019-01-01', '012', 'FFFFF6')
  571. INSERT INTO CreditCard VALUES('Card14', 'Master', '2019-01-01', '013', '33333D')
  572. INSERT INTO CreditCard VALUES('Card15', 'Chase', '2019-01-01', '014', 'AAAAA1')
  573. INSERT INTO CreditCard VALUES('Card16', 'Master', '2020-04-04', '015', 'JJJJJ1')
  574. INSERT INTO CreditCard VALUES('Card17', 'Visa', '2021-05-05', '016', 'KKKKK2')
  575.  
  576. INSERT INTO CreditDebitTrans VALUES ('A00001', '1.50', 'Debit', '2018-01-01 01:31:01', 'card01', '1AAAAA')
  577. INSERT INTO CreditDebitTrans VALUES ('A00002', '1.00', 'Credit', '2008-03-04 13:31:01', 'card11', '1BBBBB')
  578. INSERT INTO CreditDebitTrans VALUES ('A00003', '0.50', 'Debit', '2009-04-05 14:10:00', 'card03', '1CCCCC')
  579. INSERT INTO CreditDebitTrans VALUES ('A00004', '2.00', 'Credit', '2017-09-06 14:10:00', 'card08', '1DDDDD')
  580. INSERT INTO CreditDebitTrans VALUES ('A00005', '1.50', 'Debit', '2017-09-01 17:30:00', 'card02', '1EEEEE')
  581. INSERT INTO CreditDebitTrans VALUES ('A00006', '1.00', 'Credit', '2011-04-04 05:34:04', 'card10', '1FFFFF')
  582. INSERT INTO CreditDebitTrans VALUES ('A00007', '1.50', 'Debit', '2013-08-08 08:43:08', 'card01', '1GGGGG')
  583. INSERT INTO CreditDebitTrans VALUES ('A00008', '2.00', 'Credit', '2011-07-07 09:10:00', 'card05', '1HHHHH')
  584. INSERT INTO CreditDebitTrans VALUES ('A00009', '1.00', 'Debit', '2012-06-06 01:46:06', 'card06', '1IIIII')
  585. INSERT INTO CreditDebitTrans VALUES ('A00010', '0.50', 'Credit', '2014-10-10 09:49:46', 'card07', '1JJJJJ')
  586. INSERT INTO CreditDebitTrans VALUES ('A00011', '0.50', 'Debit', '2013-01-01 02:01:01', 'card08', '1KKKKK')
  587. INSERT INTO CreditDebitTrans VALUES ('A00012', '0.50', 'Credit', '2013-01-01 02:01:01', 'card09', '1LLLLL')
  588. INSERT INTO CreditDebitTrans VALUES ('A00013', '2.50', 'Debit', '2017-01-01 03:01:01', 'card10', '1MMMMM')
  589. INSERT INTO CreditDebitTrans VALUES ('A00014', '1.50', 'Credit', '2017-11-04 15:19:14', 'card14', '1NNNNN')
  590. INSERT INTO CreditDebitTrans VALUES ('A00015', '0.50', 'Debit', '2014-11-11 10:30:10', 'card13', '1OOOOO')
  591. INSERT INTO CreditDebitTrans VALUES ('A00016', '1.50', 'Debit', '2018-02-20 02:01:01', 'card15', '1PPPPP')
  592. INSERT INTO CreditDebitTrans VALUES ('A00017', '2.50', 'Credit', '2014-01-01 01:51:01', 'card07', '1QQQQQ')
  593. INSERT INTO CreditDebitTrans VALUES ('A00018', '0.50', 'Credit', '2017-02-02 13:30:00', 'Card16', '1RRRRR')
  594. INSERT INTO CreditDebitTrans VALUES ('A00019', '0.50', 'Debit', '2017-05-05 15:00:00', 'Card17', '1SSSSS')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!