| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253 |
- CREATE TABLE `tech_project` (
- `id` VARCHAR(36) NOT NULL,
- `uid` VARCHAR(36) NOT NULL,
- `serial_number` INT(8) NULL COMMENT '编号' AUTO_INCREMENT,
- `contacts` INT(1) NULL COMMENT '联系人',
- `department` VARCHAR(45) NULL COMMENT '科技项目申报部门',
- `dispatch_info` VARCHAR(400) NULL COMMENT '派单信息',
- `project_name` VARCHAR(45) NULL COMMENT '项目名称',
- `project_catagory` VARCHAR(45) NULL COMMENT '项目类型',
- `tech_field` VARCHAR(45) NULL COMMENT '技术领域',
- `project_des` VARCHAR(400) NULL COMMENT '项目简介',
- `project_mode` INT(1) NULL COMMENT '是否立项',
- `project_approval` DECIMAL(8,2) NULL COMMENT '立项金额',
- `subsidy` INT(1) NULL COMMENT '是否补助',
- `consultant` VARCHAR(36) NULL COMMENT '咨询师',
- `approval_url` VARCHAR(255) NULL COMMENT '项目材料URL',
- `state` INT(1) NULL COMMENT '申报状态',
- `create_time` DATETIME NULL COMMENT '派单日',
- `accept_date` DATETIME NULL COMMENT '受理日',
- `approved_date` DATETIME NULL COMMENT '项目批复日期',
- `record_time` DATETIME NULL COMMENT '记录创建日期',
- `deleted_sign` INT(1) NULL COMMENT '删除标记',
- PRIMARY KEY (`id`),
- INDEX `serialNumber` (`serial_number` ASC))
- ENGINE = InnoDB AUTO_INCREMENT= 600000
- COMMENT = '科技项目申请表';
- CREATE TABLE `tech_project_log` (
- `id` VARCHAR(36) NOT NULL,
- `pid` VARCHAR(36) NOT NULL,
- `record_time` DATETIME NULL COMMENT '状态变更录入时间',
- `state` INT(1) NULL COMMENT '状态',
- `principal` VARCHAR(36) NULL COMMENT '负责人',
- `operator` VARCHAR(36) NULL COMMENT '操作人',
- `comment` VARCHAR(45) NULL COMMENT '备注',
- PRIMARY KEY (`id`))
- ENGINE = InnoDB
- COMMENT = '科技项目申报log';
- CREATE TABLE `tech_website` (
- `id` VARCHAR(36) NOT NULL,
- `uid` VARCHAR(36) NULL,
- `department` VARCHAR(45) NULL COMMENT '科技部门名称',
- `website` VARCHAR(255) NULL COMMENT '网址',
- `account_number` VARCHAR(45) NULL COMMENT '帐号',
- `password` VARCHAR(32) NULL COMMENT '密码',
- `create_time` DATETIME NULL COMMENT '创建日期',
- `deleted_sign` INT(1) NULL COMMENT '删除标记',
- PRIMARY KEY (`id`))
- ENGINE = InnoDB
- COMMENT = '科技项目申报网址';
|