-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathioitbeta.sql
277 lines (254 loc) · 64.5 KB
/
ioitbeta.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
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
/*
Navicat Premium Data Transfer
Source Server : 101.0.0.141
Source Server Type : PostgreSQL
Source Server Version : 140008 (140008)
Source Host : 101.0.0.141:7654
Source Catalog : postgres
Source Schema : ioit
Target Server Type : PostgreSQL
Target Server Version : 140008 (140008)
File Encoding : 65001
Date: 14/11/2024 17:02:01
*/
-- ----------------------------
-- Table structure for business_data
-- ----------------------------
DROP TABLE IF EXISTS "ioit"."business_data";
CREATE TABLE "ioit"."business_data" (
"id" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
"data" text COLLATE "pg_catalog"."default"
)
;
-- ----------------------------
-- Records of business_data
-- ----------------------------
INSERT INTO "ioit"."business_data" VALUES ('SAP_Material', '{"form":{"port":20010,"method":"POST","path":"/hsm-io-it/sap/getMaterial","argPath":"PostBatchAllMatList.models.ErpMatMdModel","responseBody":{"data":true,"code":0,"success":true},"isXML":true,"base64decode":true,"toJSON":true}}');
INSERT INTO "ioit"."business_data" VALUES ('SAP_ProductBOM', '{"form":{"port":20020,"method":"POST","path":"/hsm-io-it/sap/getProductBOM","argPath":"PostBatchPbomList.allList.ErpPbomModel","responseBody":{"data":true,"code":0,"success":true},"isXML":true,"base64decode":true,"toJSON":true}}');
INSERT INTO "ioit"."business_data" VALUES ('SAP_AsyncOrdersn', '{"form":{"port":20030,"method":"POST","path":"/hsm-io-it/sap/getAsyncOrdersn","argPath":"PostBatchAsyncOrdersnDet.allList.ErpOrderSnModel","responseBody":{"data":true,"code":0,"success":true},"isXML":true,"base64decode":true,"toJSON":true}}');
INSERT INTO "ioit"."business_data" VALUES ('SAP_OrderBOM', '{"form":{"port":20040,"method":"POST","path":"/hsm-io-it/sap/getOrderBOM","argPath":"PostBatchProductionOrderList.allList.ErpProductionOrderModel","responseBody":{"data":true,"code":0,"success":true},"isXML":true,"base64decode":true,"toJSON":true}}');
INSERT INTO "ioit"."business_data" VALUES ('SAP_ProcessLine', '{"form":{"port":20050,"method":"POST","path":"/hsm-io-it/sap/getProcessLine","argPath":"PostBatchProductLineList.allList.ErpProductLineModel","responseBody":{"data":true,"code":0,"success":true},"isXML":true,"base64decode":true,"toJSON":true}}');
INSERT INTO "ioit"."business_data" VALUES ('SAP_ProductOrder', '{"form":{"port":20060,"method":"POST","path":"/hsm-io-it/sap/getProductOrder","argPath":"PostBatchOrderErpList.allList.ErpOrderModel","responseBody":{"data":true,"code":0,"success":true},"isXML":true,"base64decode":true,"toJSON":true}}');
INSERT INTO "ioit"."business_data" VALUES ('SAP_ProductProcess', '{"form":{"port":20070,"method":"POST","path":"/hsm-io-it/sap/getProductProcess","argPath":"PostBatchProductLineList.allList.ErpProductLineModel","responseBody":{"data":true,"code":0,"success":true},"isXML":true,"base64decode":true,"toJSON":true}}');
INSERT INTO "ioit"."business_data" VALUES ('MES_ReportWork', '{"form":{"port":20080,"method":"POST","path":"/hsm-io-it/mes/getReportWork","argPath":"","responseBody":{"data":true,"code":0,"success":true},"isXML":false,"base64decode":false,"toJSON":false}}');
INSERT INTO "ioit"."business_data" VALUES ('MES_OrderStatus', '{"form":{"port":20090,"method":"POST","path":"/hsm-io-it/mes/getOrderStatus","argPath":"","responseBody":{"data":true,"code":0,"success":true},"isXML":false,"base64decode":false,"toJSON":false}}');
INSERT INTO "ioit"."business_data" VALUES ('SAP_MES_Material', '{"fieldMappingTable":[{"field":"MatCode","targetField":"mat_code","default":"","id":"1","structure":"String","isStructure":false},{"field":"MatType","targetField":"mat_type","default":"","id":"2","structure":"String","isStructure":false},{"field":"MatTypeDesc","targetField":"mat_type_desc","default":"","id":"3","structure":"String","isStructure":false},{"field":"MatDesc","targetField":"mat_desc","default":"","id":"4","structure":"String","isStructure":false},{"field":"Plant","targetField":"plant","default":"","id":"5","structure":"Number","isStructure":false},{"field":"MatGroupCode","targetField":"mat_group_code","default":"","id":"6","structure":"String","isStructure":false},{"field":"MatGroupName","targetField":"mat_group_name","default":"","id":"7","structure":"String","isStructure":false},{"field":"ErpUnit","targetField":"erp_unit","default":"","id":"8","structure":"String","isStructure":false},{"field":"Standard","targetField":"standard","default":"","id":"9","structure":"String","isStructure":false},{"field":"ModelNumber","targetField":"model_number","default":"","id":"10","structure":"String","isStructure":false},{"field":"RoundingValue","targetField":"rounding_value","default":"0","id":"11","structure":"Number","isStructure":false},{"field":"IsDelete","targetField":"is_delete","default":"","id":"12","structure":"Number","isStructure":false}],"hasConfig":true,"processCollection":{"startProcess":"查询","startIdent":"search","process":[{"label":"查询","identification":"search","interface":"MES_SEARCHMATERIA_INTERFACE","args":[{"name":"code","value":"mat_code"},{"name":"plant","value":"plant"}],"isFirst":true,"hasPrecondition":false,"hasPostcondition":true,"precondition":[],"postcondition":[{"path":"data","result":"true","branch":[{"label":"删除","ident":"delete"},{"label":"更新","ident":"edit"}]},{"path":"data","result":"false","branch":[{"label":"新增","ident":"add"}]}],"sendBody":false},{"label":"新增","identification":"add","interface":"MES_ADDMATERIA_INTERFACE","args":[],"isFirst":false,"hasPrecondition":false,"hasPostcondition":false,"precondition":[],"postcondition":[],"sendBody":true},{"label":"更新","identification":"edit","interface":"MES_EDITMATERIA_INTERFACE","args":[],"isFirst":false,"hasPrecondition":false,"hasPostcondition":false,"precondition":[],"postcondition":[],"sendBody":true},{"label":"删除","identification":"delete","interface":"MES_DELETEMATERIA_INTERFACE","args":[{"name":"code","value":"mat_code"},{"name":"plant","value":"plant"}],"isFirst":false,"hasPrecondition":true,"hasPostcondition":false,"precondition":[{"path":"is_delete","result":"true"}],"postcondition":[],"sendBody":false}]}}');
INSERT INTO "ioit"."business_data" VALUES ('SAP_MES_ProductBOM', '{"fieldMappingTable":[{"field":"PbomCode","targetField":"pbom_code","default":"","id":"0","structure":"String","isStructure":false},{"field":"MatCode","targetField":"mat_code","default":"","id":"1","structure":"String","isStructure":false},{"field":"MatDes","targetField":"mat_des","default":"","id":"2","structure":"String","isStructure":false},{"field":"Standard","targetField":"standard","default":"","id":"3","structure":"String","isStructure":false},{"field":"MatUnit","targetField":"mat_unit","default":"","id":"4","structure":"String","isStructure":false},{"field":"Plant","targetField":"plant","default":"","id":"5","structure":"Number","isStructure":false},{"field":"PbomVersion","targetField":"pbom_version","default":"","id":"6","structure":"String","isStructure":false},{"field":"IsDelete","targetField":"is_delete","default":"","id":"7","structure":"Number","isStructure":false},{"field":"CabinetType","targetField":"cabinet_type","default":"","id":"8","structure":"String","isStructure":false},{"field":"ProjectNo","targetField":"project_no","default":"","id":"9","structure":"String","isStructure":false},{"field":"ProjectDesc","targetField":"project_desc","default":"","id":"10","structure":"String","isStructure":false},{"field":"Version","targetField":"version","default":"","id":"11","structure":"String","isStructure":false},{"field":"DataType","targetField":"data_type","default":"","id":"12","structure":"String","isStructure":false},{"field":"List.ErpPbomDetailsModel","targetField":"pbom_details_models","default":"","id":"13","structure":"Array","fields":[{"field":"PbomCode","targetField":"pbom_code","default":"","id":"13_0","parentId":"13","structure":"String","isStructure":false},{"field":"MatCode","targetField":"mat_code","default":"","id":"13_1","parentId":"13","structure":"String","isStructure":false},{"field":"MatDes","targetField":"mat_des","default":"","id":"13_2","parentId":"13","structure":"String","isStructure":false},{"field":"Standard","targetField":"standard","default":"","id":"13_3","parentId":"13","structure":"String","isStructure":false},{"field":"MatUnit","targetField":"mat_unit","default":"","id":"13_4","parentId":"13","structure":"String","isStructure":false},{"field":"IsDelete","targetField":"is_delete","default":"","id":"13_5","parentId":"13","structure":"Number","isStructure":false},{"field":"ErpCode","targetField":"erp_code","default":"","id":"13_6","parentId":"13","structure":"String","isStructure":false},{"field":"ReplaceGroup","targetField":"replace_group","default":"","id":"13_7","parentId":"13","structure":"String","isStructure":false},{"field":"Level","targetField":"level","default":"","id":"13_8","parentId":"13","structure":"Number","isStructure":false},{"field":"PositionCode","targetField":"position_code","default":"","id":"13_9","parentId":"13","structure":"String","isStructure":false},{"field":"MergeCode","targetField":"merge_code","default":"","id":"13_10","parentId":"13","structure":"String","isStructure":false},{"field":"MatNum","targetField":"mat_num","default":"","id":"13_11","parentId":"13","structure":"String","isStructure":false}],"isStructure":true}],"processCollection":{"startProcess":"查询","startIdent":"search","process":[{"label":"查询","identification":"search","interface":"MES_SEARCHPBOM_INTERFACE","args":[{"name":"code","value":"mat_code"},{"name":"plant","value":"plant"},{"name":"pbom_version","value":"pbom_version"}],"isFirst":true,"hasPrecondition":false,"hasPostcondition":true,"precondition":[],"postcondition":[{"path":"data","result":"true","branch":[{"label":"删除","ident":"delete"},{"label":"更新","ident":"edit"}]},{"path":"data","result":"false","branch":[{"label":"新增","ident":"add"}]}],"sendBody":false},{"label":"新增","identification":"add","interface":"MES_ADDPBOM_INTERFACE","args":[],"isFirst":false,"hasPrecondition":false,"hasPostcondition":false,"precondition":[],"postcondition":[],"sendBody":true},{"label":"更新","identification":"edit","interface":"MES_EDITPBOM_INTERFACE","args":[],"isFirst":false,"hasPrecondition":false,"hasPostcondition":false,"precondition":[],"postcondition":[],"sendBody":true},{"label":"删除","identification":"delete","interface":"MES_DELETEPBOM_INTERFACE","args":[{"name":"code","value":"mat_code"},{"name":"plant","value":"plant"},{"name":"pbom_version","value":"pbom_version"}],"isFirst":false,"hasPrecondition":true,"hasPostcondition":false,"precondition":[{"path":"is_delete","result":"1"}],"postcondition":[],"sendBody":false}]},"hasConfig":true}');
INSERT INTO "ioit"."business_data" VALUES ('SAP_MES_AsyncOrdersn', '{"fieldMappingTable":[{"field":"OrderNo","targetField":"order_no","default":"","id":"0","structure":"String","isStructure":false},{"field":"SnNo","targetField":"sn_no","default":"","id":"1","structure":"String","isStructure":false}],"processCollection":{"startProcess":"新增","startIdent":"add","process":[{"label":"新增","identification":"add","interface":"MES_ADDSN_INTERFACE","args":[],"isFirst":true,"hasPrecondition":false,"hasPostcondition":false,"precondition":[],"postcondition":[],"sendBody":true}]},"hasConfig":true}');
INSERT INTO "ioit"."business_data" VALUES ('SAP_MES_OrderBOM', '{"fieldMappingTable":[{"field":"OrderNo","targetField":"order_no","default":"","id":"0","structure":"String","isStructure":false},{"field":"PlanNum","targetField":"plan_num","default":"","id":"1","structure":"Number","isStructure":false},{"field":"MatCode","targetField":"mat_code","default":"","id":"2","structure":"String","isStructure":false},{"field":"MatDes","targetField":"mat_des","default":"","id":"3","structure":"String","isStructure":false},{"field":"standard","targetField":"standard","default":"","id":"4","structure":"String","isStructure":false},{"field":"MatUnit","targetField":"mat_unit","default":"","id":"5","structure":"String","isStructure":false},{"field":"IsDelete","targetField":"is_delete","default":"","id":"6","structure":"Number","isStructure":false},{"field":"List.ErpProductionOrderDetailsModel","targetField":"erp_production_order_details_model","default":"","id":"7","structure":"Array","isStructure":true,"fields":[{"field":"OrderNo","targetField":"order_no","default":"","id":"7_0","parentId":"7","structure":"String","isStructure":false},{"field":"ErpCode","targetField":"erp_code","default":"","id":"7_1","parentId":"7","structure":"String","isStructure":false},{"field":"MatDescCode","targetField":"mat_desc_code","default":"","id":"7_2","parentId":"7","structure":"String","isStructure":false},{"field":"MatDescName","targetField":"mat_desc_name","default":"","id":"7_3","parentId":"7","structure":"String","isStructure":false},{"field":"MatNum","targetField":"mat_num","default":"","id":"7_4","parentId":"7","structure":"Number","isStructure":false},{"field":"MatUnit","targetField":"mat_unit","default":"","id":"7_5","parentId":"7","structure":"String","isStructure":false},{"field":"standard","targetField":"standard","default":"","id":"7_6","parentId":"7","structure":"String","isStructure":false},{"field":"IsDelete","targetField":"is_delete","default":"","id":"7_7","parentId":"7","structure":"Number","isStructure":false},{"field":"ProcessCode","targetField":"process_code","default":"","id":"7_8","parentId":"7","structure":"String","isStructure":false}]}],"processCollection":{"startProcess":"查询","startIdent":"search","process":[{"label":"查询","identification":"search","interface":"MES_SEARCHPORDER_INTERFACE","args":[{"name":"order_no","value":"order_no"}],"isFirst":true,"hasPrecondition":false,"hasPostcondition":true,"precondition":[],"postcondition":[{"path":"data","result":"true","branch":[{"label":"删除","ident":"delete"},{"label":"更新","ident":"edit"}]},{"path":"data","result":"false","branch":[{"label":"新增","ident":"add"}]}],"sendBody":false},{"label":"新增","identification":"add","interface":"MES_ADDPPORDER_INTERFACE","args":[],"isFirst":false,"hasPrecondition":false,"hasPostcondition":false,"precondition":[],"postcondition":[],"sendBody":true},{"label":"更新","identification":"edit","interface":"MES_EDITPORDER_INTERFACE","args":[],"isFirst":false,"hasPrecondition":false,"hasPostcondition":false,"precondition":[],"postcondition":[],"sendBody":true},{"label":"删除","identification":"delete","interface":"MES_DELETEPORDER_INTERFACE","args":[{"name":"order_no","value":"order_no"}],"isFirst":false,"hasPrecondition":true,"hasPostcondition":false,"precondition":[{"path":"is_delete","result":"1"}],"postcondition":[],"sendBody":false}]},"hasConfig":true}');
INSERT INTO "ioit"."business_data" VALUES ('SAP_MES_ProcessLine', '{"fieldMappingTable":[{"field":"Plnnr","targetField":"plnnr","default":"","id":"0","structure":"String","isStructure":false},{"field":"MatCode","targetField":"mat_code","default":"","id":"1","structure":"String","isStructure":false},{"field":"MatDes","targetField":"mat_des","default":"","id":"2","structure":"String","isStructure":false},{"field":"ProcessCode","targetField":"process_code","default":"","id":"3","structure":"String","isStructure":false},{"field":"ProcessDes","targetField":"process_des","default":"","id":"4","structure":"String","isStructure":false},{"field":"Plant","targetField":"plant","default":"","id":"5","structure":"Number","isStructure":false},{"field":"StartTime","targetField":"start_time","default":"","id":"6","structure":"Date","isStructure":false},{"field":"EndTime","targetField":"end_time","default":"","id":"7","structure":"Date","isStructure":false},{"field":"IsDelete","targetField":"is_delete","default":"","id":"8","structure":"Number","isStructure":false},{"field":"ErpUpdate","targetField":"erp_update","default":"","id":"9","structure":"Date","isStructure":false},{"field":"ErpCreateId","targetField":"erp_create_id","default":"","id":"10","structure":"Number","isStructure":false},{"field":"ErpUpdateId","targetField":"erp_update_id","default":"","id":"11","structure":"Number","isStructure":false},{"field":"List.ErpProductLineDetailsModel","targetField":"erp_product_line_details_model","default":"","id":"12","structure":"Array","fields":[{"field":"Plnkn","targetField":"plnkn","default":"","id":"12_0","parentId":"12","structure":"Number","isStructure":false},{"field":"MatCode","targetField":"mat_code","default":"","id":"12_1","parentId":"12","structure":"String","isStructure":false},{"field":"MatDes","targetField":"mat_des","default":"","id":"12_2","parentId":"12","structure":"String","isStructure":false},{"field":"Plant","targetField":"plant","default":"","id":"12_3","parentId":"12","structure":"Number","isStructure":false},{"field":"MatDetailsCode","targetField":"mat_details_code","default":"","id":"12_4","parentId":"12","structure":"String","isStructure":false},{"field":"ProcessesDes","targetField":"processes_des","default":"","id":"12_5","parentId":"12","structure":"String","isStructure":false},{"field":"Num","targetField":"num","default":"","id":"12_6","parentId":"12","structure":"Number","isStructure":false},{"field":"LaborHour","targetField":"labor_hour","default":"","id":"12_7","parentId":"12","structure":"Number","isStructure":false},{"field":"LaborHourUnit","targetField":"labor_hour_unit","default":"","id":"12_8","parentId":"12","structure":"String","isStructure":false},{"field":"MachineHour","targetField":"machine_hour","default":"","id":"12_9","parentId":"12","structure":"Number","isStructure":false},{"field":"MachineHourUnit","targetField":"machine_hour_unit","default":"","id":"12_10","parentId":"12","structure":"String","isStructure":false},{"field":"LaborPrepareHour","targetField":"labor_prepare_hour","default":"","id":"12_11","parentId":"12","structure":"Number","isStructure":false},{"field":"LaborPrepareHourUnit","targetField":"labor_prepare_hour_unit","default":"","id":"12_12","parentId":"12","structure":"String","isStructure":false},{"field":"MachinePrepareHour","targetField":"machine_prepare_hour","default":"","id":"12_13","parentId":"12","structure":"Number","isStructure":false},{"field":"MachinePrepareHourUnit","targetField":"machine_prepare_hour_unit","default":"","id":"12_14","parentId":"12","structure":"String","isStructure":false},{"field":"ErpUpdate","targetField":"erp_update","default":"","id":"12_15","parentId":"12","structure":"Date","isStructure":false},{"field":"StartTime","targetField":"start_time","default":"","id":"12_16","parentId":"12","structure":"Date","isStructure":false},{"field":"EndTime","targetField":"end_time","default":"","id":"12_17","parentId":"12","structure":"Date","isStructure":false},{"field":"IsDelete","targetField":"is_delete","default":"","id":"12_18","parentId":"12","structure":"Number","isStructure":false},{"field":"ErpCreateId","targetField":"erp_create_id","default":"","id":"12_19","parentId":"12","structure":"Number","isStructure":false},{"field":"ErpUpdateId","targetField":"erp_update_id","default":"","id":"12_20","parentId":"12","structure":"Number","isStructure":false},{"field":"ProcessCode","targetField":"process_code","default":"","id":"12_21","parentId":"12","structure":"String","isStructure":false},{"field":"Plnnr","targetField":"plnnr","default":"","id":"12_22","parentId":"12","structure":"String","isStructure":false}],"isStructure":true}],"processCollection":{"startProcess":"查询","startIdent":"search","process":[{"label":"查询","identification":"search","interface":"MES_SEARCHPROCESS_INTERFACE","args":[{"name":"code","value":"mat_code"},{"name":"plant","value":"plant"}],"isFirst":true,"hasPrecondition":false,"hasPostcondition":true,"precondition":[],"postcondition":[{"path":"data","result":"true","branch":[{"label":"删除","ident":"delete"},{"label":"更新","ident":"edit"}]},{"path":"data","result":"false","branch":[{"label":"新增","ident":"add"}]}],"sendBody":false},{"label":"新增","identification":"add","interface":"MES_ADDPROCESS_INTERFACE","args":[],"isFirst":false,"hasPrecondition":false,"hasPostcondition":false,"precondition":[],"postcondition":[],"sendBody":true},{"label":"更新","identification":"edit","interface":"MES_EDITPROCESS_INTERFACE","args":[],"isFirst":false,"hasPrecondition":false,"hasPostcondition":false,"precondition":[],"postcondition":[],"sendBody":true},{"label":"删除","identification":"delete","interface":"MES_DELETEPROCESS_INTERFACE","args":[{"name":"code","value":"mat_code"},{"name":"plant","value":"plant"}],"isFirst":false,"hasPrecondition":true,"hasPostcondition":false,"precondition":[{"path":"is_delete","result":"1"}],"postcondition":[],"sendBody":false}]},"hasConfig":true}');
INSERT INTO "ioit"."business_data" VALUES ('SAP_MES_ProductOrder', '{"fieldMappingTable":[{"field":"OrderNo","targetField":"order_no","default":"","id":"0","structure":"String","isStructure":false},{"field":"CmdTime","targetField":"cmd_time","default":"","id":"1","structure":"Date","isStructure":false},{"field":"OrderPriority","targetField":"order_priority","default":"","id":"2","structure":"Number","isStructure":false},{"field":"OrderBatch","targetField":"order_batch","default":"","id":"3","structure":"String","isStructure":false},{"field":"OrderType","targetField":"order_type","default":"","id":"4","structure":"String","isStructure":false},{"field":"MatCode","targetField":"mat_code","default":"","id":"5","structure":"String","isStructure":false},{"field":"OrderNum","targetField":"order_num","default":"","id":"6","structure":"Number","isStructure":false},{"field":"Unit","targetField":"unit","default":"","id":"7","structure":"String","isStructure":false},{"field":"Plant","targetField":"plant","default":"","id":"8","structure":"Number","isStructure":false},{"field":"PlanStarttime","targetField":"plan_starttime","default":"","id":"9","structure":"Date","isStructure":false},{"field":"PlanEndtime","targetField":"plan_endtime","default":"","id":"10","structure":"Date","isStructure":false},{"field":"ProcessCode","targetField":"process_code","default":"","id":"11","structure":"String","isStructure":false},{"field":"PbomCode","targetField":"pbom_code","default":"","id":"12","structure":"String","isStructure":false},{"field":"OrderStatus","targetField":"order_status","default":"","id":"13","structure":"String","isStructure":false},{"field":"IsDelete","targetField":"is_delete","default":"","id":"14","structure":"Number","isStructure":false}],"processCollection":{"startProcess":"查询","startIdent":"search","process":[{"label":"查询","identification":"search","interface":"MES_SEARCHORDER_INTERFACE","args":[{"name":"plant","value":"plant"},{"name":"order_no","value":"order_no"}],"isFirst":true,"hasPrecondition":false,"hasPostcondition":true,"precondition":[],"postcondition":[{"path":"data","result":"true","branch":[{"label":"删除","ident":"delete"},{"label":"更新","ident":"edit"}]},{"path":"data","result":"false","branch":[{"label":"新增","ident":"add"}]}],"sendBody":false},{"label":"新增","identification":"add","interface":"MES_ADDORDER_INTERFACE","args":[],"isFirst":false,"hasPrecondition":false,"hasPostcondition":false,"precondition":[],"postcondition":[],"sendBody":true},{"label":"更新","identification":"edit","interface":"MES_EDITORDER_INTERFACE","args":[],"isFirst":false,"hasPrecondition":false,"hasPostcondition":false,"precondition":[],"postcondition":[],"sendBody":true},{"label":"删除","identification":"delete","interface":"MES_DELETEORDER_INTERFACE","args":[{"name":"order_no","value":"order_no"},{"name":"plant","value":"plant"}],"isFirst":false,"hasPrecondition":true,"hasPostcondition":false,"precondition":[{"path":"is_delete","result":"1"}],"postcondition":[],"sendBody":false}]},"hasConfig":true}');
INSERT INTO "ioit"."business_data" VALUES ('SAP_MES_ProductProcess', '{"fieldMappingTable":[{"field":"Plnnr","targetField":"plnnr","default":"","id":"0","structure":"String","isStructure":false},{"field":"Plnkn","targetField":"plnkn","default":"","id":"11","structure":"Number","isStructure":false},{"field":"MatCode","targetField":"mat_code","default":"","id":"1","structure":"String","isStructure":false},{"field":"MatDes","targetField":"mat_des","default":"","id":"2","structure":"String","isStructure":false},{"field":"Plant","targetField":"plant","default":"","id":"3","structure":"Number","isStructure":false},{"field":"MatDetailsCode","targetField":"mat_details_code","default":"","id":"4","structure":"String","isStructure":false},{"field":"ProcessesDes","targetField":"processes_des","default":"","id":"5","structure":"String","isStructure":false},{"field":"Num","targetField":"num","default":"","id":"6","structure":"Number","isStructure":false},{"field":"IsDelete","targetField":"is_delete","default":"","id":"7","structure":"Number","isStructure":false},{"field":"ErpUpdate","targetField":"erp_update","default":"","id":"12","structure":"Date","isStructure":false},{"field":"ErpCreateId","targetField":"erp_create_id","default":"","id":"8","structure":"Number","isStructure":false},{"field":"ErpUpdateId","targetField":"erp_update_id","default":"","id":"9","structure":"Number","isStructure":false},{"field":"ProcessCode","targetField":"process_code","default":"","id":"10","structure":"String","isStructure":false}],"processCollection":{"startProcess":"查询","startIdent":"search","process":[{"label":"查询","identification":"search","interface":"MES_SEARCHFLOW_INTERFACE","args":[{"name":"plnnr","value":"plnnr"},{"name":"plnkn","value":"plnkn"}],"isFirst":true,"hasPrecondition":false,"hasPostcondition":true,"precondition":[],"postcondition":[{"path":"data","result":"true","branch":[{"label":"删除","ident":"delete"},{"label":"更新","ident":"edit"}]},{"path":"data","result":"false","branch":[{"label":"新增","ident":"add"}]}],"sendBody":false},{"label":"新增","identification":"add","interface":"MES_ADDPPFLOW_INTERFACE","args":[],"isFirst":false,"hasPrecondition":false,"hasPostcondition":false,"precondition":[],"postcondition":[],"sendBody":true},{"label":"更新","identification":"edit","interface":"MES_EDITPFLOW_INTERFACE","args":[],"isFirst":false,"hasPrecondition":false,"hasPostcondition":false,"precondition":[],"postcondition":[],"sendBody":true},{"label":"删除","identification":"delete","interface":"MES_DELETEPFLOW_INTERFACE","args":[{"name":"plnnr","value":"plnnr"},{"name":"plnkn","value":"plnkn"}],"isFirst":false,"hasPrecondition":true,"hasPostcondition":false,"precondition":[{"path":"is_delete","result":"1"}],"postcondition":[],"sendBody":false}]},"hasConfig":true}');
INSERT INTO "ioit"."business_data" VALUES ('MES_SAP_ReportWork', '{"fieldMappingTable":[{"field":"order_no","targetField":"AUFNR","default":"","id":"0","structure":"String","isStructure":false},{"field":"output","targetField":"LMNGA","default":"","id":"1","structure":"Number","isStructure":false},{"field":"reject","targetField":"XMNGA","default":"","id":"2","structure":"Number","isStructure":false},{"field":"Sap_step_code","targetField":"VORNR","default":"","id":"3","structure":"String","isStructure":false},{"field":"labor_hour","targetField":"ISM04","default":"","id":"4","structure":"Number","isStructure":false},{"field":"labor_hour_unit","targetField":"ILE04","default":"","id":"5","structure":"String","isStructure":false},{"field":"machine_hour","targetField":"ISM03","default":"","id":"6","structure":"Number","isStructure":false},{"field":"machine_hour_unit","targetField":"ILE03","default":"","id":"7","structure":"String","isStructure":false},{"field":"Is_finish","targetField":"AUERU","default":"","id":"8","structure":"Number","isStructure":false}],"processCollection":{"startProcess":"同步","startIdent":"report","process":[{"label":"同步","identification":"report","interface":"MES_REPORTWORK_INTERFACE","args":[],"isFirst":true,"hasPrecondition":false,"hasPostcondition":false,"precondition":[],"postcondition":[],"sendBody":true,"bodyType":"XML"}]},"hasConfig":true}');
INSERT INTO "ioit"."business_data" VALUES ('MES_SAP_OrderStatus', '{"fieldMappingTable":[{"field":"order_no","targetField":"OrderNo","default":"","id":"0","structure":"String","isStructure":false},{"field":"order_status","targetField":"OrderStatus","default":"","id":"1","structure":"String","isStructure":false}],"processCollection":{"startProcess":"同步","startIdent":"report","process":[{"label":"同步","identification":"report","interface":"MES_REPORTORDERSTATUS_INTERFACE","args":[],"isFirst":true,"hasPrecondition":false,"hasPostcondition":false,"precondition":[],"postcondition":[],"sendBody":true,"bodyType":"XML"}]},"hasConfig":true}');
-- ----------------------------
-- Table structure for component
-- ----------------------------
DROP TABLE IF EXISTS "ioit"."component";
CREATE TABLE "ioit"."component" (
"label" varchar(255) COLLATE "pg_catalog"."default",
"value" varchar(255) COLLATE "pg_catalog"."default",
"node_type" varchar(255) COLLATE "pg_catalog"."default",
"node_mark" varchar(255) COLLATE "pg_catalog"."default",
"img" varchar(255) COLLATE "pg_catalog"."default",
"no_config_msg" varchar(255) COLLATE "pg_catalog"."default",
"node_data" varchar(255) COLLATE "pg_catalog"."default",
"cate_key" varchar(255) COLLATE "pg_catalog"."default",
"applicable_type" varchar(255) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "ioit"."component"."applicable_type" IS '用于区分组件适用类型
all表示不区分场景
client表示客户端
server表示服务';
-- ----------------------------
-- Records of component
-- ----------------------------
INSERT INTO "ioit"."component" VALUES ('SAP产品工艺路线同步MES', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP产品工艺路线同步MES的信息', '{"type":"SAP_MES_ProcessLine","modular_package":false}', 'business_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('SAP生产订单', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP生产订单的信息', '{"type":"SAP_MES_ProductOrder","modular_package":true}', 'business_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('SAP生产订单同步MES', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP生产订单同步MES的信息', '{"type":"SAP_MES_ProductOrder","modular_package":false}', 'business_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('SAP产品工序', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP产品工序的信息', '{"type":"SAP_MES_ProductProcess","modular_package":true}', 'business_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('SAP物料', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP物料的信息', '{"type": "SAP_MES_Material","modular_package": true}', 'business_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('SAP物料同步MES', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP物料同步MES的信息', '{"type": "SAP_MES_Material"}', 'business_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('SAP产品BOM', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP产品BOM的信息', '{"type": "SAP_MES_ProductBOM","modular_package": true}', 'business_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('SAP产品BOM同步MES', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP产品BOM同步MES的信息', '{"type": "SAP_MES_ProductBOM"}', 'business_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('HiaBatch转信息模型', 'HiaBatchToInfoModel', 'transform', 'HiaBatch-to-infoModel', 'filedata-convert', '请配置HiaBatch转信息模型', '', 'transform_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('SAP订单产品SN', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP订单产品SN的信息', '{"type": "SAP_MES_AsyncOrdersn","modular_package": true}', 'business_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('SAP订单BOM', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP订单BOM的信息', '{"type":"SAP_MES_OrderBOM","modular_package":true}', 'business_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('SAP订单BOM同步MES', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP订单BOM同步MES的信息', '{"type":"SAP_MES_OrderBOM","modular_package":false}', 'business_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('SAP订单产品SN同步MES', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP订单产品SN同步MES的信息', '{"type": "SAP_MES_AsyncOrdersn"}', 'business_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('API', 'Api', 'input', 'API', 'http-client', '请配置API输入', '', 'input_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('关系数据库', 'DataBase', 'input', 'database', 'database', '请配置数据库信息', '', 'input_c_key', 'client');
INSERT INTO "ioit"."component" VALUES ('电子工厂MySQL', 'MySQL', 'input', 'mysql', 'mysql', '请配置MySQL数据库信息', '', 'input_c_key', 'client');
INSERT INTO "ioit"."component" VALUES ('API', 'Api', 'output', 'API', 'http-client', '请配置API输出', '', 'output_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('信息模型', 'InfoModel', 'output', 'info-model', 'info-model', '请配置信息模型的信息', '', 'output_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('关系数据库', 'DataBase', 'output', 'database', 'database', '请配置数据库信息', '', 'output_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('字段排序', 'FieldSort', 'transform', 'field-sort', 'field-sort', '请配置字段排序', '', 'transform_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('字段选择', 'FieldSelect', 'transform', 'field-select', 'field-select', '请配置字段选择', '', 'transform_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('字段映射', 'FieldMapping', 'transform', 'field-mapping', 'data-mapping', '请配置字段映射', '', 'transform_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('数据加解密', 'DataEnOrDecryption', 'transform', 'data-enordecryption', 'data-enordecryption', '', '', 'transform_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('类型转换', 'TypeConvert', 'transform', 'type-convert', 'type-convert', '', '', 'transform_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('记录集连接', 'RecordesetLink', 'transform', 'recordeset-link', 'recordeset-link', '', '', 'transform_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('数据映射', 'DataMapping', 'transform', 'mapping', 'mapping', '', '', 'transform_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('数据计算', 'DataComputed', 'transform', 'data-computed', 'data-computed', '', '', 'transform_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('XML解析', 'XMLToJSON', 'transform', 'xml-json', 'xml-json', '', '', 'transform_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('数据过滤', 'DataFilter', 'transform', 'data-filter', 'data-filter', '', '', 'transform_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('映射结构输出', 'MappingOutput', 'transform', 'mapping-output', 'mapping-output', '请配置映射结构输出', '', 'transform_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('映射关系', 'MappingRelation', 'transform', 'mapping-relation', 'mapping-relation', '请配置映射关系', '', 'transform_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('数据校验', 'DataValidate', 'transform', 'data-validate', 'data-validate', '请配置数据校验', '', 'transform_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('SAP产品工艺路线', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP产品工艺路线的信息', '{"type":"SAP_MES_ProcessLine","modular_package":true}', 'business_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('SAP产品工序同步MES', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP产品工序同步MES的信息', '{"type":"SAP_MES_ProductProcess","modular_package":false}', 'business_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('MES生产订单报工', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP生产订单报工的信息', '{"type":"MES_SAP_ReportWork","modular_package":true}', 'business_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('MES生产订单报工同步SAP', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置MES生产订单报工同步SAP的信息', '{"type":"MES_SAP_ReportWork","modular_package":false}', 'business_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('MES生产订单状态', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置MES生产订单状态的信息', '{"type":"MES_SAP_OrderStatus","modular_package":true}', 'business_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('文件系统', 'File', 'input', 'file', 'file', '请配置文件信息', '', 'input_c_key', 'client');
INSERT INTO "ioit"."component" VALUES ('流程接口', 'ProcessInterface', 'output', 'process-interface', 'process-interface', '请配置流程接口的信息', '', 'output_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('MES生产订单状态同步SAP', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置MES生产订单状态同步SAP的信息', '{"type":"MES_SAP_OrderStatus","modular_package":false}', 'business_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('字段哈希', 'FieldHash', 'transform', 'field-hash', 'field-hash', '请配置字段哈希', '', 'transform_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('数据同步', 'DataAsync', 'transform', 'data-async', 'field-select', '请配置数据同步', '', 'transform_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('字段拆分', 'FieldSplit', 'transform', 'field-split', 'field-split', '', '', 'transform_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('JSON解析', 'JSONStructrueSelect', 'transform', 'json-structrue', 'json-structrue', '', '', 'transform_c_key', 'all');
INSERT INTO "ioit"."component" VALUES ('文件数据转换', 'FileDataConvert', 'transform', 'file-data-convert', 'filedata-convert', '请配置数据转换', '', 'transform_c_key', 'all');
-- ----------------------------
-- Table structure for component_cata
-- ----------------------------
DROP TABLE IF EXISTS "ioit"."component_cata";
CREATE TABLE "ioit"."component_cata" (
"label" varchar(255) COLLATE "pg_catalog"."default",
"value" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
"id" varchar(255) COLLATE "pg_catalog"."default" NOT NULL
)
;
-- ----------------------------
-- Records of component_cata
-- ----------------------------
INSERT INTO "ioit"."component_cata" VALUES ('输入组件', 'input', 'input_c_key');
INSERT INTO "ioit"."component_cata" VALUES ('转换组件', 'transform', 'transform_c_key');
INSERT INTO "ioit"."component_cata" VALUES ('输出组件', 'output', 'output_c_key');
INSERT INTO "ioit"."component_cata" VALUES ('业务组件', 'business', 'business_c_key');
-- ----------------------------
-- Table structure for data_publish
-- ----------------------------
DROP TABLE IF EXISTS "ioit"."data_publish";
CREATE TABLE "ioit"."data_publish" (
"len_index" int8
)
;
-- ----------------------------
-- Records of data_publish
-- ----------------------------
INSERT INTO "ioit"."data_publish" VALUES (2);
-- ----------------------------
-- Table structure for database_info
-- ----------------------------
DROP TABLE IF EXISTS "ioit"."database_info";
CREATE TABLE "ioit"."database_info" (
"code" varchar(40) COLLATE "pg_catalog"."default",
"connectname" varchar(255) COLLATE "pg_catalog"."default",
"username" varchar(255) COLLATE "pg_catalog"."default",
"password" varchar(255) COLLATE "pg_catalog"."default",
"host" varchar(40) COLLATE "pg_catalog"."default",
"port" varchar(10) COLLATE "pg_catalog"."default",
"namespace" varchar(40) COLLATE "pg_catalog"."default",
"databasetype" varchar(10) COLLATE "pg_catalog"."default",
"dbname" varchar(255) COLLATE "pg_catalog"."default",
"schemaname" varchar(255) COLLATE "pg_catalog"."default",
"tablename" varchar(255) COLLATE "pg_catalog"."default",
"dbpath" varchar(255) COLLATE "pg_catalog"."default",
"s_node" varchar(10) COLLATE "pg_catalog"."default"
)
;
-- ----------------------------
-- Records of database_info
-- ----------------------------
INSERT INTO "ioit"."database_info" VALUES ('mysql_03121108', 'pg6', 'root', '123456', '100.0.0.6', '3306', 'hsm_io_it', 'MySQL', '', '', '', '', 'unpublish');
-- ----------------------------
-- Table structure for job_cata
-- ----------------------------
DROP TABLE IF EXISTS "ioit"."job_cata";
CREATE TABLE "ioit"."job_cata" (
"cl_code" varchar(255) COLLATE "pg_catalog"."default",
"cg_name" varchar(255) COLLATE "pg_catalog"."default",
"cg_parent" varchar(255) COLLATE "pg_catalog"."default",
"namespace" varchar(255) COLLATE "pg_catalog"."default",
"s_node" varchar(10) COLLATE "pg_catalog"."default",
"cg_describe" text COLLATE "pg_catalog"."default"
)
;
-- ----------------------------
-- Records of job_cata
-- ----------------------------
INSERT INTO "ioit"."job_cata" VALUES ('cate_rootroot', '默认作业分类', '', 'hsm_io_it', '', '默认作业分类');
INSERT INTO "ioit"."job_cata" VALUES ('cate_r37760oz', 'test', '默认作业分类', 'hsm_io_it', 'e1', '');
INSERT INTO "ioit"."job_cata" VALUES ('cate_u5wr0q96', 'aaa', '默认作业分类', 'hsm_io_it', 's1', '');
-- ----------------------------
-- Table structure for job_info
-- ----------------------------
DROP TABLE IF EXISTS "ioit"."job_info";
CREATE TABLE "ioit"."job_info" (
"namespace" varchar(255) COLLATE "pg_catalog"."default",
"s_node" varchar(255) COLLATE "pg_catalog"."default",
"code" varchar(255) COLLATE "pg_catalog"."default",
"name" varchar(255) COLLATE "pg_catalog"."default",
"describe" varchar(255) COLLATE "pg_catalog"."default",
"schedule" varchar(255) COLLATE "pg_catalog"."default",
"schedule_details" varchar(255) COLLATE "pg_catalog"."default",
"schedule_cycle" varchar(255) COLLATE "pg_catalog"."default",
"schedule_unit" varchar(255) COLLATE "pg_catalog"."default",
"content" jsonb,
"cron_id" varchar(255) COLLATE "pg_catalog"."default",
"is_http" bool,
"canvas" jsonb,
"job_type" varchar(255) COLLATE "pg_catalog"."default",
"job_class" varchar(255) COLLATE "pg_catalog"."default",
"template" varchar(255) COLLATE "pg_catalog"."default",
"id" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
"status" int8,
"create_time" timestamptz(6),
"edite_time" timestamptz(6),
"create_user" varchar(255) COLLATE "pg_catalog"."default",
"is_auto_select_id" bool,
"cron_detail" jsonb,
"period_detail" jsonb
)
;
-- ----------------------------
-- Records of job_info
-- ----------------------------
INSERT INTO "ioit"."job_info" VALUES ('hsm_io_it', 's1', 'job_cypv5c1m', 'aa', 'sdf', '2', '@every 60s', '60', 'second', '{"benthos_yaml": "input: {}\npipeline: {}\noutput: {}\nlogger:\n level: ALL\n format: json\n add_timestamp: true\n file:\n path: /usr/local/hsm-os/data/hsm-io-it/data/benthos/json/job_cypv5c1m.json\n rotate: true\n", "canvas_param": [], "node_data_map": {}, "node_yaml_map": {"input": {}, "output": {}, "transform": {"PBE7U696Ppvbe-1ukJakM": {"label": "fieldmapping0_1", "mapping": "map mapping {\nOrderNo = this.\"order_no\"\nOrderStatus = this.\"order_status\"\n}\nroot = if this.catch(root).type() == \"array\" { this.catch(root).map_each(item -> item.apply(\"mapping\"))} else { this.catch(root).catch({}).apply(\"mapping\") }\n"}}}, "benthos_componnet": null}', '', 't', '{"lineList": [], "nodeList": [{"x": 565, "y": 149, "id": "PBE7U696Ppvbe-1ukJakM", "img": "sap", "attrs": {"config": false, "fieldData": [{"id": "0", "field": "order_no", "default": "", "structure": "String", "isStructure": false, "targetField": "OrderNo"}, {"id": "1", "field": "order_status", "default": "", "structure": "String", "isStructure": false, "targetField": "OrderStatus"}], "resultKey": "fieldmapping0"}, "label": "MES生产订单状态", "ports": [{"id": "8ca47f4c-5a26-49ca-9c89-f94acd9a89df", "group": "input"}, {"id": "d0e39f08-8a76-40db-adcb-26fc72e46565", "group": "output"}], "value": "FieldMapping", "status": "success", "cateKey": "business_c_key", "message": "配置完毕", "isConfig": true, "nodeData": "{\"type\":\"MES_SAP_OrderStatus\",\"modular_package\":true}", "nodeMark": "field-mapping", "nodeType": "transform", "resultKey": "fieldmapping0", "outputdata": {"fields": [], "dataType": "object", "outputKey": "fieldmapping0"}, "noConfigMsg": "请配置MES生产订单状态的信息", "flowNodeType": "transform"}]}', 'realtime', 'cate_rootroot', '', 'job_cypv5c1m', 0, '2024-11-08 18:36:58+08', '2024-11-08 18:37:23+08', 'admin', 't', '{"type": "", "endDate": "", "endType": "endless", "dayOfWeek": "", "dayOfMonth": "", "executeMonth": "", "effectiveDate": ""}', '{"times": 1, "endDate": "endless", "endType": "endless", "effectiveDate": "", "schedule_unit": "second", "schedule_cycle": 60}');
INSERT INTO "ioit"."job_info" VALUES ('c9c72df67e834db99726291c3e549636', 'e1', 'job_f8ie1aei', '新建作业1', '', '2', '@every 30s', '30', 'second', '{"benthos_yaml": "", "canvas_param": null, "node_data_map": null, "node_yaml_map": null, "benthos_componnet": null}', '', 'f', '{}', 'timing', '', '', 'job_f8ie1aei', 0, '2024-09-04 14:40:23+08', '2024-11-05 14:29:33+08', 'admin', 'f', '{"type": "", "endDate": "", "endType": "", "dayOfWeek": "", "dayOfMonth": "", "executeMonth": "", "effectiveDate": "2024-09-04 14:40:23"}', '{"times": 0, "endDate": "", "endType": "endless", "effectiveDate": "", "schedule_unit": "second", "schedule_cycle": 30}');
INSERT INTO "ioit"."job_info" VALUES ('c9c72df67e834db99726291c3e549636', 'e1', 'job_eeu4x0il', '新建作业', '', '2', '@every 30s', '30', 'second', '{"benthos_yaml": "", "canvas_param": null, "node_data_map": null, "node_yaml_map": null, "benthos_componnet": null}', '', 'f', '{}', 'timing', '', '', 'job_eeu4x0il', 0, '2024-09-04 14:40:21+08', '2024-11-05 14:29:33+08', 'admin', 'f', '{"type": "", "endDate": "", "endType": "", "dayOfWeek": "", "dayOfMonth": "", "executeMonth": "", "effectiveDate": "2024-09-04 14:40:21"}', '{"times": 0, "endDate": "", "endType": "endless", "effectiveDate": "", "schedule_unit": "second", "schedule_cycle": 30}');
INSERT INTO "ioit"."job_info" VALUES ('hsm_io_it', 's1', 'job_i6jlrnnl', 'aaa', 'adsfa', '2', '@every 60s', '60', 'second', '{"benthos_yaml": "input: {}\npipeline: {}\noutput: {}\nlogger:\n level: ALL\n format: json\n add_timestamp: true\n file:\n path: /usr/local/hsm-os/data/hsm-io-it/data/benthos/json/job_i6jlrnnl.json\n rotate: true\n", "canvas_param": [], "node_data_map": {}, "node_yaml_map": {"input": {}, "output": {}, "transform": {}}, "benthos_componnet": null}', '', 't', '{"lineList": [{"id": "f5711018-a9ce-4150-b59e-0c40dc7d7b19", "shape": "edge", "source": {"cell": "fHwQaO6V2HmFmW75GtXCJ", "port": "13079e78-930c-41d1-bdda-b490f287506c"}, "target": {"cell": "4Ozp062jDvrTufWjN1MPP", "port": "e1b6c3ca-8333-4254-a89f-a398daa8ec46"}}, {"id": "be9a0c36-c128-4593-93c3-06c252457c30", "shape": "edge", "source": {"cell": "4Ozp062jDvrTufWjN1MPP", "port": "d2177b32-331b-4693-b359-4d38c610f11e"}, "target": {"cell": "3igaa2gzEJ5paZyM_ohhm", "port": "af30f150-d3cd-423c-96b6-e6861de1f7ce"}}], "nodeList": [{"x": 334, "y": 93, "id": "fHwQaO6V2HmFmW75GtXCJ", "img": "http-client", "label": "API输入", "ports": [{"id": "13079e78-930c-41d1-bdda-b490f287506c", "group": "input"}], "value": "Api", "status": "", "cateKey": "input_c_key", "message": "", "isConfig": false, "nodeData": "", "nodeMark": "API", "nodeType": "input", "resultKey": "API", "noConfigMsg": "请配置API输入", "flowNodeType": "input"}, {"x": 566, "y": 109, "id": "4Ozp062jDvrTufWjN1MPP", "img": "data-mapping", "label": "字段映射", "ports": [{"id": "d2177b32-331b-4693-b359-4d38c610f11e", "group": "input"}, {"id": "e1b6c3ca-8333-4254-a89f-a398daa8ec46", "group": "output"}], "value": "FieldMapping", "status": "", "cateKey": "transform_c_key", "message": "", "isConfig": false, "nodeData": "", "nodeMark": "field-mapping", "nodeType": "transform", "resultKey": "fieldmapping", "noConfigMsg": "请配置字段映射", "flowNodeType": "transform"}, {"x": 779, "y": 115, "id": "3igaa2gzEJ5paZyM_ohhm", "img": "http-client", "label": "API输出", "ports": [{"id": "af30f150-d3cd-423c-96b6-e6861de1f7ce", "group": "output"}], "value": "Api", "status": "", "cateKey": "output_c_key", "message": "", "isConfig": false, "nodeData": "", "nodeMark": "API", "nodeType": "output", "resultKey": "API1", "noConfigMsg": "请配置API输出", "flowNodeType": "output"}]}', 'realtime', 'cate_r37760oz', '', 'job_i6jlrnnl', 0, '2024-11-14 13:52:33+08', '2024-11-14 13:55:12+08', 'admin', 't', '{"type": "", "endDate": "", "endType": "endless", "dayOfWeek": "", "dayOfMonth": "", "executeMonth": "", "effectiveDate": ""}', '{"times": 1, "endDate": "endless", "endType": "endless", "effectiveDate": "", "schedule_unit": "second", "schedule_cycle": 60}');
INSERT INTO "ioit"."job_info" VALUES ('hsm_io_it', 's1', 'job_h2vr7fb0', 'test', '', '2', '@every 60s', '60', 'second', '{"benthos_yaml": "input:\n label: interval\n generate:\n interval: 0s\n count: 1\n mapping: root = {}\npipeline:\n processors:\n - branch:\n processors:\n - sql_raw:\n args_mapping: \"[0]\"\n driver: mysql\n dsn: root:123456@tcp(100.0.0.6:3306)/fanfan\n query: SELECT\n id,device_name,pointvalue1,pointvalue10,pointvalue2,pointvalue3,pointvalue4,pointvalue5,pointvalue6,pointvalue7,pointvalue8,pointvalue9\n FROM devicecount100 where 1 = ? or id\n in(''0'',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'',''9'')\n result_map: root.database = this\noutput:\n branch:\n processors:\n - mapping: root = if this.query == null { {\"query\":{} }} else {this}\n - http:\n headers:\n Authorization: Bearer\n eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VySWQiOiJIU00tSU8tSVQiLCJ1c2VyQWNjb3VudCI6IkhTTS1JTy1JVCIsImxvZ2luQ2xpZW50IjoiV0VCIiwidXNlck5hbWUiOiJIU00tSU8tSVQiLCJzaWQiOiI0YzU2NTk3NC1lYmJhLTQ2MzgtYTc2NC1iZWU1OTlkMTc2MDUiLCJ0eXBlIjoiQVBQIiwibG9naW5UaW1lIjoiMjAyNC0wMS0yMlQwOToxNDozMS4zOTZaIiwiaWF0IjoxNzA1OTE0ODcxfQ.p4KcVHdBfYc5GsQ3StuBfByvpDXoDHwvsTqHsO3wqRs\n Content-Type: application/json\n rate_limit: \"\"\n retries: 0\n timeout: 60s\n url: http://100.0.0.141:6543/api/graphql/model\n verb: POST\nlogger:\n level: ALL\n format: json\n add_timestamp: true\n file:\n path: /usr/local/hsm-os/data/hsm-io-it/data/benthos/json/job_h2vr7fb0.json\n rotate: true\n", "canvas_param": [], "node_data_map": {"database": [{"id": 0, "device_name": "TEST_0", "pointvalue1": 0, "pointvalue2": 4, "pointvalue3": 87, "pointvalue4": 18, "pointvalue5": 91, "pointvalue6": 32, "pointvalue7": 54, "pointvalue8": 74, "pointvalue9": 20, "pointvalue10": 47}, {"id": 1, "device_name": "TEST_1", "pointvalue1": 1, "pointvalue2": 7, "pointvalue3": 40, "pointvalue4": 57, "pointvalue5": 65, "pointvalue6": 56, "pointvalue7": 72, "pointvalue8": 95, "pointvalue9": 69, "pointvalue10": 50}, {"id": 2, "device_name": "TEST_2", "pointvalue1": 2, "pointvalue2": 3, "pointvalue3": 93, "pointvalue4": 89, "pointvalue5": 65, "pointvalue6": 46, "pointvalue7": 27, "pointvalue8": 75, "pointvalue9": 14, "pointvalue10": 14}, {"id": 3, "device_name": "TEST_3", "pointvalue1": 3, "pointvalue2": 1, "pointvalue3": 48, "pointvalue4": 79, "pointvalue5": 60, "pointvalue6": 53, "pointvalue7": 75, "pointvalue8": 27, "pointvalue9": 79, "pointvalue10": 36}, {"id": 4, "device_name": "TEST_4", "pointvalue1": 4, "pointvalue2": 1, "pointvalue3": 74, "pointvalue4": 31, "pointvalue5": 14, "pointvalue6": 54, "pointvalue7": 38, "pointvalue8": 17, "pointvalue9": 54, "pointvalue10": 26}, {"id": 5, "device_name": "TEST_5", "pointvalue1": 5, "pointvalue2": 4, "pointvalue3": 62, "pointvalue4": 69, "pointvalue5": 56, "pointvalue6": 63, "pointvalue7": 50, "pointvalue8": 47, "pointvalue9": 78, "pointvalue10": 57}, {"id": 6, "device_name": "TEST_6", "pointvalue1": 6, "pointvalue2": 3, "pointvalue3": 21, "pointvalue4": 66, "pointvalue5": 76, "pointvalue6": 82, "pointvalue7": 81, "pointvalue8": 62, "pointvalue9": 54, "pointvalue10": 74}, {"id": 7, "device_name": "TEST_7", "pointvalue1": 7, "pointvalue2": 1, "pointvalue3": 42, "pointvalue4": 52, "pointvalue5": 33, "pointvalue6": 92, "pointvalue7": 81, "pointvalue8": 29, "pointvalue9": 71, "pointvalue10": 78}, {"id": 8, "device_name": "TEST_8", "pointvalue1": 8, "pointvalue2": 7, "pointvalue3": 47, "pointvalue4": 85, "pointvalue5": 97, "pointvalue6": 40, "pointvalue7": 78, "pointvalue8": 79, "pointvalue9": 63, "pointvalue10": 68}, {"id": 9, "device_name": "TEST_9", "pointvalue1": 9, "pointvalue2": 4, "pointvalue3": 38, "pointvalue4": 27, "pointvalue5": 13, "pointvalue6": 63, "pointvalue7": 87, "pointvalue8": 57, "pointvalue9": 11, "pointvalue10": 57}]}, "node_yaml_map": {"input": {"bu2IBPIo8SXaf0u17MqrP": {"branch": {"processors": [{"sql_raw": {"dsn": "root:123456@tcp(100.0.0.6:3306)/fanfan", "query": "SELECT id,device_name,pointvalue1,pointvalue10,pointvalue2,pointvalue3,pointvalue4,pointvalue5,pointvalue6,pointvalue7,pointvalue8,pointvalue9 FROM devicecount100 where 1 = ? or id in(''0'',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'',''9'')", "driver": "mysql", "args_mapping": "[0]"}}], "result_map": "root.database = this"}}}, "output": {"wLrMDNmRoldd6QfDbm_Av": {"branch": {"processors": [{"mapping": "root = if this.query == null { {\"query\":{} }} else {this}"}, {"http": {"url": "http://100.0.0.141:6543/api/graphql/model", "verb": "POST", "headers": {"Content-Type": "application/json", "Authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VySWQiOiJIU00tSU8tSVQiLCJ1c2VyQWNjb3VudCI6IkhTTS1JTy1JVCIsImxvZ2luQ2xpZW50IjoiV0VCIiwidXNlck5hbWUiOiJIU00tSU8tSVQiLCJzaWQiOiI0YzU2NTk3NC1lYmJhLTQ2MzgtYTc2NC1iZWU1OTlkMTc2MDUiLCJ0eXBlIjoiQVBQIiwibG9naW5UaW1lIjoiMjAyNC0wMS0yMlQwOToxNDozMS4zOTZaIiwiaWF0IjoxNzA1OTE0ODcxfQ.p4KcVHdBfYc5GsQ3StuBfByvpDXoDHwvsTqHsO3wqRs"}, "retries": 0, "timeout": "60s", "rate_limit": ""}}]}}}, "transform": {}}, "benthos_componnet": null}', '', 'f', '{"lineList": [{"id": "1f964171-86a7-4371-940c-593df830183f", "shape": "edge", "source": {"cell": "bu2IBPIo8SXaf0u17MqrP", "port": "f93e4e86-e43e-4e28-abe7-759e992b64b0"}, "target": {"cell": "wLrMDNmRoldd6QfDbm_Av", "port": "3691b549-6e89-412b-b996-b2da877c4e97"}}], "nodeList": [{"x": 360, "y": 191, "id": "bu2IBPIo8SXaf0u17MqrP", "img": "database", "attrs": {"sql": "", "mainKey": ["id"], "resultKey": "database", "selectData": [{"id": 0, "symbolKey": "0,", "device_name": "TEST_0", "pointvalue1": 0, "pointvalue2": 4, "pointvalue3": 87, "pointvalue4": 18, "pointvalue5": 91, "pointvalue6": 32, "pointvalue7": 54, "pointvalue8": 74, "pointvalue9": 20, "pointvalue10": 47, "symbolSortKey": 0}, {"id": 1, "symbolKey": "1,", "device_name": "TEST_1", "pointvalue1": 1, "pointvalue2": 7, "pointvalue3": 40, "pointvalue4": 57, "pointvalue5": 65, "pointvalue6": 56, "pointvalue7": 72, "pointvalue8": 95, "pointvalue9": 69, "pointvalue10": 50, "symbolSortKey": 1}, {"id": 2, "symbolKey": "2,", "device_name": "TEST_2", "pointvalue1": 2, "pointvalue2": 3, "pointvalue3": 93, "pointvalue4": 89, "pointvalue5": 65, "pointvalue6": 46, "pointvalue7": 27, "pointvalue8": 75, "pointvalue9": 14, "pointvalue10": 14, "symbolSortKey": 2}, {"id": 3, "symbolKey": "3,", "device_name": "TEST_3", "pointvalue1": 3, "pointvalue2": 1, "pointvalue3": 48, "pointvalue4": 79, "pointvalue5": 60, "pointvalue6": 53, "pointvalue7": 75, "pointvalue8": 27, "pointvalue9": 79, "pointvalue10": 36, "symbolSortKey": 3}, {"id": 4, "symbolKey": "4,", "device_name": "TEST_4", "pointvalue1": 4, "pointvalue2": 1, "pointvalue3": 74, "pointvalue4": 31, "pointvalue5": 14, "pointvalue6": 54, "pointvalue7": 38, "pointvalue8": 17, "pointvalue9": 54, "pointvalue10": 26, "symbolSortKey": 4}, {"id": 5, "symbolKey": "5,", "device_name": "TEST_5", "pointvalue1": 5, "pointvalue2": 4, "pointvalue3": 62, "pointvalue4": 69, "pointvalue5": 56, "pointvalue6": 63, "pointvalue7": 50, "pointvalue8": 47, "pointvalue9": 78, "pointvalue10": 57, "symbolSortKey": 5}, {"id": 6, "symbolKey": "6,", "device_name": "TEST_6", "pointvalue1": 6, "pointvalue2": 3, "pointvalue3": 21, "pointvalue4": 66, "pointvalue5": 76, "pointvalue6": 82, "pointvalue7": 81, "pointvalue8": 62, "pointvalue9": 54, "pointvalue10": 74, "symbolSortKey": 6}, {"id": 7, "symbolKey": "7,", "device_name": "TEST_7", "pointvalue1": 7, "pointvalue2": 1, "pointvalue3": 42, "pointvalue4": 52, "pointvalue5": 33, "pointvalue6": 92, "pointvalue7": 81, "pointvalue8": 29, "pointvalue9": 71, "pointvalue10": 78, "symbolSortKey": 7}, {"id": 8, "symbolKey": "8,", "device_name": "TEST_8", "pointvalue1": 8, "pointvalue2": 7, "pointvalue3": 47, "pointvalue4": 85, "pointvalue5": 97, "pointvalue6": 40, "pointvalue7": 78, "pointvalue8": 79, "pointvalue9": 63, "pointvalue10": 68, "symbolSortKey": 8}, {"id": 9, "symbolKey": "9,", "device_name": "TEST_9", "pointvalue1": 9, "pointvalue2": 4, "pointvalue3": 38, "pointvalue4": 27, "pointvalue5": 13, "pointvalue6": 63, "pointvalue7": 87, "pointvalue8": 57, "pointvalue9": 11, "pointvalue10": 57, "symbolSortKey": 9}], "sqlOutputData": [], "tableSelection": [{"name": "id", "type": "int", "comment": ""}, {"name": "device_name", "type": "varchar(50)", "comment": ""}, {"name": "pointvalue1", "type": "int", "comment": ""}, {"name": "pointvalue10", "type": "int", "comment": ""}, {"name": "pointvalue2", "type": "int", "comment": ""}, {"name": "pointvalue3", "type": "int", "comment": ""}, {"name": "pointvalue4", "type": "int", "comment": ""}, {"name": "pointvalue5", "type": "int", "comment": ""}, {"name": "pointvalue6", "type": "int", "comment": ""}, {"name": "pointvalue7", "type": "int", "comment": ""}, {"name": "pointvalue8", "type": "int", "comment": ""}, {"name": "pointvalue9", "type": "int", "comment": ""}], "curDatabaseConnect": {"sql": "", "code": "mysql_03121108", "host": "100.0.0.6", "port": "3306", "retry": "", "dbname": "", "dbpath": "", "s_node": "", "password": "123456", "username": "root", "namespace": "", "tablename": "", "schemaname": "", "connectname": "pg6", "databasetype": "MySQL"}, "selectedModuleName": "", "databaseConnectname": "mysql_03121108", "selectedDataBaseName": "fanfan", "selectedDataBaseTableName": "devicecount100"}, "label": "关系数据库输入", "ports": [{"id": "f93e4e86-e43e-4e28-abe7-759e992b64b0", "group": "input"}], "value": "DataBase", "status": "success", "cateKey": "input_c_key", "message": "配置完毕", "isConfig": true, "nodeData": "", "nodeMark": "database", "nodeType": "input", "resultKey": "database", "outputdata": {"fields": [{"name": "id", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "device_name", "type": "String", "comment": "", "sourceType": "varchar(50)"}, {"name": "pointvalue1", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "pointvalue10", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "pointvalue2", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "pointvalue3", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "pointvalue4", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "pointvalue5", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "pointvalue6", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "pointvalue7", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "pointvalue8", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "pointvalue9", "type": "Number", "comment": "", "sourceType": "int"}], "dataType": "array", "outputKey": "database"}, "noConfigMsg": "请配置数据库信息", "flowNodeType": "input"}, {"x": 722, "y": 215, "id": "wLrMDNmRoldd6QfDbm_Av", "img": "info-model", "attrs": {"host": "", "path": "/hsm-io-it/batch/getData", "port": "", "address": "http://100.0.0.141:6543/api/graphql/model"}, "label": "信息模型输出", "ports": [{"id": "3691b549-6e89-412b-b996-b2da877c4e97", "group": "output"}], "value": "InfoModel", "status": "success", "cateKey": "output_c_key", "message": "配置完毕", "isConfig": true, "nodeData": "", "nodeMark": "info-model", "nodeType": "output", "inputdata": {"fields": [{"name": "id", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "device_name", "type": "String", "comment": "", "sourceType": "varchar(50)"}, {"name": "pointvalue1", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "pointvalue10", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "pointvalue2", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "pointvalue3", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "pointvalue4", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "pointvalue5", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "pointvalue6", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "pointvalue7", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "pointvalue8", "type": "Number", "comment": "", "sourceType": "int"}, {"name": "pointvalue9", "type": "Number", "comment": "", "sourceType": "int"}], "dataType": "array", "outputKey": "database"}, "resultKey": "infomodel", "outputdata": {"fields": [], "dataType": "object", "outputKey": "infomodel"}, "noConfigMsg": "请配置信息模型的信息", "flowNodeType": "output"}]}', 'timing', 'cate_r37760oz', '', 'job_h2vr7fb0', 1, '2024-11-14 13:42:27+08', '2024-11-14 15:40:49+08', 'admin', 't', '{"type": "", "endDate": "", "endType": "endless", "dayOfWeek": "", "dayOfMonth": "", "executeMonth": "", "effectiveDate": "2024-11-14 13:42:44"}', '{"times": 1, "endDate": "endless", "endType": "endless", "effectiveDate": "2024-11-14 13:42:44", "schedule_unit": "second", "schedule_cycle": 60}');
INSERT INTO "ioit"."job_info" VALUES ('hsm_io_it', 's1', 'job_f8ie1aei', '新建作业1', '', '2', '@every 30s', '30', 'second', '{"benthos_yaml": "", "canvas_param": null, "node_data_map": null, "node_yaml_map": null, "benthos_componnet": null}', '', 'f', '{}', 'timing', 'cate_rootroot', '', 'job_f8ie1aei', 0, '2024-09-04 14:40:23+08', '2024-11-14 16:35:31+08', 'admin', 'f', '{"type": "", "endDate": "", "endType": "", "dayOfWeek": "", "dayOfMonth": "", "executeMonth": "", "effectiveDate": "2024-09-04 14:40:23"}', '{"times": 0, "endDate": "", "endType": "endless", "effectiveDate": "", "schedule_unit": "second", "schedule_cycle": 30}');
INSERT INTO "ioit"."job_info" VALUES ('1160320035634e2a9de37e8c11e7343f', 'e1', 'job_vz2eq0re', '新建作业111', '', '2', '@every 60s', '60', 'second', '{"benthos_yaml": "", "canvas_param": null, "node_data_map": null, "node_yaml_map": null, "benthos_componnet": null}', '', 'f', '{}', 'timing', '', '', 'job_vz2eq0re', 0, '2024-11-14 16:16:52+08', '2024-11-14 16:23:38+08', 'admin', 't', '{"type": "", "endDate": "", "endType": "", "dayOfWeek": "", "dayOfMonth": "", "executeMonth": "", "effectiveDate": "2024-11-14 16:16:52"}', '{"times": 0, "endDate": "", "endType": "endless", "effectiveDate": "2024-11-14 16:16:52", "schedule_unit": "second", "schedule_cycle": 60}');
INSERT INTO "ioit"."job_info" VALUES ('hsm_io_it', 's1', 'job_eeu4x0il', '新建作业', '', '2', '@every 30s', '30', 'second', '{"benthos_yaml": "", "canvas_param": null, "node_data_map": null, "node_yaml_map": null, "benthos_componnet": null}', '', 'f', '{}', 'timing', 'cate_rootroot', '', 'job_eeu4x0il', 0, '2024-09-04 14:40:21+08', '2024-11-14 16:35:31+08', 'admin', 'f', '{"type": "", "endDate": "", "endType": "", "dayOfWeek": "", "dayOfMonth": "", "executeMonth": "", "effectiveDate": "2024-09-04 14:40:21"}', '{"times": 0, "endDate": "", "endType": "endless", "effectiveDate": "", "schedule_unit": "second", "schedule_cycle": 30}');
INSERT INTO "ioit"."job_info" VALUES ('hsm_io_it', 'e1', 'job_y1e82zpt', 'asdaa', '', '2', '@every 60s', '60', 'second', '{"benthos_yaml": "", "canvas_param": null, "node_data_map": null, "node_yaml_map": null, "benthos_componnet": null}', '', 'f', '{}', 'timing', 'cate_rootroot', '', 'job_y1e82zpt', 0, '2024-11-14 16:55:40+08', '2024-11-14 16:55:40+08', 'admin', 't', '{"type": "", "endDate": "", "endType": "endless", "dayOfWeek": "", "dayOfMonth": "", "executeMonth": "", "effectiveDate": "2024-11-14 16:56:00"}', '{"times": 1, "endDate": "endless", "endType": "endless", "effectiveDate": "2024-11-14 16:56:00", "schedule_unit": "second", "schedule_cycle": 60}');
-- ----------------------------
-- Table structure for job_nodes
-- ----------------------------
DROP TABLE IF EXISTS "ioit"."job_nodes";
CREATE TABLE "ioit"."job_nodes" (
"namespace" varchar(255) COLLATE "pg_catalog"."default",
"startnode" varchar(255) COLLATE "pg_catalog"."default",
"code" varchar(255) COLLATE "pg_catalog"."default",
"stopnode" varchar(255) COLLATE "pg_catalog"."default"
)
;
-- ----------------------------
-- Records of job_nodes
-- ----------------------------
-- ----------------------------
-- Primary Key structure for table business_data
-- ----------------------------
ALTER TABLE "ioit"."business_data" ADD CONSTRAINT "business_data_pkey" PRIMARY KEY ("id");
-- ----------------------------
-- Primary Key structure for table component_cata
-- ----------------------------
ALTER TABLE "ioit"."component_cata" ADD CONSTRAINT "component_cata_pkey" PRIMARY KEY ("id");
-- ----------------------------
-- Indexes structure for table job_info
-- ----------------------------
CREATE INDEX "idx_namespace" ON "ioit"."job_info" USING btree (
"namespace" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);