mock_47_elements.sql 98 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648
  1. -- 灵越智报 Mock 数据 (图数据库格式)
  2. -- 生成时间: 2026-03-02
  3. -- 项目节点
  4. INSERT INTO nodes (id, node_type, node_key, name, status, created_by) VALUES
  5. (10, 'PROJECT', 'PRJ-2024-001', '成都院2024年复审报告', 'draft', 1)
  6. ON CONFLICT (id) DO NOTHING;
  7. -- 要素定义节点 (47个)
  8. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (701, 'ELEMENT', 'basicInfo.projectCode', '项目编号', 1) ON CONFLICT (id) DO NOTHING;
  9. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (702, 'ELEMENT', 'basicInfo.requestLevel', '申请级别', 1) ON CONFLICT (id) DO NOTHING;
  10. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (703, 'ELEMENT', 'basicInfo.applyAt', '申请日期', 1) ON CONFLICT (id) DO NOTHING;
  11. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (704, 'ELEMENT', 'basicInfo.reviewObjectCertificateGetAt', '证书获取日期', 1) ON CONFLICT (id) DO NOTHING;
  12. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (705, 'ELEMENT', 'basicInfo.reviewObjectCertificate2GetAt', '二次证书获取日期', 1) ON CONFLICT (id) DO NOTHING;
  13. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (706, 'ELEMENT', 'basicInfo.reviewCategory', '申请类别', 1) ON CONFLICT (id) DO NOTHING;
  14. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (707, 'ELEMENT', 'basicInfo.reviewUnit', '评审单位', 1) ON CONFLICT (id) DO NOTHING;
  15. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (708, 'ELEMENT', 'project.reviewObject', '评审对象', 1) ON CONFLICT (id) DO NOTHING;
  16. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (709, 'ELEMENT', 'project.reviewObjectAlias', '评审对象简称', 1) ON CONFLICT (id) DO NOTHING;
  17. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (710, 'ELEMENT', 'project.resultScore', '评审得分', 1) ON CONFLICT (id) DO NOTHING;
  18. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (711, 'ELEMENT', 'project.resultLevel', '评审级别', 1) ON CONFLICT (id) DO NOTHING;
  19. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (712, 'ELEMENT', 'project.workStartAt', '评审开始日期', 1) ON CONFLICT (id) DO NOTHING;
  20. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (713, 'ELEMENT', 'project.workEndAt', '评审结束日期', 1) ON CONFLICT (id) DO NOTHING;
  21. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (714, 'ELEMENT', 'project.createdAt', '报告日期', 1) ON CONFLICT (id) DO NOTHING;
  22. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (715, 'ELEMENT', 'project.reviewPeriod', '评审周期', 1) ON CONFLICT (id) DO NOTHING;
  23. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (716, 'ELEMENT', 'project.closingMeetingAt', '末次评审会议时间', 1) ON CONFLICT (id) DO NOTHING;
  24. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (717, 'ELEMENT', 'project.reviewObjectSummary', '评审对象概况', 1) ON CONFLICT (id) DO NOTHING;
  25. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (718, 'ELEMENT', 'project.reviewObjectDescription', '评审对象描述', 1) ON CONFLICT (id) DO NOTHING;
  26. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (719, 'ELEMENT', 'project.reviewObjectSelfAssessmentProcess', '评审对象自评过程', 1) ON CONFLICT (id) DO NOTHING;
  27. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (720, 'ELEMENT', 'project.reviewRange', '复审范围', 1) ON CONFLICT (id) DO NOTHING;
  28. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (721, 'ELEMENT', 'project.reviewRangeShort', '复审范围简称', 1) ON CONFLICT (id) DO NOTHING;
  29. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (722, 'ELEMENT', 'project.target', '目标', 1) ON CONFLICT (id) DO NOTHING;
  30. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (723, 'ELEMENT', 'project.duty', '组织机构和职责', 1) ON CONFLICT (id) DO NOTHING;
  31. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (724, 'ELEMENT', 'project.fullParticipation', '全员参与', 1) ON CONFLICT (id) DO NOTHING;
  32. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (725, 'ELEMENT', 'project.safetyInvestment', '安全生产投入', 1) ON CONFLICT (id) DO NOTHING;
  33. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (726, 'ELEMENT', 'project.safetyCulture', '安全文化建设', 1) ON CONFLICT (id) DO NOTHING;
  34. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (727, 'ELEMENT', 'project.systematicManagement', '制度化管理', 1) ON CONFLICT (id) DO NOTHING;
  35. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (728, 'ELEMENT', 'project.trainingManagement', '教育培训管理', 1) ON CONFLICT (id) DO NOTHING;
  36. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (729, 'ELEMENT', 'project.employeeTraining', '人员教育培训', 1) ON CONFLICT (id) DO NOTHING;
  37. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (730, 'ELEMENT', 'project.assetManagement', '设备设施管理', 1) ON CONFLICT (id) DO NOTHING;
  38. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (731, 'ELEMENT', 'project.jobSafety', '作业安全', 1) ON CONFLICT (id) DO NOTHING;
  39. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (732, 'ELEMENT', 'project.positionQualified', '岗位达标', 1) ON CONFLICT (id) DO NOTHING;
  40. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (733, 'ELEMENT', 'project.partner', '相关方', 1) ON CONFLICT (id) DO NOTHING;
  41. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (734, 'ELEMENT', 'project.occupationalHealth', '职业健康', 1) ON CONFLICT (id) DO NOTHING;
  42. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (735, 'ELEMENT', 'project.riskAssessment', '风险辨识与评价', 1) ON CONFLICT (id) DO NOTHING;
  43. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (736, 'ELEMENT', 'project.majorHazardManagement', '重大危险源管理', 1) ON CONFLICT (id) DO NOTHING;
  44. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (737, 'ELEMENT', 'project.hazardInspection', '隐患排查', 1) ON CONFLICT (id) DO NOTHING;
  45. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (738, 'ELEMENT', 'project.changeManagement', '变更管理', 1) ON CONFLICT (id) DO NOTHING;
  46. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (739, 'ELEMENT', 'project.earlyWarning', '预测预警', 1) ON CONFLICT (id) DO NOTHING;
  47. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (740, 'ELEMENT', 'project.emergencyResponse', '应急救援', 1) ON CONFLICT (id) DO NOTHING;
  48. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (741, 'ELEMENT', 'project.incidentManagement', '事故管理', 1) ON CONFLICT (id) DO NOTHING;
  49. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (742, 'ELEMENT', 'project.continuousImprovement', '持续改进', 1) ON CONFLICT (id) DO NOTHING;
  50. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (743, 'ELEMENT', 'project.safetyStandardizationStatus', '安全生产标准化建设和持续运行情况', 1) ON CONFLICT (id) DO NOTHING;
  51. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (744, 'ELEMENT', 'project.safetyHighlight', '安全生产管理亮点', 1) ON CONFLICT (id) DO NOTHING;
  52. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (745, 'ELEMENT', 'project.workProcess', '现场复审工作过程', 1) ON CONFLICT (id) DO NOTHING;
  53. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (746, 'ELEMENT', 'project.moreWorkReference', '工作依据', 1) ON CONFLICT (id) DO NOTHING;
  54. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (747, 'ELEMENT', '+expert_list', '专家组成员表', 1) ON CONFLICT (id) DO NOTHING;
  55. -- 要素定义属性
  56. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (701, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
  57. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (701, 'namespace', 'basicInfo') ON CONFLICT (node_id, prop_key) DO NOTHING;
  58. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (701, 'field_name', 'projectCode') ON CONFLICT (node_id, prop_key) DO NOTHING;
  59. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (701, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
  60. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (702, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
  61. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (702, 'namespace', 'basicInfo') ON CONFLICT (node_id, prop_key) DO NOTHING;
  62. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (702, 'field_name', 'requestLevel') ON CONFLICT (node_id, prop_key) DO NOTHING;
  63. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (702, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
  64. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (703, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
  65. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (703, 'namespace', 'basicInfo') ON CONFLICT (node_id, prop_key) DO NOTHING;
  66. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (703, 'field_name', 'applyAt') ON CONFLICT (node_id, prop_key) DO NOTHING;
  67. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (703, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  68. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (704, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
  69. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (704, 'namespace', 'basicInfo') ON CONFLICT (node_id, prop_key) DO NOTHING;
  70. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (704, 'field_name', 'reviewObjectCertificateGetAt') ON CONFLICT (node_id, prop_key) DO NOTHING;
  71. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (704, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  72. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (705, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
  73. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (705, 'namespace', 'basicInfo') ON CONFLICT (node_id, prop_key) DO NOTHING;
  74. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (705, 'field_name', 'reviewObjectCertificate2GetAt') ON CONFLICT (node_id, prop_key) DO NOTHING;
  75. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (705, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  76. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (706, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
  77. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (706, 'namespace', 'basicInfo') ON CONFLICT (node_id, prop_key) DO NOTHING;
  78. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (706, 'field_name', 'reviewCategory') ON CONFLICT (node_id, prop_key) DO NOTHING;
  79. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (706, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
  80. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (707, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
  81. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (707, 'namespace', 'basicInfo') ON CONFLICT (node_id, prop_key) DO NOTHING;
  82. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (707, 'field_name', 'reviewUnit') ON CONFLICT (node_id, prop_key) DO NOTHING;
  83. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (707, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
  84. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (708, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
  85. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (708, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  86. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (708, 'field_name', 'reviewObject') ON CONFLICT (node_id, prop_key) DO NOTHING;
  87. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (708, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
  88. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (709, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
  89. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (709, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  90. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (709, 'field_name', 'reviewObjectAlias') ON CONFLICT (node_id, prop_key) DO NOTHING;
  91. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (709, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
  92. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (710, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
  93. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (710, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  94. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (710, 'field_name', 'resultScore') ON CONFLICT (node_id, prop_key) DO NOTHING;
  95. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (710, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
  96. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (711, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
  97. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (711, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  98. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (711, 'field_name', 'resultLevel') ON CONFLICT (node_id, prop_key) DO NOTHING;
  99. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (711, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
  100. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (712, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
  101. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (712, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  102. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (712, 'field_name', 'workStartAt') ON CONFLICT (node_id, prop_key) DO NOTHING;
  103. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (712, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
  104. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (713, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
  105. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (713, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  106. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (713, 'field_name', 'workEndAt') ON CONFLICT (node_id, prop_key) DO NOTHING;
  107. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (713, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
  108. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (714, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
  109. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (714, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  110. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (714, 'field_name', 'createdAt') ON CONFLICT (node_id, prop_key) DO NOTHING;
  111. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (714, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
  112. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (715, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
  113. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (715, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  114. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (715, 'field_name', 'reviewPeriod') ON CONFLICT (node_id, prop_key) DO NOTHING;
  115. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (715, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  116. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (716, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
  117. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (716, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  118. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (716, 'field_name', 'closingMeetingAt') ON CONFLICT (node_id, prop_key) DO NOTHING;
  119. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (716, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  120. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (717, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  121. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (717, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  122. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (717, 'field_name', 'reviewObjectSummary') ON CONFLICT (node_id, prop_key) DO NOTHING;
  123. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (717, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
  124. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (718, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  125. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (718, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  126. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (718, 'field_name', 'reviewObjectDescription') ON CONFLICT (node_id, prop_key) DO NOTHING;
  127. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (718, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
  128. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (719, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  129. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (719, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  130. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (719, 'field_name', 'reviewObjectSelfAssessmentProcess') ON CONFLICT (node_id, prop_key) DO NOTHING;
  131. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (719, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  132. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (720, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  133. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (720, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  134. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (720, 'field_name', 'reviewRange') ON CONFLICT (node_id, prop_key) DO NOTHING;
  135. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (720, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  136. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (721, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  137. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (721, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  138. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (721, 'field_name', 'reviewRangeShort') ON CONFLICT (node_id, prop_key) DO NOTHING;
  139. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (721, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  140. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (722, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  141. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (722, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  142. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (722, 'field_name', 'target') ON CONFLICT (node_id, prop_key) DO NOTHING;
  143. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (722, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
  144. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (723, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  145. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (723, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  146. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (723, 'field_name', 'duty') ON CONFLICT (node_id, prop_key) DO NOTHING;
  147. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (723, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
  148. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (724, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  149. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (724, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  150. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (724, 'field_name', 'fullParticipation') ON CONFLICT (node_id, prop_key) DO NOTHING;
  151. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (724, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  152. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (725, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  153. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (725, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  154. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (725, 'field_name', 'safetyInvestment') ON CONFLICT (node_id, prop_key) DO NOTHING;
  155. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (725, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  156. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (726, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  157. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (726, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  158. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (726, 'field_name', 'safetyCulture') ON CONFLICT (node_id, prop_key) DO NOTHING;
  159. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (726, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  160. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (727, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  161. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (727, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  162. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (727, 'field_name', 'systematicManagement') ON CONFLICT (node_id, prop_key) DO NOTHING;
  163. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (727, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  164. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (728, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  165. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (728, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  166. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (728, 'field_name', 'trainingManagement') ON CONFLICT (node_id, prop_key) DO NOTHING;
  167. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (728, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  168. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (729, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  169. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (729, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  170. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (729, 'field_name', 'employeeTraining') ON CONFLICT (node_id, prop_key) DO NOTHING;
  171. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (729, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  172. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (730, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  173. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (730, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  174. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (730, 'field_name', 'assetManagement') ON CONFLICT (node_id, prop_key) DO NOTHING;
  175. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (730, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  176. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (731, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  177. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (731, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  178. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (731, 'field_name', 'jobSafety') ON CONFLICT (node_id, prop_key) DO NOTHING;
  179. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (731, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  180. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (732, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  181. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (732, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  182. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (732, 'field_name', 'positionQualified') ON CONFLICT (node_id, prop_key) DO NOTHING;
  183. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (732, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  184. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (733, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  185. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (733, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  186. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (733, 'field_name', 'partner') ON CONFLICT (node_id, prop_key) DO NOTHING;
  187. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (733, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  188. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (734, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  189. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (734, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  190. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (734, 'field_name', 'occupationalHealth') ON CONFLICT (node_id, prop_key) DO NOTHING;
  191. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (734, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  192. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (735, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  193. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (735, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  194. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (735, 'field_name', 'riskAssessment') ON CONFLICT (node_id, prop_key) DO NOTHING;
  195. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (735, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  196. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (736, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  197. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (736, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  198. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (736, 'field_name', 'majorHazardManagement') ON CONFLICT (node_id, prop_key) DO NOTHING;
  199. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (736, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  200. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (737, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  201. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (737, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  202. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (737, 'field_name', 'hazardInspection') ON CONFLICT (node_id, prop_key) DO NOTHING;
  203. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (737, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  204. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (738, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  205. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (738, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  206. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (738, 'field_name', 'changeManagement') ON CONFLICT (node_id, prop_key) DO NOTHING;
  207. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (738, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  208. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (739, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  209. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (739, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  210. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (739, 'field_name', 'earlyWarning') ON CONFLICT (node_id, prop_key) DO NOTHING;
  211. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (739, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  212. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (740, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  213. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (740, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  214. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (740, 'field_name', 'emergencyResponse') ON CONFLICT (node_id, prop_key) DO NOTHING;
  215. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (740, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  216. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (741, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  217. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (741, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  218. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (741, 'field_name', 'incidentManagement') ON CONFLICT (node_id, prop_key) DO NOTHING;
  219. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (741, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  220. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (742, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  221. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (742, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  222. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (742, 'field_name', 'continuousImprovement') ON CONFLICT (node_id, prop_key) DO NOTHING;
  223. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (742, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  224. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (743, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  225. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (743, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  226. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (743, 'field_name', 'safetyStandardizationStatus') ON CONFLICT (node_id, prop_key) DO NOTHING;
  227. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (743, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  228. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (744, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  229. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (744, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  230. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (744, 'field_name', 'safetyHighlight') ON CONFLICT (node_id, prop_key) DO NOTHING;
  231. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (744, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  232. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (745, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  233. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (745, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  234. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (745, 'field_name', 'workProcess') ON CONFLICT (node_id, prop_key) DO NOTHING;
  235. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (745, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  236. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (746, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
  237. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (746, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
  238. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (746, 'field_name', 'moreWorkReference') ON CONFLICT (node_id, prop_key) DO NOTHING;
  239. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (746, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
  240. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (747, 'element_type', 'table') ON CONFLICT (node_id, prop_key) DO NOTHING;
  241. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (747, 'field_name', 'expert_list') ON CONFLICT (node_id, prop_key) DO NOTHING;
  242. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (747, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
  243. -- 要素值节点 (47个)
  244. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (801, 'VALUE', 'PRJ-2024-001:basicInfo.projectCode', '项目编号值', 1) ON CONFLICT (id) DO NOTHING;
  245. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (802, 'VALUE', 'PRJ-2024-001:basicInfo.requestLevel', '申请级别值', 1) ON CONFLICT (id) DO NOTHING;
  246. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (803, 'VALUE', 'PRJ-2024-001:basicInfo.applyAt', '申请日期值', 1) ON CONFLICT (id) DO NOTHING;
  247. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (804, 'VALUE', 'PRJ-2024-001:basicInfo.reviewObjectCertificateGetAt', '证书获取日期值', 1) ON CONFLICT (id) DO NOTHING;
  248. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (805, 'VALUE', 'PRJ-2024-001:basicInfo.reviewObjectCertificate2GetAt', '二次证书获取日期值', 1) ON CONFLICT (id) DO NOTHING;
  249. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (806, 'VALUE', 'PRJ-2024-001:basicInfo.reviewCategory', '申请类别值', 1) ON CONFLICT (id) DO NOTHING;
  250. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (807, 'VALUE', 'PRJ-2024-001:basicInfo.reviewUnit', '评审单位值', 1) ON CONFLICT (id) DO NOTHING;
  251. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (808, 'VALUE', 'PRJ-2024-001:project.reviewObject', '评审对象值', 1) ON CONFLICT (id) DO NOTHING;
  252. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (809, 'VALUE', 'PRJ-2024-001:project.reviewObjectAlias', '评审对象简称值', 1) ON CONFLICT (id) DO NOTHING;
  253. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (810, 'VALUE', 'PRJ-2024-001:project.resultScore', '评审得分值', 1) ON CONFLICT (id) DO NOTHING;
  254. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (811, 'VALUE', 'PRJ-2024-001:project.resultLevel', '评审级别值', 1) ON CONFLICT (id) DO NOTHING;
  255. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (812, 'VALUE', 'PRJ-2024-001:project.workStartAt', '评审开始日期值', 1) ON CONFLICT (id) DO NOTHING;
  256. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (813, 'VALUE', 'PRJ-2024-001:project.workEndAt', '评审结束日期值', 1) ON CONFLICT (id) DO NOTHING;
  257. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (814, 'VALUE', 'PRJ-2024-001:project.createdAt', '报告日期值', 1) ON CONFLICT (id) DO NOTHING;
  258. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (815, 'VALUE', 'PRJ-2024-001:project.reviewPeriod', '评审周期值', 1) ON CONFLICT (id) DO NOTHING;
  259. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (816, 'VALUE', 'PRJ-2024-001:project.closingMeetingAt', '末次评审会议时间值', 1) ON CONFLICT (id) DO NOTHING;
  260. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (817, 'VALUE', 'PRJ-2024-001:project.reviewObjectSummary', '评审对象概况值', 1) ON CONFLICT (id) DO NOTHING;
  261. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (818, 'VALUE', 'PRJ-2024-001:project.reviewObjectDescription', '评审对象描述值', 1) ON CONFLICT (id) DO NOTHING;
  262. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (819, 'VALUE', 'PRJ-2024-001:project.reviewObjectSelfAssessmentProcess', '评审对象自评过程值', 1) ON CONFLICT (id) DO NOTHING;
  263. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (820, 'VALUE', 'PRJ-2024-001:project.reviewRange', '复审范围值', 1) ON CONFLICT (id) DO NOTHING;
  264. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (821, 'VALUE', 'PRJ-2024-001:project.reviewRangeShort', '复审范围简称值', 1) ON CONFLICT (id) DO NOTHING;
  265. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (822, 'VALUE', 'PRJ-2024-001:project.target', '目标值', 1) ON CONFLICT (id) DO NOTHING;
  266. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (823, 'VALUE', 'PRJ-2024-001:project.duty', '组织机构和职责值', 1) ON CONFLICT (id) DO NOTHING;
  267. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (824, 'VALUE', 'PRJ-2024-001:project.fullParticipation', '全员参与值', 1) ON CONFLICT (id) DO NOTHING;
  268. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (825, 'VALUE', 'PRJ-2024-001:project.safetyInvestment', '安全生产投入值', 1) ON CONFLICT (id) DO NOTHING;
  269. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (826, 'VALUE', 'PRJ-2024-001:project.safetyCulture', '安全文化建设值', 1) ON CONFLICT (id) DO NOTHING;
  270. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (827, 'VALUE', 'PRJ-2024-001:project.systematicManagement', '制度化管理值', 1) ON CONFLICT (id) DO NOTHING;
  271. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (828, 'VALUE', 'PRJ-2024-001:project.trainingManagement', '教育培训管理值', 1) ON CONFLICT (id) DO NOTHING;
  272. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (829, 'VALUE', 'PRJ-2024-001:project.employeeTraining', '人员教育培训值', 1) ON CONFLICT (id) DO NOTHING;
  273. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (830, 'VALUE', 'PRJ-2024-001:project.assetManagement', '设备设施管理值', 1) ON CONFLICT (id) DO NOTHING;
  274. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (831, 'VALUE', 'PRJ-2024-001:project.jobSafety', '作业安全值', 1) ON CONFLICT (id) DO NOTHING;
  275. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (832, 'VALUE', 'PRJ-2024-001:project.positionQualified', '岗位达标值', 1) ON CONFLICT (id) DO NOTHING;
  276. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (833, 'VALUE', 'PRJ-2024-001:project.partner', '相关方值', 1) ON CONFLICT (id) DO NOTHING;
  277. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (834, 'VALUE', 'PRJ-2024-001:project.occupationalHealth', '职业健康值', 1) ON CONFLICT (id) DO NOTHING;
  278. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (835, 'VALUE', 'PRJ-2024-001:project.riskAssessment', '风险辨识与评价值', 1) ON CONFLICT (id) DO NOTHING;
  279. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (836, 'VALUE', 'PRJ-2024-001:project.majorHazardManagement', '重大危险源管理值', 1) ON CONFLICT (id) DO NOTHING;
  280. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (837, 'VALUE', 'PRJ-2024-001:project.hazardInspection', '隐患排查值', 1) ON CONFLICT (id) DO NOTHING;
  281. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (838, 'VALUE', 'PRJ-2024-001:project.changeManagement', '变更管理值', 1) ON CONFLICT (id) DO NOTHING;
  282. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (839, 'VALUE', 'PRJ-2024-001:project.earlyWarning', '预测预警值', 1) ON CONFLICT (id) DO NOTHING;
  283. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (840, 'VALUE', 'PRJ-2024-001:project.emergencyResponse', '应急救援值', 1) ON CONFLICT (id) DO NOTHING;
  284. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (841, 'VALUE', 'PRJ-2024-001:project.incidentManagement', '事故管理值', 1) ON CONFLICT (id) DO NOTHING;
  285. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (842, 'VALUE', 'PRJ-2024-001:project.continuousImprovement', '持续改进值', 1) ON CONFLICT (id) DO NOTHING;
  286. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (843, 'VALUE', 'PRJ-2024-001:project.safetyStandardizationStatus', '安全生产标准化建设和持续运行情况值', 1) ON CONFLICT (id) DO NOTHING;
  287. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (844, 'VALUE', 'PRJ-2024-001:project.safetyHighlight', '安全生产管理亮点值', 1) ON CONFLICT (id) DO NOTHING;
  288. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (845, 'VALUE', 'PRJ-2024-001:project.workProcess', '现场复审工作过程值', 1) ON CONFLICT (id) DO NOTHING;
  289. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (846, 'VALUE', 'PRJ-2024-001:project.moreWorkReference', '工作依据值', 1) ON CONFLICT (id) DO NOTHING;
  290. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (847, 'VALUE', 'PRJ-2024-001:+expert_list', '专家组成员表值', 1) ON CONFLICT (id) DO NOTHING;
  291. -- 要素值属性
  292. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (801, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  293. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (801, 'value_text', 'BZ-0092-2024') ON CONFLICT (node_id, prop_key) DO NOTHING;
  294. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (801, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  295. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (802, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  296. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (802, 'value_text', '一级') ON CONFLICT (node_id, prop_key) DO NOTHING;
  297. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (802, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  298. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (803, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  299. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (803, 'value_text', '2024年7月8日') ON CONFLICT (node_id, prop_key) DO NOTHING;
  300. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (803, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  301. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (804, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  302. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (804, 'value_text', '2019年12月9日') ON CONFLICT (node_id, prop_key) DO NOTHING;
  303. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (804, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  304. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (805, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  305. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (805, 'value_text', '2015年4月7日') ON CONFLICT (node_id, prop_key) DO NOTHING;
  306. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (805, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  307. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (806, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  308. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (806, 'value_text', '电力勘测设计企业') ON CONFLICT (node_id, prop_key) DO NOTHING;
  309. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (806, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  310. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (807, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  311. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (807, 'value_text', '湖北安源安全环保科技有限公司') ON CONFLICT (node_id, prop_key) DO NOTHING;
  312. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (807, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  313. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (808, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  314. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (808, 'value_text', '中国电建集团成都勘测设计研究院有限公司') ON CONFLICT (node_id, prop_key) DO NOTHING;
  315. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (808, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  316. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (809, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  317. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (809, 'value_text', '成都院') ON CONFLICT (node_id, prop_key) DO NOTHING;
  318. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (809, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  319. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (810, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  320. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (810, 'value_text', '93.33') ON CONFLICT (node_id, prop_key) DO NOTHING;
  321. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (810, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  322. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (811, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  323. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (811, 'value_text', '一级') ON CONFLICT (node_id, prop_key) DO NOTHING;
  324. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (811, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  325. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (812, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  326. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (812, 'value_text', '2024年7月13日') ON CONFLICT (node_id, prop_key) DO NOTHING;
  327. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (812, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  328. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (813, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  329. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (813, 'value_text', '2024年10月17日') ON CONFLICT (node_id, prop_key) DO NOTHING;
  330. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (813, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  331. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (814, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  332. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (814, 'value_text', '2024年11月') ON CONFLICT (node_id, prop_key) DO NOTHING;
  333. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (814, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  334. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (815, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  335. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (815, 'value_text', '2023年7月8日-2024年7月8日') ON CONFLICT (node_id, prop_key) DO NOTHING;
  336. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (815, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  337. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (816, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  338. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (816, 'value_text', '2024年10月17日') ON CONFLICT (node_id, prop_key) DO NOTHING;
  339. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (816, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  340. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (817, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  341. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (817, 'value_text', '中国电建集团成都勘测设计研究院有限公司(简称:成都院)成立于2005年,是世界500强企业中国电力建设集团的核心成员企业。作为国家级高新技术企业,成都院以水利水电、新能源和基础设施为核心业务,在水电工程领域承担了金沙江、大渡河、雅砻江等重大河流的规划勘测设计工作,创造了多项"中国第一"和"世界之最"。成都院拥有注册资本50亿元人民币,专业技术人员规模近3000人,累计获得4443项专利和100项行业资质认证,展现了雄厚的技术研发实力。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  342. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (817, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  343. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (818, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  344. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (818, 'value_text', '中国电建集团成都勘测设计研究院有限公司(简称:成都院)是中国电力建设集团核心成员企业,作为国内领先的清洁能源工程服务商,成都院在水利水电、新能源及基础设施领域具有突出优势。成都院深度参与了国家西部大开发和"西电东送"战略,承担了包括两河口水电站、杨房沟水电站、乌东德水电站等重大工程的勘测设计工作,其中两河口水电站拥有世界最高土石坝的纪录。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  345. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (818, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  346. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (819, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  347. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (819, 'value_text', '成都院于2024年3月启动安全生产标准化复审自评工作,成立了以总经理为组长的自评工作领导小组,制定了详细的自评工作方案。自评工作历时3个月,覆盖公司本部及所有在建项目,共发现问题隐患127项,已全部完成整改。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  348. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (819, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  349. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (820, 'is_filled', 'false') ON CONFLICT (node_id, prop_key) DO NOTHING;
  350. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (821, 'is_filled', 'false') ON CONFLICT (node_id, prop_key) DO NOTHING;
  351. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (822, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  352. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (822, 'value_text', '成都院制定并发布《QHSE"十四五"规划》(安质〔2023〕1号),明确了总体安全生产目标,包括7项安全管理及事故控制目标,总体目标为公司"十四五"规划的子规划,安全生产与职业健康工作目标纳入总体生产经营目标。成都院发布《关于印发<成都院2024年安全生产与职业健康、能源节约与生态环境保护工作目标和重点>的通知》(蓉设安质〔2024〕18号),明确了2024年安全生产与职业健康目标,包括9项安全管理目标和10项事故控制目标。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  353. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (822, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  354. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (823, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  355. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (823, 'value_text', '成都院建立了完善的安全生产组织机构体系,设立了安全生产委员会作为最高决策机构,下设安全质量环保部作为专职管理部门。公司各级领导班子成员均签订了安全生产责任书,明确了"党政同责、一岗双责"的安全生产责任制。各部门、各项目部均配备了专(兼)职安全管理人员,形成了横向到边、纵向到底的安全管理网络。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  356. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (823, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  357. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (824, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  358. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (824, 'value_text', '成都院建立了全员参与的安全生产管理机制,通过安全生产责任制的层层签订,将安全责任落实到每一位员工。公司定期组织安全生产培训和应急演练,提高全员安全意识和应急处置能力。建立了安全隐患举报奖励制度,鼓励员工积极参与安全管理。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  359. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (824, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  360. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (825, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  361. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (825, 'value_text', '成都院严格执行安全生产费用提取和使用制度,按照规定比例提取安全生产费用,专款专用。2024年度安全生产投入总额达到2500万元,主要用于安全设施设备更新、安全培训教育、应急救援物资储备等方面。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  362. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (825, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  363. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (826, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  364. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (826, 'value_text', '成都院积极推进安全文化建设,将安全理念融入企业文化体系。通过开展"安全生产月"、"安全知识竞赛"等活动,营造浓厚的安全文化氛围。建立了安全文化展示厅,展示公司安全发展历程和典型案例。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  365. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (826, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  366. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (827, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  367. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (827, 'value_text', '成都院建立了完善的安全生产规章制度体系,涵盖安全生产责任制、安全生产管理制度、安全操作规程等方面。公司定期对制度进行评审和修订,确保制度的适用性和有效性。建立了制度执行情况检查机制,确保各项制度落实到位。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  368. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (827, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  369. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (828, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  370. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (828, 'value_text', '成都院建立了完善的安全教育培训管理制度,制定了年度培训计划,明确了培训内容、培训对象和培训要求。公司设立了专门的培训管理部门,配备了专职培训管理人员,建立了培训档案管理系统。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  371. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (828, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  372. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (829, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  373. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (829, 'value_text', '成都院严格执行三级安全教育培训制度,新员工入职必须完成公司级、部门级、班组级三级安全教育培训。特种作业人员全部持证上岗,证书有效期内复审率达到100%。2024年度共组织各类安全培训156次,培训人员达到8500人次。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  374. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (829, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  375. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (830, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  376. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (830, 'value_text', '成都院建立了完善的设备设施管理制度,对所有生产设备设施实行台账管理。定期开展设备设施安全检查和维护保养,确保设备设施处于良好状态。特种设备全部按规定进行检验检测,检验合格率达到100%。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  377. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (830, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  378. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (831, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  379. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (831, 'value_text', '成都院严格执行作业安全管理制度,对高风险作业实行作业许可制度。建立了作业风险分析和控制措施制度,作业前必须进行风险辨识和安全交底。配备了完善的个人防护用品,确保作业人员安全。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  380. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (831, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  381. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (832, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  382. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (832, 'value_text', '成都院建立了岗位达标管理制度,明确了各岗位的安全生产职责和能力要求。定期开展岗位达标考核,考核结果与绩效挂钩。2024年度岗位达标率达到98%以上。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  383. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (832, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  384. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (833, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  385. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (833, 'value_text', '成都院建立了相关方安全管理制度,对承包商、供应商等相关方实行准入管理。签订安全生产协议,明确双方安全责任。定期对相关方进行安全检查和评价,不合格的相关方及时清退。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  386. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (833, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  387. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (834, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  388. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (834, 'value_text', '成都院建立了职业健康管理制度,定期开展职业病危害因素检测和员工职业健康体检。配备了完善的职业病防护设施和个人防护用品。建立了职业健康档案,实行动态管理。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  389. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (834, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  390. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (835, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  391. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (835, 'value_text', '成都院建立了安全风险辨识与评价制度,定期开展全面的风险辨识和评价工作。建立了风险分级管控清单,明确了各级风险的管控措施和责任人。对重大风险实行挂牌督办,确保风险可控。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  392. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (835, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  393. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (836, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  394. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (836, 'value_text', '成都院建立了重大危险源管理制度,对辨识出的重大危险源实行登记建档、定期检测、评估监控。制定了重大危险源应急预案,定期开展应急演练。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  395. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (836, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  396. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (837, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  397. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (837, 'value_text', '成都院建立了隐患排查治理制度,实行分级排查、分类治理。建立了隐患排查治理信息系统,实现隐患的闭环管理。2024年度共排查隐患1256项,整改率达到100%。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  398. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (837, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  399. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (838, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  400. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (838, 'value_text', '成都院建立了变更管理制度,对人员、设备、工艺、环境等方面的变更实行审批管理。变更前进行风险评估,变更后进行验收确认,确保变更安全可控。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  401. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (838, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  402. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (839, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  403. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (839, 'value_text', '成都院建立了安全预测预警机制,利用信息化手段对安全生产状况进行实时监控和分析。建立了安全生产预警指标体系,及时发布预警信息,采取预防措施。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  404. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (839, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  405. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (840, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  406. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (840, 'value_text', '成都院建立了完善的应急救援体系,制定了综合应急预案和专项应急预案。配备了应急救援物资和装备,建立了应急救援队伍。定期开展应急演练,提高应急处置能力。2024年度共组织应急演练32次。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  407. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (840, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  408. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (841, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  409. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (841, 'value_text', '成都院建立了事故管理制度,明确了事故报告、调查、处理和统计分析的程序和要求。建立了事故案例库,定期开展事故案例学习和警示教育。复审期内未发生生产安全事故。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  410. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (841, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  411. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (842, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  412. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (842, 'value_text', '成都院建立了安全生产持续改进机制,定期开展安全生产绩效评估和管理评审。根据评估结果制定改进措施,持续提升安全生产管理水平。建立了安全生产标准化建设长效机制,确保标准化工作持续有效运行。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  413. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (842, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  414. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (843, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  415. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (843, 'value_text', '成都院自2015年首次通过电力勘测设计企业一级安全生产标准化评审以来,始终坚持标准化建设不放松,持续完善安全生产管理体系。公司将安全生产标准化建设纳入年度工作计划,定期开展自评和整改,确保标准化工作持续有效运行。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  416. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (843, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  417. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (844, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
  418. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (844, 'value_text', '成都院在安全生产管理方面形成了多项亮点:一是建立了智慧安全管理平台,实现了安全管理信息化、智能化;二是创新了"安全+党建"工作模式,将安全工作与党建工作深度融合;三是建立了安全生产标准化建设长效机制,确保标准化工作持续有效运行。') ON CONFLICT (node_id, prop_key) DO NOTHING;
  419. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (844, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
  420. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (845, 'is_filled', 'false') ON CONFLICT (node_id, prop_key) DO NOTHING;
  421. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (846, 'is_filled', 'false') ON CONFLICT (node_id, prop_key) DO NOTHING;
  422. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (847, 'is_filled', 'false') ON CONFLICT (node_id, prop_key) DO NOTHING;
  423. -- HAS_ELEMENT 关系
  424. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 701, 1) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  425. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 702, 2) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  426. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 703, 3) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  427. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 704, 4) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  428. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 705, 5) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  429. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 706, 6) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  430. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 707, 7) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  431. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 708, 8) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  432. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 709, 9) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  433. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 710, 10) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  434. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 711, 11) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  435. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 712, 12) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  436. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 713, 13) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  437. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 714, 14) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  438. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 715, 15) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  439. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 716, 16) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  440. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 717, 17) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  441. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 718, 18) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  442. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 719, 19) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  443. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 720, 20) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  444. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 721, 21) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  445. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 722, 22) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  446. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 723, 23) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  447. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 724, 24) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  448. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 725, 25) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  449. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 726, 26) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  450. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 727, 27) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  451. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 728, 28) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  452. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 729, 29) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  453. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 730, 30) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  454. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 731, 31) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  455. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 732, 32) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  456. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 733, 33) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  457. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 734, 34) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  458. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 735, 35) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  459. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 736, 36) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  460. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 737, 37) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  461. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 738, 38) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  462. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 739, 39) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  463. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 740, 40) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  464. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 741, 41) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  465. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 742, 42) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  466. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 743, 43) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  467. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 744, 44) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  468. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 745, 45) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  469. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 746, 46) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  470. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ELEMENT', 10, 747, 47) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  471. -- HAS_VALUE 关系
  472. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 801) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  473. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 802) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  474. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 803) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  475. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 804) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  476. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 805) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  477. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 806) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  478. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 807) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  479. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 808) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  480. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 809) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  481. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 810) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  482. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 811) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  483. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 812) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  484. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 813) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  485. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 814) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  486. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 815) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  487. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 816) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  488. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 817) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  489. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 818) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  490. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 819) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  491. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 820) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  492. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 821) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  493. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 822) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  494. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 823) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  495. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 824) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  496. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 825) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  497. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 826) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  498. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 827) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  499. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 828) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  500. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 829) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  501. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 830) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  502. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 831) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  503. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 832) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  504. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 833) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  505. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 834) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  506. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 835) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  507. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 836) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  508. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 837) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  509. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 838) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  510. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 839) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  511. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 840) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  512. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 841) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  513. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 842) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  514. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 843) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  515. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 844) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  516. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 845) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  517. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 846) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  518. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_VALUE', 10, 847) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  519. -- FOR_ELEMENT 关系
  520. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 801, 701) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  521. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 802, 702) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  522. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 803, 703) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  523. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 804, 704) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  524. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 805, 705) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  525. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 806, 706) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  526. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 807, 707) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  527. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 808, 708) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  528. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 809, 709) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  529. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 810, 710) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  530. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 811, 711) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  531. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 812, 712) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  532. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 813, 713) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  533. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 814, 714) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  534. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 815, 715) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  535. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 816, 716) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  536. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 817, 717) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  537. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 818, 718) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  538. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 819, 719) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  539. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 820, 720) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  540. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 821, 721) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  541. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 822, 722) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  542. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 823, 723) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  543. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 824, 724) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  544. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 825, 725) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  545. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 826, 726) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  546. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 827, 727) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  547. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 828, 728) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  548. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 829, 729) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  549. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 830, 730) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  550. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 831, 731) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  551. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 832, 732) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  552. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 833, 733) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  553. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 834, 734) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  554. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 835, 735) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  555. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 836, 736) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  556. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 837, 737) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  557. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 838, 738) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  558. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 839, 739) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  559. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 840, 740) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  560. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 841, 741) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  561. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 842, 742) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  562. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 843, 743) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  563. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 844, 744) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  564. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 845, 745) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  565. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 846, 746) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  566. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('FOR_ELEMENT', 847, 747) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  567. -- 附件节点
  568. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (400, 'ATTACHMENT', 'ATT-001', '01-复审通知', 1) ON CONFLICT (id) DO NOTHING;
  569. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (401, 'ATTACHMENT', 'ATT-002', '02-评审报告原文', 1) ON CONFLICT (id) DO NOTHING;
  570. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (402, 'ATTACHMENT', 'ATT-003', '03-安全标准化达标证书', 1) ON CONFLICT (id) DO NOTHING;
  571. -- 附件属性
  572. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (400, 'file_name', '复审通知.docx') ON CONFLICT (node_id, prop_key) DO NOTHING;
  573. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (400, 'parse_status', 'completed') ON CONFLICT (node_id, prop_key) DO NOTHING;
  574. INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (400, 'file_size', 102400) ON CONFLICT (node_id, prop_key) DO NOTHING;
  575. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (401, 'file_name', '评审报告.pdf') ON CONFLICT (node_id, prop_key) DO NOTHING;
  576. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (401, 'parse_status', 'completed') ON CONFLICT (node_id, prop_key) DO NOTHING;
  577. INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (401, 'file_size', 512000) ON CONFLICT (node_id, prop_key) DO NOTHING;
  578. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (402, 'file_name', '达标证书.pdf') ON CONFLICT (node_id, prop_key) DO NOTHING;
  579. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (402, 'parse_status', 'completed') ON CONFLICT (node_id, prop_key) DO NOTHING;
  580. INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (402, 'file_size', 256000) ON CONFLICT (node_id, prop_key) DO NOTHING;
  581. -- HAS_ATTACHMENT 关系
  582. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ATTACHMENT', 10, 400, 1) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  583. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ATTACHMENT', 10, 401, 2) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  584. INSERT INTO edges (edge_type, from_node_id, to_node_id, sort_order) VALUES ('HAS_ATTACHMENT', 10, 402, 3) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  585. -- 实体节点
  586. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (500, 'ENTITY', 'ORG:成都院', '中国电建集团成都勘测设计研究院有限公司', 1) ON CONFLICT (id) DO NOTHING;
  587. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (501, 'ENTITY', 'ORG:成都院简称', '成都院', 1) ON CONFLICT (id) DO NOTHING;
  588. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (502, 'ENTITY', 'CODE:BZ-0092-2024', 'BZ-0092-2024', 1) ON CONFLICT (id) DO NOTHING;
  589. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (503, 'ENTITY', 'DATE:开始', '2024年7月13日', 1) ON CONFLICT (id) DO NOTHING;
  590. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (504, 'ENTITY', 'DATE:结束', '2024年10月17日', 1) ON CONFLICT (id) DO NOTHING;
  591. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (505, 'ENTITY', 'NUMBER:得分', '93.33', 1) ON CONFLICT (id) DO NOTHING;
  592. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (506, 'ENTITY', 'DATE:申请', '2024年7月8日', 1) ON CONFLICT (id) DO NOTHING;
  593. INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (507, 'ENTITY', 'DATE:证书', '2019年12月9日', 1) ON CONFLICT (id) DO NOTHING;
  594. -- 实体属性
  595. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (500, 'entity_type', 'ORG') ON CONFLICT (node_id, prop_key) DO NOTHING;
  596. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (500, 'business_label', '评审对象') ON CONFLICT (node_id, prop_key) DO NOTHING;
  597. INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (500, 'confidence', 0.95) ON CONFLICT (node_id, prop_key) DO NOTHING;
  598. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (501, 'entity_type', 'ORG') ON CONFLICT (node_id, prop_key) DO NOTHING;
  599. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (501, 'business_label', '评审对象简称') ON CONFLICT (node_id, prop_key) DO NOTHING;
  600. INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (501, 'confidence', 0.95) ON CONFLICT (node_id, prop_key) DO NOTHING;
  601. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (502, 'entity_type', 'CODE') ON CONFLICT (node_id, prop_key) DO NOTHING;
  602. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (502, 'business_label', '项目编号') ON CONFLICT (node_id, prop_key) DO NOTHING;
  603. INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (502, 'confidence', 0.95) ON CONFLICT (node_id, prop_key) DO NOTHING;
  604. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (503, 'entity_type', 'DATE') ON CONFLICT (node_id, prop_key) DO NOTHING;
  605. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (503, 'business_label', '评审开始日期') ON CONFLICT (node_id, prop_key) DO NOTHING;
  606. INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (503, 'confidence', 0.95) ON CONFLICT (node_id, prop_key) DO NOTHING;
  607. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (504, 'entity_type', 'DATE') ON CONFLICT (node_id, prop_key) DO NOTHING;
  608. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (504, 'business_label', '评审结束日期') ON CONFLICT (node_id, prop_key) DO NOTHING;
  609. INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (504, 'confidence', 0.95) ON CONFLICT (node_id, prop_key) DO NOTHING;
  610. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (505, 'entity_type', 'NUMBER') ON CONFLICT (node_id, prop_key) DO NOTHING;
  611. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (505, 'business_label', '评审得分') ON CONFLICT (node_id, prop_key) DO NOTHING;
  612. INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (505, 'confidence', 0.95) ON CONFLICT (node_id, prop_key) DO NOTHING;
  613. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (506, 'entity_type', 'DATE') ON CONFLICT (node_id, prop_key) DO NOTHING;
  614. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (506, 'business_label', '申请日期') ON CONFLICT (node_id, prop_key) DO NOTHING;
  615. INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (506, 'confidence', 0.95) ON CONFLICT (node_id, prop_key) DO NOTHING;
  616. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (507, 'entity_type', 'DATE') ON CONFLICT (node_id, prop_key) DO NOTHING;
  617. INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (507, 'business_label', '证书获取日期') ON CONFLICT (node_id, prop_key) DO NOTHING;
  618. INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (507, 'confidence', 0.95) ON CONFLICT (node_id, prop_key) DO NOTHING;
  619. -- HAS_ENTITY 关系
  620. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_ENTITY', 400, 500) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  621. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_ENTITY', 400, 501) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  622. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_ENTITY', 400, 502) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  623. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_ENTITY', 400, 503) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  624. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_ENTITY', 400, 504) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  625. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_ENTITY', 400, 505) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  626. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_ENTITY', 400, 506) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  627. INSERT INTO edges (edge_type, from_node_id, to_node_id) VALUES ('HAS_ENTITY', 400, 507) ON CONFLICT (edge_type, from_node_id, to_node_id) DO NOTHING;
  628. -- 更新序列
  629. SELECT setval('nodes_id_seq', (SELECT COALESCE(MAX(id), 1) FROM nodes));
  630. SELECT setval('edges_id_seq', (SELECT COALESCE(MAX(id), 1) FROM edges));
  631. SELECT setval('node_properties_id_seq', (SELECT COALESCE(MAX(id), 1) FROM node_properties));
  632. SELECT '47个要素 Mock 数据导入完成' AS result;