MySQL 表 t_d_fmdreportdetail 结构及字段说明

/* Navicat Premium Data Transfer

Source Server : 192.168.1.223_3306 Source Server Type : MySQL Source Server Version : 50725 Source Host : 192.168.1.223:3306 Source Schema : db_twenty

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

Date: 11/05/2023 09:20:05 */

SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0;

-- Table structure for t_d_fmdreportdetail

DROP TABLE IF EXISTS t_d_fmdreportdetail; CREATE TABLE t_d_fmdreportdetail ( C_ID bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', C_CREATEAT datetime(0) NULL COMMENT '创建时间', C_CREATORID bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', C_CREATORNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人姓名', C_DELETED bit(1) NULL DEFAULT NULL COMMENT '是否删除', C_NAME varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称', C_REMARK varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', C_UPDATEAT datetime(0) NULL DEFAULT NULL COMMENT '更新时间', C_UPDATERID bigint(20) NULL DEFAULT NULL COMMENT '更新人ID', C_UPDATERNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人姓名', C_OWNERID bigint(20) NULL DEFAULT NULL COMMENT '所属人ID', f3 double NULL DEFAULT NULL COMMENT '字段3', f4 int(11) NULL DEFAULT NULL COMMENT '字段4', f5 int(11) NULL DEFAULT NULL COMMENT '字段5', f6 int(11) NULL DEFAULT NULL COMMENT '字段6', C_CITNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '城市名称', C_CITID bigint(20) NULL DEFAULT NULL COMMENT '城市ID', C_COUNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '县名称', C_COUID bigint(20) NULL DEFAULT NULL COMMENT '县ID', C_PRONAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省名称', C_PROID bigint(20) NULL DEFAULT NULL COMMENT '省ID', C_TOWNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '乡镇名称', C_TOWID bigint(20) NULL DEFAULT NULL COMMENT '乡镇ID', C_VILNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '村名称', C_VILID bigint(20) NULL DEFAULT NULL COMMENT '村ID', R_AGRAUDIT_ID bigint(20) NULL DEFAULT NULL COMMENT '所属农业审核ID', R_AUDIR_ID bigint(20) NULL DEFAULT NULL COMMENT '所属审核ID', R_REPORT_ID bigint(20) NULL DEFAULT NULL COMMENT '所属报告ID', R_TASK_ID bigint(20) NULL DEFAULT NULL COMMENT '所属任务ID', PRIMARY KEY (C_ID) USING BTREE, INDEX FK_b70bv3dnuf80gkuewagi5f1yy(R_AGRAUDIT_ID) USING BTREE, INDEX FK_c1bww7qrr6mqndhnjo51c9oxf(R_AUDIR_ID) USING BTREE, INDEX FK_1nel3qvotn7tkon9msq17pj5h(R_REPORT_ID) USING BTREE, INDEX FK_pdbo66wagcmfll4bqon14y06m(R_TASK_ID) USING BTREE, CONSTRAINT FK_1nel3qvotn7tkon9msq17pj5h FOREIGN KEY (R_REPORT_ID) REFERENCES t_d_fmdreport (C_ID) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT FK_b70bv3dnuf80gkuewagi5f1yy FOREIGN KEY (R_AGRAUDIT_ID) REFERENCES t_d_fmdagrunitaudit (C_ID) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT FK_c1bww7qrr6mqndhnjo51c9oxf FOREIGN KEY (R_AUDIR_ID) REFERENCES t_d_agrunitaudit (C_ID) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT FK_pdbo66wagcmfll4bqon14y06m FOREIGN KEY (R_TASK_ID) REFERENCES t_d_task (C_ID) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 2294 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1; 添加SQL的字段注释内容：ALTER TABLE t_d_fmdreportdetail MODIFY COLUMN C_ID bigint(20) NOT NULL COMMENT '主键ID', MODIFY COLUMN C_CREATEAT datetime(0) NULL COMMENT '创建时间', MODIFY COLUMN C_CREATORID bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', MODIFY COLUMN C_CREATORNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人姓名', MODIFY COLUMN C_DELETED bit(1) NULL DEFAULT NULL COMMENT '是否删除', MODIFY COLUMN C_NAME varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称', MODIFY COLUMN C_REMARK varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', MODIFY COLUMN C_UPDATEAT datetime(0) NULL DEFAULT NULL COMMENT '更新时间', MODIFY COLUMN C_UPDATERID bigint(20) NULL DEFAULT NULL COMMENT '更新人ID', MODIFY COLUMN C_UPDATERNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人姓名', MODIFY COLUMN C_OWNERID bigint(20) NULL DEFAULT NULL COMMENT '所属人ID', MODIFY COLUMN f3 double NULL DEFAULT NULL COMMENT '字段3', MODIFY COLUMN f4 int(11) NULL DEFAULT NULL COMMENT '字段4', MODIFY COLUMN f5 int(11) NULL DEFAULT NULL COMMENT '字段5', MODIFY COLUMN f6 int(11) NULL DEFAULT NULL COMMENT '字段6', MODIFY COLUMN C_CITNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '城市名称', MODIFY COLUMN C_CITID bigint(20) NULL DEFAULT NULL COMMENT '城市ID', MODIFY COLUMN C_COUNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '县名称', MODIFY COLUMN C_COUID bigint(20) NULL DEFAULT NULL COMMENT '县ID', MODIFY COLUMN C_PRONAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省名称', MODIFY COLUMN C_PROID bigint(20) NULL DEFAULT NULL COMMENT '省ID', MODIFY COLUMN C_TOWNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '乡镇名称', MODIFY COLUMN C_TOWID bigint(20) NULL DEFAULT NULL COMMENT '乡镇ID', MODIFY COLUMN C_VILNAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '村名称', MODIFY COLUMN C_VILID bigint(20) NULL DEFAULT NULL COMMENT '村ID', MODIFY COLUMN R_AGRAUDIT_ID bigint(20) NULL DEFAULT NULL COMMENT '所属农业审核ID', MODIFY COLUMN R_AUDIR_ID bigint(20) NULL DEFAULT NULL COMMENT '所属审核ID', MODIFY COLUMN R_REPORT_ID bigint(20) NULL DEFAULT NULL COMMENT '所属报告ID', MODIFY COLUMN R_TASK_ID bigint(20) NULL DEFAULT NULL COMMENT '所属任务ID';