|
|
|
# 工商-司法协助
|
|
|
|
|
|
|
|
司法协助包括股权冻结和股权变更
|
|
|
|
|
|
|
|
# 数据存储
|
|
|
|
|
|
|
|
* host: s-uf679e7a2557fa84.mongodb.rds.aliyuncs.com:3717,s-uf61ad41d3e0fe14.mongodb.rds.aliyuncs.com:3717
|
|
|
|
* username: ***
|
|
|
|
* password: ***
|
|
|
|
* database: utn_ic
|
|
|
|
* collection: ic、company_justice（推荐使用）
|
|
|
|
|
|
|
|
# 数据结构
|
|
|
|
|
|
|
|
## ic表
|
|
|
|
|
|
|
|
```json
|
|
|
|
{
|
|
|
|
"justices": [
|
|
|
|
{
|
|
|
|
"executee": "被执行人",
|
|
|
|
"equity_amount": "股权数额",
|
|
|
|
"exec_court": "执行法院",
|
|
|
|
"doc_no": "执行通知书文号",
|
|
|
|
"equity_status": "类型 丨 状态",
|
|
|
|
"unit": "数额币种",
|
|
|
|
"freeze_info": {
|
|
|
|
"executee": "被执行人",
|
|
|
|
"equity_amount": "股权数额",
|
|
|
|
"exec_court": "执行法院",
|
|
|
|
"doc_no": "执行通知书文号",
|
|
|
|
"exec_no": "执行裁定书文号",
|
|
|
|
"executee_identify_type": "被执行人证件类型",
|
|
|
|
"executee_identify_no": "被执行人证件号码",
|
|
|
|
"exec_item": "执行事项",
|
|
|
|
"freeze_start_date": "冻结期限自",
|
|
|
|
"freeze_end_date": "冻结期限至",
|
|
|
|
"freeze_years": "冻结期限",
|
|
|
|
"public_date": "公示日期"
|
|
|
|
},
|
|
|
|
"unfreeze_info": {
|
|
|
|
"unfreeze_exec_court": "执行法院",
|
|
|
|
"unfreeze_exec_item": "执行事项",
|
|
|
|
"unfreeze_exec_no": "执行裁定书文号",
|
|
|
|
"unfreeze_doc_no": "执行通知书文号",
|
|
|
|
"unfreeze_executee": "被执行人",
|
|
|
|
"unfreeze_equity_amount": "股权数额",
|
|
|
|
"unfreeze_executee_identify_type": "被执行人证件类型",
|
|
|
|
"unfreeze_executee_identify_no": "被执行人证件号码",
|
|
|
|
"unfreeze_date": "解除冻结日期",
|
|
|
|
"unfreeze_public_date": "公示日期"
|
|
|
|
},
|
|
|
|
"keep_freeze_info": {
|
|
|
|
"executee": "被执行人",
|
|
|
|
"equity_amount": "股权数额",
|
|
|
|
"exec_court": "执行法院",
|
|
|
|
"doc_no": "执行通知书文号",
|
|
|
|
"exec_no": "执行裁定书文号",
|
|
|
|
"executee_identify_type": "被执行人证件类型",
|
|
|
|
"executee_identify_no": "被执行人证件号码",
|
|
|
|
"exec_item": "执行事项",
|
|
|
|
"freeze_start_date": "续行冻结期限自",
|
|
|
|
"freeze_end_date": "续行冻结期限至",
|
|
|
|
"freeze_years": "续行冻结期限",
|
|
|
|
"public_date": "公示日期"
|
|
|
|
},
|
|
|
|
"change_info": {
|
|
|
|
"exec_item": "执行事项",
|
|
|
|
"executee": "被执行人",
|
|
|
|
"executee_identify_type": "被执行人证件类型",
|
|
|
|
"executee_identify_no": "被执行人证件号码",
|
|
|
|
"equity_amount": "股权数额",
|
|
|
|
"exec_court": "执行法院",
|
|
|
|
"doc_no": "执行通知书文号",
|
|
|
|
"exec_no": "执行裁定书文号",
|
|
|
|
"exec_date": "执行日期",
|
|
|
|
"accepter": "受让人",
|
|
|
|
"accepter_identify_type": "受让人证件类型",
|
|
|
|
"accepter_identify_no": "受让人证件号码"
|
|
|
|
},
|
|
|
|
"invalid_info": {
|
|
|
|
"invalid_date": "失效时间",
|
|
|
|
"invalid_reason": "失效原因"
|
|
|
|
}
|
|
|
|
},
|
|
|
|
...
|
|
|
|
],
|
|
|
|
"justice_size": "司法协助条数"
|
|
|
|
}
|
|
|
|
```
|
|
|
|
|
|
|
|
# company_justice表
|
|
|
|
|
|
|
|
```json
|
|
|
|
{
|
|
|
|
"company_name_digest": "主体唯一键",
|
|
|
|
"justice_record": "司法协助记录MD5值",
|
|
|
|
"executee": "被执行人",
|
|
|
|
"equity_amount": "股权数额",
|
|
|
|
"exec_court": "执行法院",
|
|
|
|
"doc_no": "执行通知书文号",
|
|
|
|
"equity_status": "类型 丨 状态",
|
|
|
|
"unit": "数额币种",
|
|
|
|
"is_history": "是否是历史,1:历史司法协助,0:当前司法协助(与工商一致)",
|
|
|
|
"freeze_info": {
|
|
|
|
"executee": "被执行人",
|
|
|
|
"equity_amount": "股权数额",
|
|
|
|
"exec_court": "执行法院",
|
|
|
|
"doc_no": "执行通知书文号",
|
|
|
|
"exec_no": "执行裁定书文号",
|
|
|
|
"executee_identify_type": "被执行人证件类型",
|
|
|
|
"executee_identify_no": "被执行人证件号码",
|
|
|
|
"exec_item": "执行事项",
|
|
|
|
"freeze_start_date": "冻结期限自",
|
|
|
|
"freeze_end_date": "冻结期限至",
|
|
|
|
"freeze_years": "冻结期限",
|
|
|
|
"public_date": "公示日期"
|
|
|
|
},
|
|
|
|
"unfreeze_info": {
|
|
|
|
"unfreeze_exec_court": "执行法院",
|
|
|
|
"unfreeze_exec_item": "执行事项",
|
|
|
|
"unfreeze_exec_no": "执行裁定书文号",
|
|
|
|
"unfreeze_doc_no": "执行通知书文号",
|
|
|
|
"unfreeze_executee": "被执行人",
|
|
|
|
"unfreeze_equity_amount": "股权数额",
|
|
|
|
"unfreeze_executee_identify_type": "被执行人证件类型",
|
|
|
|
"unfreeze_executee_identify_no": "被执行人证件号码",
|
|
|
|
"unfreeze_date": "解除冻结日期",
|
|
|
|
"unfreeze_public_date": "公示日期"
|
|
|
|
},
|
|
|
|
"keep_freeze_info": {
|
|
|
|
"executee": "被执行人",
|
|
|
|
"equity_amount": "股权数额",
|
|
|
|
"exec_court": "执行法院",
|
|
|
|
"doc_no": "执行通知书文号",
|
|
|
|
"exec_no": "执行裁定书文号",
|
|
|
|
"executee_identify_type": "被执行人证件类型",
|
|
|
|
"executee_identify_no": "被执行人证件号码",
|
|
|
|
"exec_item": "执行事项",
|
|
|
|
"freeze_start_date": "续行冻结期限自",
|
|
|
|
"freeze_end_date": "续行冻结期限至",
|
|
|
|
"freeze_years": "续行冻结期限",
|
|
|
|
"public_date": "公示日期"
|
|
|
|
},
|
|
|
|
"change_info": {
|
|
|
|
"exec_item": "执行事项",
|
|
|
|
"executee": "被执行人",
|
|
|
|
"executee_identify_type": "被执行人证件类型",
|
|
|
|
"executee_identify_no": "被执行人证件号码",
|
|
|
|
"equity_amount": "股权数额",
|
|
|
|
"exec_court": "执行法院",
|
|
|
|
"doc_no": "执行通知书文号",
|
|
|
|
"exec_no": "执行裁定书文号",
|
|
|
|
"exec_date": "执行日期",
|
|
|
|
"accepter": "受让人",
|
|
|
|
"accepter_identify_type": "受让人证件类型",
|
|
|
|
"accepter_identify_no": "受让人证件号码"
|
|
|
|
},
|
|
|
|
"invalid_info": {
|
|
|
|
"invalid_date": "失效时间",
|
|
|
|
"invalid_reason": "失效原因"
|
|
|
|
}
|
|
|
|
}
|
|
|
|
```
|
|
|
|
|
|
|
|
# 数据字典
|
|
|
|
|
|
|
|
## 司法协助
|
|
|
|
|
|
|
|
| 字段名 | 字段类型 | 描述 |
|
|
|
|
| ------ | ------ | ------ |
|
|
|
|
| company_name_digest | string | 主体唯一键 |
|
|
|
|
| justice_record | string | 司法协助记录MD5值 |
|
|
|
|
| executee | string | 被执行人 |
|
|
|
|
| equity_amount | string | 股权数额 |
|
|
|
|
| exec_court | string | 执行法院 |
|
|
|
|
| doc_no | string | 执行通知书文号 |
|
|
|
|
| equity_status | string | 类型 丨 状态 |
|
|
|
|
| unit | string | 数额币种 |
|
|
|
|
| is_history | int | 是否是历史,1:历史司法协助,0:当前司法协助(与工商一致) |
|
|
|
|
| freeze_info | object | 股权冻结信息 |
|
|
|
|
| unfreeze_info | object | 解除冻结信息 |
|
|
|
|
| keep_freeze_info | object | 续行冻结信息 |
|
|
|
|
| change_info | object | 股权变更信息 |
|
|
|
|
| invalid_info | object | 失效信息 |
|
|
|
|
|
|
|
|
## 司法协助-冻结信息
|
|
|
|
|
|
|
|
| 字段名 | 字段类型 | 描述 |
|
|
|
|
| ------ | ------ | ------ |
|
|
|
|
| executee | string | 被执行人 |
|
|
|
|
| equity_amount | string | 股权数额 |
|
|
|
|
| exec_court | string | 执行法院 |
|
|
|
|
| doc_no | string | 执行通知书文号 |
|
|
|
|
| exec_no | string | 执行裁定书文号 |
|
|
|
|
| executee_identify_type | string | 被执行人证件类型 |
|
|
|
|
| executee_identify_no | string | 被执行人证件号码 |
|
|
|
|
| exec_item | string | 执行事项 |
|
|
|
|
| freeze_start_date | date | 冻结期限自 |
|
|
|
|
| freeze_end_date | date | 冻结期限至 |
|
|
|
|
| freeze_years | date | 冻结期限 |
|
|
|
|
| public_date | date | 公示日期 |
|
|
|
|
|
|
|
|
## 司法协助-解冻信息
|
|
|
|
|
|
|
|
| 字段名 | 字段类型 | 描述 |
|
|
|
|
| ------ | ------ | ------ |
|
|
|
|
| unfreeze_exec_court | string | 执行法院 |
|
|
|
|
| unfreeze_exec_item | string | 执行事项 |
|
|
|
|
| unfreeze_exec_no | string | 执行裁定书文号 |
|
|
|
|
| unfreeze_doc_no | string | 执行通知书文号 |
|
|
|
|
| unfreeze_executee | string | 被执行人 |
|
|
|
|
| unfreeze_equity_amount | string | 股权数额 |
|
|
|
|
| unfreeze_executee_identify_type | string | 被执行人证件类型 |
|
|
|
|
| unfreeze_executee_identify_no | string | 被执行人证件号码 |
|
|
|
|
| unfreeze_date | date | 解除冻结日期 |
|
|
|
|
| unfreeze_public_date | date | 公示日期 |
|
|
|
|
|
|
|
|
## 司法协助-续行冻结信息
|
|
|
|
|
|
|
|
| 字段名 | 字段类型 | 描述 |
|
|
|
|
| ------ | ------ | ------ |
|
|
|
|
| executee | string | 被执行人 |
|
|
|
|
| equity_amount | string | 股权数额 |
|
|
|
|
| exec_court | string | 执行法院 |
|
|
|
|
| doc_no | string | 执行通知书文号 |
|
|
|
|
| exec_no | string | 执行裁定书文号 |
|
|
|
|
| executee_identify_type | string | 被执行人证件类型 |
|
|
|
|
| executee_identify_no | string | 被执行人证件号码 |
|
|
|
|
| exec_item | string | 执行事项 |
|
|
|
|
| freeze_start_date | date | 续行冻结期限自 |
|
|
|
|
| freeze_end_date | date | 续行冻结期限至 |
|
|
|
|
| freeze_years | string | 续行冻结期限 |
|
|
|
|
| public_date | date | 公示日期 |
|
|
|
|
|
|
|
|
## 司法协助-股权变更信息
|
|
|
|
|
|
|
|
| 字段名 | 字段类型 | 描述 |
|
|
|
|
| ------ | ------ | ------ |
|
|
|
|
| exec_item | string | 执行事项 |
|
|
|
|
| executee | string | 被执行人 |
|
|
|
|
| executee_identify_type | string | 被执行人证件类型 |
|
|
|
|
| executee_identify_no | string | 被执行人证件号码 |
|
|
|
|
| equity_amount | string | 股权数额 |
|
|
|
|
| exec_court | string | 执行法院 |
|
|
|
|
| doc_no | string | 执行通知书文号 |
|
|
|
|
| exec_no | string | 执行裁定书文号 |
|
|
|
|
| exec_date | date | 执行日期 |
|
|
|
|
| accepter | string | 受让人 |
|
|
|
|
| accepter_identify_type | string | 受让人证件类型 |
|
|
|
|
| accepter_identify_no | string | 受让人证件号码 |
|
|
|
|
|
|
|
|
## 司法协助-失效信息
|
|
|
|
|
|
|
|
| 字段名 | 字段类型 | 描述 |
|
|
|
|
| ------ | ------ | ------ |
|
|
|
|
| invalid_date | date | 失效时间 |
|
|
|
|
| invalid_reason | string | 失效原因 |
|
|
|
|
|
|
|
|
# 说明
|
|
|
|
|
|
|
|
* company_justice表中以company_name_digest+justice_record作为唯一键
|
|
|
|
* 对于股权变更信息，justice_record由 被执行人+股权数额+执行法院+执行通知书文号+执行裁定书文号+执行日期+受让人 拼接成的字符串MD5获得
|
|
|
|
* 对于其他信息， justice_record由 被执行人+股权数额+执行法院+执行通知书文号+执行裁定书文号 拼接成的字符串MD5获得
|
|
|
|
* company_justice表中的is_history=1时表示公示系统已删除该条记录
|
|
|
|
|
