/*
 Navicat Premium Dump SQL

 Source Server Type    : MySQL

 Date: 26/11/2024 10:23:10
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for base_line
-- ----------------------------
DROP TABLE IF EXISTS `base_line`;
CREATE TABLE `base_line`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '产线编码',
  `Name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '产线名称',
  `WorkshopId` int NOT NULL COMMENT '所属车间Id',
  `Description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '产线描述',
  `CreateId` int NOT NULL COMMENT '创建人',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `UpdateId` int NULL DEFAULT NULL COMMENT '修改人',
  `UpdateTime` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `IsDeleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0:未删除  1:已删除',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '产线表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for base_workshop
-- ----------------------------
DROP TABLE IF EXISTS `base_workshop`;
CREATE TABLE `base_workshop`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '车间编码',
  `Name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '车间名称',
  `Description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '描述',
  `CreateId` int NOT NULL COMMENT '创建人',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `UpdateId` int NULL DEFAULT NULL COMMENT '修改人',
  `UpdateTime` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `IsDeleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0:未删除  1:已删除',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '车间表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for base_workstation
-- ----------------------------
DROP TABLE IF EXISTS `base_workstation`;
CREATE TABLE `base_workstation`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '工位编码',
  `Name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '工位名称',
  `ProcessOperationId` int NOT NULL COMMENT '工序Id',
  `LineId` int NOT NULL COMMENT '产线Id',
  `Description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '描述',
  `CreateId` int NOT NULL COMMENT '创建人',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `UpdateId` int NULL DEFAULT NULL COMMENT '修改人',
  `UpdateTime` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `IsDeleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0:未删除  1:已删除',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '工位表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for base_workstation_and_user
-- ----------------------------
DROP TABLE IF EXISTS `base_workstation_and_user`;
CREATE TABLE `base_workstation_and_user`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `WorkstationId` int NOT NULL COMMENT '工位Id',
  `SysUserId` int NOT NULL COMMENT '用户Id',
  `CreateId` int NOT NULL COMMENT '创建人',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `UpdateId` int NULL DEFAULT NULL COMMENT '修改人',
  `UpdateTime` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `IsDeleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0:未删除  1:已删除',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '工位和人员关系表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for process_operation
-- ----------------------------
DROP TABLE IF EXISTS `process_operation`;
CREATE TABLE `process_operation`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '工序编码',
  `Name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '工序名称',
  `Type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '类型(映射字典表)',
  `Description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '描述',
  `CreateId` int NOT NULL COMMENT '创建人',
  `CreateTime` datetime NOT NULL COMMENT '创建时间',
  `UpdateId` int NULL DEFAULT NULL COMMENT '修改人',
  `UpdateTime` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `IsDeleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0:未删除  1:已删除',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 36 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '工序表' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;