-- ============================================================
-- 清空并重建项目10的要素表和值表
-- 基于模板.docx中的动态要素 {{...}} 与原文.docx对照
-- ============================================================

BEGIN;

-- 1. 删除旧的值节点的属性、边、节点
DELETE FROM node_properties WHERE node_id IN (
  SELECT n.id FROM nodes n JOIN edges e ON e.to_node_id = n.id
  WHERE e.from_node_id = 10 AND n.node_type = 'VALUE'
);
DELETE FROM edges WHERE to_node_id IN (
  SELECT n.id FROM nodes n JOIN edges e ON e.to_node_id = n.id
  WHERE e.from_node_id = 10 AND n.node_type = 'VALUE'
);
DELETE FROM nodes WHERE id IN (
  SELECT n.id FROM nodes n JOIN edges e ON e.to_node_id = n.id
  WHERE e.from_node_id = 10 AND n.node_type = 'VALUE'
);

-- 2. 删除旧的要素节点的属性、边、节点
DELETE FROM node_properties WHERE node_id IN (
  SELECT n.id FROM nodes n JOIN edges e ON e.to_node_id = n.id
  WHERE e.from_node_id = 10 AND n.node_type = 'ELEMENT'
);
DELETE FROM edges WHERE to_node_id IN (
  SELECT n.id FROM nodes n JOIN edges e ON e.to_node_id = n.id
  WHERE e.from_node_id = 10 AND n.node_type = 'ELEMENT'
);
DELETE FROM nodes WHERE id IN (
  SELECT n.id FROM nodes n JOIN edges e ON e.to_node_id = n.id
  WHERE e.from_node_id = 10 AND n.node_type = 'ELEMENT'
);

-- ============================================================
-- 3. 插入要素节点 (ELEMENT) — 47个动态要素
--    ID 从 701 开始（要素），801 开始（值）
-- ============================================================

-- === basicInfo 命名空间 ===
INSERT INTO nodes (id, node_type, node_key, name) VALUES
(701, 'ELEMENT', 'basicInfo.projectCode',                '项目编号'),
(702, 'ELEMENT', 'basicInfo.requestLevel',               '申请级别'),
(703, 'ELEMENT', 'basicInfo.reviewObjectCertificateGetAt','获证日期'),
(704, 'ELEMENT', 'basicInfo.reviewObjectCertificate2GetAt','通过评审日期'),
(705, 'ELEMENT', 'basicInfo.applyAt',                    '申请日期');

-- === project 命名空间 ===
INSERT INTO nodes (id, node_type, node_key, name) VALUES
(706, 'ELEMENT', 'project.reviewObject',                 '评审对象'),
(707, 'ELEMENT', 'project.reviewObjectAlias',            '评审对象简称'),
(708, 'ELEMENT', 'project.resultScore',                  '评审得分'),
(709, 'ELEMENT', 'project.resultLevel',                  '评审结论级别'),
(710, 'ELEMENT', 'project.workStartAt',                  '评审开始日期'),
(711, 'ELEMENT', 'project.workEndAt',                    '评审结束日期'),
(712, 'ELEMENT', 'project.createdAt',                    '报告日期'),
(713, 'ELEMENT', 'project.reviewObjectSummary',          '评审对象概况'),
(714, 'ELEMENT', 'project.reviewObjectDescription',      '评审对象简介'),
(715, 'ELEMENT', 'project.reviewPeriod',                 '评审期'),
(716, 'ELEMENT', 'project.target',                       '目标'),
(717, 'ELEMENT', 'project.duty',                         '职责'),
(718, 'ELEMENT', 'project.fullParticipation',            '全员参与'),
(719, 'ELEMENT', 'project.safetyInvestment',             '安全投入'),
(720, 'ELEMENT', 'project.safetyCulture',                '安全文化'),
(721, 'ELEMENT', 'project.systematicManagement',         '体系化管理'),
(722, 'ELEMENT', 'project.employeeTraining',             '人员教育培训'),
(723, 'ELEMENT', 'project.assetManagement',              '设备设施管理'),
(724, 'ELEMENT', 'project.jobSafety',                    '作业安全'),
(725, 'ELEMENT', 'project.positionQualified',            '岗位达标'),
(726, 'ELEMENT', 'project.partner',                      '相关方'),
(727, 'ELEMENT', 'project.occupationalHealth',           '职业健康'),
(728, 'ELEMENT', 'project.riskAssessment',               '风险辨识与评价'),
(729, 'ELEMENT', 'project.majorHazardManagement',        '重大危险源管理'),
(730, 'ELEMENT', 'project.hazardInspection',             '隐患排查'),
(731, 'ELEMENT', 'project.changeManagement',             '变更管理'),
(732, 'ELEMENT', 'project.earlyWarning',                 '预测预警'),
(733, 'ELEMENT', 'project.emergencyResponse',            '应急救援'),
(734, 'ELEMENT', 'project.incidentManagement',           '事故管理'),
(735, 'ELEMENT', 'project.continuousImprovement',        '持续改进'),
(736, 'ELEMENT', 'project.safetyStandardizationStatus',  '标准化建设运行情况'),
(737, 'ELEMENT', 'project.safetyHighlight',              '安全生产管理亮点'),
(738, 'ELEMENT', 'project.reviewObjectSelfAssessmentProcess', '自评过程'),
(739, 'ELEMENT', 'project.moreWorkReference',            '其他工作依据'),
(740, 'ELEMENT', 'project.reviewRange',                  '复审范围'),
(741, 'ELEMENT', 'project.workProcess',                  '复审工作过程'),
(742, 'ELEMENT', 'project.closingMeetingAt',             '末次会议时间');

-- === 表格/列表类要素（+前缀表示动态表格或列表） ===
INSERT INTO nodes (id, node_type, node_key, name) VALUES
(743, 'ELEMENT', '+SPSRRReviewProject',                  '现场复审项目'),
(744, 'ELEMENT', '+SPSRRReviewer',                       '现场复审人员'),
(745, 'ELEMENT', '+review_status',                       '现场复审情况'),
(746, 'ELEMENT', '+target_responsibility',               '目标职责'),
(747, 'ELEMENT', '+institutionalized_management',        '制度化管理');

-- ============================================================
-- 4. 要素属性
-- ============================================================

-- basicInfo 命名空间
INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES
-- 701: basicInfo.projectCode
(701, 'namespace', 'basicInfo'), (701, 'field_name', 'projectCode'),
(701, 'element_type', 'text'), (701, 'required', 'true'),
(701, 'description', '项目编号，格式如 BZ-0092-2024'),
-- 702: basicInfo.requestLevel
(702, 'namespace', 'basicInfo'), (702, 'field_name', 'requestLevel'),
(702, 'element_type', 'text'), (702, 'required', 'true'),
(702, 'description', '申请类别级别，如一级'),
-- 703: basicInfo.reviewObjectCertificateGetAt
(703, 'namespace', 'basicInfo'), (703, 'field_name', 'reviewObjectCertificateGetAt'),
(703, 'element_type', 'text'), (703, 'required', 'false'),
(703, 'description', '获得安全生产标准化证书日期'),
-- 704: basicInfo.reviewObjectCertificate2GetAt
(704, 'namespace', 'basicInfo'), (704, 'field_name', 'reviewObjectCertificate2GetAt'),
(704, 'element_type', 'text'), (704, 'required', 'false'),
(704, 'description', '通过标准化评审日期'),
-- 705: basicInfo.applyAt
(705, 'namespace', 'basicInfo'), (705, 'field_name', 'applyAt'),
(705, 'element_type', 'text'), (705, 'required', 'true'),
(705, 'description', '提出复审申请日期');

-- project 命名空间
INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES
-- 706: project.reviewObject
(706, 'namespace', 'project'), (706, 'field_name', 'reviewObject'),
(706, 'element_type', 'text'), (706, 'required', 'true'),
(706, 'description', '评审对象全称'),
-- 707: project.reviewObjectAlias
(707, 'namespace', 'project'), (707, 'field_name', 'reviewObjectAlias'),
(707, 'element_type', 'text'), (707, 'required', 'true'),
(707, 'description', '评审对象简称，用于正文中引用'),
-- 708: project.resultScore
(708, 'namespace', 'project'), (708, 'field_name', 'resultScore'),
(708, 'element_type', 'text'), (708, 'required', 'true'),
(708, 'description', '评审得分'),
-- 709: project.resultLevel
(709, 'namespace', 'project'), (709, 'field_name', 'resultLevel'),
(709, 'element_type', 'text'), (709, 'required', 'true'),
(709, 'description', '评审结论级别，如一级'),
-- 710: project.workStartAt
(710, 'namespace', 'project'), (710, 'field_name', 'workStartAt'),
(710, 'element_type', 'text'), (710, 'required', 'true'),
(710, 'description', '评审工作开始日期'),
-- 711: project.workEndAt
(711, 'namespace', 'project'), (711, 'field_name', 'workEndAt'),
(711, 'element_type', 'text'), (711, 'required', 'true'),
(711, 'description', '评审工作结束日期'),
-- 712: project.createdAt
(712, 'namespace', 'project'), (712, 'field_name', 'createdAt'),
(712, 'element_type', 'text'), (712, 'required', 'true'),
(712, 'description', '报告编制日期，如2024年11月'),
-- 713: project.reviewObjectSummary
(713, 'namespace', 'project'), (713, 'field_name', 'reviewObjectSummary'),
(713, 'element_type', 'paragraph'), (713, 'required', 'true'),
(713, 'description', '评审对象概况（多段落）'),
-- 714: project.reviewObjectDescription
(714, 'namespace', 'project'), (714, 'field_name', 'reviewObjectDescription'),
(714, 'element_type', 'paragraph'), (714, 'required', 'true'),
(714, 'description', '评审对象简介'),
-- 715: project.reviewPeriod
(715, 'namespace', 'project'), (715, 'field_name', 'reviewPeriod'),
(715, 'element_type', 'text'), (715, 'required', 'true'),
(715, 'description', '评审期，如2023年7月8日至2024年7月7日');

INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES
-- 716~735: 八大核心要素子项（段落类型）
(716, 'namespace', 'project'), (716, 'field_name', 'target'),
(716, 'element_type', 'paragraph'), (716, 'required', 'true'),
(716, 'description', '1.2.1 目标职责-目标'),
(717, 'namespace', 'project'), (717, 'field_name', 'duty'),
(717, 'element_type', 'paragraph'), (717, 'required', 'true'),
(717, 'description', '1.2.1 目标职责-职责'),
(718, 'namespace', 'project'), (718, 'field_name', 'fullParticipation'),
(718, 'element_type', 'paragraph'), (718, 'required', 'true'),
(718, 'description', '1.2.1 目标职责-全员参与'),
(719, 'namespace', 'project'), (719, 'field_name', 'safetyInvestment'),
(719, 'element_type', 'paragraph'), (719, 'required', 'true'),
(719, 'description', '1.2.1 目标职责-安全投入'),
(720, 'namespace', 'project'), (720, 'field_name', 'safetyCulture'),
(720, 'element_type', 'paragraph'), (720, 'required', 'true'),
(720, 'description', '1.2.1 目标职责-安全文化'),
(721, 'namespace', 'project'), (721, 'field_name', 'systematicManagement'),
(721, 'element_type', 'paragraph'), (721, 'required', 'true'),
(721, 'description', '1.2.2 制度化管理-体系化管理'),
(722, 'namespace', 'project'), (722, 'field_name', 'employeeTraining'),
(722, 'element_type', 'paragraph'), (722, 'required', 'true'),
(722, 'description', '1.2.3 教育培训-人员教育培训'),
(723, 'namespace', 'project'), (723, 'field_name', 'assetManagement'),
(723, 'element_type', 'paragraph'), (723, 'required', 'true'),
(723, 'description', '1.2.4 现场管理-设备设施管理'),
(724, 'namespace', 'project'), (724, 'field_name', 'jobSafety'),
(724, 'element_type', 'paragraph'), (724, 'required', 'true'),
(724, 'description', '1.2.4 现场管理-作业安全'),
(725, 'namespace', 'project'), (725, 'field_name', 'positionQualified'),
(725, 'element_type', 'paragraph'), (725, 'required', 'true'),
(725, 'description', '1.2.4 现场管理-岗位达标');

INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES
(726, 'namespace', 'project'), (726, 'field_name', 'partner'),
(726, 'element_type', 'paragraph'), (726, 'required', 'true'),
(726, 'description', '1.2.4 现场管理-相关方'),
(727, 'namespace', 'project'), (727, 'field_name', 'occupationalHealth'),
(727, 'element_type', 'paragraph'), (727, 'required', 'true'),
(727, 'description', '1.2.4 现场管理-职业健康'),
(728, 'namespace', 'project'), (728, 'field_name', 'riskAssessment'),
(728, 'element_type', 'paragraph'), (728, 'required', 'true'),
(728, 'description', '1.2.5 安全风险管控-风险辨识与评价'),
(729, 'namespace', 'project'), (729, 'field_name', 'majorHazardManagement'),
(729, 'element_type', 'paragraph'), (729, 'required', 'true'),
(729, 'description', '1.2.5 安全风险管控-重大危险源管理'),
(730, 'namespace', 'project'), (730, 'field_name', 'hazardInspection'),
(730, 'element_type', 'paragraph'), (730, 'required', 'true'),
(730, 'description', '1.2.5 安全风险管控-隐患排查'),
(731, 'namespace', 'project'), (731, 'field_name', 'changeManagement'),
(731, 'element_type', 'paragraph'), (731, 'required', 'true'),
(731, 'description', '1.2.5 安全风险管控-变更管理'),
(732, 'namespace', 'project'), (732, 'field_name', 'earlyWarning'),
(732, 'element_type', 'paragraph'), (732, 'required', 'true'),
(732, 'description', '1.2.5 安全风险管控-预测预警'),
(733, 'namespace', 'project'), (733, 'field_name', 'emergencyResponse'),
(733, 'element_type', 'paragraph'), (733, 'required', 'true'),
(733, 'description', '1.2.6 应急救援'),
(734, 'namespace', 'project'), (734, 'field_name', 'incidentManagement'),
(734, 'element_type', 'paragraph'), (734, 'required', 'true'),
(734, 'description', '1.2.7 事故管理'),
(735, 'namespace', 'project'), (735, 'field_name', 'continuousImprovement'),
(735, 'element_type', 'paragraph'), (735, 'required', 'true'),
(735, 'description', '1.2.8 持续改进');

INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES
-- 736~742: 其他 project 要素
(736, 'namespace', 'project'), (736, 'field_name', 'safetyStandardizationStatus'),
(736, 'element_type', 'paragraph'), (736, 'required', 'true'),
(736, 'description', '1.3 安全生产标准化建设和持续运行情况'),
(737, 'namespace', 'project'), (737, 'field_name', 'safetyHighlight'),
(737, 'element_type', 'paragraph'), (737, 'required', 'false'),
(737, 'description', '1.4 安全生产管理亮点'),
(738, 'namespace', 'project'), (738, 'field_name', 'reviewObjectSelfAssessmentProcess'),
(738, 'element_type', 'paragraph'), (738, 'required', 'true'),
(738, 'description', '2.1 自评过程'),
(739, 'namespace', 'project'), (739, 'field_name', 'moreWorkReference'),
(739, 'element_type', 'text'), (739, 'required', 'false'),
(739, 'description', '其他工作依据文件名称'),
(740, 'namespace', 'project'), (740, 'field_name', 'reviewRange'),
(740, 'element_type', 'text'), (740, 'required', 'true'),
(740, 'description', '3.3 复审范围'),
(741, 'namespace', 'project'), (741, 'field_name', 'workProcess'),
(741, 'element_type', 'paragraph'), (741, 'required', 'true'),
(741, 'description', '3.5.3 现场复审工作过程'),
(742, 'namespace', 'project'), (742, 'field_name', 'closingMeetingAt'),
(742, 'element_type', 'text'), (742, 'required', 'true'),
(742, 'description', '末次会议日期时间');

-- 表格/列表类要素
INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES
(743, 'namespace', 'table'), (743, 'field_name', 'SPSRRReviewProject'),
(743, 'element_type', 'table'), (743, 'required', 'true'),
(743, 'description', '3.5.1 现场复审项目选择（动态表格）'),
(744, 'namespace', 'table'), (744, 'field_name', 'SPSRRReviewer'),
(744, 'element_type', 'table'), (744, 'required', 'true'),
(744, 'description', '3.5.2 现场复审人员（动态表格）'),
(745, 'namespace', 'table'), (745, 'field_name', 'review_status'),
(745, 'element_type', 'paragraph'), (745, 'required', 'true'),
(745, 'description', '4 现场复审情况（动态段落）'),
(746, 'namespace', 'table'), (746, 'field_name', 'target_responsibility'),
(746, 'element_type', 'paragraph'), (746, 'required', 'true'),
(746, 'description', '4.1.1 目标职责复审情况（动态段落）'),
(747, 'namespace', 'table'), (747, 'field_name', 'institutionalized_management'),
(747, 'element_type', 'paragraph'), (747, 'required', 'true'),
(747, 'description', '4.1.2 制度化管理复审情况（动态段落）');

-- ============================================================
-- 5. 要素排序
-- ============================================================
INSERT INTO node_properties (node_id, prop_key, prop_value)
SELECT id, 'sort_order', CAST((id - 700) AS TEXT) FROM nodes WHERE id BETWEEN 701 AND 747;

-- ============================================================
-- 6. 建立 HAS_ELEMENT 边（项目 -> 要素）
-- ============================================================
INSERT INTO edges (from_node_id, to_node_id, edge_type)
SELECT 10, id, 'HAS_ELEMENT' FROM nodes WHERE id BETWEEN 701 AND 747;

-- ============================================================
-- 7. 插入值节点 (VALUE) — 与原文对照
--    ID 从 801 开始
-- ============================================================
INSERT INTO nodes (id, node_type, node_key, name) VALUES
(801, 'VALUE', 'PRJ-2024-001:basicInfo.projectCode',                 '项目编号值'),
(802, 'VALUE', 'PRJ-2024-001:basicInfo.requestLevel',                '申请级别值'),
(803, 'VALUE', 'PRJ-2024-001:basicInfo.reviewObjectCertificateGetAt', '获证日期值'),
(804, 'VALUE', 'PRJ-2024-001:basicInfo.reviewObjectCertificate2GetAt','通过评审日期值'),
(805, 'VALUE', 'PRJ-2024-001:basicInfo.applyAt',                     '申请日期值'),
(806, 'VALUE', 'PRJ-2024-001:project.reviewObject',                  '评审对象值'),
(807, 'VALUE', 'PRJ-2024-001:project.reviewObjectAlias',             '评审对象简称值'),
(808, 'VALUE', 'PRJ-2024-001:project.resultScore',                   '评审得分值'),
(809, 'VALUE', 'PRJ-2024-001:project.resultLevel',                   '评审结论级别值'),
(810, 'VALUE', 'PRJ-2024-001:project.workStartAt',                   '评审开始日期值'),
(811, 'VALUE', 'PRJ-2024-001:project.workEndAt',                     '评审结束日期值'),
(812, 'VALUE', 'PRJ-2024-001:project.createdAt',                     '报告日期值'),
(813, 'VALUE', 'PRJ-2024-001:project.reviewObjectSummary',           '评审对象概况值'),
(814, 'VALUE', 'PRJ-2024-001:project.reviewObjectDescription',       '评审对象简介值'),
(815, 'VALUE', 'PRJ-2024-001:project.reviewPeriod',                  '评审期值'),
(816, 'VALUE', 'PRJ-2024-001:project.target',                        '目标值'),
(817, 'VALUE', 'PRJ-2024-001:project.duty',                          '职责值'),
(818, 'VALUE', 'PRJ-2024-001:project.fullParticipation',             '全员参与值'),
(819, 'VALUE', 'PRJ-2024-001:project.safetyInvestment',              '安全投入值'),
(820, 'VALUE', 'PRJ-2024-001:project.safetyCulture',                 '安全文化值'),
(821, 'VALUE', 'PRJ-2024-001:project.systematicManagement',          '体系化管理值'),
(822, 'VALUE', 'PRJ-2024-001:project.employeeTraining',              '人员教育培训值'),
(823, 'VALUE', 'PRJ-2024-001:project.assetManagement',               '设备设施管理值'),
(824, 'VALUE', 'PRJ-2024-001:project.jobSafety',                     '作业安全值'),
(825, 'VALUE', 'PRJ-2024-001:project.positionQualified',             '岗位达标值'),
(826, 'VALUE', 'PRJ-2024-001:project.partner',                       '相关方值'),
(827, 'VALUE', 'PRJ-2024-001:project.occupationalHealth',            '职业健康值'),
(828, 'VALUE', 'PRJ-2024-001:project.riskAssessment',                '风险辨识与评价值'),
(829, 'VALUE', 'PRJ-2024-001:project.majorHazardManagement',         '重大危险源管理值'),
(830, 'VALUE', 'PRJ-2024-001:project.hazardInspection',              '隐患排查值'),
(831, 'VALUE', 'PRJ-2024-001:project.changeManagement',              '变更管理值'),
(832, 'VALUE', 'PRJ-2024-001:project.earlyWarning',                  '预测预警值'),
(833, 'VALUE', 'PRJ-2024-001:project.emergencyResponse',             '应急救援值'),
(834, 'VALUE', 'PRJ-2024-001:project.incidentManagement',            '事故管理值'),
(835, 'VALUE', 'PRJ-2024-001:project.continuousImprovement',         '持续改进值'),
(836, 'VALUE', 'PRJ-2024-001:project.safetyStandardizationStatus',   '标准化建设运行情况值'),
(837, 'VALUE', 'PRJ-2024-001:project.safetyHighlight',               '安全生产管理亮点值'),
(838, 'VALUE', 'PRJ-2024-001:project.reviewObjectSelfAssessmentProcess','自评过程值'),
(839, 'VALUE', 'PRJ-2024-001:project.moreWorkReference',             '其他工作依据值'),
(840, 'VALUE', 'PRJ-2024-001:project.reviewRange',                   '复审范围值'),
(841, 'VALUE', 'PRJ-2024-001:project.workProcess',                   '复审工作过程值'),
(842, 'VALUE', 'PRJ-2024-001:project.closingMeetingAt',              '末次会议时间值'),
(843, 'VALUE', 'PRJ-2024-001:+SPSRRReviewProject',                   '现场复审项目值'),
(844, 'VALUE', 'PRJ-2024-001:+SPSRRReviewer',                        '现场复审人员值'),
(845, 'VALUE', 'PRJ-2024-001:+review_status',                        '现场复审情况值'),
(846, 'VALUE', 'PRJ-2024-001:+target_responsibility',                '目标职责值'),
(847, 'VALUE', 'PRJ-2024-001:+institutionalized_management',         '制度化管理值');

-- ============================================================
-- 8. 建立 HAS_VALUE 边（项目 -> 值）
-- ============================================================
INSERT INTO edges (from_node_id, to_node_id, edge_type)
SELECT 10, id, 'HAS_VALUE' FROM nodes WHERE id BETWEEN 801 AND 847;

-- ============================================================
-- 9. 值属性 — 从原文中提取的实际值
-- ============================================================

-- 短文本类要素值
INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES
-- 801: basicInfo.projectCode
(801, 'value_text', 'BZ-0092-2024'),
(801, 'is_filled', 'true'), (801, 'fill_source', 'manual'),
-- 802: basicInfo.requestLevel
(802, 'value_text', '一级'),
(802, 'is_filled', 'true'), (802, 'fill_source', 'manual'),
-- 803: basicInfo.reviewObjectCertificateGetAt
(803, 'value_text', '2020年12月'),
(803, 'is_filled', 'true'), (803, 'fill_source', 'manual'),
-- 804: basicInfo.reviewObjectCertificate2GetAt
(804, 'value_text', '2020年'),
(804, 'is_filled', 'true'), (804, 'fill_source', 'manual'),
-- 805: basicInfo.applyAt
(805, 'value_text', '2024年7月8日'),
(805, 'is_filled', 'true'), (805, 'fill_source', 'manual'),
-- 806: project.reviewObject
(806, 'value_text', '中国电建集团成都勘测设计研究院有限公司'),
(806, 'is_filled', 'true'), (806, 'fill_source', 'manual'),
-- 807: project.reviewObjectAlias
(807, 'value_text', '成都院'),
(807, 'is_filled', 'true'), (807, 'fill_source', 'manual'),
-- 808: project.resultScore
(808, 'value_text', '93.33'),
(808, 'is_filled', 'true'), (808, 'fill_source', 'manual'),
-- 809: project.resultLevel
(809, 'value_text', '一级'),
(809, 'is_filled', 'true'), (809, 'fill_source', 'manual'),
-- 810: project.workStartAt
(810, 'value_text', '2024年7月13日'),
(810, 'is_filled', 'true'), (810, 'fill_source', 'manual'),
-- 811: project.workEndAt
(811, 'value_text', '2024年10月19日'),
(811, 'is_filled', 'true'), (811, 'fill_source', 'manual'),
-- 812: project.createdAt
(812, 'value_text', '2024年11月'),
(812, 'is_filled', 'true'), (812, 'fill_source', 'manual'),
-- 815: project.reviewPeriod
(815, 'value_text', '2023年7月8日至2024年7月7日'),
(815, 'is_filled', 'true'), (815, 'fill_source', 'manual'),
-- 839: project.moreWorkReference
(839, 'value_text', '《关于深入开展电力安全生产标准化建设暨安全环保提升专项行动的通知》（蓉设安质〔2024〕20号）'),
(839, 'is_filled', 'true'), (839, 'fill_source', 'manual'),
-- 840: project.reviewRange
(840, 'value_text', '成都院总部各职能部门、勘测设计分公司、建设分公司、国际工程分公司及其所属项目部'),
(840, 'is_filled', 'true'), (840, 'fill_source', 'manual'),
-- 842: project.closingMeetingAt
(842, 'value_text', '2024年10月17日上10：30～12：00'),
(842, 'is_filled', 'true'), (842, 'fill_source', 'manual');

-- 长段落类要素值（暂标记为待填充）
INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES
(813, 'is_filled', 'false'), (813, 'fill_source', 'pending'),
(814, 'is_filled', 'false'), (814, 'fill_source', 'pending'),
(816, 'is_filled', 'false'), (816, 'fill_source', 'pending'),
(817, 'is_filled', 'false'), (817, 'fill_source', 'pending'),
(818, 'is_filled', 'false'), (818, 'fill_source', 'pending'),
(819, 'is_filled', 'false'), (819, 'fill_source', 'pending'),
(820, 'is_filled', 'false'), (820, 'fill_source', 'pending'),
(821, 'is_filled', 'false'), (821, 'fill_source', 'pending'),
(822, 'is_filled', 'false'), (822, 'fill_source', 'pending'),
(823, 'is_filled', 'false'), (823, 'fill_source', 'pending'),
(824, 'is_filled', 'false'), (824, 'fill_source', 'pending'),
(825, 'is_filled', 'false'), (825, 'fill_source', 'pending'),
(826, 'is_filled', 'false'), (826, 'fill_source', 'pending'),
(827, 'is_filled', 'false'), (827, 'fill_source', 'pending'),
(828, 'is_filled', 'false'), (828, 'fill_source', 'pending'),
(829, 'is_filled', 'false'), (829, 'fill_source', 'pending'),
(830, 'is_filled', 'false'), (830, 'fill_source', 'pending'),
(831, 'is_filled', 'false'), (831, 'fill_source', 'pending'),
(832, 'is_filled', 'false'), (832, 'fill_source', 'pending'),
(833, 'is_filled', 'false'), (833, 'fill_source', 'pending'),
(834, 'is_filled', 'false'), (834, 'fill_source', 'pending'),
(835, 'is_filled', 'false'), (835, 'fill_source', 'pending'),
(836, 'is_filled', 'false'), (836, 'fill_source', 'pending'),
(837, 'is_filled', 'false'), (837, 'fill_source', 'pending'),
(838, 'is_filled', 'false'), (838, 'fill_source', 'pending'),
(841, 'is_filled', 'false'), (841, 'fill_source', 'pending'),
(843, 'is_filled', 'false'), (843, 'fill_source', 'pending'),
(844, 'is_filled', 'false'), (844, 'fill_source', 'pending'),
(845, 'is_filled', 'false'), (845, 'fill_source', 'pending'),
(846, 'is_filled', 'false'), (846, 'fill_source', 'pending'),
(847, 'is_filled', 'false'), (847, 'fill_source', 'pending');

COMMIT;
