20170705-coganizance-record.sql 758 B

12345678910111213141516
  1. ALTER TABLE `organization_tech` MODIFY COLUMN `specialty` VARCHAR (255) NULL COMMENT '擅长领域';
  2. ALTER TABLE `achievement` MODIFY COLUMN `owner_mobile` VARCHAR(36) NULL COMMENT '所有人联系电话';
  3. ALTER TABLE `demand` MODIFY COLUMN `employer_contacts_mobile` VARCHAR(36) COMMENT '雇主联系人电话';
  4. ALTER TABLE `demand` MODIFY COLUMN `employer_name` VARCHAR(45) COMMENT'雇主名称';
  5. CREATE TABLE `coganizance_record` (
  6. `id` BIGINT(18) NOT NULL AUTO_INCREMENT,
  7. `district` INT(4) NOT NULL COMMENT '地区(省份/市)',
  8. `unit_name` VARCHAR(45) NOT NULL COMMENT '公司名称',
  9. `year` INT(4) NOT NULL COMMENT '高企认定年份',
  10. PRIMARY KEY (`id`))AUTO_INCREMENT = 1
  11. ENGINE = InnoDB
  12. COMMENT = '高企认定数据';