invest-research-backend/sql/政策面文档sqlite初始化.sql

PRAGMA foreign_keys = ON;

PRAGMA journal_mode = WAL;


-- 模式: 仅插入数据. 假设 indicator / document / document_summary 三表已存在 (indicator 来自基本面/政策面脚本).
-- 重复执行安全: indicator 用 INSERT OR IGNORE (同一 category+subcategory 不会重复);
--                document 用 INSERT OR IGNORE (依赖 UNIQUE(category_id, period));
--                document_summary 用 INSERT OR IGNORE (依赖 UNIQUE(document_id)).
-- 临时表 _cat_map 记录 (category, subcategory) -> indicator.id, 用于解析外键.

CREATE TEMP TABLE _cat_map (category TEXT, subcategory TEXT, indicator_id INTEGER);

INSERT INTO _cat_map (category, subcategory, indicator_id)

  SELECT category, subcategory, id FROM indicator WHERE subcategory IS NOT NULL;


-- 阶段1: 章节行 upsert 到 indicator
INSERT OR IGNORE INTO indicator (category, subcategory, name, frequency, source)
  SELECT '政策面', '2.9 央行货政报告', '央行货币政策执行报告', '季', '中国人民银行'
  WHERE NOT EXISTS (SELECT 1 FROM indicator WHERE category='政策面' AND subcategory='2.9 央行货政报告');
INSERT INTO _cat_map (category, subcategory, indicator_id)
  SELECT category, subcategory, id FROM indicator
  WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM _cat_map cm WHERE cm.category='政策面' AND cm.subcategory='2.9 央行货政报告' AND cm.indicator_id=indicator.id);

INSERT OR IGNORE INTO indicator (category, subcategory, name, frequency, source)
  SELECT '政策面', '2.10 央行货币政策例会', '央行货币政策委员会例会', '季', '中国人民银行'
  WHERE NOT EXISTS (SELECT 1 FROM indicator WHERE category='政策面' AND subcategory='2.10 央行货币政策例会');
INSERT INTO _cat_map (category, subcategory, indicator_id)
  SELECT category, subcategory, id FROM indicator
  WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM _cat_map cm WHERE cm.category='政策面' AND cm.subcategory='2.10 央行货币政策例会' AND cm.indicator_id=indicator.id);

INSERT OR IGNORE INTO indicator (category, subcategory, name, frequency, source)
  SELECT '重要会议', '3.1 中央经济工作会议', '中央经济工作会议', '季', '中国人民银行'
  WHERE NOT EXISTS (SELECT 1 FROM indicator WHERE category='重要会议' AND subcategory='3.1 中央经济工作会议');
INSERT INTO _cat_map (category, subcategory, indicator_id)
  SELECT category, subcategory, id FROM indicator
  WHERE category='重要会议' AND subcategory='3.1 中央经济工作会议'
    AND NOT EXISTS (SELECT 1 FROM _cat_map cm WHERE cm.category='重要会议' AND cm.subcategory='3.1 中央经济工作会议' AND cm.indicator_id=indicator.id);

INSERT OR IGNORE INTO indicator (category, subcategory, name, frequency, source)
  SELECT '重要会议', '3.2 政府工作报告', '政府工作报告', '季', '中国人民银行'
  WHERE NOT EXISTS (SELECT 1 FROM indicator WHERE category='重要会议' AND subcategory='3.2 政府工作报告');
INSERT INTO _cat_map (category, subcategory, indicator_id)
  SELECT category, subcategory, id FROM indicator
  WHERE category='重要会议' AND subcategory='3.2 政府工作报告'
    AND NOT EXISTS (SELECT 1 FROM _cat_map cm WHERE cm.category='重要会议' AND cm.subcategory='3.2 政府工作报告' AND cm.indicator_id=indicator.id);

INSERT OR IGNORE INTO indicator (category, subcategory, name, frequency, source)
  SELECT '重要会议', '3.3 政治局会议', '中央政治局会议', '季', '中国人民银行'
  WHERE NOT EXISTS (SELECT 1 FROM indicator WHERE category='重要会议' AND subcategory='3.3 政治局会议');
INSERT INTO _cat_map (category, subcategory, indicator_id)
  SELECT category, subcategory, id FROM indicator
  WHERE category='重要会议' AND subcategory='3.3 政治局会议'
    AND NOT EXISTS (SELECT 1 FROM _cat_map cm WHERE cm.category='重要会议' AND cm.subcategory='3.3 政治局会议' AND cm.indicator_id=indicator.id);

INSERT OR IGNORE INTO indicator (category, subcategory, name, frequency, source)
  SELECT '产业政策', '4.1 十五五规划', '十五五规划纲要', '季', '中国人民银行'
  WHERE NOT EXISTS (SELECT 1 FROM indicator WHERE category='产业政策' AND subcategory='4.1 十五五规划');
INSERT INTO _cat_map (category, subcategory, indicator_id)
  SELECT category, subcategory, id FROM indicator
  WHERE category='产业政策' AND subcategory='4.1 十五五规划'
    AND NOT EXISTS (SELECT 1 FROM _cat_map cm WHERE cm.category='产业政策' AND cm.subcategory='4.1 十五五规划' AND cm.indicator_id=indicator.id);


-- 阶段2: 每份 PDF 一行 document
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2026Q2', 2026, '2026Q2-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2026Q2-中国货币政策例会.pdf', 222123, '2026-06-28', 8, 1, 1
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2026Q2');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2026Q1', 2026, '2026Q1-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2026Q1-中国货币政策例会.pdf', 223485, NULL, NULL, 0, 2
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2026Q1');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2025Q4', 2025, '2025Q4-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2025Q4-中国货币政策例会.pdf', 235103, NULL, NULL, 0, 3
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2025Q4');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2025Q3', 2025, '2025Q3-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2025Q3-中国货币政策例会.pdf', 246103, NULL, NULL, 0, 4
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2025Q3');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2025Q2', 2025, '2025Q2-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2025Q2-中国货币政策例会.pdf', 243292, NULL, NULL, 0, 5
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2025Q2');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2025Q1', 2025, '2025Q1-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2025Q1-中国货币政策例会.pdf', 246034, NULL, NULL, 0, 6
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2025Q1');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2024Q4', 2024, '2024Q4-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2024Q4-中国货币政策例会.pdf', 252055, NULL, NULL, 0, 7
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2024Q4');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2024Q3', 2024, '2024Q3-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2024Q3-中国货币政策例会.pdf', 242751, NULL, NULL, 0, 8
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2024Q3');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2024Q2', 2024, '2024Q2-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2024Q2-中国货币政策例会.pdf', 240041, NULL, NULL, 0, 9
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2024Q2');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2024Q1', 2024, '2024Q1-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2024Q1-中国货币政策例会.pdf', 243700, NULL, NULL, 0, 10
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2024Q1');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2023Q4', 2023, '2023Q4-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2023Q4-中国货币政策例会.pdf', 246547, NULL, NULL, 0, 11
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2023Q4');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2023Q3', 2023, '2023Q3-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2023Q3-中国货币政策例会.pdf', 238062, NULL, NULL, 0, 12
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2023Q3');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2023Q2', 2023, '2023Q2-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2023Q2-中国货币政策例会.pdf', 238684, NULL, NULL, 0, 13
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2023Q2');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2023Q1', 2023, '2023Q1-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2023Q1-中国货币政策例会.pdf', 228530, NULL, NULL, 0, 14
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2023Q1');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2022Q4', 2022, '2022Q4-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2022Q4-中国货币政策例会.pdf', 239895, NULL, NULL, 0, 15
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2022Q4');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2022Q3', 2022, '2022Q3-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2022Q3-中国货币政策例会.pdf', 243536, NULL, NULL, 0, 16
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2022Q3');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2022Q2', 2022, '2022Q2-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2022Q2-中国货币政策例会.pdf', 228338, NULL, NULL, 0, 17
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2022Q2');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2022Q1', 2022, '2022Q1-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2022Q1-中国货币政策例会.pdf', 220822, NULL, NULL, 0, 18
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2022Q1');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2021Q4', 2021, '2021Q4-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2021Q4-中国货币政策例会.pdf', 217996, NULL, NULL, 0, 19
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2021Q4');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2021Q3', 2021, '2021Q3-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2021Q3-中国货币政策例会.pdf', 222550, NULL, NULL, 0, 20
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2021Q3');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2021Q2', 2021, '2021Q2-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2021Q2-中国货币政策例会.pdf', 217532, NULL, NULL, 0, 21
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2021Q2');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2021Q1', 2021, '2021Q1-中国货币政策例会', 'data/uploads/2.10-货币政策例会/2021Q1-中国货币政策例会.pdf', 220305, NULL, NULL, 0, 22
  FROM _cat_map WHERE category='政策面' AND subcategory='2.10 央行货币政策例会'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.10 央行货币政策例会' AND d2.period='2021Q1');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2026Q2', 2026, '2026Q2-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2026Q2-中国货币政策执行报告.pdf', 3882665, '2026-08-15', 65, 1, 1
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2026Q2');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2026Q1', 2026, '2026Q1-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2026Q1-中国货币政策执行报告.pdf', 1265472, NULL, NULL, 0, 2
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2026Q1');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2025Q4', 2025, '2025Q4-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2025Q4-中国货币政策执行报告.pdf', 1546495, NULL, NULL, 0, 3
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2025Q4');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2025Q3', 2025, '2025Q3-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2025Q3-中国货币政策执行报告.pdf', 1274418, NULL, NULL, 0, 4
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2025Q3');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2025Q2', 2025, '2025Q2-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2025Q2-中国货币政策执行报告.pdf', 1761434, NULL, NULL, 0, 5
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2025Q2');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2025Q1', 2025, '2025Q1-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2025Q1-中国货币政策执行报告.pdf', 1423468, NULL, NULL, 0, 6
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2025Q1');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2024Q4', 2024, '2024Q4-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2024Q4-中国货币政策执行报告.pdf', 1270128, NULL, NULL, 0, 7
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2024Q4');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2024Q3', 2024, '2024Q3-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2024Q3-中国货币政策执行报告.pdf', 1379731, NULL, NULL, 0, 8
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2024Q3');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2024Q2', 2024, '2024Q2-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2024Q2-中国货币政策执行报告.pdf', 1275961, NULL, NULL, 0, 9
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2024Q2');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2024Q1', 2024, '2024Q1-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2024Q1-中国货币政策执行报告.pdf', 1264433, NULL, NULL, 0, 10
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2024Q1');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2023Q4', 2023, '2023Q4-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2023Q4-中国货币政策执行报告.pdf', 1265272, NULL, NULL, 0, 11
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2023Q4');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2023Q3', 2023, '2023Q3-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2023Q3-中国货币政策执行报告.pdf', 1283558, NULL, NULL, 0, 12
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2023Q3');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2023Q2', 2023, '2023Q2-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2023Q2-中国货币政策执行报告.pdf', 1300252, NULL, NULL, 0, 13
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2023Q2');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2023Q1', 2023, '2023Q1-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2023Q1-中国货币政策执行报告.pdf', 1353358, NULL, NULL, 0, 14
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2023Q1');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2022Q4', 2022, '2022Q4-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2022Q4-中国货币政策执行报告.pdf', 1404546, NULL, NULL, 0, 15
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2022Q4');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2022Q3', 2022, '2022Q3-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2022Q3-中国货币政策执行报告.pdf', 1034096, NULL, NULL, 0, 16
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2022Q3');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2022Q2', 2022, '2022Q2-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2022Q2-中国货币政策执行报告.pdf', 1555438, NULL, NULL, 0, 17
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2022Q2');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2022Q1', 2022, '2022Q1-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2022Q1-中国货币政策执行报告.pdf', 1274643, NULL, NULL, 0, 18
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2022Q1');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2021Q4', 2021, '2021Q4-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2021Q4-中国货币政策执行报告.pdf', 1539623, NULL, NULL, 0, 19
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2021Q4');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2021Q3', 2021, '2021Q3-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2021Q3-中国货币政策执行报告.pdf', 1532025, NULL, NULL, 0, 20
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2021Q3');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2021Q2', 2021, '2021Q2-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2021Q2-中国货币政策执行报告.pdf', 1576939, NULL, NULL, 0, 21
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2021Q2');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2021Q1', 2021, '2021Q1-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2021Q1-中国货币政策执行报告.pdf', 1469844, NULL, NULL, 0, 22
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2021Q1');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2020Q4', 2020, '2020Q4-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2020Q4-中国货币政策执行报告.pdf', 1723498, NULL, NULL, 0, 23
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2020Q4');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2020Q3', 2020, '2020Q3-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2020Q3-中国货币政策执行报告.pdf', 1526907, NULL, NULL, 0, 24
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2020Q3');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2020Q2', 2020, '2020Q2-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2020Q2-中国货币政策执行报告.pdf', 1473232, NULL, NULL, 0, 25
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2020Q2');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2020Q1', 2020, '2020Q1-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2020Q1-中国货币政策执行报告.pdf', 1413116, NULL, NULL, 0, 26
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2020Q1');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2019Q4', 2019, '2019Q4-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2019Q4-中国货币政策执行报告.pdf', 1740875, NULL, NULL, 0, 27
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2019Q4');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2019Q3', 2019, '2019Q3-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2019Q3-中国货币政策执行报告.pdf', 1578398, NULL, NULL, 0, 28
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2019Q3');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2019Q2', 2019, '2019Q2-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2019Q2-中国货币政策执行报告.pdf', 1515933, NULL, NULL, 0, 29
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2019Q2');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2019Q1', 2019, '2019Q1-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2019Q1-中国货币政策执行报告.pdf', 1638999, NULL, NULL, 0, 30
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2019Q1');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2018Q4', 2018, '2018Q4-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2018Q4-中国货币政策执行报告.pdf', 1232928, NULL, NULL, 0, 31
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2018Q4');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2018Q3', 2018, '2018Q3-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2018Q3-中国货币政策执行报告.pdf', 801162, NULL, NULL, 0, 32
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2018Q3');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2018Q2', 2018, '2018Q2-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2018Q2-中国货币政策执行报告.pdf', 709809, NULL, NULL, 0, 33
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2018Q2');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2018Q1', 2018, '2018Q1-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2018Q1-中国货币政策执行报告.pdf', 690351, NULL, NULL, 0, 34
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2018Q1');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2017Q4', 2017, '2017Q4-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2017Q4-中国货币政策执行报告.pdf', 680198, NULL, NULL, 0, 35
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2017Q4');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2017Q3', 2017, '2017Q3-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2017Q3-中国货币政策执行报告.pdf', 685261, NULL, NULL, 0, 36
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2017Q3');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2017Q2', 2017, '2017Q2-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2017Q2-中国货币政策执行报告.pdf', 749646, NULL, NULL, 0, 37
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2017Q2');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2017Q1', 2017, '2017Q1-中国货币政策执行报告', 'data/uploads/2.9-货币政策执行报告/2017Q1-中国货币政策执行报告.pdf', 666783, NULL, NULL, 0, 38
  FROM _cat_map WHERE category='政策面' AND subcategory='2.9 央行货政报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='政策面' AND cm2.subcategory='2.9 央行货政报告' AND d2.period='2017Q1');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2025年', 2025, '2025年-中央经济工作会议', 'data/uploads/3.1-中央经济工作会议/2025年-中央经济工作会议.pdf', 351515, '2025-12-12', 12, 1, 1
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.1 中央经济工作会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.1 中央经济工作会议' AND d2.period='2025年');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2024年', 2024, '2024年-中央经济工作会议', 'data/uploads/3.1-中央经济工作会议/2024年-中央经济工作会议.pdf', 378088, NULL, NULL, 0, 2
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.1 中央经济工作会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.1 中央经济工作会议' AND d2.period='2024年');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2023年', 2023, '2023年-中央经济工作会议', 'data/uploads/3.1-中央经济工作会议/2023年-中央经济工作会议.pdf', 372701, NULL, NULL, 0, 3
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.1 中央经济工作会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.1 中央经济工作会议' AND d2.period='2023年');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2022年', 2022, '2022年-中央经济工作会议', 'data/uploads/3.1-中央经济工作会议/2022年-中央经济工作会议.pdf', 397365, NULL, NULL, 0, 4
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.1 中央经济工作会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.1 中央经济工作会议' AND d2.period='2022年');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2021年', 2021, '2021年-中央经济工作会议', 'data/uploads/3.1-中央经济工作会议/2021年-中央经济工作会议.pdf', 379543, NULL, NULL, 0, 5
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.1 中央经济工作会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.1 中央经济工作会议' AND d2.period='2021年');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2020年', 2020, '2020年-中央经济工作会议', 'data/uploads/3.1-中央经济工作会议/2020年-中央经济工作会议.pdf', 403129, NULL, NULL, 0, 6
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.1 中央经济工作会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.1 中央经济工作会议' AND d2.period='2020年');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2026年', 2026, '2026年-政府工作报告', 'data/uploads/3.2-政府工作报告/2026年-政府工作报告.pdf', 658517, '2026-03-05', 38, 1, 1
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.2 政府工作报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.2 政府工作报告' AND d2.period='2026年');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2025年', 2025, '2025年-政府工作报告', 'data/uploads/3.2-政府工作报告/2025年-政府工作报告.pdf', 658002, NULL, NULL, 0, 2
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.2 政府工作报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.2 政府工作报告' AND d2.period='2025年');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2024年', 2024, '2024年-政府工作报告', 'data/uploads/3.2-政府工作报告/2024年-政府工作报告.pdf', 651610, NULL, NULL, 0, 3
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.2 政府工作报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.2 政府工作报告' AND d2.period='2024年');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2023年', 2023, '2023年-政府工作报告', 'data/uploads/3.2-政府工作报告/2023年-政府工作报告.pdf', 646076, NULL, NULL, 0, 4
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.2 政府工作报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.2 政府工作报告' AND d2.period='2023年');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2022年', 2022, '2022年-政府工作报告', 'data/uploads/3.2-政府工作报告/2022年-政府工作报告.pdf', 655290, NULL, NULL, 0, 5
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.2 政府工作报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.2 政府工作报告' AND d2.period='2022年');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2021年', 2021, '2021年-政府工作报告', 'data/uploads/3.2-政府工作报告/2021年-政府工作报告.pdf', 645926, NULL, NULL, 0, 6
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.2 政府工作报告'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.2 政府工作报告' AND d2.period='2021年');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2026-07-30', 2026, '2026-07-30-政治局会议', 'data/uploads/3.3-政治局会议/2026-07-30-政治局会议.pdf', 266848, '2026-07-30', 6, 1, 1
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.3 政治局会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.3 政治局会议' AND d2.period='2026-07-30');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2026-04-28', 2026, '2026-04-28-政治局会议', 'data/uploads/3.3-政治局会议/2026-04-28-政治局会议.pdf', 244043, NULL, NULL, 0, 2
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.3 政治局会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.3 政治局会议' AND d2.period='2026-04-28');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2025-12-08', 2025, '2025-12-08-政治局会议', 'data/uploads/3.3-政治局会议/2025-12-08-政治局会议.pdf', 213680, NULL, NULL, 0, 3
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.3 政治局会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.3 政治局会议' AND d2.period='2025-12-08');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2025-07-30', 2025, '2025-07-30-政治局会议', 'data/uploads/3.3-政治局会议/2025-07-30-政治局会议.pdf', 261130, NULL, NULL, 0, 4
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.3 政治局会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.3 政治局会议' AND d2.period='2025-07-30');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2025-04-25', 2025, '2025-04-25-政治局会议', 'data/uploads/3.3-政治局会议/2025-04-25-政治局会议.pdf', 226776, NULL, NULL, 0, 5
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.3 政治局会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.3 政治局会议' AND d2.period='2025-04-25');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2024-09-26', 2024, '2024-09-26-政治局会议', 'data/uploads/3.3-政治局会议/2024-09-26-政治局会议.pdf', 254911, NULL, NULL, 0, 6
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.3 政治局会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.3 政治局会议' AND d2.period='2024-09-26');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2024-07-30', 2024, '2024-07-30-政治局会议', 'data/uploads/3.3-政治局会议/2024-07-30-政治局会议.pdf', 297735, NULL, NULL, 0, 7
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.3 政治局会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.3 政治局会议' AND d2.period='2024-07-30');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2024-04-30', 2024, '2024-04-30-政治局会议', 'data/uploads/3.3-政治局会议/2024-04-30-政治局会议.pdf', 292892, NULL, NULL, 0, 8
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.3 政治局会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.3 政治局会议' AND d2.period='2024-04-30');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2023-12-08', 2023, '2023-12-08-政治局会议', 'data/uploads/3.3-政治局会议/2023-12-08-政治局会议.pdf', 252493, NULL, NULL, 0, 9
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.3 政治局会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.3 政治局会议' AND d2.period='2023-12-08');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2023-07-24', 2023, '2023-07-24-政治局会议', 'data/uploads/3.3-政治局会议/2023-07-24-政治局会议.pdf', 256708, NULL, NULL, 0, 10
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.3 政治局会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.3 政治局会议' AND d2.period='2023-07-24');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2023-04-28', 2023, '2023-04-28-政治局会议', 'data/uploads/3.3-政治局会议/2023-04-28-政治局会议.pdf', 240613, NULL, NULL, 0, 11
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.3 政治局会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.3 政治局会议' AND d2.period='2023-04-28');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2022-12-06', 2022, '2022-12-06-政治局会议', 'data/uploads/3.3-政治局会议/2022-12-06-政治局会议.pdf', 273137, NULL, NULL, 0, 12
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.3 政治局会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.3 政治局会议' AND d2.period='2022-12-06');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2022-07-28', 2022, '2022-07-28-政治局会议', 'data/uploads/3.3-政治局会议/2022-07-28-政治局会议.pdf', 271288, NULL, NULL, 0, 13
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.3 政治局会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.3 政治局会议' AND d2.period='2022-07-28');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2022-04-29', 2022, '2022-04-29-政治局会议', 'data/uploads/3.3-政治局会议/2022-04-29-政治局会议.pdf', 261635, NULL, NULL, 0, 14
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.3 政治局会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.3 政治局会议' AND d2.period='2022-04-29');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2021-12-06', 2021, '2021-12-06-政治局会议', 'data/uploads/3.3-政治局会议/2021-12-06-政治局会议.pdf', 267246, NULL, NULL, 0, 15
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.3 政治局会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.3 政治局会议' AND d2.period='2021-12-06');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2021-07-30', 2021, '2021-07-30-政治局会议', 'data/uploads/3.3-政治局会议/2021-07-30-政治局会议.pdf', 238462, NULL, NULL, 0, 16
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.3 政治局会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.3 政治局会议' AND d2.period='2021-07-30');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '2021-04-30', 2021, '2021-04-30-政治局会议', 'data/uploads/3.3-政治局会议/2021-04-30-政治局会议.pdf', 281617, NULL, NULL, 0, 17
  FROM _cat_map WHERE category='重要会议' AND subcategory='3.3 政治局会议'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='重要会议' AND cm2.subcategory='3.3 政治局会议' AND d2.period='2021-04-30');
INSERT OR IGNORE INTO document (category_id, period, period_year, title, file_path, file_size, publish_date, page_count, is_latest, sort_order)
  SELECT indicator_id, '十五五', NULL, '十五五规划纲要', 'data/uploads/4.1-十五五规划/十五五规划纲要.pdf', 11281148, '2026-03-13', 128, 1, 1
  FROM _cat_map WHERE category='产业政策' AND subcategory='4.1 十五五规划'
    AND NOT EXISTS (SELECT 1 FROM document d2 JOIN _cat_map cm2 ON cm2.indicator_id = d2.category_id WHERE cm2.category='产业政策' AND cm2.subcategory='4.1 十五五规划' AND d2.period='十五五');

-- 阶段3: 最新期 document_summary
INSERT OR IGNORE INTO document_summary (document_id, overall_tone, policy_stance, risk_control, key_points_json, updated_at)
  SELECT d.id, '加大逆周期调节力度', '保持流动性合理充裕', '防范资金空转', '[]', datetime('now')
  FROM document d JOIN _cat_map cm ON cm.indicator_id = d.category_id
  WHERE cm.category='政策面' AND cm.subcategory='2.10 央行货币政策例会' AND d.period='2026Q2'
    AND NOT EXISTS (SELECT 1 FROM document_summary s2 WHERE s2.document_id = d.id);
INSERT OR IGNORE INTO document_summary (document_id, overall_tone, policy_stance, risk_control, key_points_json, updated_at)
  SELECT d.id, '坚持稳中求进,加大逆周期调节', '稳健偏宽松,保持流动性合理充裕', '稳妥处置地方债务、房地产金融风险', '[{"section": "结构性工具", "text": "科技创新再贷款 4000 亿 · 设备更新 5000 亿", "change": "新增"}, {"section": "汇率", "text": "必要时进行逆周期调节,防止超调", "change": "强调"}, {"section": "重点领域", "text": "五篇大文章:科技/绿色/普惠/养老/数字", "change": "延续"}, {"section": "房地产", "text": "保交楼专项再贷款政策延续,扩大白名单", "change": "加大"}]', datetime('now')
  FROM document d JOIN _cat_map cm ON cm.indicator_id = d.category_id
  WHERE cm.category='政策面' AND cm.subcategory='2.9 央行货政报告' AND d.period='2026Q2'
    AND NOT EXISTS (SELECT 1 FROM document_summary s2 WHERE s2.document_id = d.id);
INSERT OR IGNORE INTO document_summary (document_id, overall_tone, policy_stance, risk_control, key_points_json, updated_at)
  SELECT d.id, '稳中求进、以进促稳', '适度宽松', '守住不发生系统性风险底线', '[]', datetime('now')
  FROM document d JOIN _cat_map cm ON cm.indicator_id = d.category_id
  WHERE cm.category='重要会议' AND cm.subcategory='3.1 中央经济工作会议' AND d.period='2025年'
    AND NOT EXISTS (SELECT 1 FROM document_summary s2 WHERE s2.document_id = d.id);
INSERT OR IGNORE INTO document_summary (document_id, overall_tone, policy_stance, risk_control, key_points_json, updated_at)
  SELECT d.id, '推动经济高质量发展', '财政政策更加积极、货币政策适度宽松', '有效防范化解重大风险', '[]', datetime('now')
  FROM document d JOIN _cat_map cm ON cm.indicator_id = d.category_id
  WHERE cm.category='重要会议' AND cm.subcategory='3.2 政府工作报告' AND d.period='2026年'
    AND NOT EXISTS (SELECT 1 FROM document_summary s2 WHERE s2.document_id = d.id);
INSERT OR IGNORE INTO document_summary (document_id, overall_tone, policy_stance, risk_control, key_points_json, updated_at)
  SELECT d.id, '做好下半年经济工作', '财政货币协同发力', '房地产/地方债风险化解', '[]', datetime('now')
  FROM document d JOIN _cat_map cm ON cm.indicator_id = d.category_id
  WHERE cm.category='重要会议' AND cm.subcategory='3.3 政治局会议' AND d.period='2026-07-30'
    AND NOT EXISTS (SELECT 1 FROM document_summary s2 WHERE s2.document_id = d.id);
INSERT OR IGNORE INTO document_summary (document_id, overall_tone, policy_stance, risk_control, key_points_json, updated_at)
  SELECT d.id, '高质量发展', '建设现代化产业体系', '统筹发展与安全', '[]', datetime('now')
  FROM document d JOIN _cat_map cm ON cm.indicator_id = d.category_id
  WHERE cm.category='产业政策' AND cm.subcategory='4.1 十五五规划' AND d.period='十五五'
    AND NOT EXISTS (SELECT 1 FROM document_summary s2 WHERE s2.document_id = d.id);

DROP TABLE _cat_map;

-- 查询示例: 2.9 章节最新期摘要 + 元数据
-- SELECT i.subcategory, i.name, d.period, d.title, d.file_path, d.publish_date, d.page_count, s.overall_tone, s.policy_stance, s.risk_control, s.key_points_json
-- FROM indicator i
-- JOIN document d ON d.category_id = i.id AND d.is_latest = 1
-- LEFT JOIN document_summary s ON s.document_id = d.id
-- WHERE i.subcategory = '2.9 央行货政报告';