|
|
|
# 欠税公告
|
|
|
|
|
|
|
|
# 存储信息
|
|
|
|
aliyun-mysql-rds
|
|
|
|
|
|
|
|
* host: bdp-rds-001.mysql.rds.aliyuncs.com
|
|
|
|
* port: 3306
|
|
|
|
* user: **
|
|
|
|
* password: **
|
|
|
|
* database: utn_ng_risk
|
|
|
|
|
|
|
|
# 建表语句
|
|
|
|
|
|
|
|
```sql
|
|
|
|
CREATE TABLE `company_own_tax_info` (
|
|
|
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
|
`name` varchar(255) NOT NULL COMMENT '纳税人名称',
|
|
|
|
`base` varchar(10) NOT NULL COMMENT '省市',
|
|
|
|
`tax_id_number` varchar(150) NOT NULL COMMENT '纳税人识别号',
|
|
|
|
`legalperson_name` varchar(150) DEFAULT NULL COMMENT '法人或负责人名称',
|
|
|
|
`person_id_name` varchar(50) DEFAULT NULL COMMENT '法人证件名称',
|
|
|
|
`person_id_number` varchar(150) DEFAULT NULL COMMENT '证件号码',
|
|
|
|
`location` varchar(1000) DEFAULT NULL COMMENT '经营地点',
|
|
|
|
`tax_category` varchar(255) DEFAULT NULL COMMENT '欠税税种',
|
|
|
|
`own_tax_amount` varchar(50) DEFAULT NULL COMMENT '欠税金额',
|
|
|
|
`taxpayer_type` varchar(10) DEFAULT NULL COMMENT '纳税人类型',
|
|
|
|
`publish_date` date DEFAULT NULL COMMENT '发布日期',
|
|
|
|
`own_tax_balance` varchar(20) DEFAULT NULL COMMENT '欠税余额',
|
|
|
|
`new_own_tax_balance` varchar(20) DEFAULT NULL COMMENT '当前新发生欠税余额',
|
|
|
|
`reg_type` varchar(50) DEFAULT NULL COMMENT '注册类型',
|
|
|
|
`department` varchar(200) DEFAULT NULL COMMENT '税款所属税务机关',
|
|
|
|
`source` varchar(500) DEFAULT NULL COMMENT '来源',
|
|
|
|
`oss_location` varchar(100) DEFAULT NULL COMMENT 'oss上文件存放的位置',
|
|
|
|
`type` smallint(6) DEFAULT NULL COMMENT '0国税 1地税',
|
|
|
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
|
|
|
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
|
`is_deleted` smallint(6) DEFAULT '0' COMMENT '是否删除 0否 1删',
|
|
|
|
`company_name_digest` char(32) DEFAULT NULL COMMENT '对应主体唯一键',
|
|
|
|
`company_id` char(32) DEFAULT NULL COMMENT '对应主体唯一键',
|
|
|
|
PRIMARY KEY (`id`),
|
|
|
|
UNIQUE KEY `index_id_number` (`tax_id_number`,`tax_category`,`publish_date`,`own_tax_balance`,`own_tax_amount`,`name`),
|
|
|
|
KEY `index_name` (`name`),
|
|
|
|
KEY `n_p_index` (`name`,`publish_date`),
|
|
|
|
KEY `idx_digest` (`company_name_digest`)
|
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=4591256 DEFAULT CHARSET=utf8 COMMENT='欠税信息公告';
|
|
|
|
|
|
|
|
```
|
|
|
|
|
|
|
|
# 数据字典
|
|
|
|
|
|
|
|
| 表名 | 字段名 | 字段类型 | 注释 |
|
|
|
|
| ------ | ------ | ------ | ------ |
|
|
|
|
| | id | bigint(20) | 自增主键 |
|
|
|
|
| | name | varchar(255) | 纳税人名称 |
|
|
|
|
| | base | varchar(10) | 省市 |
|
|
|
|
| | tax_id_number | varchar(150) | 纳税人识别号 |
|
|
|
|
| | legalperson_name | varchar(150) | 法人或负责人名称 |
|
|
|
|
| | person_id_name | varchar(50) | 法人证件名称 |
|
|
|
|
| | person_id_number | varchar(150) | 证件号码 |
|
|
|
|
| | location | varchar(1000) | 经营地点 |
|
|
|
|
| | tax_category | varchar(255) | 欠税税种 |
|
|
|
|
| | own_tax_amount | varchar(50) | 欠税金额 |
|
|
|
|
| | taxpayer_type | varchar(10) | 纳税人类型 |
|
|
|
|
| company_own_tax_info | publish_date | date | 发布日期 |
|
|
|
|
| 欠税信息公告 | own_tax_balance | varchar(20) | 欠税余额 |
|
|
|
|
| | new_own_tax_balance | varchar(20) | 当前新发生欠税余额 |
|
|
|
|
| | reg_type | varchar(50) | 注册类型 |
|
|
|
|
| | department | varchar(200) | 税款所属税务机关 |
|
|
|
|
| | source | varchar(500) | 来源 |
|
|
|
|
| | oss_location | varchar(100) | oss上文件存放的位置 |
|
|
|
|
| | type | smallint(6) | 0国税1地税 |
|
|
|
|
| | create_time | datetime | 创建时间 |
|
|
|
|
| | update_time | datetime | 更新时间 |
|
|
|
|
| | is_deleted | smallint(6) | 是否删除0否1删 |
|
|
|
|
| | company_name_digest | char(32) | 对应主体唯一键 |
|
|
|
|
| | company_id | char(32) | 对应主体唯一键 |
|
|
|
|
|
|
|
|
# 样例
|
|
|
|
|
|
|
|
| id | name | base | tax_id_number | legalperson_name | person_id_name | person_id_number | location | tax_category | own_tax_amount | taxpayer_type | publish_date | own_tax_balance | new_own_tax_balance | reg_type | department | source | oss_location | type | create_time | update_time | is_deleted | company_name_digest | company_id |
|
|
|
|
| ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ |
|
|
|
|
| 4591255 | 上海苏蝶实业有限公司 | sh | 91310120785893426A | 徐丹 | 居民身份证 | 非公示项 | 上海市奉贤区南桥镇新建西路101号 | 城市维护建设税 | | | 2020-07-27 | 10.51 | | | 第十一税务所 | http://shanghai.chinatax.gov.cn/fxtax/tzgg/qsgg/202007/t454696.html | taxNotice/shanghai.chinatax.gov.cn+++20200727P020200727340607193984.xlsx | | 2020-07-29 00:00:00 | 2020-07-29 00:00:00 | 0 | 5d284cc440a4ed1e6ff2c1e29bdfd74a | 13b2ba20d8ca71d684e39983d5f7f264 |
|
|
|
|
| 4591254 | 上海苏蝶实业有限公司 | sh | 91310120785893426A | 徐丹 | 居民身份证 | 非公示项 | 上海市奉贤区南桥镇新建西路101号 | 增值税 | | | 2020-07-27 | 1050.70 | | | 第十一税务所 | http://shanghai.chinatax.gov.cn/fxtax/tzgg/qsgg/202007/t454696.html | taxNotice/shanghai.chinatax.gov.cn+++20200727P020200727340607193984.xlsx | | 2020-07-29 00:00:00 | 2020-07-29 00:00:00 | 0 | 5d284cc440a4ed1e6ff2c1e29bdfd74a | 13b2ba20d8ca71d684e39983d5f7f264 |
|
|
|
|
| 4591253 | 上海嵩川包装材料经营部 | sh | 9131012009384069XX | 姜春莲 | 居民身份证 | 非公示项 | 上海市奉贤区奉城镇奉高路999号7号厂房 | 城市维护建设税 | | | 2020-07-27 | 733.03 | | | 第十一税务所 | http://shanghai.chinatax.gov.cn/fxtax/tzgg/qsgg/202007/t454696.html | taxNotice/shanghai.chinatax.gov.cn+++20200727P020200727340607193984.xlsx | | 2020-07-29 00:00:00 | 2020-07-29 00:00:00 | 0 | d9e50e8c8d0a771e2212428afe4ae6ae | 1600f020232128b8e4e0c04ae9eb8b11 |
|
|
|
|
| 4591252 | 上海嵩川包装材料经营部 | sh | 9131012009384069XX | 姜春莲 | 居民身份证 | 非公示项 | 上海市奉贤区奉城镇奉高路999号7号厂房 | 增值税 | | | 2020-07-27 | 73302.89 | | | 第十一税务所 | http://shanghai.chinatax.gov.cn/fxtax/tzgg/qsgg/202007/t454696.html | taxNotice/shanghai.chinatax.gov.cn+++20200727P020200727340607193984.xlsx | | 2020-07-29 00:00:00 | 2020-07-29 00:00:00 | 0 | d9e50e8c8d0a771e2212428afe4ae6ae | 1600f020232128b8e4e0c04ae9eb8b11 |
|
|
|
|
|
|
|
|
# 说明
|
|
|
|
|
|
|
|
* is_deleted字段的值包括：0、1、2等，查询欠税公告条件为 is_deleted=0，历史欠税公告： is_deleted != 0 |
|
|
\ No newline at end of file |
