INSERT INTO `obpm2_security`.`sync_data_maps`(`id`, `created_time`, `last_updated_time`, `map_key`, `target_config`) VALUES ('map-instance-tenant-app-employee-security-man', '2021-01-01 00:00:01', '2021-01-01 00:00:01', 'tenant-app-employee', '{\"jdbcConnection\":{\"driverClass\":\"com.mysql.jdbc.Driver\",\"password\":\"Prega_security#202110\",\"poolSize\":\"200\",\"sqlParserBeanName\":\"MySql_SqlParser\",\"url\":\"jdbc:mysql://192.168.0.20:3300/prega_securityflow?useUnicode=true&characterEncoding=utf8&useSSL=false\",\"username\":\"prega_security\"},\"tableMap\":{\"autoMap\":false,\"columns\":[{\"fieldName\":\"id\",\"fixedValue\":\"#{id}--__qFCcCnozYNwzoG3O6Ms\",\"onlyForNew\":false},{\"fieldName\":\"item_pirture\",\"fixedValue\":\"#{one_inch_color_white_photo}\",\"onlyForNew\":false},{\"fieldName\":\"item_leavedate\",\"fixedValue\":\"#{leave_date}\",\"onlyForNew\":false},{\"fieldName\":\"item_deptid\",\"fixedValue\":\"#{depart_id}\",\"onlyForNew\":false},{\"fieldName\":\"item_phone\",\"fixedValue\":\"#{telephone}\",\"onlyForNew\":false},{\"fieldName\":\"item_jobtype\",\"fixedValue\":\"#{occupation_type}\",\"onlyForNew\":false},{\"fieldName\":\"item_deptname\",\"fixedValue\":\"#{depart_name}\",\"onlyForNew\":false},{\"fieldName\":\"item_userid\",\"fixedValue\":\"#{id}\",\"onlyForNew\":false},{\"fieldName\":\"item_securityname\",\"fixedValue\":\"#{name}\",\"onlyForNew\":false},{\"fieldName\":\"item_isinmycompany\",\"fixedValue\":\"#{is_in_mycompany}\",\"onlyForNew\":false},{\"fieldName\":\"item_companyname\",\"fixedValue\":\"#{company_name}\",\"onlyForNew\":false},{\"fieldName\":\"item_iscertified\",\"fixedValue\":\"#{is_certified}\",\"onlyForNew\":false},{\"fieldName\":\"item_lastauthtime\",\"fixedValue\":\"#{last_auth_time}\",\"onlyForNew\":false},{\"fieldName\":\"item_documenttype\",\"fixedValue\":\"#{credential_type}\",\"onlyForNew\":false},{\"fieldName\":\"item_documentid\",\"fixedValue\":\"#{credential_number}\",\"onlyForNew\":false},{\"fieldName\":\"item_entrydate\",\"fixedValue\":\"#{hired_date}\",\"onlyForNew\":false},{\"fieldName\":\"item_domain_id\",\"fixedValue\":\"#{organization_id}\",\"onlyForNew\":false},{\"fieldName\":\"item_insure\",\"fixedValue\":\"#{insure}\",\"onlyForNew\":false},{\"fieldName\":\"item_birthdate\",\"fixedValue\":\"#{birth_date}\",\"onlyForNew\":false},{\"fieldName\":\"item_sex\",\"fixedValue\":\"#{sex}\",\"onlyForNew\":false},{\"fieldName\":\"item_nationality\",\"fixedValue\":\"xxx\",\"onlyForNew\":false},{\"fieldName\":\"item_education\",\"fixedValue\":\"#{education}\",\"onlyForNew\":false},{\"fieldName\":\"item_height\",\"fixedValue\":\"#{stature}\",\"onlyForNew\":false},{\"fieldName\":\"item_bloodtype\",\"fixedValue\":\"#{blood_type}\",\"onlyForNew\":false},{\"fieldName\":\"item_nation\",\"fixedValue\":\"#{nation}\",\"onlyForNew\":false},{\"fieldName\":\"item_politicaloutlook\",\"fixedValue\":\"#{politics_status}\",\"onlyForNew\":false},{\"fieldName\":\"item_maritalstatus\",\"fixedValue\":\"#{military_status}\",\"onlyForNew\":false},{\"fieldName\":\"item_homeaddress\",\"fixedValue\":\"#{home_address}\",\"onlyForNew\":false},{\"fieldName\":\"item_householdtype\",\"fixedValue\":\"#{household_type}\",\"onlyForNew\":false},{\"fieldName\":\"item_emergencycontact\",\"fixedValue\":\"#{emergency_contact}\",\"onlyForNew\":false},{\"fieldName\":\"item_emergencyphone\",\"fixedValue\":\"#{emergency_phone}\",\"onlyForNew\":false},{\"fieldName\":\"item_licenselevel\",\"fixedValue\":\"#{license_level}\",\"onlyForNew\":false},{\"fieldName\":\"item_isveteran\",\"fixedValue\":\"#{is_veteran}\",\"onlyForNew\":false},{\"fieldName\":\"item_workyears\",\"fixedValue\":\"#{work_years}\",\"onlyForNew\":false},{\"fieldName\":\"item_diseasehistory\",\"fixedValue\":\"#{disease_history}\",\"onlyForNew\":false},{\"fieldName\":\"item_idfacephoto\",\"fixedValue\":\"#{id_face_photo}\",\"onlyForNew\":false},{\"fieldName\":\"item_idnationphoto\",\"fixedValue\":\"#{id_nation_photo}\",\"onlyForNew\":false},{\"fieldName\":\"item_idvalidations\",\"fixedValue\":\"#{id_validation_s}\",\"onlyForNew\":false},{\"fieldName\":\"item_idvalidatione\",\"fixedValue\":\"#{id_validation_e}\",\"onlyForNew\":false},{\"fieldName\":\"item_idaddress\",\"fixedValue\":\"#{id_validation_e}\",\"onlyForNew\":false},{\"fieldName\":\"item_headphoto\",\"fixedValue\":\"#{one_inch_color_white_photo}\",\"onlyForNew\":false},{\"fieldName\":\"item_shiming\",\"fixedValue\":\"#{shi_ming}\",\"onlyForNew\":false},{\"fieldName\":\"item_beizhu\",\"fixedValue\":\"#{remark}\",\"onlyForNew\":false}],\"tableName\":\"tlk_securityman\"},' );