<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.qinan.safetyeval.infrastructure.mapper.QualFilingEquipmentMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="org.qinan.safetyeval.infrastructure.dataobject.QualFilingEquipmentDO">
        <id column="id" property="id"/>
        <result column="filing_id" property="filingId"/>
        <result column="source_equipment_id" property="sourceEquipmentId"/>
        <result column="device_name" property="deviceName"/>
        <result column="device_model" property="deviceModel"/>
        <result column="instrument_type_code" property="instrumentTypeCode"/>
        <result column="instrument_type_name" property="instrumentTypeName"/>
        <result column="device_type_code" property="deviceTypeCode"/>
        <result column="device_type_name" property="deviceTypeName"/>
        <result column="manufacturer" property="manufacturer"/>
        <result column="flow_desc" property="flowDesc"/>
        <result column="min_flow" property="minFlow"/>
        <result column="max_flow" property="maxFlow"/>
        <result column="calibration_unit" property="calibrationUnit"/>
        <result column="calibration_init_value" property="calibrationInitValue"/>
        <result column="field_calibration_type_code" property="fieldCalibrationTypeCode"/>
        <result column="field_calibration_type_name" property="fieldCalibrationTypeName"/>
        <result column="dual_channel_flag" property="dualChannelFlag"/>
        <result column="calibration_report_url" property="calibrationReportUrl"/>
        <result column="delete_enum" property="deleteEnum"/>
        <result column="remarks" property="remarks"/>
        <result column="create_name" property="createName"/>
        <result column="update_name" property="updateName"/>
        <result column="tenant_id" property="tenantId"/>
        <result column="org_id" property="orgId"/>
        <result column="version" property="version"/>
        <result column="create_time" property="createTime"/>
        <result column="update_time" property="updateTime"/>
        <result column="create_id" property="createId"/>
        <result column="update_id" property="updateId"/>
        <result column="env" property="env"/>
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        `id`, `filing_id`, `source_equipment_id`, `device_name`, `device_model`, `instrument_type_code`, `instrument_type_name`, `device_type_code`, `device_type_name`, `manufacturer`, `flow_desc`, `min_flow`, `max_flow`, `calibration_unit`, `calibration_init_value`, `field_calibration_type_code`, `field_calibration_type_name`, `dual_channel_flag`, `calibration_report_url`, `delete_enum`, `remarks`, `create_name`, `update_name`, `tenant_id`, `org_id`, `version`, `create_time`, `update_time`, `create_id`, `update_id`, `env`
    </sql>

</mapper>
