Skip to content

GitLab

risk_company_justice · Changes

Page history
update: 司法协助 authored by 李子健's avatar 李子健
Hide whitespace changes
Inline Side-by-side
Showing with 364 additions and 0 deletions
lake/risk_company_justice.md 0 → 100644
View page @ 41d311a8
# 限制高消费
# 存储信息
aliyun-mysql-rds
* host: bdp-rds-001.mysql.rds.aliyuncs.com
* port: 3306
* user: **
* password: **
* database: utn_ng_risk
# 建表语句
```sql
CREATE TABLE if not exists utn_ng_risk.`risk_company_justice` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
`company_name_digest` char(32) NOT NULL COMMENT '主体唯一键',
`justice_record` char(32) NOT NULL COMMENT '司法协助记录，justice_url的md5',
`justice_url` varchar(255) not null comment '记录连接',
`executee` varchar(255) DEFAULT NULL COMMENT '被执行人',
`executee_name_digest` char(32) DEFAULT NULL COMMENT '被执行人为企业时企业唯一键',
`equity_amount` varchar(50) DEFAULT NULL COMMENT '股权数额',
`unit` varchar(50) DEFAULT NULL COMMENT '数额币种',
`exec_court` varchar(100) DEFAULT NULL COMMENT '执行法院',
`doc_no` varchar(200) DEFAULT NULL COMMENT '执行通知书文号',
`equity_status` varchar(200) DEFAULT NULL COMMENT '类型丨状态',
`freeze_doc_no` varchar(200) DEFAULT NULL COMMENT '冻结执行通知书文号',
`freeze_exec_no` varchar(200) DEFAULT NULL COMMENT '冻结执行裁定书文号',
`executee_identify_type` varchar(50) DEFAULT NULL COMMENT '被执行人证件类型',
`executee_identify_no` varchar(50) DEFAULT NULL COMMENT '被执行人证件号码',
`exec_item` varchar(250) DEFAULT NULL COMMENT '冻结执行事项',
`freeze_start_date` date DEFAULT NULL COMMENT '冻结期限自',
`freeze_end_date` date DEFAULT NULL COMMENT '冻结期限至',
`freeze_years` varchar(50) DEFAULT NULL COMMENT '冻结期限',
`public_date` varchar(50) DEFAULT NULL COMMENT '冻结公示日期',
`unfreeze_exec_item` varchar(250) DEFAULT NULL COMMENT '解冻执行事项',
`unfreeze_doc_no` varchar(200) DEFAULT NULL COMMENT '解冻执行通知书文号',
`unfreeze_exec_no` varchar(200) DEFAULT NULL COMMENT '解冻执行裁定书文号',
`unfreeze_date` date DEFAULT NULL COMMENT '解除冻结日期',
`unfreeze_public_date` varchar(50) DEFAULT NULL COMMENT '解冻公示日期',
`keep_freeze_doc_no` varchar(200) DEFAULT NULL COMMENT '续行冻结执行通知书文号',
`keep_freeze_exec_no` varchar(200) DEFAULT NULL COMMENT '续行冻结执行裁定书文号',
`keep_exec_item` varchar(250) DEFAULT NULL COMMENT '续行冻结执行事项',
`keep_freeze_start_date` date DEFAULT NULL COMMENT '续行冻结期限自',
`keep_freeze_end_date` date DEFAULT NULL COMMENT '续行冻结期限至',
`keep_freeze_years` varchar(50) DEFAULT NULL COMMENT '续行冻结期限',
`keep_free_public_date` varchar(50) DEFAULT NULL COMMENT '续行冻结公示日期',
`change_freeze_doc_no` varchar(200) DEFAULT NULL COMMENT '股权变更执行通知书文号',
`change_freeze_exec_no` varchar(200) DEFAULT NULL COMMENT '股权变更执行裁定书文号',
`change_exec_item` varchar(250) DEFAULT NULL COMMENT '股权变更执行事项',
`change_exec_date` date DEFAULT NULL COMMENT '股权变更执行日期',
`accepter` varchar(255) DEFAULT NULL COMMENT '受让人',
`accepter_name_digest` char(32) DEFAULT NULL COMMENT '受让人为企业时企业唯一键',
`accepter_identify_type` varchar(50) DEFAULT NULL COMMENT '受让人证件类型',
`accepter_identify_no` varchar(50) DEFAULT NULL COMMENT '受让人证件号码',
`invalid_date` date DEFAULT NULL COMMENT '失效时间',
`invalid_reason` varchar(255) DEFAULT NULL COMMENT '失效原因',
`is_history` tinyint(4) DEFAULT '0' COMMENT '状态（0: 有效， 1: 历史）',
`use_flag` tinyint(4) DEFAULT '0' COMMENT '使用标记',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '入库时间',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_digest_justice_record` (`company_name_digest`,`justice_record`),
KEY `idx_update_time` (`update_time`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='司法协助';
```
# 数据字典
| 表名 | 字段名 | 字段类型 | 注释 |
| ------ | ------ | ------ | ------ |
| | id | bigint(20) | 自增主键 |
| | company_name_digest | char(32) | 主体唯一键 |
| | justice_record | char(32) | 司法协助记录，justice_url的md5 |
| | justice_url | varchar(255) | 记录连接 |
| | executee | varchar(255) | 被执行人 |
| | executee_name_digest | char(32) | 被执行人为企业时企业唯一键 |
| | equity_amount | varchar(50) | 股权数额 |
| | unit | varchar(50) | 数额币种 |
| | exec_court | varchar(100) | 执行法院 |
| | doc_no | varchar(200) | 执行通知书文号 |
| | equity_status | varchar(200) | 类型丨状态 |
| | freeze_doc_no | varchar(200) | 冻结执行通知书文号 |
| | freeze_exec_no | varchar(200) | 冻结执行裁定书文号 |
| | executee_identify_type | varchar(50) | 被执行人证件类型 |
| | executee_identify_no | varchar(50) | 被执行人证件号码 |
| | exec_item | varchar(250) | 冻结执行事项 |
| | freeze_start_date | date | 冻结期限自 |
| | freeze_end_date | date | 冻结期限至 |
| | freeze_years | varchar(50) | 冻结期限 |
| | public_date | varchar(50) | 冻结公示日期 |
| | unfreeze_exec_item | varchar(250) | 解冻执行事项 |
| | unfreeze_doc_no | varchar(200) | 解冻执行通知书文号 |
| risk_xianxiao | unfreeze_exec_no | varchar(200) | 解冻执行裁定书文号 |
| | unfreeze_date | date | 解除冻结日期 |
| | unfreeze_public_date | varchar(50) | 解冻公示日期 |
| | keep_freeze_doc_no | varchar(200) | 续行冻结执行通知书文号 |
| | keep_freeze_exec_no | varchar(200) | 续行冻结执行裁定书文号 |
| | keep_exec_item | varchar(250) | 续行冻结执行事项 |
| | keep_freeze_start_date | date | 续行冻结期限自 |
| | keep_freeze_end_date | date | 续行冻结期限至 |
| | keep_freeze_years | varchar(50) | 续行冻结期限 |
| | keep_free_public_date | varchar(50) | 续行冻结公示日期 |
| | change_freeze_doc_no | varchar(200) | 股权变更执行通知书文号 |
| | change_freeze_exec_no | varchar(200) | 股权变更执行裁定书文号 |
| | change_exec_item | varchar(250) | 股权变更执行事项 |
| | change_exec_date | date | 股权变更执行日期 |
| | accepter | varchar(255) | 受让人 |
| | accepter_name_digest | char(32) | 受让人为企业时企业唯一键 |
| | accepter_identify_type | varchar(50) | 受让人证件类型 |
| | accepter_identify_no | varchar(50) | 受让人证件号码 |
| | invalid_date | date | 失效时间 |
| | invalid_reason | varchar(255) | 失效原因 |
| | is_history | tinyint(4) | 状态（0: 有效， 1: 历史） |
| | use_flag | tinyint(4) | 使用标记 |
| | create_time | datetime | 入库时间 |
| | update_time | datetime | 最后更新时间 |
# 样例
```json
[
{
"id": 1,
"company_name_digest": "4324666b14b07e50ac9be0ac6b66384b",
"justice_record": "1618ed5f24661ec8d18740b431cc5891",
"justice_url": "http://www.gsxt.gov.cn/corp-query-entprise-info-judiciaryStockfreeze-PROVINCENODENUM1300000d8cb1485e604eefacdeeafb10e4c09e.html",
"executee": "廊坊市双力房地产开发有限公司",
"executee_name_digest": "ea3b8bb04b8c5a990a0f2e82101cfe3e",
"equity_amount": "3500万人民币",
"unit": "人民币",
"exec_court": "廊坊市广阳区人民法院",
"doc_no": "（2020）冀1003执保306号",
"equity_status": "股权冻结|冻结",
"freeze_doc_no": "（2020）冀1003执保306号",
"freeze_exec_no": "（2020）冀1003民初978号",
"executee_identify_type": "企业法人营业执照(公司)",
"executee_identify_no": "91131000746878733Q",
"exec_item": "公示冻结股权、其他投资权益",
"freeze_start_date": "2020-06-04",
"freeze_end_date": "2022-06-03",
"freeze_years": "729",
"public_date": null,
"unfreeze_exec_item": null,
"unfreeze_doc_no": null,
"unfreeze_exec_no": null,
"unfreeze_date": null,
"unfreeze_public_date": null,
"keep_freeze_doc_no": null,
"keep_freeze_exec_no": null,
"keep_exec_item": null,
"keep_freeze_start_date": null,
"keep_freeze_end_date": null,
"keep_freeze_years": null,
"keep_free_public_date": null,
"change_freeze_doc_no": null,
"change_freeze_exec_no": null,
"change_exec_item": null,
"change_exec_date": null,
"accepter": null,
"accepter_name_digest": null,
"accepter_identify_type": null,
"accepter_identify_no": null,
"invalid_date": null,
"invalid_reason": null,
"is_history": 0,
"use_flag": 0,
"create_time": "2022-05-24 14:02:38",
"update_time": "2022-05-24 14:02:38"
},
{
"id": 2,
"company_name_digest": "6f71c821ebc365048f5abb669f06cae6",
"justice_record": "e610206fcc84f3c92060cee8900f5efb",
"justice_url": "http://www.gsxt.gov.cn/corp-query-entprise-info-judiciaryStockfreeze-PROVINCENODENUM310000c807e6be27e5462a81d7bf94ed3b799f.html",
"executee": "广东皮皮时光文化传媒有限公司",
"executee_name_digest": "4969b6da5d041ce00d15f74022422596",
"equity_amount": "300万人民币",
"unit": "人民币",
"exec_court": "南京市玄武区人民法院",
"doc_no": "2020法执苏0102民初字第12447号",
"equity_status": "股权冻结|冻结",
"freeze_doc_no": "2020法执苏0102民初字第12447号",
"freeze_exec_no": "2020法执苏0102民初字第12447号",
"executee_identify_type": "其他",
"executee_identify_no": "9144030071232402XC",
"exec_item": "公示冻结股权、其他投资权权益",
"freeze_start_date": "2020-12-24",
"freeze_end_date": "2023-12-23",
"freeze_years": "1094",
"public_date": "2020-12-24T00:00:00",
"unfreeze_exec_item": null,
"unfreeze_doc_no": null,
"unfreeze_exec_no": null,
"unfreeze_date": null,
"unfreeze_public_date": null,
"keep_freeze_doc_no": null,
"keep_freeze_exec_no": null,
"keep_exec_item": null,
"keep_freeze_start_date": null,
"keep_freeze_end_date": null,
"keep_freeze_years": null,
"keep_free_public_date": null,
"change_freeze_doc_no": null,
"change_freeze_exec_no": null,
"change_exec_item": null,
"change_exec_date": null,
"accepter": null,
"accepter_name_digest": null,
"accepter_identify_type": null,
"accepter_identify_no": null,
"invalid_date": null,
"invalid_reason": null,
"is_history": 0,
"use_flag": 0,
"create_time": "2022-05-24 14:02:38",
"update_time": "2022-05-24 14:02:38"
},
{
"id": 3,
"company_name_digest": "9c69156203d0c3628b307d95ffbf7801",
"justice_record": "ef9040454554430242646706b08af4e8",
"justice_url": "http://www.gsxt.gov.cn/corp-query-entprise-info-judiciaryStockfreeze-PROVINCENODENUM43000025b0acf07abb4f0eb709053a3b888a8c.html",
"executee": "向成芳",
"executee_name_digest": null,
"equity_amount": "500万人民币",
"unit": "人民币",
"exec_court": "邵阳市大祥区人民法院",
"doc_no": "2020湘0503执281号之一",
"equity_status": "股权冻结|冻结",
"freeze_doc_no": "2020湘0503执281号之一",
"freeze_exec_no": "2020湘0503执281号之一",
"executee_identify_type": "中华人民共和国居民身份证",
"executee_identify_no": "",
"exec_item": "公示冻结股权、其他投资权益",
"freeze_start_date": "2020-04-27",
"freeze_end_date": "2023-04-26",
"freeze_years": "1094",
"public_date": "2020-04-27T00:00:00",
"unfreeze_exec_item": null,
"unfreeze_doc_no": null,
"unfreeze_exec_no": null,
"unfreeze_date": null,
"unfreeze_public_date": null,
"keep_freeze_doc_no": null,
"keep_freeze_exec_no": null,
"keep_exec_item": null,
"keep_freeze_start_date": null,
"keep_freeze_end_date": null,
"keep_freeze_years": null,
"keep_free_public_date": null,
"change_freeze_doc_no": null,
"change_freeze_exec_no": null,
"change_exec_item": null,
"change_exec_date": null,
"accepter": null,
"accepter_name_digest": null,
"accepter_identify_type": null,
"accepter_identify_no": null,
"invalid_date": null,
"invalid_reason": null,
"is_history": 0,
"use_flag": 0,
"create_time": "2022-05-24 14:02:38",
"update_time": "2022-05-24 14:02:38"
},
{
"id": 4,
"company_name_digest": "5226b00094e2aef51e8ec731b042514d",
"justice_record": "b772975e8aa779c1bedbfca1ae2ad8e9",
"justice_url": "http://www.gsxt.gov.cn/corp-query-entprise-info-judiciaryStockfreeze-PROVINCENODENUM340000400000099744326141.html",
"executee": "安徽华强羽绒有限公司",
"executee_name_digest": "8e5363de26cc91f8343469c9f5d55898",
"equity_amount": "400万人民币元",
"unit": "人民币元",
"exec_court": "舒城县人民法院",
"doc_no": "（2020）皖1523执宝154号",
"equity_status": "股权冻结|解除冻结",
"freeze_doc_no": null,
"freeze_exec_no": null,
"executee_identify_type": "内资企业法人",
"executee_identify_no": "913415237050035789",
"exec_item": null,
"freeze_start_date": null,
"freeze_end_date": null,
"freeze_years": null,
"public_date": null,
"unfreeze_exec_item": "解除冻结股权、其他投资权益",
"unfreeze_doc_no": "（2020）皖1523执宝154号",
"unfreeze_exec_no": "（2020）皖1523执宝154号",
"unfreeze_date": "2020-09-11",
"unfreeze_public_date": "2020-07-16T00:00:00",
"keep_freeze_doc_no": null,
"keep_freeze_exec_no": null,
"keep_exec_item": null,
"keep_freeze_start_date": null,
"keep_freeze_end_date": null,
"keep_freeze_years": null,
"keep_free_public_date": null,
"change_freeze_doc_no": null,
"change_freeze_exec_no": null,
"change_exec_item": null,
"change_exec_date": null,
"accepter": null,
"accepter_name_digest": null,
"accepter_identify_type": null,
"accepter_identify_no": null,
"invalid_date": null,
"invalid_reason": null,
"is_history": 0,
"use_flag": 0,
"create_time": "2022-05-24 14:02:38",
"update_time": "2022-05-24 14:02:38"
},
{
"id": 5,
"company_name_digest": "efa6c6c25d8fb5fb04a6df49386f9ea7",
"justice_record": "a9b49feb16ebd7097a1a5b396db19788",
"justice_url": "http://www.gsxt.gov.cn/corp-query-entprise-info-judiciaryStockfreeze-PROVINCENODENUM430000f552bbe51b5040a58b72a67a7e9e54bf.html",
"executee": "张年春",
"executee_name_digest": null,
"equity_amount": "20万人民币",
"unit": "人民币",
"exec_court": "临澧县人民法院",
"doc_no": "（2016）湘0724执87号",
"equity_status": "股权冻结|失效",
"freeze_doc_no": null,
"freeze_exec_no": null,
"executee_identify_type": null,
"executee_identify_no": null,
"exec_item": null,
"freeze_start_date": null,
"freeze_end_date": null,
"freeze_years": null,
"public_date": null,
"unfreeze_exec_item": null,
"unfreeze_doc_no": null,
"unfreeze_exec_no": null,
"unfreeze_date": null,
"unfreeze_public_date": null,
"keep_freeze_doc_no": null,
"keep_freeze_exec_no": null,
"keep_exec_item": null,
"keep_freeze_start_date": null,
"keep_freeze_end_date": null,
"keep_freeze_years": null,
"keep_free_public_date": null,
"change_freeze_doc_no": null,
"change_freeze_exec_no": null,
"change_exec_item": null,
"change_exec_date": null,
"accepter": null,
"accepter_name_digest": null,
"accepter_identify_type": null,
"accepter_identify_no": null,
"invalid_date": "2019-06-06",
"invalid_reason": "冻结期满且未续行冻结，自动失效",
"is_history": 0,
"use_flag": 0,
"create_time": "2022-05-24 14:02:38",
"update_time": "2022-05-24 14:02:38"
}
]
```
\ No newline at end of file