分类表

CREATE TABLE info_category (
id int(11) NOT NULL AUTO_INCREMENT COMMENT '分类ID',
parent_id int(11) DEFAULT NULL COMMENT '父分类ID',
category_name varchar(100) NOT NULL COMMENT '分类名称',
level int(11) NOT NULL COMMENT '分类级别',
PRIMARY KEY (id)
) AUTO_INCREMENT = 2000015 AUTO_INCREMENT_MODE = 'ORDER' DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 2 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 COMMENT = '分类信息表';