filesystem_graph

Column	Type
graph_name	VARCHAR
uniform_resource_id	VARCHAR
nature	TEXT
uri	TEXT
ur_ingest_session_fs_path_id	VARCHAR
root_path	TEXT

SQL DDL

CREATE VIEW "filesystem_graph" AS
    SELECT
        ure.graph_name,
        ur.uniform_resource_id,
        ur.nature,
        ur.uri,
        ur_ingest_fs_path.ur_ingest_session_fs_path_id,
        ur_ingest_fs_path.root_path
    FROM
        uniform_resource_edge ure
    JOIN
        uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
    JOIN
        ur_ingest_session_fs_path ur_ingest_fs_path ON ure.node_id = ur_ingest_fs_path.ur_ingest_session_fs_path_id
    WHERE
        ure.graph_name = 'filesystem'