经营状况-税务评级

存储信息

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='纳税信用评价'

数据字典

样例