/*
Navicat MySQL Data Transfer

Source Server         : 183.250.166.207_3345
Source Server Version : 50720
Source Host           : 183.250.166.207:3345
Source Database       : gxbbd

Target Server Type    : MYSQL
Target Server Version : 50720
File Encoding         : 65001

Date: 2019-01-24 17:16:11
*/



-- ----------------------------
-- Table structure for project_change
-- ----------------------------
DROP TABLE IF EXISTS `project_change`;
CREATE TABLE `project_change` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `active` bit(1) DEFAULT NULL COMMENT '是否可用',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新者',
  `projectname` varchar(100) DEFAULT NULL COMMENT '项目名称',
  `projectcontent` varchar(255) DEFAULT NULL COMMENT '项目内容',
  `projecttime` varchar(255) DEFAULT NULL COMMENT '变更时间',
  `certificateId` int(11) DEFAULT NULL COMMENT '证书ID',
  `type` varchar(10) DEFAULT NULL COMMENT '业务类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8;
