t_d_sfdplace 表结构 - 乡村振兴平台数据库

CREATE TABLE t_d_sfdplace ( 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', C_LEVEL int(11) NULL DEFAULT NULL COMMENT '级别', 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', C_PLACEID 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_DETAIL_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', f28 int(11) NULL DEFAULT NULL COMMENT '行政村是否启动 是', f29 int(11) NULL DEFAULT NULL COMMENT '行政村是否启动 否', S_f28 int(11) NULL DEFAULT NULL COMMENT '历史行政村是否启动 是', S_f29 int(11) NULL DEFAULT NULL COMMENT '历史行政村是否启动 否', f30 int(11) NULL DEFAULT NULL COMMENT '是否涉农 1是 0否', f31 int(11) NULL DEFAULT NULL COMMENT '是否美丽宜居村 1是 0否', f32 int(11) NULL DEFAULT NULL COMMENT '是否特色精品村 1是 0否', PRIMARY KEY (C_ID) USING BTREE, INDEX FK_dpak4q3nnvmrxiusurxm7t5nv(R_AGRAUDIT_ID) USING BTREE, INDEX FK_7qv1ffbme8epuwr4q6jikdowq(R_AUDIR_ID) USING BTREE, INDEX FK_atseyjeidw5ebn3e42y4xp1rm(R_DETAIL_ID) USING BTREE, INDEX FK_i0m1dcwvvohf5idboksjva4n8(R_REPORT_ID) USING BTREE, INDEX FK_5qjxi7rt2lny72anbsrak8dlj(R_TASK_ID) USING BTREE, CONSTRAINT FK_5qjxi7rt2lny72anbsrak8dlj FOREIGN KEY (R_TASK_ID) REFERENCES t_d_task (C_ID) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT FK_7qv1ffbme8epuwr4q6jikdowq FOREIGN KEY (R_AUDIR_ID) REFERENCES t_d_agrunitaudit (C_ID) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT FK_atseyjeidw5ebn3e42y4xp1rm FOREIGN KEY (R_DETAIL_ID) REFERENCES t_d_sfdreportdetail (C_ID) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT FK_dpak4q3nnvmrxiusurxm7t5nv FOREIGN KEY (R_AGRAUDIT_ID) REFERENCES t_d_sfdagrunitaudit (C_ID) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT FK_i0m1dcwvvohf5idboksjva4n8 FOREIGN KEY (R_REPORT_ID) REFERENCES t_d_sfdreport (C_ID) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 27709 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;