/*
|
Navicat Premium Data Transfer
|
|
Source Server : 本地MySQL
|
Source Server Type : MySQL
|
Source Server Version : 80032 (8.0.32)
|
Source Host : localhost:3306
|
Source Schema : wms
|
|
Target Server Type : MySQL
|
Target Server Version : 80032 (8.0.32)
|
File Encoding : 65001
|
|
Date: 13/11/2024 11:17:16
|
*/
|
|
SET NAMES utf8mb4;
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
-- ----------------------------
|
-- Table structure for order_information
|
-- ----------------------------
|
DROP TABLE IF EXISTS `order_information`;
|
CREATE TABLE `order_information` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '序号',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '订单号',
|
`customer_order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '客户订单号',
|
`create_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '出库时间',
|
`customer_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '客户名称',
|
`consignor` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '发货人',
|
`arrival_address` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '到货地址',
|
`receiving_contact` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '收货联系人',
|
`cell_phone_number` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '手机号',
|
`is_delete` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of order_information
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for out_product
|
-- ----------------------------
|
DROP TABLE IF EXISTS `out_product`;
|
CREATE TABLE `out_product` (
|
`id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '出库ID',
|
`unit` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '单位',
|
`outbound_quantity` int NOT NULL COMMENT '出库数量',
|
`out_person` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '发货人',
|
`create_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '发货日期',
|
`product_name_id` int NOT NULL COMMENT '产品名称ID',
|
`product_model_id` int NOT NULL COMMENT '规格型号ID',
|
`order_information_id` int NOT NULL COMMENT '订单信息ID',
|
`add_Time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '入库时间',
|
`is_delete` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of out_product
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for product
|
-- ----------------------------
|
DROP TABLE IF EXISTS `product`;
|
CREATE TABLE `product` (
|
`id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '产品数据库ID',
|
`unit` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '单位',
|
`incoming_quantity` int NOT NULL COMMENT '入库数量',
|
`add_person` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '入库人',
|
`create_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '入库时间',
|
`product_name_id` int NOT NULL COMMENT '设备名称ID',
|
`product_model_id` int NOT NULL COMMENT '设备型号ID',
|
`is_delete` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of product
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for product_model
|
-- ----------------------------
|
DROP TABLE IF EXISTS `product_model`;
|
CREATE TABLE `product_model` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
`product_model` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '型号',
|
`product_name_id` int NOT NULL COMMENT '库存名称id',
|
`product_code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '产品编码',
|
`is_delete` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE INDEX `unique`(`product_code` ASC) USING BTREE COMMENT '产品编码唯一约束'
|
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of product_model
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for product_name
|
-- ----------------------------
|
DROP TABLE IF EXISTS `product_name`;
|
CREATE TABLE `product_name` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键Id',
|
`product_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '产品名称',
|
`is_delete` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`create_time` datetime NULL DEFAULT NULL,
|
`update_time` datetime NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of product_name
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for user
|
-- ----------------------------
|
DROP TABLE IF EXISTS `user`;
|
CREATE TABLE `user` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '用户表格',
|
`username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称',
|
`account` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '账号',
|
`password` varchar(33) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '密码',
|
`salt` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '数据库保存加密盐',
|
`avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '头像',
|
`authority` bigint NOT NULL COMMENT '权限',
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE INDEX `account`(`account` ASC) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of user
|
-- ----------------------------
|
INSERT INTO `user` VALUES (1, '管理员账号', 'admin', 'e4a5020448006e3e145e3781d6e4b403', 'AF5ieE-;bj', '/defaultAvatar.png', 1);
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
