plm_graph

Column	Type
graph_name	VARCHAR
nature	TEXT
uniform_resource_id	VARCHAR
uri	TEXT
ur_ingest_session_plm_acct_project_issue_id	VARCHAR
issue_id	TEXT
project_id	VARCHAR
title	TEXT
body	TEXT

SQL DDL

CREATE VIEW "plm_graph" AS
    SELECT
        ure.graph_name,
        ure.nature,
        ur.uniform_resource_id,
        ur.uri,
        ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id,
        ur_ingest_plm.issue_id,
        ur_ingest_plm.ur_ingest_session_plm_acct_project_id as project_id,
        ur_ingest_plm.title,
        ur_ingest_plm.body
    FROM
        uniform_resource_edge ure
    JOIN
        uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
    JOIN
        ur_ingest_session_plm_acct_project_issue ur_ingest_plm ON ure.node_id = ur_ingest_plm.ur_ingest_session_plm_acct_project_issue_id
    WHERE
        ure.graph_name = 'plm'