表结构和数据

最新推荐文章于 2024-02-29 22:11:02 发布

BACKWASH2038

最新推荐文章于 2024-02-29 22:11:02 发布

阅读量210

点赞数

文章标签：单元测试

本文链接：https://blog.csdn.net/weixin_38501485/article/details/123271869

版权

/*
SQLyog Ultimate v12.5.0 (64 bit)
MySQL - 5.7.34
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `pe_regist` (
   `id` varchar (108),
   `order_no` varchar (96),
   `order_status` int (10),
   `del_flag` int (10),
   `his_id` varchar (96),
   `worke_type` varchar (108),
   `pe_type` varchar (108),
   `pe_number` varchar (96),
   `pe_user_id` varchar (60),
   `name` varchar (60),
   `order_time` datetime ,
   `pe_depart_id` varchar (60),
   `report_flag` varchar (108),
   `group_id` varchar (36),
   `group_name` varchar (150),
   `pack_dis_flag` varchar (108),
   `cur_rate` Decimal (12),
   `source` varchar (108),
   `total_price` Decimal (12),
   `pay_status` varchar (108),
   `pe_status` varchar (108),
   `print_num` int (10),
   `picture` varchar (3000),
   `create_by` varchar (108),
   `create_time` datetime ,
   `update_by` varchar (108),
   `update_time` datetime ,
   `remarks` varchar (1500)
);
insert into `pe_regist` (`id`, `order_no`, `order_status`, `del_flag`, `his_id`, `worke_type`, `pe_type`, `pe_number`, `pe_user_id`, `name`, `order_time`, `pe_depart_id`, `report_flag`, `group_id`, `group_name`, `pack_dis_flag`, `cur_rate`, `source`, `total_price`, `pay_status`, `pe_status`, `print_num`, `picture`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496667179648655361',NULL,'0','0',NULL,'1495690225646567425','1396638070965657602','P997','1496667179636072450','张嘉琪医师测试(终)','2022-02-23 00:00:00',NULL,'1416379310770540545',NULL,NULL,'1410491628215345154','1.00','1396638783632433154','4488.00','1395672027011080193','1395671735808942081','0','temp/6bc6a7195b766b8d2a498a861fe5e23_1640224107962(1)_1645605220929.jpg','admin','2022-02-24 10:03:57','admin','2022-02-24 10:17:55',NULL);

/*
SQLyog Ultimate v12.5.0 (64 bit)
MySQL - 5.7.34
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `pe_user_info` (
   `id` varchar (108),
   `app_user_id` varchar (108),
   `del_flag` int (10),
   `name` varchar (60),
   `depart_name` varchar (360),
   `operation_type` varchar (108),
   `depart_id` varchar (108),
   `his_id` varchar (96),
   `phone` varchar (96),
   `sex` varchar (108),
   `nationality` varchar (108),
   `marriage` varchar (108),
   `indus_type` varchar (108),
   `id_type` varchar (108),
   `id_no` varchar (96),
   `self_price` Decimal (12),
   `team_price` Decimal (12),
   `self_number` int (10),
   `team_number` int (10),
   `birth_date` datetime ,
   `email` varchar (60),
   `address` varchar (360),
   `detail_addr` varchar (1500),
   `picture` varchar (3000),
   `nation` varchar (36),
   `mouth` varchar (36),
   `age` varchar (36),
   `remarks` varchar (384),
   `create_by` varchar (150),
   `create_time` datetime ,
   `update_by` varchar (150),
   `update_time` datetime
);
insert into `pe_user_info` (`id`, `app_user_id`, `del_flag`, `name`, `depart_name`, `operation_type`, `depart_id`, `his_id`, `phone`, `sex`, `nationality`, `marriage`, `indus_type`, `id_type`, `id_no`, `self_price`, `team_price`, `self_number`, `team_number`, `birth_date`, `email`, `address`, `detail_addr`, `picture`, `nation`, `mouth`, `age`, `remarks`, `create_by`, `create_time`, `update_by`, `update_time`) values('1496667179636072450',NULL,'0','张嘉琪医师测试(终)','测试','1408301789265035266',NULL,NULL,'15489489489','1395669001382780929',NULL,'1408302281344974850','1397748754025594881','1395669169872166914','640103199112121212','0.00','0.00','0','0',NULL,NULL,NULL,NULL,NULL,'汉',NULL,'22',NULL,'admin','2022-02-24 10:03:57',NULL,NULL);

/*
SQLyog Ultimate v12.5.0 (64 bit)
MySQL - 5.7.34
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `pe_result` (
   `id` varchar (108),
   `del_flag` int (1),
   `his_id` varchar (96),
   `reg_id` varchar (108),
   `result_type` varchar (108),
   `comb_id` varchar (108),
   `comb_name` varchar (150),
   `diseases_flag` int (1),
   `item_id` varchar (108),
   `item_name` varchar (60),
   `phy_result` varchar (3000),
   `doctor` varchar (150),
   `result_unit` varchar (108),
   `result_up_value` varchar (108),
   `result_down_value` varchar (108),
   `result_tips` varchar (108),
   `neg_flag` tinyint (1),
   `dept_id` varchar (108),
   `fin_flag` int (1),
   `picture` varchar (3000),
   `file_path` varchar (3000),
   `create_by` varchar (108),
   `create_time` datetime ,
   `update_by` varchar (36),
   `update_time` datetime ,
   `remarks` varchar (1500)
);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496667409706229762','0',NULL,'1496667179648655361','1','703','脉搏','2','46','脉搏','11','管理员','次/分',NULL,NULL,NULL,'0','7aaacb462acd4d798af0cd301e9a7a5e','1',NULL,NULL,'admin','2022-02-24 10:04:52',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496667662920556546','0',NULL,'1496667179648655361','1','759','听力','2','106','听力:左','11','管理员',NULL,NULL,NULL,NULL,'0','882c471a4c904e6e9023c1a2a304485e','1',NULL,NULL,'admin','2022-02-24 10:05:52',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496667662949916673','0',NULL,'1496667179648655361','1','759','听力','2','107','听力:右','12','管理员',NULL,NULL,NULL,NULL,'0','882c471a4c904e6e9023c1a2a304485e','1',NULL,NULL,'admin','2022-02-24 10:05:52',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496667662979276802','0',NULL,'1496667179648655361','1','761','耳疾','2','82','耳疾:左','11','管理员',NULL,NULL,NULL,NULL,'0','882c471a4c904e6e9023c1a2a304485e','1',NULL,NULL,'admin','2022-02-24 10:05:52',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496667663012831233','0',NULL,'1496667179648655361','1','761','耳疾','2','133','耳疾:右','33','管理员',NULL,NULL,NULL,NULL,'0','882c471a4c904e6e9023c1a2a304485e','1',NULL,NULL,'admin','2022-02-24 10:05:52',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496667663033802753','0',NULL,'1496667179648655361','1','762','鼻及鼻窦','2','80','鼻及鼻窦:左','2','管理员',NULL,NULL,NULL,NULL,'0','882c471a4c904e6e9023c1a2a304485e','1',NULL,NULL,'admin','2022-02-24 10:05:52',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496667663063162881','0',NULL,'1496667179648655361','1','762','鼻及鼻窦','2','137','鼻及鼻窦:右','4','管理员',NULL,NULL,NULL,NULL,'0','882c471a4c904e6e9023c1a2a304485e','1',NULL,NULL,'admin','2022-02-24 10:05:52',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496667663092523009','0',NULL,'1496667179648655361','1','764','粘膜','2','78','粘膜','5','管理员',NULL,NULL,NULL,NULL,'0','882c471a4c904e6e9023c1a2a304485e','1',NULL,NULL,'admin','2022-02-24 10:05:52',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496667663117688834','0',NULL,'1496667179648655361','1','765','牙及牙龈','2','77','牙及牙龈','6','管理员',NULL,NULL,NULL,NULL,'0','882c471a4c904e6e9023c1a2a304485e','1',NULL,NULL,'admin','2022-02-24 10:05:52',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496667663147048961','0',NULL,'1496667179648655361','1','846','呼吸','2','138','呼吸','7','管理员','次/分',NULL,NULL,NULL,'0','882c471a4c904e6e9023c1a2a304485e','1',NULL,NULL,'admin','2022-02-24 10:05:52',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496667663172214785','0',NULL,'1496667179648655361','1','726','眼疾','2','68','眼疾:左','3','管理员',NULL,NULL,NULL,NULL,'0','882c471a4c904e6e9023c1a2a304485e','1',NULL,NULL,'admin','2022-02-24 10:05:52',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496667663205769217','0',NULL,'1496667179648655361','1','726','眼疾','2','134','眼疾:右','3','管理员',NULL,NULL,NULL,NULL,'0','882c471a4c904e6e9023c1a2a304485e','1',NULL,NULL,'admin','2022-02-24 10:05:52',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668009969852417','0',NULL,'1496667179648655361','1','841','色觉','2','91','色觉','1','管理员',NULL,NULL,NULL,NULL,'0','9ef309c900a143fe9b1b8e0eb137238f','1',NULL,NULL,'admin','2022-02-24 10:07:15',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668010003406849','0',NULL,'1496667179648655361','1','756','咽','2','87','咽','2','管理员',NULL,NULL,NULL,NULL,'0','9ef309c900a143fe9b1b8e0eb137238f','1',NULL,NULL,'admin','2022-02-24 10:07:15',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668010108264449','0',NULL,'1496667179648655361','1','757','喉','2','88','喉','3','管理员',NULL,NULL,NULL,NULL,'0','9ef309c900a143fe9b1b8e0eb137238f','1',NULL,NULL,'admin','2022-02-24 10:07:15',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668010250870785','0',NULL,'1496667179648655361','1','758','舌','2','83','舌','4','管理员',NULL,NULL,NULL,NULL,'0','9ef309c900a143fe9b1b8e0eb137238f','1',NULL,NULL,'admin','2022-02-24 10:07:15',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668010347339777','0',NULL,'1496667179648655361','1','634','血压','2','45','血压','5','管理员','mmHg',NULL,NULL,NULL,'0','9ef309c900a143fe9b1b8e0eb137238f','1',NULL,NULL,'admin','2022-02-24 10:07:15',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668010385088513','0',NULL,'1496667179648655361','1','730','发育及营养','2','70','发育及营养','6','管理员',NULL,'','',NULL,'0','9ef309c900a143fe9b1b8e0eb137238f','1',NULL,NULL,'admin','2022-02-24 10:07:15',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668010682884098','0',NULL,'1496667179648655361','1','732','神经及精神','2','71','神经及精神','7','管理员',NULL,NULL,NULL,NULL,'0','9ef309c900a143fe9b1b8e0eb137238f','1',NULL,NULL,'admin','2022-02-24 10:07:15',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668010741604353','0',NULL,'1496667179648655361','1','733','肺及呼吸道','2','73','肺及呼吸道','8','管理员',NULL,NULL,NULL,NULL,'0','9ef309c900a143fe9b1b8e0eb137238f','1',NULL,NULL,'admin','2022-02-24 10:07:15',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668010779353089','0',NULL,'1496667179648655361','1','734','心脏及血管','2','74','心脏及血管','2','管理员',NULL,NULL,NULL,NULL,'0','9ef309c900a143fe9b1b8e0eb137238f','1',NULL,NULL,'admin','2022-02-24 10:07:15',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668010817101826','0',NULL,'1496667179648655361','1','736','腹部包块','2','76','腹部包块','3','管理员',NULL,NULL,NULL,NULL,'0','9ef309c900a143fe9b1b8e0eb137238f','1',NULL,NULL,'admin','2022-02-24 10:07:15',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668091205132290','0',NULL,'1496667179648655361','1','735','肝、脾、双肾','2','75','肝、脾、双肾','1','管理员',NULL,NULL,NULL,NULL,'0','9ef309c900a143fe9b1b8e0eb137238f','1',NULL,NULL,'admin','2022-02-24 10:07:34','admin','2022-02-24 10:08:48',NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668091234492418','0',NULL,'1496667179648655361','1','711','其他','2','145','其他','2','管理员',NULL,NULL,NULL,NULL,'0','9ef309c900a143fe9b1b8e0eb137238f','1',NULL,NULL,'admin','2022-02-24 10:07:34','admin','2022-02-24 10:08:48',NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668849531101185','0',NULL,'1496667179648655361','1','724','裸眼视力','2','65','裸眼视力:左','1','管理员',NULL,NULL,NULL,NULL,'0','fe4f6aaf012d4c52bcf126adbd896a51','1',NULL,NULL,'admin','2022-02-24 10:10:35','admin','2022-02-24 10:11:25',NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668849564655617','0',NULL,'1496667179648655361','1','724','裸眼视力','2','66','裸眼视力:右','2','管理员',NULL,NULL,NULL,NULL,'0','fe4f6aaf012d4c52bcf126adbd896a51','1',NULL,NULL,'admin','2022-02-24 10:10:35','admin','2022-02-24 10:11:25',NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668849589821441','0',NULL,'1496667179648655361','1','725','矫正视力','2','99','矫正视力:左','22','管理员',NULL,NULL,NULL,NULL,'0','fe4f6aaf012d4c52bcf126adbd896a51','1',NULL,NULL,'admin','2022-02-24 10:10:35','admin','2022-02-24 10:11:25',NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668849623375873','0',NULL,'1496667179648655361','1','725','矫正视力','2','101','矫正视力:右','34','管理员',NULL,NULL,NULL,NULL,'0','fe4f6aaf012d4c52bcf126adbd896a51','1',NULL,NULL,'admin','2022-02-24 10:10:35','admin','2022-02-24 10:11:25',NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668849648541698','0',NULL,'1496667179648655361','1','741','皮肤','2','92','皮肤','564','管理员',NULL,NULL,NULL,NULL,'0','fe4f6aaf012d4c52bcf126adbd896a51','1',NULL,NULL,'admin','2022-02-24 10:10:35','admin','2022-02-24 10:11:25',NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668849682096129','0',NULL,'1496667179648655361','1','740','头、颈','2','93','头、颈','34','管理员',NULL,NULL,NULL,NULL,'0','fe4f6aaf012d4c52bcf126adbd896a51','1',NULL,NULL,'admin','2022-02-24 10:10:35','admin','2022-02-24 10:11:25',NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668849715650561','0',NULL,'1496667179648655361','1','712','脊柱','2','150','脊柱','24','管理员',NULL,NULL,NULL,NULL,'0','fe4f6aaf012d4c52bcf126adbd896a51','1',NULL,NULL,'admin','2022-02-24 10:10:35','admin','2022-02-24 10:11:25',NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668849740816386','0',NULL,'1496667179648655361','1','739','肛门','2','94','肛门','26','管理员',NULL,NULL,NULL,NULL,'0','fe4f6aaf012d4c52bcf126adbd896a51','1',NULL,NULL,'admin','2022-02-24 10:10:35','admin','2022-02-24 10:11:25',NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668849774370817','0',NULL,'1496667179648655361','1','742','胸透或胸X片','2','95','胸透或胸X片','33','管理员',NULL,NULL,NULL,NULL,'0','fe4f6aaf012d4c52bcf126adbd896a51','1',NULL,NULL,'admin','2022-02-24 10:10:35','admin','2022-02-24 10:11:25',NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668849799536642','0',NULL,'1496667179648655361','1','879','其他','2','155','其他','22','管理员',NULL,NULL,NULL,NULL,'0','fe4f6aaf012d4c52bcf126adbd896a51','1',NULL,NULL,'admin','2022-02-24 10:10:35','admin','2022-02-24 10:11:25',NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668849824702465','0',NULL,'1496667179648655361','1','713','甲状腺','2','56','甲状腺','25','管理员',NULL,NULL,NULL,NULL,'0','fe4f6aaf012d4c52bcf126adbd896a51','1',NULL,NULL,'admin','2022-02-24 10:10:35','admin','2022-02-24 10:11:25',NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496668849858256898','0',NULL,'1496667179648655361','1','851','淋巴结','2','146','淋巴结','27','管理员',NULL,NULL,NULL,NULL,'0','fe4f6aaf012d4c52bcf126adbd896a51','1',NULL,NULL,'admin','2022-02-24 10:10:35','admin','2022-02-24 10:11:25',NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496669145917399041','0',NULL,'1496667179648655361','1','852','四肢','2','151','四肢','123','管理员',NULL,NULL,NULL,NULL,'0','fe4f6aaf012d4c52bcf126adbd896a51','1',NULL,NULL,'admin','2022-02-24 10:11:46',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496669145946759169','0',NULL,'1496667179648655361','1','737','生殖器','2','97','生殖器','245','管理员',NULL,NULL,NULL,NULL,'0','fe4f6aaf012d4c52bcf126adbd896a51','1',NULL,NULL,'admin','2022-02-24 10:11:46',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496670534735339522','0',NULL,'1496667179648655361','1','763','嗅觉','2','122','嗅觉','123','管理员',NULL,NULL,NULL,NULL,'0','54136d778e75409ab89dc2854521ae82','1',NULL,NULL,'admin','2022-02-24 10:17:17',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496670534760505346','0',NULL,'1496667179648655361','1','746','心电图','2','156','心电图','22','管理员',NULL,NULL,NULL,NULL,'0','54136d778e75409ab89dc2854521ae82','1',NULL,NULL,'admin','2022-02-24 10:17:17',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496670534789865474','0',NULL,'1496667179648655361','1','743','肝功能','2','96','肝功能','33','管理员',NULL,NULL,NULL,NULL,'0','54136d778e75409ab89dc2854521ae82','1',NULL,NULL,'admin','2022-02-24 10:17:17',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496670689710678018','0',NULL,'1496667179648655361','0','718','血常规','2','HGB','★血红蛋白浓度','1','管理员','g/L','160','110','↓','1','33fcaba403b1499a8fdccb7258b745f4','1',NULL,NULL,'admin','2022-02-24 10:17:54',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496670689756815362','0',NULL,'1496667179648655361','0','718','血常规','2','MCH','平均血红蛋白量','2','管理员','pg','32','27','↓','1','33fcaba403b1499a8fdccb7258b745f4','1',NULL,NULL,'admin','2022-02-24 10:17:54',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496670689840701441','0',NULL,'1496667179648655361','0','718','血常规','2','MPV','平均血小板体积','3','管理员','fL','12','6.5','↓','1','33fcaba403b1499a8fdccb7258b745f4','1',NULL,NULL,'admin','2022-02-24 10:17:54',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496670689870061570','0',NULL,'1496667179648655361','0','718','血常规','2','PLT','★血小板数目','4','管理员','E9/L','300','100','↓','1','33fcaba403b1499a8fdccb7258b745f4','1',NULL,NULL,'admin','2022-02-24 10:17:54',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496670689907810305','0',NULL,'1496667179648655361','0','718','血常规','2','MCHC','★平均血红蛋白浓度','5','管理员','g/L','360','320','↓','1','33fcaba403b1499a8fdccb7258b745f4','1',NULL,NULL,'admin','2022-02-24 10:17:54',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496670689983307778','0',NULL,'1496667179648655361','0','721','尿常规','2','PH','酸碱度','2','管理员',NULL,'7','5.5','↓','1','33fcaba403b1499a8fdccb7258b745f4','1',NULL,NULL,'admin','2022-02-24 10:17:54',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496670690008473602','0',NULL,'1496667179648655361','0','721','尿常规','2','BIL','胆红素','3','管理员','umol/L','0','0','↑','1','33fcaba403b1499a8fdccb7258b745f4','1',NULL,NULL,'admin','2022-02-24 10:17:54',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496670690155274241','0',NULL,'1496667179648655361','0','721','尿常规','2','NIT','亚硝酸盐','4','管理员',NULL,'0','0','↑','1','33fcaba403b1499a8fdccb7258b745f4','1',NULL,NULL,'admin','2022-02-24 10:17:54',NULL,NULL,NULL);
insert into `pe_result` (`id`, `del_flag`, `his_id`, `reg_id`, `result_type`, `comb_id`, `comb_name`, `diseases_flag`, `item_id`, `item_name`, `phy_result`, `doctor`, `result_unit`, `result_up_value`, `result_down_value`, `result_tips`, `neg_flag`, `dept_id`, `fin_flag`, `picture`, `file_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remarks`) values('1496670690356600834','0',NULL,'1496667179648655361','0','721','尿常规','2','WBC.','白细胞','5','管理员','*10`9/L','10','4','','0','33fcaba403b1499a8fdccb7258b745f4','1',NULL,NULL,'admin','2022-02-24 10:17:54',NULL,NULL,NULL);

/*
SQLyog Ultimate v12.5.0 (64 bit)
MySQL - 5.7.34
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `pe_summary` (
   `id` varchar (108),
   `del_flag` int (1),
   `his_id` varchar (96),
   `reg_id` varchar (108),
   `dept_id` varchar (108),
   `comb_id` varchar (108),
   `comb_name` varchar (150),
   `neg_flag` char (30),
   `diseases_flag` int (11),
   `create_by` varchar (108),
   `create_time` datetime ,
   `update_by` varchar (108),
   `update_time` datetime ,
   `remarks` varchar (1500)
);

/*
SQLyog Ultimate v12.5.0 (64 bit)
MySQL - 5.7.34
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `pe_summary_details` (
   `id` bigint (20),
   `del_flag` int (11),
   `pe_sum_id` varchar (108),
   `content` varchar (1500),
   `suggest_id` varchar (108)
);