use `sys-tran`;
insert into `tran_sys_set` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `hospital_code`, `plan`, `sys_type`, `name`, `code`, `value`, `remark`) values('N','1970-01-01 12:00:00','1970-01-01 12:00:00',NULL,NULL,'LT','0','11','模板管理者','template_admin','admin1,admin2','配置管理员请用医生Code');

INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0001', '肛肠外科', 'LT', '杭州朗通信息技术有限公司', '肛肠外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0002', '感染科', 'LT', '杭州朗通信息技术有限公司', '感染科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0003', '呼吸内科', 'LT', '杭州朗通信息技术有限公司', '呼吸内科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0004', '儿外科', 'LT', '杭州朗通信息技术有限公司', '儿外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0005', '肾内科', 'LT', '杭州朗通信息技术有限公司', '肾内科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0006', '风湿免疫科', 'LT', '杭州朗通信息技术有限公司', '风湿免疫科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0007', '颌面外科', 'LT', '杭州朗通信息技术有限公司', '颌面外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0008', '核医学科', 'LT', '杭州朗通信息技术有限公司', '核医学科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0009', '妇产科', 'LT', '杭州朗通信息技术有限公司', '妇产科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0010', '肿瘤外科', 'LT', '杭州朗通信息技术有限公司', '肿瘤外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0011', '胃肠外科', 'LT', '杭州朗通信息技术有限公司', '胃肠外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0012', '神经内科', 'LT', '杭州朗通信息技术有限公司', '神经内科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0013', '儿内科', 'LT', '杭州朗通信息技术有限公司', '儿内科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0014', '血液科', 'LT', '杭州朗通信息技术有限公司', '血液科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0015', '精神科', 'LT', '杭州朗通信息技术有限公司', '精神科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0016', '中医科', 'LT', '杭州朗通信息技术有限公司', '中医科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0017', '传染病科', 'LT', '杭州朗通信息技术有限公司', '传染病科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0018', '牙科', 'LT', '杭州朗通信息技术有限公司', '牙科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0019', '急诊科', 'LT', '杭州朗通信息技术有限公司', '急诊科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0020', '皮肤科', 'LT', '杭州朗通信息技术有限公司', '皮肤科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0021', '血管外科', 'LT', '杭州朗通信息技术有限公司', '血管外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0022', '眼科', 'LT', '杭州朗通信息技术有限公司', '眼科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0023', '胸外科', 'LT', '杭州朗通信息技术有限公司', '胸外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0024', '肿瘤科', 'LT', '杭州朗通信息技术有限公司', '肿瘤科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0025', '心血管外科', 'LT', '杭州朗通信息技术有限公司', '心血管外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0026', '肝胆外科', 'LT', '杭州朗通信息技术有限公司', '肝胆外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0027', '普外科', 'LT', '杭州朗通信息技术有限公司', '普外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0028', '烧伤科', 'LT', '杭州朗通信息技术有限公司', '烧伤科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0029', '整形外科', 'LT', '杭州朗通信息技术有限公司', '整形外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0030', '心胸外科', 'LT', '杭州朗通信息技术有限公司', '心胸外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0031', '口腔科', 'LT', '杭州朗通信息技术有限公司', '口腔科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0032', '心血管内科', 'LT', '杭州朗通信息技术有限公司', '心血管内科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0033', '普通内科', 'LT', '杭州朗通信息技术有限公司', '普通内科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0034', '泌尿外科', 'LT', '杭州朗通信息技术有限公司', '泌尿外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0035', '男科', 'LT', '杭州朗通信息技术有限公司', '男科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0036', '康复科', 'LT', '杭州朗通信息技术有限公司', '康复科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0037', '消化内科', 'LT', '杭州朗通信息技术有限公司', '消化内科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0038', '内分泌科', 'LT', '杭州朗通信息技术有限公司', '内分泌科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0039', '乳腺外科', 'LT', '杭州朗通信息技术有限公司', '乳腺外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0040', '儿科', 'LT', '杭州朗通信息技术有限公司', '儿科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0041', '骨科', 'LT', '杭州朗通信息技术有限公司', '骨科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0042', 'ICU', 'LT', '杭州朗通信息技术有限公司', 'ICU', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0043', '手外科', 'LT', '杭州朗通信息技术有限公司', '手外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0044', '肿瘤内科', 'LT', '杭州朗通信息技术有限公司', '肿瘤内科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0045', '神经外科', 'LT', '杭州朗通信息技术有限公司', '神经外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0046', '五官科', 'LT', '杭州朗通信息技术有限公司', '五官科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0047', '全科', 'LT', '杭州朗通信息技术有限公司', '全科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0048', '产科', 'LT', '杭州朗通信息技术有限公司', '产科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0049', '妇科', 'LT', '杭州朗通信息技术有限公司', '妇科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0050', '皮肤与性病科', 'LT', '杭州朗通信息技术有限公司', '皮肤与性病科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0051', '肝炎专科', 'LT', '杭州朗通信息技术有限公司', '肝炎专科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0052', '新生儿科', 'LT', '杭州朗通信息技术有限公司', '新生儿科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0053', '小儿胸心外科', 'LT', '杭州朗通信息技术有限公司', '小儿胸心外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0054', '小儿消化专科', 'LT', '杭州朗通信息技术有限公司', '小儿消化专科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0055', '小儿呼吸专科', 'LT', '杭州朗通信息技术有限公司', '小儿呼吸专科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0056', '小儿内分泌专科', 'LT', '杭州朗通信息技术有限公司', '小儿内分泌专科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0057', '小儿遗传病专科', 'LT', '杭州朗通信息技术有限公司', '小儿遗传病专科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0058', '小儿传染病科', 'LT', '杭州朗通信息技术有限公司', '小儿传染病科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0059', '动物源性传染病专科', 'LT', '杭州朗通信息技术有限公司', '动物源性传染病专科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0060', '虫媒传染病专科', 'LT', '杭州朗通信息技术有限公司', '虫媒传染病专科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0061', '肠道传染病专科', 'LT', '杭州朗通信息技术有限公司', '肠道传染病专科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0062', '呼吸道传染病专科', 'LT', '杭州朗通信息技术有限公司', '呼吸道传染病专科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0063', '结核病科', 'LT', '杭州朗通信息技术有限公司', '结核病科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0064', '口腔颌面外科', 'LT', '杭州朗通信息技术有限公司', '口腔颌面外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0065', '口腔粘膜病科', 'LT', '杭州朗通信息技术有限公司', '口腔粘膜病科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0066', '牙周病科', 'LT', '杭州朗通信息技术有限公司', '牙周病科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0067', '牙体牙髓病科', 'LT', '杭州朗通信息技术有限公司', '牙体牙髓病科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0068', '儿童口腔科', 'LT', '杭州朗通信息技术有限公司', '儿童口腔科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0069', '小儿心脏病专科', 'LT', '杭州朗通信息技术有限公司', '小儿心脏病专科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0070', '烧伤外科', 'LT', '杭州朗通信息技术有限公司', '烧伤外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0071', '小儿肾病专科', 'LT', '杭州朗通信息技术有限公司', '小儿肾病专科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0072', '小儿骨科', 'LT', '杭州朗通信息技术有限公司', '小儿骨科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0073', '小儿泌尿外科', 'LT', '杭州朗通信息技术有限公司', '小儿泌尿外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0074', '小儿神经外科', 'LT', '杭州朗通信息技术有限公司', '小儿神经外科', 1, NULL);
INSERT INTO `tran_hospital_dept` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `hospital_code`, `hospital_name`, `concept_dept_name`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'D0075', '蠕虫病专科', 'LT', '杭州朗通信息技术有限公司', '蠕虫病专科', 1, NULL);


INSERT INTO `tran_field_info` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `uuid`, `icss_field`, `his_field`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'LT', 'patientNo', 'patientNo', '1', NULL);
INSERT INTO `tran_field_info` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `uuid`, `icss_field`, `his_field`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'LT', 'doctorNo', 'doctorNo', '1', NULL);
INSERT INTO `tran_field_info` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `uuid`, `icss_field`, `his_field`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'LT', 'recordId', 'recordId', '1', NULL);
INSERT INTO `tran_field_info` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `uuid`, `icss_field`, `his_field`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'LT', 'hospitalId', 'hospitalId', '1', NULL);
INSERT INTO `tran_field_info` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `uuid`, `icss_field`, `his_field`, `status`, `remark`)  VALUES ('N', '1970-1-1 12:00:00', '1970-1-1 12:00:00', '0', '0', 'LT', 'deptNo', 'deptId', '1', NULL);

INSERT INTO `tran_doctor_info` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `hospital_code`, `hospital_dept_code`, `code`, `name`, `sex`, `id_type`, `id_no`, `address`, `phone`, `remark`) VALUES ('N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 'LT', '', 'admin1', '管理员男', '1', NULL, '', NULL, NULL, NULL);
INSERT INTO `tran_doctor_info` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `hospital_code`, `hospital_dept_code`, `code`, `name`, `sex`, `id_type`, `id_no`, `address`, `phone`, `remark`) VALUES ('N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 'LT', NULL, 'admin2', '管理员女', '2', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `tran_doctor_info` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `hospital_code`, `hospital_dept_code`, `code`, `name`, `sex`, `id_type`, `id_no`, `address`, `phone`, `remark`) VALUES ('N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 'LT', NULL, 'doc1', '医生男', '1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `tran_doctor_info` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `hospital_code`, `hospital_dept_code`, `code`, `name`, `sex`, `id_type`, `id_no`, `address`, `phone`, `remark`) VALUES ('N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 'LT', NULL, 'doc2', '医生女', '2', NULL, NULL, NULL, NULL, NULL);


INSERT INTO `tran_patient_info` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `hospital_code`, `code`, `name`, `sex`, `birthday`, `id_type`, `id_no`, `address`, `phone`, `identity_num`, `postcode`, `contacts`, `contact_phone`, `work_unit`, `operation`, `country`, `nationality`, `matrimony`, `remark`) VALUES ('N', '2019-12-06 13:49:15', '1970-01-01 12:00:00', '0', '0', 'LT', '1600', '周男', '1', '1992-03-25 00:00:00', NULL, '411521199203251533', NULL, NULL, '411521199203251533', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1');
INSERT INTO `tran_patient_info` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `hospital_code`, `code`, `name`, `sex`, `birthday`, `id_type`, `id_no`, `address`, `phone`, `identity_num`, `postcode`, `contacts`, `contact_phone`, `work_unit`, `operation`, `country`, `nationality`, `matrimony`, `remark`) VALUES ('N', '2019-12-06 13:49:15', '1970-01-01 12:00:00', '0', '0', 'LT', '1601', '周女', '1', '1992-03-04 00:00:00', NULL, '411521199203251533', NULL, NULL, '411521199203251533', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1');

INSERT INTO `tran_hospital_info` (`id`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `code`, `name`, `address`, `spell`, `status`, `order_no`, `connect`, `remark`) VALUES ('9', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 'LT', '杭州朗通信息有限公司', NULL, NULL, '1', NULL, '0', NULL);
