data_stream/double_publicity.md

@@ -223,7 +223,7 @@ create table if not exists database.`company_allow` (
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
   PRIMARY KEY (`id`) ,
-  UNIQUE KEY `IX_UNIQUE_NAME_NO` (`company_name`,`credit_no`,`allow_code`,`allow_no`),
+  UNIQUE KEY `IX_UNIQUE_NAME_NO` (`company_name`,`allow_id`),
   KEY `IX_ALLOW_TYPE` (`allow_type`),
   KEY `IX_CHECK_TYPE` (`check_type`),
   KEY `IX_CREATE_TIME` (`create_time`),
@@ -258,7 +258,7 @@ create table if not exists database.`company_punish` (
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
   PRIMARY KEY (`id`) ,
-  UNIQUE KEY `IX_UNIQUE_NAME_NO` (`company_name`,`credit_no`,`punish_code`),
+  UNIQUE KEY `IX_UNIQUE_NAME_NO` (`company_name`,`punish_id`),
   KEY `IX_PUNISH_TYPE` (`punish_type`),
   KEY `IX_PUNISH_AMOUNT` (`punish_amount`),
   KEY `IX_CREATE_TIME` (`create_time`),
@@ -282,7 +282,7 @@ create table if not exists database.`company_trustworthy_incentive` (
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
   PRIMARY KEY (`id`) ,
-  UNIQUE KEY `IX_UNIQUE_NAME_NO` (`company_name`,`credit_no`,`evaluation_year`,`trustworthy_incentive_type`),
+  UNIQUE KEY `IX_UNIQUE_NAME_NO` (`company_name`,`trustworthy_incentive_id`),
   KEY `IX_CREATE_TIME` (`create_time`),
   KEY `IX_UPDATE_TIME` (`update_time`)
 ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='信用中国守信激励';