sql/personnel.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
 Navicat Premium Data Transfer

 Source Server         : 本机
 Source Server Type    : MySQL
 Source Server Version : 50737
 Source Host           : localhost:3306
 Source Schema         : personnel

 Target Server Type    : MySQL
 Target Server Version : 50737
 File Encoding         : 65001

 Date: 11/03/2022 11:24:22
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for give
-- ----------------------------
DROP TABLE IF EXISTS `give`;
CREATE TABLE `give`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NULL DEFAULT NULL,
  `give_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `give_phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `give_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `product_count` int(11) NULL DEFAULT NULL COMMENT '物资数量',
  `unit` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位',
  `logistic_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '物流单号',
  `createdate` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建日期',
  `user_id` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 48 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of give
-- ----------------------------
INSERT INTO `give` VALUES (43, 24, '1', '1', '1', 1, '1', '1', '22-03-05 07:07:37', 1);
INSERT INTO `give` VALUES (36, 24, '1', '1', '1', 1, '1', '1', '22-03-05 07:03:49', 1);
INSERT INTO `give` VALUES (37, 24, '1', '1', '1', 1, '1', '1', '22-03-05 07:04:23', 1);
INSERT INTO `give` VALUES (38, 24, '1', '1', '1', 1, '1', '1', '22-03-05 07:05:38', 1);
INSERT INTO `give` VALUES (42, 24, '1', '1', '1', 1, '1', '1', '22-03-05 07:07:36', 1);
INSERT INTO `give` VALUES (41, 24, '1', '1', '1', 1, '1', '1', '22-03-05 07:07:36', 1);
INSERT INTO `give` VALUES (40, 24, '1', '1', '1', 1, '1', '1', '22-03-05 07:07:35', 1);
INSERT INTO `give` VALUES (39, 24, '1', '1', '1', 1, '1', '1', '22-03-05 07:07:34', 1);
INSERT INTO `give` VALUES (44, 24, '1', '1', '1', 1, '1', '1', '22-03-05 07:08:22', 1);
INSERT INTO `give` VALUES (45, 24, '1', '1', '1', 1, '1', '1', '22-03-05 07:10:04', 1);
INSERT INTO `give` VALUES (46, 34, '1', '1', '1', 1, '1', '1', '22-03-07 12:43:59', 1);
INSERT INTO `give` VALUES (47, 34, '小蓝', '12311241', '山东省XX市', 5, '袋', '12341412', '22-03-07 12:52:11', 1);

-- ----------------------------
-- Table structure for healthy
-- ----------------------------
DROP TABLE IF EXISTS `healthy`;
CREATE TABLE `healthy`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NULL DEFAULT NULL,