t_projectreportbatch 表结构 - MySQL 数据库

/\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: 13/07/2023 14:29:15\n/\n\nSET NAMES utf8mb4;\nSET FOREIGN_KEY_CHECKS = 0;\n\n-- ----------------------------\n-- Table structure for t_projectreportbatch\n-- ----------------------------\nDROP TABLE IF EXISTS t_projectreportbatch;\nCREATE TABLE t_projectreportbatch (\n C_ID bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',\n C_APPLYNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '申请名称',\n C_REPORTPHONE varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '报告电话',\n C_CREATAT datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n C_REMARK varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',\n C_REPORTAT datetime(0) NULL DEFAULT NULL COMMENT '报告时间',\n C_STATUS int(11) 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 R_PLACE_ID bigint(20) NULL DEFAULT NULL COMMENT '地点ID',\n R_STATEMENT_ID bigint(20) NULL DEFAULT NULL COMMENT '报告ID',\n PRIMARY KEY (C_ID) USING BTREE,\n INDEX FKFD3B07787B396C9B(R_PLACE_ID) USING BTREE,\n INDEX FKFD3B077870AF54D3(R_STATEMENT_ID) USING BTREE,\n CONSTRAINT FKFD3B077870AF54D3 FOREIGN KEY (R_STATEMENT_ID) REFERENCES t_projectreportall (C_ID) ON DELETE RESTRICT ON UPDATE RESTRICT,\n CONSTRAINT FKFD3B07787B396C9B FOREIGN KEY (R_PLACE_ID) REFERENCES t_place (C_ID) ON DELETE RESTRICT ON UPDATE RESTRICT\n) ENGINE = InnoDB AUTO_INCREMENT = 41866 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;\n\nSET FOREIGN_KEY_CHECKS = 1;