DROP TABLE IF EXISTS `blade_device_type`; CREATE TABLE `blade_device_type` ( `id` bigint(0) NOT NULL COMMENT '主键', `status` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) NULL DEFAULT NULL, `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型编码（唯一）', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型名称', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uniqueCodeIndex` (`code`, `is_deleted`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '机器类型' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_employee`; CREATE TABLE `blade_employee` ( `id` bigint(0) NOT NULL, `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户ID', `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '员工编号', `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名', `email` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱', `tel` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电话', `hire_date` datetime(0) NULL DEFAULT NULL COMMENT '入职日期', `job_number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工卡号', `pin_code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'PIN码', `organization_id` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组织ID', `dept_id` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据权限', `post_id` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '岗位ID', `user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '账号ID', `role_id` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色ID', `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建单位', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `status` int(0) NULL DEFAULT NULL COMMENT '数据状态', `is_deleted` int(0) NULL DEFAULT NULL, `avatar` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '员工头像', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '员工' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_employee_post`; CREATE TABLE `blade_employee_post` ( `id` bigint(0) NOT NULL COMMENT '主键', `employee_id` bigint(0) NULL DEFAULT 0 COMMENT '员工ID', `post_id` bigint(0) NULL DEFAULT 0 COMMENT '岗位ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '员工岗位表' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_maintain_item`; CREATE TABLE `blade_maintain_item` ( `id` bigint(0) NOT NULL COMMENT '主键', `status` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) NULL DEFAULT NULL, `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '保养编码', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '保养项', `requirement` varchar(350) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '保养要求', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uniqueCodeIndex` (`code`, `is_deleted`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '保养项信息' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_maintain_project`; CREATE TABLE `blade_maintain_project` ( `id` bigint(0) NOT NULL COMMENT '主键', `status` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) NULL DEFAULT NULL, `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `device_type_id` bigint(0) NULL DEFAULT NULL COMMENT '机器类型Id', `device_type_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '机器类型名称', `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '保养项目编码', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '保养项目名称', `interval_time` int(0) NULL DEFAULT NULL COMMENT '周期（天）', `pre_warning_days` int(0) NULL DEFAULT NULL COMMENT '保养预警提示（天）', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uniqueCodeIndex` (`code`, `is_deleted`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '保养项目' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_maintain_project_item`; CREATE TABLE `blade_maintain_project_item` ( `id` bigint(0) NOT NULL COMMENT '主键', `status` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) NULL DEFAULT NULL, `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `project_id` bigint(0) NULL DEFAULT NULL COMMENT '保养项目Id', `item_id` bigint(0) NULL DEFAULT NULL COMMENT '保养项Id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '保养项目保养项' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_malfunction_type`; CREATE TABLE `blade_malfunction_type` ( `id` bigint(0) NOT NULL COMMENT '主键', `status` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) NULL DEFAULT NULL, `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '故障类型编号', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '故障类型', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uniqueCodeIndex` (`code`, `is_deleted`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '故障类型信息' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_material`; CREATE TABLE `blade_material` ( `id` bigint NOT NULL COMMENT '主键', `status` tinyint unsigned DEFAULT NULL COMMENT '状态', `is_deleted` int DEFAULT NULL, `create_user` bigint DEFAULT NULL COMMENT '创建人', `create_dept` bigint DEFAULT NULL COMMENT '创建部门', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_user` bigint DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所属租户', `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '物料编码', `bar_code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '物料条码', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '物料名称', `type_id` bigint DEFAULT NULL COMMENT '物料类型id', `unit` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '计量单位', `stuff` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '材质', `standard_model` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '规格', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注', `lower_limit` decimal(20, 2) DEFAULT NULL, `upper_limit` decimal(20, 2) DEFAULT NULL, `is_must_check` int DEFAULT NULL COMMENT '是否必检：0-非必检，1-必检', `property` int DEFAULT NULL COMMENT '物料性质：1-原材料、2-半成品、3-成品、4-备品备件、5-辅助用品、9-其它', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uniqueCodeIndex` (`code`, `is_deleted`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT ='物料'; DROP TABLE IF EXISTS `blade_material_type`; CREATE TABLE `blade_material_type` ( `id` bigint(0) NOT NULL COMMENT '主键', `status` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) NULL DEFAULT NULL, `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物料类型编码', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物料类型名称', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uniqueCodeIndex` (`code`, `is_deleted`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '物料类型' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_notice`; CREATE TABLE `blade_notice` ( `id` bigint(0) NOT NULL COMMENT '主键', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户ID', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题', `category` int(0) NULL DEFAULT NULL COMMENT '类型', `release_time` timestamp(0) NULL DEFAULT NULL COMMENT '发布时间', `content` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内容', `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` timestamp(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '修改人', `update_time` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间', `status` int(0) NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知公告表' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_notify_history`; CREATE TABLE `blade_notify_history` ( `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '通知状态', `notify_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '通知类型', `notifier_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '通知ID', `notify_time` datetime(6) NULL DEFAULT NULL COMMENT '通知时间', `provider` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '提供商', `template_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模板id', `template` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '模板内容', `retry_times` int(0) NULL DEFAULT NULL COMMENT '重试次数', `error_type` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '错误类型', `context_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '通知数据', `error_stack` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '错误栈', `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '修改人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间', `status` int(0) NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) NULL DEFAULT NULL, `trance_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '追溯ID', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_nt_his_notifier_id` (`notifier_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_notify_notifications`; CREATE TABLE `blade_notify_notifications` ( `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `subscribe_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订阅追溯Id', `subscriber` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订阅得用户ID', `businessKey` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主题标识,如:device_alarm', `businessName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '主题名称', `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '通知消息内容', `notify_time` bigint(0) NOT NULL COMMENT '通知时间', `state` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '通知状态', `description` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '修改人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间', `status` int(0) NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_ntfc_subscribe` (`subscriber`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_notify_subscribers`; CREATE TABLE `blade_notify_subscribers` ( `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户ID', `subscriber` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订阅者ID', `business_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务主题,如:device_alarm', `business_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '主题名称,如:设备告警', `notify_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订阅通知类型', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述', `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '修改人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间', `status` int(0) NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_nfy_subs_subscriber` (`subscriber`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_process`; CREATE TABLE `blade_process` ( `id` bigint(0) NOT NULL, `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工序编号', `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工序名称', `type` int(0) NULL DEFAULT NULL COMMENT '工序类型', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工序描述', `is_import` tinyint(0) NULL DEFAULT NULL COMMENT '是否导入', `is_deleted` int(0) NULL DEFAULT NULL, `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `status` int(0) NULL DEFAULT NULL COMMENT '业务状态', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uniqueCodeIndex` (`code`, `is_deleted`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '生产工序信息；' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_process_association`; CREATE TABLE `blade_process_association` ( `id` bigint(0) NOT NULL COMMENT '主键id', `type` tinyint(0) NULL DEFAULT NULL COMMENT '业务类型：1、工位，2、库区，3、供应商', `biz_id` bigint(0) NULL DEFAULT NULL COMMENT '业务id', `process_id` bigint(0) NULL DEFAULT NULL COMMENT '工序id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工序关系表' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS blade_product; CREATE TABLE `blade_product` ( `id` BIGINT(20) NOT NULL COMMENT '产品ID', `tenant_id` VARCHAR(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '所属租户', `code` VARCHAR(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '产品编号', `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '产品名称', `parent_id` BIGINT(20) DEFAULT NULL COMMENT '上级产品ID', `type_id` BIGINT(20) NOT NULL COMMENT '产品类型', `unit` VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '计量单位', `standard_model` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '规格型号', `description` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '产品描述', `documents` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '产品文档', `extend_field` json DEFAULT NULL COMMENT '扩展字段', `create_user` BIGINT(20) DEFAULT NULL COMMENT '创建人', `create_dept` BIGINT(20) DEFAULT NULL COMMENT '创建部门', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_user` BIGINT(20) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `status` INT(2) DEFAULT NULL COMMENT '状态：1启用 0停用', `is_deleted` INT(11) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uniqueCodeIndex` (`code`, `is_deleted`) USING BTREE, KEY `type_id_index` (`type_id`) USING BTREE ) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT = '产品信息'; -- 产品类型表 DROP TABLE IF EXISTS `blade_product_type`; CREATE TABLE `blade_product_type` ( `id` bigint(20) NOT NULL COMMENT '主键', `status` tinyint(3) UNSIGNED NULL DEFAULT 1 COMMENT '状态: 1为启动，0为停用', `is_deleted` int(11) NULL DEFAULT NULL, `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注/说明', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uniqueNameIndex` (`name`, `is_deleted`) USING BTREE COMMENT '名称唯一索引' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '产品类型' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_production_calendar`; CREATE TABLE `blade_production_calendar` ( `id` bigint NOT NULL, `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '日历编号', `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '日历名称', `year` int DEFAULT NULL COMMENT '应用年份', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '租户id', `is_deleted` int DEFAULT NULL, `create_dept` bigint DEFAULT NULL COMMENT '部门', `status` tinyint DEFAULT NULL COMMENT '启用禁用(0:禁用，1:启用)', `create_user` bigint DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_user` bigint DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', PRIMARY KEY (`id`) USING BTREE, KEY `codeIndex` (`code`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT ='生产日历'; DROP TABLE IF EXISTS `blade_production_calendar_day`; CREATE TABLE `blade_production_calendar_day` ( `id` bigint NOT NULL, `calendar_id` bigint DEFAULT NULL COMMENT '生产日历id', `calendar_date` date DEFAULT NULL COMMENT '生产日历日期', `start_time` datetime DEFAULT NULL COMMENT '班次日开始时间', `end_time` datetime DEFAULT NULL COMMENT '班次日结束时间', `week` int DEFAULT NULL COMMENT '属于当年的第几周', `month` int DEFAULT NULL COMMENT '属于当年的第几月', `year` int DEFAULT NULL COMMENT '属于哪一年', `model_id` bigint DEFAULT NULL COMMENT '班次模型id', `is_deleted` int DEFAULT NULL, `is_high_priority` tinyint DEFAULT NULL COMMENT '是否高优先级(0:否,1:是)', `is_off_day` tinyint DEFAULT NULL COMMENT '是否是休息日(0:否,1:是)', `off_id` bigint DEFAULT NULL COMMENT '休息日id', PRIMARY KEY (`id`) USING BTREE, KEY `calendarDateIndex` (`calendar_date`) USING BTREE, KEY `calendarIdIndex` (`calendar_id`) USING BTREE, KEY `modelIndex` (`model_id`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT ='生产日历日信息'; DROP TABLE IF EXISTS `blade_production_calendar_daytime`; CREATE TABLE `blade_production_calendar_daytime` ( `id` bigint(0) NOT NULL, `calendar_id` bigint(0) NULL DEFAULT NULL COMMENT '生产日历id', `calendar_day_id` bigint(0) NULL DEFAULT NULL COMMENT '生产日历具体id', `calendar_date` date NULL DEFAULT NULL COMMENT '生产日历日期', `start_time` datetime(0) NULL DEFAULT NULL COMMENT '班次开始时间', `end_time` datetime(0) NULL DEFAULT NULL COMMENT '班次结束时间', `shift_index` tinyint(0) NULL DEFAULT NULL COMMENT '班次序号', `shift_type` tinyint(0) NULL DEFAULT NULL COMMENT '班次类型(1-工作时段,2-休息时段,0-工厂日内未定义时段,3-工厂日外未定义时段)', `week` int(0) NULL DEFAULT NULL COMMENT '属于当年的第几周', `month` int(0) NULL DEFAULT NULL COMMENT '属于当年第几月', `year` int(0) NULL DEFAULT NULL COMMENT '年', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '本条记录创建时间', `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `is_high_priority` tinyint(0) NULL DEFAULT NULL COMMENT '是否高优先级(0:否,1:是)', `is_undefined` tinyint(0) NULL DEFAULT NULL COMMENT '是否未定义工厂日(0:否,1:是)', PRIMARY KEY (`id`) USING BTREE, INDEX `calendarDateIndex` (`calendar_date`) USING BTREE, INDEX `calendarIdIndex` (`calendar_id`) USING BTREE, INDEX `shift_time_index` (`calendar_id`, `start_time`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '生产日历日时间段定义' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_production_capacity_group`; CREATE TABLE `blade_production_capacity_group` ( `id` bigint(0) NOT NULL COMMENT '主键', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户ID', `name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组名', `full_name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组完整名称', `sort` int(0) NULL DEFAULT NULL COMMENT '排序', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `calendar_code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `is_deleted` int(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '组' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_region`; CREATE TABLE `blade_region` ( `code` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '区划编号', `parent_code` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '父区划编号', `ancestors` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '祖区划编号', `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区划名称', `province_code` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省级区划编号', `province_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省级名称', `city_code` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市级区划编号', `city_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市级名称', `district_code` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区级区划编号', `district_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区级名称', `town_code` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '镇级区划编号', `town_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '镇级名称', `village_code` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '村级区划编号', `village_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '村级名称', `region_level` int(0) NULL DEFAULT NULL COMMENT '层级', `sort` int(0) NULL DEFAULT NULL COMMENT '排序', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`code`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '行政区划表' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_shift_detail`; CREATE TABLE `blade_shift_detail` ( `id` bigint NOT NULL, `model_id` bigint DEFAULT NULL COMMENT '班次模型id', `shift_index` tinyint DEFAULT NULL COMMENT '班次序号', `shift_start_time` int DEFAULT NULL COMMENT '班次开始时间的偏移量(以当日0点为基准的偏移量的分钟数）', `shift_end_time` int DEFAULT NULL COMMENT '班次开始时间的偏移量(以当日0点为基准的偏移量的分钟数）', `rest_number` tinyint DEFAULT NULL COMMENT '班次休息时段数量', `index_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '下标名称', PRIMARY KEY (`id`) USING BTREE, KEY `modelIndex` (`model_id`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC; DROP TABLE IF EXISTS `blade_shift_model`; CREATE TABLE `blade_shift_model` ( `id` bigint(0) NOT NULL, `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '班次编号', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '班次名称', `shift_number` tinyint(0) NULL DEFAULT NULL COMMENT '班次数量', `colour` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '班次颜色', `start_time` int(0) NULL DEFAULT NULL COMMENT '班次日开始时间的偏移量(以当日0点为基准的偏移量的分钟数）', `end_time` int(0) NULL DEFAULT NULL COMMENT '班次日结束时间的偏移量(以当日0点为基准的偏移量的分钟数）', `tenant_id` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户id', `is_deleted` int(0) NULL DEFAULT NULL, `is_default` tinyint(0) NULL DEFAULT NULL COMMENT '是否是默认班次(0-默认,1-非默认)默认班次不可编辑,不可删除', `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建日期', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新日期', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `status` int(0) NULL DEFAULT NULL COMMENT '业务状态', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_shift_rest_time`; CREATE TABLE `blade_shift_rest_time` ( `id` bigint(0) NOT NULL, `model_id` bigint(0) NULL DEFAULT NULL COMMENT '模型Id', `rest_index` int(0) NULL DEFAULT NULL COMMENT '休息时段序号', `shift_id` bigint(0) NULL DEFAULT NULL COMMENT '班次Id', `rest_start_time` int(0) NULL DEFAULT NULL COMMENT '休息时段开始时间的偏移量(以当日0点为基准的偏移量的分钟数）', `rest_end_time` int(0) NULL DEFAULT NULL COMMENT '休息时段结束时间的偏移量(以当日0点为基准的偏移量的分钟数）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_stock_in_type`; CREATE TABLE `blade_stock_in_type` ( `id` bigint(0) NOT NULL COMMENT '主键', `status` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) NULL DEFAULT NULL, `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '入库类型编码', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '入库类型名称', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '入库类型' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_stock_out_type`; CREATE TABLE `blade_stock_out_type` ( `id` bigint(0) NOT NULL COMMENT '主键', `status` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) NULL DEFAULT NULL, `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '出库类型编码', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '出库类型名称', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '出库类型' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_supplier`; CREATE TABLE `blade_supplier` ( `id` bigint(0) NOT NULL COMMENT '主键', `status` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) NULL DEFAULT NULL, `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '供应商编码', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '供应商名称', `address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '供应商地址', `tel` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系方式', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uniqueCodeIndex` (`code`, `is_deleted`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '供应商' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_tool`; CREATE TABLE `blade_tool` ( `id` bigint(20) NOT NULL COMMENT '主键', `status` tinyint(3) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '删除状态：0-未删除，1-已删除', `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户ID', `tool_category_id` bigint(20) NULL DEFAULT NULL COMMENT '刀具类型id', `tool_model_id` bigint(20) NULL DEFAULT NULL COMMENT '刀具型号id', `tool_prefix_code` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '刀具前缀编号', `life_count_method` int(11) NULL DEFAULT NULL COMMENT '寿命计数方式(1.按次数 2.按时间)', `initial_life` int(45) NULL DEFAULT NULL COMMENT '初始寿命', `used_life` int(45) NULL DEFAULT NULL COMMENT '已用寿命', `remain_life` int(45) NULL DEFAULT NULL COMMENT '剩余寿命', `warning_value` int(45) NULL DEFAULT NULL COMMENT '预警值', `life_state` int(4) NULL DEFAULT NULL COMMENT '寿命状态(1.正常 2.警告 3.报警)', `use_state` int(4) NULL DEFAULT NULL COMMENT '使用状态(2.新增 1.已装刀 0.已卸刀)', `workstation_id` bigint(20) NULL DEFAULT NULL COMMENT '工位Id', `workstation_code` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工位编号', `workstation_name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工位名称', `tool_position` int(11) NULL DEFAULT NULL COMMENT '机床刀位', `parameter1` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数1', `parameter2` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数2', `parameter3` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数3', `parameter4` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数4', `parameter5` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数5', `parameter6` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数6', `parameter7` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数7', `parameter8` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数8', `parameter9` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数9', `parameter10` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数10', `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '刀具编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '刀具管理' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_tool_category`; CREATE TABLE `blade_tool_category` ( `id` bigint(20) NOT NULL COMMENT '主键', `status` tinyint(3) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '删除状态：0-未删除', `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户ID', `parent_id` bigint(20) NULL DEFAULT 0 COMMENT '父主键', `name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组名', `sort` int(10) NULL DEFAULT NULL COMMENT '顺序', `tool_prefix_code` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编码规则前缀', `code_length` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编码长度', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '刀具类型' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_tool_model`; CREATE TABLE `blade_tool_model` ( `id` bigint(20) NOT NULL COMMENT '主键', `status` tinyint(3) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '删除状态：0-未删除，1-已删除', `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户ID', `tool_category_id` bigint(20) NULL DEFAULT NULL COMMENT '刀具类型id', `tool_prefix_code` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '刀具前缀编号', `life_count_method` int(11) NULL DEFAULT NULL COMMENT '寿命计数方式(1.按次数 2.按时间)', `initial_life` int(45) NULL DEFAULT NULL COMMENT '初始寿命', `warning_value` int(45) NULL DEFAULT NULL COMMENT '预警值', `parameter1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数1', `parameter2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数2', `parameter3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数3', `parameter4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数4', `parameter5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数5', `parameter6` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数6', `parameter7` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数7', `parameter8` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数8', `parameter9` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数9', `parameter10` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数10', `model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '刀具型号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '刀具型号' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_workstation`; CREATE TABLE `blade_workstation` ( `id` bigint NOT NULL, `tenant_id` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所属租户', `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '工位编号', `name` varchar(32) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT '工位名称', `avatar` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '头像', `type` int NOT NULL DEFAULT '1' COMMENT '工位类型：机器、人, 来自字典 workstation_type', `calendar_code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '#default#' COMMENT '生产日历', `standard_efficiency` decimal(5, 2) DEFAULT NULL COMMENT '标准效率', `production_capacity_group` bigint DEFAULT NULL COMMENT '产能组', `calendar_code_waiting` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '生产日历等待更新', `status` int DEFAULT NULL COMMENT '业务状态', `create_dept` bigint DEFAULT NULL COMMENT '创建单位', `is_deleted` int DEFAULT NULL, `create_time` datetime DEFAULT NULL COMMENT '创建时间', `create_user` bigint DEFAULT NULL COMMENT '创建人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `update_user` bigint DEFAULT NULL COMMENT '更新人', `support_cnc_rw` tinyint DEFAULT NULL COMMENT '是否支持文件写入(1 支持 0 不支持)', `device_type` int DEFAULT NULL COMMENT '加工设备类型', `properties` int DEFAULT NULL COMMENT '加工属性', `transmission_method` int DEFAULT 1 COMMENT '程序传输方式：1 FTP 2 串口', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uniqueCodeIndex` (`code`, `is_deleted`) USING BTREE, KEY `calendarIndex` (`calendar_code`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT ='工位'; DROP TABLE IF EXISTS `blade_workstation_of_machine`; CREATE TABLE `blade_workstation_of_machine` ( `id` bigint(0) NOT NULL, `workstation_id` bigint(0) NOT NULL, `machine_id` bigint(0) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '机器工位' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_workstation_of_workstation_group`; CREATE TABLE `blade_workstation_of_workstation_group` ( `id` bigint(0) NOT NULL, `workstation_id` bigint(0) NOT NULL, `workstation_group_id` bigint(0) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工位-工位组对应表' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_workstation_wcs`; CREATE TABLE `blade_workstation_wcs` ( `id` bigint NOT NULL COMMENT '主键id', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `workstation_id` bigint NULL DEFAULT NULL COMMENT '工位id', `data_item` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工位变量名称', `data_type` int NULL DEFAULT NULL COMMENT '采集用途', `dmp_variables_id` bigint NULL DEFAULT NULL COMMENT '采集项id', `status` int NULL DEFAULT NULL COMMENT '业务状态', `collect_item` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `create_dept` bigint NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_user` bigint NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `update_user` bigint NULL DEFAULT NULL COMMENT '更新人', `is_deleted` int NULL DEFAULT NULL, `data_item_crc` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '校验值', `collect_setting_item` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '采集项', `big_screen` tinyint(0) NULL DEFAULT 1 COMMENT '大屏', `real_time_data` tinyint(0) NULL DEFAULT 1 COMMENT '实时数据', `process_parameter` tinyint(0) NULL DEFAULT 1 COMMENT '过程参数', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工况参数' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_gallery`; CREATE TABLE `blade_gallery` ( `id` bigint(0) NOT NULL COMMENT '主键', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图库名称', `status` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) NULL DEFAULT NULL, `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '图库' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_gallery_item`; CREATE TABLE `blade_gallery_item` ( `id` bigint(0) NOT NULL COMMENT '主键', `gallery_id` bigint(0) NULL DEFAULT NULL COMMENT '图库类别ID', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称', `original_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件原名', `thumbnail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '缩略图，base64存储', `link` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件地址', `extension` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '附件拓展名', `status` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '数据状态，1启用/0停用', `is_deleted` int(0) NULL DEFAULT NULL, `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '图库' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_check_item`; CREATE TABLE `blade_check_item` ( `id` bigint(0) NOT NULL COMMENT '主键', `status` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) NULL DEFAULT NULL, `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `check_project_id` bigint(0) NULL DEFAULT NULL COMMENT '点检项目Id', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '点检项', `value_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数值类型', `requirement` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '点检要求', `standard_value` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标准数值', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '点检项' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_check_project`; CREATE TABLE `blade_check_project` ( `id` bigint(0) NOT NULL COMMENT '主键', `status` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) NULL DEFAULT NULL, `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '点检项目编码', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '点检项目名称', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uniqueCodeIndex` (`code`, `is_deleted`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '点检项目信息' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_machine`; CREATE TABLE `blade_machine` ( `id` bigint(0) NOT NULL, `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户ID', `extend_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '扩展id', `machine_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '机器编号', `machine_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '机器名称', `collect_switch` tinyint(0) NOT NULL DEFAULT 0 COMMENT '采集开关：0关/1开', `collect_driver` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '采集驱动', `type_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设备类型', `machine_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设备类型', `machine_model` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '机器规格', `machine_life_status` tinyint(0) NULL DEFAULT NULL COMMENT '生命状态 字典 machine_life_status', `machine_use_status` tinyint(0) NULL DEFAULT NULL COMMENT '使用状态 字典 machine_use_status', `factory_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '出厂编号', `assets_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资产编号', `brand` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品牌', `nameplate` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '铭牌', `avatar` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像', `serial_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '序列号', `factory_file` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '出厂档案', `manufacturer` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '制造厂商', `country_of_manufacture` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产地国别', `system_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '系统名称', `software_version` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '软件版本', `net_weight` decimal(19, 2) NULL DEFAULT NULL COMMENT '净重kg', `power` decimal(19, 2) NULL DEFAULT NULL COMMENT '功率kw', `voltage` decimal(19, 2) NULL DEFAULT NULL COMMENT '电压v', `dimensions` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '轮廓尺寸(CM)', `production_time` datetime(0) NULL DEFAULT NULL COMMENT '生产日期', `delivery_time` datetime(0) NULL DEFAULT NULL COMMENT '交付日期', `depreciation_year` int(0) NULL DEFAULT NULL COMMENT '折旧年限', `turn_to_fixed_assets_time` datetime(0) NULL DEFAULT NULL COMMENT '转固日期', `invoice_value` decimal(19, 2) NULL DEFAULT NULL COMMENT '发票金额', `ovfa` decimal(19, 2) NULL DEFAULT NULL COMMENT '资产原值', `net_asset_value` decimal(19, 2) NULL DEFAULT NULL COMMENT '资产净值', `organization` bigint(0) NULL DEFAULT NULL COMMENT '使用部门', `custodian` bigint(0) NULL DEFAULT NULL COMMENT '保管人', `management_class` tinyint(0) NULL DEFAULT NULL COMMENT '管理等级，字典 machine_management_class', `elaborate_equipment` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '是否是特种设备，1是/0否', `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建单位', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `status` int(0) NULL DEFAULT NULL COMMENT '业务状态', `is_deleted` int(0) NULL DEFAULT NULL, `pin_code` char(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'PIN码', `short_code` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '短编码', `last_repair_time` datetime(0) NULL DEFAULT NULL COMMENT '维修日期', `employee_id` bigint(0) NULL DEFAULT NULL COMMENT '责任人', `production_line` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生产线', `organization_id` bigint(0) NULL DEFAULT NULL COMMENT '使用部门', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `machine_type_id` bigint(0) NULL DEFAULT NULL COMMENT '机器类型id', `group_id` bigint(0) NULL DEFAULT NULL COMMENT '所属机器组id', `last_maintain_time` datetime(0) NULL DEFAULT NULL COMMENT '最后保养时间', `next_maintain_time` datetime(0) NULL DEFAULT NULL COMMENT '下次保养时间', `last_check_time` datetime(0) NULL DEFAULT NULL COMMENT '最后点检时间', `installation_location` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '安装位置', `maintenance_time` datetime(0) NULL DEFAULT NULL COMMENT '保养日期', `repair_status` tinyint(0) NULL DEFAULT NULL COMMENT '维修状态', `maintenance_status` tinyint(0) NULL DEFAULT NULL COMMENT '保养状态', `external_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设备外部标识（用户可更改，用于标识该设备,唯一标识，可使用该Key进行检索设备）', PRIMARY KEY (`id`) USING BTREE, INDEX `employee_id` (`employee_id`) USING BTREE, INDEX `employee_id_2` (`employee_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '机器' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_shift_off_day`; CREATE TABLE `blade_shift_off_day` ( `id` bigint(0) NOT NULL COMMENT '主键', `status` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) UNSIGNED NULL DEFAULT 0 COMMENT '删除状态：0-未删除，1-已删除', `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `start_off_day` date NULL DEFAULT NULL COMMENT '休息日-开始', `end_off_day` date NULL DEFAULT NULL COMMENT '休息日-结束', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注/说明', `year` int(0) UNSIGNED NULL DEFAULT NULL COMMENT '年份', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '班次休息日' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_fixture`; CREATE TABLE `blade_fixture` ( `id` bigint NOT NULL, `tenant_id` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '夹具编号', `name` varchar(32) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT '夹具名称', `fixture_status` int NULL DEFAULT NULL COMMENT '夹具状态', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图像', `in_use` tinyint NULL DEFAULT 0 COMMENT '是否在使用', `status` int NULL DEFAULT NULL COMMENT '业务状态', `create_dept` bigint NULL DEFAULT NULL COMMENT '创建单位', `is_deleted` int NULL DEFAULT NULL, `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_user` bigint NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `update_user` bigint NULL DEFAULT NULL COMMENT '更新人', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uniqueCodeIndex` (`code`, `is_deleted`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工装夹具' ROW_FORMAT = DYNAMIC; DROP TABLE IF EXISTS `blade_warehouse_area`; CREATE TABLE `blade_warehouse_area` ( `id` bigint(20) NOT NULL COMMENT '主键', `status` tinyint(3) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `parent_id` bigint(20) NOT NULL COMMENT '父级id', `is_deleted` int(11) NULL DEFAULT NULL, `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '库区编码', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '库区名称', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uniqueCodeIndex` (`code`, `is_deleted`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '库区' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for blade_warehouse_area_of_material_type -- ---------------------------- DROP TABLE IF EXISTS `blade_warehouse_area_of_material_type`; CREATE TABLE `blade_warehouse_area_of_material_type` ( `id` bigint(0) NOT NULL COMMENT '主键', `warehouse_area_id` bigint(0) NULL DEFAULT NULL COMMENT '库区id', `material_type_id` bigint(0) NULL DEFAULT NULL COMMENT '物料类型id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '库区物料类型连接表' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_code`; CREATE TABLE `blade_code` ( `id` bigint(0) NOT NULL COMMENT '主键', `datasource_id` bigint(0) NULL DEFAULT NULL COMMENT '数据源主键', `service_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务名称', `code_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块名称', `table_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表名', `table_prefix` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表前缀', `pk_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '主键名', `package_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '后端包名', `base_mode` int(0) NULL DEFAULT NULL COMMENT '基础业务模式', `wrap_mode` int(0) NULL DEFAULT NULL COMMENT '包装器模式', `api_path` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '后端路径', `web_path` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '前端路径', `is_deleted` int(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码生成表' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_device_type_check_project`; CREATE TABLE `blade_device_type_check_project` ( `id` bigint(0) NOT NULL COMMENT '主键', `status` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) NULL DEFAULT NULL, `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `device_type_id` bigint(0) NULL DEFAULT NULL COMMENT '设备类型id', `check_project_id` bigint(0) NULL DEFAULT NULL COMMENT '点检项目id', `interval_time` int(0) NULL DEFAULT NULL COMMENT '点检周期', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '设备类型点检记录' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_warehouse_grid`; CREATE TABLE `blade_warehouse_grid` ( `id` bigint(20) NOT NULL COMMENT 'id', `tenant_id` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `station_id` bigint(20) NOT NULL COMMENT '库位id', `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '货格编号', `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '货格名称', `status` int(11) NULL DEFAULT NULL COMMENT '业务状态', `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建单位', `is_deleted` int(11) NULL DEFAULT NULL, `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `unique_code_index` (`code`, `is_deleted`) USING BTREE, INDEX `station_index` (`station_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '库区货格' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_warehouse_station`; CREATE TABLE `blade_warehouse_station` ( `id` bigint(20) NOT NULL COMMENT 'id', `tenant_id` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `area_id` bigint(20) NOT NULL COMMENT '库区id', `warehouse_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '库位编号', `warehouse_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '库位名称', `status` int(11) NULL DEFAULT NULL COMMENT '业务状态', `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建单位', `is_deleted` int(11) NULL DEFAULT NULL, `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `avatar` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uniqueCodeIndex` (`area_id`, `warehouse_code`, `is_deleted`) USING BTREE COMMENT '库位编号唯一索引', UNIQUE INDEX `uniqueNameIndex` (`area_id`, `warehouse_name`, `is_deleted`) USING BTREE COMMENT '库位名称唯一索引' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '库区库位' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_tray`; CREATE TABLE `blade_tray` ( `id` bigint NOT NULL, `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '编码', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称', `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片', `tray_status` tinyint DEFAULT '1' COMMENT '托盘状态 1 - 空载 0 - 负载', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '托盘描述', `in_use` tinyint DEFAULT '0' COMMENT '是否使用 默认为1', `category` tinyint DEFAULT NULL COMMENT '托盘类别', `standard_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '规格', `availability` tinyint DEFAULT NULL COMMENT '可用状态 1-激活 0-冻结', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注', `status` tinyint DEFAULT '1' COMMENT '业务状态 1激活 0 冻结', `is_deleted` bigint unsigned DEFAULT NULL COMMENT '删除标记：0-未删除，1-已删除', `create_user` bigint DEFAULT NULL COMMENT '创建人', `create_dept` bigint DEFAULT NULL COMMENT '创建部门', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_user` bigint DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `uniqueCodeIndex` (`code`, `is_deleted`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT ='托盘'; -- 托盘面-托盘 DROP TABLE IF EXISTS `blade_tray_surface`; CREATE TABLE `blade_tray_surface` ( `id` bigint NOT NULL, `tray_id` bigint DEFAULT NULL COMMENT '托盘id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '托盘面名称', `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '托盘面编号', `program_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '偏移程序编号', `in_use` tinyint DEFAULT '0' COMMENT '是否使用 默认为1', `status` tinyint DEFAULT '1' COMMENT '业务状态 1激活 0 冻结', `is_deleted` bigint unsigned DEFAULT NULL COMMENT '删除标记：0-未删除，1-已删除', `create_user` bigint DEFAULT NULL COMMENT '创建人', `create_dept` bigint DEFAULT NULL COMMENT '创建部门', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_user` bigint DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT ='托盘面'; -- 托盘面-夹具 DROP TABLE IF EXISTS `blade_tray_fixture`; CREATE TABLE `blade_tray_fixture` ( `id` bigint NOT NULL, `tray_id` bigint DEFAULT NULL COMMENT '托盘id', `face_id` bigint DEFAULT NULL COMMENT '托盘面id', `fix_id` bigint DEFAULT NULL COMMENT '夹具id', `status` tinyint DEFAULT '1' COMMENT '业务状态 1激活 0 冻结', `is_deleted` bigint unsigned DEFAULT NULL COMMENT '删除标记：0-未删除，1-已删除', `create_user` bigint DEFAULT NULL COMMENT '创建人', `create_dept` bigint DEFAULT NULL COMMENT '创建部门', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_user` bigint DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT ='托盘面-夹具'; DROP TABLE IF EXISTS `blade_workstation_workbench`; CREATE TABLE `blade_workstation_workbench` ( `id` bigint(0) NOT NULL COMMENT '主键', `status` tinyint(0) NULL DEFAULT NULL COMMENT '状态', `is_deleted` int(0) NULL DEFAULT NULL COMMENT '删除', `create_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户', `workstation_id` bigint(0) NULL DEFAULT NULL COMMENT '工位id', `sort` int(0) NULL DEFAULT NULL COMMENT '排序', `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作台名称', `workbench_default` int(0) NULL DEFAULT NULL COMMENT '是否为默认工作台：是：1 否：0', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工作台' ROW_FORMAT = Dynamic; -- 工装附件 DROP TABLE IF EXISTS `blade_tool_appendix`; CREATE TABLE `blade_tool_appendix` ( `id` bigint NOT NULL, `tenant_id` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所属租户', `parent_id` bigint DEFAULT NULL COMMENT '父id', `file_length` bigint DEFAULT NULL COMMENT '文件大小', `file_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文件名称', `object_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文件key', `file_link` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文件链接', `content_type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文件mini类型', `status` int DEFAULT NULL COMMENT '业务状态', `create_dept` bigint DEFAULT NULL COMMENT '创建单位', `is_deleted` int DEFAULT NULL, `create_time` datetime DEFAULT NULL COMMENT '创建时间', `create_user` bigint DEFAULT NULL COMMENT '创建人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `update_user` bigint DEFAULT NULL COMMENT '更新人', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uniqueCodeIndex` (`id`, `is_deleted`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT ='附件文件'; DROP TABLE IF EXISTS `blade_tray_storage`; CREATE TABLE `blade_tray_storage` ( `id` bigint NOT NULL, `tray_id` bigint DEFAULT NULL COMMENT '托盘id', `warehouse_station_id` bigint DEFAULT NULL COMMENT '库位id', `status` tinyint DEFAULT '1' COMMENT '业务状态 1激活 0 冻结', `is_deleted` bigint unsigned DEFAULT NULL COMMENT '删除标记：0-未删除，1-已删除', `create_user` bigint DEFAULT NULL COMMENT '创建人', `create_dept` bigint DEFAULT NULL COMMENT '创建部门', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_user` bigint DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT ='托盘存放'; DROP TABLE IF EXISTS `blade_production_craft_version`; CREATE TABLE `blade_production_craft_version` ( `id` bigint(20) NOT NULL, `tenant_id` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `name` varchar(32) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT '版本名称', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '版本描述', `craft_id` bigint(20) NULL NULL COMMENT '工艺路线id', `edition_status` int(11) NULL DEFAULT 0 COMMENT '是否定版(0:否 1:是)', `status` int(11) NULL DEFAULT NULL COMMENT '业务状态', `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建单位', `is_deleted` bigint(20) NULL DEFAULT NULL, `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '产品工艺版本' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for blade_production_craft_process_related_tool -- ---------------------------- DROP TABLE IF EXISTS `blade_production_craft_process_related_tool`; CREATE TABLE `blade_production_craft_process_related_tool` ( `id` bigint(20) NOT NULL COMMENT '主键', `tool_id` bigint(20) NULL DEFAULT NULL COMMENT '刀具ID', `version_process_id` bigint(20) NULL DEFAULT NULL COMMENT '产品工艺工序ID', `tool_code` varchar(128) NULL DEFAULT NULL COMMENT '刀具编号', `tool_model_name` varchar(64) NULL DEFAULT NULL COMMENT '刀具型号名称', `tool_category_name` varchar(45) NULL DEFAULT NULL COMMENT '刀具类型名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '产品工艺工序关联刀具' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for blade_production_craft_process_related_fixture -- ---------------------------- DROP TABLE IF EXISTS `blade_production_craft_process_related_fixture`; CREATE TABLE `blade_production_craft_process_related_fixture` ( `id` bigint(20) NOT NULL COMMENT '主键', `fixture_id` bigint(20) NULL DEFAULT NULL COMMENT '夹具ID', `version_process_id` bigint(20) NULL DEFAULT NULL COMMENT '产品工艺工序ID', `fixture_group_name` varchar(45) null, `fixture_code` varchar(128) null, `fixture_name` varchar(32) null, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '产品工艺工序关联夹具' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for blade_production_craft_process_file -- ---------------------------- DROP TABLE IF EXISTS `blade_production_craft_process_file`; CREATE TABLE `blade_production_craft_process_file` ( `id` bigint(20) NOT NULL, `version_process_id` bigint(20) NULL DEFAULT NULL COMMENT '产品工艺工序ID', `file_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称', `object_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件key', `content_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件mini类型', `link` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件外链', `file_size` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件大小', `upload_time` datetime(0) NULL DEFAULT NULL COMMENT '上传时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '产品工艺工序文件' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for blade_production_craft_process -- ---------------------------- DROP TABLE IF EXISTS `blade_production_craft_process`; CREATE TABLE `blade_production_craft_process` ( `id` bigint(20) NOT NULL COMMENT '主键', `tenant_id` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `version_id` bigint(20) NULL DEFAULT NULL COMMENT '所属工艺版本', `process_id` bigint(20) NULL DEFAULT NULL COMMENT '所属生产工序', `sort` int(11) NULL DEFAULT NULL COMMENT '工序顺序', `program_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '程序名称', `standard_time` int(11) NULL DEFAULT NULL COMMENT '标准工时（秒）', `prepare_time` int(11) NULL DEFAULT 0 COMMENT '准备工时', `disassembly_time` int(11) NULL DEFAULT 0 COMMENT '拆卸工时', `transport_time` int(11) NULL DEFAULT 0 COMMENT '运输工时', `source_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源ID', `target_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '目标ID', `x_coordinate` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'x坐标', `y_coordinate` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'y坐标', `is_deleted` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '删除标记：0-未删除，1-已删除', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建部门', `status` int(11) NULL DEFAULT NULL COMMENT '业务状态', `process_name` varchar(32) null comment '工序名称', `process_code` varchar(128) null comment '工序编号', `process_desc` varchar(255) null comment '工序描述', `process_type` int null comment '工种', `process_type_name` varchar(32) null comment '工种名称', `program_id` bigint null comment '程序id', `mea_method` varchar(20) null comment '测量方式', `mea_method_value` int null comment '测量方式维护的值', `handler_method` int null comment '不合格品处理方式', `main_sequence_id` bigint null comment '主序id（当主序id不为空时，代表工序是子序）', `whether_test` int default 0 null comment '是否质检：默认 0 否 1 是', `whether_parallel` int default 0 null comment '是否并行：默认 0 否 1 是', `bag_id` bigint null comment '工艺包id', `bag_name` varchar(64) null comment '工艺包名称', `height` int(11) DEFAULT NULL COMMENT '主序的高度', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工艺版本的工序流程' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_material_storage`; CREATE TABLE `blade_material_storage` ( `id` bigint(20) NOT NULL, `material_id` bigint(20) DEFAULT NULL COMMENT '物料id', `warehouse_station_id` bigint(20) DEFAULT NULL COMMENT '库位id', `status` tinyint(4) DEFAULT '1' COMMENT '业务状态 1激活 0 冻结', `is_deleted` bigint(20) unsigned DEFAULT NULL COMMENT '删除标记：0-未删除，1-已删除', `create_user` bigint(20) DEFAULT NULL COMMENT '创建人', `create_dept` bigint(20) DEFAULT NULL COMMENT '创建部门', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_user` bigint(20) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT ='物料存放'; DROP TABLE IF EXISTS `blade_bom_material`; CREATE TABLE `blade_bom_material` ( `id` bigint(20) NOT NULL COMMENT '主键', `status` tinyint(3) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '删除状态：0-未删除，1-已删除', `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `version_id` bigint(20) NULL DEFAULT NULL COMMENT 'bom版本id', `material_id` bigint(20) NULL DEFAULT NULL COMMENT '物料id', `parent_id` bigint(20) NULL DEFAULT NULL COMMENT '父级Id', `all_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'allPath', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'bom物料' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_bom_process`; CREATE TABLE `blade_bom_process` ( `id` bigint(20) NOT NULL COMMENT '主键', `status` tinyint(3) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '删除状态：0-未删除，1-已删除', `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `bom_material_id` bigint(20) NULL DEFAULT NULL COMMENT 'bom物料Id', `molecule` int(11) NULL DEFAULT NULL COMMENT '用量分子', `denominator` int(11) NULL DEFAULT NULL COMMENT '用量分母', `process_id` bigint(20) NULL DEFAULT NULL COMMENT '用料工序id', `loss` decimal(10, 2) NULL DEFAULT NULL COMMENT '固定损耗', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'bom物料工序' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_bom_version`; CREATE TABLE `blade_bom_version` ( `id` bigint(20) NOT NULL COMMENT '主键', `status` tinyint(3) UNSIGNED NULL DEFAULT NULL COMMENT '状态', `is_deleted` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '删除状态：0-未删除，1-已删除', `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建部门', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `product_id` bigint(20) NULL DEFAULT NULL COMMENT '产品id', `version` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '版本', `version_status` int(11) NULL DEFAULT 0 COMMENT '版本状态(0：未定版，1：已定版)', `craft_id` bigint(20) NULL DEFAULT NULL COMMENT '工艺版本id', `craft_version` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工艺版本', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '版本描述', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'bom版本' ROW_FORMAT = Dynamic; -- 工艺路线版本产线表 drop table if exists `blade_craft_version_line`; CREATE TABLE `blade_craft_version_line` ( `id` bigint NOT NULL COMMENT '主键', `status` tinyint unsigned DEFAULT NULL COMMENT '状态', `is_deleted` int DEFAULT NULL, `create_user` bigint DEFAULT NULL COMMENT '创建人', `create_dept` bigint DEFAULT NULL COMMENT '创建部门', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_user` bigint DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所属租户', `craft_id` bigint DEFAULT NULL COMMENT '工艺路线id', `version_id` bigint DEFAULT NULL COMMENT '工艺路线版本id', `group_id` bigint DEFAULT NULL COMMENT '产线id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT ='工艺路线版本产线表'; -- 工艺路线表 drop table if exists `blade_craft_routing`; CREATE TABLE `blade_craft_routing` ( `id` bigint NOT NULL COMMENT '主键', `status` tinyint unsigned DEFAULT NULL COMMENT '状态', `is_deleted` int DEFAULT NULL, `create_user` bigint DEFAULT NULL COMMENT '创建人', `create_dept` bigint DEFAULT NULL COMMENT '创建部门', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_user` bigint DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所属租户', `name` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称', `description` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述', `product_id` bigint DEFAULT NULL COMMENT '产品id', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uniqueCodeIndex` (`name`, `is_deleted`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT ='工艺路线'; DROP TABLE IF EXISTS `blade_dnc_fixed_space`; CREATE TABLE `blade_dnc_fixed_space` ( `id` bigint(20) NOT NULL COMMENT '主键', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户ID', `parent_id` bigint(20) DEFAULT '0' COMMENT '父主键', `name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '固定空间目录名称', `all_path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '全路径(包含自身)', `is_deleted` int(11) DEFAULT NULL, `status` int(11) DEFAULT NULL COMMENT '状态', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `create_user` bigint(20) DEFAULT NULL COMMENT '创建人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `update_user` bigint(20) DEFAULT NULL COMMENT '更新人', `create_dept` bigint(20) DEFAULT NULL COMMENT '创建部门', `td_id` bigint(20) DEFAULT NULL COMMENT '工位目录id', `space_location` int(11) DEFAULT NULL COMMENT '目录属性: 1 常规（根节点）2 固定', PRIMARY KEY (`id`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT ='工位目录关联固定空间表'; DROP TABLE IF EXISTS `blade_dnc_transfer_directory`; CREATE TABLE `blade_dnc_transfer_directory` ( `id` bigint(0) NOT NULL, `group_all_path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工位文件组的all_path', `dept_id` bigint(0) NULL DEFAULT NULL COMMENT '职权域id', `group_id` bigint(0) NULL DEFAULT NULL COMMENT '工位文件分组Id', `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工位文件名称', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户ID', `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` int(0) NULL DEFAULT NULL, `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `status` int(0) NULL DEFAULT NULL COMMENT '业务状态', `resource_id` bigint(0) NULL DEFAULT NULL COMMENT '资源id', `workstation_id` bigint(0) NULL DEFAULT NULL COMMENT '工位id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工位目录表' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_dnc_transfer_directory_file`; CREATE TABLE `blade_dnc_transfer_directory_file` ( `id` bigint(0) NOT NULL, `transfer_directory_id` bigint(0) NOT NULL COMMENT '工位目录Id', `file_source` tinyint(0) NULL DEFAULT NULL COMMENT '文件来源 1 我的文档 2 本地文件 3 工艺管理', `file_type` int(0) NULL DEFAULT NULL COMMENT '文件类别(1:加工文件,2:工艺文件)', `original_filename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原始文件名称', `filename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称', `content_length` bigint(0) NULL DEFAULT NULL, `content_md5` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件md5值', `last_modified` datetime(0) NULL DEFAULT NULL COMMENT '最后修改时间', `content_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `object_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件的objectKey', `suffix` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` int(0) NULL DEFAULT NULL, `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `status` int(0) NULL DEFAULT NULL COMMENT '业务状态', `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件地址', `is_current` int(0) NULL DEFAULT NULL COMMENT '是否为当前版本,1是0否', `workstation_id` bigint(0) NOT NULL COMMENT '工位Id', `cover_time` datetime(0) NULL DEFAULT NULL COMMENT '文件时间', `craft_file_id` bigint(0) NULL DEFAULT NULL COMMENT '文档文件id', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户ID', `version` int(0) NULL DEFAULT NULL COMMENT '版本号', `storage_space` int(0) NULL DEFAULT NULL COMMENT '存储位置：1 常规空间 2 固定空间', `whether_archive` int(0) NULL DEFAULT NULL COMMENT '文件是否归档：1 未归档 2 已归档', `storage_space_id` bigint(0) NULL DEFAULT NULL COMMENT '固定空间目录id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工位目录文件表' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_dnc_transfer_directory_group`; CREATE TABLE `blade_dnc_transfer_directory_group` ( `id` bigint(0) NOT NULL COMMENT '主键', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户ID', `parent_id` bigint(0) NULL DEFAULT 0 COMMENT '父主键', `name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工位文件组名', `all_path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '全路径(包含自身)', `is_deleted` int(0) NULL DEFAULT NULL, `status` int(0) NULL DEFAULT NULL COMMENT '状态', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `workstation_group_id` bigint(0) NULL DEFAULT NULL COMMENT '工位组id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工位组目录表' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_dnc_ws_relation_td`; CREATE TABLE `blade_dnc_ws_relation_td` ( `id` bigint(20) NOT NULL, `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户ID', `create_user` bigint(20) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_user` bigint(20) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `is_deleted` int(11) DEFAULT NULL, `create_dept` bigint(20) DEFAULT NULL COMMENT '创建部门', `status` int(11) DEFAULT NULL COMMENT '业务状态', `transfer_director_id` bigint(20) DEFAULT NULL COMMENT 'FTP目录id', `workstation_id` bigint(20) DEFAULT NULL COMMENT '工位id', PRIMARY KEY (`id`), UNIQUE KEY `workstation_id` (`workstation_id`, `is_deleted`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT ='FTP目录与工位关系表'; -- 菜单脚本 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 (1469141105228611586, 1503998309035220994, 'shift_calendar', '班制日历', 'shift_calendar', '/console/base/shift-calendar', 'iconfont iconicon_work', 2, 1, 0, 1, '', 0, 'CPS', 1), (1470274120439566338, 1503966666579030018, 'organization', '员工-部门-岗位', 'organization', '/master/person/main/index', 'iconfont iconicon_group', 1, 1, 0, 1, '', 0, 'CPS', 1), (1471285883018977281, 1503992936900796418, 'workstation', '工位', 'workstation', '/console/workstation/index', 'iconfont icon-wxbgongju', 1, 1, 0, 1, '', 0, 'CPS', 1), (1483632111746801666, 0, 'basic_data', '主数据', 'basic_data', '/console/basic-data', 'iconfont saber-zhushuju', 2, 0, 0, 1, '', 0, 'CPS', 1), (1483642077594710017, 1503992936900796418, 'machine_data', '机器管理数据', 'machine_data', '/console/basic-data/tpm-data', 'iconfont icon-rizhi', 3, 1, 0, 1, '', 0, 'CPS', 1), (1485491717025140738, 1503992936900796418, 'machine_ledger', '机器台账', 'machine_ledger', '/tpm/machine-management', 'iconfont iconicon_airplay', 2, 1, 0, 1, '', 0, 'CPS', 1), (1493759281711730689, 1504027069390331905, 'supplier', '供应商', 'supplier', '/console/basic-data/supplier-info', 'iconfont iconicon_community_line', 1, 1, 0, 1, '', 0, 'CPS', 1), (1503195854444433409, 1504027069390331905, 'gallery', '图库', 'gallery', '/console/basic-data/gallery', 'iconfont iconicon_namecard', 4, 1, 0, 1, '', 0, 'CPS', 1), (1503215833683517442, 1503998309035220994, 'day_off', '休息日', 'day_off', '/master/time/day-off/index', 'iconfont iconicon_more', 1, 1, 0, 1, '', 0, 'CPS', 1), (1503546274154123265, 1504003518490812418, 'area_location', '库区库位', 'area_location', '/console/basic-data/material-warehousing-data/reservoir-location/reservoir-location', 'iconfont iconicon_work', 3, 1, 0, 1, '', 0, 'CPS', 1), (1503621096733990913, 1503992936900796418, 'work_condition', '工位采集模板', 'menu', '/console/basic-data/working-condition/index', 'iconfont icon-liuliangyunpingtaitubiao08', 4, 1, 0, 1, '', 0, 'CPS', 1), (1503966666579030018, 1483632111746801666, 'staff', '人', 'staff', '/console/basic-data/staff', 'iconfont iconicon_principal', 1, 1, 0, 1, '', 0, 'CPS', 1), (1503992936900796418, 1483632111746801666, 'machine', '机', 'machine', '/console/basic-data/machine', 'iconfont iconicon_setting', 2, 1, 0, 1, '', 0, 'CPS', 1), (1503996684083601409, 1483632111746801666, 'material', '料', 'material', '/console/basic-data/material', 'iconfont iconicon_work', 3, 1, 0, 1, '', 0, 'CPS', 1), (1503998309035220994, 1483632111746801666, 'production_time', '时间', 'production_time', '/console/basic-data/production-time', 'iconfont iconicon_send', 4, 1, 0, 1, '', 0, 'CPS', 1), (1504003518490812418, 1483632111746801666, 'warehouse', '仓储', 'warehouse', '/console/basic-data/warehouse', 'iconfont iconicon_cspace', 6, 1, 0, 1, '', 0, 'CPS', 1), (1504027069390331905, 1483632111746801666, 'other', '其他', 'other', '/console/basic-data/other', 'iconfont iconicon_im_keyboard', 8, 1, 0, 1, '', 0, 'CPS', 1), (1497086897538789377, 1503996684083601409, 'materials', '物料信息', 'materials', '/console/basic-data/material-warehousing-data/material-info', 'iconfont iconicon_compile', 1, 1, 0, 1, '', 0, 'CPS', 1), (1519129245830651905, 1518929460899213313, 'tray_fixture', '托盘夹具', 'tray_fixture', '/console/tooling/tray-fixture', 'iconfont iconicon_savememo', 1, 1, 0, 1, '', 0, 'CPS', 1), (1522048292781465601, 1518929460899213313, 'tray_storage', '托盘存放', 'tray_storage', '/master/frock/tray-deposit/index', 'iconfont iconicon_setting', 2, 1, 0, 1, '', 0, 'CPS', 1), (1522390934839029761, 1504025044741070849, 'processes', '工序管理', 'processes', '/console/basic-data/work-process', 'iconfont iconicon_send', 2, 1, 0, 1, '', 0, 'CPS', 1), (1504025044741070849, 1483632111746801666, 'product_process', '产品工艺', 'product_process', '/console/basic-data/product-process', 'iconfont iconicon_namecard', 7, 1, 0, 1, '', 0, 'CPS', 1), (1522823470509395969, 1504025044741070849, 'product', '产品', 'product', '/console/basic-data/product', 'iconfont iconicon_coinpurse_line', 55, 1, 0, 1, '', 0, 'CPS', 1), (1523489440260923394, 1504025044741070849, 'process_route', '工艺路线', 'process_route', '/console/product-process/process-route', 'iconfont iconicon_exchange', 2, 1, 0, 1, '', 0, 'CPS', 1), (1526736219864084482, 1523489440260923394, 'cancel_fixed', '取消定版', 'cancel_fixed', '', 'iconfont iconicon_safety', 1, 2, 0, 1, '', 0, 'CPS', 1), (1527115790989488129, 1503996684083601409, 'material_storage', '物料存放', 'material_storage', '/console/basic-data/material-warehousing-data/material-storage', 'iconfont iconicon_send', 4, 1, 0, 1, '', 0, 'CPS', 1), (1526031760774340609, 1504025044741070849, 'bom_list', 'BOM 清单', 'menu', '/console/bom-list/index', 'iconfont icon-caidan', 3, 1, 0, 1, '', 0, 'CPS', 1), (1526040185400328193, 1504003518490812418, 'issue_receipt_type', '出入库类型', 'issue_receipt_type', '/console/basic-data/material-warehousing-data/Material-warehousing-data', 'iconfont iconicon_more', 4, 1, 0, 1, '', 0, 'CPS', 1), (1535168094212694017, 1526031760774340609, 'fix_version', '定版', 'fix_version', '', '', 1, 2, 0, 1, '', 0, 'CPS', 1), (1535169198577131521, 1526031760774340609, 'cancel_version', '取消定版', 'cancel_version', '', '', 2, 2, 0, 1, '', 0, 'CPS', 1), (1535242977381232642, 1526031760774340609, 'delete_version', '删除版本', 'delete_version', '', '', 3, 2, 0, 1, '', 0, 'CPS', 1), (1535243543318671362, 1526031760774340609, 'add_process', '添加工序', 'add_process', '', '', 4, 2, 0, 1, '', 0, 'CPS', 1), (1535244130533814273, 1526031760774340609, 'add_material', '添加物料', 'add_material', '', '', 5, 2, 0, 1, '', 0, 'CPS', 1), (1535246268496392194, 1526031760774340609, 'add_version', '新增版本', 'add_version', '', '', 6, 2, 0, 1, '', 0, 'CPS', 1), (1541661765077213185, 1523489440260923394, 'craft_route_create', '新建工艺路线', 'craft_route_create', '', '', 10, 2, 0, 1, '', 0, 'CPS', 1), (1541662062897963010, 1523489440260923394, 'craft_route_edit', '编辑工艺路线', 'craft_route_edit', '', '', 11, 2, 0, 1, '', 0, 'CPS', 1), (1541662253902372865, 1523489440260923394, 'craft_route_delete', '删除工艺路线', 'craft_route_delete', '', '', 12, 2, 0, 1, '', 0, 'CPS', 1), (1541668488361975810, 1522823470509395969, 'view_craft', '查看工艺路线', 'view_craft', '', '', 10, 2, 0, 1, '', 0, 'CPS', 1), (1541668794567139329, 1522823470509395969, 'view_bom', '查看bom清单', 'view_bom', '', '', 11, 2, 0, 1, '', 0, 'CPS', 1), (1541668925542670337, 1522823470509395969, 'bind_craft', '绑定工艺路线', 'bind_craft', '', '', 12, 2, 0, 1, '', 0, 'CPS', 1), (1541669017884467201, 1522823470509395969, 'unbind_craft', '解绑工艺路线', 'unbind_craft', '', '', 13, 2, 0, 1, '', 0, 'CPS', 1); INSERT INTO `blade_warehouse_area` VALUES (1, 0, 0, 0, 1123598821738675201, 1123598813738675201, '2022-04-25 10:25:51', 1123598821738675201, '2022-04-25 10:25:56', '000000', '所有的', '所有的', NULL); DROP TABLE IF EXISTS `blade_dnc_art_bag`; CREATE TABLE `blade_dnc_art_bag` ( `id` bigint(0) NOT NULL, `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `create_user` bigint(0) NULL DEFAULT NULL, `create_dept` bigint(0) NULL DEFAULT NULL, `create_time` datetime(0) NULL DEFAULT NULL, `update_user` bigint(0) NULL DEFAULT NULL, `update_time` datetime(0) NULL DEFAULT NULL, `status` int(0) NULL DEFAULT NULL, `is_deleted` int(0) NULL DEFAULT NULL, `tenant_id` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '000000', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工艺包名称', `code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工艺包编码', `catalogue_id` bigint(0) NULL DEFAULT NULL COMMENT '工艺目录id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_dnc_art_file`; CREATE TABLE `blade_dnc_art_file` ( `id` bigint(0) NOT NULL, `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `create_user` bigint(0) NULL DEFAULT NULL, `create_dept` bigint(0) NULL DEFAULT NULL, `create_time` datetime(0) NULL DEFAULT NULL, `update_user` bigint(0) NULL DEFAULT NULL, `update_time` datetime(0) NULL DEFAULT NULL, `status` int(0) NULL DEFAULT NULL, `is_deleted` int(0) NULL DEFAULT NULL, `tenant_id` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '000000', `file_id` bigint(0) NULL DEFAULT NULL COMMENT '文件id', `art_bag_id` bigint(0) NULL DEFAULT NULL COMMENT '工艺包id', `source_type` int(0) NULL DEFAULT NULL COMMENT '文件来源 1 我的文档 2 工位文件 3 本地上传 4 归档文件', `file_type` int(0) NULL DEFAULT NULL COMMENT '文件类别(1:程序,2 文档)', `original_filename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原始文件名称', `filename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称', `content_length` bigint(0) NULL DEFAULT NULL, `content_md5` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件md5值', `content_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件类型', `object_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件的objectKey', `suffix` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件后缀', `document_ownership` int(0) NULL DEFAULT NULL COMMENT '文件归属：1 工位 2 工厂', `is_current` int(0) NULL DEFAULT NULL COMMENT '是否为当前版本,1是0否', `link` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件链接', `storage_space` int(0) NULL DEFAULT NULL COMMENT '存储位置：1 常规空间 2 固定空间', `version` int(0) NULL DEFAULT NULL COMMENT '文件版本', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工艺包文件' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_employee_on_off_work`; CREATE TABLE `blade_employee_on_off_work` ( `id` bigint(20) NOT NULL, `online_time` datetime DEFAULT NULL COMMENT '上线时间', `on_employee_id` bigint(20) DEFAULT NULL COMMENT '上线员工id', `on_employee_code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '上线员工编号', `on_employee_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '上线员工名称', `on_employee_avatar` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '上线员工头像', `workstation_id` bigint(20) DEFAULT NULL COMMENT '工位id', `workstation_code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '工位编号', `workstation_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '工位名称', `workstation_avatar` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '工位名称头像', `offline_time` datetime DEFAULT NULL COMMENT '下线时间', `off_employee_id` bigint(20) DEFAULT NULL COMMENT '下线员工id', `off_employee_code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '下线员工编号', `off_employee_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '下线员工名称', `off_employee_avatar` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '下线员工头像', `online_type` tinyint(4) DEFAULT '0' COMMENT '上下线类型 0-上线 1-下线', `time_type` tinyint(4) DEFAULT '0' COMMENT '按时间/班次上下线 0-时间 1-班次', `status` tinyint(4) DEFAULT '1' COMMENT '业务状态 1激活 0 冻结', `is_deleted` bigint(20) unsigned DEFAULT NULL COMMENT '删除标记：0-未删除，1-已删除', `create_user` bigint(20) DEFAULT NULL COMMENT '创建人', `create_dept` bigint(20) DEFAULT NULL COMMENT '创建部门', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_user` bigint(20) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT ='员工上下线表'; DROP TABLE IF EXISTS `blade_dnc_process_catalogue`; CREATE TABLE `blade_dnc_process_catalogue` ( `id` bigint(0) NOT NULL COMMENT '主键', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户ID', `parent_id` bigint(0) NULL DEFAULT 0 COMMENT '父主键', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工艺目录名称', `all_path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '全路径(包含自身)', `is_deleted` int(0) NULL DEFAULT NULL, `status` int(0) NULL DEFAULT NULL COMMENT '状态', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `create_user` bigint(0) NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `update_user` bigint(0) NULL DEFAULT NULL COMMENT '更新人', `create_dept` bigint(0) NULL DEFAULT NULL COMMENT '创建部门', `dept_id` bigint(0) NULL DEFAULT NULL COMMENT '职权域id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工艺目录表' ROW_FORMAT = Dynamic; -- 数据标签关系表 ALTER TABLE `blade_workstation_wcs` ADD COLUMN `usage_id` bigint NULL COMMENT '数据标签ID' AFTER `data_type`; -- 增加数据标签关系表 CREATE TABLE `blade_workstation_wcs_usage` ( `id` bigint(20) NOT NULL COMMENT '主键', `collect_type` tinyint(4) DEFAULT NULL COMMENT '计算方法', `usage_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '数据标签名称', `usage_code` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '数据标签编号', `parameter` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '数据标签执行参数', `create_time` datetime DEFAULT NULL, `create_user` bigint(255) DEFAULT NULL, `update_time` datetime DEFAULT NULL, `update_user` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC; -- 增加数据标签初始化数据 INSERT INTO `blade_workstation_wcs_usage` (`id`, `collect_type`, `usage_name`, `usage_code`, `parameter`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1604657686328061954, 0, '无', '0', NULL, '2022-12-19 09:59:40', NULL, NULL, NULL); INSERT INTO `blade_workstation_wcs_usage` (`id`, `collect_type`, `usage_name`, `usage_code`, `parameter`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1604659202451517442, 1, '状态', '1', NULL, '2022-12-19 10:05:42', NULL, NULL, NULL); INSERT INTO `blade_workstation_wcs_usage` (`id`, `collect_type`, `usage_name`, `usage_code`, `parameter`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1604659243140460545, 2, '产量', '2', NULL, '2022-12-19 10:05:51', NULL, NULL, NULL); INSERT INTO `blade_workstation_wcs_usage` (`id`, `collect_type`, `usage_name`, `usage_code`, `parameter`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1604659295900610562, 3, '报警', '3', NULL, '2022-12-19 10:06:04', NULL, NULL, NULL); INSERT INTO `blade_workstation_wcs_usage` (`id`, `collect_type`, `usage_name`, `usage_code`, `parameter`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1604659380000600066, 5, '脉冲产量', '5', NULL, '2022-12-19 10:06:24', NULL, NULL, NULL); INSERT INTO `blade_workstation_wcs_usage` (`id`, `collect_type`, `usage_name`, `usage_code`, `parameter`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1604659442676084737, 6, '报警号', '6', NULL, '2022-12-19 10:06:39', NULL, NULL, NULL); INSERT INTO `blade_workstation_wcs_usage` (`id`, `collect_type`, `usage_name`, `usage_code`, `parameter`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1604659517745737729, 7, '报警信息', '7', NULL, '2022-12-19 10:06:57', NULL, NULL, NULL); -- 修改字典名称 INSERT INTO `blade_dict` (`id`, `parent_id`, `code`, `dict_key`, `dict_value`, `sort`, `remark`, `is_sealed`, `is_deleted`) VALUES (1600787418029592578, 1473111864757952513, 'workstation_param_type', '8', '差值计算', 10, '', 0, 0); INSERT INTO `blade_dict` (`id`, `parent_id`, `code`, `dict_key`, `dict_value`, `sort`, `remark`, `is_sealed`, `is_deleted`) VALUES (1600787468336074754, 1473111864757952513, 'workstation_param_type', '9', '脉冲计算', 11, '', 0, 0); -- 数据标签增加大屏接口 INSERT INTO blade_interface_config (id, status, is_deleted, create_user, create_dept, create_time, update_user, update_time, url, url_name, url_type, owning_chart) VALUES (1602849539512963073, 1, 0, 1123598821738675201, 1123598813738675201, '2022-12-14 10:14:44', 1123598821738675201, '2022-12-14 10:14:44', '/api/blade-visual/output/usage-type', '脉冲、计数显示用途统计', 0, '3'); INSERT INTO blade_interface_config_field (id, status, is_deleted, create_user, create_dept, create_time, update_user, update_time, config_id, label, name, is_required, data_type, data_source, is_single_choice, checked_parent, relation_field, method) VALUES (1602849545779253250, 1, 0, 1123598821738675201, 1123598813738675201, '2022-12-14 10:14:46', 1123598821738675201, '2022-12-19 14:19:12', 1602849539512963073, '数据标签', 'usageCode', 1, 2, '/api/blade-cps/workstation-wcs-usage/visual-usage-code', 1, NULL, NULL, 'get'); INSERT INTO blade_interface_config_field (id, status, is_deleted, create_user, create_dept, create_time, update_user, update_time, config_id, label, name, is_required, data_type, data_source, is_single_choice, checked_parent, relation_field, method) VALUES (1602853136015396866, 1, 0, 1123598821738675201, 1123598813738675201, '2022-12-14 10:29:02', 1123598821738675201, '2022-12-14 10:29:02', 1602849539512963073, '工位列表', 'workStationIdList', 1, 4, '/api/blade-visual/data-source/workstation', 0, NULL, NULL, 'get'); INSERT INTO blade_interface_config_field (id, status, is_deleted, create_user, create_dept, create_time, update_user, update_time, config_id, label, name, is_required, data_type, data_source, is_single_choice, checked_parent, relation_field, method) VALUES (1602853344312922113, 1, 0, 1123598821738675201, 1123598813738675201, '2022-12-14 10:29:52', 1123598821738675201, '2022-12-14 10:36:19', 1602849539512963073, '查询策略', 'policy', 1, 2, '/api/blade-cps/workstation-wcs-usage/visual-usage-policy', 1, NULL, NULL, 'get'); INSERT INTO blade_interface_config_field (id, status, is_deleted, create_user, create_dept, create_time, update_user, update_time, config_id, label, name, is_required, data_type, data_source, is_single_choice, checked_parent, relation_field, method) VALUES (1602853823713480706, 1, 0, 1123598821738675201, 1123598813738675201, '2022-12-14 10:31:46', 1123598821738675201, '2022-12-14 10:31:46', 1602849539512963073, '近n小时/天', 'timeLevel', 0, 2, '/api/blade-visual/data-source/time-level', 1, NULL, NULL, 'get'); -- 接口权限 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 (1605015416735895553, 1510094368595181569, 'visual_output.get_count_pulse_output', '设备 脉冲 计数 相关数据标签统计', '/blade-visual/output/usage-type', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-20 09:41:10', 1123598821738675201, '2022-12-20 09:41:10', 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 (1605015071330766850, 1475761204784312321, 'workstation_wcs_usage.list', '获取所有数据数据标签数据', '/blade-cps/workstation-wcs-usage/list', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, '2022-12-20 09:39:47', 1123598821738675201, '2022-12-20 09:39:47', 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 (1605015071339155458, 1475761204784312321, 'workstation_wcs_usage.params_config', '获取计算方式的参数配置', '/blade-cps/workstation-wcs-usage/params-config/*', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, '2022-12-20 09:39:47', 1123598821738675201, '2022-12-20 09:39:47', 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 (1605015071347544065, 1475761204784312321, 'workstation_wcs_usage.remove', '删除数据标签', '/blade-cps/workstation-wcs-usage', NULL, NULL, 'DELETE', 1123598821738675201, 1123598813738675201, '2022-12-20 09:39:47', 1123598821738675201, '2022-12-20 09:39:47', 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 (1605015071355932674, 1475761204784312321, 'workstation_wcs_usage.save', '保存数据标签', '/blade-cps/workstation-wcs-usage', NULL, NULL, 'PUT', 1123598821738675201, 1123598813738675201, '2022-12-20 09:39:47', 1123598821738675201, '2022-12-20 09:39:47', 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 (1605015071368515585, 1475761204784312321, 'workstation_wcs_usage.update', '更新数据标签', '/blade-cps/workstation-wcs-usage', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-20 09:39:47', 1123598821738675201, '2022-12-20 09:39:47', 1, 0); DROP TABLE IF EXISTS `blade_fms_real_time_tray`; CREATE TABLE `blade_fms_real_time_tray` ( `id` bigint(20) NOT NULL, `tenant_id` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户', `tray_code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '托盘号', `fixture_id` bigint(128) NULL DEFAULT NULL COMMENT '夹具id', `current_position` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '当前位置', `current_station` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '当前工作台 1,2', `current_type` int(11) NULL DEFAULT NULL COMMENT '当前位置类型 1-库位,2-位置', `target_position` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '目标位置', `target_station` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '目标工作台 1,2', `tray_state` int(11) NULL DEFAULT NULL COMMENT '1-满托,2-空托', `sche_state` int(11) NULL DEFAULT NULL COMMENT '调度状态 1-将要去,2-到达', `arrive_time` datetime(0) NULL DEFAULT NULL COMMENT '到达时间 异常不更新', `status` int(11) NULL DEFAULT NULL COMMENT '业务状态', `order_id` bigint(20) NULL DEFAULT NULL COMMENT '工单ID', `order_code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工单号', `order_process_id` bigint(20) NULL DEFAULT NULL COMMENT '工单工序ID', `process_code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工序号', `program_no` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '程序号', `program_offset` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '程序偏移', `will_order_id` bigint(20) NULL DEFAULT NULL COMMENT '将要去的工单ID', `will_order_code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '将要去的工单', `will_order_process_id` bigint(20) NULL DEFAULT NULL COMMENT '将要去的工单工序ID', `will_process_code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '将要去的工序', `will_program_no` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '将要去的程序号', `will_program_offset` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '将要去的程序偏移', `part_type` tinyint(4) NULL DEFAULT NULL COMMENT '产品状态 1-待加工,2-加工中,3-加工完成,4-半成品,5-不合格品', `part_type_time` datetime(0) NULL DEFAULT NULL COMMENT '状态改变时间', `components_number` bigint(20) NULL DEFAULT NULL COMMENT '当前工件号', `last_load_complete_time` datetime(0) NULL DEFAULT NULL COMMENT '上一次装料完成时间', `last_cnc_complete_time` datetime(0) NULL DEFAULT NULL COMMENT '上一次加工完成时间', `is_deleted` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '删除标记：0-未删除，1-已删除', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建部门', `is_first_empty_return` tinyint(4) NULL DEFAULT NULL COMMENT '是否首序空托返回', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '托盘实时数据' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_andon_record`; CREATE TABLE `blade_andon_record` ( `id` bigint(20) NOT NULL COMMENT '主键', `status` tinyint(4) DEFAULT NULL COMMENT '状态', `is_deleted` int(11) DEFAULT '0' COMMENT '删除状态：0-未删除，1-已删除', `create_user` bigint(20) DEFAULT NULL COMMENT '创建人', `create_dept` bigint(20) DEFAULT NULL COMMENT '创建部门', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_user` bigint(20) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `type_id` bigint(20) DEFAULT NULL COMMENT '安灯类型id', `type_code` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '安灯类型编号', `type_name` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '安灯类型名称', `reason_id` bigint(20) DEFAULT NULL COMMENT '安灯原因id', `reason_code` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '安灯原因编号', `reason_name` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '安灯原因名称', `workstation_id` bigint(20) DEFAULT NULL COMMENT '工位id', `workstation_name` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '工位名称', `workstation_code` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '工位编号', `call_emp_id` bigint(20) DEFAULT NULL COMMENT '呼叫人员id', `call_emp_code` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '呼叫人员编号', `call_emp_name` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '呼叫人员名称', `hand_emp_id` bigint(20) DEFAULT NULL COMMENT '处理人员id', `hand_emp_code` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '处理人员编号', `hand_emp_name` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '处理人员名称', `complete_emp_id` bigint(20) DEFAULT NULL COMMENT '完成人员id', `complete_emp_code` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '完成人员编号', `complete_emp_name` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '完成人员名称', `call_time` datetime DEFAULT NULL COMMENT '呼叫时间(开始时间)', `response_time` datetime DEFAULT NULL COMMENT '响应时间', `end_time` datetime DEFAULT NULL COMMENT '结束时间', `remark` varchar(140) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注', `cur_status` tinyint(4) DEFAULT '0' COMMENT '当前状态 0-当前无状态 1-已发起，待接收 2-已接收，待完成 3-完成', `shift_index` int(11) DEFAULT NULL COMMENT '所在班次', `index_name` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '班次名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='安灯原因表'; CREATE TABLE `blade_device_andon_type` ( `id` bigint(20) NOT NULL COMMENT '主键', `status` tinyint(4) DEFAULT NULL COMMENT '状态', `is_deleted` int(11) DEFAULT '0' COMMENT '删除状态：0-未删除，1-已删除', `create_user` bigint(20) DEFAULT NULL COMMENT '创建人', `create_dept` bigint(20) DEFAULT NULL COMMENT '创建部门', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_user` bigint(20) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `andon_type_id` bigint(20) DEFAULT NULL COMMENT '安灯类型id', `device_type_id` bigint(20) DEFAULT NULL COMMENT '机器类型id', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='机器类型安灯类型关联表';