|
|
# 工商主体-分支机构
|
|
|
|
|
|
# 数据存储
|
|
|
|
|
|
* host: s-uf679e7a2557fa84.mongodb.rds.aliyuncs.com:3717,s-uf61ad41d3e0fe14.mongodb.rds.aliyuncs.com:3717
|
|
|
* username: ***
|
|
|
* password: ***
|
|
|
* database: utn_ic
|
|
|
* collection: ic、company_branch(推荐使用)
|
|
|
|
|
|
# 说明
|
|
|
|
|
|
## ic.branches
|
|
|
|
|
|
ic表的branches列表字段是爬虫爬取的工商展示的分支机构
|
|
|
|
|
|
## ic.n_branches
|
|
|
|
|
|
ic表的n_branches列表字段是工商展示分支机构+名称解析处理合并之后的结果
|
|
|
|
|
|
## company_branch表
|
|
|
|
|
|
将ic.n_branches列表独立存表,一条记录为一个公司的一个分支机构
|
|
|
|
|
|
# 数据结构
|
|
|
|
|
|
## ic表
|
|
|
|
|
|
```json
|
|
|
{
|
|
|
"n_branches": [
|
|
|
{
|
|
|
"branch_name": "分支机构名称",
|
|
|
"branch_code": "分支机构注册号",
|
|
|
"branch_credit_no": "分支机构统一信用代码",
|
|
|
"authority": "分支机构登记机关",
|
|
|
"company_name_digest": "分支机构的主键",
|
|
|
"establish_date": "分支机构成立日期",
|
|
|
"company_status": "分支机构登记状态",
|
|
|
"n_company_status": "归类后的分支机构登记状态",
|
|
|
"cancel_date": "分支机构注销日期",
|
|
|
"revoke_date": "分支机构吊销日期"
|
|
|
},
|
|
|
...,
|
|
|
|
|
|
],
|
|
|
"n_branch_size": "n_branches列表大小"
|
|
|
}
|
|
|
```
|
|
|
|
|
|
## company_branch表
|
|
|
|
|
|
```json
|
|
|
{
|
|
|
"branch_name": "分支机构名称",
|
|
|
"branch_code": "分支机构注册号",
|
|
|
"branch_credit_no": "分支机构统一信用代码",
|
|
|
"authority": "分支机构登记机关",
|
|
|
"branch_name_digest": "分支机构的主键",
|
|
|
"company_name_digest": "母公司主键digest",
|
|
|
"establish_date": "分支机构成立日期",
|
|
|
"company_status": "分支机构登记状态",
|
|
|
"n_company_status": "归类后的分支机构登记状态",
|
|
|
"cancel_date": "分支机构注销日期",
|
|
|
"revoke_date": "分支机构吊销日期",
|
|
|
"create_time": "入库时间",
|
|
|
"lastupdatetime": "最后更新时间"
|
|
|
}
|
|
|
```
|
|
|
|
|
|
# 数据字典
|
|
|
|
|
|
## company_branch表
|
|
|
|
|
|
| 字段名 | 字段类型 | 描述 |
|
|
|
| ------ | ------ | ------ |
|
|
|
| branch_name | string | 分支机构名称 |
|
|
|
| branch_code | string | 分支机构注册号 |
|
|
|
| branch_credit_no | string | 分支机构统一信用代码 |
|
|
|
| authority | string | 分支机构登记机关 |
|
|
|
| branch_name_digest | string | 分支机构的主键 |
|
|
|
| company_name_digest | string | 母公司主键digest |
|
|
|
| establish_date | date | 分支机构成立日期 |
|
|
|
| company_status | string | 分支机构登记状态 |
|
|
|
| n_company_status | string | 归类后的分支机构登记状态 |
|
|
|
| cancel_date | date | 分支机构注销日期 |
|
|
|
| revoke_date | date | 分支机构吊销日期 |
|
|
|
| create_time | date | 入库时间 |
|
|
|
| lastupdatetime | date | 最后更新时间 |
|
|
|
|
|
|
|
|
|
# 使用说明
|
|
|
|
|
|
* 查询企业当前的分支机构,应该选择n_company_status = '正常'
|
|
|
* 查询企业的历史分支机构,应该选择n_company_status != '正常' |
|
|
\ No newline at end of file |