imap_graph

Column	Type
graph_name	VARCHAR
uniform_resource_id	VARCHAR
nature	TEXT
uri	TEXT
content	BLOB
ur_ingest_session_imap_acct_folder_message_id	VARCHAR
ingest_imap_acct_folder_id	VARCHAR
message_id	TEXT

SQL DDL

CREATE VIEW "imap_graph" AS
      SELECT
        ure.graph_name,
        ur.uniform_resource_id,
        ur.nature,
        ur.uri,
        ur.content,
        ur_ingest_imap.ur_ingest_session_imap_acct_folder_message_id,
        ur_ingest_imap.ingest_imap_acct_folder_id,
        ur_ingest_imap.message_id
    FROM
        uniform_resource_edge ure
    JOIN
        uniform_resource ur ON ure.uniform_resource_id = ur.uniform_resource_id
    JOIN
        ur_ingest_session_imap_acct_folder_message ur_ingest_imap ON ure.node_id = ur_ingest_imap.ur_ingest_session_imap_acct_folder_message_id
    WHERE
        ure.graph_name = 'imap'