part3.sql 68 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753
  1. -- ===========================================================================
  2. -- 医保影像云图像质控规范 - CT检查部位质控标准 (第3批)
  3. -- 基于《医保影像云图像质控规范 (YXY-QC-2025-A1)》
  4. --
  5. -- 本文件包含以下部位的CT质控标准:
  6. -- - 5.4.5 颈部软组织 (6个检查项目)
  7. -- - 5.4.6 胸部 (4个检查项目)
  8. --
  9. -- 检查项目总数: 10
  10. -- 质控因子总数: 70
  11. --
  12. -- 创建时间: 2026-01-13
  13. -- ===========================================================================
  14. -- 5.4.5.1 颈部CT平扫 - 因子1: 检查范围
  15. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  16. ('CT_NECK_5_4_5_1_1', 'CT_NECK_5_4_5_1_1', '检查范围', 3, 'boolean',
  17. '检查范围从枕骨大孔至第1胸椎',
  18. '{"type": "dicom_check", "method": "checkSCAN_RANGE", "params": {"minSliceCount": 30, "expectedBodyPart": "颈部软组织", "checkCoverage": true}, "isVeto": false, "description": "检查范围从枕骨大孔至第1胸椎"}',
  19. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  20. -- 5.4.5.1 颈部CT平扫 - 因子2: 图像偏中心
  21. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  22. ('CT_NECK_5_4_5_1_2', 'CT_NECK_5_4_5_1_2', '图像偏中心', 3, 'boolean',
  23. '断层位于图像正中',
  24. '{"type": "opencv_check", "method": "checkIMAGE_CENTERING", "params": {"maxOffsetRatio": 0.15}, "isVeto": false, "description": "断层位于图像正中"}',
  25. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  26. -- 5.4.5.1 颈部CT平扫 - 因子3: 重建参数
  27. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  28. ('CT_NECK_5_4_5_1_3', 'CT_NECK_5_4_5_1_3', '重建参数', 3, 'boolean',
  29. '厚层≤3.0mm,薄层≤1.25mm,DFOV:18cm',
  30. '{"type": "dicom_check", "method": "checkRECONSTRUCTION_PARAMS", "params": {"thickSliceMax": 3.0, "thickIntervalMax": 3.0, "thinSliceMax": 1.25, "thinIntervalMax": 1.25, "dfov": 18, "dfovTolerance": 2.0}, "isVeto": false, "description": "厚层≤3.0mm,薄层≤1.25mm,DFOV:18cm"}',
  31. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  32. -- 5.4.5.1 颈部CT平扫 - 因子4: 窗口技术
  33. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  34. ('CT_NECK_5_4_5_1_4', 'CT_NECK_5_4_5_1_4', '窗口技术', 3, 'boolean',
  35. '软组织窗:窗宽350~400HU,窗位35~45HU',
  36. '{"type": "dicom_check", "method": "checkWINDOW_TECHNIQUE", "params": {"softTissueWindow": {"windowWidth": {"min": 350, "max": 400}, "windowCenter": {"min": 35, "max": 45}}}, "isVeto": true, "description": "软组织窗:窗宽350~400HU,窗位35~45HU"}',
  37. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  38. -- 5.4.5.1 颈部CT平扫 - 因子5: 扫描体位
  39. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  40. ('CT_NECK_5_4_5_1_5', 'CT_NECK_5_4_5_1_5', '扫描体位', 3, 'boolean',
  41. '仰卧位',
  42. '{"type": "dicom_check", "method": "checkSCAN_POSITION", "params": {"expectedPosition": ["HFS", "FFS"]}, "isVeto": false, "description": "仰卧位"}',
  43. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  44. -- 5.4.5.1 颈部CT平扫 - 因子6: 图像标识
  45. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  46. ('CT_NECK_5_4_5_1_6', 'CT_NECK_5_4_5_1_6', '图像标识', 3, 'boolean',
  47. '影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位',
  48. '{"type": "dicom_check", "method": "checkImageAnnotation", "params": {"requiredFields": ["StudyInstanceUID", "BodyPartExamined", "PatientName", "PatientSex", "PatientAge", "StudyDate", "StudyTime", "KVP", "ScanDirection"]}, "isVeto": true, "description": "影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位"}',
  49. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  50. -- 5.4.5.1 颈部CT平扫 - 因子7: 图像伪影
  51. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  52. ('CT_NECK_5_4_5_1_7', 'CT_NECK_5_4_5_1_7', '图像伪影', 3, 'boolean',
  53. '无明显运动、呼吸、设备或体外金属等原因产生的图像伪影',
  54. '{"type": "opencv_check", "method": "checkIMAGE_ARTIFACTS", "params": {"motionThreshold": 30.0, "beamHardeningThreshold": 50.0}, "isVeto": true, "description": "无明显运动、呼吸、设备或体外金属等原因产生的图像伪影"}',
  55. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  56. -- 5.4.5.1 颈部CT平扫 - 因子8: 图像清晰度
  57. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  58. ('CT_NECK_5_4_5_1_8', 'CT_NECK_5_4_5_1_8', '图像清晰度', 3, 'boolean',
  59. '组织结构显示清晰,默认窗宽窗位合适',
  60. '{"type": "opencv_check", "method": "checkIMAGE_CLARITY", "params": {"sharpnessThreshold": 100.0, "contrastThreshold": 50.0}, "isVeto": false, "description": "组织结构显示清晰,默认窗宽窗位合适"}',
  61. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  62. -- 5.4.5.1 颈部CT平扫 - 质控标准
  63. INSERT INTO `qc_standard` (`id`, `standard_code`, `standard_name`, `modality`, `body_part`, `scan_type`, `exam_item`, `pass_score`, `description`, `status`, `create_time`, `update_time`) VALUES
  64. ('STD_CT_5_4_5_1', 'CT_5_4_5_1', '颈部CT平扫质控标准', 'CT', '颈部软组织', '平扫', '颈部CT平扫', 80,
  65. '颈部CT平扫质控标准,包含8个质控因子',
  66. 1, NOW(), NOW());
  67. -- 5.4.5.1 颈部CT平扫 - 标准-因子关联
  68. INSERT INTO `qc_standard_factor` (`id`, `standard_id`, `factor_id`, `weight`, `is_required`, `sort_order`, `create_time`, `update_time`) VALUES
  69. ('SF_CT_5_4_5_1_1', 'STD_CT_5_4_5_1', 'CT_NECK_5_4_5_1_1', 10.00, 1, 1, NOW(), NOW()),
  70. ('SF_CT_5_4_5_1_2', 'STD_CT_5_4_5_1', 'CT_NECK_5_4_5_1_2', 8.00, 1, 2, NOW(), NOW()),
  71. ('SF_CT_5_4_5_1_3', 'STD_CT_5_4_5_1', 'CT_NECK_5_4_5_1_3', 10.00, 1, 3, NOW(), NOW()),
  72. ('SF_CT_5_4_5_1_4', 'STD_CT_5_4_5_1', 'CT_NECK_5_4_5_1_4', 20.00, 1, 4, NOW(), NOW()),
  73. ('SF_CT_5_4_5_1_5', 'STD_CT_5_4_5_1', 'CT_NECK_5_4_5_1_5', 8.00, 1, 5, NOW(), NOW()),
  74. ('SF_CT_5_4_5_1_6', 'STD_CT_5_4_5_1', 'CT_NECK_5_4_5_1_6', 20.00, 1, 6, NOW(), NOW()),
  75. ('SF_CT_5_4_5_1_7', 'STD_CT_5_4_5_1', 'CT_NECK_5_4_5_1_7', 16.00, 1, 7, NOW(), NOW()),
  76. ('SF_CT_5_4_5_1_8', 'STD_CT_5_4_5_1', 'CT_NECK_5_4_5_1_8', 8.00, 1, 8, NOW(), NOW());
  77. -- 5.4.5.2 颈部CT增强 - 因子1: 检查范围
  78. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  79. ('CT_NECK_5_4_5_2_1', 'CT_NECK_5_4_5_2_1', '检查范围', 3, 'boolean',
  80. '检查范围从枕骨大孔至第1胸椎',
  81. '{"type": "dicom_check", "method": "checkSCAN_RANGE", "params": {"minSliceCount": 30, "expectedBodyPart": "颈部软组织", "checkCoverage": true}, "isVeto": false, "description": "检查范围从枕骨大孔至第1胸椎"}',
  82. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  83. -- 5.4.5.2 颈部CT增强 - 因子2: 图像偏中心
  84. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  85. ('CT_NECK_5_4_5_2_2', 'CT_NECK_5_4_5_2_2', '图像偏中心', 3, 'boolean',
  86. '断层位于图像正中',
  87. '{"type": "opencv_check", "method": "checkIMAGE_CENTERING", "params": {"maxOffsetRatio": 0.15}, "isVeto": false, "description": "断层位于图像正中"}',
  88. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  89. -- 5.4.5.2 颈部CT增强 - 因子3: 重建参数
  90. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  91. ('CT_NECK_5_4_5_2_3', 'CT_NECK_5_4_5_2_3', '重建参数', 3, 'boolean',
  92. '厚层≤3.0mm,薄层≤1.25mm,DFOV:18cm',
  93. '{"type": "dicom_check", "method": "checkRECONSTRUCTION_PARAMS", "params": {"thickSliceMax": 3.0, "thickIntervalMax": 3.0, "thinSliceMax": 1.25, "thinIntervalMax": 1.25, "dfov": 18, "dfovTolerance": 2.0}, "isVeto": false, "description": "厚层≤3.0mm,薄层≤1.25mm,DFOV:18cm"}',
  94. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  95. -- 5.4.5.2 颈部CT增强 - 因子4: 窗口技术
  96. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  97. ('CT_NECK_5_4_5_2_4', 'CT_NECK_5_4_5_2_4', '窗口技术', 3, 'boolean',
  98. '软组织窗:窗宽350~400HU,窗位35~45HU',
  99. '{"type": "dicom_check", "method": "checkWINDOW_TECHNIQUE", "params": {"softTissueWindow": {"windowWidth": {"min": 350, "max": 400}, "windowCenter": {"min": 35, "max": 45}}}, "isVeto": true, "description": "软组织窗:窗宽350~400HU,窗位35~45HU"}',
  100. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  101. -- 5.4.5.2 颈部CT增强 - 因子5: 扫描体位
  102. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  103. ('CT_NECK_5_4_5_2_5', 'CT_NECK_5_4_5_2_5', '扫描体位', 3, 'boolean',
  104. '仰卧位',
  105. '{"type": "dicom_check", "method": "checkSCAN_POSITION", "params": {"expectedPosition": ["HFS", "FFS"]}, "isVeto": false, "description": "仰卧位"}',
  106. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  107. -- 5.4.5.2 颈部CT增强 - 因子6: 图像标识
  108. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  109. ('CT_NECK_5_4_5_2_6', 'CT_NECK_5_4_5_2_6', '图像标识', 3, 'boolean',
  110. '影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位',
  111. '{"type": "dicom_check", "method": "checkImageAnnotation", "params": {"requiredFields": ["StudyInstanceUID", "BodyPartExamined", "PatientName", "PatientSex", "PatientAge", "StudyDate", "StudyTime", "KVP", "ScanDirection"]}, "isVeto": true, "description": "影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位"}',
  112. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  113. -- 5.4.5.2 颈部CT增强 - 因子7: 图像伪影
  114. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  115. ('CT_NECK_5_4_5_2_7', 'CT_NECK_5_4_5_2_7', '图像伪影', 3, 'boolean',
  116. '无明显运动、呼吸、设备或体外金属等原因产生的图像伪影',
  117. '{"type": "opencv_check", "method": "checkIMAGE_ARTIFACTS", "params": {"motionThreshold": 30.0, "beamHardeningThreshold": 50.0}, "isVeto": true, "description": "无明显运动、呼吸、设备或体外金属等原因产生的图像伪影"}',
  118. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  119. -- 5.4.5.2 颈部CT增强 - 因子8: 图像清晰度
  120. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  121. ('CT_NECK_5_4_5_2_8', 'CT_NECK_5_4_5_2_8', '图像清晰度', 3, 'boolean',
  122. '组织结构显示清晰,默认窗宽窗位合适',
  123. '{"type": "opencv_check", "method": "checkIMAGE_CLARITY", "params": {"sharpnessThreshold": 100.0, "contrastThreshold": 50.0}, "isVeto": false, "description": "组织结构显示清晰,默认窗宽窗位合适"}',
  124. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  125. -- 5.4.5.2 颈部CT增强 - 质控标准
  126. INSERT INTO `qc_standard` (`id`, `standard_code`, `standard_name`, `modality`, `body_part`, `scan_type`, `exam_item`, `pass_score`, `description`, `status`, `create_time`, `update_time`) VALUES
  127. ('STD_CT_5_4_5_2', 'CT_5_4_5_2', '颈部CT增强质控标准', 'CT', '颈部软组织', '增强', '颈部CT增强', 80,
  128. '颈部CT增强质控标准,包含8个质控因子',
  129. 1, NOW(), NOW());
  130. -- 5.4.5.2 颈部CT增强 - 标准-因子关联
  131. INSERT INTO `qc_standard_factor` (`id`, `standard_id`, `factor_id`, `weight`, `is_required`, `sort_order`, `create_time`, `update_time`) VALUES
  132. ('SF_CT_5_4_5_2_1', 'STD_CT_5_4_5_2', 'CT_NECK_5_4_5_2_1', 10.00, 1, 1, NOW(), NOW()),
  133. ('SF_CT_5_4_5_2_2', 'STD_CT_5_4_5_2', 'CT_NECK_5_4_5_2_2', 8.00, 1, 2, NOW(), NOW()),
  134. ('SF_CT_5_4_5_2_3', 'STD_CT_5_4_5_2', 'CT_NECK_5_4_5_2_3', 10.00, 1, 3, NOW(), NOW()),
  135. ('SF_CT_5_4_5_2_4', 'STD_CT_5_4_5_2', 'CT_NECK_5_4_5_2_4', 20.00, 1, 4, NOW(), NOW()),
  136. ('SF_CT_5_4_5_2_5', 'STD_CT_5_4_5_2', 'CT_NECK_5_4_5_2_5', 8.00, 1, 5, NOW(), NOW()),
  137. ('SF_CT_5_4_5_2_6', 'STD_CT_5_4_5_2', 'CT_NECK_5_4_5_2_6', 20.00, 1, 6, NOW(), NOW()),
  138. ('SF_CT_5_4_5_2_7', 'STD_CT_5_4_5_2', 'CT_NECK_5_4_5_2_7', 16.00, 1, 7, NOW(), NOW()),
  139. ('SF_CT_5_4_5_2_8', 'STD_CT_5_4_5_2', 'CT_NECK_5_4_5_2_8', 8.00, 1, 8, NOW(), NOW());
  140. -- 5.4.5.3 喉部CT平扫 - 因子1: 检查范围
  141. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  142. ('CT_LARYNX_5_4_5_3_1', 'CT_LARYNX_5_4_5_3_1', '检查范围', 3, 'boolean',
  143. '检查范围从枕骨大孔到胸廓入口',
  144. '{"type": "dicom_check", "method": "checkSCAN_RANGE", "params": {"minSliceCount": 30, "expectedBodyPart": "颈部软组织", "checkCoverage": true}, "isVeto": false, "description": "检查范围从枕骨大孔到胸廓入口"}',
  145. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  146. -- 5.4.5.3 喉部CT平扫 - 因子2: 图像偏中心
  147. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  148. ('CT_LARYNX_5_4_5_3_2', 'CT_LARYNX_5_4_5_3_2', '图像偏中心', 3, 'boolean',
  149. '断层位于图像正中',
  150. '{"type": "opencv_check", "method": "checkIMAGE_CENTERING", "params": {"maxOffsetRatio": 0.15}, "isVeto": false, "description": "断层位于图像正中"}',
  151. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  152. -- 5.4.5.3 喉部CT平扫 - 因子3: 重建参数
  153. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  154. ('CT_LARYNX_5_4_5_3_3', 'CT_LARYNX_5_4_5_3_3', '重建参数', 3, 'boolean',
  155. '厚层≤3.0mm,薄层≤1.25mm,DFOV:18cm',
  156. '{"type": "dicom_check", "method": "checkRECONSTRUCTION_PARAMS", "params": {"thickSliceMax": 3.0, "thickIntervalMax": 3.0, "thinSliceMax": 1.25, "thinIntervalMax": 1.25, "dfov": 18, "dfovTolerance": 2.0}, "isVeto": false, "description": "厚层≤3.0mm,薄层≤1.25mm,DFOV:18cm"}',
  157. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  158. -- 5.4.5.3 喉部CT平扫 - 因子4: 窗口技术
  159. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  160. ('CT_LARYNX_5_4_5_3_4', 'CT_LARYNX_5_4_5_3_4', '窗口技术', 3, 'boolean',
  161. '软组织窗:窗宽350~400HU,窗位35~45HU',
  162. '{"type": "dicom_check", "method": "checkWINDOW_TECHNIQUE", "params": {"softTissueWindow": {"windowWidth": {"min": 350, "max": 400}, "windowCenter": {"min": 35, "max": 45}}}, "isVeto": true, "description": "软组织窗:窗宽350~400HU,窗位35~45HU"}',
  163. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  164. -- 5.4.5.3 喉部CT平扫 - 因子5: 扫描体位
  165. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  166. ('CT_LARYNX_5_4_5_3_5', 'CT_LARYNX_5_4_5_3_5', '扫描体位', 3, 'boolean',
  167. '仰卧位',
  168. '{"type": "dicom_check", "method": "checkSCAN_POSITION", "params": {"expectedPosition": ["HFS", "FFS"]}, "isVeto": false, "description": "仰卧位"}',
  169. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  170. -- 5.4.5.3 喉部CT平扫 - 因子6: 图像标识
  171. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  172. ('CT_LARYNX_5_4_5_3_6', 'CT_LARYNX_5_4_5_3_6', '图像标识', 3, 'boolean',
  173. '影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位',
  174. '{"type": "dicom_check", "method": "checkImageAnnotation", "params": {"requiredFields": ["StudyInstanceUID", "BodyPartExamined", "PatientName", "PatientSex", "PatientAge", "StudyDate", "StudyTime", "KVP", "ScanDirection"]}, "isVeto": true, "description": "影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位"}',
  175. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  176. -- 5.4.5.3 喉部CT平扫 - 因子7: 图像伪影
  177. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  178. ('CT_LARYNX_5_4_5_3_7', 'CT_LARYNX_5_4_5_3_7', '图像伪影', 3, 'boolean',
  179. '无明显运动、呼吸、设备或体外金属等原因产生的图像伪影',
  180. '{"type": "opencv_check", "method": "checkIMAGE_ARTIFACTS", "params": {"motionThreshold": 30.0, "beamHardeningThreshold": 50.0}, "isVeto": true, "description": "无明显运动、呼吸、设备或体外金属等原因产生的图像伪影"}',
  181. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  182. -- 5.4.5.3 喉部CT平扫 - 因子8: 图像清晰度
  183. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  184. ('CT_LARYNX_5_4_5_3_8', 'CT_LARYNX_5_4_5_3_8', '图像清晰度', 3, 'boolean',
  185. '组织结构显示清晰,默认窗宽窗位合适',
  186. '{"type": "opencv_check", "method": "checkIMAGE_CLARITY", "params": {"sharpnessThreshold": 100.0, "contrastThreshold": 50.0}, "isVeto": false, "description": "组织结构显示清晰,默认窗宽窗位合适"}',
  187. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  188. -- 5.4.5.3 喉部CT平扫 - 质控标准
  189. INSERT INTO `qc_standard` (`id`, `standard_code`, `standard_name`, `modality`, `body_part`, `scan_type`, `exam_item`, `pass_score`, `description`, `status`, `create_time`, `update_time`) VALUES
  190. ('STD_CT_5_4_5_3', 'CT_5_4_5_3', '喉部CT平扫质控标准', 'CT', '颈部软组织', '平扫', '喉部CT平扫', 80,
  191. '喉部CT平扫质控标准,包含8个质控因子',
  192. 1, NOW(), NOW());
  193. -- 5.4.5.3 喉部CT平扫 - 标准-因子关联
  194. INSERT INTO `qc_standard_factor` (`id`, `standard_id`, `factor_id`, `weight`, `is_required`, `sort_order`, `create_time`, `update_time`) VALUES
  195. ('SF_CT_5_4_5_3_1', 'STD_CT_5_4_5_3', 'CT_LARYNX_5_4_5_3_1', 10.00, 1, 1, NOW(), NOW()),
  196. ('SF_CT_5_4_5_3_2', 'STD_CT_5_4_5_3', 'CT_LARYNX_5_4_5_3_2', 8.00, 1, 2, NOW(), NOW()),
  197. ('SF_CT_5_4_5_3_3', 'STD_CT_5_4_5_3', 'CT_LARYNX_5_4_5_3_3', 10.00, 1, 3, NOW(), NOW()),
  198. ('SF_CT_5_4_5_3_4', 'STD_CT_5_4_5_3', 'CT_LARYNX_5_4_5_3_4', 20.00, 1, 4, NOW(), NOW()),
  199. ('SF_CT_5_4_5_3_5', 'STD_CT_5_4_5_3', 'CT_LARYNX_5_4_5_3_5', 8.00, 1, 5, NOW(), NOW()),
  200. ('SF_CT_5_4_5_3_6', 'STD_CT_5_4_5_3', 'CT_LARYNX_5_4_5_3_6', 20.00, 1, 6, NOW(), NOW()),
  201. ('SF_CT_5_4_5_3_7', 'STD_CT_5_4_5_3', 'CT_LARYNX_5_4_5_3_7', 16.00, 1, 7, NOW(), NOW()),
  202. ('SF_CT_5_4_5_3_8', 'STD_CT_5_4_5_3', 'CT_LARYNX_5_4_5_3_8', 8.00, 1, 8, NOW(), NOW());
  203. -- 5.4.5.4 喉部CT增强 - 因子1: 检查范围
  204. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  205. ('CT_LARYNX_5_4_5_4_1', 'CT_LARYNX_5_4_5_4_1', '检查范围', 3, 'boolean',
  206. '检查范围从枕骨大孔到胸廓入口',
  207. '{"type": "dicom_check", "method": "checkSCAN_RANGE", "params": {"minSliceCount": 30, "expectedBodyPart": "颈部软组织", "checkCoverage": true}, "isVeto": false, "description": "检查范围从枕骨大孔到胸廓入口"}',
  208. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  209. -- 5.4.5.4 喉部CT增强 - 因子2: 图像偏中心
  210. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  211. ('CT_LARYNX_5_4_5_4_2', 'CT_LARYNX_5_4_5_4_2', '图像偏中心', 3, 'boolean',
  212. '断层位于图像正中',
  213. '{"type": "opencv_check", "method": "checkIMAGE_CENTERING", "params": {"maxOffsetRatio": 0.15}, "isVeto": false, "description": "断层位于图像正中"}',
  214. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  215. -- 5.4.5.4 喉部CT增强 - 因子3: 重建参数
  216. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  217. ('CT_LARYNX_5_4_5_4_3', 'CT_LARYNX_5_4_5_4_3', '重建参数', 3, 'boolean',
  218. '厚层≤3.0mm,薄层≤1.25mm,DFOV:18cm',
  219. '{"type": "dicom_check", "method": "checkRECONSTRUCTION_PARAMS", "params": {"thickSliceMax": 3.0, "thickIntervalMax": 3.0, "thinSliceMax": 1.25, "thinIntervalMax": 1.25, "dfov": 18, "dfovTolerance": 2.0}, "isVeto": false, "description": "厚层≤3.0mm,薄层≤1.25mm,DFOV:18cm"}',
  220. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  221. -- 5.4.5.4 喉部CT增强 - 因子4: 窗口技术
  222. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  223. ('CT_LARYNX_5_4_5_4_4', 'CT_LARYNX_5_4_5_4_4', '窗口技术', 3, 'boolean',
  224. '软组织窗:窗宽350~400HU,窗位35~45HU',
  225. '{"type": "dicom_check", "method": "checkWINDOW_TECHNIQUE", "params": {"softTissueWindow": {"windowWidth": {"min": 350, "max": 400}, "windowCenter": {"min": 35, "max": 45}}}, "isVeto": true, "description": "软组织窗:窗宽350~400HU,窗位35~45HU"}',
  226. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  227. -- 5.4.5.4 喉部CT增强 - 因子5: 扫描体位
  228. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  229. ('CT_LARYNX_5_4_5_4_5', 'CT_LARYNX_5_4_5_4_5', '扫描体位', 3, 'boolean',
  230. '仰卧位',
  231. '{"type": "dicom_check", "method": "checkSCAN_POSITION", "params": {"expectedPosition": ["HFS", "FFS"]}, "isVeto": false, "description": "仰卧位"}',
  232. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  233. -- 5.4.5.4 喉部CT增强 - 因子6: 图像标识
  234. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  235. ('CT_LARYNX_5_4_5_4_6', 'CT_LARYNX_5_4_5_4_6', '图像标识', 3, 'boolean',
  236. '影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位',
  237. '{"type": "dicom_check", "method": "checkImageAnnotation", "params": {"requiredFields": ["StudyInstanceUID", "BodyPartExamined", "PatientName", "PatientSex", "PatientAge", "StudyDate", "StudyTime", "KVP", "ScanDirection"]}, "isVeto": true, "description": "影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位"}',
  238. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  239. -- 5.4.5.4 喉部CT增强 - 因子7: 图像伪影
  240. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  241. ('CT_LARYNX_5_4_5_4_7', 'CT_LARYNX_5_4_5_4_7', '图像伪影', 3, 'boolean',
  242. '无明显运动、呼吸、设备或体外金属等原因产生的图像伪影',
  243. '{"type": "opencv_check", "method": "checkIMAGE_ARTIFACTS", "params": {"motionThreshold": 30.0, "beamHardeningThreshold": 50.0}, "isVeto": true, "description": "无明显运动、呼吸、设备或体外金属等原因产生的图像伪影"}',
  244. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  245. -- 5.4.5.4 喉部CT增强 - 因子8: 图像清晰度
  246. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  247. ('CT_LARYNX_5_4_5_4_8', 'CT_LARYNX_5_4_5_4_8', '图像清晰度', 3, 'boolean',
  248. '组织结构显示清晰,默认窗宽窗位合适',
  249. '{"type": "opencv_check", "method": "checkIMAGE_CLARITY", "params": {"sharpnessThreshold": 100.0, "contrastThreshold": 50.0}, "isVeto": false, "description": "组织结构显示清晰,默认窗宽窗位合适"}',
  250. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  251. -- 5.4.5.4 喉部CT增强 - 质控标准
  252. INSERT INTO `qc_standard` (`id`, `standard_code`, `standard_name`, `modality`, `body_part`, `scan_type`, `exam_item`, `pass_score`, `description`, `status`, `create_time`, `update_time`) VALUES
  253. ('STD_CT_5_4_5_4', 'CT_5_4_5_4', '喉部CT增强质控标准', 'CT', '颈部软组织', '增强', '喉部CT增强', 80,
  254. '喉部CT增强质控标准,包含8个质控因子',
  255. 1, NOW(), NOW());
  256. -- 5.4.5.4 喉部CT增强 - 标准-因子关联
  257. INSERT INTO `qc_standard_factor` (`id`, `standard_id`, `factor_id`, `weight`, `is_required`, `sort_order`, `create_time`, `update_time`) VALUES
  258. ('SF_CT_5_4_5_4_1', 'STD_CT_5_4_5_4', 'CT_LARYNX_5_4_5_4_1', 10.00, 1, 1, NOW(), NOW()),
  259. ('SF_CT_5_4_5_4_2', 'STD_CT_5_4_5_4', 'CT_LARYNX_5_4_5_4_2', 8.00, 1, 2, NOW(), NOW()),
  260. ('SF_CT_5_4_5_4_3', 'STD_CT_5_4_5_4', 'CT_LARYNX_5_4_5_4_3', 10.00, 1, 3, NOW(), NOW()),
  261. ('SF_CT_5_4_5_4_4', 'STD_CT_5_4_5_4', 'CT_LARYNX_5_4_5_4_4', 20.00, 1, 4, NOW(), NOW()),
  262. ('SF_CT_5_4_5_4_5', 'STD_CT_5_4_5_4', 'CT_LARYNX_5_4_5_4_5', 8.00, 1, 5, NOW(), NOW()),
  263. ('SF_CT_5_4_5_4_6', 'STD_CT_5_4_5_4', 'CT_LARYNX_5_4_5_4_6', 20.00, 1, 6, NOW(), NOW()),
  264. ('SF_CT_5_4_5_4_7', 'STD_CT_5_4_5_4', 'CT_LARYNX_5_4_5_4_7', 16.00, 1, 7, NOW(), NOW()),
  265. ('SF_CT_5_4_5_4_8', 'STD_CT_5_4_5_4', 'CT_LARYNX_5_4_5_4_8', 8.00, 1, 8, NOW(), NOW());
  266. -- 5.4.5.5 甲状腺CT平扫 - 因子1: 检查范围
  267. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  268. ('CT_THYROID_5_4_5_5_1', 'CT_THYROID_5_4_5_5_1', '检查范围', 3, 'boolean',
  269. '检查范围从枢椎底部至胸廓入口下3cm',
  270. '{"type": "dicom_check", "method": "checkSCAN_RANGE", "params": {"minSliceCount": 30, "expectedBodyPart": "颈部软组织", "checkCoverage": true}, "isVeto": false, "description": "检查范围从枢椎底部至胸廓入口下3cm"}',
  271. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  272. -- 5.4.5.5 甲状腺CT平扫 - 因子2: 图像偏中心
  273. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  274. ('CT_THYROID_5_4_5_5_2', 'CT_THYROID_5_4_5_5_2', '图像偏中心', 3, 'boolean',
  275. '断层位于图像正中',
  276. '{"type": "opencv_check", "method": "checkIMAGE_CENTERING", "params": {"maxOffsetRatio": 0.15}, "isVeto": false, "description": "断层位于图像正中"}',
  277. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  278. -- 5.4.5.5 甲状腺CT平扫 - 因子3: 重建参数
  279. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  280. ('CT_THYROID_5_4_5_5_3', 'CT_THYROID_5_4_5_5_3', '重建参数', 3, 'boolean',
  281. '厚层≤3.0mm,薄层≤1.25mm,DFOV:18cm',
  282. '{"type": "dicom_check", "method": "checkRECONSTRUCTION_PARAMS", "params": {"thickSliceMax": 3.0, "thickIntervalMax": 3.0, "thinSliceMax": 1.25, "thinIntervalMax": 1.25, "dfov": 18, "dfovTolerance": 2.0}, "isVeto": false, "description": "厚层≤3.0mm,薄层≤1.25mm,DFOV:18cm"}',
  283. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  284. -- 5.4.5.5 甲状腺CT平扫 - 因子4: 窗口技术
  285. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  286. ('CT_THYROID_5_4_5_5_4', 'CT_THYROID_5_4_5_5_4', '窗口技术', 3, 'boolean',
  287. '软组织窗:窗宽350~400HU,窗位35~45HU',
  288. '{"type": "dicom_check", "method": "checkWINDOW_TECHNIQUE", "params": {"softTissueWindow": {"windowWidth": {"min": 350, "max": 400}, "windowCenter": {"min": 35, "max": 45}}}, "isVeto": true, "description": "软组织窗:窗宽350~400HU,窗位35~45HU"}',
  289. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  290. -- 5.4.5.5 甲状腺CT平扫 - 因子5: 扫描体位
  291. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  292. ('CT_THYROID_5_4_5_5_5', 'CT_THYROID_5_4_5_5_5', '扫描体位', 3, 'boolean',
  293. '仰卧位',
  294. '{"type": "dicom_check", "method": "checkSCAN_POSITION", "params": {"expectedPosition": ["HFS", "FFS"]}, "isVeto": false, "description": "仰卧位"}',
  295. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  296. -- 5.4.5.5 甲状腺CT平扫 - 因子6: 图像标识
  297. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  298. ('CT_THYROID_5_4_5_5_6', 'CT_THYROID_5_4_5_5_6', '图像标识', 3, 'boolean',
  299. '影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位',
  300. '{"type": "dicom_check", "method": "checkImageAnnotation", "params": {"requiredFields": ["StudyInstanceUID", "BodyPartExamined", "PatientName", "PatientSex", "PatientAge", "StudyDate", "StudyTime", "KVP", "ScanDirection"]}, "isVeto": true, "description": "影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位"}',
  301. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  302. -- 5.4.5.5 甲状腺CT平扫 - 因子7: 图像伪影
  303. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  304. ('CT_THYROID_5_4_5_5_7', 'CT_THYROID_5_4_5_5_7', '图像伪影', 3, 'boolean',
  305. '无明显运动、呼吸、设备或体外金属等原因产生的图像伪影',
  306. '{"type": "opencv_check", "method": "checkIMAGE_ARTIFACTS", "params": {"motionThreshold": 30.0, "beamHardeningThreshold": 50.0}, "isVeto": true, "description": "无明显运动、呼吸、设备或体外金属等原因产生的图像伪影"}',
  307. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  308. -- 5.4.5.5 甲状腺CT平扫 - 因子8: 图像清晰度
  309. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  310. ('CT_THYROID_5_4_5_5_8', 'CT_THYROID_5_4_5_5_8', '图像清晰度', 3, 'boolean',
  311. '组织结构显示清晰,默认窗宽窗位合适',
  312. '{"type": "opencv_check", "method": "checkIMAGE_CLARITY", "params": {"sharpnessThreshold": 100.0, "contrastThreshold": 50.0}, "isVeto": false, "description": "组织结构显示清晰,默认窗宽窗位合适"}',
  313. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  314. -- 5.4.5.5 甲状腺CT平扫 - 质控标准
  315. INSERT INTO `qc_standard` (`id`, `standard_code`, `standard_name`, `modality`, `body_part`, `scan_type`, `exam_item`, `pass_score`, `description`, `status`, `create_time`, `update_time`) VALUES
  316. ('STD_CT_5_4_5_5', 'CT_5_4_5_5', '甲状腺CT平扫质控标准', 'CT', '颈部软组织', '平扫', '甲状腺CT平扫', 80,
  317. '甲状腺CT平扫质控标准,包含8个质控因子',
  318. 1, NOW(), NOW());
  319. -- 5.4.5.5 甲状腺CT平扫 - 标准-因子关联
  320. INSERT INTO `qc_standard_factor` (`id`, `standard_id`, `factor_id`, `weight`, `is_required`, `sort_order`, `create_time`, `update_time`) VALUES
  321. ('SF_CT_5_4_5_5_1', 'STD_CT_5_4_5_5', 'CT_THYROID_5_4_5_5_1', 10.00, 1, 1, NOW(), NOW()),
  322. ('SF_CT_5_4_5_5_2', 'STD_CT_5_4_5_5', 'CT_THYROID_5_4_5_5_2', 8.00, 1, 2, NOW(), NOW()),
  323. ('SF_CT_5_4_5_5_3', 'STD_CT_5_4_5_5', 'CT_THYROID_5_4_5_5_3', 10.00, 1, 3, NOW(), NOW()),
  324. ('SF_CT_5_4_5_5_4', 'STD_CT_5_4_5_5', 'CT_THYROID_5_4_5_5_4', 20.00, 1, 4, NOW(), NOW()),
  325. ('SF_CT_5_4_5_5_5', 'STD_CT_5_4_5_5', 'CT_THYROID_5_4_5_5_5', 8.00, 1, 5, NOW(), NOW()),
  326. ('SF_CT_5_4_5_5_6', 'STD_CT_5_4_5_5', 'CT_THYROID_5_4_5_5_6', 20.00, 1, 6, NOW(), NOW()),
  327. ('SF_CT_5_4_5_5_7', 'STD_CT_5_4_5_5', 'CT_THYROID_5_4_5_5_7', 16.00, 1, 7, NOW(), NOW()),
  328. ('SF_CT_5_4_5_5_8', 'STD_CT_5_4_5_5', 'CT_THYROID_5_4_5_5_8', 8.00, 1, 8, NOW(), NOW());
  329. -- 5.4.5.6 甲状腺CT增强 - 因子1: 检查范围
  330. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  331. ('CT_THYROID_5_4_5_6_1', 'CT_THYROID_5_4_5_6_1', '检查范围', 3, 'boolean',
  332. '检查范围从枢椎底部至胸廓入口下3cm',
  333. '{"type": "dicom_check", "method": "checkSCAN_RANGE", "params": {"minSliceCount": 30, "expectedBodyPart": "颈部软组织", "checkCoverage": true}, "isVeto": false, "description": "检查范围从枢椎底部至胸廓入口下3cm"}',
  334. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  335. -- 5.4.5.6 甲状腺CT增强 - 因子2: 图像偏中心
  336. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  337. ('CT_THYROID_5_4_5_6_2', 'CT_THYROID_5_4_5_6_2', '图像偏中心', 3, 'boolean',
  338. '断层位于图像正中',
  339. '{"type": "opencv_check", "method": "checkIMAGE_CENTERING", "params": {"maxOffsetRatio": 0.15}, "isVeto": false, "description": "断层位于图像正中"}',
  340. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  341. -- 5.4.5.6 甲状腺CT增强 - 因子3: 重建参数
  342. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  343. ('CT_THYROID_5_4_5_6_3', 'CT_THYROID_5_4_5_6_3', '重建参数', 3, 'boolean',
  344. '厚层≤3.0mm,薄层≤1.25mm,DFOV:18cm',
  345. '{"type": "dicom_check", "method": "checkRECONSTRUCTION_PARAMS", "params": {"thickSliceMax": 3.0, "thickIntervalMax": 3.0, "thinSliceMax": 1.25, "thinIntervalMax": 1.25, "dfov": 18, "dfovTolerance": 2.0}, "isVeto": false, "description": "厚层≤3.0mm,薄层≤1.25mm,DFOV:18cm"}',
  346. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  347. -- 5.4.5.6 甲状腺CT增强 - 因子4: 窗口技术
  348. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  349. ('CT_THYROID_5_4_5_6_4', 'CT_THYROID_5_4_5_6_4', '窗口技术', 3, 'boolean',
  350. '软组织窗:窗宽350~400HU,窗位35~45HU',
  351. '{"type": "dicom_check", "method": "checkWINDOW_TECHNIQUE", "params": {"softTissueWindow": {"windowWidth": {"min": 350, "max": 400}, "windowCenter": {"min": 35, "max": 45}}}, "isVeto": true, "description": "软组织窗:窗宽350~400HU,窗位35~45HU"}',
  352. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  353. -- 5.4.5.6 甲状腺CT增强 - 因子5: 扫描体位
  354. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  355. ('CT_THYROID_5_4_5_6_5', 'CT_THYROID_5_4_5_6_5', '扫描体位', 3, 'boolean',
  356. '仰卧位',
  357. '{"type": "dicom_check", "method": "checkSCAN_POSITION", "params": {"expectedPosition": ["HFS", "FFS"]}, "isVeto": false, "description": "仰卧位"}',
  358. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  359. -- 5.4.5.6 甲状腺CT增强 - 因子6: 图像标识
  360. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  361. ('CT_THYROID_5_4_5_6_6', 'CT_THYROID_5_4_5_6_6', '图像标识', 3, 'boolean',
  362. '影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位',
  363. '{"type": "dicom_check", "method": "checkImageAnnotation", "params": {"requiredFields": ["StudyInstanceUID", "BodyPartExamined", "PatientName", "PatientSex", "PatientAge", "StudyDate", "StudyTime", "KVP", "ScanDirection"]}, "isVeto": true, "description": "影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位"}',
  364. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  365. -- 5.4.5.6 甲状腺CT增强 - 因子7: 图像伪影
  366. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  367. ('CT_THYROID_5_4_5_6_7', 'CT_THYROID_5_4_5_6_7', '图像伪影', 3, 'boolean',
  368. '无明显运动、呼吸、设备或体外金属等原因产生的图像伪影',
  369. '{"type": "opencv_check", "method": "checkIMAGE_ARTIFACTS", "params": {"motionThreshold": 30.0, "beamHardeningThreshold": 50.0}, "isVeto": true, "description": "无明显运动、呼吸、设备或体外金属等原因产生的图像伪影"}',
  370. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  371. -- 5.4.5.6 甲状腺CT增强 - 因子8: 图像清晰度
  372. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  373. ('CT_THYROID_5_4_5_6_8', 'CT_THYROID_5_4_5_6_8', '图像清晰度', 3, 'boolean',
  374. '组织结构显示清晰,默认窗宽窗位合适',
  375. '{"type": "opencv_check", "method": "checkIMAGE_CLARITY", "params": {"sharpnessThreshold": 100.0, "contrastThreshold": 50.0}, "isVeto": false, "description": "组织结构显示清晰,默认窗宽窗位合适"}',
  376. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  377. -- 5.4.5.6 甲状腺CT增强 - 质控标准
  378. INSERT INTO `qc_standard` (`id`, `standard_code`, `standard_name`, `modality`, `body_part`, `scan_type`, `exam_item`, `pass_score`, `description`, `status`, `create_time`, `update_time`) VALUES
  379. ('STD_CT_5_4_5_6', 'CT_5_4_5_6', '甲状腺CT增强质控标准', 'CT', '颈部软组织', '增强', '甲状腺CT增强', 80,
  380. '甲状腺CT增强质控标准,包含8个质控因子',
  381. 1, NOW(), NOW());
  382. -- 5.4.5.6 甲状腺CT增强 - 标准-因子关联
  383. INSERT INTO `qc_standard_factor` (`id`, `standard_id`, `factor_id`, `weight`, `is_required`, `sort_order`, `create_time`, `update_time`) VALUES
  384. ('SF_CT_5_4_5_6_1', 'STD_CT_5_4_5_6', 'CT_THYROID_5_4_5_6_1', 10.00, 1, 1, NOW(), NOW()),
  385. ('SF_CT_5_4_5_6_2', 'STD_CT_5_4_5_6', 'CT_THYROID_5_4_5_6_2', 8.00, 1, 2, NOW(), NOW()),
  386. ('SF_CT_5_4_5_6_3', 'STD_CT_5_4_5_6', 'CT_THYROID_5_4_5_6_3', 10.00, 1, 3, NOW(), NOW()),
  387. ('SF_CT_5_4_5_6_4', 'STD_CT_5_4_5_6', 'CT_THYROID_5_4_5_6_4', 20.00, 1, 4, NOW(), NOW()),
  388. ('SF_CT_5_4_5_6_5', 'STD_CT_5_4_5_6', 'CT_THYROID_5_4_5_6_5', 8.00, 1, 5, NOW(), NOW()),
  389. ('SF_CT_5_4_5_6_6', 'STD_CT_5_4_5_6', 'CT_THYROID_5_4_5_6_6', 20.00, 1, 6, NOW(), NOW()),
  390. ('SF_CT_5_4_5_6_7', 'STD_CT_5_4_5_6', 'CT_THYROID_5_4_5_6_7', 16.00, 1, 7, NOW(), NOW()),
  391. ('SF_CT_5_4_5_6_8', 'STD_CT_5_4_5_6', 'CT_THYROID_5_4_5_6_8', 8.00, 1, 8, NOW(), NOW());
  392. -- 5.4.6.1 胸部CT平扫 - 因子1: 检查范围
  393. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  394. ('CT_CHEST_5_4_6_1_1', 'CT_CHEST_5_4_6_1_1', '检查范围', 3, 'boolean',
  395. '检查范围从肺尖至较低侧肋膈角下2~3cm',
  396. '{"type": "dicom_check", "method": "checkSCAN_RANGE", "params": {"minSliceCount": 30, "expectedBodyPart": "胸部", "checkCoverage": true}, "isVeto": false, "description": "检查范围从肺尖至较低侧肋膈角下2~3cm"}',
  397. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  398. -- 5.4.6.1 胸部CT平扫 - 因子2: 图像偏中心
  399. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  400. ('CT_CHEST_5_4_6_1_2', 'CT_CHEST_5_4_6_1_2', '图像偏中心', 3, 'boolean',
  401. '断层位于图像正中',
  402. '{"type": "opencv_check", "method": "checkIMAGE_CENTERING", "params": {"maxOffsetRatio": 0.15}, "isVeto": false, "description": "断层位于图像正中"}',
  403. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  404. -- 5.4.6.1 胸部CT平扫 - 因子3: 重建参数
  405. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  406. ('CT_CHEST_5_4_6_1_3', 'CT_CHEST_5_4_6_1_3', '重建参数', 3, 'boolean',
  407. '厚层≤5.0mm,薄层≤1.25mm,DFOV:33cm',
  408. '{"type": "dicom_check", "method": "checkRECONSTRUCTION_PARAMS", "params": {"thickSliceMax": 5.0, "thickIntervalMax": 5.0, "thinSliceMax": 1.25, "thinIntervalMax": 1.25, "dfov": 33, "dfovTolerance": 2.0}, "isVeto": false, "description": "厚层≤5.0mm,薄层≤1.25mm,DFOV:33cm"}',
  409. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  410. -- 5.4.6.1 胸部CT平扫 - 因子4: 窗口技术
  411. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  412. ('CT_CHEST_5_4_6_1_4', 'CT_CHEST_5_4_6_1_4', '窗口技术', 3, 'boolean',
  413. '软组织窗:窗宽300~500HU,窗位30~50HU',
  414. '{"type": "dicom_check", "method": "checkWINDOW_TECHNIQUE", "params": {"softTissueWindow": {"windowWidth": {"min": 300, "max": 500}, "windowCenter": {"min": 30, "max": 50}}}, "isVeto": true, "description": "软组织窗:窗宽300~500HU,窗位30~50HU"}',
  415. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  416. -- 5.4.6.1 胸部CT平扫 - 因子5: 扫描体位
  417. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  418. ('CT_CHEST_5_4_6_1_5', 'CT_CHEST_5_4_6_1_5', '扫描体位', 3, 'boolean',
  419. '仰卧位,双手上举',
  420. '{"type": "dicom_check", "method": "checkSCAN_POSITION", "params": {"expectedPosition": ["HFS", "FFS"]}, "isVeto": false, "description": "仰卧位,双手上举"}',
  421. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  422. -- 5.4.6.1 胸部CT平扫 - 因子6: 图像标识
  423. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  424. ('CT_CHEST_5_4_6_1_6', 'CT_CHEST_5_4_6_1_6', '图像标识', 3, 'boolean',
  425. '影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位',
  426. '{"type": "dicom_check", "method": "checkImageAnnotation", "params": {"requiredFields": ["StudyInstanceUID", "BodyPartExamined", "PatientName", "PatientSex", "PatientAge", "StudyDate", "StudyTime", "KVP", "ScanDirection"]}, "isVeto": true, "description": "影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位"}',
  427. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  428. -- 5.4.6.1 胸部CT平扫 - 因子7: 图像伪影
  429. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  430. ('CT_CHEST_5_4_6_1_7', 'CT_CHEST_5_4_6_1_7', '图像伪影', 3, 'boolean',
  431. '无明显运动、呼吸、设备或体外金属等原因产生的图像伪影',
  432. '{"type": "opencv_check", "method": "checkIMAGE_ARTIFACTS", "params": {"motionThreshold": 30.0, "beamHardeningThreshold": 50.0}, "isVeto": true, "description": "无明显运动、呼吸、设备或体外金属等原因产生的图像伪影"}',
  433. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  434. -- 5.4.6.1 胸部CT平扫 - 因子8: 图像清晰度
  435. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  436. ('CT_CHEST_5_4_6_1_8', 'CT_CHEST_5_4_6_1_8', '图像清晰度', 3, 'boolean',
  437. '组织结构显示清晰,默认窗宽窗位合适',
  438. '{"type": "opencv_check", "method": "checkIMAGE_CLARITY", "params": {"sharpnessThreshold": 100.0, "contrastThreshold": 50.0}, "isVeto": false, "description": "组织结构显示清晰,默认窗宽窗位合适"}',
  439. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  440. -- 5.4.6.1 胸部CT平扫 - 质控标准
  441. INSERT INTO `qc_standard` (`id`, `standard_code`, `standard_name`, `modality`, `body_part`, `scan_type`, `exam_item`, `pass_score`, `description`, `status`, `create_time`, `update_time`) VALUES
  442. ('STD_CT_5_4_6_1', 'CT_5_4_6_1', '胸部CT平扫质控标准', 'CT', '胸部', '平扫', '胸部CT平扫', 80,
  443. '胸部CT平扫质控标准,包含8个质控因子',
  444. 1, NOW(), NOW());
  445. -- 5.4.6.1 胸部CT平扫 - 标准-因子关联
  446. INSERT INTO `qc_standard_factor` (`id`, `standard_id`, `factor_id`, `weight`, `is_required`, `sort_order`, `create_time`, `update_time`) VALUES
  447. ('SF_CT_5_4_6_1_1', 'STD_CT_5_4_6_1', 'CT_CHEST_5_4_6_1_1', 10.00, 1, 1, NOW(), NOW()),
  448. ('SF_CT_5_4_6_1_2', 'STD_CT_5_4_6_1', 'CT_CHEST_5_4_6_1_2', 8.00, 1, 2, NOW(), NOW()),
  449. ('SF_CT_5_4_6_1_3', 'STD_CT_5_4_6_1', 'CT_CHEST_5_4_6_1_3', 10.00, 1, 3, NOW(), NOW()),
  450. ('SF_CT_5_4_6_1_4', 'STD_CT_5_4_6_1', 'CT_CHEST_5_4_6_1_4', 20.00, 1, 4, NOW(), NOW()),
  451. ('SF_CT_5_4_6_1_5', 'STD_CT_5_4_6_1', 'CT_CHEST_5_4_6_1_5', 8.00, 1, 5, NOW(), NOW()),
  452. ('SF_CT_5_4_6_1_6', 'STD_CT_5_4_6_1', 'CT_CHEST_5_4_6_1_6', 20.00, 1, 6, NOW(), NOW()),
  453. ('SF_CT_5_4_6_1_7', 'STD_CT_5_4_6_1', 'CT_CHEST_5_4_6_1_7', 16.00, 1, 7, NOW(), NOW()),
  454. ('SF_CT_5_4_6_1_8', 'STD_CT_5_4_6_1', 'CT_CHEST_5_4_6_1_8', 8.00, 1, 8, NOW(), NOW());
  455. -- 5.4.6.2 胸部CT增强 - 因子1: 检查范围
  456. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  457. ('CT_CHEST_5_4_6_2_1', 'CT_CHEST_5_4_6_2_1', '检查范围', 3, 'boolean',
  458. '检查范围从肺尖至较低侧肋膈角下2~3cm',
  459. '{"type": "dicom_check", "method": "checkSCAN_RANGE", "params": {"minSliceCount": 30, "expectedBodyPart": "胸部", "checkCoverage": true}, "isVeto": false, "description": "检查范围从肺尖至较低侧肋膈角下2~3cm"}',
  460. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  461. -- 5.4.6.2 胸部CT增强 - 因子2: 图像偏中心
  462. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  463. ('CT_CHEST_5_4_6_2_2', 'CT_CHEST_5_4_6_2_2', '图像偏中心', 3, 'boolean',
  464. '断层位于图像正中',
  465. '{"type": "opencv_check", "method": "checkIMAGE_CENTERING", "params": {"maxOffsetRatio": 0.15}, "isVeto": false, "description": "断层位于图像正中"}',
  466. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  467. -- 5.4.6.2 胸部CT增强 - 因子3: 重建参数
  468. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  469. ('CT_CHEST_5_4_6_2_3', 'CT_CHEST_5_4_6_2_3', '重建参数', 3, 'boolean',
  470. '厚层≤5.0mm,薄层≤2.0mm,DFOV:33cm',
  471. '{"type": "dicom_check", "method": "checkRECONSTRUCTION_PARAMS", "params": {"thickSliceMax": 5.0, "thickIntervalMax": 5.0, "thinSliceMax": 2.0, "thinIntervalMax": 2.0, "dfov": 33, "dfovTolerance": 2.0}, "isVeto": false, "description": "厚层≤5.0mm,薄层≤2.0mm,DFOV:33cm"}',
  472. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  473. -- 5.4.6.2 胸部CT增强 - 因子4: 窗口技术
  474. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  475. ('CT_CHEST_5_4_6_2_4', 'CT_CHEST_5_4_6_2_4', '窗口技术', 3, 'boolean',
  476. '软组织窗:窗宽300~500HU,窗位30~50HU',
  477. '{"type": "dicom_check", "method": "checkWINDOW_TECHNIQUE", "params": {"softTissueWindow": {"windowWidth": {"min": 300, "max": 500}, "windowCenter": {"min": 30, "max": 50}}}, "isVeto": true, "description": "软组织窗:窗宽300~500HU,窗位30~50HU"}',
  478. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  479. -- 5.4.6.2 胸部CT增强 - 因子5: 扫描体位
  480. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  481. ('CT_CHEST_5_4_6_2_5', 'CT_CHEST_5_4_6_2_5', '扫描体位', 3, 'boolean',
  482. '仰卧位,双手上举',
  483. '{"type": "dicom_check", "method": "checkSCAN_POSITION", "params": {"expectedPosition": ["HFS", "FFS"]}, "isVeto": false, "description": "仰卧位,双手上举"}',
  484. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  485. -- 5.4.6.2 胸部CT增强 - 因子6: 图像标识
  486. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  487. ('CT_CHEST_5_4_6_2_6', 'CT_CHEST_5_4_6_2_6', '图像标识', 3, 'boolean',
  488. '影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位',
  489. '{"type": "dicom_check", "method": "checkImageAnnotation", "params": {"requiredFields": ["StudyInstanceUID", "BodyPartExamined", "PatientName", "PatientSex", "PatientAge", "StudyDate", "StudyTime", "KVP", "ScanDirection"]}, "isVeto": true, "description": "影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位"}',
  490. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  491. -- 5.4.6.2 胸部CT增强 - 因子7: 图像伪影
  492. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  493. ('CT_CHEST_5_4_6_2_7', 'CT_CHEST_5_4_6_2_7', '图像伪影', 3, 'boolean',
  494. '无明显运动、呼吸、设备或体外金属等原因产生的图像伪影',
  495. '{"type": "opencv_check", "method": "checkIMAGE_ARTIFACTS", "params": {"motionThreshold": 30.0, "beamHardeningThreshold": 50.0}, "isVeto": true, "description": "无明显运动、呼吸、设备或体外金属等原因产生的图像伪影"}',
  496. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  497. -- 5.4.6.2 胸部CT增强 - 因子8: 图像清晰度
  498. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  499. ('CT_CHEST_5_4_6_2_8', 'CT_CHEST_5_4_6_2_8', '图像清晰度', 3, 'boolean',
  500. '组织结构显示清晰,默认窗宽窗位合适',
  501. '{"type": "opencv_check", "method": "checkIMAGE_CLARITY", "params": {"sharpnessThreshold": 100.0, "contrastThreshold": 50.0}, "isVeto": false, "description": "组织结构显示清晰,默认窗宽窗位合适"}',
  502. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  503. -- 5.4.6.2 胸部CT增强 - 质控标准
  504. INSERT INTO `qc_standard` (`id`, `standard_code`, `standard_name`, `modality`, `body_part`, `scan_type`, `exam_item`, `pass_score`, `description`, `status`, `create_time`, `update_time`) VALUES
  505. ('STD_CT_5_4_6_2', 'CT_5_4_6_2', '胸部CT增强质控标准', 'CT', '胸部', '增强', '胸部CT增强', 80,
  506. '胸部CT增强质控标准,包含8个质控因子',
  507. 1, NOW(), NOW());
  508. -- 5.4.6.2 胸部CT增强 - 标准-因子关联
  509. INSERT INTO `qc_standard_factor` (`id`, `standard_id`, `factor_id`, `weight`, `is_required`, `sort_order`, `create_time`, `update_time`) VALUES
  510. ('SF_CT_5_4_6_2_1', 'STD_CT_5_4_6_2', 'CT_CHEST_5_4_6_2_1', 10.00, 1, 1, NOW(), NOW()),
  511. ('SF_CT_5_4_6_2_2', 'STD_CT_5_4_6_2', 'CT_CHEST_5_4_6_2_2', 8.00, 1, 2, NOW(), NOW()),
  512. ('SF_CT_5_4_6_2_3', 'STD_CT_5_4_6_2', 'CT_CHEST_5_4_6_2_3', 10.00, 1, 3, NOW(), NOW()),
  513. ('SF_CT_5_4_6_2_4', 'STD_CT_5_4_6_2', 'CT_CHEST_5_4_6_2_4', 20.00, 1, 4, NOW(), NOW()),
  514. ('SF_CT_5_4_6_2_5', 'STD_CT_5_4_6_2', 'CT_CHEST_5_4_6_2_5', 8.00, 1, 5, NOW(), NOW()),
  515. ('SF_CT_5_4_6_2_6', 'STD_CT_5_4_6_2', 'CT_CHEST_5_4_6_2_6', 20.00, 1, 6, NOW(), NOW()),
  516. ('SF_CT_5_4_6_2_7', 'STD_CT_5_4_6_2', 'CT_CHEST_5_4_6_2_7', 16.00, 1, 7, NOW(), NOW()),
  517. ('SF_CT_5_4_6_2_8', 'STD_CT_5_4_6_2', 'CT_CHEST_5_4_6_2_8', 8.00, 1, 8, NOW(), NOW());
  518. -- 5.4.6.3 肋骨CT平扫 - 因子1: 检查范围
  519. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  520. ('CT_RIB_5_4_6_3_1', 'CT_RIB_5_4_6_3_1', '检查范围', 3, 'boolean',
  521. '检查范围从第一肋上缘至终末肋下缘',
  522. '{"type": "dicom_check", "method": "checkSCAN_RANGE", "params": {"minSliceCount": 30, "expectedBodyPart": "胸部", "checkCoverage": true}, "isVeto": false, "description": "检查范围从第一肋上缘至终末肋下缘"}',
  523. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  524. -- 5.4.6.3 肋骨CT平扫 - 因子2: 图像偏中心
  525. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  526. ('CT_RIB_5_4_6_3_2', 'CT_RIB_5_4_6_3_2', '图像偏中心', 3, 'boolean',
  527. '断层位于图像正中',
  528. '{"type": "opencv_check", "method": "checkIMAGE_CENTERING", "params": {"maxOffsetRatio": 0.15}, "isVeto": false, "description": "断层位于图像正中"}',
  529. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  530. -- 5.4.6.3 肋骨CT平扫 - 因子3: 重建参数
  531. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  532. ('CT_RIB_5_4_6_3_3', 'CT_RIB_5_4_6_3_3', '重建参数', 3, 'boolean',
  533. '厚层≤5.0mm,薄层≤1.25mm,DFOV:33cm',
  534. '{"type": "dicom_check", "method": "checkRECONSTRUCTION_PARAMS", "params": {"thickSliceMax": 5.0, "thickIntervalMax": 5.0, "thinSliceMax": 1.25, "thinIntervalMax": 1.25, "dfov": 33, "dfovTolerance": 2.0}, "isVeto": false, "description": "厚层≤5.0mm,薄层≤1.25mm,DFOV:33cm"}',
  535. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  536. -- 5.4.6.3 肋骨CT平扫 - 因子4: 窗口技术
  537. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  538. ('CT_RIB_5_4_6_3_4', 'CT_RIB_5_4_6_3_4', '窗口技术', 3, 'boolean',
  539. '软组织窗:窗宽2000~2500HU,窗位550~750HU',
  540. '{"type": "dicom_check", "method": "checkWINDOW_TECHNIQUE", "params": {"softTissueWindow": {"windowWidth": {"min": 2000, "max": 2500}, "windowCenter": {"min": 550, "max": 750}}}, "isVeto": true, "description": "软组织窗:窗宽2000~2500HU,窗位550~750HU"}',
  541. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  542. -- 5.4.6.3 肋骨CT平扫 - 因子5: 扫描体位
  543. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  544. ('CT_RIB_5_4_6_3_5', 'CT_RIB_5_4_6_3_5', '扫描体位', 3, 'boolean',
  545. '仰卧位,双手上举',
  546. '{"type": "dicom_check", "method": "checkSCAN_POSITION", "params": {"expectedPosition": ["HFS", "FFS"]}, "isVeto": false, "description": "仰卧位,双手上举"}',
  547. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  548. -- 5.4.6.3 肋骨CT平扫 - 因子6: 图像标识
  549. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  550. ('CT_RIB_5_4_6_3_6', 'CT_RIB_5_4_6_3_6', '图像标识', 3, 'boolean',
  551. '影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位',
  552. '{"type": "dicom_check", "method": "checkImageAnnotation", "params": {"requiredFields": ["StudyInstanceUID", "BodyPartExamined", "PatientName", "PatientSex", "PatientAge", "StudyDate", "StudyTime", "KVP", "ScanDirection"]}, "isVeto": true, "description": "影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位"}',
  553. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  554. -- 5.4.6.3 肋骨CT平扫 - 因子7: 图像伪影
  555. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  556. ('CT_RIB_5_4_6_3_7', 'CT_RIB_5_4_6_3_7', '图像伪影', 3, 'boolean',
  557. '无明显运动、呼吸、设备或体外金属等原因产生的图像伪影',
  558. '{"type": "opencv_check", "method": "checkIMAGE_ARTIFACTS", "params": {"motionThreshold": 30.0, "beamHardeningThreshold": 50.0}, "isVeto": true, "description": "无明显运动、呼吸、设备或体外金属等原因产生的图像伪影"}',
  559. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  560. -- 5.4.6.3 肋骨CT平扫 - 因子8: 图像清晰度
  561. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  562. ('CT_RIB_5_4_6_3_8', 'CT_RIB_5_4_6_3_8', '图像清晰度', 3, 'boolean',
  563. '组织结构显示清晰,默认窗宽窗位合适',
  564. '{"type": "opencv_check", "method": "checkIMAGE_CLARITY", "params": {"sharpnessThreshold": 100.0, "contrastThreshold": 50.0}, "isVeto": false, "description": "组织结构显示清晰,默认窗宽窗位合适"}',
  565. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  566. -- 5.4.6.3 肋骨CT平扫 - 质控标准
  567. INSERT INTO `qc_standard` (`id`, `standard_code`, `standard_name`, `modality`, `body_part`, `scan_type`, `exam_item`, `pass_score`, `description`, `status`, `create_time`, `update_time`) VALUES
  568. ('STD_CT_5_4_6_3', 'CT_5_4_6_3', '肋骨CT平扫质控标准', 'CT', '胸部', '平扫', '肋骨CT平扫', 80,
  569. '肋骨CT平扫质控标准,包含8个质控因子',
  570. 1, NOW(), NOW());
  571. -- 5.4.6.3 肋骨CT平扫 - 标准-因子关联
  572. INSERT INTO `qc_standard_factor` (`id`, `standard_id`, `factor_id`, `weight`, `is_required`, `sort_order`, `create_time`, `update_time`) VALUES
  573. ('SF_CT_5_4_6_3_1', 'STD_CT_5_4_6_3', 'CT_RIB_5_4_6_3_1', 10.00, 1, 1, NOW(), NOW()),
  574. ('SF_CT_5_4_6_3_2', 'STD_CT_5_4_6_3', 'CT_RIB_5_4_6_3_2', 8.00, 1, 2, NOW(), NOW()),
  575. ('SF_CT_5_4_6_3_3', 'STD_CT_5_4_6_3', 'CT_RIB_5_4_6_3_3', 10.00, 1, 3, NOW(), NOW()),
  576. ('SF_CT_5_4_6_3_4', 'STD_CT_5_4_6_3', 'CT_RIB_5_4_6_3_4', 20.00, 1, 4, NOW(), NOW()),
  577. ('SF_CT_5_4_6_3_5', 'STD_CT_5_4_6_3', 'CT_RIB_5_4_6_3_5', 8.00, 1, 5, NOW(), NOW()),
  578. ('SF_CT_5_4_6_3_6', 'STD_CT_5_4_6_3', 'CT_RIB_5_4_6_3_6', 20.00, 1, 6, NOW(), NOW()),
  579. ('SF_CT_5_4_6_3_7', 'STD_CT_5_4_6_3', 'CT_RIB_5_4_6_3_7', 16.00, 1, 7, NOW(), NOW()),
  580. ('SF_CT_5_4_6_3_8', 'STD_CT_5_4_6_3', 'CT_RIB_5_4_6_3_8', 8.00, 1, 8, NOW(), NOW());
  581. -- 5.4.6.4 肺低剂量CT平扫 - 因子1: 检查范围
  582. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  583. ('CT_LUNG_LD_5_4_6_4_1', 'CT_LUNG_LD_5_4_6_4_1', '检查范围', 3, 'boolean',
  584. '检查范围从肺尖至较低侧肋膈角下2~3cm',
  585. '{"type": "dicom_check", "method": "checkSCAN_RANGE", "params": {"minSliceCount": 30, "expectedBodyPart": "胸部", "checkCoverage": true}, "isVeto": false, "description": "检查范围从肺尖至较低侧肋膈角下2~3cm"}',
  586. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  587. -- 5.4.6.4 肺低剂量CT平扫 - 因子2: 图像偏中心
  588. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  589. ('CT_LUNG_LD_5_4_6_4_2', 'CT_LUNG_LD_5_4_6_4_2', '图像偏中心', 3, 'boolean',
  590. '断层位于图像正中',
  591. '{"type": "opencv_check", "method": "checkIMAGE_CENTERING", "params": {"maxOffsetRatio": 0.15}, "isVeto": false, "description": "断层位于图像正中"}',
  592. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  593. -- 5.4.6.4 肺低剂量CT平扫 - 因子3: 重建参数
  594. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  595. ('CT_LUNG_LD_5_4_6_4_3', 'CT_LUNG_LD_5_4_6_4_3', '重建参数', 3, 'boolean',
  596. '厚层≤5.0mm,薄层≤2.0mm,DFOV:33cm',
  597. '{"type": "dicom_check", "method": "checkRECONSTRUCTION_PARAMS", "params": {"thickSliceMax": 5.0, "thickIntervalMax": 5.0, "thinSliceMax": 2.0, "thinIntervalMax": 2.0, "dfov": 33, "dfovTolerance": 2.0}, "isVeto": false, "description": "厚层≤5.0mm,薄层≤2.0mm,DFOV:33cm"}',
  598. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  599. -- 5.4.6.4 肺低剂量CT平扫 - 因子4: 窗口技术
  600. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  601. ('CT_LUNG_LD_5_4_6_4_4', 'CT_LUNG_LD_5_4_6_4_4', '窗口技术', 3, 'boolean',
  602. '软组织窗:窗宽800~1500HU,窗位-800~-600HU',
  603. '{"type": "dicom_check", "method": "checkWINDOW_TECHNIQUE", "params": {"softTissueWindow": {"windowWidth": {"min": 800, "max": 1500}, "windowCenter": {"min": -800, "max": -600}}}, "isVeto": true, "description": "软组织窗:窗宽800~1500HU,窗位-800~-600HU"}',
  604. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  605. -- 5.4.6.4 肺低剂量CT平扫 - 因子5: 扫描体位
  606. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  607. ('CT_LUNG_LD_5_4_6_4_5', 'CT_LUNG_LD_5_4_6_4_5', '扫描体位', 3, 'boolean',
  608. '仰卧位,双手上举',
  609. '{"type": "dicom_check", "method": "checkSCAN_POSITION", "params": {"expectedPosition": ["HFS", "FFS"]}, "isVeto": false, "description": "仰卧位,双手上举"}',
  610. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  611. -- 5.4.6.4 肺低剂量CT平扫 - 因子6: 图像标识
  612. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  613. ('CT_LUNG_LD_5_4_6_4_6', 'CT_LUNG_LD_5_4_6_4_6', '图像标识', 3, 'boolean',
  614. '影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位',
  615. '{"type": "dicom_check", "method": "checkImageAnnotation", "params": {"requiredFields": ["StudyInstanceUID", "BodyPartExamined", "PatientName", "PatientSex", "PatientAge", "StudyDate", "StudyTime", "KVP", "ScanDirection"]}, "isVeto": true, "description": "影像号、检查部位、姓名、性别、年龄、日期、时间、kV、mAs值、扫描方位"}',
  616. 'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);
  617. -- 5.4.6.4 肺低剂量CT平扫 - 因子7: 图像伪影
  618. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  619. ('CT_LUNG_LD_5_4_6_4_7', 'CT_LUNG_LD_5_4_6_4_7', '图像伪影', 3, 'boolean',
  620. '无明显运动、呼吸、设备或体外金属等原因产生的图像伪影',
  621. '{"type": "opencv_check", "method": "checkIMAGE_ARTIFACTS", "params": {"motionThreshold": 30.0, "beamHardeningThreshold": 50.0}, "isVeto": true, "description": "无明显运动、呼吸、设备或体外金属等原因产生的图像伪影"}',
  622. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  623. -- 5.4.6.4 肺低剂量CT平扫 - 因子8: 图像清晰度
  624. INSERT INTO `qc_factor` (`id`, `factor_code`, `factor_name`, `factor_category`, `factor_type`, `description`, `check_rule`, `data_source`, `status`, `create_time`, `update_time`, `modality`, `body_part`, `scan_type`) VALUES
  625. ('CT_LUNG_LD_5_4_6_4_8', 'CT_LUNG_LD_5_4_6_4_8', '图像清晰度', 3, 'boolean',
  626. '组织结构显示清晰,默认窗宽窗位合适',
  627. '{"type": "opencv_check", "method": "checkIMAGE_CLARITY", "params": {"sharpnessThreshold": 100.0, "contrastThreshold": 50.0}, "isVeto": false, "description": "组织结构显示清晰,默认窗宽窗位合适"}',
  628. 'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);
  629. -- 5.4.6.4 肺低剂量CT平扫 - 质控标准
  630. INSERT INTO `qc_standard` (`id`, `standard_code`, `standard_name`, `modality`, `body_part`, `scan_type`, `exam_item`, `pass_score`, `description`, `status`, `create_time`, `update_time`) VALUES
  631. ('STD_CT_5_4_6_4', 'CT_5_4_6_4', '肺低剂量CT平扫质控标准', 'CT', '胸部', '平扫', '肺低剂量CT平扫', 80,
  632. '肺低剂量CT平扫质控标准,包含8个质控因子',
  633. 1, NOW(), NOW());
  634. -- 5.4.6.4 肺低剂量CT平扫 - 标准-因子关联
  635. INSERT INTO `qc_standard_factor` (`id`, `standard_id`, `factor_id`, `weight`, `is_required`, `sort_order`, `create_time`, `update_time`) VALUES
  636. ('SF_CT_5_4_6_4_1', 'STD_CT_5_4_6_4', 'CT_LUNG_LD_5_4_6_4_1', 10.00, 1, 1, NOW(), NOW()),
  637. ('SF_CT_5_4_6_4_2', 'STD_CT_5_4_6_4', 'CT_LUNG_LD_5_4_6_4_2', 8.00, 1, 2, NOW(), NOW()),
  638. ('SF_CT_5_4_6_4_3', 'STD_CT_5_4_6_4', 'CT_LUNG_LD_5_4_6_4_3', 10.00, 1, 3, NOW(), NOW()),
  639. ('SF_CT_5_4_6_4_4', 'STD_CT_5_4_6_4', 'CT_LUNG_LD_5_4_6_4_4', 20.00, 1, 4, NOW(), NOW()),
  640. ('SF_CT_5_4_6_4_5', 'STD_CT_5_4_6_4', 'CT_LUNG_LD_5_4_6_4_5', 8.00, 1, 5, NOW(), NOW()),
  641. ('SF_CT_5_4_6_4_6', 'STD_CT_5_4_6_4', 'CT_LUNG_LD_5_4_6_4_6', 20.00, 1, 6, NOW(), NOW()),
  642. ('SF_CT_5_4_6_4_7', 'STD_CT_5_4_6_4', 'CT_LUNG_LD_5_4_6_4_7', 16.00, 1, 7, NOW(), NOW()),
  643. ('SF_CT_5_4_6_4_8', 'STD_CT_5_4_6_4', 'CT_LUNG_LD_5_4_6_4_8', 8.00, 1, 8, NOW(), NOW());