{
  "title": "归集行业信息-优化配置-其他信息变更",
  "groupId": "cdc-gathering-reader-db-others-1",
  "batchSize": 500,
  "batchIntervalMs": 2000,
  "regionPrefix": 1405,
  "kafkaConnections": [
    {
      "name": "kafka-collection",
      "bootstrapServer": "117.78.39.204:9092"
    }
  ],
  "jdbcConnections": [
    {
      "name": "industryInfoCollection-jdbc",
      "url": "jdbc:mysql://localhost:3306/obpm2?characterEncoding=UTF-8&serverTimezone=GMT%2B8&allowMultiQueries=true&autoReconnect=true",
      "userName": "root",
      "password": "root",
      "driverClassName": "com.mysql.cj.jdbc.Driver"
    }
  ],
  "topicSubscribers": [
    {
      "uid": "company_tenant_organizations_topic_jc01",
      "topic": "obpm2.binlog-cdc.topic.v2.tenant_organizations",
      "refKafkaName": "kafka-collection",
      "subscriberContents": [
        {
          "uid": "company_tenant_organizations_jc01",
          "title": "同步企业信息-tenant_organizations",
          "refJdbcName": "industryInfoCollection-jdbc",
          "type": "JDBC",
          "content": "insert into obpm2.tenant_organizations(`id`,`approved_information_last_updated_time`,`approved_information_note`,`approved_information_status`,`code`,`created_time`,`industry_code`,`institutional_code`,`last_updated_time`,`logo_path`,`name`,`place_of_business_address`,`place_of_business_city_code`,`place_of_business_city_name`,`place_of_business_district_code`,`place_of_business_district_name`,`place_of_business_province_code`,`place_of_business_province_name`,`place_of_register_address`,`place_of_register_city_code`,`place_of_register_city_name`,`place_of_register_district_code`,`place_of_register_district_name`,`place_of_register_province_code`,`place_of_register_province_name`,`tenant_user_id`,`description`,`latitude`,`longitude`,`sys_name`,`lon_lat_json`,`status`,`fax`,`telephone`,`type`,`industry_detail_type`,`supervise_region_code`,`supervise_depart_id`,`supervise_depart_name`,`competent_unit_region_code`,`competent_unit_code`,`share_organization_id`,`share_organization_name`,`share_employee_id`,`share_employee_name`,`level`,`level_changed_time`) VALUES(:after.id,:after.approved_information_last_updated_time,:after.approved_information_note,:after.approved_information_status,:after.code,:after.created_time,:after.industry_code,:after.institutional_code,:after.last_updated_time,:after.logo_path,:after.name,:after.place_of_business_address,:after.place_of_business_city_code,:after.place_of_business_city_name,:after.place_of_business_district_code,:after.place_of_business_district_name,:after.place_of_business_province_code,:after.place_of_business_province_name,:after.place_of_register_address,:after.place_of_register_city_code,:after.place_of_register_city_name,:after.place_of_register_district_code,:after.place_of_register_district_name,:after.place_of_register_province_code,:after.place_of_register_province_name,:after.tenant_user_id,:after.description,:after.latitude,:after.longitude,:after.sys_name,:after.lon_lat_json,:after.status,:after.fax,:after.telephone,:after.type,:after.industry_detail_type,:after.supervise_region_code,:after.supervise_depart_id,:after.supervise_depart_name,:after.competent_unit_region_code,:after.competent_unit_code,:after.share_organization_id,:after.share_organization_name,:after.share_employee_id,:after.share_employee_name,:after.level,:after.level_changed_time) ON DUPLICATE KEY UPDATE `approved_information_last_updated_time` = VALUES(`approved_information_last_updated_time`),`approved_information_note` = VALUES(`approved_information_note`),`approved_information_status` = VALUES(`approved_information_status`),`code` = VALUES(`code`),`created_time` = VALUES(`created_time`),`industry_code` = VALUES(`industry_code`),`institutional_code` = VALUES(`institutional_code`),`last_updated_time` = VALUES(`last_updated_time`),`logo_path` = VALUES(`logo_path`),`name` = VALUES(`name`),`place_of_business_address` = VALUES(`place_of_business_address`),`place_of_business_city_code` = VALUES(`place_of_business_city_code`),`place_of_business_city_name` = VALUES(`place_of_business_city_name`),`place_of_business_district_code` = VALUES(`place_of_business_district_code`),`place_of_business_district_name` = VALUES(`place_of_business_district_name`),`place_of_business_province_code` = VALUES(`place_of_business_province_code`),`place_of_business_province_name` = VALUES(`place_of_business_province_name`),`place_of_register_address` = VALUES(`place_of_register_address`),`place_of_register_city_code` = VALUES(`place_of_register_city_code`),`place_of_register_city_name` = VALUES(`place_of_register_city_name`),`place_of_register_district_code` = VALUES(`place_of_register_district_code`),`place_of_register_district_name` = VALUES(`place_of_register_district_name`),`place_of_register_province_code` = VALUES(`place_of_register_province_code`),`place_of_register_province_name` = VALUES(`place_of_register_province_name`),`tenant_user_id` = VALUES(`tenant_user_id`),`description` = VALUES(`description`),`latitude` = VALUES(`latitude`),`longitude` = VALUES(`longitude`),`sys_name` = VALUES(`sys_name`),`lon_lat_json` = VALUES(`lon_lat_json`),`status` = VALUES(`status`),`fax` = VALUES(`fax`),`telephone` = VALUES(`telephone`),`type` = VALUES(`type`),`industry_detail_type` = VALUES(`industry_detail_type`),`supervise_region_code` = VALUES(`supervise_region_code`),`supervise_depart_id` = VALUES(`supervise_depart_id`),`supervise_depart_name` = VALUES(`supervise_depart_name`),`competent_unit_region_code` = VALUES(`competent_unit_region_code`),`competent_unit_code` = VALUES(`competent_unit_code`),`share_organization_id` = VALUES(`share_organization_id`),`share_organization_name` = VALUES(`share_organization_name`),`share_employee_id` = VALUES(`share_employee_id`),`share_employee_name` = VALUES(`share_employee_name`),`level` = VALUES(`level`),`level_changed_time` = VALUES(`level_changed_time`)"
        }
      ]
    },
    {
      "uid": "company_tenant_companies_topic_jc01",
      "topic": "obpm2.binlog-cdc.topic.v2.tenant_companies",
      "refKafkaName": "kafka-collection",
      "subscriberContents": [
        {
          "uid": "company_tenant_companies_jc01",
          "title": "同步企业信息-tenant_companies",
          "refJdbcName": "industryInfoCollection-jdbc",
          "type": "JDBC",
          "content": "insert into obpm2.tenant_companies(`id`,`unify_social_credit_code`,`unify_social_credit_code_file`,`is_cross`,`parent_name`,`parent_certificate_type`,`parent_certificate_number`,`parent_legal_person_name`,`parent_legal_person_telephone`,`economic_type`,`nature`,`service_scope`,`service_scope_description`,`registered_capital`,`fixed_capital`,`annual_profit_tax`,`annual_sales_volume`,`certificate_type`,`service_permit_number`,`security_approval_number`,`name_of_issuing_authority`,`first_issue_service_permit`,`service_permit_attachment`,`train_content`,`security_preparedness_rating`,`security_armed_rating`,`security_safety_defense_rating`,`is_risk_assessment`,`number_of_security_guards`,`is_public_security_security`,`is_property_enterprise`,`nature_of_self_recruited_units`,`legal_person_name`,`legal_person_telephone`,`legal_person_credential_type`,`legal_person_credential_number`,`legal_person_nationality`,`security_person_name`,`security_person_telephone`,`security_person_credential_type`,`security_person_credential_number`,`create_time`,`last_updated_time`) VALUES(:after.id,:after.unify_social_credit_code,:after.unify_social_credit_code_file,:after.is_cross,:after.parent_name,:after.parent_certificate_type,:after.parent_certificate_number,:after.parent_legal_person_name,:after.parent_legal_person_telephone,:after.economic_type,:after.nature,:after.service_scope,:after.service_scope_description,:after.registered_capital,:after.fixed_capital,:after.annual_profit_tax,:after.annual_sales_volume,:after.certificate_type,:after.service_permit_number,:after.security_approval_number,:after.name_of_issuing_authority,:after.first_issue_service_permit,:after.service_permit_attachment,:after.train_content,:after.security_preparedness_rating,:after.security_armed_rating,:after.security_safety_defense_rating,:after.is_risk_assessment,:after.number_of_security_guards,:after.is_public_security_security,:after.is_property_enterprise,:after.nature_of_self_recruited_units,:after.legal_person_name,:after.legal_person_telephone,:after.legal_person_credential_type,:after.legal_person_credential_number,:after.legal_person_nationality,:after.security_person_name,:after.security_person_telephone,:after.security_person_credential_type,:after.security_person_credential_number,:after.create_time,:after.last_updated_time) ON DUPLICATE KEY UPDATE `unify_social_credit_code` = VALUES(`unify_social_credit_code`),`unify_social_credit_code_file` = VALUES(`unify_social_credit_code_file`),`is_cross` = VALUES(`is_cross`),`parent_name` = VALUES(`parent_name`),`parent_certificate_type` = VALUES(`parent_certificate_type`),`parent_certificate_number` = VALUES(`parent_certificate_number`),`parent_legal_person_name` = VALUES(`parent_legal_person_name`),`parent_legal_person_telephone` = VALUES(`parent_legal_person_telephone`),`economic_type` = VALUES(`economic_type`),`nature` = VALUES(`nature`),`service_scope` = VALUES(`service_scope`),`service_scope_description` = VALUES(`service_scope_description`),`registered_capital` = VALUES(`registered_capital`),`fixed_capital` = VALUES(`fixed_capital`),`annual_profit_tax` = VALUES(`annual_profit_tax`),`annual_sales_volume` = VALUES(`annual_sales_volume`),`certificate_type` = VALUES(`certificate_type`),`service_permit_number` = VALUES(`service_permit_number`),`security_approval_number` = VALUES(`security_approval_number`),`name_of_issuing_authority` = VALUES(`name_of_issuing_authority`),`first_issue_service_permit` = VALUES(`first_issue_service_permit`),`service_permit_attachment` = VALUES(`service_permit_attachment`),`train_content` = VALUES(`train_content`),`security_preparedness_rating` = VALUES(`security_preparedness_rating`),`security_armed_rating` = VALUES(`security_armed_rating`),`security_safety_defense_rating` = VALUES(`security_safety_defense_rating`),`is_risk_assessment` = VALUES(`is_risk_assessment`),`number_of_security_guards` = VALUES(`number_of_security_guards`),`is_public_security_security` = VALUES(`is_public_security_security`),`is_property_enterprise` = VALUES(`is_property_enterprise`),`nature_of_self_recruited_units` = VALUES(`nature_of_self_recruited_units`),`legal_person_name` = VALUES(`legal_person_name`),`legal_person_telephone` = VALUES(`legal_person_telephone`),`legal_person_credential_type` = VALUES(`legal_person_credential_type`),`legal_person_credential_number` = VALUES(`legal_person_credential_number`),`legal_person_nationality` = VALUES(`legal_person_nationality`),`security_person_name` = VALUES(`security_person_name`),`security_person_telephone` = VALUES(`security_person_telephone`),`security_person_credential_type` = VALUES(`security_person_credential_type`),`security_person_credential_number` = VALUES(`security_person_credential_number`),`create_time` = VALUES(`create_time`),`last_updated_time` = VALUES(`last_updated_time`)"
        }
      ]
    },
    {
      "uid":"user_tlk_shareholderinformation_topic_jc01",
      "topic": "baibaodunflow.binlog-cdc.topic.v2.tlk_shareholderinformation",
      "refKafkaName": "kafka-collection",
      "subscriberContents": [
        {
          "uid":"user_tlk_shareholderinformation_jc01",
          "title": "同步股东信息-tlk_shareholderinformation",
          "refJdbcName": "industryInfoCollection-jdbc",
          "type": "JDBC",
          "content": "insert into baibaodunflow.tlk_shareholderinformation(`PARENT`,`LASTMODIFIED`,`FORMNAME`,`STATE`,`AUDITUSER`,`AUDITDATE`,`AUTHOR`,`AUTHOR_DEPT_INDEX`,`CREATED`,`FORMID`,`ISTMP`,`VERSIONS`,`APPLICATIONID`,`STATEINT`,`STATELABEL`,`AUDITORNAMES`,`LASTFLOWOPERATION`,`LASTMODIFIER`,`DOMAINID`,`AUDITORLIST`,`COAUDITORLIST`,`STATELABELINFO`,`PREVAUDITNODE`,`PREVAUDITUSER`,`OPTIONITEM`,`SIGN`,`KINGGRIDSIGNATURE`,`ITEM_SHAREHOLDERTYPE`,`ITEM_SHAREHOLDER`,`ITEM_DOCUMENTTYPE`,`ITEM_DOCUMENTID`,`ITEM_CAPITALCONTRIBUTION`,`ITEM_STOCKPROPORTION`,`ITEM_ADDRESS`,`ITEM_SEX`,`ITEM_NATIONALITY`,`ITEM_NATION`,`ITEM_HOUSEHOLD`,`ID`,`ITEM_DOMAIN_ID`,`ITEM_TOPID`,`AUTHORDEPTID`,`AUTHOR_USER_INDEX`,`SUBFORMIDS`,`INITIATOR`,`ITEM_TELEPHONE`,`ITEM_IS_DELETE`) VALUES(:after.PARENT,:after.LASTMODIFIED,:after.FORMNAME,:after.STATE,:after.AUDITUSER,:after.AUDITDATE,:after.AUTHOR,:after.AUTHOR_DEPT_INDEX,:after.CREATED,:after.FORMID,:after.ISTMP,:after.VERSIONS,:after.APPLICATIONID,:after.STATEINT,:after.STATELABEL,:after.AUDITORNAMES,:after.LASTFLOWOPERATION,:after.LASTMODIFIER,:after.DOMAINID,:after.AUDITORLIST,:after.COAUDITORLIST,:after.STATELABELINFO,:after.PREVAUDITNODE,:after.PREVAUDITUSER,:after.OPTIONITEM,:after.SIGN,:after.KINGGRIDSIGNATURE,:after.ITEM_SHAREHOLDERTYPE,:after.ITEM_SHAREHOLDER,:after.ITEM_DOCUMENTTYPE,:after.ITEM_DOCUMENTID,:after.ITEM_CAPITALCONTRIBUTION,:after.ITEM_STOCKPROPORTION,:after.ITEM_ADDRESS,:after.ITEM_SEX,:after.ITEM_NATIONALITY,:after.ITEM_NATION,:after.ITEM_HOUSEHOLD,:after.ID,:after.ITEM_DOMAIN_ID,:after.ITEM_TOPID,:after.AUTHORDEPTID,:after.AUTHOR_USER_INDEX,:after.SUBFORMIDS,:after.INITIATOR,:after.ITEM_TELEPHONE,:after.ITEM_IS_DELETE) ON DUPLICATE KEY UPDATE `PARENT` = VALUES(`PARENT`),`LASTMODIFIED` = VALUES(`LASTMODIFIED`),`FORMNAME` = VALUES(`FORMNAME`),`STATE` = VALUES(`STATE`),`AUDITUSER` = VALUES(`AUDITUSER`),`AUDITDATE` = VALUES(`AUDITDATE`),`AUTHOR` = VALUES(`AUTHOR`),`AUTHOR_DEPT_INDEX` = VALUES(`AUTHOR_DEPT_INDEX`),`CREATED` = VALUES(`CREATED`),`FORMID` = VALUES(`FORMID`),`ISTMP` = VALUES(`ISTMP`),`VERSIONS` = VALUES(`VERSIONS`),`APPLICATIONID` = VALUES(`APPLICATIONID`),`STATEINT` = VALUES(`STATEINT`),`STATELABEL` = VALUES(`STATELABEL`),`AUDITORNAMES` = VALUES(`AUDITORNAMES`),`LASTFLOWOPERATION` = VALUES(`LASTFLOWOPERATION`),`LASTMODIFIER` = VALUES(`LASTMODIFIER`),`DOMAINID` = VALUES(`DOMAINID`),`AUDITORLIST` = VALUES(`AUDITORLIST`),`COAUDITORLIST` = VALUES(`COAUDITORLIST`),`STATELABELINFO` = VALUES(`STATELABELINFO`),`PREVAUDITNODE` = VALUES(`PREVAUDITNODE`),`PREVAUDITUSER` = VALUES(`PREVAUDITUSER`),`OPTIONITEM` = VALUES(`OPTIONITEM`),`SIGN` = VALUES(`SIGN`),`KINGGRIDSIGNATURE` = VALUES(`KINGGRIDSIGNATURE`),`ITEM_SHAREHOLDERTYPE` = VALUES(`ITEM_SHAREHOLDERTYPE`),`ITEM_SHAREHOLDER` = VALUES(`ITEM_SHAREHOLDER`),`ITEM_DOCUMENTTYPE` = VALUES(`ITEM_DOCUMENTTYPE`),`ITEM_DOCUMENTID` = VALUES(`ITEM_DOCUMENTID`),`ITEM_CAPITALCONTRIBUTION` = VALUES(`ITEM_CAPITALCONTRIBUTION`),`ITEM_STOCKPROPORTION` = VALUES(`ITEM_STOCKPROPORTION`),`ITEM_ADDRESS` = VALUES(`ITEM_ADDRESS`),`ITEM_SEX` = VALUES(`ITEM_SEX`),`ITEM_NATIONALITY` = VALUES(`ITEM_NATIONALITY`),`ITEM_NATION` = VALUES(`ITEM_NATION`),`ITEM_HOUSEHOLD` = VALUES(`ITEM_HOUSEHOLD`),`ITEM_DOMAIN_ID` = VALUES(`ITEM_DOMAIN_ID`),`ITEM_TOPID` = VALUES(`ITEM_TOPID`),`AUTHORDEPTID` = VALUES(`AUTHORDEPTID`),`AUTHOR_USER_INDEX` = VALUES(`AUTHOR_USER_INDEX`),`SUBFORMIDS` = VALUES(`SUBFORMIDS`),`INITIATOR` = VALUES(`INITIATOR`),`ITEM_TELEPHONE` = VALUES(`ITEM_TELEPHONE`),`ITEM_IS_DELETE` = VALUES(`ITEM_IS_DELETE`)"
        }
      ]
    },
    {
      "uid":"user_tlk_managementlayer_topic_jc01",
      "topic": "baibaodunflow.binlog-cdc.topic.v2.tlk_managementlayer",
      "refKafkaName": "kafka-collection",
      "subscriberContents": [
        {
          "uid":"user_tlk_managementlayer_jc01",
          "title": "同步管理层信息-tlk_managementlayer",
          "refJdbcName": "industryInfoCollection-jdbc",
          "type": "JDBC",
          "content": "insert into baibaodunflow.tlk_managementlayer(`PARENT`,`LASTMODIFIED`,`FORMNAME`,`STATE`,`AUDITUSER`,`AUDITDATE`,`AUTHOR`,`AUTHOR_DEPT_INDEX`,`CREATED`,`FORMID`,`ISTMP`,`VERSIONS`,`APPLICATIONID`,`STATEINT`,`STATELABEL`,`AUDITORNAMES`,`LASTFLOWOPERATION`,`LASTMODIFIER`,`DOMAINID`,`AUDITORLIST`,`COAUDITORLIST`,`STATELABELINFO`,`PREVAUDITNODE`,`PREVAUDITUSER`,`OPTIONITEM`,`SIGN`,`KINGGRIDSIGNATURE`,`ITEM_NAME`,`ITEM_DOCUMENTTYPE`,`ITEM_DOCUMENTID`,`ITEM_SEX`,`ITEM_JOBTYPE`,`ID`,`ITEM_ISVETERAN`,`ITEM_NATION`,`ITEM_HOUSEHOLD`,`ITEM_EDUCATION`,`ITEM_SKILLLEVEL`,`ITEM_PHONE`,`ITEM_ADDRESS`,`ITEM_DOMAIN_ID`,`ITEM_TOPID`,`ITEM_DEPTID`,`ITEM_DEPTNAME`,`ITEM_DEPARTMENT`,`ITEM_DEPARTMENTNAME`,`AUTHORDEPTID`,`AUTHOR_USER_INDEX`,`SUBFORMIDS`,`INITIATOR`,`ITEM_USERTOLIST`,`ITEM_ID`,`ITEM_JOBTYPEDETAIL`,`ITEM_IS_DELETE`) VALUES(:after.PARENT,:after.LASTMODIFIED,:after.FORMNAME,:after.STATE,:after.AUDITUSER,:after.AUDITDATE,:after.AUTHOR,:after.AUTHOR_DEPT_INDEX,:after.CREATED,:after.FORMID,:after.ISTMP,:after.VERSIONS,:after.APPLICATIONID,:after.STATEINT,:after.STATELABEL,:after.AUDITORNAMES,:after.LASTFLOWOPERATION,:after.LASTMODIFIER,:after.DOMAINID,:after.AUDITORLIST,:after.COAUDITORLIST,:after.STATELABELINFO,:after.PREVAUDITNODE,:after.PREVAUDITUSER,:after.OPTIONITEM,:after.SIGN,:after.KINGGRIDSIGNATURE,:after.ITEM_NAME,:after.ITEM_DOCUMENTTYPE,:after.ITEM_DOCUMENTID,:after.ITEM_SEX,:after.ITEM_JOBTYPE,:after.ID,:after.ITEM_ISVETERAN,:after.ITEM_NATION,:after.ITEM_HOUSEHOLD,:after.ITEM_EDUCATION,:after.ITEM_SKILLLEVEL,:after.ITEM_PHONE,:after.ITEM_ADDRESS,:after.ITEM_DOMAIN_ID,:after.ITEM_TOPID,:after.ITEM_DEPTID,:after.ITEM_DEPTNAME,:after.ITEM_DEPARTMENT,:after.ITEM_DEPARTMENTNAME,:after.AUTHORDEPTID,:after.AUTHOR_USER_INDEX,:after.SUBFORMIDS,:after.INITIATOR,:after.ITEM_USERTOLIST,:after.ITEM_ID,:after.ITEM_JOBTYPEDETAIL,:after.ITEM_IS_DELETE) ON DUPLICATE KEY UPDATE `PARENT` = VALUES(`PARENT`),`LASTMODIFIED` = VALUES(`LASTMODIFIED`),`FORMNAME` = VALUES(`FORMNAME`),`STATE` = VALUES(`STATE`),`AUDITUSER` = VALUES(`AUDITUSER`),`AUDITDATE` = VALUES(`AUDITDATE`),`AUTHOR` = VALUES(`AUTHOR`),`AUTHOR_DEPT_INDEX` = VALUES(`AUTHOR_DEPT_INDEX`),`CREATED` = VALUES(`CREATED`),`FORMID` = VALUES(`FORMID`),`ISTMP` = VALUES(`ISTMP`),`VERSIONS` = VALUES(`VERSIONS`),`APPLICATIONID` = VALUES(`APPLICATIONID`),`STATEINT` = VALUES(`STATEINT`),`STATELABEL` = VALUES(`STATELABEL`),`AUDITORNAMES` = VALUES(`AUDITORNAMES`),`LASTFLOWOPERATION` = VALUES(`LASTFLOWOPERATION`),`LASTMODIFIER` = VALUES(`LASTMODIFIER`),`DOMAINID` = VALUES(`DOMAINID`),`AUDITORLIST` = VALUES(`AUDITORLIST`),`COAUDITORLIST` = VALUES(`COAUDITORLIST`),`STATELABELINFO` = VALUES(`STATELABELINFO`),`PREVAUDITNODE` = VALUES(`PREVAUDITNODE`),`PREVAUDITUSER` = VALUES(`PREVAUDITUSER`),`OPTIONITEM` = VALUES(`OPTIONITEM`),`SIGN` = VALUES(`SIGN`),`KINGGRIDSIGNATURE` = VALUES(`KINGGRIDSIGNATURE`),`ITEM_NAME` = VALUES(`ITEM_NAME`),`ITEM_DOCUMENTTYPE` = VALUES(`ITEM_DOCUMENTTYPE`),`ITEM_DOCUMENTID` = VALUES(`ITEM_DOCUMENTID`),`ITEM_SEX` = VALUES(`ITEM_SEX`),`ITEM_JOBTYPE` = VALUES(`ITEM_JOBTYPE`),`ITEM_ISVETERAN` = VALUES(`ITEM_ISVETERAN`),`ITEM_NATION` = VALUES(`ITEM_NATION`),`ITEM_HOUSEHOLD` = VALUES(`ITEM_HOUSEHOLD`),`ITEM_EDUCATION` = VALUES(`ITEM_EDUCATION`),`ITEM_SKILLLEVEL` = VALUES(`ITEM_SKILLLEVEL`),`ITEM_PHONE` = VALUES(`ITEM_PHONE`),`ITEM_ADDRESS` = VALUES(`ITEM_ADDRESS`),`ITEM_DOMAIN_ID` = VALUES(`ITEM_DOMAIN_ID`),`ITEM_TOPID` = VALUES(`ITEM_TOPID`),`ITEM_DEPTID` = VALUES(`ITEM_DEPTID`),`ITEM_DEPTNAME` = VALUES(`ITEM_DEPTNAME`),`ITEM_DEPARTMENT` = VALUES(`ITEM_DEPARTMENT`),`ITEM_DEPARTMENTNAME` = VALUES(`ITEM_DEPARTMENTNAME`),`AUTHORDEPTID` = VALUES(`AUTHORDEPTID`),`AUTHOR_USER_INDEX` = VALUES(`AUTHOR_USER_INDEX`),`SUBFORMIDS` = VALUES(`SUBFORMIDS`),`INITIATOR` = VALUES(`INITIATOR`),`ITEM_USERTOLIST` = VALUES(`ITEM_USERTOLIST`),`ITEM_ID` = VALUES(`ITEM_ID`),`ITEM_JOBTYPEDETAIL` = VALUES(`ITEM_JOBTYPEDETAIL`),`ITEM_IS_DELETE` = VALUES(`ITEM_IS_DELETE`)"
        }
      ]
    },
    {
      "uid": "company_tlk_subcompanyinformation_topic_jc01",
      "topic": "baibaodunflow.binlog-cdc.topic.v2.tlk_subcompanyinformation",
      "refKafkaName": "kafka-collection",
      "subscriberContents": [
        {
          "uid": "company_tlk_subcompanyinformation_jc01",
          "title": "同步分子公司信息-tlk_subcompanyinformation",
          "refJdbcName": "industryInfoCollection-jdbc",
          "type": "JDBC",
          "content": "insert into baibaodunflow.tlk_subcompanyinformation(`PARENT`,`LASTMODIFIED`,`FORMNAME`,`STATE`,`AUDITUSER`,`AUDITDATE`,`AUTHOR`,`AUTHORDEPTID`,`AUTHOR_DEPT_INDEX`,`AUTHOR_USER_INDEX`,`CREATED`,`FORMID`,`SUBFORMIDS`,`INITIATOR`,`ISTMP`,`VERSIONS`,`APPLICATIONID`,`STATEINT`,`STATELABEL`,`AUDITORNAMES`,`LASTFLOWOPERATION`,`LASTMODIFIER`,`DOMAINID`,`AUDITORLIST`,`COAUDITORLIST`,`STATELABELINFO`,`PREVAUDITNODE`,`PREVAUDITUSER`,`OPTIONITEM`,`SIGN`,`KINGGRIDSIGNATURE`,`ITEM_COMPANY_NAME`,`ITEM_COMPANY_TYPE`,`ITEM_SUPERVISORY_ADDRESS`,`ID`,`ITEM_SUPERVISORY_ID`,`ITEM_FOUNDATION_DATE`,`ITEM_TELEPHONE`,`ITEM_LEGALPERSON`,`ITEM_DOCUMENT_TYPE`,`ITEM_DOCUMENT_ID`,`ITEM_LEGAL_TELEPHONE`,`ITEM_SECURITY_NUM`,`ITEM_REGISTER_ADDRESS`,`ITEM_REGISTER_ID`,`ITEM_REGISTER_ADDRESS_DETAIL`,`ITEM_BUSINESS_ADDRESS`,`ITEM_BUSINESS_ID`,`ITEM_BUSINESS_ADDRESS_DETAIL`,`ITEM_IS_DELETE`) VALUES(:after.PARENT,:after.LASTMODIFIED,:after.FORMNAME,:after.STATE,:after.AUDITUSER,:after.AUDITDATE,:after.AUTHOR,:after.AUTHORDEPTID,:after.AUTHOR_DEPT_INDEX,:after.AUTHOR_USER_INDEX,:after.CREATED,:after.FORMID,:after.SUBFORMIDS,:after.INITIATOR,:after.ISTMP,:after.VERSIONS,:after.APPLICATIONID,:after.STATEINT,:after.STATELABEL,:after.AUDITORNAMES,:after.LASTFLOWOPERATION,:after.LASTMODIFIER,:after.DOMAINID,:after.AUDITORLIST,:after.COAUDITORLIST,:after.STATELABELINFO,:after.PREVAUDITNODE,:after.PREVAUDITUSER,:after.OPTIONITEM,:after.SIGN,:after.KINGGRIDSIGNATURE,:after.ITEM_COMPANY_NAME,:after.ITEM_COMPANY_TYPE,:after.ITEM_SUPERVISORY_ADDRESS,:after.ID,:after.ITEM_SUPERVISORY_ID,:after.ITEM_FOUNDATION_DATE,:after.ITEM_TELEPHONE,:after.ITEM_LEGALPERSON,:after.ITEM_DOCUMENT_TYPE,:after.ITEM_DOCUMENT_ID,:after.ITEM_LEGAL_TELEPHONE,:after.ITEM_SECURITY_NUM,:after.ITEM_REGISTER_ADDRESS,:after.ITEM_REGISTER_ID,:after.ITEM_REGISTER_ADDRESS_DETAIL,:after.ITEM_BUSINESS_ADDRESS,:after.ITEM_BUSINESS_ID,:after.ITEM_BUSINESS_ADDRESS_DETAIL,:after.ITEM_IS_DELETE) ON DUPLICATE KEY UPDATE `PARENT` = VALUES(`PARENT`),`LASTMODIFIED` = VALUES(`LASTMODIFIED`),`FORMNAME` = VALUES(`FORMNAME`),`STATE` = VALUES(`STATE`),`AUDITUSER` = VALUES(`AUDITUSER`),`AUDITDATE` = VALUES(`AUDITDATE`),`AUTHOR` = VALUES(`AUTHOR`),`AUTHORDEPTID` = VALUES(`AUTHORDEPTID`),`AUTHOR_DEPT_INDEX` = VALUES(`AUTHOR_DEPT_INDEX`),`AUTHOR_USER_INDEX` = VALUES(`AUTHOR_USER_INDEX`),`CREATED` = VALUES(`CREATED`),`FORMID` = VALUES(`FORMID`),`SUBFORMIDS` = VALUES(`SUBFORMIDS`),`INITIATOR` = VALUES(`INITIATOR`),`ISTMP` = VALUES(`ISTMP`),`VERSIONS` = VALUES(`VERSIONS`),`APPLICATIONID` = VALUES(`APPLICATIONID`),`STATEINT` = VALUES(`STATEINT`),`STATELABEL` = VALUES(`STATELABEL`),`AUDITORNAMES` = VALUES(`AUDITORNAMES`),`LASTFLOWOPERATION` = VALUES(`LASTFLOWOPERATION`),`LASTMODIFIER` = VALUES(`LASTMODIFIER`),`DOMAINID` = VALUES(`DOMAINID`),`AUDITORLIST` = VALUES(`AUDITORLIST`),`COAUDITORLIST` = VALUES(`COAUDITORLIST`),`STATELABELINFO` = VALUES(`STATELABELINFO`),`PREVAUDITNODE` = VALUES(`PREVAUDITNODE`),`PREVAUDITUSER` = VALUES(`PREVAUDITUSER`),`OPTIONITEM` = VALUES(`OPTIONITEM`),`SIGN` = VALUES(`SIGN`),`KINGGRIDSIGNATURE` = VALUES(`KINGGRIDSIGNATURE`),`ITEM_COMPANY_NAME` = VALUES(`ITEM_COMPANY_NAME`),`ITEM_COMPANY_TYPE` = VALUES(`ITEM_COMPANY_TYPE`),`ITEM_SUPERVISORY_ADDRESS` = VALUES(`ITEM_SUPERVISORY_ADDRESS`),`ITEM_SUPERVISORY_ID` = VALUES(`ITEM_SUPERVISORY_ID`),`ITEM_FOUNDATION_DATE` = VALUES(`ITEM_FOUNDATION_DATE`),`ITEM_TELEPHONE` = VALUES(`ITEM_TELEPHONE`),`ITEM_LEGALPERSON` = VALUES(`ITEM_LEGALPERSON`),`ITEM_DOCUMENT_TYPE` = VALUES(`ITEM_DOCUMENT_TYPE`),`ITEM_DOCUMENT_ID` = VALUES(`ITEM_DOCUMENT_ID`),`ITEM_LEGAL_TELEPHONE` = VALUES(`ITEM_LEGAL_TELEPHONE`),`ITEM_SECURITY_NUM` = VALUES(`ITEM_SECURITY_NUM`),`ITEM_REGISTER_ADDRESS` = VALUES(`ITEM_REGISTER_ADDRESS`),`ITEM_REGISTER_ID` = VALUES(`ITEM_REGISTER_ID`),`ITEM_REGISTER_ADDRESS_DETAIL` = VALUES(`ITEM_REGISTER_ADDRESS_DETAIL`),`ITEM_BUSINESS_ADDRESS` = VALUES(`ITEM_BUSINESS_ADDRESS`),`ITEM_BUSINESS_ID` = VALUES(`ITEM_BUSINESS_ID`),`ITEM_BUSINESS_ADDRESS_DETAIL` = VALUES(`ITEM_BUSINESS_ADDRESS_DETAIL`),`ITEM_IS_DELETE` = VALUES(`ITEM_IS_DELETE`)"
        }
      ]
    },
    {
      "uid": "company_tlk_overseasoperation_topic_jc01",
      "topic": "baibaodunflow.binlog-cdc.topic.v2.tlk_overseasoperation",
      "refKafkaName": "kafka-collection",
      "subscriberContents": [
        {
          "uid": "company_tlk_overseasoperation_jc01",
          "title": "同步企业海外经营信息-tlk_overseasoperation",
          "refJdbcName": "industryInfoCollection-jdbc",
          "type": "JDBC",
          "content": "insert into baibaodunflow.tlk_overseasoperation(`PARENT`,`LASTMODIFIED`,`FORMNAME`,`STATE`,`AUDITUSER`,`AUDITDATE`,`AUTHOR`,`AUTHOR_DEPT_INDEX`,`CREATED`,`FORMID`,`ISTMP`,`VERSIONS`,`APPLICATIONID`,`STATEINT`,`STATELABEL`,`AUDITORNAMES`,`LASTFLOWOPERATION`,`LASTMODIFIER`,`DOMAINID`,`AUDITORLIST`,`COAUDITORLIST`,`STATELABELINFO`,`PREVAUDITNODE`,`PREVAUDITUSER`,`OPTIONITEM`,`SIGN`,`KINGGRIDSIGNATURE`,`ITEM_NATIONALITY`,`ITEM_OPERATIONTYPE`,`ITEM_RECORDPOLIC`,`ITEM_RECORDDATE`,`ITEM_STARTDATE`,`ITEM_ENDDATE`,`ITEM_BUSINESSSCOPE`,`ID`,`ITEM_DOMAIN_ID`,`ITEM_COMPANYNAME`,`AUTHORDEPTID`,`AUTHOR_USER_INDEX`,`SUBFORMIDS`,`INITIATOR`,`ITEM_IS_DELETE`) VALUES(:after.PARENT,:after.LASTMODIFIED,:after.FORMNAME,:after.STATE,:after.AUDITUSER,:after.AUDITDATE,:after.AUTHOR,:after.AUTHOR_DEPT_INDEX,:after.CREATED,:after.FORMID,:after.ISTMP,:after.VERSIONS,:after.APPLICATIONID,:after.STATEINT,:after.STATELABEL,:after.AUDITORNAMES,:after.LASTFLOWOPERATION,:after.LASTMODIFIER,:after.DOMAINID,:after.AUDITORLIST,:after.COAUDITORLIST,:after.STATELABELINFO,:after.PREVAUDITNODE,:after.PREVAUDITUSER,:after.OPTIONITEM,:after.SIGN,:after.KINGGRIDSIGNATURE,:after.ITEM_NATIONALITY,:after.ITEM_OPERATIONTYPE,:after.ITEM_RECORDPOLIC,:after.ITEM_RECORDDATE,:after.ITEM_STARTDATE,:after.ITEM_ENDDATE,:after.ITEM_BUSINESSSCOPE,:after.ID,:after.ITEM_DOMAIN_ID,:after.ITEM_COMPANYNAME,:after.AUTHORDEPTID,:after.AUTHOR_USER_INDEX,:after.SUBFORMIDS,:after.INITIATOR,:after.ITEM_IS_DELETE) ON DUPLICATE KEY UPDATE `PARENT` = VALUES(`PARENT`),`LASTMODIFIED` = VALUES(`LASTMODIFIED`),`FORMNAME` = VALUES(`FORMNAME`),`STATE` = VALUES(`STATE`),`AUDITUSER` = VALUES(`AUDITUSER`),`AUDITDATE` = VALUES(`AUDITDATE`),`AUTHOR` = VALUES(`AUTHOR`),`AUTHOR_DEPT_INDEX` = VALUES(`AUTHOR_DEPT_INDEX`),`CREATED` = VALUES(`CREATED`),`FORMID` = VALUES(`FORMID`),`ISTMP` = VALUES(`ISTMP`),`VERSIONS` = VALUES(`VERSIONS`),`APPLICATIONID` = VALUES(`APPLICATIONID`),`STATEINT` = VALUES(`STATEINT`),`STATELABEL` = VALUES(`STATELABEL`),`AUDITORNAMES` = VALUES(`AUDITORNAMES`),`LASTFLOWOPERATION` = VALUES(`LASTFLOWOPERATION`),`LASTMODIFIER` = VALUES(`LASTMODIFIER`),`DOMAINID` = VALUES(`DOMAINID`),`AUDITORLIST` = VALUES(`AUDITORLIST`),`COAUDITORLIST` = VALUES(`COAUDITORLIST`),`STATELABELINFO` = VALUES(`STATELABELINFO`),`PREVAUDITNODE` = VALUES(`PREVAUDITNODE`),`PREVAUDITUSER` = VALUES(`PREVAUDITUSER`),`OPTIONITEM` = VALUES(`OPTIONITEM`),`SIGN` = VALUES(`SIGN`),`KINGGRIDSIGNATURE` = VALUES(`KINGGRIDSIGNATURE`),`ITEM_NATIONALITY` = VALUES(`ITEM_NATIONALITY`),`ITEM_OPERATIONTYPE` = VALUES(`ITEM_OPERATIONTYPE`),`ITEM_RECORDPOLIC` = VALUES(`ITEM_RECORDPOLIC`),`ITEM_RECORDDATE` = VALUES(`ITEM_RECORDDATE`),`ITEM_STARTDATE` = VALUES(`ITEM_STARTDATE`),`ITEM_ENDDATE` = VALUES(`ITEM_ENDDATE`),`ITEM_BUSINESSSCOPE` = VALUES(`ITEM_BUSINESSSCOPE`),`ITEM_DOMAIN_ID` = VALUES(`ITEM_DOMAIN_ID`),`ITEM_COMPANYNAME` = VALUES(`ITEM_COMPANYNAME`),`AUTHORDEPTID` = VALUES(`AUTHORDEPTID`),`AUTHOR_USER_INDEX` = VALUES(`AUTHOR_USER_INDEX`),`SUBFORMIDS` = VALUES(`SUBFORMIDS`),`INITIATOR` = VALUES(`INITIATOR`),`ITEM_IS_DELETE` = VALUES(`ITEM_IS_DELETE`)"
        }
      ]
    },
    {
      "uid": "company_tlk_companyinformation_topic_jc01",
      "topic": "baibaodunflow.binlog-cdc.topic.v2.tlk_companyinformation",
      "refKafkaName": "kafka-collection",
      "subscriberContents": [
        {
          "uid": "company_tlk_companyinformation_jc01",
          "title": "同步从业单位信息-tlk_companyinformation",
          "refJdbcName": "industryInfoCollection-jdbc",
          "type": "JDBC",
          "content": "insert into baibaodunflow.tlk_companyinformation(`PARENT`,`LASTMODIFIED`,`FORMNAME`,`STATE`,`AUDITUSER`,`AUDITDATE`,`AUTHOR`,`AUTHOR_DEPT_INDEX`,`CREATED`,`FORMID`,`ISTMP`,`VERSIONS`,`APPLICATIONID`,`STATEINT`,`STATELABEL`,`AUDITORNAMES`,`LASTFLOWOPERATION`,`LASTMODIFIER`,`DOMAINID`,`AUDITORLIST`,`COAUDITORLIST`,`STATELABELINFO`,`PREVAUDITNODE`,`PREVAUDITUSER`,`OPTIONITEM`,`SIGN`,`KINGGRIDSIGNATURE`,`ITEM_companyName`,`ITEM_registerAddress`,`ITEM_registerAddressDetail`,`ITEM_officeAddress`,`ITEM_officeAddressDetail`,`ITEM_companyPhone`,`ITEM_companyFax`,`ITEM_economicType`,`ITEM_companyType`,`ID`,`ITEM_isSub`,`ITEM_groupName`,`ITEM_groupDocumentType`,`ITEM_groupDocumentNO`,`ITEM_groupLegalPerson`,`ITEM_groupPhone`,`ITEM_legalPerson`,`ITEM_documentType`,`ITEM_documentID`,`ITEM_nationality`,`ITEM_legalPersonPhone`,`ITEM_registeredCapital`,`ITEM_fixedAssets`,`ITEM_annuaTurnover`,`ITEM_profitTaxes`,`ITEM_registerDocumentType`,`ITEM_registerID`,`ITEM_registerPhoto`,`ITEM_officeType`,`ITEM_securityServicePermitNo`,`ITEM_securityServicePhoto`,`ITEM_issuingSecurityService`,`ITEM_issueServiceDate`,`ITEM_businessScope`,`ITEM_HRLevel`,`ITEM_armedEscortLevel`,`ITEM_securityPrecautions`,`ITEM_isRiskAssessment`,`ITEM_securityTrainPermitNo`,`ITEM_securityTrainPhoto`,`ITEM_issuingTrainPermit`,`ITEM_issueTrainDate`,`ITEM_trainScope`,`ITEM_SecurityNums`,`ITEM_securityGroupLevel`,`ITEM_domain_id`,`ITEM_companyStatus`,`ITEM_systemAdmin`,`ITEM_securityType`,`ITEM_isInvoivingPlaces`,`ITEM_isKeyProtectionUnits`,`ITEM_saas_organId`,`ITEM_saas_LearnId`,`AUTHORDEPTID`,`AUTHOR_USER_INDEX`,`SUBFORMIDS`,`INITIATOR`,`ITEM_securityServicePermitN`,`ITEM_companycode`,`ITEM_yin01`,`ITEM_yin02`,`ITEM_yin03`,`ITEM_yin04`,`ITEM_attendanceSiteType`,`item_inmycompanyNums`,`item_stationNum`,`item_securityTeacherNum`,`item_shareholderNum`,`ITEM_place_of_register_province_code`,`ITEM_place_of_business_province_code`,`ITEM_place_of_register_city_code`,`ITEM_place_of_business_city_code`,`ITEM_place_of_register_district_code`,`ITEM_place_of_business_district_code`,`ITEM_sec_manager`,`ITEM_sec_manager_phone`,`ITEM_sec_manager_id`,`ITEM_sec_manager_doc_type`,`ITEM_approval_number`,`ITEM_is_property`,`ITEM_showTips`) VALUES(:after.PARENT,:after.LASTMODIFIED,:after.FORMNAME,:after.STATE,:after.AUDITUSER,:after.AUDITDATE,:after.AUTHOR,:after.AUTHOR_DEPT_INDEX,:after.CREATED,:after.FORMID,:after.ISTMP,:after.VERSIONS,:after.APPLICATIONID,:after.STATEINT,:after.STATELABEL,:after.AUDITORNAMES,:after.LASTFLOWOPERATION,:after.LASTMODIFIER,:after.DOMAINID,:after.AUDITORLIST,:after.COAUDITORLIST,:after.STATELABELINFO,:after.PREVAUDITNODE,:after.PREVAUDITUSER,:after.OPTIONITEM,:after.SIGN,:after.KINGGRIDSIGNATURE,:after.ITEM_companyName,:after.ITEM_registerAddress,:after.ITEM_registerAddressDetail,:after.ITEM_officeAddress,:after.ITEM_officeAddressDetail,:after.ITEM_companyPhone,:after.ITEM_companyFax,:after.ITEM_economicType,:after.ITEM_companyType,:after.ID,:after.ITEM_isSub,:after.ITEM_groupName,:after.ITEM_groupDocumentType,:after.ITEM_groupDocumentNO,:after.ITEM_groupLegalPerson,:after.ITEM_groupPhone,:after.ITEM_legalPerson,:after.ITEM_documentType,:after.ITEM_documentID,:after.ITEM_nationality,:after.ITEM_legalPersonPhone,:after.ITEM_registeredCapital,:after.ITEM_fixedAssets,:after.ITEM_annuaTurnover,:after.ITEM_profitTaxes,:after.ITEM_registerDocumentType,:after.ITEM_registerID,:after.ITEM_registerPhoto,:after.ITEM_officeType,:after.ITEM_securityServicePermitNo,:after.ITEM_securityServicePhoto,:after.ITEM_issuingSecurityService,:after.ITEM_issueServiceDate,:after.ITEM_businessScope,:after.ITEM_HRLevel,:after.ITEM_armedEscortLevel,:after.ITEM_securityPrecautions,:after.ITEM_isRiskAssessment,:after.ITEM_securityTrainPermitNo,:after.ITEM_securityTrainPhoto,:after.ITEM_issuingTrainPermit,:after.ITEM_issueTrainDate,:after.ITEM_trainScope,:after.ITEM_SecurityNums,:after.ITEM_securityGroupLevel,:after.ITEM_domain_id,:after.ITEM_companyStatus,:after.ITEM_systemAdmin,:after.ITEM_securityType,:after.ITEM_isInvoivingPlaces,:after.ITEM_isKeyProtectionUnits,:after.ITEM_saas_organId,:after.ITEM_saas_LearnId,:after.AUTHORDEPTID,:after.AUTHOR_USER_INDEX,:after.SUBFORMIDS,:after.INITIATOR,:after.ITEM_securityServicePermitN,:after.ITEM_companycode,:after.ITEM_yin01,:after.ITEM_yin02,:after.ITEM_yin03,:after.ITEM_yin04,:after.ITEM_attendanceSiteType,:after.item_inmycompanyNums,:after.item_stationNum,:after.item_securityTeacherNum,:after.item_shareholderNum,:after.ITEM_place_of_register_province_code,:after.ITEM_place_of_business_province_code,:after.ITEM_place_of_register_city_code,:after.ITEM_place_of_business_city_code,:after.ITEM_place_of_register_district_code,:after.ITEM_place_of_business_district_code,:after.ITEM_sec_manager,:after.ITEM_sec_manager_phone,:after.ITEM_sec_manager_id,:after.ITEM_sec_manager_doc_type,:after.ITEM_approval_number,:after.ITEM_is_property,:after.ITEM_showTips) ON DUPLICATE KEY UPDATE `PARENT` = VALUES(`PARENT`),`LASTMODIFIED` = VALUES(`LASTMODIFIED`),`FORMNAME` = VALUES(`FORMNAME`),`STATE` = VALUES(`STATE`),`AUDITUSER` = VALUES(`AUDITUSER`),`AUDITDATE` = VALUES(`AUDITDATE`),`AUTHOR` = VALUES(`AUTHOR`),`AUTHOR_DEPT_INDEX` = VALUES(`AUTHOR_DEPT_INDEX`),`CREATED` = VALUES(`CREATED`),`FORMID` = VALUES(`FORMID`),`ISTMP` = VALUES(`ISTMP`),`VERSIONS` = VALUES(`VERSIONS`),`APPLICATIONID` = VALUES(`APPLICATIONID`),`STATEINT` = VALUES(`STATEINT`),`STATELABEL` = VALUES(`STATELABEL`),`AUDITORNAMES` = VALUES(`AUDITORNAMES`),`LASTFLOWOPERATION` = VALUES(`LASTFLOWOPERATION`),`LASTMODIFIER` = VALUES(`LASTMODIFIER`),`DOMAINID` = VALUES(`DOMAINID`),`AUDITORLIST` = VALUES(`AUDITORLIST`),`COAUDITORLIST` = VALUES(`COAUDITORLIST`),`STATELABELINFO` = VALUES(`STATELABELINFO`),`PREVAUDITNODE` = VALUES(`PREVAUDITNODE`),`PREVAUDITUSER` = VALUES(`PREVAUDITUSER`),`OPTIONITEM` = VALUES(`OPTIONITEM`),`SIGN` = VALUES(`SIGN`),`KINGGRIDSIGNATURE` = VALUES(`KINGGRIDSIGNATURE`),`ITEM_companyName` = VALUES(`ITEM_companyName`),`ITEM_registerAddress` = VALUES(`ITEM_registerAddress`),`ITEM_registerAddressDetail` = VALUES(`ITEM_registerAddressDetail`),`ITEM_officeAddress` = VALUES(`ITEM_officeAddress`),`ITEM_officeAddressDetail` = VALUES(`ITEM_officeAddressDetail`),`ITEM_companyPhone` = VALUES(`ITEM_companyPhone`),`ITEM_companyFax` = VALUES(`ITEM_companyFax`),`ITEM_economicType` = VALUES(`ITEM_economicType`),`ITEM_companyType` = VALUES(`ITEM_companyType`),`ITEM_isSub` = VALUES(`ITEM_isSub`),`ITEM_groupName` = VALUES(`ITEM_groupName`),`ITEM_groupDocumentType` = VALUES(`ITEM_groupDocumentType`),`ITEM_groupDocumentNO` = VALUES(`ITEM_groupDocumentNO`),`ITEM_groupLegalPerson` = VALUES(`ITEM_groupLegalPerson`),`ITEM_groupPhone` = VALUES(`ITEM_groupPhone`),`ITEM_legalPerson` = VALUES(`ITEM_legalPerson`),`ITEM_documentType` = VALUES(`ITEM_documentType`),`ITEM_documentID` = VALUES(`ITEM_documentID`),`ITEM_nationality` = VALUES(`ITEM_nationality`),`ITEM_legalPersonPhone` = VALUES(`ITEM_legalPersonPhone`),`ITEM_registeredCapital` = VALUES(`ITEM_registeredCapital`),`ITEM_fixedAssets` = VALUES(`ITEM_fixedAssets`),`ITEM_annuaTurnover` = VALUES(`ITEM_annuaTurnover`),`ITEM_profitTaxes` = VALUES(`ITEM_profitTaxes`),`ITEM_registerDocumentType` = VALUES(`ITEM_registerDocumentType`),`ITEM_registerID` = VALUES(`ITEM_registerID`),`ITEM_registerPhoto` = VALUES(`ITEM_registerPhoto`),`ITEM_officeType` = VALUES(`ITEM_officeType`),`ITEM_securityServicePermitNo` = VALUES(`ITEM_securityServicePermitNo`),`ITEM_securityServicePhoto` = VALUES(`ITEM_securityServicePhoto`),`ITEM_issuingSecurityService` = VALUES(`ITEM_issuingSecurityService`),`ITEM_issueServiceDate` = VALUES(`ITEM_issueServiceDate`),`ITEM_businessScope` = VALUES(`ITEM_businessScope`),`ITEM_HRLevel` = VALUES(`ITEM_HRLevel`),`ITEM_armedEscortLevel` = VALUES(`ITEM_armedEscortLevel`),`ITEM_securityPrecautions` = VALUES(`ITEM_securityPrecautions`),`ITEM_isRiskAssessment` = VALUES(`ITEM_isRiskAssessment`),`ITEM_securityTrainPermitNo` = VALUES(`ITEM_securityTrainPermitNo`),`ITEM_securityTrainPhoto` = VALUES(`ITEM_securityTrainPhoto`),`ITEM_issuingTrainPermit` = VALUES(`ITEM_issuingTrainPermit`),`ITEM_issueTrainDate` = VALUES(`ITEM_issueTrainDate`),`ITEM_trainScope` = VALUES(`ITEM_trainScope`),`ITEM_SecurityNums` = VALUES(`ITEM_SecurityNums`),`ITEM_securityGroupLevel` = VALUES(`ITEM_securityGroupLevel`),`ITEM_domain_id` = VALUES(`ITEM_domain_id`),`ITEM_companyStatus` = VALUES(`ITEM_companyStatus`),`ITEM_systemAdmin` = VALUES(`ITEM_systemAdmin`),`ITEM_securityType` = VALUES(`ITEM_securityType`),`ITEM_isInvoivingPlaces` = VALUES(`ITEM_isInvoivingPlaces`),`ITEM_isKeyProtectionUnits` = VALUES(`ITEM_isKeyProtectionUnits`),`ITEM_saas_organId` = VALUES(`ITEM_saas_organId`),`ITEM_saas_LearnId` = VALUES(`ITEM_saas_LearnId`),`AUTHORDEPTID` = VALUES(`AUTHORDEPTID`),`AUTHOR_USER_INDEX` = VALUES(`AUTHOR_USER_INDEX`),`SUBFORMIDS` = VALUES(`SUBFORMIDS`),`INITIATOR` = VALUES(`INITIATOR`),`ITEM_securityServicePermitN` = VALUES(`ITEM_securityServicePermitN`),`ITEM_companycode` = VALUES(`ITEM_companycode`),`ITEM_yin01` = VALUES(`ITEM_yin01`),`ITEM_yin02` = VALUES(`ITEM_yin02`),`ITEM_yin03` = VALUES(`ITEM_yin03`),`ITEM_yin04` = VALUES(`ITEM_yin04`),`ITEM_attendanceSiteType` = VALUES(`ITEM_attendanceSiteType`),`item_inmycompanyNums` = VALUES(`item_inmycompanyNums`),`item_stationNum` = VALUES(`item_stationNum`),`item_securityTeacherNum` = VALUES(`item_securityTeacherNum`),`item_shareholderNum` = VALUES(`item_shareholderNum`),`ITEM_place_of_register_province_code` = VALUES(`ITEM_place_of_register_province_code`),`ITEM_place_of_business_province_code` = VALUES(`ITEM_place_of_business_province_code`),`ITEM_place_of_register_city_code` = VALUES(`ITEM_place_of_register_city_code`),`ITEM_place_of_business_city_code` = VALUES(`ITEM_place_of_business_city_code`),`ITEM_place_of_register_district_code` = VALUES(`ITEM_place_of_register_district_code`),`ITEM_place_of_business_district_code` = VALUES(`ITEM_place_of_business_district_code`),`ITEM_sec_manager` = VALUES(`ITEM_sec_manager`),`ITEM_sec_manager_phone` = VALUES(`ITEM_sec_manager_phone`),`ITEM_sec_manager_id` = VALUES(`ITEM_sec_manager_id`),`ITEM_sec_manager_doc_type` = VALUES(`ITEM_sec_manager_doc_type`),`ITEM_approval_number` = VALUES(`ITEM_approval_number`),`ITEM_is_property` = VALUES(`ITEM_is_property`),`ITEM_showTips` = VALUES(`ITEM_showTips`)"
        }
      ]
    },
    {
      "uid": "company_tlk_setsupervise_topic_jc01",
      "topic": "baibaodunflow.binlog-cdc.topic.v2.tlk_setsupervise",
      "refKafkaName": "kafka-collection",
      "subscriberContents": [
        {
          "uid": "company_tlk_setsupervise_jc01",
          "title": "同步从业单位信息-tlk_setsupervise",
          "refJdbcName": "industryInfoCollection-jdbc",
          "type": "JDBC",
          "content": "insert into baibaodunflow.tlk_setsupervise(`PARENT`,`LASTMODIFIED`,`FORMNAME`,`STATE`,`AUDITUSER`,`AUDITDATE`,`AUTHOR`,`AUTHOR_DEPT_INDEX`,`CREATED`,`FORMID`,`ISTMP`,`VERSIONS`,`APPLICATIONID`,`STATEINT`,`STATELABEL`,`AUDITORNAMES`,`LASTFLOWOPERATION`,`LASTMODIFIER`,`DOMAINID`,`AUDITORLIST`,`COAUDITORLIST`,`STATELABELINFO`,`PREVAUDITNODE`,`PREVAUDITUSER`,`OPTIONITEM`,`SIGN`,`KINGGRIDSIGNATURE`,`ITEM_OFFICEADDRESS`,`ID`,`ITEM_OFFICEADDRESSID`,`ITEM_OFFICEPOLICEADDRESS`,`ITEM_REGISTERADDRESS`,`ITEM_REGISTERADDRESSID`,`ITEM_REGISTERPOLICEADDRESS`,`ITEM_OFFICEPOLICEADDRESSID`,`ITEM_OFFICEPOLICEIDINDEX`,`ITEM_REGISTERPOLICEADDRESSID`,`ITEM_REGISTERPOLICEIDINDEX`,`ITEM_DOMAIN_ID`,`AUTHORDEPTID`,`AUTHOR_USER_INDEX`,`SUBFORMIDS`,`INITIATOR`,`ITEM_B`,`ITEM_FLAG`) VALUES(:after.PARENT,:after.LASTMODIFIED,:after.FORMNAME,:after.STATE,:after.AUDITUSER,:after.AUDITDATE,:after.AUTHOR,:after.AUTHOR_DEPT_INDEX,:after.CREATED,:after.FORMID,:after.ISTMP,:after.VERSIONS,:after.APPLICATIONID,:after.STATEINT,:after.STATELABEL,:after.AUDITORNAMES,:after.LASTFLOWOPERATION,:after.LASTMODIFIER,:after.DOMAINID,:after.AUDITORLIST,:after.COAUDITORLIST,:after.STATELABELINFO,:after.PREVAUDITNODE,:after.PREVAUDITUSER,:after.OPTIONITEM,:after.SIGN,:after.KINGGRIDSIGNATURE,:after.ITEM_OFFICEADDRESS,:after.ID,:after.ITEM_OFFICEADDRESSID,:after.ITEM_OFFICEPOLICEADDRESS,:after.ITEM_REGISTERADDRESS,:after.ITEM_REGISTERADDRESSID,:after.ITEM_REGISTERPOLICEADDRESS,:after.ITEM_OFFICEPOLICEADDRESSID,:after.ITEM_OFFICEPOLICEIDINDEX,:after.ITEM_REGISTERPOLICEADDRESSID,:after.ITEM_REGISTERPOLICEIDINDEX,:after.ITEM_DOMAIN_ID,:after.AUTHORDEPTID,:after.AUTHOR_USER_INDEX,:after.SUBFORMIDS,:after.INITIATOR,:after.ITEM_B,:after.ITEM_FLAG) ON DUPLICATE KEY UPDATE `PARENT` = VALUES(`PARENT`),`LASTMODIFIED` = VALUES(`LASTMODIFIED`),`FORMNAME` = VALUES(`FORMNAME`),`STATE` = VALUES(`STATE`),`AUDITUSER` = VALUES(`AUDITUSER`),`AUDITDATE` = VALUES(`AUDITDATE`),`AUTHOR` = VALUES(`AUTHOR`),`AUTHOR_DEPT_INDEX` = VALUES(`AUTHOR_DEPT_INDEX`),`CREATED` = VALUES(`CREATED`),`FORMID` = VALUES(`FORMID`),`ISTMP` = VALUES(`ISTMP`),`VERSIONS` = VALUES(`VERSIONS`),`APPLICATIONID` = VALUES(`APPLICATIONID`),`STATEINT` = VALUES(`STATEINT`),`STATELABEL` = VALUES(`STATELABEL`),`AUDITORNAMES` = VALUES(`AUDITORNAMES`),`LASTFLOWOPERATION` = VALUES(`LASTFLOWOPERATION`),`LASTMODIFIER` = VALUES(`LASTMODIFIER`),`DOMAINID` = VALUES(`DOMAINID`),`AUDITORLIST` = VALUES(`AUDITORLIST`),`COAUDITORLIST` = VALUES(`COAUDITORLIST`),`STATELABELINFO` = VALUES(`STATELABELINFO`),`PREVAUDITNODE` = VALUES(`PREVAUDITNODE`),`PREVAUDITUSER` = VALUES(`PREVAUDITUSER`),`OPTIONITEM` = VALUES(`OPTIONITEM`),`SIGN` = VALUES(`SIGN`),`KINGGRIDSIGNATURE` = VALUES(`KINGGRIDSIGNATURE`),`ITEM_OFFICEADDRESS` = VALUES(`ITEM_OFFICEADDRESS`),`ITEM_OFFICEADDRESSID` = VALUES(`ITEM_OFFICEADDRESSID`),`ITEM_OFFICEPOLICEADDRESS` = VALUES(`ITEM_OFFICEPOLICEADDRESS`),`ITEM_REGISTERADDRESS` = VALUES(`ITEM_REGISTERADDRESS`),`ITEM_REGISTERADDRESSID` = VALUES(`ITEM_REGISTERADDRESSID`),`ITEM_REGISTERPOLICEADDRESS` = VALUES(`ITEM_REGISTERPOLICEADDRESS`),`ITEM_OFFICEPOLICEADDRESSID` = VALUES(`ITEM_OFFICEPOLICEADDRESSID`),`ITEM_OFFICEPOLICEIDINDEX` = VALUES(`ITEM_OFFICEPOLICEIDINDEX`),`ITEM_REGISTERPOLICEADDRESSID` = VALUES(`ITEM_REGISTERPOLICEADDRESSID`),`ITEM_REGISTERPOLICEIDINDEX` = VALUES(`ITEM_REGISTERPOLICEIDINDEX`),`ITEM_DOMAIN_ID` = VALUES(`ITEM_DOMAIN_ID`),`AUTHORDEPTID` = VALUES(`AUTHORDEPTID`),`AUTHOR_USER_INDEX` = VALUES(`AUTHOR_USER_INDEX`),`SUBFORMIDS` = VALUES(`SUBFORMIDS`),`INITIATOR` = VALUES(`INITIATOR`),`ITEM_B` = VALUES(`ITEM_B`),`ITEM_FLAG` = VALUES(`ITEM_FLAG`)"
        }
      ]
    },
    {
      "uid": "others_tlk_attendance_site_base_info_topic_jc01",
      "topic": "baibaodunflow.binlog-cdc.topic.v2.tlk_attendance_site_base_info",
      "refKafkaName": "kafka-collection",
      "subscriberContents": [
        {
          "uid": "others_tlk_attendance_site_base_info_jc01",
          "title": "同步驻勤点信息-tlk_attendance_site_base_info",
          "refJdbcName": "industryInfoCollection-jdbc",
          "type": "JDBC",
          "content": "insert into baibaodunflow.tlk_attendance_site_base_info(`PARENT`,`LASTMODIFIED`,`FORMNAME`,`STATE`,`AUDITUSER`,`AUDITDATE`,`AUTHOR`,`AUTHOR_DEPT_INDEX`,`CREATED`,`FORMID`,`ISTMP`,`VERSIONS`,`APPLICATIONID`,`STATEINT`,`STATELABEL`,`AUDITORNAMES`,`LASTFLOWOPERATION`,`LASTMODIFIER`,`DOMAINID`,`AUDITORLIST`,`COAUDITORLIST`,`STATELABELINFO`,`PREVAUDITNODE`,`PREVAUDITUSER`,`OPTIONITEM`,`SIGN`,`KINGGRIDSIGNATURE`,`ITEM_attendanceSiteName`,`ITEM_attendanceSiteType`,`ITEM_attendanceSiteContent`,`ID`,`ITEM_attendanceSiteAddress`,`ITEM_attendanceSiteFullAddress`,`ITEM_attendanceSiteLongitude`,`ITEM_attendanceSiteLatitude`,`ITEM_performRange`,`ITEM_officePoliceAddress`,`ITEM_officePoliceAddressID`,`ITEM_officePoliceIDIndex`,`ITEM_attendanceStartDate`,`ITEM_attendanceEndDate`,`ITEM_attendanceSiteState`,`ITEM_principal`,`ITEM_principalName`,`ITEM_principalCardType`,`ITEM_principalIdCardNo`,`ITEM_principalPhoneNo`,`ITEM_principalIsCertified`,`ITEM_serveObjectName`,`ITEM_serveObjectType`,`ITEM_isSignificanceUnit`,`ITEM_contractName`,`ITEM_contractState`,`ITEM_contractStartDate`,`ITEM_contractEndDate`,`ITEM_domain_id`,`ITEM_CONTRACTIDS`,`ITEM_companyName`,`ITEM_SaaS_ID`,`ITEM_isdeleted`,`AUTHORDEPTID`,`AUTHOR_USER_INDEX`,`SUBFORMIDS`,`INITIATOR`,`ITEM_contractId`,`ITEM_princiheyan`,`ITEM_REALITYNAME`,`ITEM_REALITYCARDNO`,`ITEM_REALITYPHONE`,`ITEM_ISAFFILIATION`,`ITEM_contractFile`,`ITEM_CONTRACT`,`ITEM_CFILE`,`ITEM_USERID`,`ITEM_COMPANY_POLICE`,`ITEM_ATT_TYPE`,`ITEM_PROJECT_ID`,`ITEM_PROJECT_NAME`,`ITEM_ATTENDANCE_PROJECT_ID`,`ITEM_CONCURRENTSTAFFNUMBER`) VALUES(:after.PARENT,:after.LASTMODIFIED,:after.FORMNAME,:after.STATE,:after.AUDITUSER,:after.AUDITDATE,:after.AUTHOR,:after.AUTHOR_DEPT_INDEX,:after.CREATED,:after.FORMID,:after.ISTMP,:after.VERSIONS,:after.APPLICATIONID,:after.STATEINT,:after.STATELABEL,:after.AUDITORNAMES,:after.LASTFLOWOPERATION,:after.LASTMODIFIER,:after.DOMAINID,:after.AUDITORLIST,:after.COAUDITORLIST,:after.STATELABELINFO,:after.PREVAUDITNODE,:after.PREVAUDITUSER,:after.OPTIONITEM,:after.SIGN,:after.KINGGRIDSIGNATURE,:after.ITEM_attendanceSiteName,:after.ITEM_attendanceSiteType,:after.ITEM_attendanceSiteContent,:after.ID,:after.ITEM_attendanceSiteAddress,:after.ITEM_attendanceSiteFullAddress,:after.ITEM_attendanceSiteLongitude,:after.ITEM_attendanceSiteLatitude,:after.ITEM_performRange,:after.ITEM_officePoliceAddress,:after.ITEM_officePoliceAddressID,:after.ITEM_officePoliceIDIndex,:after.ITEM_attendanceStartDate,:after.ITEM_attendanceEndDate,:after.ITEM_attendanceSiteState,:after.ITEM_principal,:after.ITEM_principalName,:after.ITEM_principalCardType,:after.ITEM_principalIdCardNo,:after.ITEM_principalPhoneNo,:after.ITEM_principalIsCertified,:after.ITEM_serveObjectName,:after.ITEM_serveObjectType,:after.ITEM_isSignificanceUnit,:after.ITEM_contractName,:after.ITEM_contractState,:after.ITEM_contractStartDate,:after.ITEM_contractEndDate,:after.ITEM_domain_id,:after.ITEM_CONTRACTIDS,:after.ITEM_companyName,:after.ITEM_SaaS_ID,:after.ITEM_isdeleted,:after.AUTHORDEPTID,:after.AUTHOR_USER_INDEX,:after.SUBFORMIDS,:after.INITIATOR,:after.ITEM_contractId,:after.ITEM_princiheyan,:after.ITEM_REALITYNAME,:after.ITEM_REALITYCARDNO,:after.ITEM_REALITYPHONE,:after.ITEM_ISAFFILIATION,:after.ITEM_contractFile,:after.ITEM_CONTRACT,:after.ITEM_CFILE,:after.ITEM_USERID,:after.ITEM_COMPANY_POLICE,:after.ITEM_ATT_TYPE,:after.ITEM_PROJECT_ID,:after.ITEM_PROJECT_NAME,:after.ITEM_ATTENDANCE_PROJECT_ID,:after.ITEM_CONCURRENTSTAFFNUMBER) ON DUPLICATE KEY UPDATE `PARENT` = VALUES(`PARENT`),`LASTMODIFIED` = VALUES(`LASTMODIFIED`),`FORMNAME` = VALUES(`FORMNAME`),`STATE` = VALUES(`STATE`),`AUDITUSER` = VALUES(`AUDITUSER`),`AUDITDATE` = VALUES(`AUDITDATE`),`AUTHOR` = VALUES(`AUTHOR`),`AUTHOR_DEPT_INDEX` = VALUES(`AUTHOR_DEPT_INDEX`),`CREATED` = VALUES(`CREATED`),`FORMID` = VALUES(`FORMID`),`ISTMP` = VALUES(`ISTMP`),`VERSIONS` = VALUES(`VERSIONS`),`APPLICATIONID` = VALUES(`APPLICATIONID`),`STATEINT` = VALUES(`STATEINT`),`STATELABEL` = VALUES(`STATELABEL`),`AUDITORNAMES` = VALUES(`AUDITORNAMES`),`LASTFLOWOPERATION` = VALUES(`LASTFLOWOPERATION`),`LASTMODIFIER` = VALUES(`LASTMODIFIER`),`DOMAINID` = VALUES(`DOMAINID`),`AUDITORLIST` = VALUES(`AUDITORLIST`),`COAUDITORLIST` = VALUES(`COAUDITORLIST`),`STATELABELINFO` = VALUES(`STATELABELINFO`),`PREVAUDITNODE` = VALUES(`PREVAUDITNODE`),`PREVAUDITUSER` = VALUES(`PREVAUDITUSER`),`OPTIONITEM` = VALUES(`OPTIONITEM`),`SIGN` = VALUES(`SIGN`),`KINGGRIDSIGNATURE` = VALUES(`KINGGRIDSIGNATURE`),`ITEM_attendanceSiteName` = VALUES(`ITEM_attendanceSiteName`),`ITEM_attendanceSiteType` = VALUES(`ITEM_attendanceSiteType`),`ITEM_attendanceSiteContent` = VALUES(`ITEM_attendanceSiteContent`),`ITEM_attendanceSiteAddress` = VALUES(`ITEM_attendanceSiteAddress`),`ITEM_attendanceSiteFullAddress` = VALUES(`ITEM_attendanceSiteFullAddress`),`ITEM_attendanceSiteLongitude` = VALUES(`ITEM_attendanceSiteLongitude`),`ITEM_attendanceSiteLatitude` = VALUES(`ITEM_attendanceSiteLatitude`),`ITEM_performRange` = VALUES(`ITEM_performRange`),`ITEM_officePoliceAddress` = VALUES(`ITEM_officePoliceAddress`),`ITEM_officePoliceAddressID` = VALUES(`ITEM_officePoliceAddressID`),`ITEM_officePoliceIDIndex` = VALUES(`ITEM_officePoliceIDIndex`),`ITEM_attendanceStartDate` = VALUES(`ITEM_attendanceStartDate`),`ITEM_attendanceEndDate` = VALUES(`ITEM_attendanceEndDate`),`ITEM_attendanceSiteState` = VALUES(`ITEM_attendanceSiteState`),`ITEM_principal` = VALUES(`ITEM_principal`),`ITEM_principalName` = VALUES(`ITEM_principalName`),`ITEM_principalCardType` = VALUES(`ITEM_principalCardType`),`ITEM_principalIdCardNo` = VALUES(`ITEM_principalIdCardNo`),`ITEM_principalPhoneNo` = VALUES(`ITEM_principalPhoneNo`),`ITEM_principalIsCertified` = VALUES(`ITEM_principalIsCertified`),`ITEM_serveObjectName` = VALUES(`ITEM_serveObjectName`),`ITEM_serveObjectType` = VALUES(`ITEM_serveObjectType`),`ITEM_isSignificanceUnit` = VALUES(`ITEM_isSignificanceUnit`),`ITEM_contractName` = VALUES(`ITEM_contractName`),`ITEM_contractState` = VALUES(`ITEM_contractState`),`ITEM_contractStartDate` = VALUES(`ITEM_contractStartDate`),`ITEM_contractEndDate` = VALUES(`ITEM_contractEndDate`),`ITEM_domain_id` = VALUES(`ITEM_domain_id`),`ITEM_CONTRACTIDS` = VALUES(`ITEM_CONTRACTIDS`),`ITEM_companyName` = VALUES(`ITEM_companyName`),`ITEM_SaaS_ID` = VALUES(`ITEM_SaaS_ID`),`ITEM_isdeleted` = VALUES(`ITEM_isdeleted`),`AUTHORDEPTID` = VALUES(`AUTHORDEPTID`),`AUTHOR_USER_INDEX` = VALUES(`AUTHOR_USER_INDEX`),`SUBFORMIDS` = VALUES(`SUBFORMIDS`),`INITIATOR` = VALUES(`INITIATOR`),`ITEM_contractId` = VALUES(`ITEM_contractId`),`ITEM_princiheyan` = VALUES(`ITEM_princiheyan`),`ITEM_REALITYNAME` = VALUES(`ITEM_REALITYNAME`),`ITEM_REALITYCARDNO` = VALUES(`ITEM_REALITYCARDNO`),`ITEM_REALITYPHONE` = VALUES(`ITEM_REALITYPHONE`),`ITEM_ISAFFILIATION` = VALUES(`ITEM_ISAFFILIATION`),`ITEM_contractFile` = VALUES(`ITEM_contractFile`),`ITEM_CONTRACT` = VALUES(`ITEM_CONTRACT`),`ITEM_CFILE` = VALUES(`ITEM_CFILE`),`ITEM_USERID` = VALUES(`ITEM_USERID`),`ITEM_COMPANY_POLICE` = VALUES(`ITEM_COMPANY_POLICE`),`ITEM_ATT_TYPE` = VALUES(`ITEM_ATT_TYPE`),`ITEM_PROJECT_ID` = VALUES(`ITEM_PROJECT_ID`),`ITEM_PROJECT_NAME` = VALUES(`ITEM_PROJECT_NAME`),`ITEM_ATTENDANCE_PROJECT_ID` = VALUES(`ITEM_ATTENDANCE_PROJECT_ID`),`ITEM_CONCURRENTSTAFFNUMBER` = VALUES(`ITEM_CONCURRENTSTAFFNUMBER`)"
        }
      ]
    },
    {
      "uid": "others_tlk_attendance_site_person_info_topic_jc01",
      "topic": "baibaodunflow.binlog-cdc.topic.v2.tlk_attendance_site_person_info",
      "refKafkaName": "kafka-collection",
      "subscriberContents": [
        {
          "uid": "others_tlk_attendance_site_person_info_jc01",
          "title": "同步驻勤人员信息-tlk_attendance_site_person_info",
          "refJdbcName": "industryInfoCollection-jdbc",
          "type": "JDBC",
          "content": "insert into baibaodunflow.tlk_attendance_site_person_info(`PARENT`,`LASTMODIFIED`,`FORMNAME`,`STATE`,`AUDITUSER`,`AUDITDATE`,`AUTHOR`,`AUTHOR_DEPT_INDEX`,`CREATED`,`FORMID`,`ISTMP`,`VERSIONS`,`APPLICATIONID`,`STATEINT`,`STATELABEL`,`AUDITORNAMES`,`LASTFLOWOPERATION`,`LASTMODIFIER`,`DOMAINID`,`AUDITORLIST`,`COAUDITORLIST`,`STATELABELINFO`,`PREVAUDITNODE`,`PREVAUDITUSER`,`OPTIONITEM`,`SIGN`,`KINGGRIDSIGNATURE`,`ITEM_securityName`,`ITEM_securityId`,`ITEM_documentType`,`ITEM_documentID`,`ITEM_phone`,`ITEM_DeptName`,`ITEM_jobType`,`ITEM_isCertified`,`ITEM_insuranceStatus`,`ITEM_createdUser`,`ID`,`ITEM_attendanceSiteId`,`ITEM_domain_id`,`ITEM_SaaS_PerId`,`ITEM_SaaS_taskId`,`ITEM_isdeleted`,`AUTHORDEPTID`,`AUTHOR_USER_INDEX`,`SUBFORMIDS`,`INITIATOR`,`ITEM_REPORTING_TIME`,`ITEM_PERSON_STATUS`,`ITEM_PERSON_TYPE`,`ITEM_FROM_TYPE`,`ITEM_PUSH_ATTENDANCE`) VALUES(:after.PARENT,:after.LASTMODIFIED,:after.FORMNAME,:after.STATE,:after.AUDITUSER,:after.AUDITDATE,:after.AUTHOR,:after.AUTHOR_DEPT_INDEX,:after.CREATED,:after.FORMID,:after.ISTMP,:after.VERSIONS,:after.APPLICATIONID,:after.STATEINT,:after.STATELABEL,:after.AUDITORNAMES,:after.LASTFLOWOPERATION,:after.LASTMODIFIER,:after.DOMAINID,:after.AUDITORLIST,:after.COAUDITORLIST,:after.STATELABELINFO,:after.PREVAUDITNODE,:after.PREVAUDITUSER,:after.OPTIONITEM,:after.SIGN,:after.KINGGRIDSIGNATURE,:after.ITEM_securityName,:after.ITEM_securityId,:after.ITEM_documentType,:after.ITEM_documentID,:after.ITEM_phone,:after.ITEM_DeptName,:after.ITEM_jobType,:after.ITEM_isCertified,:after.ITEM_insuranceStatus,:after.ITEM_createdUser,ifnull(:after.ID,''),:after.ITEM_attendanceSiteId,:after.ITEM_domain_id,:after.ITEM_SaaS_PerId,:after.ITEM_SaaS_taskId,:after.ITEM_isdeleted,:after.AUTHORDEPTID,:after.AUTHOR_USER_INDEX,:after.SUBFORMIDS,:after.INITIATOR,:after.ITEM_REPORTING_TIME,:after.ITEM_PERSON_STATUS,:after.ITEM_PERSON_TYPE,:after.ITEM_FROM_TYPE,:after.ITEM_PUSH_ATTENDANCE) ON DUPLICATE KEY UPDATE `PARENT` = VALUES(`PARENT`),`LASTMODIFIED` = VALUES(`LASTMODIFIED`),`FORMNAME` = VALUES(`FORMNAME`),`STATE` = VALUES(`STATE`),`AUDITUSER` = VALUES(`AUDITUSER`),`AUDITDATE` = VALUES(`AUDITDATE`),`AUTHOR` = VALUES(`AUTHOR`),`AUTHOR_DEPT_INDEX` = VALUES(`AUTHOR_DEPT_INDEX`),`CREATED` = VALUES(`CREATED`),`FORMID` = VALUES(`FORMID`),`ISTMP` = VALUES(`ISTMP`),`VERSIONS` = VALUES(`VERSIONS`),`APPLICATIONID` = VALUES(`APPLICATIONID`),`STATEINT` = VALUES(`STATEINT`),`STATELABEL` = VALUES(`STATELABEL`),`AUDITORNAMES` = VALUES(`AUDITORNAMES`),`LASTFLOWOPERATION` = VALUES(`LASTFLOWOPERATION`),`LASTMODIFIER` = VALUES(`LASTMODIFIER`),`DOMAINID` = VALUES(`DOMAINID`),`AUDITORLIST` = VALUES(`AUDITORLIST`),`COAUDITORLIST` = VALUES(`COAUDITORLIST`),`STATELABELINFO` = VALUES(`STATELABELINFO`),`PREVAUDITNODE` = VALUES(`PREVAUDITNODE`),`PREVAUDITUSER` = VALUES(`PREVAUDITUSER`),`OPTIONITEM` = VALUES(`OPTIONITEM`),`SIGN` = VALUES(`SIGN`),`KINGGRIDSIGNATURE` = VALUES(`KINGGRIDSIGNATURE`),`ITEM_securityName` = VALUES(`ITEM_securityName`),`ITEM_securityId` = VALUES(`ITEM_securityId`),`ITEM_documentType` = VALUES(`ITEM_documentType`),`ITEM_documentID` = VALUES(`ITEM_documentID`),`ITEM_phone` = VALUES(`ITEM_phone`),`ITEM_DeptName` = VALUES(`ITEM_DeptName`),`ITEM_jobType` = VALUES(`ITEM_jobType`),`ITEM_isCertified` = VALUES(`ITEM_isCertified`),`ITEM_insuranceStatus` = VALUES(`ITEM_insuranceStatus`),`ITEM_createdUser` = VALUES(`ITEM_createdUser`),`ITEM_attendanceSiteId` = VALUES(`ITEM_attendanceSiteId`),`ITEM_domain_id` = VALUES(`ITEM_domain_id`),`ITEM_SaaS_PerId` = VALUES(`ITEM_SaaS_PerId`),`ITEM_SaaS_taskId` = VALUES(`ITEM_SaaS_taskId`),`ITEM_isdeleted` = VALUES(`ITEM_isdeleted`),`AUTHORDEPTID` = VALUES(`AUTHORDEPTID`),`AUTHOR_USER_INDEX` = VALUES(`AUTHOR_USER_INDEX`),`SUBFORMIDS` = VALUES(`SUBFORMIDS`),`INITIATOR` = VALUES(`INITIATOR`),`ITEM_REPORTING_TIME` = VALUES(`ITEM_REPORTING_TIME`),`ITEM_PERSON_STATUS` = VALUES(`ITEM_PERSON_STATUS`),`ITEM_PERSON_TYPE` = VALUES(`ITEM_PERSON_TYPE`),`ITEM_FROM_TYPE` = VALUES(`ITEM_FROM_TYPE`),`ITEM_PUSH_ATTENDANCE` = VALUES(`ITEM_PUSH_ATTENDANCE`)"
        },
        {
          "uid": "others_tlk_attendance_site_person_info_jc02",
          "title": "同步驻勤人员信息-tlk_attendance_site_person_info-删除人员",
          "refJdbcName": "industryInfoCollection-jdbc",
          "type": "JDBC",
          "content": "delete from baibaodunflow.tlk_attendance_site_person_info where id in ( :before.id,'' ) and :after.id is null"
        }
      ]
    },
    {
      "uid": "others_tlk_attendance_site_arrange_info_topic_jc01",
      "topic": "baibaodunflow.binlog-cdc.topic.v2.tlk_attendance_site_arrange_info",
      "refKafkaName": "kafka-collection",
      "subscriberContents": [
        {
          "uid": "others_tlk_attendance_site_arrange_info_jc01",
          "title": "同步驻勤人员安排信息-tlk_attendance_site_arrange_info",
          "refJdbcName": "industryInfoCollection-jdbc",
          "type": "JDBC",
          "content": "insert into baibaodunflow.tlk_attendance_site_arrange_info(`PARENT`,`LASTMODIFIED`,`FORMNAME`,`STATE`,`AUDITUSER`,`AUDITDATE`,`AUTHOR`,`AUTHOR_DEPT_INDEX`,`CREATED`,`FORMID`,`ISTMP`,`VERSIONS`,`APPLICATIONID`,`STATEINT`,`STATELABEL`,`AUDITORNAMES`,`LASTFLOWOPERATION`,`LASTMODIFIER`,`DOMAINID`,`AUDITORLIST`,`COAUDITORLIST`,`STATELABELINFO`,`PREVAUDITNODE`,`PREVAUDITUSER`,`OPTIONITEM`,`SIGN`,`KINGGRIDSIGNATURE`,`ITEM_SECURITYNAME`,`ITEM_SECURITYID`,`ITEM_ATTENDANCESITEID`,`ITEM_DOCUMENTTYPE`,`ITEM_DOCUMENTID`,`ITEM_PHONE`,`ITEM_JOIN_ATT_TIME`,`ITEM_JOIN_ATT_OPERATOR`,`ITEM_LEAVE_ATT_TIME`,`ITEM_LEAVE_ATT_OPERATOR`,`ID`,`AUTHORDEPTID`,`AUTHOR_USER_INDEX`,`SUBFORMIDS`,`INITIATOR`) VALUES(:after.PARENT,:after.LASTMODIFIED,:after.FORMNAME,:after.STATE,:after.AUDITUSER,:after.AUDITDATE,:after.AUTHOR,:after.AUTHOR_DEPT_INDEX,:after.CREATED,:after.FORMID,:after.ISTMP,:after.VERSIONS,:after.APPLICATIONID,:after.STATEINT,:after.STATELABEL,:after.AUDITORNAMES,:after.LASTFLOWOPERATION,:after.LASTMODIFIER,:after.DOMAINID,:after.AUDITORLIST,:after.COAUDITORLIST,:after.STATELABELINFO,:after.PREVAUDITNODE,:after.PREVAUDITUSER,:after.OPTIONITEM,:after.SIGN,:after.KINGGRIDSIGNATURE,:after.ITEM_SECURITYNAME,:after.ITEM_SECURITYID,:after.ITEM_ATTENDANCESITEID,:after.ITEM_DOCUMENTTYPE,:after.ITEM_DOCUMENTID,:after.ITEM_PHONE,:after.ITEM_JOIN_ATT_TIME,:after.ITEM_JOIN_ATT_OPERATOR,:after.ITEM_LEAVE_ATT_TIME,:after.ITEM_LEAVE_ATT_OPERATOR,:after.ID,:after.AUTHORDEPTID,:after.AUTHOR_USER_INDEX,:after.SUBFORMIDS,:after.INITIATOR) ON DUPLICATE KEY UPDATE `PARENT` = VALUES(`PARENT`),`LASTMODIFIED` = VALUES(`LASTMODIFIED`),`FORMNAME` = VALUES(`FORMNAME`),`STATE` = VALUES(`STATE`),`AUDITUSER` = VALUES(`AUDITUSER`),`AUDITDATE` = VALUES(`AUDITDATE`),`AUTHOR` = VALUES(`AUTHOR`),`AUTHOR_DEPT_INDEX` = VALUES(`AUTHOR_DEPT_INDEX`),`CREATED` = VALUES(`CREATED`),`FORMID` = VALUES(`FORMID`),`ISTMP` = VALUES(`ISTMP`),`VERSIONS` = VALUES(`VERSIONS`),`APPLICATIONID` = VALUES(`APPLICATIONID`),`STATEINT` = VALUES(`STATEINT`),`STATELABEL` = VALUES(`STATELABEL`),`AUDITORNAMES` = VALUES(`AUDITORNAMES`),`LASTFLOWOPERATION` = VALUES(`LASTFLOWOPERATION`),`LASTMODIFIER` = VALUES(`LASTMODIFIER`),`DOMAINID` = VALUES(`DOMAINID`),`AUDITORLIST` = VALUES(`AUDITORLIST`),`COAUDITORLIST` = VALUES(`COAUDITORLIST`),`STATELABELINFO` = VALUES(`STATELABELINFO`),`PREVAUDITNODE` = VALUES(`PREVAUDITNODE`),`PREVAUDITUSER` = VALUES(`PREVAUDITUSER`),`OPTIONITEM` = VALUES(`OPTIONITEM`),`SIGN` = VALUES(`SIGN`),`KINGGRIDSIGNATURE` = VALUES(`KINGGRIDSIGNATURE`),`ITEM_SECURITYNAME` = VALUES(`ITEM_SECURITYNAME`),`ITEM_SECURITYID` = VALUES(`ITEM_SECURITYID`),`ITEM_ATTENDANCESITEID` = VALUES(`ITEM_ATTENDANCESITEID`),`ITEM_DOCUMENTTYPE` = VALUES(`ITEM_DOCUMENTTYPE`),`ITEM_DOCUMENTID` = VALUES(`ITEM_DOCUMENTID`),`ITEM_PHONE` = VALUES(`ITEM_PHONE`),`ITEM_JOIN_ATT_TIME` = VALUES(`ITEM_JOIN_ATT_TIME`),`ITEM_JOIN_ATT_OPERATOR` = VALUES(`ITEM_JOIN_ATT_OPERATOR`),`ITEM_LEAVE_ATT_TIME` = VALUES(`ITEM_LEAVE_ATT_TIME`),`ITEM_LEAVE_ATT_OPERATOR` = VALUES(`ITEM_LEAVE_ATT_OPERATOR`),`AUTHORDEPTID` = VALUES(`AUTHORDEPTID`),`AUTHOR_USER_INDEX` = VALUES(`AUTHOR_USER_INDEX`),`SUBFORMIDS` = VALUES(`SUBFORMIDS`),`INITIATOR` = VALUES(`INITIATOR`)"
        }
      ]
    },
    {
      "uid": "others_tlk_contracttoenterprise_topic_jc01",
      "topic": "baibaodunflow.binlog-cdc.topic.v2.tlk_contracttoenterprise",
      "refKafkaName": "kafka-collection",
      "subscriberContents": [
        {
          "uid": "others_tlk_contracttoenterprise_jc01",
          "title": "同步驻勤项目合同信息-tlk_contracttoenterprise",
          "refJdbcName": "industryInfoCollection-jdbc",
          "type": "JDBC",
          "content": "insert into baibaodunflow.tlk_contracttoenterprise(`PARENT`,`LASTMODIFIED`,`FORMNAME`,`STATE`,`AUDITUSER`,`AUDITDATE`,`AUTHOR`,`AUTHOR_DEPT_INDEX`,`CREATED`,`FORMID`,`ISTMP`,`VERSIONS`,`APPLICATIONID`,`STATEINT`,`STATELABEL`,`AUDITORNAMES`,`LASTFLOWOPERATION`,`LASTMODIFIER`,`DOMAINID`,`AUDITORLIST`,`COAUDITORLIST`,`STATELABELINFO`,`PREVAUDITNODE`,`PREVAUDITUSER`,`OPTIONITEM`,`SIGN`,`KINGGRIDSIGNATURE`,`ID`,`ITEM_CONTRACTNAME`,`ITEM_BELONGENTERPRISE`,`ITEM_PARTYANAME`,`ITEM_PARTYAPHONE`,`ITEM_PARTYBNAME`,`ITEM_PARTYBPHONE`,`ITEM_PARTYCNAME`,`ITEM_PARTYCPHONE`,`ITEM_CONTRACTSTARTDATE`,`ITEM_ISNOTENDDATE`,`ITEM_CONTRACTENDDATE`,`ITEM_CONTRACTSTATE`,`ITEM_CONTRACTFILE`,`ITEM_DOMAIN_ID`,`ITEM_SAAS_COMCONTRACTID`,`AUTHORDEPTID`,`AUTHOR_USER_INDEX`,`SUBFORMIDS`,`INITIATOR`) VALUES(:after.PARENT,:after.LASTMODIFIED,:after.FORMNAME,:after.STATE,:after.AUDITUSER,:after.AUDITDATE,:after.AUTHOR,:after.AUTHOR_DEPT_INDEX,:after.CREATED,:after.FORMID,:after.ISTMP,:after.VERSIONS,:after.APPLICATIONID,:after.STATEINT,:after.STATELABEL,:after.AUDITORNAMES,:after.LASTFLOWOPERATION,:after.LASTMODIFIER,:after.DOMAINID,:after.AUDITORLIST,:after.COAUDITORLIST,:after.STATELABELINFO,:after.PREVAUDITNODE,:after.PREVAUDITUSER,:after.OPTIONITEM,:after.SIGN,:after.KINGGRIDSIGNATURE,:after.ID,:after.ITEM_CONTRACTNAME,:after.ITEM_BELONGENTERPRISE,:after.ITEM_PARTYANAME,:after.ITEM_PARTYAPHONE,:after.ITEM_PARTYBNAME,:after.ITEM_PARTYBPHONE,:after.ITEM_PARTYCNAME,:after.ITEM_PARTYCPHONE,:after.ITEM_CONTRACTSTARTDATE, DATEDIFF(date(:after.ITEM_ISNOTENDDATE),'1970-01-01'),:after.ITEM_CONTRACTENDDATE,:after.ITEM_CONTRACTSTATE,:after.ITEM_CONTRACTFILE,:after.ITEM_DOMAIN_ID,:after.ITEM_SAAS_COMCONTRACTID,:after.AUTHORDEPTID,:after.AUTHOR_USER_INDEX,:after.SUBFORMIDS,:after.INITIATOR) ON DUPLICATE KEY UPDATE `PARENT` = VALUES(`PARENT`),`LASTMODIFIED` = VALUES(`LASTMODIFIED`),`FORMNAME` = VALUES(`FORMNAME`),`STATE` = VALUES(`STATE`),`AUDITUSER` = VALUES(`AUDITUSER`),`AUDITDATE` = VALUES(`AUDITDATE`),`AUTHOR` = VALUES(`AUTHOR`),`AUTHOR_DEPT_INDEX` = VALUES(`AUTHOR_DEPT_INDEX`),`CREATED` = VALUES(`CREATED`),`FORMID` = VALUES(`FORMID`),`ISTMP` = VALUES(`ISTMP`),`VERSIONS` = VALUES(`VERSIONS`),`APPLICATIONID` = VALUES(`APPLICATIONID`),`STATEINT` = VALUES(`STATEINT`),`STATELABEL` = VALUES(`STATELABEL`),`AUDITORNAMES` = VALUES(`AUDITORNAMES`),`LASTFLOWOPERATION` = VALUES(`LASTFLOWOPERATION`),`LASTMODIFIER` = VALUES(`LASTMODIFIER`),`DOMAINID` = VALUES(`DOMAINID`),`AUDITORLIST` = VALUES(`AUDITORLIST`),`COAUDITORLIST` = VALUES(`COAUDITORLIST`),`STATELABELINFO` = VALUES(`STATELABELINFO`),`PREVAUDITNODE` = VALUES(`PREVAUDITNODE`),`PREVAUDITUSER` = VALUES(`PREVAUDITUSER`),`OPTIONITEM` = VALUES(`OPTIONITEM`),`SIGN` = VALUES(`SIGN`),`KINGGRIDSIGNATURE` = VALUES(`KINGGRIDSIGNATURE`),`ITEM_CONTRACTNAME` = VALUES(`ITEM_CONTRACTNAME`),`ITEM_BELONGENTERPRISE` = VALUES(`ITEM_BELONGENTERPRISE`),`ITEM_PARTYANAME` = VALUES(`ITEM_PARTYANAME`),`ITEM_PARTYAPHONE` = VALUES(`ITEM_PARTYAPHONE`),`ITEM_PARTYBNAME` = VALUES(`ITEM_PARTYBNAME`),`ITEM_PARTYBPHONE` = VALUES(`ITEM_PARTYBPHONE`),`ITEM_PARTYCNAME` = VALUES(`ITEM_PARTYCNAME`),`ITEM_PARTYCPHONE` = VALUES(`ITEM_PARTYCPHONE`),`ITEM_CONTRACTSTARTDATE` = VALUES(`ITEM_CONTRACTSTARTDATE`),`ITEM_ISNOTENDDATE` = VALUES(`ITEM_ISNOTENDDATE`),`ITEM_CONTRACTENDDATE` = VALUES(`ITEM_CONTRACTENDDATE`),`ITEM_CONTRACTSTATE` = VALUES(`ITEM_CONTRACTSTATE`),`ITEM_CONTRACTFILE` = VALUES(`ITEM_CONTRACTFILE`),`ITEM_DOMAIN_ID` = VALUES(`ITEM_DOMAIN_ID`),`ITEM_SAAS_COMCONTRACTID` = VALUES(`ITEM_SAAS_COMCONTRACTID`),`AUTHORDEPTID` = VALUES(`AUTHORDEPTID`),`AUTHOR_USER_INDEX` = VALUES(`AUTHOR_USER_INDEX`),`SUBFORMIDS` = VALUES(`SUBFORMIDS`),`INITIATOR` = VALUES(`INITIATOR`)"
        }
      ]
    },
    {
      "uid": "others_tlk_attendance_project_topic_jc01",
      "topic": "baibaodunflow.binlog-cdc.topic.v2.tlk_attendance_project",
      "refKafkaName": "kafka-collection",
      "subscriberContents": [
        {
          "uid": "others_tlk_attendance_project_jc01",
          "title": "同步驻勤项目信息-tlk_attendance_project",
          "refJdbcName": "industryInfoCollection-jdbc",
          "type": "JDBC",
          "content": "insert into baibaodunflow.tlk_attendance_project(`PARENT`,`LASTMODIFIED`,`FORMNAME`,`STATE`,`AUDITUSER`,`AUDITDATE`,`AUTHOR`,`AUTHORDEPTID`,`AUTHOR_DEPT_INDEX`,`AUTHOR_USER_INDEX`,`CREATED`,`FORMID`,`SUBFORMIDS`,`INITIATOR`,`ISTMP`,`VERSIONS`,`APPLICATIONID`,`STATEINT`,`STATELABEL`,`AUDITORNAMES`,`LASTFLOWOPERATION`,`LASTMODIFIER`,`DOMAINID`,`AUDITORLIST`,`COAUDITORLIST`,`STATELABELINFO`,`PREVAUDITNODE`,`PREVAUDITUSER`,`OPTIONITEM`,`SIGN`,`KINGGRIDSIGNATURE`,`ID`,`ITEM_PROJECT_NAME`,`ITEM_PROJECT_CONTENT`,`ITEM_ATTENDANCESITEADDRESS`,`ITEM_ATTENDANCESITEFULLADDRESS`,`ITEM_ATTENDANCESITELONGITUDE`,`ITEM_ATTENDANCESITELATITUDE`,`ITEM_MANAGER`,`ITEM_CONTRACT_ID`) VALUES(:after.PARENT,:after.LASTMODIFIED,:after.FORMNAME,:after.STATE,:after.AUDITUSER,:after.AUDITDATE,:after.AUTHOR,:after.AUTHORDEPTID,:after.AUTHOR_DEPT_INDEX,:after.AUTHOR_USER_INDEX,:after.CREATED,:after.FORMID,:after.SUBFORMIDS,:after.INITIATOR,:after.ISTMP,:after.VERSIONS,:after.APPLICATIONID,:after.STATEINT,:after.STATELABEL,:after.AUDITORNAMES,:after.LASTFLOWOPERATION,:after.LASTMODIFIER,:after.DOMAINID,:after.AUDITORLIST,:after.COAUDITORLIST,:after.STATELABELINFO,:after.PREVAUDITNODE,:after.PREVAUDITUSER,:after.OPTIONITEM,:after.SIGN,:after.KINGGRIDSIGNATURE,:after.ID,:after.ITEM_PROJECT_NAME,:after.ITEM_PROJECT_CONTENT,:after.ITEM_ATTENDANCESITEADDRESS,:after.ITEM_ATTENDANCESITEFULLADDRESS,:after.ITEM_ATTENDANCESITELONGITUDE,:after.ITEM_ATTENDANCESITELATITUDE,:after.ITEM_MANAGER,:after.ITEM_CONTRACT_ID) ON DUPLICATE KEY UPDATE `PARENT` = VALUES(`PARENT`),`LASTMODIFIED` = VALUES(`LASTMODIFIED`),`FORMNAME` = VALUES(`FORMNAME`),`STATE` = VALUES(`STATE`),`AUDITUSER` = VALUES(`AUDITUSER`),`AUDITDATE` = VALUES(`AUDITDATE`),`AUTHOR` = VALUES(`AUTHOR`),`AUTHORDEPTID` = VALUES(`AUTHORDEPTID`),`AUTHOR_DEPT_INDEX` = VALUES(`AUTHOR_DEPT_INDEX`),`AUTHOR_USER_INDEX` = VALUES(`AUTHOR_USER_INDEX`),`CREATED` = VALUES(`CREATED`),`FORMID` = VALUES(`FORMID`),`SUBFORMIDS` = VALUES(`SUBFORMIDS`),`INITIATOR` = VALUES(`INITIATOR`),`ISTMP` = VALUES(`ISTMP`),`VERSIONS` = VALUES(`VERSIONS`),`APPLICATIONID` = VALUES(`APPLICATIONID`),`STATEINT` = VALUES(`STATEINT`),`STATELABEL` = VALUES(`STATELABEL`),`AUDITORNAMES` = VALUES(`AUDITORNAMES`),`LASTFLOWOPERATION` = VALUES(`LASTFLOWOPERATION`),`LASTMODIFIER` = VALUES(`LASTMODIFIER`),`DOMAINID` = VALUES(`DOMAINID`),`AUDITORLIST` = VALUES(`AUDITORLIST`),`COAUDITORLIST` = VALUES(`COAUDITORLIST`),`STATELABELINFO` = VALUES(`STATELABELINFO`),`PREVAUDITNODE` = VALUES(`PREVAUDITNODE`),`PREVAUDITUSER` = VALUES(`PREVAUDITUSER`),`OPTIONITEM` = VALUES(`OPTIONITEM`),`SIGN` = VALUES(`SIGN`),`KINGGRIDSIGNATURE` = VALUES(`KINGGRIDSIGNATURE`),`ITEM_PROJECT_NAME` = VALUES(`ITEM_PROJECT_NAME`),`ITEM_PROJECT_CONTENT` = VALUES(`ITEM_PROJECT_CONTENT`),`ITEM_ATTENDANCESITEADDRESS` = VALUES(`ITEM_ATTENDANCESITEADDRESS`),`ITEM_ATTENDANCESITEFULLADDRESS` = VALUES(`ITEM_ATTENDANCESITEFULLADDRESS`),`ITEM_ATTENDANCESITELONGITUDE` = VALUES(`ITEM_ATTENDANCESITELONGITUDE`),`ITEM_ATTENDANCESITELATITUDE` = VALUES(`ITEM_ATTENDANCESITELATITUDE`),`ITEM_MANAGER` = VALUES(`ITEM_MANAGER`),`ITEM_CONTRACT_ID` = VALUES(`ITEM_CONTRACT_ID`)"
        }
      ]
    }
  ]
}