qc-ns/doc/sql/fixed_sql/part1.sql

-- ============================================================================
-- 医保影像云图像质控规范 - SQL数据导入脚本
--
-- 文档：医保影像云图像质控规范 (YXY-QC-2025-A1)
-- 创建时间：2026-01-13
--
-- 本文件包含：
-- - Part 1: 影像检查图像基础要求（4.1-4.7）
-- - Part 2: CT图像质量控制整体要求（5.3）
-- - Part 3: CT颅脑平扫质控标准（5.4.1.1）
-- - Part 4: CT颅脑增强质控标准（5.4.1.2）
--
-- 说明：根据现有表结构生成，适用于 qc_factor、qc_standard、qc_standard_factor 表
-- ============================================================================

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ===================================
-- Part 1: 影像检查图像基础要求（适用于所有影像模态）
-- ===================================

-- 4.1 有效图像（否决项）
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
('BASIC_4_1', 'BASIC_4_1', '有效图像', 1, 'boolean',
'影像检查图像须确保清晰度与可辨识性，能够为诊断提供准确依据，严禁出现全黑、全白等无效影像',
'{
  "type": "opencv_check",
  "method": "checkValidImage",
  "params": {
    "minSharpness": 50.0,
    "minBrightness": 10.0,
    "maxBrightness": 245.0,
    "minStdDev": 20.0
  },
  "isVeto": true,
  "description": "使用Laplacian方差检测清晰度，检查亮度范围和标准差，识别全黑、全白图像"
}',
'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 4.2 真实人体图像（否决项）
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
('BASIC_4_2', 'BASIC_4_2', '真实人体图像', 1, 'boolean',
'影像检查图像须真实反映人体解剖结构，严禁使用非真实人体图像，如：仿人体模型、质控水模、动植物等',
'{
  "type": "opencv_check",
  "method": "checkRealHumanBody",
  "params": {
    "minEdgeRatio": 0.015,
    "maxEdgeRatio": 0.50,
    "minTextureComplexity": 3.0
  },
  "isVeto": true,
  "description": "检查边缘密度和纹理复杂度，识别非真实人体图像（模型、水模、动植物等）"
}',
'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 4.3 原始完整图像
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
('BASIC_4_3', 'BASIC_4_3', '原始完整图像', 1, 'boolean',
'影像检查图像须为原始采集内容，严禁篡改、添加、删减、伪造处理',
'{
  "type": "opencv_check",
  "method": "checkOriginalComplete",
  "params": {
    "maxAvgEdgeCount": 500.0,
    "checkCompressionArtifacts": true
  },
  "isVeto": false,
  "description": "检测图像是否经过篡改、添加、删减或伪造处理"
}',
'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 4.4 非拼接图像
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
('BASIC_4_4', 'BASIC_4_4', '非拼接图像', 1, 'boolean',
'影像检查图像须完整包含患者同一次检查的全部图像，禁止将不同机构、不同患者、不同时间采集的检查图像拼接为同一次影像检查图像',
'{
  "type": "opencv_check",
  "method": "checkNonStitched",
  "params": {
    "detectSeams": true,
    "maxSeamEdges": 10,
    "checkInconsistentLighting": true
  },
  "isVeto": false,
  "description": "检测图像是否存在拼接痕迹、接缝或光照不一致"
}',
'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 4.5 非重复图像
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
('BASIC_4_5', 'BASIC_4_5', '非重复图像', 1, 'boolean',
'同一患者的同次影像检查图像不得被重复使用于不同的检查记录中，严禁将部分影像检查图像跨患者、跨机构重复使用',
'{
  "type": "dicom_check",
  "method": "checkNonDuplicate",
  "params": {
    "checkAcrossStudies": true,
    "checkAcrossPatients": true,
    "checkAcrossInstitutions": true
  },
  "isVeto": false,
  "description": "通过SOP Instance UID和图像哈希值检查图像是否被重复使用"
}',
'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 4.6 患者信息相符
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
('BASIC_4_6', 'BASIC_4_6', '患者信息相符', 1, 'boolean',
'影像检查图像特征须与患者年龄、性别、病史等信息相符',
'{
  "type": "dicom_check",
  "method": "checkPatientInfoMatch",
  "params": {
    "checkAgeConsistency": true,
    "checkSexConsistency": true,
    "allowAgeDeviation": 5
  },
  "isVeto": false,
  "description": "验证DICOM中的患者年龄、性别与图像特征是否一致"
}',
'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 4.7 检查部位一致
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
('BASIC_4_7', 'BASIC_4_7', '检查部位一致', 1, 'boolean',
'影像检查图像显示的检查部位须与检查报告、医保结算对应信息保持一致',
'{
  "type": "dicom_check",
  "method": "checkBodyPartConsistent",
  "params": {
    "compareWithReport": true,
    "compareWithSettlement": true,
    "allowSynonyms": true
  },
  "isVeto": false,
  "description": "验证图像显示的检查部位与检查报告、医保结算信息是否一致"
}',
'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);


-- ===================================
-- Part 2: CT图像质量控制整体要求（5.3）
-- ===================================

-- 5.3.1 图像信息（需包含DICOM元数据）（否决项）
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
('CT_5_3_1', 'CT_5_3_1', 'CT图像信息完整性', 2, 'boolean',
'需包含患者标识、扫描参数等DICOM元数据信息',
'{
  "type": "dicom_check",
  "method": "checkCTDicomMetadata",
  "params": {
    "requiredFields": [
      "PatientID",
      "PatientName",
      "StudyDate",
      "Modality",
      "SliceThickness",
      "KVP"
    ]
  },
  "isVeto": true,
  "description": "检查CT DICOM文件是否包含必需的元数据字段"
}',
'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 5.3.2 图像质量（窗技术应用）
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
('CT_5_3_2', 'CT_5_3_2', 'CT窗技术应用', 2, 'boolean',
'图像对比度和灰度，应依检查部位的规范，合理应用窗技术，满足组织间的不同层次对比',
'{
  "type": "dicom_check",
  "method": "checkCTWindowTechnique",
  "params": {
    "requireWindowCenter": true,
    "requireWindowWidth": true,
    "checkAppropriateWindow": true
  },
  "isVeto": false,
  "description": "检查是否正确应用窗技术（窗宽窗位）"
}',
'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);


-- ===================================
-- Part 3: CT颅脑质控标准（5.4.1）
-- ===================================

-- 5.4.1.1 头颅CT平扫
INSERT INTO `qc_standard` (`id`, `standard_code`, `standard_name`, `modality`, `body_part`, `scan_type`, `exam_item`, `factor_category`, `description`, `pass_score`, `status`, `create_time`, `update_time`) VALUES
('STD_CT_5_4_1_1', 'CT_5_4_1_1', '头颅CT平扫质控标准', 'CT', '颅脑', '平扫', '头颅CT平扫', 2,
'基于医保影像云规范的颅脑CT平扫质控标准，包含检查范围、重建参数、窗口技术、图像标识、伪影、清晰度等要求',
80, 1, NOW(), NOW());

-- 头颅CT平扫 - 检查范围
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
('CT_5_4_1_1_1', 'CT_5_4_1_1_1', '检查范围（颅脑）', 2, 'string',
'检查范围：从颅底至颅顶',
'{
  "type": "dicom_check",
  "method": "checkScanRangeSkullBaseToTop",
  "params": {
    "minSliceCount": 30,
    "expectedBodyPart": "BRAIN",
    "checkCoverage": true
  },
  "isVeto": false,
  "description": "验证扫描范围是否覆盖颅底至颅顶"
}',
'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 头颅CT平扫 - 图像偏中心
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
('CT_5_4_1_1_2', 'CT_5_4_1_1_2', '图像偏中心', 2, 'string',
'图像偏中心：断层位于图像正中',
'{
  "type": "opencv_check",
  "method": "checkImageCentering",
  "params": {
    "maxOffsetRatio": 0.10
  },
  "isVeto": false,
  "description": "检测图像内容重心是否偏离中心"
}',
'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 头颅CT平扫 - 重建参数
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
('CT_5_4_1_1_3', 'CT_5_4_1_1_3', '重建参数', 2, 'object',
'重建参数：厚层层厚/层间隔≤5mm/5mm，薄层层厚/层间隔≤1.25mm/1.25mm，DFOV：23cm',
'{
  "type": "dicom_check",
  "method": "checkReconstructionParams",
  "params": {
    "thickSlice": {
      "maxSliceThickness": 5.0,
      "maxSliceInterval": 5.0
    },
    "thinSlice": {
      "maxSliceThickness": 1.25,
      "maxSliceInterval": 1.25
    },
    "dfov": {
      "nominal": 23.0,
      "tolerance": 3.0
    }
  },
  "isVeto": false,
  "description": "检查层厚、层间隔和DFOV参数"
}',
'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 头颅CT平扫 - 窗口技术（脑窗+骨窗）（否决项）
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
('CT_5_4_1_1_4', 'CT_5_4_1_1_4', '窗口技术', 2, 'object',
'窗口技术：脑窗窗宽80~100HU，窗位35~45HU；骨窗窗宽3500~4000HU，窗位500~700HU',
'{
  "type": "dicom_check",
  "method": "checkWindowTechnique",
  "params": {
    "brainWindow": {
      "windowWidth": {"min": 80, "max": 100},
      "windowCenter": {"min": 35, "max": 45}
    },
    "boneWindow": {
      "windowWidth": {"min": 3500, "max": 4000},
      "windowCenter": {"min": 500, "max": 700}
    }
  },
  "isVeto": true,
  "description": "检查脑窗和骨窗的窗宽窗位是否符合标准"
}',
'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 头颅CT平扫 - 扫描体位
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
('CT_5_4_1_1_5', 'CT_5_4_1_1_5', '扫描体位', 2, 'string',
'扫描体位：仰卧位',
'{
  "type": "dicom_check",
  "method": "checkScanPosition",
  "params": {
    "expectedPosition": "HFS",
    "allowedPositions": ["HFS", "FFS"]
  },
  "isVeto": false,
  "description": "验证患者体位是否符合标准（HFS-仰卧位头先进）"
}',
'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 头颅CT平扫 - 图像标识（否决项）
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
('CT_5_4_1_1_6', 'CT_5_4_1_1_6', '图像标识', 2, 'boolean',
'图像标识：影像号、检查部位、姓名、性别、年龄、检查日期、检查时间、kV、mAs值、扫描方位',
'{
  "type": "dicom_check",
  "method": "checkImageAnnotation",
  "params": {
    "requiredFields": [
      "StudyInstanceUID",
      "BodyPartExamined",
      "PatientName",
      "PatientSex",
      "PatientAge",
      "StudyDate",
      "StudyTime",
      "KVP",
      "Exposure"
    ]
  },
  "isVeto": true,
  "description": "检查DICOM文件是否包含所有必需的图像标识信息"
}',
'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 头颅CT平扫 - 图像伪影（否决项）
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
('CT_5_4_1_1_7', 'CT_5_4_1_1_7', '图像伪影', 2, 'boolean',
'图像伪影：没有运动伪影以及高衰减伪影',
'{
  "type": "opencv_check",
  "method": "checkImageArtifact",
  "params": {
    "maxMotionArtifactLevel": 2,
    "checkBeamHardening": true,
    "checkMetalArtifact": true,
    "maxArtifactRatio": 0.15
  },
  "isVeto": true,
  "description": "检测运动伪影、束硬化伪影、金属伪影等CT常见伪影"
}',
'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 头颅CT平扫 - 图像清晰度
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
('CT_5_4_1_1_8', 'CT_5_4_1_1_8', '图像清晰度', 2, 'number',
'图像清晰度：颅脑组织显示清晰',
'{
  "type": "opencv_check",
  "method": "checkImageClarity",
  "params": {
    "minSharpness": 100.0,
    "minContrast": 30.0
  },
  "isVeto": false,
  "description": "检测颅脑组织显示的清晰度"
}',
'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);


-- ===================================
-- 关联质控因子到头颅CT平扫标准
-- ===================================

DELETE FROM qc_standard_factor WHERE standard_id = 'STD_CT_5_4_1_1';

-- 基础要求（4.1-4.7）
INSERT INTO `qc_standard_factor` (`id`, `standard_id`, `factor_id`, `weight`, `is_required`, `sort_order`, `create_time`, `update_time`) VALUES
('SF_CT_5_4_1_1_4_1', 'STD_CT_5_4_1_1', 'BASIC_4_1', 15.00, 1, 1, NOW(), NOW()),
('SF_CT_5_4_1_1_4_2', 'STD_CT_5_4_1_1', 'BASIC_4_2', 15.00, 1, 2, NOW(), NOW()),
('SF_CT_5_4_1_1_4_3', 'STD_CT_5_4_1_1', 'BASIC_4_3', 5.00, 0, 3, NOW(), NOW()),
('SF_CT_5_4_1_1_4_4', 'STD_CT_5_4_1_1', 'BASIC_4_4', 5.00, 0, 4, NOW(), NOW()),
('SF_CT_5_4_1_1_4_5', 'STD_CT_5_4_1_1', 'BASIC_4_5', 5.00, 0, 5, NOW(), NOW()),
('SF_CT_5_4_1_1_4_6', 'STD_CT_5_4_1_1', 'BASIC_4_6', 5.00, 0, 6, NOW(), NOW()),
('SF_CT_5_4_1_1_4_7', 'STD_CT_5_4_1_1', 'BASIC_4_7', 5.00, 0, 7, NOW(), NOW()),
-- CT整体要求（5.3）
('SF_CT_5_4_1_1_5_3_1', 'STD_CT_5_4_1_1', 'CT_5_3_1', 10.00, 1, 8, NOW(), NOW()),
('SF_CT_5_4_1_1_5_3_2', 'STD_CT_5_4_1_1', 'CT_5_3_2', 5.00, 0, 9, NOW(), NOW()),
-- 颅脑专项要求
('SF_CT_5_4_1_1_SPEC_1', 'STD_CT_5_4_1_1', 'CT_5_4_1_1_1', 5.00, 0, 10, NOW(), NOW()),
('SF_CT_5_4_1_1_SPEC_2', 'STD_CT_5_4_1_1', 'CT_5_4_1_1_2', 5.00, 0, 11, NOW(), NOW()),
('SF_CT_5_4_1_1_SPEC_3', 'STD_CT_5_4_1_1', 'CT_5_4_1_1_3', 5.00, 0, 12, NOW(), NOW()),
('SF_CT_5_4_1_1_SPEC_4', 'STD_CT_5_4_1_1', 'CT_5_4_1_1_4', 10.00, 1, 13, NOW(), NOW()),
('SF_CT_5_4_1_1_SPEC_5', 'STD_CT_5_4_1_1', 'CT_5_4_1_1_5', 5.00, 0, 14, NOW(), NOW()),
('SF_CT_5_4_1_1_SPEC_6', 'STD_CT_5_4_1_1', 'CT_5_4_1_1_6', 10.00, 1, 15, NOW(), NOW()),
('SF_CT_5_4_1_1_SPEC_7', 'STD_CT_5_4_1_1', 'CT_5_4_1_1_7', 10.00, 1, 16, NOW(), NOW()),
('SF_CT_5_4_1_1_SPEC_8', 'STD_CT_5_4_1_1', 'CT_5_4_1_1_8', 5.00, 0, 17, NOW(), NOW());



-- ============================================================================
-- Part 4: CT颅脑增强质控标准（5.4.1.2）
-- ============================================================================

-- ===================================
-- 5.4.1.2 头颅CT增强 - 质控因子（qc_factor）
-- ===================================
-- 因子1：检查范围 - 从颅底至颅顶
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
('CT_HEAD_ENH_5_4_1_2_1', 'CT_HEAD_ENH_5_4_1_2_1', '检查范围', 3, 'boolean', '检查范围从颅底至颅顶，确保覆盖完整颅脑区域',
'{
  "type": "dicom_check",
  "method": "checkScanRangeSkullBaseToTop",
  "params": {
    "minSliceCount": 30,
    "expectedBodyPart": "BRAIN",
    "checkCoverage": true
  },
  "isVeto": false,
  "description": "通过DICOM序列图像数量和BodyPart标签验证扫描范围是否覆盖颅底至颅顶"
}',
'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 因子2：图像偏中心 - 断层位于图像正中
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
('CT_HEAD_ENH_5_4_1_2_2', 'CT_HEAD_ENH_5_4_1_2_2', '图像偏中心', 3, 'string', '断层位于图像正中，允许适度偏移',
'{
  "type": "opencv_check",
  "method": "checkImageCentering",
  "params": {
    "maxOffsetRatio": 0.15,
    "checkCenterOfMass": true
  },
  "isVeto": false,
  "description": "检测图像内容重心是否偏离中心超过15%"
}',
'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 因子3：重建参数 - 层厚/层间隔、DFOV
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
('CT_HEAD_ENH_5_4_1_2_3', 'CT_HEAD_ENH_5_4_1_2_3', '重建参数', 3, 'object', '厚层层厚/层间隔≤5mm/5mm，薄层层厚/层间隔≤1.25mm/1.25mm，DFOV：23cm',
'{
  "type": "dicom_check",
  "method": "checkReconstructionParams",
  "params": {
    "thickSlice": {
      "maxSliceThickness": 5.0,
      "maxSliceInterval": 5.0
    },
    "thinSlice": {
      "maxSliceThickness": 1.25,
      "maxSliceInterval": 1.25
    },
    "dfov": {
      "nominal": 23.0,
      "tolerance": 5.0
    }
  },
  "isVeto": false,
  "description": "检查DICOM标签中的层厚、层间隔和DFOV是否符合规范"
}',
'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 因子4：窗口技术 - 脑窗静脉期（否决项）
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
('CT_HEAD_ENH_5_4_1_2_4', 'CT_HEAD_ENH_5_4_1_2_4', '窗口技术', 3, 'object', '常规包含脑窗静脉期：窗宽80~100HU，窗位35~45HU',
'{
  "type": "dicom_check",
  "method": "checkWindowTechnique",
  "params": {
    "brainWindowVenous": {
      "windowWidth": {"min": 80, "max": 100},
      "windowCenter": {"min": 35, "max": 45}
    }
  },
  "isVeto": true,
  "description": "检查窗宽窗位是否符合脑窗静脉期标准（增强CT关键参数）"
}',
'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 因子5：扫描体位 - 仰卧位
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
('CT_HEAD_ENH_5_4_1_2_5', 'CT_HEAD_ENH_5_4_1_2_5', '扫描体位', 3, 'string', '扫描体位：仰卧位',
'{
  "type": "dicom_check",
  "method": "checkScanPosition",
  "params": {
    "expectedPosition": "HFS",
    "allowedPositions": ["HFS", "FFS", "HFP", "FFP"],
    "checkPatientOrientation": true
  },
  "isVeto": false,
  "description": "验证患者体位是否符合标准（Head First Supine - HFS表示仰卧位头先进）"
}',
'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 因子6：图像标识（否决项）
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
('CT_HEAD_ENH_5_4_1_2_6', 'CT_HEAD_ENH_5_4_1_2_6', '图像标识', 3, 'boolean', '图像标识须包含：影像号、检查部位、姓名、性别、年龄、检查日期、检查时间、kV、mAs值、扫描方位',
'{
  "type": "dicom_check",
  "method": "checkImageAnnotation",
  "params": {
    "requiredFields": [
      "StudyInstanceUID",        -- 影像号
      "BodyPartExamined",        -- 检查部位
      "PatientName",             -- 姓名
      "PatientSex",              -- 性别
      "PatientAge",              -- 年龄
      "StudyDate",               -- 检查日期
      "StudyTime",               -- 检查时间
      "KVP",                     -- kV值
      "Exposure",                -- mAs值
      "ScanOrientation"          -- 扫描方位
    ]
  },
  "isVeto": true,
  "description": "检查DICOM文件是否包含所有必需的图像标识信息"
}',
'dicom_metadata', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 因子7：图像伪影（否决项）
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
('CT_HEAD_ENH_5_4_1_2_7', 'CT_HEAD_ENH_5_4_1_2_7', '图像伪影', 3, 'boolean', '没有运动伪影以及高衰减伪影',
'{
  "type": "opencv_check",
  "method": "checkImageArtifactEnhanced",
  "params": {
    "maxMotionArtifactLevel": 2,
    "checkBeamHardening": true,
    "checkMetalArtifact": true,
    "maxArtifactRatio": 0.15
  },
  "isVeto": true,
  "description": "检测运动伪影、束硬化伪影、金属伪影等增强CT常见伪影"
}',
'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);

-- 因子8：图像清晰度 - 增强CT脑部血管明显强化
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
('CT_HEAD_ENH_5_4_1_2_8', 'CT_HEAD_ENH_5_4_1_2_8', '图像清晰度', 3, 'number', '增强CT脑部血管明显强化，血管对比度清晰',
'{
  "type": "opencv_check",
  "method": "checkImageClarityEnhanced",
  "params": {
    "minVesselContrast": 50.0,
    "minSharpness": 100.0,
    "checkEnhancement": true,
    "expectedEnhancementRatio": 1.5
  },
  "isVeto": false,
  "description": "检测增强CT血管强化程度和清晰度，评估血管显示质量"
}',
'opencv_analysis', 1, NOW(), NOW(), NULL, NULL, NULL);


-- ===================================
-- 2. 创建质控标准（qc_standard）
-- ===================================

INSERT INTO `qc_standard` (`id`, `standard_code`, `standard_name`, `standard_category`, `description`, `pass_score`, `status`, `create_time`, `update_time`) VALUES
('STD_CT_HEAD_ENHANCED', 'STD_CT_HEAD_ENHANCED', '头颅CT增强质控标准', 3, '基于国家医保局要求的头颅CT增强影像质量控制标准（GB 5.4.1.2），包含检查范围、重建参数、窗口技术、增强效果等专项要求',
80, 1, NOW(), NOW());


-- ===================================
-- 3. 关联质控因子到标准（qc_standard_factor）
-- ===================================

-- 删除旧的关联（如果存在）
DELETE FROM qc_standard_factor WHERE standard_id = 'STD_CT_HEAD_ENHANCED';

-- 插入新的关联（权重分配）
-- 头颅CT增强专项因子（权重分配：总计100）
INSERT INTO `qc_standard_factor` (`id`, `standard_id`, `factor_id`, `check_rule`, `weight`, `is_required`, `threshold_value`, `sort_order`, `create_time`, `update_time`, `pass_value`) VALUES
('SF_CT_ENH_1', 'STD_CT_HEAD_ENHANCED', 'CT_HEAD_ENH_5_4_1_2_1', NULL, 10.00, 1, NULL, 1, NOW(), NOW(), '{"passed": true}'),   -- 检查范围
('SF_CT_ENH_2', 'STD_CT_HEAD_ENHANCED', 'CT_HEAD_ENH_5_4_1_2_2', NULL, 8.00, 1, NULL, 2, NOW(), NOW(), '{"result": "normal"}'),  -- 图像偏中心
('SF_CT_ENH_3', 'STD_CT_HEAD_ENHANCED', 'CT_HEAD_ENH_5_4_1_2_3', NULL, 12.00, 1, NULL, 3, NOW(), NOW(), '{"passed": true}'),  -- 重建参数
('SF_CT_ENH_4', 'STD_CT_HEAD_ENHANCED', 'CT_HEAD_ENH_5_4_1_2_4', NULL, 20.00, 1, NULL, 4, NOW(), NOW(), '{"passed": true}'),  -- 窗口技术（否决项）
('SF_CT_ENH_5', 'STD_CT_HEAD_ENHANCED', 'CT_HEAD_ENH_5_4_1_2_5', NULL, 8.00, 1, NULL, 5, NOW(), NOW(), '{"position": "HFS"}'),  -- 扫描体位
('SF_CT_ENH_6', 'STD_CT_HEAD_ENHANCED', 'CT_HEAD_ENH_5_4_1_2_6', NULL, 17.00, 1, NULL, 6, NOW(), NOW(), '{"passed": true}'),  -- 图像标识（否决项）
('SF_CT_ENH_7', 'STD_CT_HEAD_ENHANCED', 'CT_HEAD_ENH_5_4_1_2_7', NULL, 15.00, 1, NULL, 7, NOW(), NOW(), '{"passed": true}'),  -- 图像伪影（否决项）
('SF_CT_ENH_8', 'STD_CT_HEAD_ENHANCED', 'CT_HEAD_ENH_5_4_1_2_8', NULL, 10.00, 1, NULL, 8, NOW(), NOW(), '{"value": {"$gte": 50}}')  -- 图像清晰度


-- ===================================

-- ===================================
-- 验证查询
-- ===================================

-- 查看所有头颅CT平扫质控因子
SELECT
    f.factor_code,
    f.factor_name,
    f.description,
    JSON_EXTRACT(f.check_rule, '$.isVeto') as is_veto,
    JSON_EXTRACT(f.check_rule, '$.method') as check_method
FROM qc_factor f
WHERE f.id LIKE 'CT_5_4_1_1_%' OR f.id LIKE 'BASIC_%'
ORDER BY f.factor_code;

-- 查看头颅CT平扫标准及其关联的因子
SELECT
    s.standard_code,
    s.standard_name,
    s.modality,
    s.body_part,
    s.scan_type,
    f.factor_code,
    f.factor_name,
    sf.weight,
    sf.is_required,
    sf.sort_order
FROM qc_standard s
JOIN qc_standard_factor sf ON s.id = sf.standard_id
JOIN qc_factor f ON sf.factor_id = f.id
WHERE s.id = 'STD_CT_5_4_1_1'
ORDER BY sf.sort_order;

-- 统计信息
SELECT '基础质控因子' as type, COUNT(*) as count FROM qc_factor WHERE id LIKE 'BASIC_%'
UNION ALL
SELECT '头颅CT平扫质控因子', COUNT(*) FROM qc_factor WHERE id LIKE 'CT_5_4_1_1_%'
UNION ALL
SELECT '头颅CT平扫标准-因子关联', COUNT(*) FROM qc_standard_factor WHERE standard_id = 'STD_CT_5_4_1_1';

SET FOREIGN_KEY_CHECKS = 1;

-- ===================================
-- 文件说明
-- ===================================
-- 本文件包含了基础的影像质控因子和头颅CT平扫的完整质控标准
-- 下一步将创建其他CT部位的质控标准（口腔颌面、眼部、鼻咽部、颈部、胸部、腹部、盆腔）
-- 以及MR相关的质控标准