31 lines
1.6 KiB
SQL
31 lines
1.6 KiB
SQL
-- 数字人 vs 真人"对抗学习"
|
|
-- 每周为每个 bot 选 1 个真实高赞真人帖，让 bot 吸收其"为什么高互动"的洞察
|
|
|
|
CREATE TABLE `bot_adversarial_learnings` (
|
|
`id` INT NOT NULL AUTO_INCREMENT,
|
|
`bot_id` INT NOT NULL,
|
|
`week_key` VARCHAR(20) NOT NULL,
|
|
`source_ref_type` VARCHAR(20) NOT NULL,
|
|
`source_ref_id` INT NOT NULL,
|
|
`source_user_id` INT NOT NULL,
|
|
`source_user_name` VARCHAR(50) NULL,
|
|
`forum_slug` VARCHAR(30) NULL,
|
|
`source_title` VARCHAR(200) NULL,
|
|
`source_content` TEXT NOT NULL,
|
|
`source_metrics` JSON NOT NULL,
|
|
`relevance_score` DOUBLE NOT NULL DEFAULT 0,
|
|
`learned_insight` TEXT NOT NULL,
|
|
`learn_categories` JSON NULL,
|
|
`status` VARCHAR(20) NOT NULL DEFAULT 'active',
|
|
`used_count` INT NOT NULL DEFAULT 0,
|
|
`learned_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
|
|
`expires_at` DATETIME(3) NULL,
|
|
`created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
|
|
`updated_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE INDEX `bot_adversarial_learnings_bot_id_week_key_key`(`bot_id`, `week_key`),
|
|
INDEX `bot_adversarial_learnings_bot_id_status_idx`(`bot_id`, `status`),
|
|
INDEX `bot_adversarial_learnings_week_key_idx`(`week_key`),
|
|
INDEX `bot_adversarial_learnings_source_ref_type_source_ref_id_idx`(`source_ref_type`, `source_ref_id`)
|
|
);
|