| ... | ... | @@ -32,4 +32,23 @@ CREATE TABLE `bankruptcy_judicative_paper` ( |
|
|
|
```
|
|
|
|
|
|
|
|
# 数据字典
|
|
|
|
通过案号与公开案件表，公开公告表关联，获取相关数据 |
|
|
|
| Tables | 字段 | 类型 | 长度 | 是否为空 | 字段说明 |
|
|
|
|
|-----------------------------|--------------|------------------|------------|------|------------------|
|
|
|
|
| bankruptcy_judicative_paper | id | int(10) unsigned | | NO | 主键自增 |
|
|
|
|
| bankruptcy_judicative_paper | case_code | varchar(100) | 100 | NO | 案号 |
|
|
|
|
| bankruptcy_judicative_paper | title | varchar(100) | 100 | YES | 文书标题 |
|
|
|
|
| bankruptcy_judicative_paper | court_name | varchar(100) | 100 | YES | 法院名称 |
|
|
|
|
| bankruptcy_judicative_paper | doc_content | longtext | 4294967295 | YES | 文书详情 |
|
|
|
|
| bankruptcy_judicative_paper | publish_date | varchar(255) | 255 | YES | 公告日期 |
|
|
|
|
| bankruptcy_judicative_paper | case_type | varchar(50) | 50 | YES | 关联案件类型 |
|
|
|
|
| bankruptcy_judicative_paper | url | varchar(255) | 255 | NO | 链接 |
|
|
|
|
| bankruptcy_judicative_paper | create_time | datetime | | YES | 创建时间 |
|
|
|
|
| bankruptcy_judicative_paper | update_time | datetime | | YES | 更新时间 |
|
|
|
|
| bankruptcy_judicative_paper | use_flag | tinyint(4) | | YES | 是否删除，0 非删除，10 删除 |
|
|
|
|
|
|
|
|
# 样例数据
|
|
|
|
| id | case_code | title | court_name | doc_content | publish_date | case_type | url | create_time | update_time | use_flag |
|
|
|
|
|----|-----------------|--------------|------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------|-----------|--------------------------------------------------------------------------------|---------------------|---------------------|----------|
|
|
|
|
| 1 | （2018）苏1324破12号 | 终结破产程序-民事裁定书 | 泗洪县人民法院 | <div class="detail_text" id="printDiv" style="margin-bottom:47px;"><title>((((人民法院</title><div class="Section0" style="layout-grid:15.6000pt;"><p class="MsoNormal" align="center" style="text-align:center;line-height:30.0000pt;mso-line-height-rule:exactly;"><b><span style="mso-spacerun:'yes';font-family:方正小标宋简体;letter-spacing:3.0000pt;font-weight:bold;font-size:22.0000pt;mso-font-kerning:0.0000pt;"><font face="方正小标宋简体">江苏省泗洪县人民法院</font></span></b><b><span style="mso-spacerun:'yes';font-family:方正小标宋简体;letter-spacing:3.0000pt;font-weight:bold;font-size:22.0000pt;mso-font-kerning:0.0000pt;"><p></p></span></b></p><p class="MsoNormal" align="center" style="text-align:center;line-height:30.0000pt;mso-line-height-rule:exactly;"><b><span style="mso-spacerun:'yes';font-family:方正小标宋简体;letter-spacing:3.0000pt;font-weight:bold;font-size:22.0000pt;mso-font-kerning:0.0000pt;"><font face="方正小标宋简体">民事裁定书</font></span></b><b><span style="mso-spacerun:'yes';font-family:方正小标宋简体;letter-spacing:3.0000pt;font-weight:bold;font-size:22.0000pt;mso-font-kerning:0.0000pt;"><p></p></span></b></p><p class="MsoNormal" style="text-indent:32.0000pt;mso-char-indent-count:2.0000;line-height:25.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋_GB2312;font-size:16.0000pt;mso-font-kerning:0.0000pt;"><p> </p></span></p><p class="MsoNormal" align="right" style="margin-right:32.0000pt;text-align:right;line-height:30.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">（</font>2018）苏1324破12号之六</span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><p></p></span></p><p class="MsoNormal" align="right" style="margin-right:32.0000pt;text-align:right;line-height:30.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><p> </p></span></p><p class="MsoBodyTextIndent" style="text-indent:32.0000pt;line-height:30.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋;color:rgb(0,0,0);text-underline:rgb(0,0,0);font-size:16.0000pt;mso-font-kerning:0.0000pt;"><font face="仿宋">申请人：泗洪亿欣工贸有限公司管理人。</font></span><span style="mso-spacerun:'yes';font-family:仿宋;color:rgb(0,0,0);text-underline:rgb(0,0,0);font-size:16.0000pt;mso-font-kerning:0.0000pt;"><p></p></span></p><p class="MsoNormal" style="text-indent:32.0000pt;mso-char-indent-count:2.0000;line-height:30.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:0.0000pt;">2020年8月10日，</span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">泗洪亿欣工贸有限公司管理人</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:0.0000pt;"><font face="仿宋">向本院提出申请，称经本院裁定的《</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">泗洪亿欣工贸有限公司破产财产分配方案</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:0.0000pt;"><font face="仿宋">》已执行完毕，破产财产最后分配已完结，故请求终结</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">泗洪亿欣工贸有限公司</font></span><span style="mso-spacerun:'yes';font-family:仿宋;color:rgb(0,0,0);font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">破产程序</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:0.0000pt;"><font face="仿宋">。同时，管理人指出未接收到财务账册、会计凭证等导致无法进行完全清算。</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:0.0000pt;"><p></p></span></p><p class="MsoNormal" style="text-indent:32.0000pt;mso-char-indent-count:2.0000;line-height:30.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:0.0000pt;"><font face="仿宋">本院认为：</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">泗洪亿欣工贸有限公司</font></span><span style="mso-spacerun:'yes';font-family:仿宋;color:rgb(0,0,0);font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">管理人已</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">按照本院裁定认可的破产财产分配方案执行并分配完毕，破产清算工作已经结束。</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:0.0000pt;"><font face="仿宋">另外，</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">泗洪亿欣工贸有限公司</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:0.0000pt;"><font face="仿宋">未向管理人提供财务账册导致无法进行完全清算，</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">根据《最高人民法院关于债权人对人员下落不明或者财产状况不清的债务人申请破产清算案件如何处理的批复》规定，</font>“债务人的有关人员不履行法定义务，人民法院可依据有关法律规定追究其相应法律责任；其行为导致无法清算或者造成损失，有关权利人起诉要求其承担相应民事责任的，人民法院应依法予以支持”，故本案破产清算程序终结后，泗洪亿欣工贸有限公司的债权人可另寻合法途径向泗洪亿欣工贸有限公司的有关人员主张权利。根据《中华人民共和国企业破产法》一百二十条第二款之规定，裁定如下： </span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><p></p></span></p><p class="MsoNormal" style="text-indent:32.0000pt;mso-char-indent-count:2.0000;line-height:30.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:0.0000pt;"><font face="仿宋">终结</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">泗洪亿欣工贸有限公司破产程序</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:0.0000pt;"><font face="仿宋">。</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:0.0000pt;"><p></p></span></p><p class="MsoNormal" style="text-indent:32.0000pt;mso-char-indent-count:2.0000;line-height:30.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:0.0000pt;"><font face="仿宋">本裁定自即日起开始生效。</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:0.0000pt;"><p></p></span></p><p class="MsoNormal" style="text-indent:32.0000pt;mso-char-indent-count:2.0000;line-height:30.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:0.0000pt;"><p> </p></span></p><p class="MsoNormal" style="text-indent:32.0000pt;mso-char-indent-count:2.0000;line-height:30.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:0.0000pt;"><p> </p></span></p><p class="MsoNormal" align="right" style="text-align:right;line-height:30.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">审</font> <font face="仿宋">判</font> <font face="仿宋">长</font> <font face="仿宋">汤卫兵</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><p></p></span></p><p class="MsoNormal" align="right" style="text-indent:240.0000pt;mso-char-indent-count:15.0000;text-align:right;line-height:30.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">审</font> <font face="仿宋">判</font> <font face="仿宋">员</font> <font face="仿宋">秦</font> <font face="仿宋">雷</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><p></p></span></p><p class="MsoNormal" align="right" style="text-indent:240.0000pt;mso-char-indent-count:15.0000;text-align:right;line-height:30.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">审</font> <font face="仿宋">判</font> <font face="仿宋">员</font> <font face="仿宋">李</font> <font face="仿宋">伟</font> </span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><p></p></span></p><p class="MsoNormal" align="right" style="margin-right:-18.9000pt;mso-para-margin-right:-1.8000gd;text-indent:240.0000pt;mso-char-indent-count:15.0000;text-align:right;line-height:30.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><p> </p></span></p><p class="MsoNormal" align="right" style="margin-right:-18.9000pt;mso-para-margin-right:-1.8000gd;text-indent:240.0000pt;mso-char-indent-count:15.0000;text-align:right;line-height:30.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><p> </p></span></p><p class="MsoNormal" align="right" style="margin-right:-18.9000pt;mso-para-margin-right:-1.8000gd;text-indent:240.0000pt;mso-char-indent-count:15.0000;text-align:right;line-height:30.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><p> </p></span></p><p class="MsoNormal" align="right" style="margin-right:-8.4000pt;mso-para-margin-right:-0.8000gd;text-indent:240.0000pt;mso-char-indent-count:15.0000;text-align:right;line-height:30.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"> <font face="仿宋">二</font></span><span style="mso-spacerun:'yes';font-family:仿宋;mso-bidi-font-family:宋体;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">〇</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">二</font></span><span style="mso-spacerun:'yes';font-family:仿宋;mso-bidi-font-family:宋体;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">〇</font></span><span style="mso-spacerun:'yes';font-family:仿宋;mso-bidi-font-family:仿宋_GB2312;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">年八月十二</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">日</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><p></p></span></p><p class="MsoNormal" align="right" style="text-indent:240.0000pt;mso-char-indent-count:15.0000;text-align:right;line-height:30.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><p> </p></span></p><p class="MsoNormal" align="right" style="text-indent:240.0000pt;mso-char-indent-count:15.0000;text-align:right;line-height:30.0000pt;mso-line-height-rule:exactly;"><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:1.0000pt;"><font face="仿宋">书</font> <font face="仿宋">记</font> <font face="仿宋">员</font> <font face="仿宋">刘</font> <font face="仿宋">哲</font></span><span style="mso-spacerun:'yes';font-family:仿宋;font-size:16.0000pt;mso-font-kerning:0.0000pt;"><p></p></span></p></div></div> | 2020-08-20 00:00:00 | 破产案件 | http://pccz.court.gov.cn/pcajxxw/pcws/wsxq?id=6C823B7F2D5F3F5B4DDB2B0B35CCFECC | 2022-06-13 18:00:48 | 2022-06-13 18:00:48 | 0 |
|
|
|
|
|
|
|
|
通过案号与公开案件表，公开公告表关联，获取相关数据 |
|
|
\ No newline at end of file |
