-
Notifications
You must be signed in to change notification settings - Fork 0
/
Transaction.sql
78 lines (51 loc) · 3.1 KB
/
Transaction.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
USE JigitalclouN
INSERT INTO TrRental VALUES('JCN-R0116','JCN-C5111','JCN-S4112','2020-11-11',6)
INSERT INTO TrRentalDetail VALUES('JCN-R0116','JCN-V3102')
INSERT INTO TrRentalDetail VALUES('JCN-R0116','JCN-V3103')
INSERT INTO TrRentalDetail VALUES('JCN-R0116','JCN-V3104')
INSERT INTO TrRentalDetail VALUES('JCN-R0116','JCN-V3105')
INSERT INTO TrRental VALUES('JCN-R0117','JCN-C3103','JCN-S7112','2022-11-01',7)
INSERT INTO TrRentalDetail VALUES('JCN-R0117','JCN-V3107')
INSERT INTO TrRentalDetail VALUES('JCN-R0117','JCN-V3108')
INSERT INTO TrRentalDetail VALUES('JCN-R0117','JCN-V3109')
INSERT INTO TrRentalDetail VALUES('JCN-R0117','JCN-V3110')
INSERT INTO TrRental VALUES('JCN-R0118','JCN-C3201','JCN-S5112','2022-12-19',8)
INSERT INTO TrRentalDetail VALUES('JCN-R0118','JCN-V3107')
INSERT INTO TrRentalDetail VALUES('JCN-R0118','JCN-V3108')
INSERT INTO TrRentalDetail VALUES('JCN-R0118','JCN-V3109')
INSERT INTO TrRentalDetail VALUES('JCN-R0118','JCN-V3110')
INSERT INTO TrRental VALUES('JCN-R0119','JCN-C7201','JCN-S6112','2023-01-12',9)
INSERT INTO TrRentalDetail VALUES('JCN-R0119','JCN-V3107')
INSERT INTO TrRentalDetail VALUES('JCN-R0119','JCN-V3108')
INSERT INTO TrRentalDetail VALUES('JCN-R0119','JCN-V3109')
INSERT INTO TrRentalDetail VALUES('JCN-R0119','JCN-V3110')
INSERT INTO TrRental VALUES('JCN-R0120','JCN-C6111','JCN-S7112','2023-01-26',10)
INSERT INTO TrRentalDetail VALUES('JCN-R0120','JCN-V3107')
INSERT INTO TrRentalDetail VALUES('JCN-R0120','JCN-V3108')
INSERT INTO TrRentalDetail VALUES('JCN-R0120','JCN-V3109')
INSERT INTO TrRentalDetail VALUES('JCN-R0120','JCN-V3110')
INSERT INTO TrSales VALUES('JCN-S0116','JCN-C5111','JCN-S4112','2020-11-11')
INSERT INTO TrSalesDetail VALUES('JCN-S0116','JCN-V3102')
INSERT INTO TrSalesDetail VALUES('JCN-S0116','JCN-V3103')
INSERT INTO TrSalesDetail VALUES('JCN-S0116','JCN-V3104')
INSERT INTO TrSalesDetail VALUES('JCN-S0116','JCN-V3105')
INSERT INTO TrSales VALUES('JCN-S0117','JCN-C3103','JCN-S7112','2022-11-01')
INSERT INTO TrSalesDetail VALUES('JCN-S0117','JCN-V3107')
INSERT INTO TrSalesDetail VALUES('JCN-S0117','JCN-V3108')
INSERT INTO TrSalesDetail VALUES('JCN-S0117','JCN-V3109')
INSERT INTO TrSalesDetail VALUES('JCN-S0117','JCN-V3110')
INSERT INTO TrSales VALUES('JCN-S0118','JCN-C3201','JCN-S5112','2022-12-19')
INSERT INTO TrSalesDetail VALUES('JCN-S0118','JCN-V3101')
INSERT INTO TrSalesDetail VALUES('JCN-S0118','JCN-V3102')
INSERT INTO TrSalesDetail VALUES('JCN-S0118','JCN-V3103')
INSERT INTO TrSalesDetail VALUES('JCN-S0118','JCN-V3104')
INSERT INTO TrSales VALUES('JCN-S0119','JCN-C7201','JCN-S6112','2023-01-12')
INSERT INTO TrSalesDetail VALUES('JCN-S0119','JCN-V3105')
INSERT INTO TrSalesDetail VALUES('JCN-S0119','JCN-V3106')
INSERT INTO TrSalesDetail VALUES('JCN-S0119','JCN-V3107')
INSERT INTO TrSalesDetail VALUES('JCN-S0119','JCN-V3108')
INSERT INTO TrSales VALUES('JCN-S0120','JCN-C6111','JCN-S7112','2023-01-26')
INSERT INTO TrSalesDetail VALUES('JCN-S0120','JCN-V3109')
INSERT INTO TrSalesDetail VALUES('JCN-S0120','JCN-V3110')
INSERT INTO TrSalesDetail VALUES('JCN-S0120','JCN-V3101')
INSERT INTO TrSalesDetail VALUES('JCN-S0120','JCN-V3102')