DB_51Aspx/phms.sql

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

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

/*
 Navicat Premium Data Transfer

 Source Server         : root
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : localhost:3306
 Source Schema         : phms

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

 Date: 27/06/2022 15:48:45
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for appointment
-- ----------------------------
DROP TABLE IF EXISTS `appointment`;
CREATE TABLE `appointment`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `pet_id` bigint(20) NULL DEFAULT NULL,
  `user_id` bigint(20) NULL DEFAULT NULL,
  `doctor_id` bigint(20) NULL DEFAULT NULL,
  `app_time` datetime(0) NULL DEFAULT NULL,
  `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `status` int(5) NULL DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of appointment
-- ----------------------------
INSERT INTO `appointment` VALUES (1, 1, 1, 1, '2020-04-23 20:33:08', '555', '2020-04-23 20:33:11', 4, NULL, NULL);
INSERT INTO `appointment` VALUES (2, 1, 1, 1, '2020-04-25 00:00:00', 'hhh', '2020-04-25 20:20:25', 4, '1776222', '555');
INSERT INTO `appointment` VALUES (3, 2, 1, 5, '2020-04-25 21:23:56', '6666', '2020-04-25 21:23:59', 4, '17788885555', '5555');
INSERT INTO `appointment` VALUES (4, 3, 6, 5, '2020-04-03 00:00:00', '555', '2020-04-25 22:51:43', 2, '17768583634', '8888');
INSERT INTO `appointment` VALUES (6, 3, 6, 9, '2020-04-25 00:00:00', '11', '2020-04-25 22:58:15', 4, '18899998888', '1111');
INSERT INTO `appointment` VALUES (7, 3, 6, 9, '2020-04-25 00:00:00', '111', '2020-04-25 23:03:26', 4, '11', '11');
INSERT INTO `appointment` VALUES (10, 6, 13, 5, '2020-04-28 00:00:00', '就医', '2020-04-26 08:17:33', 4, '18860887816', '江苏宜兴');
INSERT INTO `appointment` VALUES (11, 6, 13, 5, '2020-04-26 08:30:40', '宠物异常', '2020-04-26 08:30:43', 2, '18860887816', '江苏宜兴');
INSERT INTO `appointment` VALUES (12, 7, 13, 5, '2020-04-26 08:40:30', '就医', '2020-04-26 08:40:33', 2, '18860887816', '东北');
INSERT INTO `appointment` VALUES (13, 5, 11, 5, '2020-04-26 08:50:38', '发烧', '2020-04-26 08:50:40', 4, '18860777777', '天津');
INSERT INTO `appointment` VALUES (14, 8, 17, 5, '2020-04-26 14:05:52', '热热热', '2020-04-26 14:05:57', 4, '18860887816', '江苏宜兴');
INSERT INTO `appointment` VALUES (15, 9, 18, 5, '2020-04-26 16:46:36', '发烧', '2020-04-26 16:46:39', 2, '18860887711', '江苏');
INSERT INTO `appointment` VALUES (17, 11, 18, 26, '2020-04-26 17:20:55', '人人', '2020-04-26 17:20:58', 3, '18860887816', '人人');
INSERT INTO `appointment` VALUES (18, 12, 20, 21, '2020-04-26 17:34:04', 'qq', '2020-04-26 17:34:06', 4, '18860887816', '江苏宜兴');
INSERT INTO `appointment` VALUES (19, 12, 20, 26, '2020-04-26 17:34:04', 'qq', '2020-04-26 17:34:07', 3, '18860887816', '江苏宜兴');
INSERT INTO `appointment` VALUES (20, 14, 23, 21, '2020-04-26 19:12:33', '发烧', '2020-04-26 19:12:36', 4, '18860887711', '江苏');
INSERT INTO `appointment` VALUES (21, 16, 24, 21, '2020-04-26 19:42:43', '发烧', '2020-04-26 19:42:46', 4, '18860887711', '江苏');
INSERT INTO `appointment` VALUES (22, 17, 24, 26, '2020-04-26 21:35:13', '66666', '2020-04-26 21:35:16', 3, '18899998888', '555');
INSERT INTO `appointment` VALUES (23, 19, 25, 26, '2020-04-29 11:17:27', '感冒', '2020-04-29 11:17:29', 4, '18860887711', '江苏');
INSERT INTO `appointment` VALUES (24, 20, 1, 26, '2020-04-29 20:39:14', '生病', '2020-04-29 20:39:17', 3, '18888889998', '南京');