| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 |
- alter table `org_activity_cost`
- add COLUMN `year` INT(4) NULL COMMENT '年份' after `uid`;
- CREATE TABLE `org_cognizance_proportion` (
- `id` VARCHAR(36) NOT NULL,
- `uid` VARCHAR(36) NOT NULL,
- `institution` INT(1) NULL COMMENT '企业研发机构',
- `activity` INT(1) NULL COMMENT '研发活动',
- `activity_cost` INT(1) NULL COMMENT '研发活动费用详情',
- `tech_project` INT(1) NULL COMMENT '高新技术产品',
- `intellectual_property` INT(1) NULL COMMENT '知识产权',
- `achievement` INT(1) NULL COMMENT '科技成果转化',
- `ratepay` INT(1) NULL COMMENT '企业所得税纳税申报表',
- `finance` INT(1) NULL COMMENT '财务报表',
- `human_resource` INT(1) NULL COMMENT '企业人员情况',
- `honor_datum` INT(1) NULL COMMENT '企业荣誉及其他证明材料',
- `standard` INT(1) NULL COMMENT '标准制定情况',
- `ability` INT(1) NULL COMMENT '企业创新能力',
- PRIMARY KEY (`id`))
- ENGINE = InnoDB
- COMMENT = '高企培育进度权重表';
- CREATE TABLE `legal_person_ownership` (
- `id` VARCHAR(36) NOT NULL,
- `uid` VARCHAR(36) NOT NULL,
- `type` INT(1) NULL COMMENT '法人类型(0--中国企业法人,1--外国企业法人)',
- `name` VARCHAR(32) NULL COMMENT '名称',
- `org_code` VARCHAR(32) NULL COMMENT '组织机构代码或统一社会信用代码',
- `investment` DECIMAL(8,2) NULL COMMENT '投资(万元)',
- `deleted_sign` INT(1) NULL COMMENT '删除标记',
- PRIMARY KEY (`id`))
- ENGINE = InnoDB
- COMMENT = '法人股权表';
- CREATE TABLE `nature_ownership` (
- `id` VARCHAR(36) NOT NULL,
- `uid` VARCHAR(36) NOT NULL,
- `type` INT(1) NULL COMMENT '类型 (0--中国公民,1--外籍公民)',
- `name` VARCHAR(32) NULL COMMENT '姓名',
- `id_number` VARCHAR(18) NULL COMMENT '身份证(护照)号',
- `investment` DECIMAL(8,2) NULL COMMENT '投资额(万元)',
- `deleted_sign` INT(1) NULL COMMENT '删除标记',
- PRIMARY KEY (`id`))
- ENGINE = InnoDB
- COMMENT = '自然人股权表';
|