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

biz_tax_credit

经营状况-税务评级

存储信息

aliyun-mysql-rds

host: bdp-rds-003.mysql.rds.aliyuncs.com
port: 3306
user: **
password: **
database: utn_ng_biz_info

建表语句

CREATE TABLE `tax_credit` (
  `id` bigint(32) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT '纳税人名称',
  `base` varchar(10) NOT NULL COMMENT '省市',
  `id_number` varchar(50) NOT NULL COMMENT '纳税人识别号',
  `grade` varchar(10) DEFAULT NULL COMMENT '纳税等级',
  `year` varchar(10) DEFAULT NULL COMMENT '年份',
  `eval_department` varchar(100) DEFAULT NULL COMMENT '评价单位',
  `source` varchar(200) DEFAULT NULL COMMENT '来源',
  `type` smallint(6) DEFAULT NULL COMMENT '0国税 1地税',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE 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_num_grade_eval` (`id_number`,`year`,`eval_department`,`name`),
  KEY `index_name` (`name`),
  KEY `n_y_index` (`name`,`year`),
  KEY `idx_digest` (`company_name_digest`),
  KEY `idx_update_time` (`update_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='纳税信用评价'

数据字典

表名	字段名	字段类型	注释
	id	bigint(32)	主键
	name	varchar(255)	纳税人名称
	base	varchar(10)	省市
	id_number	varchar(50)	纳税人识别号
	grade	varchar(10)	纳税等级
	year	varchar(10)	年份
	eval_department	varchar(100)	评价单位
tax_credit	source	varchar(200)	来源
	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 | title | city | district | company_name | from_url | ori_salary | url_Path | startDate | endDate | source | education | employer_number | description | experience | create_time | update_time | class | deleted | job_first_class | job_second_class | job_third_class | location | alternateField1 | alternateField2 | alternateField3 | company_name_digest | company_id | | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | | 1330827775 | 安徽贰壹陆贸易有限公司 | | 91340100MA2MT6P04N | A | 2019 | 国家税务总局 | http://hd.chinatax.gov.cn/ | 0 | null | 2021-05-03 18:00:04.0 | 0 | 0332aafd939b6e43935ef9f8879a182b | bab503eaab3badfe82aa39cdbdafcc8c | | 1330827776 | 福建众鑫盛建材有限公司 | | 91350121MA2Y8HE004 | A | 2019 | 国家税务总局 | http://hd.chinatax.gov.cn/ | 0 | null | 2021-05-03 18:00:04.0 | 0 | 6c4d8e1f36b8e68b14e4bce764abe494 | b67a76599fa361158a14755212e800e6 | | 1330827777 | 桓台县红星油脂厂 | | 913703216140826100 | A | 2018 | 国家税务总局 | http://hd.chinatax.gov.cn/ | 0 | null | 2021-05-03 18:00:04.0 | 0 | 399d892f2081945ce9e0b3914c84f3b6 | ef2e25e6369dfb2b057f314f4e87df67 | | 1330827778 | 隆昌山川机械有限责任公司 | | 91511028709008851Y | A | 2019 | 国家税务总局 | http://hd.chinatax.gov.cn/ | 0 | null | 2021-05-03 18:00:04.0 | 0 | ce650824b1516081fc2c60335b72b37c | d3daf97a4eb82c2457d3cdb6e32f063d | | 1330827779 | 福建追梦时创信息技术有限公司 | | 91350103081627533X | A | 2019 | 国家税务总局 | http://hd.chinatax.gov.cn/ | 0 | null | 2021-05-03 18:00:04.0 | 0 | ab36e869b9c369f972f19c134482c4c1 | ee98a6866d7006bdd38dcc1e209ee7db |