<?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.OrgInfoMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="org.qinan.safetyeval.infrastructure.dataobject.OrgInfoDO">
        <id column="id" property="id"/>
        <result column="unit_name" property="unitName"/>
        <result column="credit_code" property="creditCode"/>
        <result column="safety_industry_category_code" property="safetyIndustryCategoryCode"/>
        <result column="safety_industry_category_name" property="safetyIndustryCategoryName"/>
        <result column="district_code" property="districtCode"/>
        <result column="district_name" property="districtName"/>
        <result column="town_street" property="townStreet"/>
        <result column="village_community" property="villageCommunity"/>
        <result column="longitude" property="longitude"/>
        <result column="latitude" property="latitude"/>
        <result column="register_address" property="registerAddress"/>
        <result column="business_address" property="businessAddress"/>
        <result column="ownership_type_code" property="ownershipTypeCode"/>
        <result column="ownership_type_name" property="ownershipTypeName"/>
        <result column="legal_representative" property="legalRepresentative"/>
        <result column="legal_representative_phone" property="legalRepresentativePhone"/>
        <result column="principal_name" property="principalName"/>
        <result column="principal_phone" property="principalPhone"/>
        <result column="safety_dept_manager" property="safetyDeptManager"/>
        <result column="safety_dept_manager_phone" property="safetyDeptManagerPhone"/>
        <result column="safety_deputy_phone" property="safetyDeputyPhone"/>
        <result column="production_date" property="productionDate"/>
        <result column="business_status_code" property="businessStatusCode"/>
        <result column="business_status_name" property="businessStatusName"/>
        <result column="info_disclosure_url" property="infoDisclosureUrl"/>
        <result column="workplace_area" property="workplaceArea"/>
        <result column="archive_room_area" property="archiveRoomArea"/>
        <result column="fulltime_evaluator_count" property="fulltimeEvaluatorCount"/>
        <result column="registered_engineer_count" property="registeredEngineerCount"/>
        <result column="economy_industry_code" property="economyIndustryCode"/>
        <result column="economy_industry_name" property="economyIndustryName"/>
        <result column="auth_status_code" property="authStatusCode"/>
        <result column="auth_status_name" property="authStatusName"/>
        <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`, `unit_name`, `credit_code`, `safety_industry_category_code`, `safety_industry_category_name`, `district_code`, `district_name`, `town_street`, `village_community`, `longitude`, `latitude`, `register_address`, `business_address`, `ownership_type_code`, `ownership_type_name`, `legal_representative`, `legal_representative_phone`, `principal_name`, `principal_phone`, `safety_dept_manager`, `safety_dept_manager_phone`, `safety_deputy_phone`, `production_date`, `business_status_code`, `business_status_name`, `info_disclosure_url`, `workplace_area`, `archive_room_area`, `fulltime_evaluator_count`, `registered_engineer_count`, `economy_industry_code`, `economy_industry_name`, `auth_status_code`, `auth_status_name`, `delete_enum`, `remarks`, `create_name`, `update_name`, `tenant_id`, `org_id`, `version`, `create_time`, `update_time`, `create_id`, `update_id`, `env`
    </sql>

</mapper>
