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 = '科技项目申报网址';