/*
 Navicat Premium Data Transfer

 Source Server         : admin
 Source Server Type    : MySQL
 Source Server Version : 80032 (8.0.32)
 Source Host           : localhost:3306
 Source Schema         : carbon

 Target Server Type    : MySQL
 Target Server Version : 80032 (8.0.32)
 File Encoding         : 65001

 Date: 21/10/2023 13:39:32
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for delivery_order
-- ----------------------------
DROP TABLE IF EXISTS `delivery_order`;
CREATE TABLE `delivery_order`  (
  `id` bigint NOT NULL COMMENT '发货单号',
  `delivery_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发货编号',
  `contract_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '合同编号',
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户名称',
  `delivery_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '送货方式',
  `delivery_date` datetime NULL DEFAULT NULL COMMENT '交货日期',
  `shipping_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '收货地址',
  `contact_person` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系人',
  `contact_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `outbound_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '出库状态(0未出库 1已出库)',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` int NULL DEFAULT 0 COMMENT '0 未删除(默认), 1 已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '发货单' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of delivery_order
-- ----------------------------
INSERT INTO `delivery_order` VALUES (1, '1927272218', '0625974160', '侯岚', '快递', '2023-10-20 07:31:47', '成都市', 'czl1', '172-5831-7231', '0', '2023-10-20 21:04:00', '2023-10-20 15:44:12', 0);
INSERT INTO `delivery_order` VALUES (2, '0053353796', '0481886966', '郝杰宏', '快递', '2023-10-20 23:31:16', '上海市', 'czl1', '21-968-1425', '0', '2023-10-20 02:35:41', '2023-10-20 15:44:12', 0);
INSERT INTO `delivery_order` VALUES (3, '1520489915', '6840193166', '毛晓明', '快递', '2023-10-20 19:10:00', '深圳', 'czl1', '144-8584-9287', '0', '2023-10-20 23:14:48', '2023-10-20 15:44:12', 0);
INSERT INTO `delivery_order` VALUES (4, '1450266170', '5449864591', '唐岚', '快递', '2023-10-20 21:06:50', '成都市', 'czl1', '145-3686-9730', '1', '2023-10-20 04:09:51', '2023-10-20 15:44:12', 0);
INSERT INTO `delivery_order` VALUES (5, '9043280659', '4234713980', '冯秀英', '快递', '2023-10-20 05:13:40', '成都市', 'czl1', '199-0992-2293', '1', '2023-10-20 00:13:51', '2023-10-20 15:44:12', 0);
INSERT INTO `delivery_order` VALUES (6, '2699696522', '3624282666', '林詩涵', '快递', '2023-10-20 12:32:29', '中山', 'czl1', '760-4299-7287', '0', '2023-10-20 12:56:18', '2023-10-20 15:44:12', 0);
INSERT INTO `delivery_order` VALUES (7, '9993999364', '2949671500', '陈睿', '快递', '2023-10-20 06:12:39', '北京市', 'czl1', '10-808-8847', '0', '2023-10-20 14:41:37', '2023-10-20 15:44:12', 0);
INSERT INTO `delivery_order` VALUES (8, '8672302790', '9178919045', '徐睿', '快递', '2023-10-20 10:41:33', '上海市', 'czl1', '167-9103-7869', '0', '2023-10-20 01:24:06', '2023-10-20 15:44:12', 0);
INSERT INTO `delivery_order` VALUES (9, '3320022712', '2699584888', '金子异', '快递', '2023-10-20 11:16:43', '深圳', 'czl1', '755-7562-4597', '1', '2023-10-20 17:56:24', '2023-10-20 15:44:12', 0);
INSERT INTO `delivery_order` VALUES (10, '1117346715', '0167643940', '沈宇宁', '快递', '2023-10-20 15:23:12', '中山', 'czl1', '134-6489-1788', '0', '2023-10-20 23:55:53', '2023-10-20 15:44:12', 0);
INSERT INTO `delivery_order` VALUES (11, '7793232197', '7444779042', '任詩涵', '快递', '2023-10-20 14:11:05', '北京市', 'czl1', '10-3771-6626', '1', '2023-10-20 22:15:41', '2023-10-20 15:44:12', 0);
INSERT INTO `delivery_order` VALUES (12, '6756676718', '9545738147', '黄岚', '快递', '2023-10-20 14:00:30', '北京市', 'czl1', '10-385-1891', '1', '2023-10-20 14:40:15', '2023-10-20 15:44:12', 0);
INSERT INTO `delivery_order` VALUES (13, '4203549247', '2615535897', '余子异', '快递', '2023-10-20 01:54:14', '成都市', 'czl1', '191-7320-9333', '1', '2023-10-20 07:47:59', '2023-10-20 15:44:12', 0);
INSERT INTO `delivery_order` VALUES (14, '4227347803', '6741618006', '石晓明', '快递', '2023-10-20 09:07:25', '深圳', 'czl1', '755-117-4651', '0', '2023-10-20 16:41:50', '2023-10-20 15:44:12', 0);
INSERT INTO `delivery_order` VALUES (15, '7693329456', '7421104817', '林子异', '快递', '2023-10-20 08:54:38', '深圳', 'czl1', '755-526-1023', '1', '2023-10-20 04:40:13', '2023-10-20 15:44:12', 0);
INSERT INTO `delivery_order` VALUES (17, '13241234', '341341', 'test', 'test', '2023-10-21 00:45:03', 'test', 'czl', '32143124', '0', '2023-10-21 00:45:16', '2023-10-21 00:45:20', 0);
INSERT INTO `delivery_order` VALUES (1715396941852532736, '232123242', '123131', 'czl1', '快递1', '2023-10-20 05:13:40', '漳州', 'czl', '132059684154', '0', '2023-10-20 23:57:56', '2023-10-20 23:59:31', 0);

-- ----------------------------
-- Table structure for device
-- ----------------------------
DROP TABLE IF EXISTS `device`;
CREATE TABLE `device`  (
  `id` bigint NOT NULL COMMENT '编号',
  `device_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '设备名称',
  `encoding` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编码',
  `version` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '型号',
  `production_date` datetime NULL DEFAULT NULL COMMENT '生产日期',
  `batch_no` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生产批号',
  `maker` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '制造商',
  `status` int NULL DEFAULT 0 COMMENT '设备状态 0 空闲(默认),1 使用中,2 故障',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` int NULL DEFAULT 0 COMMENT '0 未删除(默认), 1 已删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `encoding`(`encoding` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '设备信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of device
-- ----------------------------
INSERT INTO `device` VALUES (16273485123456789, '机床A', 'MC001', 'XYZ-100', '2021-05-10 00:00:00', '20210510', 'ABC设备公司', 0, '用于金属加工', '2023-07-20 10:15:32', '2023-07-20 10:15:32', 0);
INSERT INTO `device` VALUES (16273485123456790, '注塑机B', 'IM002', 'PQ-200', '2022-01-15 00:00:00', '20220115', 'XYZ塑料公司', 1, '用于塑料注塑', '2023-07-21 11:25:43', '2023-07-21 11:25:43', 0);
INSERT INTO `device` VALUES (16273485123456791, '激光切割机', 'LC003', 'LM-500', '2022-06-20 00:00:00', '20220620', 'DEF激光公司', 0, '用于金属切割', '2023-07-22 12:35:54', '2023-07-22 12:35:54', 0);
INSERT INTO `device` VALUES (16273485123456792, '压力机A', 'PR001', 'PS-300', '2021-09-08 00:00:00', '20210908', 'GHI压力机公司', 2, '故障，待维修', '2023-07-23 13:46:05', '2023-07-23 13:46:05', 0);
INSERT INTO `device` VALUES (16273485123456793, '印刷机C', 'PM004', 'PR-1500', '2020-11-30 00:00:00', '20201130', 'JKL印刷公司', 1, '用于印刷纸张', '2023-07-24 14:56:16', '2023-07-24 14:56:16', 0);
INSERT INTO `device` VALUES (16273485123456794, '电焊机A', 'WE007', 'W-200', '2022-04-25 00:00:00', '20220425', 'MNO焊接公司', 0, '用于金属焊接', '2023-07-25 15:15:32', '2023-07-25 15:15:32', 0);
INSERT INTO `device` VALUES (16273485123456795, '注塑机C', 'IM004', 'PQ-300', '2023-01-05 00:00:00', '20230105', 'XYZ塑料公司', 0, '用于塑料注塑', '2023-07-26 16:25:43', '2023-07-26 16:25:43', 0);
INSERT INTO `device` VALUES (16273485123456796, '冲床B', 'PC002', 'CC-250', '2022-07-18 00:00:00', '20220718', 'PQR冲压公司', 1, '用于金属冲压', '2023-07-27 17:35:54', '2023-07-27 17:35:54', 0);
INSERT INTO `device` VALUES (16273485123456797, '数控车床A', 'NC006', 'CNC-400', '2021-11-12 00:00:00', '20211112', 'STU数控公司', 1, '用于零件加工', '2023-07-28 18:46:05', '2023-07-28 18:46:05', 0);
INSERT INTO `device` VALUES (16273485123456798, '注塑机D', 'IM006', 'PQ-400', '2023-03-29 00:00:00', '20230329', 'XYZ塑料公司', 0, '用于塑料注塑', '2023-07-29 19:56:16', '2023-07-29 19:56:16', 0);
INSERT INTO `device` VALUES (16273485123456799, '涂装线', 'PL005', 'PT-800', '2022-09-28 00:00:00', '20220928', 'VWX涂装公司', 0, '用于产品涂装', '2023-07-30 20:15:32', '2023-07-30 20:15:32', 0);
INSERT INTO `device` VALUES (16273485123456800, '车身焊接机', 'WW009', 'WH-600', '2022-12-10 00:00:00', '20221210', 'MNO焊接公司', 2, '故障，待维修', '2023-07-31 21:25:43', '2023-07-31 21:25:43', 0);
INSERT INTO `device` VALUES (16273485123456801, '数控车床B', 'NC008', 'CNC-500', '2023-02-15 00:00:00', '20230215', 'STU数控公司', 1, '用于零件加工', '2023-08-01 22:35:54', '2023-08-01 22:35:54', 0);
INSERT INTO `device` VALUES (16273485123456802, '激光焊接机', 'LW007', 'LW-350', '2021-08-22 00:00:00', '20210822', 'DEF激光公司', 0, '用于金属焊接', '2023-08-02 23:46:05', '2023-08-02 23:46:05', 0);
INSERT INTO `device` VALUES (16273485123456803, '注塑机E', 'IM009', 'PQ-600', '2022-11-05 00:00:00', '20221105', 'XYZ塑料公司', 1, '用于塑料注塑', '2023-08-03 00:56:16', '2023-08-03 00:56:16', 0);
INSERT INTO `device` VALUES (1683727583081697280, '金刚钻', 'JG189', 'JG-123', '2023-07-25 14:35:13', '20230725', 'TD金刚公司', 0, '硬的一批', '2023-07-25 14:35:13', '2023-07-25 14:45:27', 0);
INSERT INTO `device` VALUES (1683728234088022016, '金刚钻2', 'JG1812-1685183402839179264', 'JG-133', '2023-07-25 14:37:48', '20230725', '金刚公司', 0, '硬的一批', '2023-07-25 14:37:48', '2023-07-29 15:00:07', 1);
INSERT INTO `device` VALUES (1683746424373444608, '破山机', 'JG1812', NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-25 15:50:04', '2023-07-29 15:01:30', 0);
INSERT INTO `device` VALUES (1683748274313166848, '破山机123', 'JG181', 'YY-123', '2023-07-25 14:14:14', '20230725', '白山公司', 1, '没有捏', '2023-07-25 15:57:25', '2023-07-25 21:01:42', 0);
INSERT INTO `device` VALUES (1683824972694061056, '压力机', '-1685183548670935040', '', '2021-11-10 12:00:00', '', '', 0, '', '2023-07-25 21:02:12', '2023-07-29 15:00:41', 1);

-- ----------------------------
-- Table structure for early_warning
-- ----------------------------
DROP TABLE IF EXISTS `early_warning`;
CREATE TABLE `early_warning`  (
  `id` bigint NOT NULL COMMENT '编号',
  `monitoring_point_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '监测点名称',
  `monitoring_point_address` varchar(240) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '监测点地址',
  `realtime_power` decimal(10, 3) NOT NULL COMMENT '实时功率',
  `realtime_voltage` decimal(10, 3) NOT NULL COMMENT '实时电压',
  `status` int NOT NULL DEFAULT 0 COMMENT '状态 0 正常(默认),1 功率过载,2 电压异常',
  `reported_time` datetime NULL DEFAULT NULL COMMENT '上报时间',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` int NULL DEFAULT 0 COMMENT '0 未删除(默认), 1 已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '能效预警表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of early_warning
-- ----------------------------
INSERT INTO `early_warning` VALUES (16273485123456789, '电力公司总部', '北京市朝阳区CBD', 1500.000, 220.000, 0, '2023-07-20 10:15:32', '正常', '2023-07-20 10:15:32', '2023-07-20 10:15:32', 0);
INSERT INTO `early_warning` VALUES (16273485123456790, '工业园区A监测点', '上海市黄浦区南京东路', 1200.000, 230.000, 1, '2023-07-20 11:25:43', '警告：功率过载', '2023-07-20 11:25:43', '2023-07-20 11:25:43', 0);
INSERT INTO `early_warning` VALUES (16273485123456791, '商业中心B监测点', '广州市天河区珠江新城', 800.000, 215.000, 0, '2023-07-20 12:35:54', '正常', '2023-07-20 12:35:54', '2023-07-20 12:35:54', 0);
INSERT INTO `early_warning` VALUES (16273485123456792, '科技园D区监测点', '深圳市福田区华强北', 500.000, 210.000, 0, '2023-07-20 13:46:05', '正常', '2023-07-20 13:46:05', '2023-07-20 13:46:05', 0);
INSERT INTO `early_warning` VALUES (16273485123456793, '医院大楼E监测点', '成都市武侯区锦绣路', 1800.000, 225.000, 2, '2023-07-20 14:56:16', '错误：电压异常', '2023-07-20 14:56:16', '2023-07-20 14:56:16', 0);
INSERT INTO `early_warning` VALUES (16273485123456794, '购物中心F监测点', '重庆市渝中区解放碑', 1400.000, 230.000, 0, '2023-07-20 15:15:32', '正常', '2023-07-20 15:15:32', '2023-07-20 15:15:32', 0);
INSERT INTO `early_warning` VALUES (16273485123456795, '公园景区G监测点', '杭州市西湖区西湖景区', 1000.000, 220.000, 0, '2023-07-20 16:25:43', '正常', '2023-07-20 16:25:43', '2023-07-20 16:25:43', 0);
INSERT INTO `early_warning` VALUES (16273485123456796, '大学校区H监测点', '南京市鼓楼区中山陵', 2200.000, 215.000, 0, '2023-07-20 17:35:54', '正常', '2023-07-20 17:35:54', '2023-07-20 17:35:54', 0);
INSERT INTO `early_warning` VALUES (16273485123456797, '写字楼I监测点', '苏州市姑苏区拙政园', 750.000, 210.000, 0, '2023-07-20 18:46:05', '正常', '2023-07-20 18:46:05', '2023-07-20 18:46:05', 0);
INSERT INTO `early_warning` VALUES (16273485123456798, '工业园区J监测点', '西安市莲湖区钟楼', 900.000, 225.000, 2, '2023-07-20 19:56:16', '警告：电压过高', '2023-07-20 19:56:16', '2023-07-20 19:56:16', 0);
INSERT INTO `early_warning` VALUES (16273485123456799, '医学院K监测点', '武汉市江汉区江滩', 1100.000, 230.000, 0, '2023-07-20 20:15:32', '正常', '2023-07-20 20:15:32', '2023-07-20 20:15:32', 0);
INSERT INTO `early_warning` VALUES (16273485123456800, '购物中心L监测点', '天津市和平区意式风情街', 600.000, 220.000, 0, '2023-07-20 21:25:43', '正常', '2023-07-20 21:25:43', '2023-07-20 21:25:43', 0);
INSERT INTO `early_warning` VALUES (16273485123456801, '科技园M区监测点', '长沙市芙蓉区岳麓山', 1700.000, 215.000, 0, '2023-07-20 22:35:54', '正常', '2023-07-20 22:35:54', '2023-07-20 22:35:54', 0);
INSERT INTO `early_warning` VALUES (16273485123456802, '商业中心N监测点', '南宁市青秀区明秀路', 800.000, 225.000, 0, '2023-07-20 23:46:05', '正常', '2023-07-20 23:46:05', '2023-07-20 23:46:05', 0);
INSERT INTO `early_warning` VALUES (16273485123456803, '医院大楼O监测点', '厦门市思明区中山路', 950.000, 210.000, 0, '2023-07-21 00:56:16', '正常', '2023-07-21 00:56:16', '2023-07-21 00:56:16', 0);
INSERT INTO `early_warning` VALUES (1682231570227605504, '秦始皇陵', '陕西省西安市以东35公里的临潼区骊山北麓', 1200.000, 240.000, 0, '2023-07-21 11:30:35', '正常', '2023-07-21 11:30:35', '2023-07-21 11:30:35', 0);
INSERT INTO `early_warning` VALUES (1682233739949408256, '秦始皇陵-主陵墓', '陕西省西安市以东35公里的临潼区骊山北麓', 1200.000, 240.000, 0, '2023-07-21 11:39:13', '打钱', '2023-07-21 11:39:13', '2023-07-21 11:44:51', 0);
INSERT INTO `early_warning` VALUES (1682269981609054208, '明皇陵', '安徽省凤阳县城南七公里处', 1300.000, 210.000, 0, '2023-07-21 13:15:14', '正常', '2023-07-21 14:03:13', '2023-07-21 14:08:40', 0);
INSERT INTO `early_warning` VALUES (1682270022444797952, '明皇陵', '安徽省凤阳县城南七公里处', 1320.000, 210.000, 0, '2023-07-21 13:15:14', '不知道', '2023-07-21 14:03:23', '2023-07-24 15:12:58', 0);
INSERT INTO `early_warning` VALUES (1683380831396872192, '黑天遗址', '无期界断空山离庆洞府', 1300.000, 120.000, 0, '2023-07-25 12:00:00', '正常', '2023-07-24 15:37:20', '2023-07-24 20:10:57', 1);
INSERT INTO `early_warning` VALUES (1683381184532103168, '黑天遗址12', '破空界五行山', 120.000, 120.000, 0, '2023-07-24 20:44:53', '正常', '2023-07-24 15:38:44', '2023-07-25 12:19:15', 0);
INSERT INTO `early_warning` VALUES (1683451562579210240, '测试', '测试', 1200.000, 10.000, 0, '2023-07-24 20:18:19', '正常', '2023-07-24 20:18:24', '2023-07-24 20:18:38', 1);
INSERT INTO `early_warning` VALUES (1683719478688112640, '111', '111', 111.000, 111.000, 1, '2023-07-25 14:02:57', '111', '2023-07-25 14:03:00', '2023-07-25 14:04:36', 0);
INSERT INTO `early_warning` VALUES (1683719945694547968, '222', '222', 222.000, 222.000, 0, '2023-07-25 14:04:49', '22', '2023-07-25 14:04:51', '2023-07-26 12:45:24', 0);

-- ----------------------------
-- Table structure for factory_detail
-- ----------------------------
DROP TABLE IF EXISTS `factory_detail`;
CREATE TABLE `factory_detail`  (
  `id` bigint NOT NULL COMMENT '编号',
  `factory_id` bigint NULL DEFAULT NULL COMMENT '工厂建模id',
  `record_id` bigint NULL DEFAULT NULL COMMENT '物料档案id',
  `device_id` bigint NOT NULL COMMENT '设备信息id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` int NULL DEFAULT 0 COMMENT '0 未删除(默认), 1 已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工厂建模明细表(关联表)' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of factory_detail
-- ----------------------------
INSERT INTO `factory_detail` VALUES (16273485123456789, 16273485123456789, 16273485123456789, 16273485123456789, '2023-08-02 13:04:02', '2023-08-02 13:04:10', 0);
INSERT INTO `factory_detail` VALUES (16273485123456790, 16273485123456790, 16273485123456791, 16273485123456790, '2023-08-02 13:05:36', '2023-08-02 13:05:38', 0);
INSERT INTO `factory_detail` VALUES (16273485123456791, 16273485123456791, 16273485123456801, 16273485123456791, '2023-08-02 13:06:52', '2023-08-02 13:06:55', 0);
INSERT INTO `factory_detail` VALUES (1627348512345678912, 16273485123456789, 16273485123456789, 16273485123456791, '2023-08-04 14:05:17', '2023-08-04 14:05:19', 0);
INSERT INTO `factory_detail` VALUES (1687738607938134016, 1687738606281383936, 16273485123456789, 16273485123456789, '2023-08-05 16:13:35', '2023-08-05 17:03:12', 1);
INSERT INTO `factory_detail` VALUES (1687738607946522624, 1687738606281383936, 16273485123456789, 16273485123456790, '2023-08-05 16:13:35', '2023-08-05 17:03:12', 1);
INSERT INTO `factory_detail` VALUES (1689165336405643264, 1689165357628821504, 16273485123456796, 16273485123456791, '2023-08-09 14:42:54', '2023-08-09 17:22:34', 1);
INSERT INTO `factory_detail` VALUES (1689165347847704576, 1689165357628821504, 16273485123456796, 16273485123456793, '2023-08-09 14:42:56', '2023-08-09 17:25:30', 1);
INSERT INTO `factory_detail` VALUES (1689206314025967616, NULL, NULL, 16273485123456798, '2023-08-09 17:25:43', '2023-08-09 17:25:43', 0);
INSERT INTO `factory_detail` VALUES (1689207538280390656, 1689207565216210944, 16273485123456801, 16273485123456791, '2023-08-09 17:30:35', '2023-08-09 19:38:56', 0);
INSERT INTO `factory_detail` VALUES (1689207556538195968, 1689207565216210944, 16273485123456801, 16273485123456801, '2023-08-09 17:30:40', '2023-08-09 19:38:56', 0);
INSERT INTO `factory_detail` VALUES (1689239817958461440, 1689207565216210944, NULL, 16273485123456799, '2023-08-09 19:38:51', '2023-08-09 19:38:56', 0);
INSERT INTO `factory_detail` VALUES (1714108532680114176, NULL, NULL, 16273485123456794, '2023-10-17 10:38:15', '2023-10-17 10:38:15', 0);
INSERT INTO `factory_detail` VALUES (1714137044828897280, NULL, NULL, 16273485123456793, '2023-10-17 12:31:33', '2023-10-17 12:31:33', 0);

-- ----------------------------
-- Table structure for factory_modeling
-- ----------------------------
DROP TABLE IF EXISTS `factory_modeling`;
CREATE TABLE `factory_modeling`  (
  `id` bigint NOT NULL COMMENT '编号',
  `product_line_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '生产线名称',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '描述',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` int NULL DEFAULT 0 COMMENT '0 未删除(默认), 1 已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工厂建模表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of factory_modeling
-- ----------------------------
INSERT INTO `factory_modeling` VALUES (16273485123456789, '装配线1', '用于产品组装', '2023-07-20 10:15:32', '2023-07-20 10:15:32', 0);
INSERT INTO `factory_modeling` VALUES (16273485123456790, '注塑线2', '用于塑料注塑', '2023-07-21 11:25:43', '2023-07-21 11:25:43', 0);
INSERT INTO `factory_modeling` VALUES (16273485123456791, '包装线3', '用于产品包装', '2023-07-22 12:35:54', '2023-07-22 12:35:54', 0);
INSERT INTO `factory_modeling` VALUES (16273485123456792, '焊接线4', '用于金属焊接', '2023-07-23 13:46:05', '2023-07-23 13:46:05', 0);
INSERT INTO `factory_modeling` VALUES (16273485123456793, '喷涂线5', '用于表面喷涂', '2023-07-24 14:56:16', '2023-07-24 14:56:16', 0);
INSERT INTO `factory_modeling` VALUES (16273485123456794, '组装线6', '用于产品组装', '2023-07-25 15:15:32', '2023-07-25 15:15:32', 0);
INSERT INTO `factory_modeling` VALUES (16273485123456795, '包装线7', '用于产品包装', '2023-07-26 16:25:43', '2023-07-26 16:25:43', 0);
INSERT INTO `factory_modeling` VALUES (16273485123456796, '装配线8', '用于产品组装', '2023-07-27 17:35:54', '2023-07-27 17:35:54', 0);
INSERT INTO `factory_modeling` VALUES (16273485123456797, '注塑线9', '用于塑料注塑', '2023-07-28 18:46:05', '2023-07-28 18:46:05', 0);
INSERT INTO `factory_modeling` VALUES (16273485123456798, '打磨线10', '用于产品打磨', '2023-07-29 19:56:16', '2023-07-29 19:56:16', 0);
INSERT INTO `factory_modeling` VALUES (16273485123456799, '喷涂线11', '用于表面喷涂', '2023-07-30 20:15:32', '2023-07-30 20:15:32', 0);
INSERT INTO `factory_modeling` VALUES (16273485123456800, '组装线12', '用于产品组装', '2023-07-31 21:25:43', '2023-07-31 21:25:43', 0);
INSERT INTO `factory_modeling` VALUES (16273485123456801, '包装线13', '用于产品包装', '2023-08-01 22:35:54', '2023-08-01 22:35:54', 0);
INSERT INTO `factory_modeling` VALUES (16273485123456802, '打磨线14', '用于产品打磨', '2023-08-02 23:46:05', '2023-08-02 23:46:05', 0);
INSERT INTO `factory_modeling` VALUES (16273485123456803, '装配线15', '用于产品组装', '2023-08-03 00:56:16', '2023-08-03 00:56:16', 0);
INSERT INTO `factory_modeling` VALUES (1687738606281383936, '测试生产线', '测试哦', '2023-08-05 16:13:35', '2023-08-05 17:03:12', 1);
INSERT INTO `factory_modeling` VALUES (1689160330180866048, '切割线12', '切割的', '2023-08-09 14:23:00', '2023-08-09 19:58:32', 1);
INSERT INTO `factory_modeling` VALUES (1689161527449161728, '切割线BB', '切割线测试2', '2023-08-09 14:27:45', '2023-08-09 14:27:45', 0);
INSERT INTO `factory_modeling` VALUES (1689163282933182464, '切割线CC', '切割测试3', '2023-08-09 14:34:44', '2023-08-09 14:34:44', 0);
INSERT INTO `factory_modeling` VALUES (1689165357628821504, '切割线DD', '切割线测试4', '2023-08-09 14:42:59', '2023-08-09 19:58:20', 1);
INSERT INTO `factory_modeling` VALUES (1689207565216210944, '切割线111112222', '测试呢', '2023-08-09 17:30:42', '2023-08-09 19:38:56', 0);

-- ----------------------------
-- Table structure for inventory_approval
-- ----------------------------
DROP TABLE IF EXISTS `inventory_approval`;
CREATE TABLE `inventory_approval`  (
  `id` bigint NOT NULL COMMENT '申请单号',
  `related_document_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联单据号',
  `business_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '业务类型(0生产入库 1采购入库 2退货入库)',
  `supplier` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '供应商',
  `contract_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '合同号',
  `contract_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '合同类型(0采购合同 1销售合同)',
  `request_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '申请类型',
  `requester` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '申请人',
  `request_date` datetime NOT NULL COMMENT '申请日期',
  `request_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '申请状态(0未提交 1待审核 2已审核)',
  `approver` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核人',
  `approval_date` datetime NOT NULL COMMENT '审核日期',
  `approval_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核状态(0通过 1驳回)',
  `approval_comments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '审核意见',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` int NULL DEFAULT 0 COMMENT '0 未删除(默认), 1 已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '入库申请表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of inventory_approval
-- ----------------------------
INSERT INTO `inventory_approval` VALUES (1, 'bRoFMz2Pgm', '2', '赵記制药有限责任公司', '5MR6ICnfOz', '1', '工业及科学用品', '汤安琪', '2011-03-07 00:00:00', '1', '汤安琪', '2009-03-07 00:00:00', '0', '你干嘛', '2010-08-29 04:30:51', '2013-07-14 16:35:45', 0);
INSERT INTO `inventory_approval` VALUES (2, 'yVCCrGEQOu', '1', '安琪贸易有限责任公司', 'yFxSLmDjW4', '1', '服装，鞋子和珠宝', '黎璐', '2002-08-17 00:00:00', '1', '黎璐', '2015-11-09 00:00:00', '0', '金融服务业', '2014-09-02 11:41:49', '2006-11-20 19:19:48', 0);
INSERT INTO `inventory_approval` VALUES (3, 'PDs6cXREjE', '0', '金記有限责任公司', 'tMQuxOVCNm', '0', '手工制作', '严震南', '2005-04-11 00:00:00', '0', '严震南', '2017-05-31 00:00:00', '0', '贸易行业', '2006-11-10 23:22:48', '2018-08-29 13:52:17', 0);
INSERT INTO `inventory_approval` VALUES (4, 'uZROebxk0X', '2', '秀英有限责任公司', 'hjHEHd0sWg', '0', '工具与家居装饰', '熊杰宏', '2021-10-22 00:00:00', '1', '熊杰宏', '2020-05-09 00:00:00', '0', '工业', '2018-12-27 00:50:22', '2001-05-13 07:35:03', 0);
INSERT INTO `inventory_approval` VALUES (5, 'A0mEF4x9cv', '2', '袁通讯有限责任公司', 'GSC0LH7zXv', '0', '艺术，手工艺品及缝纫', '黄子韬', '2007-12-28 00:00:00', '1', '黄子韬', '2006-12-09 00:00:00', '1', '电讯業', '2021-01-29 15:01:05', '2018-10-30 04:27:13', 0);
INSERT INTO `inventory_approval` VALUES (6, 'br84IYKrTW', '0', '嘉伦食品有限责任公司', 'ASOHB52AlC', '1', '玩具与游戏', '江子异', '2002-02-23 00:00:00', '1', '江子异', '2015-03-01 00:00:00', '1', '饮食业', '2003-04-17 10:03:46', '2022-12-17 01:21:42', 0);
INSERT INTO `inventory_approval` VALUES (7, 'ql0d6utWVO', '1', '邹有限责任公司', 'AoHEBypcVw', '1', '应用程式及游戏', '萧子异', '2023-07-22 00:00:00', '0', '萧子异', '2003-10-14 00:00:00', '0', '金融服务业', '2022-04-03 04:33:20', '2018-12-05 23:29:04', 0);
INSERT INTO `inventory_approval` VALUES (8, 'PoLuQCJMUG', '0', '杰宏有限责任公司', '6XQ0TBAFCX', '1', '服装，鞋子和珠宝', '蒋睿', '2003-09-24 00:00:00', '0', '蒋睿', '2001-11-18 00:00:00', '0', '房地产业', '2007-03-22 18:20:48', '2023-02-22 05:00:16', 0);
INSERT INTO `inventory_approval` VALUES (9, 'yrNXwkEL5G', '1', '贺有限责任公司', 'BCBU2e2WWZ', '1', '保健，家庭及婴儿护理', '蔡詩涵', '2001-12-04 00:00:00', '2', '蔡詩涵', '2019-10-27 00:00:00', '1', '电讯業', '2011-07-02 16:45:54', '2021-11-07 09:46:57', 0);
INSERT INTO `inventory_approval` VALUES (10, 'VAYvmzqnGP', '1', '尹記制药有限责任公司', 'F6wCmhJiwj', '0', '艺术，手工艺品及缝纫', '史睿', '2000-02-15 00:00:00', '2', '史睿', '2013-09-30 00:00:00', '1', '制药业11', '2021-06-24 19:35:47', '2020-01-05 04:06:36', 0);
INSERT INTO `inventory_approval` VALUES (11, 'RmqotIEn5c', '2', '段記工业有限责任公司', 'WJ7lXGvAuL', '1', '手工制作', '夏杰宏', '2021-02-27 00:00:00', '2', '夏杰宏', '2002-06-08 00:00:00', '0', '工业', '2013-10-16 05:53:26', '2018-09-29 13:40:59', 0);
INSERT INTO `inventory_approval` VALUES (12, 'LPr98rWb6V', '1', '子韬顾问有限责任公司', '88pW7fn2rd', '1', '艺术，手工艺品及缝纫', '钟晓明', '2015-10-03 00:00:00', '1', '钟晓明', '2010-08-10 00:00:00', '1', '咨询业', '2013-07-15 01:24:27', '2000-04-23 13:28:46', 0);
INSERT INTO `inventory_approval` VALUES (13, 'ZifAe80Yz1', '1', '田記有限责任公司', '1lyVjkqOH6', '1', '食品', '蔡云熙', '2022-08-10 00:00:00', '1', '蔡云熙', '2000-03-28 00:00:00', '0', '制药业', '2023-07-03 22:11:37', '2018-02-23 19:51:28', 0);
INSERT INTO `inventory_approval` VALUES (14, '4wkNWCBAZ4', '1', '何記工程有限责任公司', 'xQqlclJN9b', '0', '艺术，手工艺品及缝纫', '何秀英', '2003-01-05 00:00:00', '2', '何秀英', '2017-04-01 00:00:00', '1', '工程业', '2005-12-24 23:19:28', '2012-05-17 13:22:05', 0);
INSERT INTO `inventory_approval` VALUES (15, 'AmlbCl234N', '2', '詩涵发展贸易有限责任公司', 'c8IKV1ADyf', '1', '花园与户外', '王子韬', '2008-02-27 00:00:00', '2', '王子韬', '2014-12-05 00:00:00', '0', '贸易行业', '2011-03-28 12:20:23', '2009-12-18 02:36:23', 0);
INSERT INTO `inventory_approval` VALUES (16, 'ZQtNLnmxAO', '1', '云熙有限责任公司', 'uCfoo81DNm', '0', '收藏品及美术用品', '梁嘉伦', '2022-06-19 00:00:00', '1', '梁嘉伦', '2009-04-23 00:00:00', '0', '咨询业', '2001-03-21 15:09:46', '2016-07-25 17:41:45', 0);
INSERT INTO `inventory_approval` VALUES (17, 'VPVoRp3eiO', '1', '方物业代理有限责任公司', 'P3WRbcQJh9', '1', '保健，家庭及婴儿护理', '汤晓明', '2019-03-23 00:00:00', '2', '汤晓明', '2019-11-28 00:00:00', '1', '房地产业', '2022-11-23 06:53:55', '2003-01-31 20:08:09', 0);
INSERT INTO `inventory_approval` VALUES (18, 'vVBitXNExG', '1', '秀英技术有限责任公司', 'Z3KV1UspYy', '0', '婴儿用品', '潘秀英', '2008-01-28 00:00:00', '1', '潘秀英', '2022-06-25 00:00:00', '0', '资讯科技业', '2007-08-10 06:11:40', '2016-07-17 16:34:06', 0);
INSERT INTO `inventory_approval` VALUES (19, 'LNmSSul72T', '0', '罗記有限责任公司', 'DcvCtuyMf7', '1', '应用程式及游戏', '蔡宇宁', '2010-11-13 00:00:00', '0', '蔡宇宁', '2008-01-26 00:00:00', '0', '饮食业', '2022-10-05 18:11:03', '2010-01-06 22:40:19', 0);
INSERT INTO `inventory_approval` VALUES (20, '8YIAJJ08Zu', '1', '朱記电讯有限责任公司', 'r8ox1oK6cz', '0', '工具与家居装饰', '黄云熙', '2022-04-03 00:00:00', '1', '黄云熙', '2017-03-20 00:00:00', '1', '电讯業', '2002-09-14 05:11:18', '2001-07-22 21:17:20', 0);

-- ----------------------------
-- Table structure for material_category
-- ----------------------------
DROP TABLE IF EXISTS `material_category`;
CREATE TABLE `material_category`  (
  `id` bigint NOT NULL COMMENT '编号',
  `category_encoding` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类编码',
  `category_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类名称',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '说明',
  `parent_category_id` bigint NULL DEFAULT NULL COMMENT '父级分类id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` int NULL DEFAULT 0 COMMENT '0 未删除(默认), 1 已删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `category_encoding`(`category_encoding` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '物料分类表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of material_category
-- ----------------------------
INSERT INTO `material_category` VALUES (16273485123456793, 'MP7912', '食品饮料', '零食、饮料等', NULL, '2023-07-20 13:55:31', '2023-07-20 14:42:06', 0);
INSERT INTO `material_category` VALUES (16273485123456794, 'CAT006', '美容护肤', '化妆品、护肤品', NULL, '2023-07-20 13:55:34', '2023-07-20 15:15:32', 0);
INSERT INTO `material_category` VALUES (16273485123456795, 'CAT007', '运动健身', '健身器材、运动服饰', NULL, '2023-07-20 13:55:38', '2023-07-20 16:25:43', 0);
INSERT INTO `material_category` VALUES (16273485123456796, 'CAT008', '家居家装', '家具、装饰品等', NULL, '2023-07-20 13:55:41', '2023-07-20 17:35:54', 0);
INSERT INTO `material_category` VALUES (16273485123456797, 'CAT009', '汽车配件', '发动机、雨刷等', NULL, '2023-07-20 13:55:44', '2023-07-20 18:46:05', 0);
INSERT INTO `material_category` VALUES (16273485123456798, 'CAT010', '珠宝首饰', '钻石、黄金饰品', NULL, '2023-07-20 13:55:47', '2023-07-20 19:56:16', 0);
INSERT INTO `material_category` VALUES (16273485123456799, 'CAT011', '数码配件', '手机壳、充电器等', NULL, '2023-07-20 13:55:50', '2023-07-20 20:15:32', 0);
INSERT INTO `material_category` VALUES (16273485123456800, 'CAT012', '玩具模型', '儿童玩具、模型车', NULL, '2023-07-20 13:55:53', '2023-07-20 21:25:43', 0);
INSERT INTO `material_category` VALUES (16273485123456801, 'CAT013', '健康保健', '营养品、保健药', NULL, '2023-07-20 22:35:54', '2023-07-20 22:35:54', 0);
INSERT INTO `material_category` VALUES (16273485123456802, 'CAT014', '办公用品', '文件夹、笔等', NULL, '2023-07-20 23:46:05', '2023-07-26 19:36:36', 0);
INSERT INTO `material_category` VALUES (16273485123456803, 'CAT015', '厨房用具', '刀具、锅具等', NULL, '2023-07-20 00:56:16', '2023-07-20 00:56:16', 0);
INSERT INTO `material_category` VALUES (1681850223692681216, 'MP-66', '天外之物', '地星之外的未知矿物', NULL, '2023-07-20 10:15:15', '2023-07-20 10:15:15', 0);
INSERT INTO `material_category` VALUES (1681992426326958080, 'M78177', '土星产物', '我不知道，未知的捏', 1681850223692681216, '2023-07-20 19:40:19', '2023-07-26 21:06:11', 0);
INSERT INTO `material_category` VALUES (1684184117989425152, 'DBJ666', '大保健', '保健药物', 16273485123456801, '2023-07-26 20:49:19', '2023-07-26 20:49:19', 0);
INSERT INTO `material_category` VALUES (1684185357267845120, 'SMM776', '星辰矿物', '土星', 1681992426326958080, '2023-07-26 20:54:14', '2023-07-26 21:06:30', 0);
INSERT INTO `material_category` VALUES (1684812869303857152, 'MP675', '草药', '草药类', NULL, '2023-07-28 14:27:45', '2023-07-28 14:27:45', 0);
INSERT INTO `material_category` VALUES (1684900695705956352, 'CS1-1685181426759979008', '测试1-NEW1', '测试1说明', NULL, '2023-07-28 20:16:44', '2023-07-29 14:52:15', 1);
INSERT INTO `material_category` VALUES (1684900759539068928, 'CS2', '测试2-NEW2', '测试2说明12', NULL, '2023-07-28 20:16:59', '2023-07-29 14:53:10', 0);
INSERT INTO `material_category` VALUES (1684900863327121408, 'CS3', '测试3', '测试3说明', NULL, '2023-07-28 20:17:24', '2023-07-28 20:17:24', 0);
INSERT INTO `material_category` VALUES (1684900926333956096, 'CS4-1685180894876094464', '测试4', '测试4说明', NULL, '2023-07-28 20:17:39', '2023-07-29 14:50:09', 1);
INSERT INTO `material_category` VALUES (1684901033427120128, 'CS511', '测试5', '测试5说明222', NULL, '2023-07-28 20:18:04', '2023-07-29 10:30:14', 1);
INSERT INTO `material_category` VALUES (1685284967755358208, 'JSCL01', '金属材料', '金属材料说明', NULL, '2023-07-29 21:43:42', '2023-07-29 21:43:42', 0);
INSERT INTO `material_category` VALUES (1685285188665155584, 'SLYL02', '塑料原料', '塑料原料说明', NULL, '2023-07-29 21:44:34', '2023-07-29 21:44:34', 0);
INSERT INTO `material_category` VALUES (1685285343112011776, 'BLCL03', '玻璃材料', '玻璃材料说明', NULL, '2023-07-29 21:45:11', '2023-07-29 21:45:11', 0);
INSERT INTO `material_category` VALUES (1685285498997514240, 'DZQYJ4', '电子元器件', '电子元器件说明', NULL, '2023-07-29 21:45:48', '2023-07-29 21:45:48', 0);
INSERT INTO `material_category` VALUES (1685285636025425920, 'MC0005', '木材', '', NULL, '2023-07-29 21:46:21', '2023-07-29 21:46:21', 0);
INSERT INTO `material_category` VALUES (1685285743433162752, 'XJCL06', '橡胶材料', '', NULL, '2023-07-29 21:46:46', '2023-07-29 21:46:46', 0);
INSERT INTO `material_category` VALUES (1685285851356798976, 'FZCL07', '纺织材料', '纺织材料说明', NULL, '2023-07-29 21:47:12', '2023-07-29 21:47:12', 0);
INSERT INTO `material_category` VALUES (1685285988086915072, 'DXDL08', '电线电缆', '电线电缆说明', NULL, '2023-07-29 21:47:45', '2023-07-29 21:47:45', 0);
INSERT INTO `material_category` VALUES (1685286114528403456, 'JZCL09', '建筑材料', '建筑', NULL, '2023-07-29 21:48:15', '2023-07-29 21:48:15', 0);
INSERT INTO `material_category` VALUES (1685286264575434752, 'DCDY10', '电池电源', '电池', NULL, '2023-07-29 21:48:51', '2023-07-29 21:48:51', 0);
INSERT INTO `material_category` VALUES (1685286462961819648, 'HGTL11', '化工涂料', '化工类', NULL, '2023-07-29 21:49:38', '2023-07-29 21:49:38', 0);
INSERT INTO `material_category` VALUES (1685286642100543488, 'HGCL12', '化工材料', '化工', NULL, '2023-07-29 21:50:21', '2023-07-29 21:50:21', 0);
INSERT INTO `material_category` VALUES (1685286955649933312, 'RHYZ13', '润滑油脂', '车具配件润滑', NULL, '2023-07-29 21:51:36', '2023-07-29 21:51:36', 0);

-- ----------------------------
-- Table structure for material_record
-- ----------------------------
DROP TABLE IF EXISTS `material_record`;
CREATE TABLE `material_record`  (
  `id` bigint NOT NULL COMMENT '编号',
  `material_encoding` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物料编码',
  `material_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '物料名称',
  `version` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '型号',
  `standard` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规格',
  `unit` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '单位',
  `price` decimal(10, 3) NULL DEFAULT NULL COMMENT '单价',
  `type` int NOT NULL DEFAULT 0 COMMENT '类型 0 成品(默认),1 原料',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  `category_id` bigint NULL DEFAULT NULL COMMENT '物料分类id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` int NULL DEFAULT 0 COMMENT '0 未删除(默认), 1 已删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `material_encoding`(`material_encoding` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '物料档案表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of material_record
-- ----------------------------
INSERT INTO `material_record` VALUES (16273485123456789, 'M0001', '铝合金型材', 'AL-1001', '80x40mm', '米', 36.000, 0, '用于制造门窗', 1685284967755358208, '2023-07-20 10:15:32', '2023-07-20 10:15:32', 0);
INSERT INTO `material_record` VALUES (16273485123456790, 'M0002', '不锈钢板', 'SS-2001', '1.5mm', '平方米', 80.000, 0, '用于制作厨具', 1685284967755358208, '2023-07-21 11:25:43', '2023-07-21 11:25:43', 0);
INSERT INTO `material_record` VALUES (16273485123456791, 'M0003', '塑料颗粒', 'PP-5001', '3mm', '公斤', 6.000, 1, '用于注塑加工', 1685285188665155584, '2023-07-22 12:35:54', '2023-07-22 12:35:54', 0);
INSERT INTO `material_record` VALUES (16273485123456792, 'M0004', '玻璃板', 'GL-3001', '5mm', '平方米', 23.000, 0, '用于玻璃制品', 1685285343112011776, '2023-07-23 13:46:05', '2023-07-23 13:46:05', 0);
INSERT INTO `material_record` VALUES (16273485123456793, 'M0005', '电子元件', 'EC-4001', '0805封装', '个', 0.000, 1, '用于电路板组装', 1685285498997514240, '2023-07-24 14:56:16', '2023-07-24 14:56:16', 0);
INSERT INTO `material_record` VALUES (16273485123456794, 'M0006', '木材板', 'WD-2001', '18mm', '平方米', 29.000, 0, '用于家具制作', 1685285636025425920, '2023-07-25 15:15:32', '2023-07-25 15:15:32', 0);
INSERT INTO `material_record` VALUES (16273485123456795, 'M0007', '橡胶板', 'RB-1001', '5mm', '平方米', 19.000, 0, '用于密封件制造', 1685285743433162752, '2023-07-26 16:25:43', '2023-07-26 16:25:43', 0);
INSERT INTO `material_record` VALUES (16273485123456796, 'M0008', '纺织面料', 'TF-3001', '1000mm', '米', 13.000, 0, '用于服装制作', 1685285851356798976, '2023-07-27 17:35:54', '2023-07-27 17:35:54', 0);
INSERT INTO `material_record` VALUES (16273485123456797, 'M0009', '铜线', 'CT-4001', '1mm', '卷', 9.000, 0, '用于电气连接', 1685285988086915072, '2023-07-28 18:46:05', '2023-07-28 18:46:05', 0);
INSERT INTO `material_record` VALUES (16273485123456798, 'M0010', '石膏粉', 'GP-2001', '25kg', '袋', 15.000, 1, '用于建筑装修', 1685286114528403456, '2023-07-29 19:56:16', '2023-07-29 19:56:16', 0);
INSERT INTO `material_record` VALUES (16273485123456799, 'M0011', '电池', 'BT-5001', 'AA', '个', 3.000, 1, '用于电子产品', 1685286264575434752, '2023-07-30 20:15:32', '2023-07-30 20:15:32', 0);
INSERT INTO `material_record` VALUES (16273485123456800, 'M0012', '涂料', 'PL-3001', '5L', '桶', 69.000, 1, '用于涂装', 1685286462961819648, '2023-07-31 21:25:43', '2023-07-31 21:25:43', 0);
INSERT INTO `material_record` VALUES (16273485123456801, 'M0013', '硅胶', 'SI-4001', '50g', '盒', 6.000, 1, '用于密封', 1685286642100543488, '2023-08-01 22:35:54', '2023-08-01 22:35:54', 0);
INSERT INTO `material_record` VALUES (16273485123456802, 'M0014', '电线', 'EW-5001', '1.5mm²', '米', 2.000, 1, '用于电气布线', 1685285988086915072, '2023-08-02 23:46:05', '2023-08-02 23:46:05', 0);
INSERT INTO `material_record` VALUES (16273485123456803, 'M0015', '润滑油', 'LO-6001', '4L', '瓶', 29.000, 1, '用于机械设备', 1685286955649933312, '2023-08-03 00:56:16', '2023-08-03 00:56:16', 0);
INSERT INTO `material_record` VALUES (1685456614185582592, 'MSM679', '金光石', '测试1型号', '测试1规格', '测试1单位', 4001.070, 1, '测试1备注', 551212121212, '2023-07-30 09:05:46', '2023-07-30 13:32:10', 0);
INSERT INTO `material_record` VALUES (1685458776785473536, '测试2编码', '测试2名称', '测试2型号', '测试2规格', '测试2单位', 200.050, 0, '测试2备注', NULL, '2023-07-30 09:14:21', '2023-07-30 09:17:44', 1);
INSERT INTO `material_record` VALUES (1685519233764327424, 'test_0aa878fdacd9-1685520791562387456', 'test_d2070a1a1a80', 'test_4b933177d03a', 'test_3dcc292bd924', 'test_f0f485d5efb1', 4.070, 84, 'test_40712a3520fe', 55, '2023-07-30 13:14:35', '2023-07-30 13:20:46', 1);
INSERT INTO `material_record` VALUES (1685519650296463360, 'test_0aa878fdacc9-1685520791579164672', 'test_d2070a1a1a80', 'test_4b933177d03a', 'test_3dcc292bd924', 'test_f0f485d5efb1', 4.070, 0, 'test_40712a3520fe', 55, '2023-07-30 13:16:14', '2023-07-30 13:20:46', 1);
INSERT INTO `material_record` VALUES (1685543803556757504, 'QM666', '玄天木', 'XT-129', '100KG', '斤', 10000.300, 1, '玄天木', 1685285636025425920, '2023-07-30 14:52:13', '2023-08-01 09:22:33', 0);

-- ----------------------------
-- Table structure for project_maintain
-- ----------------------------
DROP TABLE IF EXISTS `project_maintain`;
CREATE TABLE `project_maintain`  (
  `id` bigint NOT NULL COMMENT '编号',
  `project_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '项目名',
  `principal` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '负责人',
  `start_date` datetime NOT NULL COMMENT '开始日期',
  `end_date` datetime NOT NULL COMMENT '结束日期',
  `project_status` int NULL DEFAULT 1 COMMENT '项目状态 0 挂起,1 正常(默认)',
  `project_recommend` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '项目介绍',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` int NULL DEFAULT 0 COMMENT '0 未删除(默认), 1 已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '项目维护表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of project_maintain
-- ----------------------------
INSERT INTO `project_maintain` VALUES (16273485123456789, '企业网站建设', '张三', '2023-07-20 00:00:00', '2023-08-20 00:00:00', 1, '这是企业网站建设项目的介绍。', '2023-07-20 10:15:32', '2023-07-20 10:15:32', 0);
INSERT INTO `project_maintain` VALUES (16273485123456790, '移动App开发', '李四', '2023-07-21 00:00:00', '2023-08-21 00:00:00', 1, '这是移动App开发项目的介绍。', '2023-07-21 11:25:43', '2023-07-21 11:25:43', 0);
INSERT INTO `project_maintain` VALUES (16273485123456791, '新产品设计', '王五', '2023-07-22 00:00:00', '2023-08-22 00:00:00', 1, '这是新产品设计项目的介绍。', '2023-07-22 12:35:54', '2023-07-22 12:35:54', 0);
INSERT INTO `project_maintain` VALUES (16273485123456792, '市场调研', '赵六', '2023-07-23 00:00:00', '2023-08-23 00:00:00', 1, '这是市场调研项目的介绍。', '2023-07-23 13:46:05', '2023-07-23 13:46:05', 0);
INSERT INTO `project_maintain` VALUES (16273485123456793, '供应链优化', '陈七', '2023-07-24 00:00:00', '2023-08-24 00:00:00', 1, '这是供应链优化项目的介绍。', '2023-07-24 14:56:16', '2023-07-24 14:56:16', 0);
INSERT INTO `project_maintain` VALUES (16273485123456794, '人力资源培训', '刘八', '2023-07-25 00:00:00', '2023-08-25 00:00:00', 1, '这是人力资源培训项目的介绍。', '2023-07-25 15:15:32', '2023-07-25 13:09:41', 0);
INSERT INTO `project_maintain` VALUES (16273485123456795, '环保改造', '孙九', '2023-07-26 00:00:00', '2023-08-26 00:00:00', 1, '这是环保改造项目的介绍。', '2023-07-26 16:25:43', '2023-07-25 13:09:31', 0);
INSERT INTO `project_maintain` VALUES (16273485123456796, '产品推广', '周十', '2023-07-27 00:00:00', '2023-08-27 00:00:00', 1, '这是产品推广项目的介绍。', '2023-07-27 17:35:54', '2023-07-25 13:09:26', 0);
INSERT INTO `project_maintain` VALUES (16273485123456797, '财务审计', '钱十一', '2023-07-28 00:00:00', '2023-08-28 00:00:00', 1, '这是财务审计项目的介绍。', '2023-07-28 18:46:05', '2023-07-25 13:09:23', 0);
INSERT INTO `project_maintain` VALUES (16273485123456798, '网络安全检测', '吴十二', '2023-07-29 00:00:00', '2023-08-29 00:00:00', 1, '这是网络安全检测项目的介绍。', '2023-07-29 19:56:16', '2023-07-25 13:09:20', 0);
INSERT INTO `project_maintain` VALUES (16273485123456799, '数据分析', '郑十三', '2023-07-30 00:00:00', '2023-08-30 00:00:00', 1, '这是数据分析项目的介绍。', '2023-07-30 20:15:32', '2023-07-25 13:09:15', 0);
INSERT INTO `project_maintain` VALUES (16273485123456800, '市场营销策划', '黄十四', '2023-07-31 00:00:00', '2023-08-31 00:00:00', 1, '这是市场营销策划项目的介绍。', '2023-07-31 21:25:43', '2023-07-25 12:35:25', 0);
INSERT INTO `project_maintain` VALUES (16273485123456801, '物流配送优化', '马十五', '2023-08-01 00:00:00', '2023-09-01 00:00:00', 1, '这是物流配送优化项目的介绍。', '2023-08-01 22:35:54', '2023-07-25 13:09:11', 0);
INSERT INTO `project_maintain` VALUES (16273485123456802, '员工福利改进', '罗十六', '2023-08-02 00:00:00', '2023-09-02 00:00:00', 1, '这是员工福利改进项目的介绍。', '2023-08-02 23:46:05', '2023-07-25 12:19:41', 0);
INSERT INTO `project_maintain` VALUES (16273485123456803, '员工培训计划', '冯十七', '2023-08-03 00:00:00', '2023-09-03 00:00:00', 0, '这是员工培训计划项目的介绍。', '2023-08-03 00:56:16', '2023-07-24 21:56:50', 0);
INSERT INTO `project_maintain` VALUES (1682289814169997312, '血月横空', '刘希冉', '2023-07-21 15:22:02', '2023-07-21 15:22:02', 1, '不知道', '2023-07-21 15:22:02', '2023-07-21 15:34:49', 0);
INSERT INTO `project_maintain` VALUES (1682289846403276800, '马塔东街', '刘希冉', '2023-07-21 15:22:09', '2023-07-21 15:22:09', 1, '不知道', '2023-07-21 15:22:09', '2023-07-21 17:13:33', 1);
INSERT INTO `project_maintain` VALUES (1682307902403837952, '火星计划', '刘七夕', '2025-07-21 12:12:12', '2025-08-21 12:12:12', 0, '人类的一大进步', '2023-07-21 16:33:54', '2023-07-21 20:15:16', 0);
INSERT INTO `project_maintain` VALUES (1683476869105360896, '亚特兰地心计划', '汤姆', '2023-07-24 21:58:40', '2023-07-30 00:00:00', 0, '地心', '2023-07-24 21:58:57', '2023-07-25 13:10:06', 0);
INSERT INTO `project_maintain` VALUES (1683477181950107648, '测试', '测试', '2023-07-24 22:00:03', '2023-07-30 00:00:00', 1, '无', '2023-07-24 22:00:12', '2023-07-24 22:00:31', 1);

-- ----------------------------
-- Table structure for purchase_approval
-- ----------------------------
DROP TABLE IF EXISTS `purchase_approval`;
CREATE TABLE `purchase_approval`  (
  `id` bigint NOT NULL COMMENT '申请单号',
  `request_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '申请类型(0计划申请、1补货申请)',
  `plan_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '计划单号',
  `replenishment_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '补货单号',
  `applicant` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '申请人',
  `request_date` datetime NOT NULL COMMENT '申请日期',
  `request_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '申请状态(0未提交 1待审核 2已审核)',
  `approver` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核人',
  `approval_date` datetime NULL DEFAULT NULL COMMENT '审核日期',
  `approval_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核状态(0通过 1驳回)',
  `approval_comments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '审核意见',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` int NULL DEFAULT 0 COMMENT '0 未删除(默认), 1 已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '采购申请表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of purchase_approval
-- ----------------------------
INSERT INTO `purchase_approval` VALUES (1, '1', 'jNOfiBiLx3', 'KhxdQkYYW5', '王子异', '2023-06-24 08:14:51', '1', '王子异', '2006-09-30 16:58:23', '1', '不可行', '2004-04-30 16:40:22', '2007-12-09 06:07:11', 0);
INSERT INTO `purchase_approval` VALUES (2, '1', 'GeugfiQyXZ', '91EUnmvf2j', '于嘉伦', '2007-05-23 22:48:05', '1', '于嘉伦', '2016-12-28 05:02:13', '0', '测试修改审核意见', '2001-10-10 14:35:27', '2016-10-19 06:26:00', 0);
INSERT INTO `purchase_approval` VALUES (3, '1', 'WDA9R7Qk2g', 'XOOLvoTk8E', '王璐', '2007-10-03 08:35:11', '1', '王璐', '2013-06-06 13:27:31', '1', '龙岗区学园一巷103号', '2010-03-30 07:03:28', '2019-10-02 09:09:02', 0);
INSERT INTO `purchase_approval` VALUES (4, '0', 'AQ0q0FKLYH', '23RXOkNBRq', '范震南', '2006-12-21 19:49:14', '2', '范震南', '2010-05-09 07:35:15', '0', '成华区双庆路699号', '2020-11-10 18:31:03', '2001-01-10 01:38:19', 0);
INSERT INTO `purchase_approval` VALUES (5, '1', 'CbPssjdpnu', '5zElXT3ump', '孟宇宁', '2022-06-27 08:45:25', '1', '孟宇宁', '2013-10-07 02:19:06', '0', '徐汇区虹桥路576号', '2011-01-17 11:24:45', '2016-04-30 04:16:10', 0);
INSERT INTO `purchase_approval` VALUES (6, '0', 'z5oqPFqAcZ', 'f72ikqUfLL', '彭震南', '2001-01-05 14:10:57', '1', '彭震南', '2018-10-09 12:11:58', '1', '西城区西長安街693号', '2013-09-20 03:54:15', '2020-08-08 04:56:45', 0);
INSERT INTO `purchase_approval` VALUES (7, '0', 'NbY8Xp2pC6', 'ZNgSEeV4px', '杨杰宏', '2002-06-14 13:54:27', '2', '杨杰宏', '2020-04-05 04:09:19', '0', '珊瑚路146号', '2008-07-16 17:21:23', '2002-07-21 17:51:53', 0);
INSERT INTO `purchase_approval` VALUES (8, '0', 'gs7tzjGggu', 'AVbkjt7qJH', '马子韬', '2023-07-02 17:54:19', '0', '马子韬', '2017-02-19 01:10:33', '0', '福田区景田东一街696号', '2001-06-26 00:24:15', '2020-01-15 00:20:47', 0);
INSERT INTO `purchase_approval` VALUES (9, '0', 'Jod2jds05m', '3CTD9FGItE', '于嘉伦', '2001-07-03 05:10:25', '2', '于嘉伦', '2003-03-06 16:48:03', '0', '龙岗区布吉镇西环路21号', '2004-03-06 07:37:43', '2018-01-06 20:01:51', 0);
INSERT INTO `purchase_approval` VALUES (10, '1', 'AIqquBla5q', 'vS3K48UlhG', '赵詩涵', '2017-03-13 20:36:12', '0', '赵詩涵', '2001-03-24 16:40:53', '0', '越秀区中山二路441号', '2005-09-19 03:30:52', '2019-11-27 07:16:42', 0);
INSERT INTO `purchase_approval` VALUES (11, '1', 'bCk3SIHnLx', 'Dd49tdBgqe', '夏杰宏', '2008-05-16 18:03:24', '2', '夏杰宏', '2009-02-24 15:56:20', '0', '锦江区红星路三段432号', '2001-03-11 20:56:11', '2007-09-29 21:25:22', 0);
INSERT INTO `purchase_approval` VALUES (12, '0', 'q2JisvKsaa', 'kIZH28JsID', '高安琪', '2020-09-27 09:34:13', '1', '高安琪', '2022-11-18 22:13:05', '1', '成华区玉双路6号64号', '2023-02-01 11:44:42', '2001-10-10 03:15:55', 0);
INSERT INTO `purchase_approval` VALUES (13, '1', 'cupth1tw0R', 'yeil02cVwo', '余嘉伦', '2013-01-15 01:00:40', '0', '余嘉伦', '2000-01-07 12:12:01', '0', '罗湖区蔡屋围深南东路192号', '2007-06-23 03:03:14', '2003-01-21 05:46:02', 0);
INSERT INTO `purchase_approval` VALUES (14, '1', 'AbsdqIjq31', 'YurQ7oJFl2', '黎杰宏', '2005-06-09 02:15:51', '2', '黎杰宏', '2020-04-05 06:45:34', '1', '海珠区江南西路141号', '2006-09-28 23:06:48', '2016-12-14 10:53:04', 0);
INSERT INTO `purchase_approval` VALUES (15, '1', 'lKSwgShEyO', 'TcmLXEHdyh', '谢子异', '2011-12-28 05:25:11', '0', '谢子异', '2003-08-11 18:49:48', '1', '延庆区028县道817号', '2017-10-03 19:19:25', '2017-11-16 14:31:57', 0);
INSERT INTO `purchase_approval` VALUES (16, '0', 'IzAjzlAV1V', 'AYWxvaCLRB', '钱嘉伦', '2014-08-09 21:39:08', '2', '钱嘉伦', '2020-08-10 11:45:13', '0', '黄浦区淮海中路14号', '2016-11-01 09:42:33', '2006-12-16 00:11:35', 0);
INSERT INTO `purchase_approval` VALUES (17, '0', 'ygHNkYDRZu', 'KGEDbHfzqg', '姚嘉伦', '2013-01-08 21:04:24', '2', '姚嘉伦', '2007-09-08 06:14:27', '0', '成华区玉双路6号461号', '2000-05-31 07:17:02', '2007-03-25 11:36:07', 0);
INSERT INTO `purchase_approval` VALUES (18, '1', 'szqo5xx7tK', 'Tb2PdD3B74', '孟睿', '2013-03-03 09:12:21', '0', '孟睿', '2013-12-29 04:19:03', '1', '海珠区江南西路379号', '2012-10-17 21:11:20', '2013-02-04 20:06:22', 0);
INSERT INTO `purchase_approval` VALUES (19, '0', 'QOwX6ynU3f', '2hfrk9D0CX', '汪嘉伦', '2002-11-24 16:10:46', '0', '汪嘉伦', '2005-07-02 04:18:01', '0', '天河区天河路659号', '2018-12-28 13:52:31', '2014-10-26 18:53:22', 0);
INSERT INTO `purchase_approval` VALUES (20, '1', '8f5V9mCQMx', 'v26AZ2QYBy', '邹震南', '2022-09-10 13:11:39', '1', '邹震南', '2014-11-20 04:58:31', '1', '成华区玉双路6号545号', '2013-04-12 06:48:11', '2000-04-10 12:48:14', 0);

-- ----------------------------
-- Table structure for replenishment_approval
-- ----------------------------
DROP TABLE IF EXISTS `replenishment_approval`;
CREATE TABLE `replenishment_approval`  (
  `id` bigint NOT NULL COMMENT '单据号',
  `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态',
  `applicant` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '申请人',
  `application_date` datetime NOT NULL COMMENT '申请日期',
  `application_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '申请状态(0未提交 1待审核 2已审核)',
  `approver` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核人',
  `approval_date` datetime NULL DEFAULT NULL COMMENT '审核日期',
  `approval_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '审核状态(0通过 1驳回)',
  `approval_comments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '审核意见',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` int NULL DEFAULT 0 COMMENT '0 未删除(默认), 1 已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '补货申请表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of replenishment_approval
-- ----------------------------
INSERT INTO `replenishment_approval` VALUES (1, '0', '武秀英', '2019-12-22 00:00:00', '2', '武秀英', '2003-12-20 20:30:54', '1', '中非共和国', '2012-04-12 13:48:02', '2001-08-21 06:28:15', 0);
INSERT INTO `replenishment_approval` VALUES (2, '1', '徐子韬', '2020-10-07 00:00:00', '1', '徐子韬', '2007-08-17 05:18:35', '0', '白俄罗斯', '2000-02-15 10:48:45', '2009-04-22 00:54:06', 0);
INSERT INTO `replenishment_approval` VALUES (3, '0', '韩安琪', '2004-02-18 00:00:00', '0', '韩安琪', '2012-10-12 09:06:58', '0', '乌兹别克斯坦', '2020-06-30 11:35:51', '2008-04-16 18:12:01', 0);
INSERT INTO `replenishment_approval` VALUES (4, '0', '田致远', '2013-10-27 00:00:00', '0', '田致远', '2015-04-05 12:18:07', '0', '海地', '2020-01-09 12:19:54', '2022-03-05 07:58:24', 0);
INSERT INTO `replenishment_approval` VALUES (5, '1', '宋子异', '2021-04-07 00:00:00', '2', '宋子异', '2012-12-06 13:15:14', '0', '基里巴斯', '2009-04-26 12:08:14', '2005-10-04 17:26:42', 0);
INSERT INTO `replenishment_approval` VALUES (6, '1', '郝子韬', '2004-11-24 00:00:00', '2', '郝子韬', '2021-07-27 22:29:15', '0', '瑞士', '2005-01-22 00:16:01', '2004-11-29 23:40:14', 0);
INSERT INTO `replenishment_approval` VALUES (7, '1', '罗杰宏', '2021-04-03 00:00:00', '1', '罗杰宏', '2016-02-26 04:37:15', '1', '哥斯达黎加', '2000-01-31 09:48:30', '2000-02-10 21:36:04', 0);
INSERT INTO `replenishment_approval` VALUES (8, '0', '罗致远', '2018-08-21 00:00:00', '0', '罗致远', '2001-09-05 22:55:14', '1', '捷克共和国', '2013-04-19 00:06:18', '2002-11-20 09:49:38', 0);
INSERT INTO `replenishment_approval` VALUES (9, '1', '熊嘉伦', '2003-08-20 00:00:00', '1', '熊嘉伦', '2003-03-27 12:47:12', '0', '加纳', '2016-05-02 10:18:58', '2009-11-01 22:44:02', 0);
INSERT INTO `replenishment_approval` VALUES (10, '1', '崔致远', '2005-04-07 00:00:00', '1', '崔致远', '2021-03-07 23:48:56', '1', '巴基斯坦', '2003-02-23 11:45:49', '2023-08-08 13:40:11', 0);
INSERT INTO `replenishment_approval` VALUES (11, '1', '熊杰宏', '2021-11-02 00:00:00', '1', '熊杰宏', '2019-09-21 13:38:11', '0', '越南', '2020-12-05 16:13:08', '2016-06-21 10:36:42', 0);
INSERT INTO `replenishment_approval` VALUES (12, '1', '邹致远', '2005-11-06 00:00:00', '0', '邹致远', '2021-02-14 09:15:44', '1', '塞尔维亚', '2007-12-19 16:41:59', '2020-02-12 17:00:13', 0);
INSERT INTO `replenishment_approval` VALUES (13, '1', '崔震南', '2003-11-09 00:00:00', '0', '崔震南', '2011-06-15 15:01:03', '0', '吉布地', '2003-09-23 04:41:29', '2001-04-20 21:35:53', 0);
INSERT INTO `replenishment_approval` VALUES (14, '1', '陈嘉伦', '2023-06-09 00:00:00', '1', '陈嘉伦', '2020-09-07 20:05:54', '0', '立陶宛', '2014-11-26 12:15:05', '2002-07-08 02:42:36', 0);
INSERT INTO `replenishment_approval` VALUES (15, '1', '叶璐', '2008-02-28 00:00:00', '1', '叶璐', '2015-05-18 12:26:47', '1', '佛得角', '2011-05-18 07:04:03', '2018-06-25 13:27:13', 0);
INSERT INTO `replenishment_approval` VALUES (16, '0', '邹致远', '2008-04-27 00:00:00', '2', '邹致远', '2018-07-13 03:03:31', '1', '巴拉圭', '2000-04-01 07:29:12', '2005-03-17 01:44:24', 0);
INSERT INTO `replenishment_approval` VALUES (17, '1', '秦晓明', '2011-10-28 00:00:00', '1', '秦晓明', '2022-06-08 08:25:04', '0', '汤加', '2021-11-12 14:16:18', '2008-06-06 05:26:43', 0);
INSERT INTO `replenishment_approval` VALUES (18, '1', '朱子韬', '2008-08-21 00:00:00', '1', '朱子韬', '2001-05-06 00:58:52', '1', '西班牙', '2004-03-15 22:03:45', '2020-12-05 00:49:08', 0);
INSERT INTO `replenishment_approval` VALUES (19, '1', '薛子异', '2010-08-28 00:00:00', '1', '薛子异', '2019-12-30 23:07:41', '1', '安道尔', '2008-02-13 21:50:28', '2006-12-13 19:35:58', 0);
INSERT INTO `replenishment_approval` VALUES (20, '0', '武詩涵', '2015-10-15 00:00:00', '2', '武詩涵', '2007-03-06 16:23:03', '0', '贝宁', '2016-11-03 11:16:27', '2010-07-23 23:43:35', 0);

-- ----------------------------
-- Table structure for sales_contract
-- ----------------------------
DROP TABLE IF EXISTS `sales_contract`;
CREATE TABLE `sales_contract`  (
  `id` bigint NOT NULL COMMENT '编号',
  `order_number` bigint NULL DEFAULT NULL COMMENT '关联销售订单表id',
  `contact_person` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系人',
  `contact_information` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系方式',
  `applicant` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '申请人',
  `application_time` datetime NULL DEFAULT NULL COMMENT '申请时间',
  `application_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '申请状态(0未提交 1待审核 2已审核)',
  `approver` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核人',
  `approval_time` date NULL DEFAULT NULL COMMENT '审核时间',
  `approval_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核状态(0通过 1驳回)',
  `delivery_method` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '送货方式(0快递 1物流)',
  `shipping_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收货地址',
  `signing_date` datetime NOT NULL COMMENT '签订日期',
  `remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` int NULL DEFAULT 0 COMMENT '0 未删除(默认), 1 已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '销售合同' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sales_contract
-- ----------------------------
INSERT INTO `sales_contract` VALUES (1, 1, '邱晓明', '手机号', '邱晓明', '2023-10-18 23:00:16', '0', '邱晓明', '2023-10-18', '0', '1', '天河区大信商圈大信南路520号', '2023-10-18 16:41:17', 'Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. The first step is as good as half over. A man’s best friends are his ten fingers. Success consists of going from failure to failure without loss of enthusiasm. To connect to a database or schema, simply double-click it in the pane. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more.', '2023-10-18 00:42:12', '2023-10-18 22:01:50', 0);
INSERT INTO `sales_contract` VALUES (2, 2, '秦岚', '手机号', '秦岚', '2023-10-18 03:23:00', '1', '秦岚', '2023-10-18', '1', '1', '锦江区人民南路四段65号', '2023-10-18 10:11:03', 'HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. The On Startup feature allows you to control what tabs appear when you launch Navicat. In the middle of winter I at last discovered that there was in me an invincible summer. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. I destroy my enemies when I make them my friends. To connect to a database or schema, simply double-click it in the pane. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. Creativity is intelligence having fun. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. Navicat allows you to transfer data from one database and/or schema to another with detailed analytical process. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. How we spend our days is, of course, how we spend our lives. The first step is as good as half over. All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. The Synchronize to Database function will give you a full picture of all database differences. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. You must be the change you wish to see in the world. A man’s best friends are his ten fingers. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. You can select any connections, objects or projects, and then select the corresponding buttons on the Information Pane. If the plan doesn’t work, change the plan, but never the goal. Anyone who has ever made anything of importance was disciplined. SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. Sometimes you win, sometimes you learn. Champions keep playing until they get it right. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. Creativity is intelligence having fun. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. What you get by achieving your goals is not as important as what you become by achieving your goals. Creativity is intelligence having fun. I will greet this day with love in my heart. The On Startup feature allows you to control what tabs appear when you launch Navicat. Champions keep playing until they get it right. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. A man is not old until regrets take the place of dreams. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences. I will greet this day with love in my heart. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. A comfort zone is a beautiful place, but nothing ever grows there. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. If the plan doesn’t work, change the plan, but never the goal. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats.', '2023-10-18 20:18:27', '2023-10-18 22:18:26', 0);
INSERT INTO `sales_contract` VALUES (3, 3, '徐睿', '手机号', '徐睿', '2023-10-18 07:36:12', '0', '徐睿', '2023-10-18', '0', '0', '842 Tianbei 1st Rd, Luohu District', '2023-10-18 22:19:10', 'The first step is as good as half over. Remember that failure is an event, not a person. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. A query is used to extract data from the database in a readable format according to the user\'s request. Flexible settings enable you to set up a custom key for comparison and synchronization. In the middle of winter I at last discovered that there was in me an invincible summer. SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security.', '2023-10-18 08:47:35', '2023-10-18 22:43:44', 0);
INSERT INTO `sales_contract` VALUES (4, 4, '钱震南', '手机号', '钱震南', '2023-10-18 01:06:49', '1', '钱震南', '2023-10-18', '1', '1', '成华区双庆路84号', '2023-10-18 21:00:50', 'SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. Anyone who has never made a mistake has never tried anything new. Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. Anyone who has never made a mistake has never tried anything new. In the middle of winter I at last discovered that there was in me an invincible summer. What you get by achieving your goals is not as important as what you become by achieving your goals. A query is used to extract data from the database in a readable format according to the user\'s request. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. Creativity is intelligence having fun. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. Genius is an infinite capacity for taking pains. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. You will succeed because most people are lazy. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source. Sometimes you win, sometimes you learn. Anyone who has ever made anything of importance was disciplined. Anyone who has ever made anything of importance was disciplined. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. Navicat allows you to transfer data from one database and/or schema to another with detailed analytical process.', '2023-10-18 09:29:47', '2023-10-18 22:20:37', 0);
INSERT INTO `sales_contract` VALUES (5, 5, '杜睿', '手机号', '杜睿', '2023-10-18 09:30:30', '1', '杜睿', '2023-10-18', '1', '0', '960 Tianhe Road, Tianhe District', '2023-10-18 03:05:14', 'Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. SQL Editor allows you to create and edit SQL text, prepare and execute selected queries. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. If you wait, all that happens is you get older. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. SQL Editor allows you to create and edit SQL text, prepare and execute selected queries. In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. Navicat 15 has added support for the system-wide dark mode. Sometimes you win, sometimes you learn. Typically, it is employed as an encrypted version of Telnet. The repository database can be an existing MySQL, MariaDB, PostgreSQL, SQL Server, or Amazon RDS instance. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. If you wait, all that happens is you get older. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. Creativity is intelligence having fun. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. How we spend our days is, of course, how we spend our lives. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. Flexible settings enable you to set up a custom key for comparison and synchronization. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and/or MongoDB databases, making database administration to multiple kinds of database so easy. A query is used to extract data from the database in a readable format according to the user\'s request. Difficult circumstances serve as a textbook of life for people. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. All journeys have secret destinations of which the traveler is unaware. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. If you wait, all that happens is you get older. Navicat 15 has added support for the system-wide dark mode. SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. You can select any connections, objects or projects, and then select the corresponding buttons on the Information Pane. The reason why a great man is great is that he resolves to be a great man. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. The On Startup feature allows you to control what tabs appear when you launch Navicat. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. I will greet this day with love in my heart. I destroy my enemies when I make them my friends. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. The Synchronize to Database function will give you a full picture of all database differences. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. To connect to a database or schema, simply double-click it in the pane. I may not have gone where I intended to go, but I think I have ended up where I needed to be. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network. Creativity is intelligence having fun. All journeys have secret destinations of which the traveler is unaware. Navicat allows you to transfer data from one database and/or schema to another with detailed analytical process. The first step is as good as half over. Difficult circumstances serve as a textbook of life for people. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and/or MongoDB databases, making database administration to multiple kinds of database so easy. Navicat 15 has added support for the system-wide dark mode. SQL Editor allows you to create and edit SQL text, prepare and execute selected queries. If your Internet Service Provider (ISP) does not provide direct access to its server, Secure Tunneling Protocol (SSH) / HTTP is another solution. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. Actually it is just in an idea when feel oneself can achieve and cannot achieve. If the Show objects under schema in navigation pane option is checked at the Preferences window, all database objects are also displayed in the pane. The Synchronize to Database function will give you a full picture of all database differences. Actually it is just in an idea when feel oneself can achieve and cannot achieve. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. If you wait, all that happens is you get older. A comfort zone is a beautiful place, but nothing ever grows there. Genius is an infinite capacity for taking pains. Genius is an infinite capacity for taking pains. You can select any connections, objects or projects, and then select the corresponding buttons on the Information Pane. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. It is used while your ISPs do not allow direct connections, but allows establishing HTTP connections. I destroy my enemies when I make them my friends. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and/or MongoDB databases, making database administration to multiple kinds of database so easy. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud.', '2023-10-18 21:27:31', '2023-10-18 22:38:35', 0);
INSERT INTO `sales_contract` VALUES (6, 6, '阎嘉伦', '手机号', '阎嘉伦', '2023-10-18 04:56:47', '1', '阎嘉伦', '2023-10-18', '1', '1', '170 Shennan Ave, Futian District', '2023-10-18 05:08:13', 'If the plan doesn’t work, change the plan, but never the goal. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. Actually it is just in an idea when feel oneself can achieve and cannot achieve. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. The past has no power over the present moment. It is used while your ISPs do not allow direct connections, but allows establishing HTTP connections. I will greet this day with love in my heart. It wasn’t raining when Noah built the ark. You will succeed because most people are lazy. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. You can select any connections, objects or projects, and then select the corresponding buttons on the Information Pane. I will greet this day with love in my heart. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. If the Show objects under schema in navigation pane option is checked at the Preferences window, all database objects are also displayed in the pane. Anyone who has ever made anything of importance was disciplined. The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up menus quickly and easily. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. In the middle of winter I at last discovered that there was in me an invincible summer. SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. A man is not old until regrets take the place of dreams. The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up menus quickly and easily. It is used while your ISPs do not allow direct connections, but allows establishing HTTP connections. Creativity is intelligence having fun. Remember that failure is an event, not a person. Navicat provides powerful tools for working with queries: Query Editor for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. Champions keep playing until they get it right. I may not have gone where I intended to go, but I think I have ended up where I needed to be. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. If opportunity doesn’t knock, build a door. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. I destroy my enemies when I make them my friends. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source. If the plan doesn’t work, change the plan, but never the goal. Remember that failure is an event, not a person. You will succeed because most people are lazy. Navicat allows you to transfer data from one database and/or schema to another with detailed analytical process. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. Sometimes you win, sometimes you learn. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. You cannot save people, you can just love them. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. I destroy my enemies when I make them my friends. You cannot save people, you can just love them. If the Show objects under schema in navigation pane option is checked at the Preferences window, all database objects are also displayed in the pane. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. You must be the change you wish to see in the world. How we spend our days is, of course, how we spend our lives. There is no way to happiness. Happiness is the way. In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. Actually it is just in an idea when feel oneself can achieve and cannot achieve. The repository database can be an existing MySQL, MariaDB, PostgreSQL, SQL Server, or Amazon RDS instance. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network. It wasn’t raining when Noah built the ark. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source.', '2023-10-18 05:13:10', '2023-10-18 22:32:52', 0);
INSERT INTO `sales_contract` VALUES (7, 7, '戴秀英', '手机号', '戴秀英', '2023-10-18 09:34:00', '1', '戴秀英', '2023-10-18', '1', '0', '118 Dong Zhi Men, Dongcheng District', '2023-10-18 22:44:08', 'Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. After logged in the Navicat Cloud feature, the Navigation pane will be divided into Navicat Cloud and My Connections sections. Flexible settings enable you to set up a custom key for comparison and synchronization. If it scares you, it might be a good thing to try. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. I may not have gone where I intended to go, but I think I have ended up where I needed to be. Typically, it is employed as an encrypted version of Telnet. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. The first step is as good as half over. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated. If the plan doesn’t work, change the plan, but never the goal. All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. The past has no power over the present moment. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. What you get by achieving your goals is not as important as what you become by achieving your goals. The past has no power over the present moment. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network. You can select any connections, objects or projects, and then select the corresponding buttons on the Information Pane. You must be the change you wish to see in the world. Navicat Cloud provides a cloud service for synchronizing connections, queries, model files and virtual group information from Navicat, other Navicat family members, different machines and different platforms. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. Difficult circumstances serve as a textbook of life for people. A comfort zone is a beautiful place, but nothing ever grows there. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. Actually it is just in an idea when feel oneself can achieve and cannot achieve. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. All journeys have secret destinations of which the traveler is unaware. In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. All journeys have secret destinations of which the traveler is unaware. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. In the middle of winter I at last discovered that there was in me an invincible summer. You can select any connections, objects or projects, and then select the corresponding buttons on the Information Pane. The first step is as good as half over. Success consists of going from failure to failure without loss of enthusiasm. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. Success consists of going from failure to failure without loss of enthusiasm. Remember that failure is an event, not a person. After logged in the Navicat Cloud feature, the Navigation pane will be divided into Navicat Cloud and My Connections sections. Actually it is just in an idea when feel oneself can achieve and cannot achieve. All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. Always keep your eyes open. Keep watching. Because whatever you see can inspire you. The On Startup feature allows you to control what tabs appear when you launch Navicat. Difficult circumstances serve as a textbook of life for people. After comparing data, the window shows the number of records that will be inserted, updated or deleted in the target. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. There is no way to happiness. Happiness is the way. It wasn’t raining when Noah built the ark. Remember that failure is an event, not a person. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. The reason why a great man is great is that he resolves to be a great man. SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. The repository database can be an existing MySQL, MariaDB, PostgreSQL, SQL Server, or Amazon RDS instance. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. You cannot save people, you can just love them. Actually it is just in an idea when feel oneself can achieve and cannot achieve. You must be the change you wish to see in the world. Creativity is intelligence having fun. Instead of wondering when your next vacation is, maybe you should set up a life you don’t need to escape from. A query is used to extract data from the database in a readable format according to the user\'s request. A man is not old until regrets take the place of dreams. How we spend our days is, of course, how we spend our lives. If opportunity doesn’t knock, build a door. It is used while your ISPs do not allow direct connections, but allows establishing HTTP connections. Creativity is intelligence having fun.', '2023-10-18 04:20:38', '2023-10-18 22:49:17', 0);
INSERT INTO `sales_contract` VALUES (8, 8, '萧云熙', '手机号', '萧云熙', '2023-10-18 08:41:33', '0', '萧云熙', '2023-10-18', '0', '0', '407 Lefeng 6th Rd', '2023-10-18 09:09:11', 'Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. If opportunity doesn’t knock, build a door. To connect to a database or schema, simply double-click it in the pane. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. Anyone who has ever made anything of importance was disciplined. To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. If opportunity doesn’t knock, build a door. You will succeed because most people are lazy. Remember that failure is an event, not a person. SQL Editor allows you to create and edit SQL text, prepare and execute selected queries. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. You can select any connections, objects or projects, and then select the corresponding buttons on the Information Pane. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. Creativity is intelligence having fun. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network. Creativity is intelligence having fun. A man is not old until regrets take the place of dreams. Actually it is just in an idea when feel oneself can achieve and cannot achieve. If the plan doesn’t work, change the plan, but never the goal. All journeys have secret destinations of which the traveler is unaware. What you get by achieving your goals is not as important as what you become by achieving your goals. The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up menus quickly and easily. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. I may not have gone where I intended to go, but I think I have ended up where I needed to be. How we spend our days is, of course, how we spend our lives. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. Difficult circumstances serve as a textbook of life for people. Navicat Cloud could not connect and access your databases. By which it means, it could only store your connection settings, queries, model files, and virtual group; your database passwords and data (e.g. tables, views, etc) will not be stored to Navicat Cloud. The past has no power over the present moment. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network. Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. I may not have gone where I intended to go, but I think I have ended up where I needed to be. If the plan doesn’t work, change the plan, but never the goal. The On Startup feature allows you to control what tabs appear when you launch Navicat. The first step is as good as half over. In the middle of winter I at last discovered that there was in me an invincible summer. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. If your Internet Service Provider (ISP) does not provide direct access to its server, Secure Tunneling Protocol (SSH) / HTTP is another solution.', '2023-10-18 13:21:40', '2023-10-18 22:28:42', 0);
INSERT INTO `sales_contract` VALUES (9, 9, '金子韬', '手机号', '金子韬', '2023-10-18 13:03:49', '0', '金子韬', '2023-10-18', '0', '1', '环区南街二巷228号', '2023-10-18 10:38:38', 'A man is not old until regrets take the place of dreams. If the plan doesn’t work, change the plan, but never the goal. To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences. Navicat provides powerful tools for working with queries: Query Editor for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. To connect to a database or schema, simply double-click it in the pane. If opportunity doesn’t knock, build a door. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more. A man is not old until regrets take the place of dreams. All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. Champions keep playing until they get it right. If it scares you, it might be a good thing to try. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. Sometimes you win, sometimes you learn. The reason why a great man is great is that he resolves to be a great man. The reason why a great man is great is that he resolves to be a great man. A man is not old until regrets take the place of dreams. Optimism is the one quality more associated with success and happiness than any other. In other words, Navicat provides the ability for data in different databases and/or schemas to be kept up-to-date so that each repository contains the same information. If opportunity doesn’t knock, build a door. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated. A man is not old until regrets take the place of dreams. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. All journeys have secret destinations of which the traveler is unaware. You can select any connections, objects or projects, and then select the corresponding buttons on the Information Pane. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. A man’s best friends are his ten fingers. Navicat provides powerful tools for working with queries: Query Editor for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually. Success consists of going from failure to failure without loss of enthusiasm. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. The past has no power over the present moment. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. Navicat is a multi-connections Database Administration tool allowing you to connect to MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB and/or MongoDB databases, making database administration to multiple kinds of database so easy. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up menus quickly and easily. A comfort zone is a beautiful place, but nothing ever grows there. If opportunity doesn’t knock, build a door. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more. Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. I destroy my enemies when I make them my friends. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a web server does. A man’s best friends are his ten fingers. A man’s best friends are his ten fingers. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. Navicat Monitor can be installed on any local computer or virtual machine and does not require any software installation on the servers being monitored. To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences. A man’s best friends are his ten fingers. Always keep your eyes open. Keep watching. Because whatever you see can inspire you. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. Navicat provides powerful tools for working with queries: Query Editor for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually. Anyone who has ever made anything of importance was disciplined. In the middle of winter I at last discovered that there was in me an invincible summer. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. Optimism is the one quality more associated with success and happiness than any other. I will greet this day with love in my heart. Anyone who has never made a mistake has never tried anything new. You cannot save people, you can just love them. With its well-designed Graphical User Interface(GUI), Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. The past has no power over the present moment. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. Navicat Monitor requires a repository to store alerts and metrics for historical analysis. Navicat 15 has added support for the system-wide dark mode. A query is used to extract data from the database in a readable format according to the user\'s request. Navicat provides powerful tools for working with queries: Query Editor for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually. If it scares you, it might be a good thing to try. Difficult circumstances serve as a textbook of life for people. The Synchronize to Database function will give you a full picture of all database differences. You can select any connections, objects or projects, and then select the corresponding buttons on the Information Pane. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network.', '2023-10-18 18:16:58', '2023-10-18 22:14:26', 0);
INSERT INTO `sales_contract` VALUES (10, 10, '武杰宏', '手机号', '武杰宏', '2023-10-18 21:15:57', '0', '武杰宏', '2023-10-18', '0', '0', '850 Xue Yuan Yi Xiang, Longgang', '2023-10-18 14:23:16', 'Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. If opportunity doesn’t knock, build a door. If it scares you, it might be a good thing to try. It is used while your ISPs do not allow direct connections, but allows establishing HTTP connections. If the plan doesn’t work, change the plan, but never the goal. The On Startup feature allows you to control what tabs appear when you launch Navicat. Actually it is just in an idea when feel oneself can achieve and cannot achieve. In the middle of winter I at last discovered that there was in me an invincible summer. SSH serves to prevent such vulnerabilities and allows you to access a remote server\'s shell without compromising security. After logged in the Navicat Cloud feature, the Navigation pane will be divided into Navicat Cloud and My Connections sections. How we spend our days is, of course, how we spend our lives. All the Navicat Cloud objects are located under different projects. You can share the project to other Navicat Cloud accounts for collaboration. Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. In the Objects tab, you can use the List List, Detail Detail and ER Diagram ER Diagram buttons to change the object view. To successfully establish a new connection to local/remote server - no matter via SSL or SSH, set the database login information in the General tab. To start working with your server in Navicat, you should first establish a connection or several connections using the Connection window. You will succeed because most people are lazy. SQL Editor allows you to create and edit SQL text, prepare and execute selected queries. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. If the plan doesn’t work, change the plan, but never the goal. The Information Pane shows the detailed object information, project activities, the DDL of database objects, object dependencies, membership of users/roles and preview. Sometimes you win, sometimes you learn. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. Anyone who has never made a mistake has never tried anything new. Always keep your eyes open. Keep watching. Because whatever you see can inspire you. Typically, it is employed as an encrypted version of Telnet. The reason why a great man is great is that he resolves to be a great man. Anyone who has ever made anything of importance was disciplined. Export Wizard allows you to export data from tables, collections, views, or query results to any available formats. The reason why a great man is great is that he resolves to be a great man. Navicat provides a wide range advanced features, such as compelling code editing capabilities, smart code-completion, SQL formatting, and more. How we spend our days is, of course, how we spend our lives. Anyone who has ever made anything of importance was disciplined. The past has no power over the present moment. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences. Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. Champions keep playing until they get it right. If your Internet Service Provider (ISP) does not provide direct access to its server, Secure Tunneling Protocol (SSH) / HTTP is another solution. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. If it scares you, it might be a good thing to try. Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. To get a secure connection, the first thing you need to do is to install OpenSSL Library and download Database Source. The reason why a great man is great is that he resolves to be a great man. To successfully establish a new connection to local/remote server - no matter via SSL, SSH or HTTP, set the database login information in the General tab. Navicat authorizes you to make connection to remote servers running on different platforms (i.e. Windows, macOS, Linux and UNIX), and supports PAM and GSSAPI authentication. A man is not old until regrets take the place of dreams. What you get by achieving your goals is not as important as what you become by achieving your goals. It can also manage cloud databases such as Amazon Redshift, Amazon RDS, Alibaba Cloud. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server. I may not have gone where I intended to go, but I think I have ended up where I needed to be. SQL Editor allows you to create and edit SQL text, prepare and execute selected queries. If opportunity doesn’t knock, build a door. Difficult circumstances serve as a textbook of life for people. The Main Window consists of several toolbars and panes for you to work on connections, database objects and advanced tools. Champions keep playing until they get it right. Champions keep playing until they get it right. Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as possible. A man is not old until regrets take the place of dreams. Monitored servers include MySQL, MariaDB and SQL Server, and compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud and Microsoft Azure. The Navigation pane employs tree structure which allows you to take action upon the database and their objects through their pop-up menus quickly and easily.', '2023-10-18 07:49:38', '2023-10-18 22:39:25', 0);
INSERT INTO `sales_contract` VALUES (1714932221563424768, 2, 'czl', '手机号', 'czl', '2023-10-18 21:15:57', '2023-10-18 21:15:57', 'czl', '2023-10-18', '0', '0', '漳州', '2023-10-18 14:23:16', '123123123', '2023-10-19 17:11:18', '2023-10-19 17:11:18', 1);
INSERT INTO `sales_contract` VALUES (1714939968417751040, 2, 'czl1', '手机号', 'czl1', '2023-10-18 21:15:57', '1', 'czl1', '2023-10-18', '0', '0', '漳州', '2023-10-18 14:23:16', '123123123', '2023-10-19 17:42:05', '2023-10-19 17:43:47', 0);
INSERT INTO `sales_contract` VALUES (1715036809557794816, 1, '邱晓明1', '手机号', '邱晓明', '2023-10-18 23:00:16', '0', '邱晓明', '2023-10-18', '2023-10-18', '1', '天河区大信商圈大信南路520号', '2023-10-18 16:41:17', 'Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. Secure Sockets Layer(SSL) is a protocol for transmitting private documents via the Internet. The first step is as good as half over. A man’s best friends are his ten fingers. Success consists of going from failure to failure without loss of enthusiasm. To connect to a database or schema, simply double-click it in the pane. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more.', '2023-10-20 00:06:53', '2023-10-20 00:12:41', 1);

-- ----------------------------
-- Table structure for sales_contract_materials
-- ----------------------------
DROP TABLE IF EXISTS `sales_contract_materials`;
CREATE TABLE `sales_contract_materials`  (
  `id` bigint NOT NULL COMMENT '编号',
  `serial_number` int NULL DEFAULT NULL COMMENT '序号',
  `order_quantity` int NULL DEFAULT NULL COMMENT '订货数量',
  `total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '金额',
  `sales_contract_id` bigint NULL DEFAULT NULL COMMENT '关联销售合同id',
  `materials_id` bigint NULL DEFAULT NULL COMMENT '关联物料档案id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` int NULL DEFAULT 0 COMMENT '0 未删除(默认), 1 已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '销售合同、物料档案关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sales_contract_materials
-- ----------------------------
INSERT INTO `sales_contract_materials` VALUES (1, 100, 10, 1050.00, NULL, 16273485123456789, '2023-10-19 17:43:47', '2023-10-19 17:43:47', 0);
INSERT INTO `sales_contract_materials` VALUES (2, 100, 10, 1050.00, NULL, 16273485123456790, '2023-10-19 17:43:47', '2023-10-19 17:43:47', 0);
INSERT INTO `sales_contract_materials` VALUES (16, 100, 10, 1050.00, 1714939968417751040, 16273485123456789, '2023-10-19 17:42:05', '2023-10-19 17:42:05', 1);
INSERT INTO `sales_contract_materials` VALUES (17, 100, 10, 1050.00, 1714939968417751040, 16273485123456790, '2023-10-19 17:42:05', '2023-10-19 17:42:05', 1);
INSERT INTO `sales_contract_materials` VALUES (48, 10, 31, 481.42, 9, 16273485123456793, '2023-10-19 04:57:14', '2023-10-19 07:13:05', 0);
INSERT INTO `sales_contract_materials` VALUES (198, 48, 48, 427.26, 3, 16273485123456791, '2023-10-19 04:22:15', '2023-10-19 13:50:49', 0);
INSERT INTO `sales_contract_materials` VALUES (453, 22, 46, 392.26, 2, 16273485123456799, '2023-10-19 12:56:07', '2023-10-19 12:34:47', 0);
INSERT INTO `sales_contract_materials` VALUES (466, 11, 28, 693.38, 1, 16273485123456799, '2023-10-19 15:02:40', '2023-10-19 15:27:59', 0);
INSERT INTO `sales_contract_materials` VALUES (467, 36, 5, 227.83, 5, 16273485123456795, '2023-10-19 17:06:24', '2023-10-19 04:24:17', 0);
INSERT INTO `sales_contract_materials` VALUES (490, 48, 39, 681.26, 2, 16273485123456794, '2023-10-19 12:38:35', '2023-10-19 12:26:54', 0);
INSERT INTO `sales_contract_materials` VALUES (545, 11, 25, 295.89, 6, 1685456614185582592, '2023-10-19 00:54:53', '2023-10-19 18:33:12', 0);
INSERT INTO `sales_contract_materials` VALUES (604, 6, 34, 719.27, 6, 16273485123456791, '2023-10-19 17:12:48', '2023-10-19 03:06:42', 0);
INSERT INTO `sales_contract_materials` VALUES (612, 21, 31, 878.97, 1, 16273485123456794, '2023-10-19 10:25:33', '2023-10-19 02:50:04', 0);
INSERT INTO `sales_contract_materials` VALUES (616, 35, 37, 862.60, 8, 16273485123456792, '2023-10-19 19:20:20', '2023-10-19 22:54:16', 0);
INSERT INTO `sales_contract_materials` VALUES (625, 12, 43, 671.43, 4, 1685519233764327424, '2023-10-19 10:04:55', '2023-10-19 02:00:26', 0);
INSERT INTO `sales_contract_materials` VALUES (743, 24, 12, 400.50, 8, 16273485123456799, '2023-10-19 03:47:17', '2023-10-19 09:33:21', 0);
INSERT INTO `sales_contract_materials` VALUES (789, 34, 11, 828.27, 3, 16273485123456794, '2023-10-19 05:55:20', '2023-10-19 22:48:36', 0);
INSERT INTO `sales_contract_materials` VALUES (834, 28, 14, 494.42, 3, 16273485123456803, '2023-10-19 08:06:41', '2023-10-19 12:54:34', 0);
INSERT INTO `sales_contract_materials` VALUES (991, 18, 37, 240.10, 2, 16273485123456800, '2023-10-19 16:33:13', '2023-10-19 16:52:26', 0);
INSERT INTO `sales_contract_materials` VALUES (1715037095709990912, 11, 28, 693.38, 1715036809557794816, 16273485123456790, '2023-10-20 00:08:02', '2023-10-20 00:08:02', 1);
INSERT INTO `sales_contract_materials` VALUES (1715037095709990913, 21, 31, 878.97, 1715036809557794816, 16273485123456789, '2023-10-20 00:08:02', '2023-10-20 00:08:02', 1);
INSERT INTO `sales_contract_materials` VALUES (1715038270006034432, 11, 28, 693.38, 1715036809557794816, 16273485123456790, '2023-10-20 00:12:42', '2023-10-20 00:12:42', 1);
INSERT INTO `sales_contract_materials` VALUES (1715038270006034433, 21, 31, 878.97, 1715036809557794816, 16273485123456789, '2023-10-20 00:12:42', '2023-10-20 00:12:42', 1);

-- ----------------------------
-- Table structure for sales_order
-- ----------------------------
DROP TABLE IF EXISTS `sales_order`;
CREATE TABLE `sales_order`  (
  `id` bigint NOT NULL COMMENT '订单编号',
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户名称',
  `total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '金额合计',
  `delivery_date` datetime NULL DEFAULT NULL COMMENT '交货日期',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` int NULL DEFAULT 0 COMMENT '0 未删除(默认), 1 已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '销售订单' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sales_order
-- ----------------------------
INSERT INTO `sales_order` VALUES (1, '尹璐', 771.76, '2023-10-18 19:18:17', '2023-10-18 14:49:14', '2023-10-18 11:36:19', 0);
INSERT INTO `sales_order` VALUES (2, '苏岚', 125.25, '2023-10-18 01:28:24', '2023-10-18 10:20:25', '2023-10-18 09:56:29', 0);
INSERT INTO `sales_order` VALUES (3, '严睿', 443.90, '2023-10-18 19:46:56', '2023-10-18 19:04:48', '2023-10-18 12:31:52', 0);
INSERT INTO `sales_order` VALUES (4, '金云熙', 878.02, '2023-10-18 07:32:22', '2023-10-18 16:12:28', '2023-10-18 02:57:04', 0);
INSERT INTO `sales_order` VALUES (5, '蒋安琪', 416.08, '2023-10-18 03:30:43', '2023-10-18 02:03:25', '2023-10-18 11:24:23', 0);
INSERT INTO `sales_order` VALUES (6, '宋璐', 594.79, '2023-10-18 12:21:35', '2023-10-18 14:18:38', '2023-10-18 13:23:59', 0);
INSERT INTO `sales_order` VALUES (7, '张嘉伦', 128.86, '2023-10-18 16:41:41', '2023-10-18 23:35:11', '2023-10-18 15:15:32', 0);
INSERT INTO `sales_order` VALUES (8, '刘安琪', 928.14, '2023-10-18 05:25:01', '2023-10-18 07:16:06', '2023-10-18 10:38:22', 0);
INSERT INTO `sales_order` VALUES (9, '贺震南', 802.31, '2023-10-18 11:40:42', '2023-10-18 06:42:11', '2023-10-18 05:46:44', 0);
INSERT INTO `sales_order` VALUES (10, '顾杰宏', 860.30, '2023-10-18 14:09:10', '2023-10-18 19:20:48', '2023-10-18 04:46:05', 1);
INSERT INTO `sales_order` VALUES (1715040123179503616, '尹璐', 771.76, '2023-10-18 19:18:17', '2023-10-20 00:20:04', '2023-10-20 00:22:42', 1);

-- ----------------------------
-- Table structure for sales_return
-- ----------------------------
DROP TABLE IF EXISTS `sales_return`;
CREATE TABLE `sales_return`  (
  `id` bigint NOT NULL COMMENT '编号',
  `return_order_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '退货单号',
  `shipping_order_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发货单号',
  `return_date` datetime NULL DEFAULT NULL COMMENT '退货日期',
  `refund_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '退款金额',
  `reason_return` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '退款原因',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  `delivery_order_id` bigint NULL DEFAULT NULL COMMENT '关联发货单表id',
  `warehousing_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '入库状态(0未入库 1已入库)',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` int NULL DEFAULT 0 COMMENT '0 未删除(默认), 1 已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '销售退货表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sales_return
-- ----------------------------
INSERT INTO `sales_return` VALUES (1, '326387313640600171', '976892203055579822', '2023-10-20 08:11:46', 297.01, 'Difficult circumstances serve as                  ', 'The reason why a great man is great               ', 14, '1', '2023-10-20 13:32:53', '2023-10-20 06:10:56', 0);
INSERT INTO `sales_return` VALUES (2, '316870595763065058', '805771304357101869', '2023-10-20 08:42:11', 997.75, 'Navicat Monitor can be installed                  ', 'In a Telnet session, all communications,          ', 8, '0', '2023-10-20 23:31:11', '2023-10-20 06:33:21', 0);
INSERT INTO `sales_return` VALUES (3, '316900143218165209', '306977894068491505', '2023-10-20 04:13:36', 848.13, 'In the Objects tab, you can use                   ', 'Import Wizard allows you to import                ', 3, '1', '2023-10-20 13:08:37', '2023-10-20 22:11:25', 0);
INSERT INTO `sales_return` VALUES (4, '377139370892537132', '710975714643395058', '2023-10-20 19:31:02', 710.94, 'The Information Pane shows the                    ', 'Navicat Monitor is a safe, simple                 ', 12, '0', '2023-10-20 12:12:02', '2023-10-20 03:37:02', 0);
INSERT INTO `sales_return` VALUES (5, '931671174447708024', '110896509690485334', '2023-10-20 13:10:48', 84.40, 'In the Objects tab, you can use                   ', 'In the middle of winter I at last                 ', 1715271820517101568, '1', '2023-10-20 09:55:58', '2023-10-20 16:05:31', 0);
INSERT INTO `sales_return` VALUES (6, '677121480559037803', '757477725370765118', '2023-10-20 11:37:16', 991.33, 'Secure Sockets Layer(SSL) is a                    ', 'Such sessions are also susceptible                ', 15, '1', '2023-10-20 05:06:04', '2023-10-20 01:39:38', 0);
INSERT INTO `sales_return` VALUES (7, '848261686978239685', '776519589526097966', '2023-10-20 18:49:11', 679.55, 'It collects process metrics such                  ', 'Monitored servers include MySQL,                  ', 6, '1', '2023-10-20 03:58:37', '2023-10-20 14:22:19', 0);
INSERT INTO `sales_return` VALUES (8, '600553103017124020', '914607981918584358', '2023-10-20 21:17:33', 326.99, 'Navicat 15 has added support for                  ', 'To open a query using an external                 ', 11, '0', '2023-10-20 02:59:31', '2023-10-20 13:47:15', 0);
INSERT INTO `sales_return` VALUES (9, '088550788186411736', '733721572207483057', '2023-10-20 05:08:55', 242.44, 'Export Wizard allows you to export                ', 'The On Startup feature allows you                 ', 2, '1', '2023-10-20 18:37:25', '2023-10-20 19:20:52', 0);
INSERT INTO `sales_return` VALUES (10, '528346584219500831', '648046831921888924', '2023-10-20 08:38:36', 340.19, 'Always keep your eyes open. Keep                  ', 'How we spend our days is, of course,              ', 4, '1', '2023-10-20 04:15:42', '2023-10-20 20:44:57', 0);
INSERT INTO `sales_return` VALUES (11, '932461976529101598', '458189952656741814', '2023-10-20 23:41:42', 602.64, 'Sometimes you win, sometimes you learn.', 'Flexible settings enable you to                   ', 1, '0', '2023-10-20 06:43:24', '2023-10-20 09:40:38', 0);
INSERT INTO `sales_return` VALUES (12, '831926433589155267', '197305549174606992', '2023-10-20 07:45:01', 923.34, 'Typically, it is employed as an                   ', 'Optimism is the one quality more                  ', 7, '0', '2023-10-20 22:58:27', '2023-10-20 15:14:47', 0);
INSERT INTO `sales_return` VALUES (13, '315832237213462224', '985677008876670232', '2023-10-20 05:37:58', 385.03, 'Monitored servers include MySQL,                  ', 'Navicat provides powerful tools                   ', 5, '0', '2023-10-20 11:38:18', '2023-10-20 17:51:42', 0);
INSERT INTO `sales_return` VALUES (14, '049579488884004506', '573866000608737858', '2023-10-20 22:40:22', 835.53, 'Navicat provides powerful tools                   ', 'The past has no power over the present moment.', 10, '1', '2023-10-20 19:12:48', '2023-10-20 11:29:31', 0);
INSERT INTO `sales_return` VALUES (15, '215853351760827342', '784350668051399721', '2023-10-20 01:44:35', 707.26, 'If opportunity doesn’t knock, build a door.', 'To successfully establish a new                   ', 13, '0', '2023-10-20 18:28:46', '2023-10-20 03:06:22', 0);
INSERT INTO `sales_return` VALUES (16, '718760738110244027', '941706806735248556', '2023-10-20 01:48:21', 971.58, 'The repository database can be                    ', 'To open a query using an external                 ', 9, '1', '2023-10-20 01:01:32', '2023-10-20 21:46:36', 0);
INSERT INTO `sales_return` VALUES (1715409582402617344, '831926433589155268', '197305549174606993', '2023-10-20 07:45:01', 1000.00, 'Typically, it is employed as an                   ', 'Optimism is the one quality more                  ', 17, '0', '2023-10-21 00:48:09', '2023-10-21 00:53:25', 1);

-- ----------------------------
-- Table structure for sales_return_detail
-- ----------------------------
DROP TABLE IF EXISTS `sales_return_detail`;
CREATE TABLE `sales_return_detail`  (
  `id` bigint NOT NULL COMMENT '编号',
  `sales_return_id` bigint NULL DEFAULT NULL COMMENT '关联销售退货表id',
  `material` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '物料',
  `model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '型号',
  `specification` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规格',
  `unit` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '单位',
  `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '价格',
  `order_quantity` int NOT NULL COMMENT '订货数量',
  `shipped_quantity` int NOT NULL COMMENT '发货数量',
  `return_quantity` int NOT NULL COMMENT '退货数量',
  `remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` int UNSIGNED NULL DEFAULT 0 COMMENT '0 未删除(默认), 1 已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '销售退货明细' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sales_return_detail
-- ----------------------------
INSERT INTO `sales_return_detail` VALUES (1, 12, 'Kiwi', 'QDPIJNMXMN', '加细码', 'lb', 557.76, 49, 86, 55, 'In other words, Navicat provides                  ', '2023-10-20 03:37:10', '2023-10-20 19:14:28', 0);
INSERT INTO `sales_return_detail` VALUES (2, 16, 'ambi-Mingo', 'SEBEVGBRTP', '大码', 'g', 389.16, 82, 33, 68, 'In a Telnet session, all communications,          ', '2023-10-20 14:48:28', '2023-10-20 18:13:54', 0);
INSERT INTO `sales_return_detail` VALUES (3, 2, 'naspberry', 'CFWNPDLTWC', '加加大码', 'g', 168.88, 88, 79, 85, 'To successfully establish a new                   ', '2023-10-20 14:41:46', '2023-10-20 03:54:23', 0);
INSERT INTO `sales_return_detail` VALUES (4, 5, 'Pluous', 'KQSDRYXFIE', '大码', 'g', 144.47, 70, 11, 68, 'A query is used to extract data                   ', '2023-10-20 06:21:32', '2023-10-20 21:49:23', 0);
INSERT INTO `sales_return_detail` VALUES (5, 1, 'Strawberry', 'SQYPLZWZWN', '大码', 'g', 555.26, 90, 33, 91, 'In a Telnet session, all communications,          ', '2023-10-20 16:36:51', '2023-10-20 15:02:14', 0);
INSERT INTO `sales_return_detail` VALUES (6, 7, 'Apple', 'EMLLOYDFWF', '加加大码', 'kg', 911.60, 14, 91, 20, 'It collects process metrics such                  ', '2023-10-20 09:13:25', '2023-10-20 12:09:32', 0);
INSERT INTO `sales_return_detail` VALUES (7, 13, 'Oraage', 'WUVIDWOJDN', '加大码', 'lb', 856.28, 11, 69, 49, 'Navicat Cloud provides a cloud                    ', '2023-10-20 09:04:31', '2023-10-20 22:51:00', 0);
INSERT INTO `sales_return_detail` VALUES (8, 3, 'Manjo', 'LTJALTAQOV', '加细码', 'lb', 499.59, 12, 76, 89, 'Actually it is just in an idea                    ', '2023-10-20 03:29:12', '2023-10-20 12:03:03', 0);
INSERT INTO `sales_return_detail` VALUES (9, 4, 'Grape', 'WMXGBUEJMT', '细码', 'kg', 262.06, 63, 87, 53, 'It provides strong authentication                 ', '2023-10-20 20:07:38', '2023-10-20 14:45:42', 0);
INSERT INTO `sales_return_detail` VALUES (10, 11, 'Apple core', 'VRWTGAGGWJ', '中码', 'kg', 170.43, 35, 17, 33, 'Navicat is a multi-connections                    ', '2023-10-20 11:50:43', '2023-10-20 17:48:30', 0);
INSERT INTO `sales_return_detail` VALUES (11, 14, 'Grppe', 'TAPTHFUNXP', '加加大码', 'g', 490.33, 33, 34, 5, 'Navicat Monitor can be installed                  ', '2023-10-20 05:51:14', '2023-10-20 07:21:08', 0);
INSERT INTO `sales_return_detail` VALUES (12, 15, 'Maygo', 'UDHOPBQXSB', '大码', 'lb', 286.11, 15, 84, 65, 'All journeys have secret destinations             ', '2023-10-20 22:29:46', '2023-10-20 01:23:44', 0);
INSERT INTO `sales_return_detail` VALUES (13, 8, 'Orange mini', 'ZZSZXMKKDK', '中码', 'g', 441.94, 92, 26, 97, 'The Synchronize to Database function              ', '2023-10-20 13:14:30', '2023-10-20 08:12:09', 0);
INSERT INTO `sales_return_detail` VALUES (14, 9, 'Raspberry', 'EWRLUIGNYU', '加细码', 'kg', 498.24, 63, 86, 40, 'Import Wizard allows you to import                ', '2023-10-20 16:05:07', '2023-10-20 08:46:28', 0);
INSERT INTO `sales_return_detail` VALUES (15, 6, 'Macgo pi', 'UQHZZWNYDK', '加大码', 'g', 830.75, 23, 61, 62, 'Creativity is intelligence having fun.', '2023-10-20 19:35:13', '2023-10-20 00:14:55', 0);
INSERT INTO `sales_return_detail` VALUES (16, 10, 'Mango elite', 'MNCYIHBHDS', '加大码', 'kg', 492.92, 22, 50, 73, 'It collects process metrics such                  ', '2023-10-20 18:04:15', '2023-10-20 01:32:25', 0);
INSERT INTO `sales_return_detail` VALUES (1715409582402617345, 1715409582402617344, 'Kiwi', 'QDPIJNMXMN', '加细码1', 'lb', 557.76, 49, 86, 55, 'In other words, Navicat provides                  ', '2023-10-21 00:48:09', '2023-10-21 00:53:25', 1);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` bigint NOT NULL COMMENT '编号',
  `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
  `status` int NULL DEFAULT 1 COMMENT '状态 0 禁用,1 正常',
  `email` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `gender` int NULL DEFAULT 2 COMMENT '性别 0 男,1 女,2 未知',
  `avatar` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像',
  `user_type` int NOT NULL DEFAULT 1 COMMENT '用户类型 0 管理员,1 普通用户',
  `introduction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '用户介绍',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username`(`username` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'admin', '$2a$10$Guqke1hPZ3utN4ml8ScmyuzOhW/lLrLbK70U8N6yXqspF.S.Hfx8a', 1, '2691727222@qq.com', 2, 'https://gd-hbimg.huaban.com/49966c7f665313b06b4a00ba5cd85cc70d2a305213802-mxoGcU', 0, '不知道捏', '2023-07-19 10:21:15', '2023-07-19 10:21:18');

SET FOREIGN_KEY_CHECKS = 1;