CREATE TABLE `material_category` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分类ID',
`tenant_id` BIGINT UNSIGNED NOT NULL COMMENT '租户ID',
`name` VARCHAR(100) NOT NULL COMMENT '分类名称',
`code` TINYINT UNSIGNED NOT NULL COMMENT '素材类型常量：1=发圈素材，2=图片素材，3=推广海报，4=常用文档，5=宣传彩页，6=营销话术，7=营销视频',
`created_at` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
UNIQUE KEY `uk_tenant_code` (`tenant_id`, `code`),
INDEX `idx_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='素材分类表';