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
| import { BaseEntity } from '../../base/entity/base';
| import { Column, Entity, Index, Unique } from 'typeorm';
|
| /**
| * 每日站点汇总
| */
| @Entity('t_report_daily_site')
| @Unique('uk_date_site', ['date', 'siteId']) // 💡 重点：在这里加上复合唯一约束，第一个参数是索引名，第二个是字段数组
| export class ReportDailysiteEntity extends BaseEntity {
| @Index()
| @Column({ comment: '日期', type: 'date' })
| date: string;
|
| @Index()
| @Column({ comment: '站点ID' })
| siteId: number;
|
| @Index()
| @Column({ comment: '站点名称' })
| siteName: string;
|
| @Column({ comment: '总重量', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| weightTotal: number;
|
| @Column({ comment: 'sw60重量', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| weightSw60: number;
|
| @Column({ comment: 'sw61重量', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| weightSw61: number;
|
| @Column({ comment: 'sw62重量', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| weightSw62: number;
|
| @Column({ comment: 'sw63重量', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| weightSw63: number;
|
| @Column({ comment: 'sw64重量', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| weightSw64: number;
|
| @Column({ comment: 'sw62_001重量', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| weightSw62001: number;
|
| @Column({ comment: 'sw62_002重量', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| weightSw62002: number;
|
| @Column({ comment: 'sw62_003重量', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| weightSw62003: number;
|
| @Column({ comment: 'sw62_004重量', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| weightSw62004: number;
|
| @Column({ comment: 'sw62_005重量', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| weightSw62005: number;
|
| @Column({ comment: 'sw62_006重量', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| weightSw62006: number;
|
| @Column({ comment: 'sw62_007重量', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| weightSw62007: number;
|
| @Column({ comment: '总称重次数', type: 'decimal', precision: 10, scale: 2, default: 0.00 })
| timeTotal: number;
|
| @Column({ comment: 'sw60次数', type: 'decimal', precision: 10, scale: 2, default: 0.00 })
| timeSw60: number;
|
| @Column({ comment: 'sw61次数', type: 'decimal', precision: 10, scale: 2, default: 0.00 })
| timeSw61: number;
|
| @Column({ comment: 'sw62次数', type: 'decimal', precision: 10, scale: 2, default: 0.00 })
| timeSw62: number;
|
| @Column({ comment: 'sw63次数', type: 'decimal', precision: 10, scale: 2, default: 0.00 })
| timeSw63: number;
|
| @Column({ comment: 'sw64次数', type: 'decimal', precision: 10, scale: 2, default: 0.00 })
| timeSw64: number;
|
| @Column({ comment: 'sw62001次数', type: 'decimal', precision: 10, scale: 2, default: 0.00 })
| timeSw62001: number;
|
| @Column({ comment: 'sw62002次数', type: 'decimal', precision: 10, scale: 2, default: 0.00 })
| timeSw62002: number;
|
| @Column({ comment: 'sw62003次数', type: 'decimal', precision: 10, scale: 2, default: 0.00 })
| timeSw62003: number;
|
| @Column({ comment: 'sw62004次数', type: 'decimal', precision: 10, scale: 2, default: 0.00 })
| timeSw62004: number;
|
| @Column({ comment: 'sw62005次数', type: 'decimal', precision: 10, scale: 2, default: 0.00 })
| timeSw62005: number;
|
| @Column({ comment: 'sw62006次数', type: 'decimal', precision: 10, scale: 2, default: 0.00 })
| timeSw62006: number;
|
| @Column({ comment: 'sw62007次数', type: 'decimal', precision: 10, scale: 2, default: 0.00 })
| timeSw62007: number;
|
| @Column({ comment: '总碳排量', type: 'decimal', precision: 15, scale: 2, default: 0.0 })
| carbonTotal: number;
|
| @Column({ comment: 'sw60碳排量', type: 'decimal', precision: 15, scale: 2, default: 0.0 })
| carbonSw60: number;
|
| @Column({ comment: 'sw61碳排量', type: 'decimal', precision: 15, scale: 2, default: 0.0 })
| carbonSw61: number;
|
| @Column({ comment: 'sw62碳排量', type: 'decimal', precision: 15, scale: 2, default: 0.0 })
| carbonSw62: number;
|
| @Column({ comment: 'sw63碳排量', type: 'decimal', precision: 15, scale: 2, default: 0.0 })
| carbonSw63: number;
|
| @Column({ comment: 'sw64碳排量', type: 'decimal', precision: 15, scale: 2, default: 0.0 })
| carbonSw64: number;
|
| @Column({ comment: 'sw62001碳排量', type: 'decimal', precision: 15, scale: 2, default: 0.0 })
| carbonSw62001: number;
|
| @Column({ comment: 'sw62002碳排量', type: 'decimal', precision: 15, scale: 2, default: 0.0 })
| carbonSw62002: number;
|
| @Column({ comment: 'sw62003碳排量', type: 'decimal', precision: 15, scale: 2, default: 0.0 })
| carbonSw62003: number;
|
| @Column({ comment: 'sw62004碳排量', type: 'decimal', precision: 15, scale: 2, default: 0.0 })
| carbonSw62004: number;
|
| @Column({ comment: 'sw62005碳排量', type: 'decimal', precision: 15, scale: 2, default: 0.0 })
| carbonSw62005: number;
|
| @Column({ comment: 'sw62006碳排量', type: 'decimal', precision: 15, scale: 2, default: 0.0 })
| carbonSw62006: number;
|
| @Column({ comment: 'sw62007碳排量', type: 'decimal', precision: 15, scale: 2, default: 0.0 })
| carbonSw62007: number;
|
| @Column({ comment: 'sw62估算销售额', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| estimatedSalesSw62: number;
|
| @Column({ comment: 'sw62_001估算销售额', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| estimatedSalesSw62001: number;
|
| @Column({ comment: 'sw62_002估算销售额', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| estimatedSalesSw62002: number;
|
| @Column({ comment: 'sw62_003估算销售额', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| estimatedSalesSw62003: number;
|
| @Column({ comment: 'sw62_004估算销售额', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| estimatedSalesSw62004: number;
|
| @Column({ comment: 'sw62_005估算销售额', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| estimatedSalesSw62005: number;
|
| @Column({ comment: 'sw62_006估算销售额', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| estimatedSalesSw62006: number;
|
| @Column({ comment: 'sw62_007估算销售额', type: 'decimal', precision: 15, scale: 2, default: 0.00 })
| estimatedSalesSw62007: number;
|
| }
|
|
