ALTER TABLE `organization_tech` MODIFY COLUMN `specialty` VARCHAR (255) NULL COMMENT '擅长领域';

ALTER TABLE `achievement` MODIFY COLUMN `owner_mobile` VARCHAR(36) NULL COMMENT '所有人联系电话';

ALTER TABLE `demand` MODIFY COLUMN `employer_contacts_mobile` VARCHAR(36) COMMENT '雇主联系人电话';

ALTER TABLE `demand` MODIFY COLUMN `employer_name` VARCHAR(45) COMMENT'雇主名称';

CREATE TABLE `coganizance_record` (
  `id` BIGINT(18) NOT NULL  AUTO_INCREMENT,
  `district` INT(4) NOT NULL COMMENT '地区(省份/市)',
  `unit_name` VARCHAR(45) NOT NULL COMMENT '公司名称',
  `year` INT(4) NOT NULL COMMENT '高企认定年份',
  PRIMARY KEY (`id`))AUTO_INCREMENT = 1
ENGINE = InnoDB
COMMENT = '高企认定数据';