MES开发第三天

今天对数据库表进行编写，
sql代码如下：
  1 /*
  2  Navicat Premium Data Transfer
  3 
  4  Source Server         : localhost_3306
  5  Source Server Type    : MySQL
  6  Source Server Version : 80034 (8.0.34)
  7  Source Host           : localhost:3306
  8  Source Schema         : muju
  9 
 10  Target Server Type    : MySQL
 11  Target Server Version : 80034 (8.0.34)
 12  File Encoding         : 65001
 13 
 14  Date: 02/01/2025 10:25:12
 15 */
 16 
 17 SET NAMES utf8mb4;
 18 SET FOREIGN_KEY_CHECKS = 0;
 19 
 20 -- ----------------------------
 21 -- Table structure for material_outbound
 22 -- ----------------------------
 23 DROP TABLE IF EXISTS `material_outbound`;
 24 CREATE TABLE `material_outbound`  (
 25   `outbound_id` int NOT NULL AUTO_INCREMENT COMMENT '出库单编号',
 26   `material_id` int NOT NULL COMMENT '物料编号',
 27   `material_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '物料名称',
 28   `outbound_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '出库时间',
 29   `outbound_quantity` int NOT NULL COMMENT '出库数量',
 30   `recipient` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '接收人',
 31   `batch_no` int NOT NULL COMMENT '批次号',
 32   `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
 33   PRIMARY KEY (`outbound_id`) USING BTREE
 34 ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
 35 
 36 -- ----------------------------
 37 -- Table structure for materials
 38 -- ----------------------------
 39 DROP TABLE IF EXISTS `materials`;
 40 CREATE TABLE `materials`  (
 41   `material_id` int NOT NULL AUTO_INCREMENT COMMENT '物料编号（主键）',
 42   `material_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '物料名称',
 43   `quantity` int NOT NULL COMMENT '物料可用数量',
 44   PRIMARY KEY (`material_id`) USING BTREE
 45 ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
 46 
 47 -- ----------------------------
 48 -- Table structure for process_transfer
 49 -- ----------------------------
 50 DROP TABLE IF EXISTS `process_transfer`;
 51 CREATE TABLE `process_transfer`  (
 52   `transfer_id` int NOT NULL AUTO_INCREMENT COMMENT '交接单编号',
 53   `process_id` int NULL DEFAULT NULL COMMENT '工序的id',
 54   `process_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '工序的名称',
 55   `batch_no` int NOT NULL COMMENT '生产批次号',
 56   `product_id` int NULL DEFAULT NULL COMMENT '产品编号',
 57   `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '产品名称',
 58   `transfer_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '交接时间',
 59   `handover_person` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '交接人',
 60   `receiver_person` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '接收人',
 61   `transfer_quantity` int NOT NULL COMMENT '交接数量',
 62   `qualified_quantity` int NOT NULL COMMENT '合格数量',
 63   `unqualified_quantity` int NOT NULL COMMENT '不合格数量',
 64   `unqualified_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '不合格原因',
 65   `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
 66   `this_process` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '本次工序',
 67   `next_process` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '下道工序',
 68   PRIMARY KEY (`transfer_id`) USING BTREE
 69 ) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
 70 
 71 -- ----------------------------
 72 -- Table structure for production_batch
 73 -- ----------------------------
 74 DROP TABLE IF EXISTS `production_batch`;
 75 CREATE TABLE `production_batch`  (
 76   `batch_no` int NOT NULL AUTO_INCREMENT COMMENT '批次编号',
 77   `product_id` int NOT NULL COMMENT '生产产品编号',
 78   `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '生产产品名称',
 79   `planned_quantity` int NOT NULL COMMENT '计划生产数量',
 80   `actual_quantity` int NULL DEFAULT NULL COMMENT '实际生产数量',
 81   `production_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '未开始' COMMENT '生产状态（未开始，生产中，暂停，已完成）',
 82   `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
 83   PRIMARY KEY (`batch_no`) USING BTREE
 84 ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
 85 
 86 -- ----------------------------
 87 -- Table structure for production_task
 88 -- ----------------------------
 89 DROP TABLE IF EXISTS `production_task`;
 90 CREATE TABLE `production_task`  (
 91   `task_id` int NOT NULL AUTO_INCREMENT,
 92   `batch_code` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
 93   `customer_code` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
 94   `product_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
 95   `quantity` int NOT NULL,
 96   `process_description` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
 97   `status` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT '任务状态',
 98   `created_at` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT '创建时间',
 99   `updated_at` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT '更新时间',
100   PRIMARY KEY (`task_id`) USING BTREE
101 ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
102 
103 -- ----------------------------
104 -- Table structure for users
105 -- ----------------------------
106 DROP TABLE IF EXISTS `users`;
107 CREATE TABLE `users`  (
108   `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
109   `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL
110 ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
111 
112 SET FOREIGN_KEY_CHECKS = 1;
posted @ 2024-09-30 11:15 连师傅只会helloword 阅读(7) 评论(0) 收藏举报
刷新页面返回顶部
MES开发第三天

公告
