-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathioit.sql
222 lines (222 loc) · 73.1 KB
/
ioit.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
CREATE TABLE IF NOT EXISTS "ioit"."business_data" (
"id" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
"data" text COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "ioit"."business_data" OWNER TO "postgres";
BEGIN;
INSERT INTO "ioit"."business_data" ("id", "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" ("id", "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" ("id", "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" ("id", "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" ("id", "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" ("id", "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" ("id", "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" ("id", "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" ("id", "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" ("id", "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" ("id", "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" ("id", "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" ("id", "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" ("id", "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" ("id", "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" ("id", "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" ("id", "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" ("id", "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}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('hJhXNfX416Aly98Ww0kf4', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/u8/saveU8TaskCenter","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('B1huJh-BX1XEBa9y_kfJT', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getU8TaskCenter","port":"20970","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('SHcDQGp4ZPUCHd8XJDrYQ', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getU8Department","port":"20971","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('Rs81ZfTAHJFecJwXO19rs', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getU8Supplier","port":"20972","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('B7PXGwk0U5K3WWldJShcn', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getU8Unit","port":"20973","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('VG1SbBVeCEkJNLP6MwfsM', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getU8CustomerData","port":"20974","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('TKWAdq4qOfYFsixs7a3SB', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getU8Person","port":"20975","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('o1N7vjUfvOjG6IUy9qZAP', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getU8ProductionOrder","port":"20976","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('pUdFrhCLW-t98we2NmWZ0', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/u8/saveU8Department","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('wUCYXvn1yujE4Zs5SXkgT', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/u8/saveU8Supplier","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('eOv6eA8w8QSuJNoXytarM', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/u8/saveU8Unit","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('TXaa7APk8cyQd5VQ-1YPo', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/u8/saveU8CustomerData","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('SXRGsONlYXn6VEmx0tJq_', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/u8/saveU8Person","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('SZzQFFiUi_LRWevuk0x_H', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/u8/saveU8ProductionOrder","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('10s3zec8XFEyZTecX89iD', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getU8Material","port":"20977","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('ZRBDxNctIfoGDLvPFOLCL', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/u8/saveU8Material","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('72j7uqfh71Rex7w_JgftS', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getU8MaterialBOM","port":"20978","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('nz_cuy1Av9fkIlMGsZ4aK', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/u8/saveU8MaterialBOM","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('w2BfGWT24OWuBLu_nupDf', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getU8ProductIn","port":"20979","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('1_lA5YKu8sl0OKR5zy96F', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/u8/saveU8ProductIn","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('4zKKJ8dux8lHGN9j9DoOS', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getKingdeeDepartment","port":"20980","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('oyWjfq2t1FeInOKJVSzi7', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/kingdee/saveKingdeeDepartment","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('gU4H3W1wODOwNNmJkqt3w', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getKingdeeWorkCenter","port":"20981","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('mbWhVx9qHbJQCnzWaSNdB', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/kingdee/saveKingdeeWorkCenter","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('z1-C0Cfu8j8qVdxuNyZcu', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getKingdeeSupplier","port":"20982","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('Wxhq8ecT9Mz5tMC7_Ir7k', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/kingdee/saveKingdeeSupplier","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('UBOHL94rTQILvs3hgk3RZ', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getKingdeePlanOrder","port":"20983","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('r6dz2ZSI0y3FIS5nHvOZz', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/kingdee/saveKingdeePlanOrder","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('apb5yM7nBDXszVbBZYP36', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getKingdeeUnit","port":"20984","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('QVdmFJtOetQoy2PVp8Q3p', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/kingdee/saveKingdeeUnit","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('oi0IoMarxDvjkEvOFzbvL', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getKingdeeCustomer","port":"20985","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('D6rkDefvhWosFCtatdqbW', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/kingdee/saveKingdeeCustomer","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('K4SjakUNqxw7KMNM7vAl_', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getKingdeeProductionOrder","port":"20986","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('TeUmhSR-oJ1moipTKWNcK', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/kingdee/saveKingdeeProductionOrder","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('ZZ_V12tZCMdvNz5b6HCJE', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getKingdeeMaterial","port":"20987","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('RM1ALzXvMy05tA1-Tiyud', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/kingdee/saveKingdeeMaterial","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('JjX_Sl5YtiWnzo7-g89kd', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getKingdeeBOM","port":"20988","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('tJGbed0PFDx9oFOqAczmy', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/kingdee/saveKingdeeBOM","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('rSfILf7n4piVe7xzuD5Xt', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getKingdeeEmployee","port":"20989","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('RoPcBNxSXBmdKfyeTnYwd', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/kingdee/saveKingdeeEmployee","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('DjpMeX4UbkqhfZzls2cU1', '{"apiInputType":"server","argPath":"","base64decode":false,"host":"172.21.44.157","isXML":false,"method":"POST","path":"/getKingdeeProductIn","port":"20990","responseBody":"{\"data\":true,\"code\":0,\"success\":true}","toJSON":false}');
INSERT INTO "ioit"."business_data" ("id", "data") VALUES ('SnV44O1ef8iPVd4QJEaNy', '{"method":"POST","url":"e1.local:6120/api/hsm-io-it/kingdee/saveKingdeeProductIn","tabList":{"authInfo":{"authType":"none","authorization":"","password":"","token":"","username":""},"params":[],"requestBody":"","requestHeaders":[{"key":"Content-Type","value":"application/json"}]},"apiInputType":"http"}');
COMMIT;
CREATE TABLE IF NOT EXISTS "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",
"api_type" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "ioit"."component" OWNER TO "postgres";
COMMENT ON COLUMN "ioit"."component"."applicable_type" IS '用于区分组件适用类型
all表示不区分场景
client表示客户端
server表示服务';
BEGIN;
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友计量单位', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"B7PXGwk0U5K3WWldJShcn"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友客户', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"VG1SbBVeCEkJNLP6MwfsM"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友计量单位同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"eOv6eA8w8QSuJNoXytarM"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友人员', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"TKWAdq4qOfYFsixs7a3SB"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友生产订单', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"o1N7vjUfvOjG6IUy9qZAP"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友物料', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"10s3zec8XFEyZTecX89iD"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友Bom', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"72j7uqfh71Rex7w_JgftS"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友产成品', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"w2BfGWT24OWuBLu_nupDf"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友客户同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"TXaa7APk8cyQd5VQ-1YPo"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友人员同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"SXRGsONlYXn6VEmx0tJq_"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友生产订单同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"SZzQFFiUi_LRWevuk0x_H"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友物料同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"ZRBDxNctIfoGDLvPFOLCL"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友Bom同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"nz_cuy1Av9fkIlMGsZ4aK"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友产成品同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"1_lA5YKu8sl0OKR5zy96F"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空部门', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"4zKKJ8dux8lHGN9j9DoOS"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空工作中心', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"gU4H3W1wODOwNNmJkqt3w"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空供应商', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"z1-C0Cfu8j8qVdxuNyZcu"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空计划订单', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"UBOHL94rTQILvs3hgk3RZ"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空计量单位', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"apb5yM7nBDXszVbBZYP36"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空客户', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"oi0IoMarxDvjkEvOFzbvL"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空生产订单', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"K4SjakUNqxw7KMNM7vAl_"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空物料', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"ZZ_V12tZCMdvNz5b6HCJE"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空部门同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"oyWjfq2t1FeInOKJVSzi7"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空工作中心同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"mbWhVx9qHbJQCnzWaSNdB"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空供应商同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"Wxhq8ecT9Mz5tMC7_Ir7k"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空计划订单同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"r6dz2ZSI0y3FIS5nHvOZz"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空计量单位同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"QVdmFJtOetQoy2PVp8Q3p"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空客户同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"D6rkDefvhWosFCtatdqbW"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空生产订单同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"TeUmhSR-oJ1moipTKWNcK"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('API', 'Api', 'input', 'API', 'http-client', '请配置API输入', '', 'input_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空Bom', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"JjX_Sl5YtiWnzo7-g89kd"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空员工', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"rSfILf7n4piVe7xzuD5Xt"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空生产入库', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"DjpMeX4UbkqhfZzls2cU1"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空物料同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"RM1ALzXvMy05tA1-Tiyud"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空Bom同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"tJGbed0PFDx9oFOqAczmy"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空员工同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"RoPcBNxSXBmdKfyeTnYwd"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('金蝶云星空生产入库同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"SnV44O1ef8iPVd4QJEaNy"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") 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" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('SAP生产订单', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP生产订单的信息', '{"type":"SAP_MES_ProductOrder","modular_package":true}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") 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" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('SAP产品工序', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP产品工序的信息', '{"type":"SAP_MES_ProductProcess","modular_package":true}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('SAP物料', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP物料的信息', '{"type": "SAP_MES_Material","modular_package": true}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('SAP物料同步MES', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP物料同步MES的信息', '{"type": "SAP_MES_Material"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") 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" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('SAP产品BOM同步MES', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP产品BOM同步MES的信息', '{"type": "SAP_MES_ProductBOM"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('HiaBatch转信息模型', 'HiaBatchToInfoModel', 'transform', 'HiaBatch-to-infoModel', 'filedata-convert', '请配置HiaBatch转信息模型', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") 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" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") 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" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") 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" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('SAP订单产品SN同步MES', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP订单产品SN同步MES的信息', '{"type": "SAP_MES_AsyncOrdersn"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('DB表', 'DataBase', 'input', 'database', 'database', '请配置数据库信息', '', 'input_c_key', 'client', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('电子工厂MySQL', 'MySQL', 'input', 'mysql', 'mysql', '请配置MySQL数据库信息', '', 'input_c_key', 'client', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('API', 'Api', 'output', 'API', 'http-client', '请配置API输出', '', 'output_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('信息模型', 'InfoModel', 'output', 'info-model', 'info-model', '请配置信息模型的信息', '', 'output_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('关系数据库', 'DataBase', 'output', 'database', 'database', '请配置数据库信息', '', 'output_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('字段排序', 'FieldSort', 'transform', 'field-sort', 'field-sort', '请配置字段排序', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('字段选择', 'FieldSelect', 'transform', 'field-select', 'field-select', '请配置字段选择', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('字段映射', 'FieldMapping', 'transform', 'field-mapping', 'data-mapping', '请配置字段映射', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('数据加解密', 'DataEnOrDecryption', 'transform', 'data-enordecryption', 'data-enordecryption', '', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('类型转换', 'TypeConvert', 'transform', 'type-convert', 'type-convert', '', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('记录集连接', 'RecordesetLink', 'transform', 'recordeset-link', 'recordeset-link', '', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('数据映射', 'DataMapping', 'transform', 'mapping', 'mapping', '', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('新增计算列', 'DataComputed', 'transform', 'data-computed', 'data-computed', '', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('XML解析', 'XMLToJSON', 'transform', 'xml-json', 'xml-json', '', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('数据过滤', 'DataFilter', 'transform', 'data-filter', 'data-filter', '', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('映射结构输出', 'MappingOutput', 'transform', 'mapping-output', 'mapping-output', '请配置映射结构输出', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('映射关系', 'MappingRelation', 'transform', 'mapping-relation', 'mapping-relation', '请配置映射关系', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('数据校验', 'DataValidate', 'transform', 'data-validate', 'data-validate', '请配置数据校验', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('文件系统', 'File', 'input', 'file', 'file', '请配置文件信息', '', 'input_c_key', 'client', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('SAP产品工艺路线', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP产品工艺路线的信息', '{"type":"SAP_MES_ProcessLine","modular_package":true}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") 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" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('MES生产订单报工', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置SAP生产订单报工的信息', '{"type":"MES_SAP_ReportWork","modular_package":true}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") 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" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('MES生产订单状态', 'FieldMapping', 'transform', 'field-mapping', 'sap', '请配置MES生产订单状态的信息', '{"type":"MES_SAP_OrderStatus","modular_package":true}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('流程接口', 'ProcessInterface', 'output', 'process-interface', 'process-interface', '请配置流程接口的信息', '', 'output_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") 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" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('字段哈希', 'FieldHash', 'transform', 'field-hash', 'field-hash', '请配置字段哈希', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('数据同步', 'DataAsync', 'transform', 'data-async', 'field-select', '请配置数据同步', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('字段拆列', 'FieldSplit', 'transform', 'field-split', 'field-split', '', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('JSON解析', 'JSONStructrueSelect', 'transform', 'json-structrue', 'json-structrue', '', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('文件数据转换', 'FileDataConvert', 'transform', 'file-data-convert', 'filedata-convert', '请配置数据转换', '', 'transform_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('DB表', 'DBTable', 'output', 'db-table', 'database', '请配置数据库信息', '', 'output_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友工作中心同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"hJhXNfX416Aly98Ww0kf4"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友部门同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"pUdFrhCLW-t98we2NmWZ0"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友供应商同步', 'Api', 'output', 'API', 'http-client', '请配置API输出', '{"type":"wUCYXvn1yujE4Zs5SXkgT"}', 'business_c_key', 'all', '');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友工作中心', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"B1huJh-BX1XEBa9y_kfJT"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友部门', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"SHcDQGp4ZPUCHd8XJDrYQ"}', 'business_c_key', 'all', 'server');
INSERT INTO "ioit"."component" ("label", "value", "node_type", "node_mark", "img", "no_config_msg", "node_data", "cate_key", "applicable_type", "api_type") VALUES ('用友供应商', 'Api', 'input', 'API', 'http-client', '请配置API输入', '{"type":"Rs81ZfTAHJFecJwXO19rs"}', 'business_c_key', 'all', 'server');
COMMIT;
CREATE TABLE IF NOT EXISTS "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
)
;
ALTER TABLE "ioit"."component_cata" OWNER TO "postgres";
BEGIN;
INSERT INTO "ioit"."component_cata" ("label", "value", "id") VALUES ('输入组件', 'input', 'input_c_key');
INSERT INTO "ioit"."component_cata" ("label", "value", "id") VALUES ('转换组件', 'transform', 'transform_c_key');
INSERT INTO "ioit"."component_cata" ("label", "value", "id") VALUES ('输出组件', 'output', 'output_c_key');
INSERT INTO "ioit"."component_cata" ("label", "value", "id") VALUES ('业务组件', 'business', 'business_c_key');
COMMIT;
CREATE TABLE IF NOT EXISTS "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",
"retry" varchar(10) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "ioit"."database_info" OWNER TO "postgres";
CREATE TABLE IF NOT EXISTS "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"
)
;
ALTER TABLE "ioit"."job_cata" OWNER TO "postgres";
BEGIN;
INSERT INTO "ioit"."job_cata" ("cl_code", "cg_name", "cg_parent", "namespace", "s_node", "cg_describe") VALUES ('cate_rootroot', '默认作业分类', '', 'hsm_io_it', '', '默认作业分类');
COMMIT;
ALTER TABLE "ioit"."business_data" ADD CONSTRAINT "business_data_pkey" PRIMARY KEY ("id");
ALTER TABLE "ioit"."component_cata" ADD CONSTRAINT "component_cata_pkey" PRIMARY KEY ("id");