2017-03-08.sql 1.1 KB

1234567891011121314151617181920212223
  1. ALTER TABLE `organization_identity`
  2. add `listed` int(1) NOT NULL default 0 COMMENT '是否上市',
  3. add `listed_date` DATETIME NULL COMMENT '上市时间',
  4. add `listed_type` int(1) NOT NULL COMMENT '上市类型',
  5. add `stock_code` VARCHAR(32) NULL COMMENT '股票代码';
  6. ALTER TABLE `org_human_resource`
  7. add `new_employment` int(6) NULL COMMENT '新增就业人数' AFTER `year`,
  8. add `graduate_number` int(6) NULL COMMENT '高校应届毕业生人数' AFTER `new_employment`;
  9. CREATE TABLE `org_annual_report` (
  10. `id` VARCHAR(36) NOT NULL,
  11. `uid` VARCHAR(36) NULL,
  12. `create_time` DATETIME NULL COMMENT '创建时间',
  13. `last_update_time` DATETIME NULL COMMENT '最近跟新时间',
  14. `total_tax` DECIMAL(8,2) NULL COMMENT '纳税总额(万元)',
  15. `income_tax_relief` DECIMAL(8,2) NULL COMMENT '所得税减免(万元)',
  16. `total_export_volume` DECIMAL(8,2) NULL COMMENT '出口创汇总额(万元)',
  17. `year` INT(4) NULL COMMENT '年份',
  18. `state` INT(1) NULL DEFAULT 0 COMMENT '年报状态',
  19. `deleted_sign` INT(1) NOT NULL DEFAULT 0 COMMENT '删除标记',
  20. PRIMARY KEY (`id`))
  21. ENGINE = InnoDB;