INSERT INTO blade_menu(id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1566738898702618625, 0, 'cnc', '刀具管理', 'app', '/cnc', 'iconfont saber-daojuguanli', 10, 0, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu(id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1566739257311416322, 1566738898702618625, 'cnc_monitoring', '刀具监控', 'cnc_monitoring', '/cnc/cnc-monitoring', '', 2, 1, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu(id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1566739431463112705, 1566738898702618625, 'toolChange_record', '换刀记录', 'toolChange_record', '/cnc/toolChange-record', '', 3, 1, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu(id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1566739825134686210, 1566738898702618625, 'cnc_information', '刀具管理(信息)', 'cnc_information', '/cnc/info/index', '', 1, 1, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_tool_category (id, status, is_deleted, create_user, create_dept, create_time, update_user, update_time, tenant_id, parent_id, name, sort, tool_prefix_code, code_length) VALUES (1, 1, 0, NULL, NULL, TO_DATE('2022-09-05 09:37:52', 'yyyy-mm-dd hh24:mi:ss'), NULL, TO_DATE('2022-09-05 09:37:59', 'yyyy-mm-dd hh24:mi:ss'), '000000', 0, '所有的', 0, NULL, NULL); CREATE TABLE "BLADE_TOOL_PARAMETER" ( "ID" NUMBER(19, 0) NOT NULL, "STATUS" NUMBER(10, 0), "IS_DELETED" NUMBER(19, 0) DEFAULT 0, "CREATE_USER" NUMBER(19, 0), "CREATE_DEPT" NUMBER(19, 0), "CREATE_TIME" TIMESTAMP, "UPDATE_USER" NUMBER(19, 0), "UPDATE_TIME" TIMESTAMP, "TENANT_ID" NVARCHAR2(12) DEFAULT '000000', "TOOL_PARAMETER_NAME" NVARCHAR2(45), "TOOL_PARAMETER_UNIT" NVARCHAR2(45), "TOOL_PARAMETER_CODE" NVARCHAR2(45), "IS_UPDATE" NUMBER(3, 0) DEFAULT 0 ) LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; COMMENT ON COLUMN "BLADE_TOOL_PARAMETER"."ID" IS '主键'; COMMENT ON COLUMN "BLADE_TOOL_PARAMETER"."STATUS" IS '状态'; COMMENT ON COLUMN "BLADE_TOOL_PARAMETER"."IS_DELETED" IS '删除状态：0-未删除，1-已删除'; COMMENT ON COLUMN "BLADE_TOOL_PARAMETER"."CREATE_USER" IS '创建人'; COMMENT ON COLUMN "BLADE_TOOL_PARAMETER"."CREATE_DEPT" IS '创建部门'; COMMENT ON COLUMN "BLADE_TOOL_PARAMETER"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "BLADE_TOOL_PARAMETER"."UPDATE_USER" IS '更新人'; COMMENT ON COLUMN "BLADE_TOOL_PARAMETER"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "BLADE_TOOL_PARAMETER"."TENANT_ID" IS '租户ID'; COMMENT ON COLUMN "BLADE_TOOL_PARAMETER"."TOOL_PARAMETER_NAME" IS '参数名称'; COMMENT ON COLUMN "BLADE_TOOL_PARAMETER"."TOOL_PARAMETER_UNIT" IS '参数单位'; COMMENT ON COLUMN "BLADE_TOOL_PARAMETER"."TOOL_PARAMETER_CODE" IS '参数编号'; COMMENT ON COLUMN "BLADE_TOOL_PARAMETER"."IS_UPDATE" IS '是否更新 1-是 0-否'; COMMENT ON TABLE "BLADE_TOOL_PARAMETER" IS '刀具参数'; -- ---------------------------- -- Primary Key structure for table BLADE_TOOL_PARAMETER -- ---------------------------- ALTER TABLE "BLADE_TOOL_PARAMETER" ADD CONSTRAINT "SYS_C0049434" PRIMARY KEY ("ID"); CREATE TABLE "BLADE_TOOL_CHANGE_RECORD" ( "ID" NUMBER(20, 0) NOT NULL, "STATUS" NUMBER(4, 0), "IS_DELETED" NUMBER(4, 0), "CREATE_USER" NUMBER(20, 0), "CREATE_DEPT" NUMBER(20, 0), "CREATE_TIME" DATE, "UPDATE_USER" NUMBER(20, 0), "UPDATE_TIME" DATE, "TENANT_ID" NVARCHAR2(12), "TOOL_CODE" NVARCHAR2(45), "TOOL_CATEGORY_ID" NUMBER(20, 0), "TOOL_CATEGORY" NVARCHAR2(45), "TOOL_MODEL_ID" NUMBER(20, 0), "TOOL_MODEL" NVARCHAR2(45), "TOOL_PREFIX_CODE" NVARCHAR2(45), "LIFE_COUNT_METHOD" NUMBER(11, 0), "INITIAL_LIFE" NUMBER(11, 0), "USED_LIFE" NUMBER(11, 0), "REMAIN_LIFE" NUMBER(11, 0), "WARNING_VALUE" NUMBER(11, 0), "LIFE_STATE" NUMBER(11, 0), "USE_STATE" NUMBER(11, 0), "WORKSTATION_ID" NUMBER(20, 0), "WORKSTATION_CODE" NVARCHAR2(45), "WORKSTATION_NAME" NVARCHAR2(45), "TOOL_POSITION" NUMBER(11, 0), "OPERATION_TYPE" NUMBER(11, 0), "EMPLOYEE_ID" NUMBER(20, 0), "PARAMETER1" NVARCHAR2(45), "PARAMETER2" NVARCHAR2(45), "PARAMETER3" NVARCHAR2(45), "PARAMETER4" NVARCHAR2(45), "PARAMETER5" NVARCHAR2(45), "PARAMETER6" NVARCHAR2(45), "PARAMETER7" NVARCHAR2(45), "PARAMETER8" NVARCHAR2(45), "PARAMETER9" NVARCHAR2(45), "PARAMETER10" NVARCHAR2(45), "EMPLOYEE_NAME" NVARCHAR2(45) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."ID" IS '主键'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."STATUS" IS '状态'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."IS_DELETED" IS '删除状态：0-未删除，1-已删除'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."CREATE_USER" IS '创建人'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."CREATE_DEPT" IS '创建部门'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."UPDATE_USER" IS '更新人'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."TENANT_ID" IS '租户ID'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."TOOL_CODE" IS '刀具编号'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."TOOL_CATEGORY_ID" IS '刀具类型ID'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."TOOL_CATEGORY" IS '刀具类型'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."TOOL_MODEL_ID" IS '刀具型号ID'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."TOOL_MODEL" IS '刀具型号'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."TOOL_PREFIX_CODE" IS '刀具前缀编号'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."LIFE_COUNT_METHOD" IS '寿命计数方式(1.按次数 2.按时间)'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."INITIAL_LIFE" IS '初始寿命'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."USED_LIFE" IS '已用寿命'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."REMAIN_LIFE" IS '剩余寿命'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."WARNING_VALUE" IS '预警值'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."LIFE_STATE" IS '寿命状态(1.正常 2.警告 3.报警)'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."USE_STATE" IS '使用状态(1.已装刀 0.已卸刀)'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."WORKSTATION_ID" IS '工位ID'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."WORKSTATION_CODE" IS '工位编号'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."WORKSTATION_NAME" IS '工位名称'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."TOOL_POSITION" IS '机床刀位'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."OPERATION_TYPE" IS '操作类型(1.装刀 0.卸刀)'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."EMPLOYEE_ID" IS '操作人'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."PARAMETER1" IS '参数1'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."PARAMETER2" IS '参数2'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."PARAMETER3" IS '参数3'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."PARAMETER4" IS '参数4'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."PARAMETER5" IS '参数5'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."PARAMETER6" IS '参数6'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."PARAMETER7" IS '参数7'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."PARAMETER8" IS '参数8'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."PARAMETER9" IS '参数9'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."PARAMETER10" IS '参数10'; COMMENT ON COLUMN "BLADE_TOOL_CHANGE_RECORD"."EMPLOYEE_NAME" IS '操作人姓名'; COMMENT ON TABLE "BLADE_TOOL_CHANGE_RECORD" IS '刀具装卸记录'; -- ---------------------------- -- Primary Key structure for table BLADE_TOOL_CHANGE_RECORD -- ---------------------------- ALTER TABLE "BLADE_TOOL_CHANGE_RECORD" ADD CONSTRAINT "SYS_C0049435" PRIMARY KEY ("ID"); -- 菜单 INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1582192508220342274, 1566739825134686210, 'tool_category_add', '添加刀具类型', 'tool_category_add', '', '', 1, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1582195279531212801, 1566739825134686210, 'tool_category_rename', '刀具类型重命名', 'tool_category_rename', '', '', 2, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1582195569005297666, 1566739825134686210, 'tool_category_delete', '刀具类型删除', 'tool_category_delete', '', '', 3, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1582196133717999617, 1566739825134686210, 'tool_model_add', '新建刀具型号', 'tool_model_add', '', '', 4, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1582196444398485505, 1566739825134686210, 'tool_model_update', '刀具型号编辑', 'tool_model_update', '', '', 5, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1582196610295791617, 1566739825134686210, 'tool_model_delete', '刀具型号删除', 'tool_model_delete', '', '', 6, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1582197672343896066, 1566739825134686210, 'tool_parameter_add', '新建刀具参数', 'tool_parameter_add', '', '', 7, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1582197812228128770, 1566739825134686210, 'tool_parameter_update', '刀具参数编辑', 'tool_parameter_add', '', '', 8, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1582199434790436865, 1566739825134686210, 'tool_paramater_delete', '刀具参数删除', 'tool_paramater_delete', '', '', 9, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1582201677455425538, 1566739257311416322, 'tool_add', '新建刀具', 'tool_add', '', '', 1, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1582201746988597249, 1566739257311416322, 'tool_update', '编辑刀具', 'tool_update', '', '', 2, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1582201887124488193, 1566739257311416322, 'tool_delete', '删除刀具', 'tool_delete', '', '', 3, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1582202039482580993, 1566739257311416322, 'tool_reset', '重置刀具', 'tool_reset', '', '', 4, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1582202176644710401, 1566739257311416322, 'tool_export', '导出刀具', 'tool_export', '', '', 5, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1582202513631870978, 1566739257311416322, 'tool_equipment', '装刀', 'tool_equipment', '', '', 6, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1582202833040703489, 1566739257311416322, 'tool_discharge', '卸刀', 'tool_discharge', '', '', 7, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark, is_deleted, belong_application, keep_alive) VALUES (1582255045074878466, 1566739431463112705, 'tool_change_record_export', '导出换刀记录', 'tool_change_record_export', '', '', 1, 2, 0, 1, '', 0, 'CPS', 1); -- 数据权限 INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1580129128526970881, 1566739257311416322, 'tool_manage.page', '刀具分页', '/blade-tool/tool-manage/page', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-12 17:31:56', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-12 17:31:56', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1580129191890321409, 1566739257311416322, 'tool_parameter.list', '刀具参数列表', '/blade-tool/tool-parameter/list', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-12 17:32:11', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-12 17:32:11', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1580129266192416769, 1566739257311416322, 'tool_model.page', '刀具型号分页', '/blade-tool/tool-model/page', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-12 17:32:29', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-12 17:32:29', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1580129724714364929, 1566739257311416322, 'tool_category.list', '刀具类型列表', '/blade-tool/tool-category/list', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-12 17:34:18', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-12 17:34:18', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1580130194300252161, 1580126861992198146, 'tool_manage.tree', '树形结构', '/blade-tool/tool-manage/tree', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-12 17:36:10', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-12 17:36:10', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1580132130437115906, 1580128063991644162, 'tool_manage.tree', '树形结构', '/blade-tool/tool-manage/tree', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-12 17:43:52', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-12 17:43:52', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1580132511342833666, 1566739431463112705, 'tool_parameter.list', '刀具参数列表', '/blade-tool/tool-parameter/list', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-12 17:45:23', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-12 17:45:23', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1580132553210376193, 1566739431463112705, 'tool_category.list', '刀具类型列表', '/blade-tool/tool-category/list', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-12 17:45:33', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-12 17:45:33', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1580132604552851458, 1566739431463112705, 'tool_change_record.page', '刀具装卸记录分页', '/blade-tool/tool-change-record/page', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-12 17:45:45', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-12 17:45:45', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1580358114184704002, 1566739825134686210, 'tool_model.detail', '刀具型号详情', '/blade-tool/tool-model/get/*', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-13 08:41:51', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-13 08:41:51', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1580358114193092610, 1566739825134686210, 'tool_model.page', '刀具型号分页', '/blade-tool/tool-model/page', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-13 08:41:51', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-13 08:41:51', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1580358161542590465, 1566739825134686210, 'tool_category.list', '刀具类型列表', '/blade-tool/tool-category/list', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-13 08:42:02', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-13 08:42:02', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1580358161542590466, 1566739825134686210, 'tool_category.tree', '刀具类型树', '/blade-tool/tool-category/tree', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-13 08:42:02', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-13 08:42:02', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1580360346980495361, 1566739825134686210, 'tool_parameter.detail', '刀具参数详情', '/blade-tool/tool-parameter/get/*', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-13 08:50:43', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-13 08:50:43', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1580360346984689665, 1566739825134686210, 'tool_parameter.list', '刀具参数列表', '/blade-tool/tool-parameter/list', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-13 08:50:43', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-13 08:50:43', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1582258691636330497, 1582192508220342274, 'tool_category.insert', '刀具类型新增', '/blade-tool/tool-category/insert', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-18 14:34:04', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-18 14:34:04', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1582258732514017281, 1582195279531212801, 'tool_category.update_name', '刀具类型重命名', '/blade-tool/tool-category/updateName', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-18 14:34:13', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-18 14:34:13', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1582258752042696705, 1582195569005297666, 'tool_category.remove', '刀具类型删除', '/blade-tool/tool-category/remove', NULL, NULL, 'DELETE', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-18 14:34:18', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-18 14:34:18', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1582258810570014722, 1582196133717999617, 'tool_model.save', '刀具型号新增', '/blade-tool/tool-model/insert', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-18 14:34:32', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-18 14:34:32', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1582258861472088066, 1582196444398485505, 'tool_model.update', '刀具型号修改', '/blade-tool/tool-model/update', NULL, NULL, 'PUT', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-18 14:34:44', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-18 14:34:44', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1582258902672736257, 1582196610295791617, 'tool_model.remove', '刀具型号删除', '/blade-tool/tool-model/remove', NULL, NULL, 'DELETE', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-18 14:34:54', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-18 14:34:54', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1582258964895236097, 1582197672343896066, 'tool_parameter.save', '刀具参数新增或者编辑', '/blade-tool/tool-parameter/save', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-18 14:35:09', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-18 14:35:09', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1582258984386166786, 1582197812228128770, 'tool_parameter.save', '刀具参数新增或者编辑', '/blade-tool/tool-parameter/save', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-18 14:35:13', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-18 14:35:13', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1582259013062623233, 1582199434790436865, 'tool_parameter.remove', '刀具参数删除', '/blade-tool/tool-parameter/remove', NULL, NULL, 'DELETE', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-18 14:35:20', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-18 14:35:20', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1582259093454848002, 1582201677455425538, 'tool_manage.insert', '刀具新增', '/blade-tool/tool-manage/save', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-18 14:35:39', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-18 14:35:39', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1582259150363164673, 1582201746988597249, 'tool_manage.update', '刀具修改', '/blade-tool/tool-manage/update', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-18 14:35:53', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-18 14:35:53', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1582259185838587905, 1582201887124488193, 'tool_manage.remove', '刀具删除', '/blade-tool/tool-manage/remove', NULL, NULL, 'DELETE', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-18 14:36:02', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-18 14:36:02', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1582259204918476801, 1582202039482580993, 'tool_manage.reset_tool', '刀具重置', '/blade-tool/tool-manage/reset', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-18 14:36:06', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-18 14:36:06', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1582259248493101058, 1582202176644710401, 'tool_manage.export_process_param', '导出刀具监控表', '/blade-tool/tool-manage/excel/export', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-18 14:36:16', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-18 14:36:16', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1582259268353130498, 1582202513631870978, 'tool_manage.equipment_tool', '刀具装刀', '/blade-tool/tool-manage/equipment', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-18 14:36:21', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-18 14:36:21', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1582259302717063169, 1582202833040703489, 'tool_manage.discharge_tool', '刀具卸刀', '/blade-tool/tool-manage/discharge', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-18 14:36:29', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-18 14:36:29', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1582259338951655425, 1566739257311416322, 'tool_manage.is_exist_code_rule', '编码规则是否存在', '/blade-tool/tool-manage/is-exist-code-rule', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-18 14:36:38', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-18 14:36:38', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0); INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (1582259394467463170, 1582255045074878466, 'tool_change_record.export_process_param', '导出装卸刀记录表', '/blade-tool/tool-change-record/excel/export', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, TO_DATE('2022-10-18 14:36:51', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201, TO_DATE('2022-10-18 14:36:51', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0);