You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
420 lines
24 KiB
420 lines
24 KiB
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : gaopeng
|
|
Source Server Type : MySQL
|
|
Source Server Version : 80029
|
|
Source Host : localhost:3306
|
|
Source Schema : hospital2
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 80029
|
|
File Encoding : 65001
|
|
|
|
Date: 28/09/2022 22:40:13
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for admin
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `admin`;
|
|
CREATE TABLE `admin` (
|
|
`id` int(0) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`password` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '管理员' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of admin
|
|
-- ----------------------------
|
|
INSERT INTO `admin` VALUES (1, 'admin', '123456');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for auth_group
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `auth_group`;
|
|
CREATE TABLE `auth_group` (
|
|
`id` int(0) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE INDEX `name`(`name`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of auth_group
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for auth_group_permissions
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `auth_group_permissions`;
|
|
CREATE TABLE `auth_group_permissions` (
|
|
`id` bigint(0) NOT NULL AUTO_INCREMENT,
|
|
`group_id` int(0) NOT NULL,
|
|
`permission_id` int(0) NOT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE INDEX `auth_group_permissions_group_id_permission_id_0cd325b0_uniq`(`group_id`, `permission_id`) USING BTREE,
|
|
INDEX `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm`(`permission_id`) USING BTREE,
|
|
CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
|
CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of auth_group_permissions
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for auth_permission
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `auth_permission`;
|
|
CREATE TABLE `auth_permission` (
|
|
`id` int(0) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`content_type_id` int(0) NOT NULL,
|
|
`codename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE INDEX `auth_permission_content_type_id_codename_01ab375a_uniq`(`content_type_id`, `codename`) USING BTREE,
|
|
CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of auth_permission
|
|
-- ----------------------------
|
|
INSERT INTO `auth_permission` VALUES (1, 'Can add log entry', 1, 'add_logentry');
|
|
INSERT INTO `auth_permission` VALUES (2, 'Can change log entry', 1, 'change_logentry');
|
|
INSERT INTO `auth_permission` VALUES (3, 'Can delete log entry', 1, 'delete_logentry');
|
|
INSERT INTO `auth_permission` VALUES (4, 'Can view log entry', 1, 'view_logentry');
|
|
INSERT INTO `auth_permission` VALUES (5, 'Can add permission', 2, 'add_permission');
|
|
INSERT INTO `auth_permission` VALUES (6, 'Can change permission', 2, 'change_permission');
|
|
INSERT INTO `auth_permission` VALUES (7, 'Can delete permission', 2, 'delete_permission');
|
|
INSERT INTO `auth_permission` VALUES (8, 'Can view permission', 2, 'view_permission');
|
|
INSERT INTO `auth_permission` VALUES (9, 'Can add group', 3, 'add_group');
|
|
INSERT INTO `auth_permission` VALUES (10, 'Can change group', 3, 'change_group');
|
|
INSERT INTO `auth_permission` VALUES (11, 'Can delete group', 3, 'delete_group');
|
|
INSERT INTO `auth_permission` VALUES (12, 'Can view group', 3, 'view_group');
|
|
INSERT INTO `auth_permission` VALUES (13, 'Can add user', 4, 'add_user');
|
|
INSERT INTO `auth_permission` VALUES (14, 'Can change user', 4, 'change_user');
|
|
INSERT INTO `auth_permission` VALUES (15, 'Can delete user', 4, 'delete_user');
|
|
INSERT INTO `auth_permission` VALUES (16, 'Can view user', 4, 'view_user');
|
|
INSERT INTO `auth_permission` VALUES (17, 'Can add content type', 5, 'add_contenttype');
|
|
INSERT INTO `auth_permission` VALUES (18, 'Can change content type', 5, 'change_contenttype');
|
|
INSERT INTO `auth_permission` VALUES (19, 'Can delete content type', 5, 'delete_contenttype');
|
|
INSERT INTO `auth_permission` VALUES (20, 'Can view content type', 5, 'view_contenttype');
|
|
INSERT INTO `auth_permission` VALUES (21, 'Can add session', 6, 'add_session');
|
|
INSERT INTO `auth_permission` VALUES (22, 'Can change session', 6, 'change_session');
|
|
INSERT INTO `auth_permission` VALUES (23, 'Can delete session', 6, 'delete_session');
|
|
INSERT INTO `auth_permission` VALUES (24, 'Can view session', 6, 'view_session');
|
|
INSERT INTO `auth_permission` VALUES (25, 'Can add admin', 7, 'add_admin');
|
|
INSERT INTO `auth_permission` VALUES (26, 'Can change admin', 7, 'change_admin');
|
|
INSERT INTO `auth_permission` VALUES (27, 'Can delete admin', 7, 'delete_admin');
|
|
INSERT INTO `auth_permission` VALUES (28, 'Can view admin', 7, 'view_admin');
|
|
INSERT INTO `auth_permission` VALUES (29, 'Can add user_patient', 8, 'add_user_patient');
|
|
INSERT INTO `auth_permission` VALUES (30, 'Can change user_patient', 8, 'change_user_patient');
|
|
INSERT INTO `auth_permission` VALUES (31, 'Can delete user_patient', 8, 'delete_user_patient');
|
|
INSERT INTO `auth_permission` VALUES (32, 'Can view user_patient', 8, 'view_user_patient');
|
|
INSERT INTO `auth_permission` VALUES (33, 'Can add user_doctor', 9, 'add_user_doctor');
|
|
INSERT INTO `auth_permission` VALUES (34, 'Can change user_doctor', 9, 'change_user_doctor');
|
|
INSERT INTO `auth_permission` VALUES (35, 'Can delete user_doctor', 9, 'delete_user_doctor');
|
|
INSERT INTO `auth_permission` VALUES (36, 'Can view user_doctor', 9, 'view_user_doctor');
|
|
INSERT INTO `auth_permission` VALUES (37, 'Can add department', 10, 'add_department');
|
|
INSERT INTO `auth_permission` VALUES (38, 'Can change department', 10, 'change_department');
|
|
INSERT INTO `auth_permission` VALUES (39, 'Can delete department', 10, 'delete_department');
|
|
INSERT INTO `auth_permission` VALUES (40, 'Can view department', 10, 'view_department');
|
|
INSERT INTO `auth_permission` VALUES (41, 'Can add medicine', 11, 'add_medicine');
|
|
INSERT INTO `auth_permission` VALUES (42, 'Can change medicine', 11, 'change_medicine');
|
|
INSERT INTO `auth_permission` VALUES (43, 'Can delete medicine', 11, 'delete_medicine');
|
|
INSERT INTO `auth_permission` VALUES (44, 'Can view medicine', 11, 'view_medicine');
|
|
INSERT INTO `auth_permission` VALUES (45, 'Can add order', 12, 'add_order');
|
|
INSERT INTO `auth_permission` VALUES (46, 'Can change order', 12, 'change_order');
|
|
INSERT INTO `auth_permission` VALUES (47, 'Can delete order', 12, 'delete_order');
|
|
INSERT INTO `auth_permission` VALUES (48, 'Can view order', 12, 'view_order');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for auth_user
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `auth_user`;
|
|
CREATE TABLE `auth_user` (
|
|
`id` int(0) NOT NULL AUTO_INCREMENT,
|
|
`password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`last_login` datetime(6) NULL DEFAULT NULL,
|
|
`is_superuser` tinyint(1) NOT NULL,
|
|
`username` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`first_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`last_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`email` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`is_staff` tinyint(1) NOT NULL,
|
|
`is_active` tinyint(1) NOT NULL,
|
|
`date_joined` datetime(6) NOT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE INDEX `username`(`username`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of auth_user
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for auth_user_groups
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `auth_user_groups`;
|
|
CREATE TABLE `auth_user_groups` (
|
|
`id` bigint(0) NOT NULL AUTO_INCREMENT,
|
|
`user_id` int(0) NOT NULL,
|
|
`group_id` int(0) NOT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE INDEX `auth_user_groups_user_id_group_id_94350c0c_uniq`(`user_id`, `group_id`) USING BTREE,
|
|
INDEX `auth_user_groups_group_id_97559544_fk_auth_group_id`(`group_id`) USING BTREE,
|
|
CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
|
CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of auth_user_groups
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for auth_user_user_permissions
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `auth_user_user_permissions`;
|
|
CREATE TABLE `auth_user_user_permissions` (
|
|
`id` bigint(0) NOT NULL AUTO_INCREMENT,
|
|
`user_id` int(0) NOT NULL,
|
|
`permission_id` int(0) NOT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE INDEX `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq`(`user_id`, `permission_id`) USING BTREE,
|
|
INDEX `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm`(`permission_id`) USING BTREE,
|
|
CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
|
CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of auth_user_user_permissions
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for department
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `department`;
|
|
CREATE TABLE `department` (
|
|
`id` int(0) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`registration_fee` decimal(10, 2) NULL DEFAULT NULL,
|
|
`doctor_num` int(0) NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '科室表' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of department
|
|
-- ----------------------------
|
|
INSERT INTO `department` VALUES (1, '儿科', 20.00, 0);
|
|
INSERT INTO `department` VALUES (2, '妇科', 20.00, 0);
|
|
INSERT INTO `department` VALUES (3, '外科', 20.00, 0);
|
|
INSERT INTO `department` VALUES (4, '内科', 20.00, 0);
|
|
INSERT INTO `department` VALUES (5, '耳鼻咽喉科', 20.00, 0);
|
|
INSERT INTO `department` VALUES (6, '眼科', 25.00, 0);
|
|
INSERT INTO `department` VALUES (7, '骨科', 25.00, 0);
|
|
INSERT INTO `department` VALUES (8, '皮肤科', 20.00, 0);
|
|
|
|
-- ----------------------------
|
|
-- Table structure for django_admin_log
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `django_admin_log`;
|
|
CREATE TABLE `django_admin_log` (
|
|
`id` int(0) NOT NULL AUTO_INCREMENT,
|
|
`action_time` datetime(6) NOT NULL,
|
|
`object_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
|
|
`object_repr` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`action_flag` smallint(0) UNSIGNED NOT NULL,
|
|
`change_message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`content_type_id` int(0) NULL DEFAULT NULL,
|
|
`user_id` int(0) NOT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
INDEX `django_admin_log_content_type_id_c4bce8eb_fk_django_co`(`content_type_id`) USING BTREE,
|
|
INDEX `django_admin_log_user_id_c564eba6_fk_auth_user_id`(`user_id`) USING BTREE,
|
|
CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
|
CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of django_admin_log
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for django_content_type
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `django_content_type`;
|
|
CREATE TABLE `django_content_type` (
|
|
`id` int(0) NOT NULL AUTO_INCREMENT,
|
|
`app_label` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE INDEX `django_content_type_app_label_model_76bd3d3b_uniq`(`app_label`, `model`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of django_content_type
|
|
-- ----------------------------
|
|
INSERT INTO `django_content_type` VALUES (1, 'admin', 'logentry');
|
|
INSERT INTO `django_content_type` VALUES (3, 'auth', 'group');
|
|
INSERT INTO `django_content_type` VALUES (2, 'auth', 'permission');
|
|
INSERT INTO `django_content_type` VALUES (4, 'auth', 'user');
|
|
INSERT INTO `django_content_type` VALUES (5, 'contenttypes', 'contenttype');
|
|
INSERT INTO `django_content_type` VALUES (7, 'hospital', 'admin');
|
|
INSERT INTO `django_content_type` VALUES (10, 'hospital', 'department');
|
|
INSERT INTO `django_content_type` VALUES (11, 'hospital', 'medicine');
|
|
INSERT INTO `django_content_type` VALUES (12, 'hospital', 'order');
|
|
INSERT INTO `django_content_type` VALUES (9, 'hospital', 'user_doctor');
|
|
INSERT INTO `django_content_type` VALUES (8, 'hospital', 'user_patient');
|
|
INSERT INTO `django_content_type` VALUES (6, 'sessions', 'session');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for django_migrations
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `django_migrations`;
|
|
CREATE TABLE `django_migrations` (
|
|
`id` bigint(0) NOT NULL AUTO_INCREMENT,
|
|
`app` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`applied` datetime(6) NOT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of django_migrations
|
|
-- ----------------------------
|
|
INSERT INTO `django_migrations` VALUES (1, 'contenttypes', '0001_initial', '2022-09-28 14:21:17.926380');
|
|
INSERT INTO `django_migrations` VALUES (2, 'auth', '0001_initial', '2022-09-28 14:21:19.287740');
|
|
INSERT INTO `django_migrations` VALUES (3, 'admin', '0001_initial', '2022-09-28 14:21:19.574974');
|
|
INSERT INTO `django_migrations` VALUES (4, 'admin', '0002_logentry_remove_auto_add', '2022-09-28 14:21:19.602896');
|
|
INSERT INTO `django_migrations` VALUES (5, 'admin', '0003_logentry_add_action_flag_choices', '2022-09-28 14:21:19.616858');
|
|
INSERT INTO `django_migrations` VALUES (6, 'contenttypes', '0002_remove_content_type_name', '2022-09-28 14:21:19.767456');
|
|
INSERT INTO `django_migrations` VALUES (7, 'auth', '0002_alter_permission_name_max_length', '2022-09-28 14:21:19.894117');
|
|
INSERT INTO `django_migrations` VALUES (8, 'auth', '0003_alter_user_email_max_length', '2022-09-28 14:21:19.925034');
|
|
INSERT INTO `django_migrations` VALUES (9, 'auth', '0004_alter_user_username_opts', '2022-09-28 14:21:19.945978');
|
|
INSERT INTO `django_migrations` VALUES (10, 'auth', '0005_alter_user_last_login_null', '2022-09-28 14:21:20.044714');
|
|
INSERT INTO `django_migrations` VALUES (11, 'auth', '0006_require_contenttypes_0002', '2022-09-28 14:21:20.062667');
|
|
INSERT INTO `django_migrations` VALUES (12, 'auth', '0007_alter_validators_add_error_messages', '2022-09-28 14:21:20.087600');
|
|
INSERT INTO `django_migrations` VALUES (13, 'auth', '0008_alter_user_username_max_length', '2022-09-28 14:21:20.217253');
|
|
INSERT INTO `django_migrations` VALUES (14, 'auth', '0009_alter_user_last_name_max_length', '2022-09-28 14:21:20.343913');
|
|
INSERT INTO `django_migrations` VALUES (15, 'auth', '0010_alter_group_name_max_length', '2022-09-28 14:21:20.387797');
|
|
INSERT INTO `django_migrations` VALUES (16, 'auth', '0011_update_proxy_permissions', '2022-09-28 14:21:20.405748');
|
|
INSERT INTO `django_migrations` VALUES (17, 'auth', '0012_alter_user_first_name_max_length', '2022-09-28 14:21:20.535403');
|
|
INSERT INTO `django_migrations` VALUES (18, 'sessions', '0001_initial', '2022-09-28 14:21:20.636170');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for django_session
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `django_session`;
|
|
CREATE TABLE `django_session` (
|
|
`session_key` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`session_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`expire_date` datetime(6) NOT NULL,
|
|
PRIMARY KEY (`session_key`) USING BTREE,
|
|
INDEX `django_session_expire_date_a5c62663`(`expire_date`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of django_session
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for medicine
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `medicine`;
|
|
CREATE TABLE `medicine` (
|
|
`id` int(0) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`price` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`unit` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '药品' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of medicine
|
|
-- ----------------------------
|
|
INSERT INTO `medicine` VALUES (1, '板蓝根颗粒', '15', '盒');
|
|
INSERT INTO `medicine` VALUES (2, '维生素C', '20', '瓶');
|
|
INSERT INTO `medicine` VALUES (3, '葡萄糖注射液', '12', '瓶');
|
|
INSERT INTO `medicine` VALUES (4, '感冒灵颗粒', '20', '盒');
|
|
INSERT INTO `medicine` VALUES (5, '健胃消食片', '20', '和');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for order
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `order`;
|
|
CREATE TABLE `order` (
|
|
`id` int(0) NOT NULL AUTO_INCREMENT,
|
|
`patient_id` int(0) NULL DEFAULT NULL,
|
|
`department_id` int(0) NULL DEFAULT NULL,
|
|
`readme` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '患者自述情况',
|
|
`registration_fee` decimal(10, 2) NULL DEFAULT NULL COMMENT '挂号费',
|
|
`doctor_id` int(0) NULL DEFAULT NULL COMMENT '医生id',
|
|
`order_advice` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '医嘱',
|
|
`medicine_list` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '药品列表',
|
|
`total_cost` decimal(10, 2) NULL DEFAULT NULL,
|
|
`status` int(0) NULL DEFAULT NULL,
|
|
`time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '就诊记录' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of order
|
|
-- ----------------------------
|
|
INSERT INTO `order` VALUES (1, 1, 1, '我睡不着', 20.00, 1, '吃药', '2', 40.00, 2, '2021-09-07 00:00:00');
|
|
INSERT INTO `order` VALUES (2, 1, 7, '膝盖痛', NULL, NULL, '', NULL, NULL, 1, '2021-09-13 18:58:13');
|
|
INSERT INTO `order` VALUES (3, 2, 1, '有点头痛', 20.00, 1, '小感冒，吃吃药，睡睡觉', '1,2', 55.00, 2, '2021-09-14 15:26:54');
|
|
INSERT INTO `order` VALUES (5, 3, 1, '头晕', 20.00, 1, '天气热，中暑了，多休息', '1,2', 55.00, 2, '2021-09-14 16:22:18');
|
|
INSERT INTO `order` VALUES (6, 1, 5, '喉咙痛', 20.00, NULL, '', '', 0.00, 1, '2022-09-28 14:36:42');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for user_doctor
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `user_doctor`;
|
|
CREATE TABLE `user_doctor` (
|
|
`id` int(0) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '医生名称',
|
|
`id_card` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '身份证',
|
|
`department_id` int(0) NULL DEFAULT NULL COMMENT '科室id',
|
|
`status` int(0) NULL DEFAULT NULL COMMENT '状态',
|
|
`password` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of user_doctor
|
|
-- ----------------------------
|
|
INSERT INTO `user_doctor` VALUES (1, '王医生', '310116199001011234', 1, 1, '123456');
|
|
INSERT INTO `user_doctor` VALUES (2, '李医生', '310116199001021234', 2, 1, '123456');
|
|
INSERT INTO `user_doctor` VALUES (3, '孙医生', '310116199001031234', 3, 1, '123456');
|
|
INSERT INTO `user_doctor` VALUES (4, '吴医生', '310116199001041234', 4, 1, '123456');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for user_patient
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `user_patient`;
|
|
CREATE TABLE `user_patient` (
|
|
`id` int(0) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '患者名称',
|
|
`id_card` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '患者身份证号',
|
|
`phone` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '患者电话号',
|
|
`password` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '患者登录密码',
|
|
`sex` int(0) NULL DEFAULT NULL COMMENT '患者性别',
|
|
`age` int(0) NULL DEFAULT NULL COMMENT '患者年龄',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '患者表' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of user_patient
|
|
-- ----------------------------
|
|
INSERT INTO `user_patient` VALUES (1, '张三', '310116199801011234', '123456789', '123456', 1, 23);
|
|
INSERT INTO `user_patient` VALUES (2, '李四', '310116199801024524', '123456789', '123456', 2, 23);
|
|
INSERT INTO `user_patient` VALUES (3, '赵四', '310116199801031875', '123456789', '123456', 1, 23);
|
|
INSERT INTO `user_patient` VALUES (4, '小王', '333322199001011234', '12332111234', '123456', 1, 31);
|
|
INSERT INTO `user_patient` VALUES (6, '李文', '360481199005161231', '17770825424', '123456', 1, 30);
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|