首頁 探索 說明
註冊 登入
java
/
diagbotcloud
2
0
複刻 0
檔案 問題管理 0 合併請求 0 Wiki
目錄樹: ebc2e7cb78
分支列表 標籤列表
diagbotcloud
/
docs
/
026.20191210科室模板维护
/
init_tran.sql

init_tran.sql 30 KB
文件歷史 原始文件

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596 
  1. use `sys-tran`;
    2. 

  2. 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');
    3. 

  3. 

  4. 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);
    5. 

  5. 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);
    6. 

  6. 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);
    7. 

  7. 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);
    8. 

  8. 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);
    9. 

  9. 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);
    10. 

  10. 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);
    11. 

  11. 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);
    12. 

  12. 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);
    13. 

  13. 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);
    14. 

  14. 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);
    15. 

  15. 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);
    16. 

  16. 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);
    17. 

  17. 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);
    18. 

  18. 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);
    19. 

  19. 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);
    20. 

  20. 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);
    21. 

  21. 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);
    22. 

  22. 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);
    23. 

  23. 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);
    24. 

  24. 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);
    25. 

  25. 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);
    26. 

  26. 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);
    27. 

  27. 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);
    28. 

  28. 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);
    29. 

  29. 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);
    30. 

  30. 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);
    31. 

  31. 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);
    32. 

  32. 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);
    33. 

  33. 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);
    34. 

  34. 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);
    35. 

  35. 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);
    36. 

  36. 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);
    37. 

  37. 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);
    38. 

  38. 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);
    39. 

  39. 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);
    40. 

  40. 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);
    41. 

  41. 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);
    42. 

  42. 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);
    43. 

  43. 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);
    44. 

  44. 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);
    45. 

  45. 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);
    46. 

  46. 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);
    47. 

  47. 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);
    48. 

  48. 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);
    49. 

  49. 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);
    50. 

  50. 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);
    51. 

  51. 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);
    52. 

  52. 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);
    53. 

  53. 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);
    54. 

  54. 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);
    55. 

  55. 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);
    56. 

  56. 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);
    57. 

  57. 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);
    58. 

  58. 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);
    59. 

  59. 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);
    60. 

  60. 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);
    61. 

  61. 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);
    62. 

  62. 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);
    63. 

  63. 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);
    64. 

  64. 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);
    65. 

  65. 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);
    66. 

  66. 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);
    67. 

  67. 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);
    68. 

  68. 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);
    69. 

  69. 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);
    70. 

  70. 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);
    71. 

  71. 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);
    72. 

  72. 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);
    73. 

  73. 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);
    74. 

  74. 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);
    75. 

  75. 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);
    76. 

  76. 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);
    77. 

  77. 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);
    78. 

  78. 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);
    79. 

  79. 

  80. 

  81. 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);
    82. 

  82. 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);
    83. 

  83. 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);
    84. 

  84. 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);
    85. 

  85. 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);
    86. 

  86. 

  87. 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);
    88. 

  88. 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);
    89. 

  89. 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);
    90. 

  90. 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);
    91. 

  91. 

  92. 

  93. 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');
    94. 

  94. 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');
    95. 

  95. 

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