/* Navicat Premium Data Transfer Source Server : 门诊数据库服务器（线上） Source Server Type : MariaDB Source Server Version : 100300 Source Host : 172.16.32.160:3306 Source Schema : thyy_mz_system Target Server Type : MariaDB Target Server Version : 100300 File Encoding : 65001 Date: 05/03/2020 11:40:51 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_file_upload -- ---------------------------- DROP TABLE IF EXISTS `t_file_upload`; CREATE TABLE `t_file_upload` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `file_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文件名称', `file` longblob COMMENT '原文件内容字节数组', `file_type` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0' COMMENT '文件类型 0 - 头像 1-身份证正面 2 - 身份证背面 ', `mime_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '文件格式，它将帮助浏览器建议在下载时打开文件的方法', `create_time` datetime(0) DEFAULT NULL COMMENT '创建日期', `create_user` bigint(20) DEFAULT NULL COMMENT '创建人', `square_file` longblob COMMENT '转码成方形的字节数组', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 93 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文件表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_receipt -- ---------------------------- DROP TABLE IF EXISTS `t_receipt`; CREATE TABLE `t_receipt` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'key', `user_id_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户id', `receipt_begin` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发票开始', `receipt_end` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发票结尾', `receipt_current` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '当前发票号', `update_date` datetime(0) DEFAULT NULL COMMENT '当前发票范围维护时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_reqrec_request_relation -- ---------------------------- DROP TABLE IF EXISTS `t_reqrec_request_relation`; CREATE TABLE `t_reqrec_request_relation` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `request_id` bigint(11) NOT NULL COMMENT '号表主键', `serial_no` int(11) DEFAULT NULL COMMENT '挂号流水号', `op_date` datetime(0) DEFAULT NULL COMMENT '操作时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 23757 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_token -- ---------------------------- DROP TABLE IF EXISTS `t_token`; CREATE TABLE `t_token` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `token` varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'token值', `dead_time` datetime(0) DEFAULT NULL COMMENT '失效时间', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 567 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '注销了以后，还没有到失效时间的token token黑名单' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_user -- ---------------------------- DROP TABLE IF EXISTS `t_user`; CREATE TABLE `t_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `user_id_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '老系统员工编码', `user_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工号', `user_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名', `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码', `id_card` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '身份证号码', `create_time` datetime(0) DEFAULT NULL COMMENT '创建日期', `create_user` bigint(20) DEFAULT NULL COMMENT '创建人', `update_time` datetime(0) DEFAULT NULL COMMENT '更新时期', `update_user` bigint(20) DEFAULT NULL COMMENT '变更人', `status` int(2) DEFAULT NULL COMMENT '状态 0-- 在职 1--停薪留职 2-- 离职 3--退休', `profile_image` bigint(20) DEFAULT NULL COMMENT '头像地址主键', `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '邮箱', `phone_number` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '电话号码', `gender` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '性别 0 女 1 男', `lock_screen_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '锁屏密码', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 71 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_windows -- ---------------------------- DROP TABLE IF EXISTS `t_windows`; CREATE TABLE `t_windows` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `dept_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '院区 mz_zd_dept_no', `windows_no` int(3) DEFAULT NULL COMMENT '窗口号', `print_index` int(5) DEFAULT NULL COMMENT '默认发票打印机下标', `cg_print_index` int(5) DEFAULT NULL COMMENT '默认常规打印机下标', `user_id_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户id', `create_date` datetime(0) DEFAULT NULL COMMENT '创建时间', `update_date` datetime(0) DEFAULT NULL COMMENT '当前设置的更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 43 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1; -- ---------------------------- -- Table structure for t_mzmxsr -- ---------------------------- DROP TABLE IF EXISTS `t_mzmxsr`; CREATE TABLE `t_mzmxsr` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `xm` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名', `patient_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '病人id', `jz_sq_dept` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '就诊/申请科室', `jz_sq_doctor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '就诊/申请医生', `exec_dept` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '执行科室', `xmm` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '项目名', `hsm` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '核算码', `je` decimal(10, 2) DEFAULT NULL COMMENT '金额', `charge_date` datetime(0) DEFAULT NULL COMMENT '缴费时间', `dcount_date` datetime(0) DEFAULT NULL COMMENT '日结时间', `quty` double(255, 0) DEFAULT NULL COMMENT '数量', `price` decimal(10, 2) DEFAULT NULL COMMENT '单价', `parent_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '父类码', `input_date` datetime(0) DEFAULT NULL COMMENT '同步入库时间', PRIMARY KEY (`id`) USING BTREE, INDEX `t_mzmxsr_index`(`dcount_date`, `charge_date`, `jz_sq_dept`, `exec_dept`, `jz_sq_doctor`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1; ALTER TABLE t_mzmxsr ADD INDEX t_mzmxsr_index (dcount_date,charge_date,jz_sq_dept,exec_dept,jz_sq_doctor) -- ---------------------------- -- Table structure for t_menu -- ---------------------------- DROP TABLE IF EXISTS `t_menu`; CREATE TABLE `t_menu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单名称', `parent_id` bigint(20) DEFAULT NULL COMMENT '父菜单id\r\n父菜单id', `class_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '菜单图标样式 只有一级主菜单才有该字段', `menu_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '菜单地址 只有最基础的菜单才有地址', `sort_value` int(255) DEFAULT 0 COMMENT '排序字段 ，越小越优先', `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间', `create_id` bigint(20) DEFAULT NULL COMMENT '创建人id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单表' ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1; -- ---------------------------- -- Table structure for t_schedule_of_medical_apply -- ---------------------------- DROP TABLE IF EXISTS `t_schedule_of_medical_apply`; CREATE TABLE `t_schedule_of_medical_apply` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `schedule_id` bigint(20) NOT NULL COMMENT '档期id', `act_order_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '医嘱号码', `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注说明', `create_dept_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '预约发起科室部门 或者外部合作单位', `create_id` bigint(20) DEFAULT NULL COMMENT '预约人id', `create_time` datetime(0) DEFAULT NULL COMMENT '预约时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1; -- ---------------------------- -- Table structure for t_schedule_of_medical -- ---------------------------- DROP TABLE IF EXISTS `t_schedule_of_medical`; CREATE TABLE `t_schedule_of_medical` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `dep_no` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '科室编码', `room_num` tinyint(3) NOT NULL COMMENT '诊室号码', `record_date` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '日期', `begin_time` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开始时间', `end_time` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '结束时间', `status` tinyint(255) DEFAULT 0 COMMENT '状态 0 空闲 1 占用', `create_id` bigint(20) NOT NULL COMMENT '创建人', `create_date` datetime(0) NOT NULL COMMENT '创建时间', `update_id` bigint(20) NOT NULL COMMENT '修改人', `update_date` datetime(0) NOT NULL COMMENT '修改时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1; -- ---------------------------- -- Table structure for t_holidays -- ---------------------------- DROP TABLE IF EXISTS `t_holidays`; CREATE TABLE `t_holidays` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `begin_date` date NOT NULL COMMENT '开始日期', `begin_ampm` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开始日期的上下午', `end_date` date NOT NULL COMMENT '结束日期', `end_ampm` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '结束日期的上下午', `create_id` bigint(20) NOT NULL COMMENT '创建人', `create_date` datetime(0) NOT NULL COMMENT '创建时间', `update_id` bigint(20) DEFAULT NULL COMMENT '修改人', `update_date` datetime(0) DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1; SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_discount -- ---------------------------- DROP TABLE IF EXISTS `t_discount`; CREATE TABLE `t_discount` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '营销计划名称', `dept_type` int(255) NOT NULL COMMENT '0-申请科室 1 -执行科室', `dept_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '科室编码', `discount_begin_time` datetime(0) NOT NULL COMMENT '营销开始时间', `discount_end_time` datetime(0) NOT NULL COMMENT '营销结束时间', `charge_item_codes` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '收费项目编码串，用英文逗号分开', `discount_type` int(1) NOT NULL COMMENT '优惠类型 0 -单价优惠 1-折扣率', `discount_rate` decimal(10, 2) NULL DEFAULT NULL COMMENT '折扣率', `discount_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '优惠价', `delete_flag` int(255) NOT NULL COMMENT '删除标记 0 启用 1 停用 ', `create_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人ID', `create_time` datetime(0) NOT NULL COMMENT '创建时间', `update_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人ID', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1; SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_role -- ---------------------------- DROP TABLE IF EXISTS `t_role`; CREATE TABLE `t_role` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `role_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称', `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `create_id` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `update_id` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `del_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否有效（0：有效 1：无效）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色表' ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1; SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_role_menu_relation -- ---------------------------- DROP TABLE IF EXISTS `t_role_menu_relation`; CREATE TABLE `t_role_menu_relation` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID', `menu_id` bigint(20) NULL DEFAULT NULL COMMENT '菜单ID', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `create_id` bigint(20) NULL DEFAULT NULL COMMENT '创建人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1; SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_user_role_relation -- ---------------------------- DROP TABLE IF EXISTS `t_user_role_relation`; CREATE TABLE `t_user_role_relation` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户ID', `role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `create_id` bigint(20) NULL DEFAULT NULL COMMENT '创建人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户和角色关联表' ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1;