filesystem_graph

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

SQL DDL

CREATE VIEW `filesystem_graph` AS select "uniform_resource_edge"."graph_name", "uniform_resource"."uniform_resource_id", "uniform_resource"."nature", "uniform_resource"."uri", "ur_ingest_session_fs_path"."ur_ingest_session_fs_path_id", "ur_ingest_session_fs_path"."root_path" from "uniform_resource_edge" inner join "uniform_resource" on "uniform_resource_edge"."uniform_resource_id" = "uniform_resource"."uniform_resource_id" inner join "ur_ingest_session_fs_path" on "uniform_resource_edge"."node_id" = "ur_ingest_session_fs_path"."ur_ingest_session_fs_path_id" where "uniform_resource_edge"."graph_name" = 'filesystem'