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