2017-03-16.sql 2.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253
  1. CREATE TABLE `tech_project` (
  2. `id` VARCHAR(36) NOT NULL,
  3. `uid` VARCHAR(36) NOT NULL,
  4. `serial_number` INT(8) NULL COMMENT '编号' AUTO_INCREMENT,
  5. `contacts` INT(1) NULL COMMENT '联系人',
  6. `department` VARCHAR(45) NULL COMMENT '科技项目申报部门',
  7. `dispatch_info` VARCHAR(400) NULL COMMENT '派单信息',
  8. `project_name` VARCHAR(45) NULL COMMENT '项目名称',
  9. `project_catagory` VARCHAR(45) NULL COMMENT '项目类型',
  10. `tech_field` VARCHAR(45) NULL COMMENT '技术领域',
  11. `project_des` VARCHAR(400) NULL COMMENT '项目简介',
  12. `project_mode` INT(1) NULL COMMENT '是否立项',
  13. `project_approval` DECIMAL(8,2) NULL COMMENT '立项金额',
  14. `subsidy` INT(1) NULL COMMENT '是否补助',
  15. `consultant` VARCHAR(36) NULL COMMENT '咨询师',
  16. `approval_url` VARCHAR(255) NULL COMMENT '项目材料URL',
  17. `state` INT(1) NULL COMMENT '申报状态',
  18. `create_time` DATETIME NULL COMMENT '派单日',
  19. `accept_date` DATETIME NULL COMMENT '受理日',
  20. `approved_date` DATETIME NULL COMMENT '项目批复日期',
  21. `record_time` DATETIME NULL COMMENT '记录创建日期',
  22. `deleted_sign` INT(1) NULL COMMENT '删除标记',
  23. PRIMARY KEY (`id`),
  24. INDEX `serialNumber` (`serial_number` ASC))
  25. ENGINE = InnoDB AUTO_INCREMENT= 600000
  26. COMMENT = '科技项目申请表';
  27. CREATE TABLE `tech_project_log` (
  28. `id` VARCHAR(36) NOT NULL,
  29. `pid` VARCHAR(36) NOT NULL,
  30. `record_time` DATETIME NULL COMMENT '状态变更录入时间',
  31. `state` INT(1) NULL COMMENT '状态',
  32. `principal` VARCHAR(36) NULL COMMENT '负责人',
  33. `operator` VARCHAR(36) NULL COMMENT '操作人',
  34. `comment` VARCHAR(45) NULL COMMENT '备注',
  35. PRIMARY KEY (`id`))
  36. ENGINE = InnoDB
  37. COMMENT = '科技项目申报log';
  38. CREATE TABLE `tech_website` (
  39. `id` VARCHAR(36) NOT NULL,
  40. `uid` VARCHAR(36) NULL,
  41. `department` VARCHAR(45) NULL COMMENT '科技部门名称',
  42. `website` VARCHAR(255) NULL COMMENT '网址',
  43. `account_number` VARCHAR(45) NULL COMMENT '帐号',
  44. `password` VARCHAR(32) NULL COMMENT '密码',
  45. `create_time` DATETIME NULL COMMENT '创建日期',
  46. `deleted_sign` INT(1) NULL COMMENT '删除标记',
  47. PRIMARY KEY (`id`))
  48. ENGINE = InnoDB
  49. COMMENT = '科技项目申报网址';