MySQL 表结构:t_projectrecord - 项目记录表
/\n Navicat Premium Data Transfer\n\n Source Server : 192.168.1.223_3306\n Source Server Type : MySQL\n Source Server Version : 50725\n Source Host : 192.168.1.223:3306\n Source Schema : db_twenty\n\n Target Server Type : MySQL\n Target Server Version : 50725\n File Encoding : 65001\n\n Date: 18/07/2023 11:12:28\n/\n\nSET NAMES utf8mb4;\nSET FOREIGN_KEY_CHECKS = 0;\n\n-- ----------------------------\n-- Table structure for t_projectrecord\n-- ----------------------------\nDROP TABLE IF EXISTS t_projectrecord;\nCREATE TABLE t_projectrecord (\n C_ID bigint(20) NOT NULL AUTO_INCREMENT COMMENT '项目记录ID',\n C_CREATEAT datetime(0) NULL COMMENT '创建时间',\n C_CREATORID bigint(20) NULL DEFAULT NULL COMMENT '创建者ID',\n C_CREATORNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者姓名',\n C_DELETED tinyint(1) NULL DEFAULT NULL COMMENT '删除标识',\n C_NAME varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',\n C_REMARK varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',\n C_UPDATEAT datetime(0) NULL DEFAULT NULL COMMENT '更新时间',\n C_UPDATERID bigint(20) NULL DEFAULT NULL COMMENT '更新者ID',\n C_UPDATERNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新者姓名',\n m1 double NOT NULL COMMENT 'm1',\n m10 double NOT NULL COMMENT 'm10',\n m11 double NOT NULL COMMENT 'm11',\n m2 double NOT NULL COMMENT 'm2',\n m3 double NOT NULL COMMENT 'm3',\n m4 double NOT NULL COMMENT 'm4',\n m5 double NOT NULL COMMENT 'm5',\n m6 double NOT NULL COMMENT 'm6',\n m7 double NOT NULL COMMENT 'm7',\n m8 double NOT NULL COMMENT 'm8',\n m9 double NOT NULL COMMENT 'm9',\n C_BEGINEAT datetime(0) NULL DEFAULT NULL COMMENT '开始时间',\n C_ENDAT datetime(0) NULL DEFAULT NULL COMMENT '结束时间',\n C_CITNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '城市名称',\n C_CITID bigint(20) NULL DEFAULT NULL COMMENT '城市ID',\n C_COUNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '国家名称',\n C_COUID bigint(20) NULL DEFAULT NULL COMMENT '国家ID',\n C_PRONAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省份名称',\n C_PROID bigint(20) NULL DEFAULT NULL COMMENT '省份ID',\n C_TOWNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '城镇名称',\n C_TOWID bigint(20) NULL DEFAULT NULL COMMENT '城镇ID',\n C_VILNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '村庄名称',\n C_VILID bigint(20) NULL DEFAULT NULL COMMENT '村庄ID',\n C_NATNAME varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '国家名称',\n C_PLANAT datetime(0) NULL DEFAULT NULL COMMENT '计划时间',\n C_PROJECTCONTENT varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目内容',\n C_PROJECTDEP int(11) NULL DEFAULT NULL COMMENT '项目部门',\n C_PROJECTNAME varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目名称',\n C_PROJECTPERSON varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目负责人',\n C_PROJECTYPE int(11) NULL DEFAULT NULL COMMENT '项目类型',\n C_PROTECT int(11) NULL DEFAULT NULL COMMENT '项目状态',\n C_STATUS int(11) NULL DEFAULT NULL COMMENT '状态',\n C_TYPEREMARK varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型备注',\n R_PROJECT_ID bigint(20) NULL DEFAULT NULL COMMENT '关联项目ID'\n) ENGINE = InnoDB AUTO_INCREMENT = 14050 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;\n\nSET FOREIGN_KEY_CHECKS = 1;
原文地址: https://www.cveoy.top/t/topic/pSrM 著作权归作者所有。请勿转载和采集!