| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648 |
- -- 灵越智报 Mock 数据 (图数据库格式)
- -- 生成时间: 2026-03-02
- -- 项目节点
- INSERT INTO nodes (id, node_type, node_key, name, status, created_by) VALUES
- (10, 'PROJECT', 'PRJ-2024-001', '成都院2024年复审报告', 'draft', 1)
- ON CONFLICT (id) DO NOTHING;
- -- 要素定义节点 (47个)
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (701, 'ELEMENT', 'basicInfo.projectCode', '项目编号', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (702, 'ELEMENT', 'basicInfo.requestLevel', '申请级别', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (703, 'ELEMENT', 'basicInfo.applyAt', '申请日期', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (704, 'ELEMENT', 'basicInfo.reviewObjectCertificateGetAt', '证书获取日期', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (705, 'ELEMENT', 'basicInfo.reviewObjectCertificate2GetAt', '二次证书获取日期', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (706, 'ELEMENT', 'basicInfo.reviewCategory', '申请类别', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (707, 'ELEMENT', 'basicInfo.reviewUnit', '评审单位', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (708, 'ELEMENT', 'project.reviewObject', '评审对象', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (709, 'ELEMENT', 'project.reviewObjectAlias', '评审对象简称', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (710, 'ELEMENT', 'project.resultScore', '评审得分', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (711, 'ELEMENT', 'project.resultLevel', '评审级别', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (712, 'ELEMENT', 'project.workStartAt', '评审开始日期', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (713, 'ELEMENT', 'project.workEndAt', '评审结束日期', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (714, 'ELEMENT', 'project.createdAt', '报告日期', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (715, 'ELEMENT', 'project.reviewPeriod', '评审周期', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (716, 'ELEMENT', 'project.closingMeetingAt', '末次评审会议时间', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (717, 'ELEMENT', 'project.reviewObjectSummary', '评审对象概况', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (718, 'ELEMENT', 'project.reviewObjectDescription', '评审对象描述', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (719, 'ELEMENT', 'project.reviewObjectSelfAssessmentProcess', '评审对象自评过程', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (720, 'ELEMENT', 'project.reviewRange', '复审范围', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (721, 'ELEMENT', 'project.reviewRangeShort', '复审范围简称', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (722, 'ELEMENT', 'project.target', '目标', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (723, 'ELEMENT', 'project.duty', '组织机构和职责', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (724, 'ELEMENT', 'project.fullParticipation', '全员参与', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (725, 'ELEMENT', 'project.safetyInvestment', '安全生产投入', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (726, 'ELEMENT', 'project.safetyCulture', '安全文化建设', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (727, 'ELEMENT', 'project.systematicManagement', '制度化管理', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (728, 'ELEMENT', 'project.trainingManagement', '教育培训管理', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (729, 'ELEMENT', 'project.employeeTraining', '人员教育培训', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (730, 'ELEMENT', 'project.assetManagement', '设备设施管理', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (731, 'ELEMENT', 'project.jobSafety', '作业安全', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (732, 'ELEMENT', 'project.positionQualified', '岗位达标', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (733, 'ELEMENT', 'project.partner', '相关方', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (734, 'ELEMENT', 'project.occupationalHealth', '职业健康', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (735, 'ELEMENT', 'project.riskAssessment', '风险辨识与评价', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (736, 'ELEMENT', 'project.majorHazardManagement', '重大危险源管理', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (737, 'ELEMENT', 'project.hazardInspection', '隐患排查', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (738, 'ELEMENT', 'project.changeManagement', '变更管理', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (739, 'ELEMENT', 'project.earlyWarning', '预测预警', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (740, 'ELEMENT', 'project.emergencyResponse', '应急救援', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (741, 'ELEMENT', 'project.incidentManagement', '事故管理', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (742, 'ELEMENT', 'project.continuousImprovement', '持续改进', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (743, 'ELEMENT', 'project.safetyStandardizationStatus', '安全生产标准化建设和持续运行情况', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (744, 'ELEMENT', 'project.safetyHighlight', '安全生产管理亮点', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (745, 'ELEMENT', 'project.workProcess', '现场复审工作过程', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (746, 'ELEMENT', 'project.moreWorkReference', '工作依据', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (747, 'ELEMENT', '+expert_list', '专家组成员表', 1) ON CONFLICT (id) DO NOTHING;
- -- 要素定义属性
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (701, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (701, 'namespace', 'basicInfo') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (701, 'field_name', 'projectCode') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (701, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (702, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (702, 'namespace', 'basicInfo') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (702, 'field_name', 'requestLevel') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (702, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (703, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (703, 'namespace', 'basicInfo') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (703, 'field_name', 'applyAt') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (703, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (704, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (704, 'namespace', 'basicInfo') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (704, 'field_name', 'reviewObjectCertificateGetAt') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (704, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (705, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (705, 'namespace', 'basicInfo') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (705, 'field_name', 'reviewObjectCertificate2GetAt') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (705, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (706, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (706, 'namespace', 'basicInfo') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (706, 'field_name', 'reviewCategory') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (706, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (707, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (707, 'namespace', 'basicInfo') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (707, 'field_name', 'reviewUnit') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (707, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (708, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (708, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (708, 'field_name', 'reviewObject') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (708, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (709, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (709, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (709, 'field_name', 'reviewObjectAlias') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (709, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (710, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (710, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (710, 'field_name', 'resultScore') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (710, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (711, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (711, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (711, 'field_name', 'resultLevel') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (711, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (712, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (712, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (712, 'field_name', 'workStartAt') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (712, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (713, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (713, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (713, 'field_name', 'workEndAt') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (713, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (714, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (714, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (714, 'field_name', 'createdAt') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (714, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (715, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (715, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (715, 'field_name', 'reviewPeriod') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (715, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (716, 'element_type', 'text') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (716, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (716, 'field_name', 'closingMeetingAt') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (716, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (717, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (717, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (717, 'field_name', 'reviewObjectSummary') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (717, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (718, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (718, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (718, 'field_name', 'reviewObjectDescription') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (718, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (719, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (719, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (719, 'field_name', 'reviewObjectSelfAssessmentProcess') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (719, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (720, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (720, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (720, 'field_name', 'reviewRange') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (720, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (721, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (721, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (721, 'field_name', 'reviewRangeShort') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (721, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (722, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (722, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (722, 'field_name', 'target') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (722, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (723, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (723, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (723, 'field_name', 'duty') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (723, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (724, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (724, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (724, 'field_name', 'fullParticipation') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (724, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (725, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (725, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (725, 'field_name', 'safetyInvestment') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (725, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (726, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (726, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (726, 'field_name', 'safetyCulture') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (726, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (727, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (727, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (727, 'field_name', 'systematicManagement') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (727, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (728, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (728, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (728, 'field_name', 'trainingManagement') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (728, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (729, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (729, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (729, 'field_name', 'employeeTraining') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (729, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (730, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (730, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (730, 'field_name', 'assetManagement') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (730, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (731, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (731, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (731, 'field_name', 'jobSafety') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (731, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (732, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (732, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (732, 'field_name', 'positionQualified') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (732, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (733, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (733, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (733, 'field_name', 'partner') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (733, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (734, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (734, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (734, 'field_name', 'occupationalHealth') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (734, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (735, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (735, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (735, 'field_name', 'riskAssessment') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (735, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (736, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (736, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (736, 'field_name', 'majorHazardManagement') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (736, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (737, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (737, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (737, 'field_name', 'hazardInspection') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (737, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (738, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (738, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (738, 'field_name', 'changeManagement') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (738, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (739, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (739, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (739, 'field_name', 'earlyWarning') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (739, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (740, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (740, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (740, 'field_name', 'emergencyResponse') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (740, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (741, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (741, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (741, 'field_name', 'incidentManagement') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (741, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (742, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (742, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (742, 'field_name', 'continuousImprovement') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (742, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (743, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (743, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (743, 'field_name', 'safetyStandardizationStatus') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (743, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (744, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (744, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (744, 'field_name', 'safetyHighlight') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (744, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (745, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (745, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (745, 'field_name', 'workProcess') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (745, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (746, 'element_type', 'paragraph') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (746, 'namespace', 'project') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (746, 'field_name', 'moreWorkReference') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (746, 'required', false) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (747, 'element_type', 'table') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (747, 'field_name', 'expert_list') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (747, 'required', true) ON CONFLICT (node_id, prop_key) DO NOTHING;
- -- 要素值节点 (47个)
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- -- 要素值属性
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (801, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- 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;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (801, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (802, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (802, 'value_text', '一级') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (802, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (803, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- 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;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (803, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (804, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- 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;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (804, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (805, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- 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;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (805, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (806, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (806, 'value_text', '电力勘测设计企业') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (806, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (807, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (807, 'value_text', '湖北安源安全环保科技有限公司') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (807, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (808, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (808, 'value_text', '中国电建集团成都勘测设计研究院有限公司') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (808, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (809, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (809, 'value_text', '成都院') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (809, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (810, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (810, 'value_text', '93.33') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (810, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (811, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (811, 'value_text', '一级') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (811, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (812, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- 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;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (812, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (813, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- 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;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (813, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (814, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (814, 'value_text', '2024年11月') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (814, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (815, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- 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;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (815, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (816, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- 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;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (816, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (817, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- 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;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (817, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (818, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (818, 'value_text', '中国电建集团成都勘测设计研究院有限公司(简称:成都院)是中国电力建设集团核心成员企业,作为国内领先的清洁能源工程服务商,成都院在水利水电、新能源及基础设施领域具有突出优势。成都院深度参与了国家西部大开发和"西电东送"战略,承担了包括两河口水电站、杨房沟水电站、乌东德水电站等重大工程的勘测设计工作,其中两河口水电站拥有世界最高土石坝的纪录。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (818, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (819, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- 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;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (819, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (820, 'is_filled', 'false') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (821, 'is_filled', 'false') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (822, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- 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;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (822, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (823, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (823, 'value_text', '成都院建立了完善的安全生产组织机构体系,设立了安全生产委员会作为最高决策机构,下设安全质量环保部作为专职管理部门。公司各级领导班子成员均签订了安全生产责任书,明确了"党政同责、一岗双责"的安全生产责任制。各部门、各项目部均配备了专(兼)职安全管理人员,形成了横向到边、纵向到底的安全管理网络。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (823, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (824, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (824, 'value_text', '成都院建立了全员参与的安全生产管理机制,通过安全生产责任制的层层签订,将安全责任落实到每一位员工。公司定期组织安全生产培训和应急演练,提高全员安全意识和应急处置能力。建立了安全隐患举报奖励制度,鼓励员工积极参与安全管理。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (824, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (825, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (825, 'value_text', '成都院严格执行安全生产费用提取和使用制度,按照规定比例提取安全生产费用,专款专用。2024年度安全生产投入总额达到2500万元,主要用于安全设施设备更新、安全培训教育、应急救援物资储备等方面。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (825, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (826, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (826, 'value_text', '成都院积极推进安全文化建设,将安全理念融入企业文化体系。通过开展"安全生产月"、"安全知识竞赛"等活动,营造浓厚的安全文化氛围。建立了安全文化展示厅,展示公司安全发展历程和典型案例。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (826, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (827, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (827, 'value_text', '成都院建立了完善的安全生产规章制度体系,涵盖安全生产责任制、安全生产管理制度、安全操作规程等方面。公司定期对制度进行评审和修订,确保制度的适用性和有效性。建立了制度执行情况检查机制,确保各项制度落实到位。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (827, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (828, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (828, 'value_text', '成都院建立了完善的安全教育培训管理制度,制定了年度培训计划,明确了培训内容、培训对象和培训要求。公司设立了专门的培训管理部门,配备了专职培训管理人员,建立了培训档案管理系统。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (828, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (829, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- 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;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (829, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (830, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (830, 'value_text', '成都院建立了完善的设备设施管理制度,对所有生产设备设施实行台账管理。定期开展设备设施安全检查和维护保养,确保设备设施处于良好状态。特种设备全部按规定进行检验检测,检验合格率达到100%。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (830, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (831, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (831, 'value_text', '成都院严格执行作业安全管理制度,对高风险作业实行作业许可制度。建立了作业风险分析和控制措施制度,作业前必须进行风险辨识和安全交底。配备了完善的个人防护用品,确保作业人员安全。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (831, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (832, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (832, 'value_text', '成都院建立了岗位达标管理制度,明确了各岗位的安全生产职责和能力要求。定期开展岗位达标考核,考核结果与绩效挂钩。2024年度岗位达标率达到98%以上。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (832, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (833, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (833, 'value_text', '成都院建立了相关方安全管理制度,对承包商、供应商等相关方实行准入管理。签订安全生产协议,明确双方安全责任。定期对相关方进行安全检查和评价,不合格的相关方及时清退。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (833, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (834, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (834, 'value_text', '成都院建立了职业健康管理制度,定期开展职业病危害因素检测和员工职业健康体检。配备了完善的职业病防护设施和个人防护用品。建立了职业健康档案,实行动态管理。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (834, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (835, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (835, 'value_text', '成都院建立了安全风险辨识与评价制度,定期开展全面的风险辨识和评价工作。建立了风险分级管控清单,明确了各级风险的管控措施和责任人。对重大风险实行挂牌督办,确保风险可控。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (835, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (836, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (836, 'value_text', '成都院建立了重大危险源管理制度,对辨识出的重大危险源实行登记建档、定期检测、评估监控。制定了重大危险源应急预案,定期开展应急演练。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (836, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (837, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- 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;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (837, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (838, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (838, 'value_text', '成都院建立了变更管理制度,对人员、设备、工艺、环境等方面的变更实行审批管理。变更前进行风险评估,变更后进行验收确认,确保变更安全可控。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (838, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (839, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (839, 'value_text', '成都院建立了安全预测预警机制,利用信息化手段对安全生产状况进行实时监控和分析。建立了安全生产预警指标体系,及时发布预警信息,采取预防措施。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (839, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (840, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (840, 'value_text', '成都院建立了完善的应急救援体系,制定了综合应急预案和专项应急预案。配备了应急救援物资和装备,建立了应急救援队伍。定期开展应急演练,提高应急处置能力。2024年度共组织应急演练32次。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (840, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (841, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (841, 'value_text', '成都院建立了事故管理制度,明确了事故报告、调查、处理和统计分析的程序和要求。建立了事故案例库,定期开展事故案例学习和警示教育。复审期内未发生生产安全事故。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (841, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (842, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (842, 'value_text', '成都院建立了安全生产持续改进机制,定期开展安全生产绩效评估和管理评审。根据评估结果制定改进措施,持续提升安全生产管理水平。建立了安全生产标准化建设长效机制,确保标准化工作持续有效运行。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (842, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (843, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (843, 'value_text', '成都院自2015年首次通过电力勘测设计企业一级安全生产标准化评审以来,始终坚持标准化建设不放松,持续完善安全生产管理体系。公司将安全生产标准化建设纳入年度工作计划,定期开展自评和整改,确保标准化工作持续有效运行。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (843, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (844, 'is_filled', 'true') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (844, 'value_text', '成都院在安全生产管理方面形成了多项亮点:一是建立了智慧安全管理平台,实现了安全管理信息化、智能化;二是创新了"安全+党建"工作模式,将安全工作与党建工作深度融合;三是建立了安全生产标准化建设长效机制,确保标准化工作持续有效运行。') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (844, 'fill_source', 'rule') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (845, 'is_filled', 'false') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (846, 'is_filled', 'false') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (847, 'is_filled', 'false') ON CONFLICT (node_id, prop_key) DO NOTHING;
- -- HAS_ELEMENT 关系
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- -- HAS_VALUE 关系
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- -- FOR_ELEMENT 关系
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- -- 附件节点
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (400, 'ATTACHMENT', 'ATT-001', '01-复审通知', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (401, 'ATTACHMENT', 'ATT-002', '02-评审报告原文', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (402, 'ATTACHMENT', 'ATT-003', '03-安全标准化达标证书', 1) ON CONFLICT (id) DO NOTHING;
- -- 附件属性
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (400, 'file_name', '复审通知.docx') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (400, 'parse_status', 'completed') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (400, 'file_size', 102400) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (401, 'file_name', '评审报告.pdf') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (401, 'parse_status', 'completed') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (401, 'file_size', 512000) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (402, 'file_name', '达标证书.pdf') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (402, 'parse_status', 'completed') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (402, 'file_size', 256000) ON CONFLICT (node_id, prop_key) DO NOTHING;
- -- HAS_ATTACHMENT 关系
- 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;
- 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;
- 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;
- -- 实体节点
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (500, 'ENTITY', 'ORG:成都院', '中国电建集团成都勘测设计研究院有限公司', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (501, 'ENTITY', 'ORG:成都院简称', '成都院', 1) ON CONFLICT (id) DO NOTHING;
- 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;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (503, 'ENTITY', 'DATE:开始', '2024年7月13日', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (504, 'ENTITY', 'DATE:结束', '2024年10月17日', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (505, 'ENTITY', 'NUMBER:得分', '93.33', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (506, 'ENTITY', 'DATE:申请', '2024年7月8日', 1) ON CONFLICT (id) DO NOTHING;
- INSERT INTO nodes (id, node_type, node_key, name, created_by) VALUES (507, 'ENTITY', 'DATE:证书', '2019年12月9日', 1) ON CONFLICT (id) DO NOTHING;
- -- 实体属性
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (500, 'entity_type', 'ORG') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (500, 'business_label', '评审对象') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (500, 'confidence', 0.95) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (501, 'entity_type', 'ORG') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (501, 'business_label', '评审对象简称') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (501, 'confidence', 0.95) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (502, 'entity_type', 'CODE') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (502, 'business_label', '项目编号') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (502, 'confidence', 0.95) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (503, 'entity_type', 'DATE') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (503, 'business_label', '评审开始日期') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (503, 'confidence', 0.95) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (504, 'entity_type', 'DATE') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (504, 'business_label', '评审结束日期') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (504, 'confidence', 0.95) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (505, 'entity_type', 'NUMBER') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (505, 'business_label', '评审得分') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (505, 'confidence', 0.95) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (506, 'entity_type', 'DATE') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (506, 'business_label', '申请日期') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (506, 'confidence', 0.95) ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (507, 'entity_type', 'DATE') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_value) VALUES (507, 'business_label', '证书获取日期') ON CONFLICT (node_id, prop_key) DO NOTHING;
- INSERT INTO node_properties (node_id, prop_key, prop_number) VALUES (507, 'confidence', 0.95) ON CONFLICT (node_id, prop_key) DO NOTHING;
- -- HAS_ENTITY 关系
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- 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;
- -- 更新序列
- SELECT setval('nodes_id_seq', (SELECT COALESCE(MAX(id), 1) FROM nodes));
- SELECT setval('edges_id_seq', (SELECT COALESCE(MAX(id), 1) FROM edges));
- SELECT setval('node_properties_id_seq', (SELECT COALESCE(MAX(id), 1) FROM node_properties));
- SELECT '47个要素 Mock 数据导入完成' AS result;
|