Skip to content

GitLab

ic_partner · Changes

Page history
搬运lake.wiki中的内容 authored by 吴一博's avatar 吴一博
Hide whitespace changes
Inline Side-by-side
Showing with 249 additions and 0 deletions
lake/ic_partner.md 0 → 100644
View page @ 06367b0a
# 工商主体-股东信息
股东信息的相关流程包括：股比计算、更新及保留历史股东、更新及保留历史对外投资
# 数据存储
股东信息存储在两个地方，ic表的partners字段存储当前股东列表， company_partner_new表用来查询企业当前股东、对外投资、历史股东、历史对外投资
* host: s-uf679e7a2557fa84.mongodb.rds.aliyuncs.com:3717,s-uf61ad41d3e0fe14.mongodb.rds.aliyuncs.com:3717
* username: ***
* password: ***
* database: utn_ic
* collection: ic、company_partner_new(推荐使用该表)
# 数据结构
## utn_ic.ic
```json
{
"partners": [
{
"stock_name": "股东名称",
"stock_type": "股东类型",
"stock_capital": "应缴出资额",
"identify_type": "股东证件类型",
"identify_no": "股东证件号码",
"stock_realcapital": "实缴出资额",
"stock_proportion": "股权占比",
"source": "数据来源",
"company_name": "企业名称",
"company_name_digest": "企业唯一键",
"is_personal": "是否是自然人",
"stock_name_digest": "非自然人股东的company_name_digest",
"person_id": "自然人股东去重名id",
"control_partner": "是否是控股股东（股比最大的股东）",
"create_time": "创建时间",
"lastupdatetime": "最后更新时间",
"pays": [
{
"stock_capital": "应缴出资额",
"invest_type": "应缴出资方式",
"stock_date": "应缴出资日期"
},
...
],
"pay_size": "应缴明细列表大小",
"realpays": [
{
"stock_realcapital": "实缴出资额",
"invest_realtype": "实缴出资方式",
"stock_realdate": "实缴出资日期"
},
...
],
"realpay_size": "实缴明细列表大小"
},
...
],
"partner_size": "股东列表大小"
}
```
* ic表中的股东列表为工商公示的当前股东列表，不含历史股东，信息可能与企业自主公示股东、年报股东信息不同
## utn_ic.company_partner_new
```json
{
"stock_name": "股东名称",
"stock_type": "股东类型",
"stock_capital": "应缴出资额",
"identify_type": "股东证件类型",
"identify_no": "股东证件号码",
"stock_realcapital": "实缴出资额",
"stock_proportion": "股权占比",
"source": "数据来源",
"company_name": "企业名称",
"company_name_digest": "企业唯一键",
"is_personal": "是否是自然人",
"stock_name_digest": "非自然人股东的company_name_digest",
"person_id": "自然人股东去重名id",
"control_partner": "是否是控股股东（股比最大的股东）",
"create_time": "创建时间",
"lastupdatetime": "最后更新时间",
"pays": [
{
"stock_capital": "应缴出资额",
"invest_type": "应缴出资方式",
"stock_date": "应缴出资日期"
},
...
],
"pay_size": "应缴明细列表大小",
"realpays": [
{
"stock_realcapital": "实缴出资额",
"invest_realtype": "实缴出资方式",
"stock_realdate": "实缴出资日期"
},
...
],
"realpay_size": "实缴明细列表大小",
"is_history": "是否历史数据",
"deleted": "是否删除",
"remove_date": "退出日期",
"include_date": "进入日期"
}
```
## 数据字典
| 字段名 | 字段类型 | 注释 |
| ------ | ------ | ------ |
| stock_name | string | 股东名称 |
| stock_type | string | 股东类型 |
| stock_capital | double/int/string | 应缴出资额 |
| identify_type | string | 股东证件类型 |
| identify_no | string | 股东证件号码 |
| stock_realcapital | double/int/string | 实缴出资额 |
| stock_proportion | double | 股权占比 |
| source | int | 数据来源 |
| company_name | string | 企业名称 |
| company_name_digest | string | 企业唯一键 |
| is_personal | int | 是否是自然人 |
| stock_name_digest | string | 非自然人股东的company_name_digest |
| person_id | string | 自然人股东去重名id |
| control_partner | int | 是否是控股股东（股比最大的股东） |
| create_time | date | 创建时间 |
| lastupdatetime | date | 最后更新时间 |
| pays | array | 应缴明细列表 |
| pay_size | int | 应缴明细列表大小 |
| realpays | array | 实缴明细列表 |
| realpay_size | int | 实缴明细列表大小 |
| is_history | int | 是否历史数据，1：历史股东 0：当前股东 |
| deleted | int | 是否删除， 1：删除 0:未删除 |
| remove_date | date | 退出日期 |
| include_date | date | 进入日期 |
### pays
| 字段名 | 字段类型 | 注释 |
| ------ | ------ | ------ |
| stock_capital | double/int/string | 应缴出资额 |
| invest_type | string | 应缴出资方式 |
| stock_date | date | 应缴出资日期 |
### realpays
| 字段名 | 字段类型 | 注释 |
| ------ | ------ | ------ |
| stock_realcapital | double/int/string | 实缴出资额 |
| invest_realtype | string | 实缴出资方式 |
| stock_realdate | date | 实缴出资日期 |
## 样例
```json
{
"_id" : ObjectId("60057181edfcd710473f5de5"),
"stock_name" : "赵海亮",
"partner_no" : 1,
"stock_type" : "自然人股东",
"stock_realcapital" : 0,
"realpay_size" : 0,
"realpays" : [ ],
"stock_proportion" : 1,
"stock_capital" : 50,
"pay_size" : 1,
"pays" : [
{
"pay_no" : 1,
"invest_type" : "货币",
"stock_capital" : 50,
"stock_date" : null
}
],
"invest_type" : "货币",
"country" : "中国",
"stock_capital_num" : 50,
"stock_capital_unit" : null,
"control_partner" : 1,
"company_name" : "上海玥量品牌管理有限公司",
"company_name_digest" : "f12cbd656992c4982baa4ebc22b1bc01",
"create_time" : ISODate("2021-01-19T03:31:13.256+08:00"),
"lastupdatetime" : ISODate("2021-01-19T03:31:13.256+08:00"),
"is_history" : 0,
"is_personal" : 1,
"deleted" : 0
},
{
"_id" : ObjectId("5d6b76f09648334e47a7d932"),
"stock_name" : "常振忠",
"realpay_size" : 1,
"stock_realcapital" : "30.0",
"identify_no" : "非公示项",
"pays" : [
{
"stock_capital" : "30",
"pay_no" : 1
}
],
"identify_type" : null,
"source" : 2,
"stock_type" : "自然人股东",
"pay_size" : 1,
"stock_capital_amount" : 30,
"realpays" : [
{
"stock_realcapital" : "30",
"realpay_no" : 1
}
],
"partner_no" : 1,
"stock_capital" : "30.0",
"stock_realcapital_amount" : 30,
"stock_proportion" : 0.14285714285714285,
"company_name" : "陵川县泉头永和养殖专业合作社",
"company_name_digest" : "2c98bf4a66be3b2d8fff10be746268a7",
"create_time" : ISODate("2018-05-19T23:42:49.910+08:00"),
"lastupdatetime" : ISODate("2019-08-31T17:40:06.953+08:00"),
"deleted" : 1,
"is_history" : 1,
"is_personal" : 1
}
```
# 说明
* company_partner_new表是由ic表中的partners列表生成，即更新ic表时同时将股东列表根据company_name_digest更新进company_partner_new表
* company_partner_new表存在的初衷是根据stock_name反查对外投资
* 最初company_partner_new的更新逻辑是先将表中已有的股东设为删除状态（deleted=1），然后再将所有股东新增入表，后来改为直接物理删除再将所有股东新增入表
* 现有的产品应用中查询企业对外投资时都会将deleted=1的数据过滤掉，即条件stock_name = "企业名称" and deleted != 1 查询企业当前的对外投资
* 通过is_history区分是否是历史股东
* 数据处理时，历史数据必须有deleted=1
* 由于公司名有更名的情况，查询公司的对外投资时根据company_name_digest（stock_name_digest）查询
应用场景及查询方法有：
* 历史股东：company_name_digest = "{digest}" and is_history = 1
* 历史对外投资： stock_name_digest = "{company_name_digest}" and is_history = 1
* 当前对外投资： stock_name_digest = "{company_name_digest}" and is_history != 1
* 当前股东：company_name_digest = "{digest}" and deleted != 1 或者 company_name_digest = "{digest}" and is_history != 1 （推荐）
## 股比计算
## 实缴出资额
# lake-mysql