This is an old version of this page. You can view the most recent version or browse the history.

risk_company_justice

限制高消费

存储信息

aliyun-mysql-rds

host: bdp-rds-001.mysql.rds.aliyuncs.com
port: 3306
user: **
password: **
database: utn_ng_risk

建表语句

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	最后更新时间

样例

[
  {
    "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"
  }
]