~~~
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for hp_area
-- ----------------------------
DROP TABLE IF EXISTS `hp_area`;
CREATE TABLE `hp_area` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`add_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='面积';
-- ----------------------------
-- Table structure for hp_cases
-- ----------------------------
DROP TABLE IF EXISTS `hp_cases`;
CREATE TABLE `hp_cases` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL COMMENT '医生ID',
`m_id` int(11) DEFAULT NULL COMMENT '患者ID',
`state` tinyint(2) DEFAULT NULL COMMENT '是否住院 0为不住院 1为住院',
`clinic_date` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '就诊日期',
`record` text COLLATE utf8mb4_general_ci COMMENT '记录',
`add_time` int(11) DEFAULT NULL,
`length_time` varchar(11) COLLATE utf8mb4_general_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='就诊记录表';
-- ----------------------------
-- Table structure for hp_diseases
-- ----------------------------
DROP TABLE IF EXISTS `hp_diseases`;
CREATE TABLE `hp_diseases` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`add_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='病种';
-- ----------------------------
-- Table structure for hp_instrument
-- ----------------------------
DROP TABLE IF EXISTS `hp_instrument`;
CREATE TABLE `hp_instrument` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '仪器名称',
`add_time` int(11) DEFAULT NULL,
`status` tinyint(2) DEFAULT NULL COMMENT '仪器状态 0为停用 1为正常 ',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Table structure for hp_instrument_buy
-- ----------------------------
DROP TABLE IF EXISTS `hp_instrument_buy`;
CREATE TABLE `hp_instrument_buy` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`instrument_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`m_id` int(11) DEFAULT NULL,
`buy_time` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
`number` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
`add_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Table structure for hp_instrument_record
-- ----------------------------
DROP TABLE IF EXISTS `hp_instrument_record`;
CREATE TABLE `hp_instrument_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`m_id` int(11) DEFAULT NULL COMMENT '患者ＩＤ',
`user_id` int(11) DEFAULT NULL COMMENT '使用者',
`instrument_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '仪器名称',
`location` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '部位',
`operation_time` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作时长',
`operation_doctor` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作医生',
`feedback` tinytext COLLATE utf8mb4_general_ci COMMENT '反馈',
`add_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='仪器使用记录';
-- ----------------------------
-- Table structure for hp_medicine_record
-- ----------------------------
DROP TABLE IF EXISTS `hp_medicine_record`;
CREATE TABLE `hp_medicine_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`add_time` int(11) DEFAULT NULL,
`title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '药品名称',
`length_time` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '拿药时长',
`user_id` int(11) DEFAULT NULL COMMENT '医生ID',
`m_id` int(11) DEFAULT NULL COMMENT '患者ID',
`visit_time` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '回访时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='拿药记录';
-- ----------------------------
-- Table structure for hp_members
-- ----------------------------
DROP TABLE IF EXISTS `hp_members`;
CREATE TABLE `hp_members` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '姓名',
`sex` tinyint(2) DEFAULT NULL COMMENT '1为男 2为女 0为未知',
`birthday` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '生日',
`phone` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
`diseases` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '病种',
`location` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '患病部位',
`area` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '面积',
`way` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '来院途径',
`type` tinyint(2) DEFAULT NULL COMMENT '就诊类型',
`address` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '住址',
`history` tinytext COLLATE utf8mb4_general_ci COMMENT '即往史',
`family` tinytext COLLATE utf8mb4_general_ci COMMENT '家族史',
`serial_number` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '编号',
`id_card` varchar(19) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '身份证',
`doctor_id` int(11) DEFAULT NULL COMMENT '医生ID',
`user_id` int(11) DEFAULT NULL COMMENT '操作人 ID',
`add_time` int(11) DEFAULT NULL COMMENT '添加时间',
`age` int(11) DEFAULT NULL COMMENT '年龄',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='患者登记表';
-- ----------------------------
-- Table structure for hp_photographs
-- ----------------------------
DROP TABLE IF EXISTS `hp_photographs`;
CREATE TABLE `hp_photographs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`photo` text COLLATE utf8mb4_general_ci COMMENT '照片记录',
`results` text COLLATE utf8mb4_general_ci COMMENT '结果记录',
`add_time` int(11) DEFAULT NULL,
`m_id` int(11) DEFAULT NULL COMMENT '用户ID',
`user_id` int(11) DEFAULT NULL COMMENT '医生ID',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='照片记录';
-- ----------------------------
-- Table structure for hp_photographs_results
-- ----------------------------
DROP TABLE IF EXISTS `hp_photographs_results`;
CREATE TABLE `hp_photographs_results` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`photo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '照片记录',
`add_time` int(11) DEFAULT NULL,
`m_id` int(11) DEFAULT NULL COMMENT '用户ID',
`user_id` int(11) DEFAULT NULL COMMENT '医生ID',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='照片记录';
-- ----------------------------
-- Table structure for hp_place_copy
-- ----------------------------
DROP TABLE IF EXISTS `hp_place_copy`;
CREATE TABLE `hp_place_copy` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`add_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='部位';
-- ----------------------------
-- Table structure for hp_project
-- ----------------------------
DROP TABLE IF EXISTS `hp_project`;
CREATE TABLE `hp_project` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`add_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='化验项目';
-- ----------------------------
-- Table structure for hp_record
-- ----------------------------
DROP TABLE IF EXISTS `hp_record`;
CREATE TABLE `hp_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`m_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`add_time` int(11) DEFAULT NULL,
`type` int(11) DEFAULT NULL COMMENT '就诊类型',
`to_time` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '来院时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='来院记录';
-- ----------------------------
-- Table structure for hp_results
-- ----------------------------
DROP TABLE IF EXISTS `hp_results`;
CREATE TABLE `hp_results` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`add_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='回访结果';
-- ----------------------------
-- Table structure for hp_return_record
-- ----------------------------
DROP TABLE IF EXISTS `hp_return_record`;
CREATE TABLE `hp_return_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`return` text COLLATE utf8mb4_general_ci COMMENT '回访记录',
`results` text COLLATE utf8mb4_general_ci COMMENT '结果',
`user_id` int(11) DEFAULT NULL COMMENT '操作员',
`m_id` int(11) DEFAULT NULL COMMENT '患者ID',
`add_time` int(11) DEFAULT NULL,
`visit_time` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '下次回访时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='回访记录';
-- ----------------------------
-- Table structure for hp_user
-- ----------------------------
DROP TABLE IF EXISTS `hp_user`;
CREATE TABLE `hp_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '姓名',
`password` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`status` int(11) DEFAULT NULL,
`add_time` int(11) DEFAULT NULL,
`department_id` tinyint(2) DEFAULT NULL COMMENT '部门ID 1为医生站 2为咨询台 3为照片处 4为医技科室 5为领导端',
`phone` varchar(12) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '手机号码',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='管理员';
-- ----------------------------
-- Table structure for hp_way
-- ----------------------------
DROP TABLE IF EXISTS `hp_way`;
CREATE TABLE `hp_way` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`add_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='来院途径';
~~~
- 空白目录
- 一、上海璨耀
- MD5手机加密-前置撞库接口
- 数据传入提交接口
- 加密方法
- 客户数据表
- 二、菏泽白癜风医院项目
- 1.1数据库表
- 2 接口地址
- 2.1 患者管理
- 2.2 拿药管理
- 2.3 仪器管理
- 2.4 就诊记录 （病例）
- 2.5 管理员
- 2.6 回访记录
- 2.7 照片记录
- 2.8 杂项
- 2.9 来院记录
- 2.10 领导端
- 2.11 咨询台功能
- 2.12 药品设置
- 2.13 时长设置
- 2.14 不回访原因
- 三、环保项目
- 1.1 项目各种分类接口
- 2 项目管理
- 3 文件上传地址
- 4.用户登录
- 5 订单管理
- 6 个人中心
- 6.1 佣金记录
- 6.2 提现
- 7 其它接口
- 7.1 轮播图
- 8 人才管理
- 四、城爱婚恋自主征婚平台
- 一、CP管理
- 二、征婚
- 三、课程中心
- 四、其它接口