代码地址
udm: http://tech.pingansec.com/granite/project-collie-app/-/tree/master/app_certificate/udms/qxb_certificate
data_pump: http://tech.pingansec.com/granite/project-collie-app/-/blob/master/app_certificate/data_pump/qxb_certificate.yml
部署地址
host: 10.8.6.84
path: /home/collie/product/app_certificate
部署方法及说明
数据接收来源
启信宝推送文件
文件类型：json文件，文件名中包含certificate
文件路径: /data3_227/qxb_data/json
数据存储地址
内部业务表：
* 数据库地址：bdp-rds-003.mysql.rds.aliyuncs.com
* 数据库名：utn_ng_biz_info
* 表名：
(1) tb_certificate
(2) tb_certificate_detail
对外输出表：
* 数据库地址：10.8.6.87
* 数据库名：utn_ng_biz_info
* 表名：
(1) tb_certificate
(2) tb_certificate_detail
业务表结构
CREATE TABLE `tb_certificate` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID-自增序列',
`unique_id` char(32) NOT NULL COMMENT '证书名称+编号+企业名称+发证日期的MD5',
`cert_type` varchar(255) DEFAULT NULL COMMENT '证书名称，',
`cert_no` varchar(255) DEFAULT NULL COMMENT '许可编号',
`company_name` varchar(255) NOT NULL COMMENT '企业名称',
`company_name_digest` char(32) DEFAULT NULL COMMENT '主体唯一键',
`company_id` char(32) DEFAULT NULL COMMENT '主体唯一键',
`grade` varchar(127) DEFAULT NULL COMMENT '资质等级（列表）',
`responsible_person` varchar(127) DEFAULT NULL COMMENT '企业负责人',
`lic_text` varchar(2000) DEFAULT NULL COMMENT '许可内容',
`org_an` varchar(255) DEFAULT NULL COMMENT '发证单位',
`sv_dep` varchar(255) DEFAULT NULL COMMENT '监制部门',
`issue_date` date DEFAULT NULL COMMENT '发证日期',
`start_date` date DEFAULT NULL COMMENT '开始日期',
`end_date` date DEFAULT NULL COMMENT '截止日期',
`source_url` varchar(1000) DEFAULT NULL COMMENT '原始链接URL',
`use_flag` tinyint(4) DEFAULT '0' COMMENT '使用标记，10废弃删除',
`is_history` tinyint(4) DEFAULT '0' COMMENT '是否是历史数据，1历史数据',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_unique_id` (`unique_id`) USING BTREE,
KEY `idx_company` (`company_name`) USING BTREE,
KEY `idx_company_digest` (`company_name_digest`) USING BTREE,
KEY `idx_create_time` (`create_time`) USING BTREE,
KEY `idx_update_time` (`update_time`) USING BTREE,
KEY `idx_cert_no` (`cert_no`),
KEY `idx_cert_type` (`cert_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='资质证书主表';
CREATE TABLE `tb_certificate_detail` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID-自增序列',
`unique_id` char(32) NOT NULL COMMENT '证书名称+编号+企业名称+发证日期的MD5',
`detail_record` char(32) NOT NULL COMMENT '字段分类+字段名的MD5',
`field_class` varchar(255) DEFAULT '资质信息' COMMENT '明细字段分类值',
`field_name` varchar(255) DEFAULT NULL COMMENT '中文字段名',
`field_value` varchar(4000) DEFAULT NULL COMMENT '数据值',
`use_flag` tinyint(4) DEFAULT '0' COMMENT '使用标记，10废弃删除',
`is_history` tinyint(4) DEFAULT '0' COMMENT '是否是历史数据，1历史数据',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_cert_detail` (`unique_id`,`detail_record`) USING BTREE,
KEY `idx_create_time` (`create_time`) USING BTREE,
KEY `idx_update_time` (`update_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='资质信息明细';
数据样例
{
"GAP_no": "",
"_id": "5a62642bdb5ca099ca312560",
"accessory": "",
"address": "",
"agency": "",
"agency_address": "",
"agency_people": "",
"agent_info": "{\"agency_status\":\"有效\",\"agency_name\":\"中国质量认证中心\",\"agency_scope\":\"管理体系认证-质量管理体系认证,管理体系认证-环境管理体系认证,管理体系认证-职业健康安全管理体系认证,管理体系认证-信息安全管理体系认证,管理体系认证-信息技术服务管理体
系认证,服务认证-无形资产和土地服务,服务认证-建筑工程和建筑物服务,服务认证-批发业和零售业服务,服务认证-住宿服务；食品和饮料服务,服务认
证-运输服务（陆路运输服务、水运服务、空运服务、支持性和辅助运输服务）,服务认证-邮政和速递服务,服务认证-电力分配服务；通过主要管道的燃
气和水分分配服务,服务认证-金融中介、保险和辅助服务,服务认证-不动产服务,服务认证-不配备操作员的租赁或出租服务,服务认证-科学研究服务（研究和开发服务；专业、科学和技术服务；其他专业、科学和技术服务）,服务认证-电信服务；信息检索和提供服务,服务认证-支持性服务,服务认证-在收费或合同基础上的生产服务,服务认证-保养和修理服务,服务认证-公共管理和整个社区有关的其他服务；强制性社会保障服务,服务认证-教育服务,服务
认证-卫生保健和社会福利服务,服务认证-污水和垃圾处置、公共卫生及其他环境保护服务,服务认证-成员组织的服务；国外组织和机构的服务,服务认证-娱乐、文化和体育服务,服务认证-家庭服务,产品认证-农林（牧）渔；中药,产品认证-矿和矿物；电力、可燃气和水,产品认证-加工食品、饮料和烟草,产品认证-纺织品、服装和皮革制品,产品认证-木材和木制品；纸浆、纸和纸制品，印刷品,产品认证-化工类产品,产品认证-建材产品,产品认证-家具；
其他未分类产品,产品认证-废旧物资,产品认证-金属材料及金属制品,产品认证-机械设备及零部件,产品认证-电子设备及零部件,产品认证-电动机、发电机、发电成套设备和变压器,产品认证-配电和控制设备及其零件；绝缘电线和电缆；光缆,产品认证-蓄电池、原电池、原电池组和其他电池及其零件,产
品认证-白炽灯泡或放电灯、弧光灯及其附件；照明设备及其附件；其他电气设备及其零件,产品认证-仪器设备,产品认证-陆地交通设备,产品认证-航空
航天设备,产品认证-GB\\/T7635.2中涉及产品形成过程的不可运输产品,国推认证-有机产品（OGA）,国推认证-良好农业规范,国推认证-绿色市场,国推认证-食品安全管理体系,国推认证-危害分析与关键控制点,国推认证-乳制品生产企业危害分析与关键控制点,国推认证-乳制品生产企业良好生产规范,国推认证-低碳产品-通用硅酸盐水泥,国推认证-低碳产品-平板玻璃,国推认证-低碳产品-铝合金建筑型材,国推认证-低碳产品-中小型三相异步电动机,国推认证-低碳产品-陶瓷砖（板）,国推认证-低碳产品-纺织面料,国推认证-低碳产品-轮胎,国推认证-光伏产品,国推认证-电子招投标系统,国推认证-能源管理体系,国推认证-知识产权管理体系,国推认证-绿色产品（认证活动一）-人造板和木质地板,国推认证-绿色产品（认证活动一）-涂料,国推认证-绿色产品（认证活动一）-卫生陶瓷,国推认证-绿色产品（认证活动一）-太阳能热水系统,国推认证-绿色产品（认证活动一）-家具,国推认证-绿色产品（认证活
动一）-绝热材料,国推认证-绿色产品（认证活动一）-防水与密封材料,国推认证-绿色产品（认证活动一）-陶瓷砖（板）,国推认证-绿色产品（认证活
动一）-纺织产品,国推认证-绿色产品（认证活动一）-木塑制品,国推认证-绿色产品（认证活动一）-纸和纸制品,国推认证-绿色产品（认证活动一）-塑料制品,国推认证-绿色产品（认证活动一）-洗涤用品,国推认证-绿色产品（认证活动二）-电器电子产品有害物质限制使用,国推认证-绿色产品（认证活动二）-建材（围护结构及混凝土类）,国推认证-绿色产品（认证活动二）-建材（门窗幕墙及装饰装修类）,国推认证-绿色产品（认证活动二）-建材（
防水密封及建筑涂料类）,国推认证-绿色产品（认证活动二）-建材（给排水及水处理设备类）,国推认证-绿色产品（认证活动二）-建材（暖通空调及太阳能利用与照明类）,国推认证-绿色产品（认证活动二）-快递包装,强制性产品认证\",\"agency_no\":\"CNCA-R-2002-001\",\"agency_address\":\"南四环西路188号9区\",\"agency_domain\":\"www.cqc.com.cn\",\"agency_date\":\"2024-12-10\",\"agency_phone\":\"010-83886666\"}",
"annul_production": "",
"applicant": "",
"applicant_en": "",
"approval_date": "",
"approval_no": "",
"approve_time": "",
"area": "",
"attachment": "",
"attention": "",
"basic_info": "[]",
"batch_validity": "",
"business_address": "",
"business_place": "",
"business_scope": "",
"business_type": "",
"case_no": "",
"category": "",
"cert_change_date": "",
"cert_change_reason": "",
"cert_name": "",
"cert_scope": "",
"cert_type": "",
"certif_scope": "",
"certificate_information": "",
"certification_basis": "",
"change_date": "",
"change_history": "[]",
"change_record": "",
"change_situation": "",
"change_type": "",
"check_conclusion": "",
"check_project": "",
"check_reason": "",
"check_type": "",
"complaint_call": "",
"components": "",
"compositions": "",
"content": "",
"continue_date": "",
"continue_scope": "",
"created_time": "1516397617372",
"credit": "",
"credit_no": "",
"decide_date": "",
"department": "",
"description": "",
"domain_name": "",
"domicile": "",
"drug_standard_code": "",
"economic_nature": "",
"eid": "4e6921e2-84f2-48ab-8e2a-3b44179831dd",
"ename": "天
津富士达集团有限公司",
"ent_reg_no": "",
"enterprise_leader": "",
"entity_caption": "",
"expiry_date": "",
"extend_date": "",
"first_date": "2003-11-04",
"form": "",
"former_name": "",
"fs_manager": "",
"fugai_address": "",
"fugai_scope": "",
"gas_level": "",
"gmp_version": "",
"identity": "",
"industry": "",
"info_type": "",
"institution_name": "",
"is_multiplace": "",
"is_sub_certificate": "",
"issue_agency": "",
"issue_date": "",
"issue_unit": "",
"issuer": "",
"issuing_authority": "",
"last_update_time": "-1",
"last_updated_time": "1639756792732",
"latitude": "",
"legal_rep": "",
"level": "",
"licence_type": "",
"logout_date": "",
"longitude": "",
"mailing_address": "",
"main_certificate": "",
"manage_type": "",
"manufacturer_cn": "",
"manufacturer_en": "",
"market": "",
"md5": "27ab802c67a5387b57088699f6be6efd",
"medicine_type": "",
"mine_name": "",
"mine_scale": "",
"mine_type": "",
"model": "BT110ZH",
"monitoring_times": "",
"name": "",
"note": "",
"ops_flag": "8",
"org_issue_date": "",
"organization_info": "[]",
"other": "",
"pause_end_date": "",
"pause_start_date": "",
"pdf": "",
"people_name": "",
"permit_entity": "",
"permit_remark": "",
"phone": "",
"principal": "",
"principal_info": "{\"name\":\"天津邦德工业股份有限公司\",\"area\":\"中国 天津市\",\"code\":\"741386326\"}",
"pro_type": "1102：摩托车",
"producer_info": "{\"name\":\"天津富士达集团有限公司\",\"area\":\"中国 天津市\",\"code\":\"718259492\"}",
"product": "",
"product_address_cn": "",
"product_company_cn": "",
"product_company_en": "",
"product_name_cn": "",
"product_name_en": "",
"product_type": "",
"production": "[]",
"production_address": "",
"production_info": "[]",
"production_information": "",
"project_note": "",
"province": "",
"pub_date": "",
"public_date": "",
"purpose": "",
"quality_agency": "",
"quality_people": "",
"re_certification_times": "",
"reason": "",
"reg_no": "",
"register_address": "",
"register_no": "2003011102092881",
"related_companies": "[{\"role\":\"\",\"item\":\"4e6921e2-84f2-48ab-8e2a-3b44179831dd\",\"name\":\"天津富士达集团有限公司\",\"type\":\"E\"}]",
"related_database_query": "",
"renzheng_chose": "",
"renzheng_item": "",
"renzheng_level": "",
"renzheng_num": "",
"renzheng_scope": "",
"resp_person": "",
"resp_person_type": "",
"result": "",
"revocation_date": "",
"row_update_time": "2021-12-17 23:59:52",
"safe_level": "",
"sample_grade": "",
"scope": "",
"shangbao_date": "2009-11-27",
"shop_sign": "",
"signer": "",
"situation": "",
"skill": "CNCA-02C-024:2001/A1",
"source": "",
"spec": "",
"standard": "",
"start_date": "",
"state": "撤销",
"state_code": "",
"statement": "",
"storage": "",
"sub_type": "",
"sup_agency": "",
"sup_staff": "",
"tag": "",
"telephone": "",
"ten_requirement": "",
"tips": "",
"trademark_name": "",
"type": "CCC/机动车辆及安全附件",
"u_tags": "",
"unit": "",
"unit_main": "正三轮摩托车",
"unit_se": "Right three-wheeled motorcycle",
"url": "http://cx.cnca.cn/CertECloud/result/queryAuthresult3CDetail?rzjgId=01&certNumber=2003011102092881&showtemp=2&geetest_validate=c6c6cc8950dcdf5399c40f079d968965&geetest_seccode=c6c6cc8950dcdf5399c40f079d968965%7Cjordan&geetest_challenge=5273665aaf06f19fe45b12dabe8eb155",
"valid_date": "",
"valid_date_start": "",
"valid_end": "",
"valid_start": "",
"validity_end": "",
"validity_start": "",
"warehouse_address": "",
"zipcode": "",
"msgType": "UPDATE"
}
lan jianling