update.sql 2.3 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. CREATE TABLE `zh_construction_attachment` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `tid` int(11) NOT NULL COMMENT '标段id',
  4. `log_id` int(11) NOT NULL COMMENT '日志id',
  5. `uid` int(11) NOT NULL COMMENT '上传者id',
  6. `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件名称',
  7. `fileext` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件后缀',
  8. `filesize` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件大小',
  9. `filepath` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件存储路径',
  10. `upload_time` datetime NOT NULL COMMENT '上传时间',
  11. `extra_upload` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为审核通过后再次上传的文件,0为否',
  12. PRIMARY KEY (`id`) USING BTREE
  13. ) ENGINE=InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT='施工日志附件表';
  14. CREATE TABLE `zh_construction_audit` (
  15. `id` int(11) NOT NULL AUTO_INCREMENT,
  16. `tid` int(11) NOT NULL COMMENT '标段id',
  17. `uid` int(11) NOT NULL COMMENT '用户id',
  18. `is_report` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否上报人',
  19. `in_time` datetime NOT NULL COMMENT '新增时间',
  20. PRIMARY KEY (`id`) USING BTREE
  21. ) ENGINE=InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT='施工日志管理人员表';
  22. CREATE TABLE `zh_construction_log` (
  23. `id` int(11) NOT NULL AUTO_INCREMENT,
  24. `tid` int(11) NOT NULL COMMENT '标段id',
  25. `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '编号',
  26. `date_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '日期,用于code的编号生成',
  27. `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
  28. `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '日志类型',
  29. `period` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '时间/周期',
  30. `report_uid` int(11) NOT NULL COMMENT '上报人id',
  31. `shenpi_uid` int(11) DEFAULT NULL COMMENT '签审人id',
  32. `log_json` json DEFAULT NULL COMMENT '日志内容',
  33. `create_time` datetime NOT NULL COMMENT '创建时间',
  34. `start_time` datetime DEFAULT NULL COMMENT '提交时间',
  35. `checked_time` datetime DEFAULT NULL COMMENT '审签时间',
  36. PRIMARY KEY (`id`) USING BTREE
  37. ) ENGINE=InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT='施工日志内容表';