CREATE TABLE t_d_fmdplace C_ID bigint20 NOT NULL AUTO_INCREMENT C_CREATEAT datetime0 NULL C_CREATORID bigint20 NULL DEFAULT NULL C_CREATORNAME varchar50 CHARACTER SET utf8mb4 COLLATE utf8mb4_gen

ALTER TABLE t_d_fmdplace MODIFY COLUMN C_ID bigint(20) NOT NULL AUTO_INCREMENT 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 C_LEVEL int(11) NULL DEFAULT NULL COMMENT '级别', 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 C_PLACEID 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_DETAIL_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'