bladex/blade-service/blade-manager/src/main/java/sql/m_project_info.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50736
 Source Host           : localhost:3306
 Source Schema         : bladex

 Target Server Type    : MySQL
 Target Server Version : 50736
 File Encoding         : 65001

 Date: 23/05/2022 10:09:02
*/

SET NAMES utf8mb4;
SET
FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for m_project_info
-- ----------------------------
DROP TABLE IF EXISTS `m_project_info`;
CREATE TABLE `m_project_info`
(
    `id`                  bigint(20) NOT NULL COMMENT '主键id',
    `project_name`        varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目名称',
    `project_alias`       varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目别名',
    `project_number`      varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目编号',
    `project_gist`        varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目大概',
    `project_grade`       varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工程等级',
    `plan_start_time`     datetime(0) NULL DEFAULT NULL COMMENT '计划开始时间',
    `plan_end_time`       datetime(0) NULL DEFAULT NULL COMMENT '计划完成时间',
    `actual_start_time`   datetime(0) NULL DEFAULT NULL COMMENT '实际开始时间',
    `actual_end_time`     datetime(0) NULL DEFAULT NULL COMMENT '实际完工时间',
    `construcetion_date`  int(5) NULL DEFAULT NULL COMMENT '施工期',
    `estimated_amount`    decimal(20, 2) NULL DEFAULT NULL COMMENT '建设合同金额',
    `project_all_mileage` decimal(20, 0) NULL DEFAULT NULL COMMENT '项目总里程',
    `project_pavement`    decimal(20, 0) NULL DEFAULT NULL COMMENT '项目路面',
    `project_subgrade`    decimal(20, 0) NULL DEFAULT NULL COMMENT '项目路基',
    `project_remark`      varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目备注',
    `state`               int(1) NULL DEFAULT NULL COMMENT '节点状态',
    `is_open_sign`        int(11) NULL DEFAULT NULL COMMENT '是否开启电签',
    `create_time`         datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `create_user`         varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
    `create_dept`         varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建部门',
    `update_user`         varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
    `update_time`         datetime(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP (0) COMMENT '修改时间',
    `status`              int(2) NULL DEFAULT NULL COMMENT '状态',
    `is_deleted`          int(2) NULL DEFAULT 0 COMMENT '是否已删除',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户级项目表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of m_project_info
-- ----------------------------
SET
FOREIGN_KEY_CHECKS = 1;