console_information_schema_view (view) Content
| code_notebook_sql_cell_migratable_state | transition_result | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_state&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_state&stats=yes) | [code_notebook_sql_cell_migratable_state (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_state&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_state.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_state.sql?stats=yes) | [code_notebook_sql_cell_migratable_state (view) Content](console/content/view/code_notebook_sql_cell_migratable_state.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_state" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All cells that are candidates for migration (latest only) SELECT c.*, -- All columns from the code_notebook_sql_cell_migratable view s.from_state, -- The state the cell transitioned from s.to_state, -- The state the cell transitioned to s.transition_reason, -- The reason for the state transition s.transition_result, -- The result of the state transition s.transitioned_at -- The timestamp of the state transition FROM code_notebook_sql_cell_migratable c JOIN code_notebook_state s ON c.code_notebook_cell_id = s.code_notebook_cell_id ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_state | transitioned_at | TIMESTAMPTZ | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_state&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_state&stats=yes) | [code_notebook_sql_cell_migratable_state (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_state&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_state.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_state.sql?stats=yes) | [code_notebook_sql_cell_migratable_state (view) Content](console/content/view/code_notebook_sql_cell_migratable_state.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_state" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All cells that are candidates for migration (latest only) SELECT c.*, -- All columns from the code_notebook_sql_cell_migratable view s.from_state, -- The state the cell transitioned from s.to_state, -- The state the cell transitioned to s.transition_reason, -- The reason for the state transition s.transition_result, -- The result of the state transition s.transitioned_at -- The timestamp of the state transition FROM code_notebook_sql_cell_migratable c JOIN code_notebook_state s ON c.code_notebook_cell_id = s.code_notebook_cell_id ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed | code_notebook_cell_id | VARCHAR | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table) SELECT c.* FROM code_notebook_sql_cell_migratable c LEFT JOIN code_notebook_state s ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED' WHERE s.code_notebook_cell_id IS NULL ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed | notebook_kernel_id | VARCHAR | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table) SELECT c.* FROM code_notebook_sql_cell_migratable c LEFT JOIN code_notebook_state s ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED' WHERE s.code_notebook_cell_id IS NULL ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed | notebook_name | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table) SELECT c.* FROM code_notebook_sql_cell_migratable c LEFT JOIN code_notebook_state s ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED' WHERE s.code_notebook_cell_id IS NULL ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed | cell_name | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table) SELECT c.* FROM code_notebook_sql_cell_migratable c LEFT JOIN code_notebook_state s ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED' WHERE s.code_notebook_cell_id IS NULL ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed | interpretable_code | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table) SELECT c.* FROM code_notebook_sql_cell_migratable c LEFT JOIN code_notebook_state s ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED' WHERE s.code_notebook_cell_id IS NULL ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed | interpretable_code_hash | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table) SELECT c.* FROM code_notebook_sql_cell_migratable c LEFT JOIN code_notebook_state s ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED' WHERE s.code_notebook_cell_id IS NULL ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed | description | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table) SELECT c.* FROM code_notebook_sql_cell_migratable c LEFT JOIN code_notebook_state s ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED' WHERE s.code_notebook_cell_id IS NULL ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed | cell_governance | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table) SELECT c.* FROM code_notebook_sql_cell_migratable c LEFT JOIN code_notebook_state s ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED' WHERE s.code_notebook_cell_id IS NULL ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed | arguments | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table) SELECT c.* FROM code_notebook_sql_cell_migratable c LEFT JOIN code_notebook_state s ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED' WHERE s.code_notebook_cell_id IS NULL ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed | activity_log | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table) SELECT c.* FROM code_notebook_sql_cell_migratable c LEFT JOIN code_notebook_state s ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED' WHERE s.code_notebook_cell_id IS NULL ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_not_executed | version_timestamp | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table) SELECT c.* FROM code_notebook_sql_cell_migratable c LEFT JOIN code_notebook_state s ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED' WHERE s.code_notebook_cell_id IS NULL ORDER BY c.cell_name | |
| code_notebook_sql_cell_migratable_not_executed | is_idempotent | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | [code_notebook_sql_cell_migratable_not_executed (view) Content](console/content/view/code_notebook_sql_cell_migratable_not_executed.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_not_executed" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All latest migratable cells that have not yet been "executed" (based on the code_notebook_state table) SELECT c.* FROM code_notebook_sql_cell_migratable c LEFT JOIN code_notebook_state s ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED' WHERE s.code_notebook_cell_id IS NULL ORDER BY c.cell_name | |
| code_notebook_migration_sql | migration_sql | /console/info-schema/view.sql?name=code_notebook_migration_sql&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_migration_sql&stats=yes) | [code_notebook_migration_sql (view) Schema](console/info-schema/view.sql?name=code_notebook_migration_sql&stats=yes) | /console/content/view/code_notebook_migration_sql.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_migration_sql.sql?stats=yes) | [code_notebook_migration_sql (view) Content](console/content/view/code_notebook_migration_sql.sql?stats=yes) | CREATE VIEW "code_notebook_migration_sql" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- Creates a dynamic migration script by concatenating all interpretable_code for cells that should be migrated. -- Excludes cells with names containing '_once_' if they have already been executed. -- Includes comments before each block and special comments for excluded cells. -- Wraps everything in a single transaction SELECT 'BEGIN TRANSACTION; '|| 'CREATE TEMP TABLE IF NOT EXISTS "session_state_ephemeral" ( "key" TEXT PRIMARY KEY NOT NULL, "value" TEXT NOT NULL ); ' || GROUP_CONCAT( CASE -- Case 1: Non-idempotent and already executed WHEN c.is_idempotent = FALSE AND s.code_notebook_cell_id IS NOT NULL THEN '-- ' || c.notebook_name || '.' || c.cell_name || ' not included because it is non-idempotent and was already executed on ' || s.transitioned_at || ' ' -- Case 2: Idempotent and not yet executed, idempotent and being reapplied, or non-idempotent and being run for the first time ELSE '-- ' || c.notebook_name || '.' || c.cell_name || ' ' || CASE -- First execution (non-idempotent or idempotent) WHEN s.code_notebook_cell_id IS NULL THEN '-- Executing for the first time. ' -- Reapplying execution (idempotent) ELSE '-- Reapplying execution. Last executed on ' || s.transitioned_at || ' ' END || c.interpretable_code || ' ' || 'INSERT INTO code_notebook_state (code_notebook_state_id, code_notebook_cell_id, from_state, to_state, transition_reason, created_at) ' || 'VALUES (' || '''' || c.code_notebook_cell_id || '__' || strftime('%Y%m%d%H%M%S', 'now') || '''' || ', ' || '''' || c.code_notebook_cell_id || '''' || ', ' || '''MIGRATION_CANDIDATE''' || ', ' || '''EXECUTED''' || ', ' || CASE WHEN s.code_notebook_cell_id IS NULL THEN '''Migration''' ELSE '''Reapplication''' END || ', ' || 'CURRENT_TIMESTAMP' || ')' || ' ' || 'ON CONFLICT(code_notebook_cell_id, from_state, to_state) DO UPDATE SET updated_at = CURRENT_TIMESTAMP, ' || 'transition_reason = ''Reapplied ' || datetime('now', 'localtime') || ''';' || ' ' END, ' ' ) || ' COMMIT;' AS migration_sql FROM code_notebook_sql_cell_migratable c LEFT JOIN code_notebook_state s ON c.code_notebook_cell_id = s.code_notebook_cell_id AND s.to_state = 'EXECUTED' ORDER BY c.cell_name | |
| plm_graph | graph_name | VARCHAR | /console/info-schema/view.sql?name=plm_graph&stats=yes | [Content](console/info-schema/view.sql?name=plm_graph&stats=yes) | [plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes) | /console/content/view/plm_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/plm_graph.sql?stats=yes) | [plm_graph (view) Content](console/content/view/plm_graph.sql?stats=yes) | 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' |
| plm_graph | nature | TEXT | /console/info-schema/view.sql?name=plm_graph&stats=yes | [Content](console/info-schema/view.sql?name=plm_graph&stats=yes) | [plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes) | /console/content/view/plm_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/plm_graph.sql?stats=yes) | [plm_graph (view) Content](console/content/view/plm_graph.sql?stats=yes) | 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' |
| plm_graph | uniform_resource_id | VARCHAR | /console/info-schema/view.sql?name=plm_graph&stats=yes | [Content](console/info-schema/view.sql?name=plm_graph&stats=yes) | [plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes) | /console/content/view/plm_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/plm_graph.sql?stats=yes) | [plm_graph (view) Content](console/content/view/plm_graph.sql?stats=yes) | 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' |
| plm_graph | uri | TEXT | /console/info-schema/view.sql?name=plm_graph&stats=yes | [Content](console/info-schema/view.sql?name=plm_graph&stats=yes) | [plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes) | /console/content/view/plm_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/plm_graph.sql?stats=yes) | [plm_graph (view) Content](console/content/view/plm_graph.sql?stats=yes) | 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' |
| plm_graph | ur_ingest_session_plm_acct_project_issue_id | VARCHAR | /console/info-schema/view.sql?name=plm_graph&stats=yes | [Content](console/info-schema/view.sql?name=plm_graph&stats=yes) | [plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes) | /console/content/view/plm_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/plm_graph.sql?stats=yes) | [plm_graph (view) Content](console/content/view/plm_graph.sql?stats=yes) | 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' |
| plm_graph | issue_id | TEXT | /console/info-schema/view.sql?name=plm_graph&stats=yes | [Content](console/info-schema/view.sql?name=plm_graph&stats=yes) | [plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes) | /console/content/view/plm_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/plm_graph.sql?stats=yes) | [plm_graph (view) Content](console/content/view/plm_graph.sql?stats=yes) | 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' |
| plm_graph | project_id | VARCHAR | /console/info-schema/view.sql?name=plm_graph&stats=yes | [Content](console/info-schema/view.sql?name=plm_graph&stats=yes) | [plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes) | /console/content/view/plm_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/plm_graph.sql?stats=yes) | [plm_graph (view) Content](console/content/view/plm_graph.sql?stats=yes) | 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' |
| plm_graph | title | TEXT | /console/info-schema/view.sql?name=plm_graph&stats=yes | [Content](console/info-schema/view.sql?name=plm_graph&stats=yes) | [plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes) | /console/content/view/plm_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/plm_graph.sql?stats=yes) | [plm_graph (view) Content](console/content/view/plm_graph.sql?stats=yes) | 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' |
| plm_graph | body | TEXT | /console/info-schema/view.sql?name=plm_graph&stats=yes | [Content](console/info-schema/view.sql?name=plm_graph&stats=yes) | [plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes) | /console/content/view/plm_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/plm_graph.sql?stats=yes) | [plm_graph (view) Content](console/content/view/plm_graph.sql?stats=yes) | 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' |
| imap_graph | graph_name | VARCHAR | /console/info-schema/view.sql?name=imap_graph&stats=yes | [Content](console/info-schema/view.sql?name=imap_graph&stats=yes) | [imap_graph (view) Schema](console/info-schema/view.sql?name=imap_graph&stats=yes) | /console/content/view/imap_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/imap_graph.sql?stats=yes) | [imap_graph (view) Content](console/content/view/imap_graph.sql?stats=yes) | 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' |
| imap_graph | uniform_resource_id | VARCHAR | /console/info-schema/view.sql?name=imap_graph&stats=yes | [Content](console/info-schema/view.sql?name=imap_graph&stats=yes) | [imap_graph (view) Schema](console/info-schema/view.sql?name=imap_graph&stats=yes) | /console/content/view/imap_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/imap_graph.sql?stats=yes) | [imap_graph (view) Content](console/content/view/imap_graph.sql?stats=yes) | 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' |
| imap_graph | nature | TEXT | /console/info-schema/view.sql?name=imap_graph&stats=yes | [Content](console/info-schema/view.sql?name=imap_graph&stats=yes) | [imap_graph (view) Schema](console/info-schema/view.sql?name=imap_graph&stats=yes) | /console/content/view/imap_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/imap_graph.sql?stats=yes) | [imap_graph (view) Content](console/content/view/imap_graph.sql?stats=yes) | 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' |
| imap_graph | uri | TEXT | /console/info-schema/view.sql?name=imap_graph&stats=yes | [Content](console/info-schema/view.sql?name=imap_graph&stats=yes) | [imap_graph (view) Schema](console/info-schema/view.sql?name=imap_graph&stats=yes) | /console/content/view/imap_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/imap_graph.sql?stats=yes) | [imap_graph (view) Content](console/content/view/imap_graph.sql?stats=yes) | 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' |
| imap_graph | content | BLOB | /console/info-schema/view.sql?name=imap_graph&stats=yes | [Content](console/info-schema/view.sql?name=imap_graph&stats=yes) | [imap_graph (view) Schema](console/info-schema/view.sql?name=imap_graph&stats=yes) | /console/content/view/imap_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/imap_graph.sql?stats=yes) | [imap_graph (view) Content](console/content/view/imap_graph.sql?stats=yes) | 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' |
| imap_graph | ur_ingest_session_imap_acct_folder_message_id | VARCHAR | /console/info-schema/view.sql?name=imap_graph&stats=yes | [Content](console/info-schema/view.sql?name=imap_graph&stats=yes) | [imap_graph (view) Schema](console/info-schema/view.sql?name=imap_graph&stats=yes) | /console/content/view/imap_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/imap_graph.sql?stats=yes) | [imap_graph (view) Content](console/content/view/imap_graph.sql?stats=yes) | 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' |
| imap_graph | ingest_imap_acct_folder_id | VARCHAR | /console/info-schema/view.sql?name=imap_graph&stats=yes | [Content](console/info-schema/view.sql?name=imap_graph&stats=yes) | [imap_graph (view) Schema](console/info-schema/view.sql?name=imap_graph&stats=yes) | /console/content/view/imap_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/imap_graph.sql?stats=yes) | [imap_graph (view) Content](console/content/view/imap_graph.sql?stats=yes) | 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' |
| imap_graph | message_id | TEXT | /console/info-schema/view.sql?name=imap_graph&stats=yes | [Content](console/info-schema/view.sql?name=imap_graph&stats=yes) | [imap_graph (view) Schema](console/info-schema/view.sql?name=imap_graph&stats=yes) | /console/content/view/imap_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/imap_graph.sql?stats=yes) | [imap_graph (view) Content](console/content/view/imap_graph.sql?stats=yes) | 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' |
| filesystem_graph | graph_name | VARCHAR | /console/info-schema/view.sql?name=filesystem_graph&stats=yes | [Content](console/info-schema/view.sql?name=filesystem_graph&stats=yes) | [filesystem_graph (view) Schema](console/info-schema/view.sql?name=filesystem_graph&stats=yes) | /console/content/view/filesystem_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/filesystem_graph.sql?stats=yes) | [filesystem_graph (view) Content](console/content/view/filesystem_graph.sql?stats=yes) | 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' |
| filesystem_graph | uniform_resource_id | VARCHAR | /console/info-schema/view.sql?name=filesystem_graph&stats=yes | [Content](console/info-schema/view.sql?name=filesystem_graph&stats=yes) | [filesystem_graph (view) Schema](console/info-schema/view.sql?name=filesystem_graph&stats=yes) | /console/content/view/filesystem_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/filesystem_graph.sql?stats=yes) | [filesystem_graph (view) Content](console/content/view/filesystem_graph.sql?stats=yes) | 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' |
| filesystem_graph | nature | TEXT | /console/info-schema/view.sql?name=filesystem_graph&stats=yes | [Content](console/info-schema/view.sql?name=filesystem_graph&stats=yes) | [filesystem_graph (view) Schema](console/info-schema/view.sql?name=filesystem_graph&stats=yes) | /console/content/view/filesystem_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/filesystem_graph.sql?stats=yes) | [filesystem_graph (view) Content](console/content/view/filesystem_graph.sql?stats=yes) | 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' |
| filesystem_graph | uri | TEXT | /console/info-schema/view.sql?name=filesystem_graph&stats=yes | [Content](console/info-schema/view.sql?name=filesystem_graph&stats=yes) | [filesystem_graph (view) Schema](console/info-schema/view.sql?name=filesystem_graph&stats=yes) | /console/content/view/filesystem_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/filesystem_graph.sql?stats=yes) | [filesystem_graph (view) Content](console/content/view/filesystem_graph.sql?stats=yes) | 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' |
| filesystem_graph | ur_ingest_session_fs_path_id | VARCHAR | /console/info-schema/view.sql?name=filesystem_graph&stats=yes | [Content](console/info-schema/view.sql?name=filesystem_graph&stats=yes) | [filesystem_graph (view) Schema](console/info-schema/view.sql?name=filesystem_graph&stats=yes) | /console/content/view/filesystem_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/filesystem_graph.sql?stats=yes) | [filesystem_graph (view) Content](console/content/view/filesystem_graph.sql?stats=yes) | 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' |
| filesystem_graph | root_path | TEXT | /console/info-schema/view.sql?name=filesystem_graph&stats=yes | [Content](console/info-schema/view.sql?name=filesystem_graph&stats=yes) | [filesystem_graph (view) Schema](console/info-schema/view.sql?name=filesystem_graph&stats=yes) | /console/content/view/filesystem_graph.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/filesystem_graph.sql?stats=yes) | [filesystem_graph (view) Content](console/content/view/filesystem_graph.sql?stats=yes) | 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' |
| compliance_regime_control | scf_domain | TEXT | /console/info-schema/view.sql?name=compliance_regime_control&stats=yes | [Content](console/info-schema/view.sql?name=compliance_regime_control&stats=yes) | [compliance_regime_control (view) Schema](console/info-schema/view.sql?name=compliance_regime_control&stats=yes) | /console/content/view/compliance_regime_control.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/compliance_regime_control.sql?stats=yes) | [compliance_regime_control (view) Content](console/content/view/compliance_regime_control.sql?stats=yes) | CREATE VIEW compliance_regime_control AS SELECT `SCF Domain` AS scf_domain, `SCF Control` AS scf_control, `Secure Controls Framework (SCF) Control Description` AS control_description, `SCF Control Question` AS control_question, "SCF #" AS control_code, `US HIPAA` AS control_id, 'US HIPAA' AS control_type FROM uniform_resource_scf_2024_2 WHERE `US HIPAA` !='' UNION SELECT `SCF Domain` AS scf_domain, `SCF Control` AS scf_control, `Secure Controls Framework (SCF) Control Description` AS control_description, `SCF Control Question` AS control_question, "SCF #" AS control_code, `NIST 800-171A rev 3` AS control_id, 'NIST' AS control_type FROM uniform_resource_scf_2024_2 WHERE `NIST 800-171A rev 3` !='' |
| compliance_regime_control | scf_control | TEXT | /console/info-schema/view.sql?name=compliance_regime_control&stats=yes | [Content](console/info-schema/view.sql?name=compliance_regime_control&stats=yes) | [compliance_regime_control (view) Schema](console/info-schema/view.sql?name=compliance_regime_control&stats=yes) | /console/content/view/compliance_regime_control.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/compliance_regime_control.sql?stats=yes) | [compliance_regime_control (view) Content](console/content/view/compliance_regime_control.sql?stats=yes) | CREATE VIEW compliance_regime_control AS SELECT `SCF Domain` AS scf_domain, `SCF Control` AS scf_control, `Secure Controls Framework (SCF) Control Description` AS control_description, `SCF Control Question` AS control_question, "SCF #" AS control_code, `US HIPAA` AS control_id, 'US HIPAA' AS control_type FROM uniform_resource_scf_2024_2 WHERE `US HIPAA` !='' UNION SELECT `SCF Domain` AS scf_domain, `SCF Control` AS scf_control, `Secure Controls Framework (SCF) Control Description` AS control_description, `SCF Control Question` AS control_question, "SCF #" AS control_code, `NIST 800-171A rev 3` AS control_id, 'NIST' AS control_type FROM uniform_resource_scf_2024_2 WHERE `NIST 800-171A rev 3` !='' |
| compliance_regime_control | control_description | TEXT | /console/info-schema/view.sql?name=compliance_regime_control&stats=yes | [Content](console/info-schema/view.sql?name=compliance_regime_control&stats=yes) | [compliance_regime_control (view) Schema](console/info-schema/view.sql?name=compliance_regime_control&stats=yes) | /console/content/view/compliance_regime_control.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/compliance_regime_control.sql?stats=yes) | [compliance_regime_control (view) Content](console/content/view/compliance_regime_control.sql?stats=yes) | CREATE VIEW compliance_regime_control AS SELECT `SCF Domain` AS scf_domain, `SCF Control` AS scf_control, `Secure Controls Framework (SCF) Control Description` AS control_description, `SCF Control Question` AS control_question, "SCF #" AS control_code, `US HIPAA` AS control_id, 'US HIPAA' AS control_type FROM uniform_resource_scf_2024_2 WHERE `US HIPAA` !='' UNION SELECT `SCF Domain` AS scf_domain, `SCF Control` AS scf_control, `Secure Controls Framework (SCF) Control Description` AS control_description, `SCF Control Question` AS control_question, "SCF #" AS control_code, `NIST 800-171A rev 3` AS control_id, 'NIST' AS control_type FROM uniform_resource_scf_2024_2 WHERE `NIST 800-171A rev 3` !='' |
| compliance_regime_control | control_question | TEXT | /console/info-schema/view.sql?name=compliance_regime_control&stats=yes | [Content](console/info-schema/view.sql?name=compliance_regime_control&stats=yes) | [compliance_regime_control (view) Schema](console/info-schema/view.sql?name=compliance_regime_control&stats=yes) | /console/content/view/compliance_regime_control.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/compliance_regime_control.sql?stats=yes) | [compliance_regime_control (view) Content](console/content/view/compliance_regime_control.sql?stats=yes) | CREATE VIEW compliance_regime_control AS SELECT `SCF Domain` AS scf_domain, `SCF Control` AS scf_control, `Secure Controls Framework (SCF) Control Description` AS control_description, `SCF Control Question` AS control_question, "SCF #" AS control_code, `US HIPAA` AS control_id, 'US HIPAA' AS control_type FROM uniform_resource_scf_2024_2 WHERE `US HIPAA` !='' UNION SELECT `SCF Domain` AS scf_domain, `SCF Control` AS scf_control, `Secure Controls Framework (SCF) Control Description` AS control_description, `SCF Control Question` AS control_question, "SCF #" AS control_code, `NIST 800-171A rev 3` AS control_id, 'NIST' AS control_type FROM uniform_resource_scf_2024_2 WHERE `NIST 800-171A rev 3` !='' |
| compliance_regime_control | control_code | TEXT | /console/info-schema/view.sql?name=compliance_regime_control&stats=yes | [Content](console/info-schema/view.sql?name=compliance_regime_control&stats=yes) | [compliance_regime_control (view) Schema](console/info-schema/view.sql?name=compliance_regime_control&stats=yes) | /console/content/view/compliance_regime_control.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/compliance_regime_control.sql?stats=yes) | [compliance_regime_control (view) Content](console/content/view/compliance_regime_control.sql?stats=yes) | CREATE VIEW compliance_regime_control AS SELECT `SCF Domain` AS scf_domain, `SCF Control` AS scf_control, `Secure Controls Framework (SCF) Control Description` AS control_description, `SCF Control Question` AS control_question, "SCF #" AS control_code, `US HIPAA` AS control_id, 'US HIPAA' AS control_type FROM uniform_resource_scf_2024_2 WHERE `US HIPAA` !='' UNION SELECT `SCF Domain` AS scf_domain, `SCF Control` AS scf_control, `Secure Controls Framework (SCF) Control Description` AS control_description, `SCF Control Question` AS control_question, "SCF #" AS control_code, `NIST 800-171A rev 3` AS control_id, 'NIST' AS control_type FROM uniform_resource_scf_2024_2 WHERE `NIST 800-171A rev 3` !='' |
| compliance_regime_control | control_id | TEXT | /console/info-schema/view.sql?name=compliance_regime_control&stats=yes | [Content](console/info-schema/view.sql?name=compliance_regime_control&stats=yes) | [compliance_regime_control (view) Schema](console/info-schema/view.sql?name=compliance_regime_control&stats=yes) | /console/content/view/compliance_regime_control.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/compliance_regime_control.sql?stats=yes) | [compliance_regime_control (view) Content](console/content/view/compliance_regime_control.sql?stats=yes) | CREATE VIEW compliance_regime_control AS SELECT `SCF Domain` AS scf_domain, `SCF Control` AS scf_control, `Secure Controls Framework (SCF) Control Description` AS control_description, `SCF Control Question` AS control_question, "SCF #" AS control_code, `US HIPAA` AS control_id, 'US HIPAA' AS control_type FROM uniform_resource_scf_2024_2 WHERE `US HIPAA` !='' UNION SELECT `SCF Domain` AS scf_domain, `SCF Control` AS scf_control, `Secure Controls Framework (SCF) Control Description` AS control_description, `SCF Control Question` AS control_question, "SCF #" AS control_code, `NIST 800-171A rev 3` AS control_id, 'NIST' AS control_type FROM uniform_resource_scf_2024_2 WHERE `NIST 800-171A rev 3` !='' |
| compliance_regime_control | control_type | /console/info-schema/view.sql?name=compliance_regime_control&stats=yes | [Content](console/info-schema/view.sql?name=compliance_regime_control&stats=yes) | [compliance_regime_control (view) Schema](console/info-schema/view.sql?name=compliance_regime_control&stats=yes) | /console/content/view/compliance_regime_control.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/compliance_regime_control.sql?stats=yes) | [compliance_regime_control (view) Content](console/content/view/compliance_regime_control.sql?stats=yes) | CREATE VIEW compliance_regime_control AS SELECT `SCF Domain` AS scf_domain, `SCF Control` AS scf_control, `Secure Controls Framework (SCF) Control Description` AS control_description, `SCF Control Question` AS control_question, "SCF #" AS control_code, `US HIPAA` AS control_id, 'US HIPAA' AS control_type FROM uniform_resource_scf_2024_2 WHERE `US HIPAA` !='' UNION SELECT `SCF Domain` AS scf_domain, `SCF Control` AS scf_control, `Secure Controls Framework (SCF) Control Description` AS control_description, `SCF Control Question` AS control_question, "SCF #" AS control_code, `NIST 800-171A rev 3` AS control_id, 'NIST' AS control_type FROM uniform_resource_scf_2024_2 WHERE `NIST 800-171A rev 3` !='' | |
| uniform_resource_file | uniform_resource_id | VARCHAR | /console/info-schema/view.sql?name=uniform_resource_file&stats=yes | [Content](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) | [uniform_resource_file (view) Schema](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) | /console/content/view/uniform_resource_file.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_file.sql?stats=yes) | [uniform_resource_file (view) Content](console/content/view/uniform_resource_file.sql?stats=yes) | CREATE VIEW uniform_resource_file AS SELECT ur.uniform_resource_id, ur.nature, p.root_path AS source_path, pe.file_path_rel, ur.size_bytes FROM uniform_resource ur LEFT JOIN uniform_resource_edge ure ON ur.uniform_resource_id = ure.uniform_resource_id AND ure.nature = 'ingest_fs_path' LEFT JOIN ur_ingest_session_fs_path p ON ure.node_id = p.ur_ingest_session_fs_path_id LEFT JOIN ur_ingest_session_fs_path_entry pe ON ur.uniform_resource_id = pe.uniform_resource_id |
| uniform_resource_file | nature | TEXT | /console/info-schema/view.sql?name=uniform_resource_file&stats=yes | [Content](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) | [uniform_resource_file (view) Schema](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) | /console/content/view/uniform_resource_file.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_file.sql?stats=yes) | [uniform_resource_file (view) Content](console/content/view/uniform_resource_file.sql?stats=yes) | CREATE VIEW uniform_resource_file AS SELECT ur.uniform_resource_id, ur.nature, p.root_path AS source_path, pe.file_path_rel, ur.size_bytes FROM uniform_resource ur LEFT JOIN uniform_resource_edge ure ON ur.uniform_resource_id = ure.uniform_resource_id AND ure.nature = 'ingest_fs_path' LEFT JOIN ur_ingest_session_fs_path p ON ure.node_id = p.ur_ingest_session_fs_path_id LEFT JOIN ur_ingest_session_fs_path_entry pe ON ur.uniform_resource_id = pe.uniform_resource_id |
| uniform_resource_file | source_path | TEXT | /console/info-schema/view.sql?name=uniform_resource_file&stats=yes | [Content](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) | [uniform_resource_file (view) Schema](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) | /console/content/view/uniform_resource_file.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_file.sql?stats=yes) | [uniform_resource_file (view) Content](console/content/view/uniform_resource_file.sql?stats=yes) | CREATE VIEW uniform_resource_file AS SELECT ur.uniform_resource_id, ur.nature, p.root_path AS source_path, pe.file_path_rel, ur.size_bytes FROM uniform_resource ur LEFT JOIN uniform_resource_edge ure ON ur.uniform_resource_id = ure.uniform_resource_id AND ure.nature = 'ingest_fs_path' LEFT JOIN ur_ingest_session_fs_path p ON ure.node_id = p.ur_ingest_session_fs_path_id LEFT JOIN ur_ingest_session_fs_path_entry pe ON ur.uniform_resource_id = pe.uniform_resource_id |
| uniform_resource_file | file_path_rel | TEXT | /console/info-schema/view.sql?name=uniform_resource_file&stats=yes | [Content](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) | [uniform_resource_file (view) Schema](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) | /console/content/view/uniform_resource_file.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_file.sql?stats=yes) | [uniform_resource_file (view) Content](console/content/view/uniform_resource_file.sql?stats=yes) | CREATE VIEW uniform_resource_file AS SELECT ur.uniform_resource_id, ur.nature, p.root_path AS source_path, pe.file_path_rel, ur.size_bytes FROM uniform_resource ur LEFT JOIN uniform_resource_edge ure ON ur.uniform_resource_id = ure.uniform_resource_id AND ure.nature = 'ingest_fs_path' LEFT JOIN ur_ingest_session_fs_path p ON ure.node_id = p.ur_ingest_session_fs_path_id LEFT JOIN ur_ingest_session_fs_path_entry pe ON ur.uniform_resource_id = pe.uniform_resource_id |
| uniform_resource_file | size_bytes | INTEGER | /console/info-schema/view.sql?name=uniform_resource_file&stats=yes | [Content](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) | [uniform_resource_file (view) Schema](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) | /console/content/view/uniform_resource_file.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_file.sql?stats=yes) | [uniform_resource_file (view) Content](console/content/view/uniform_resource_file.sql?stats=yes) | CREATE VIEW uniform_resource_file AS SELECT ur.uniform_resource_id, ur.nature, p.root_path AS source_path, pe.file_path_rel, ur.size_bytes FROM uniform_resource ur LEFT JOIN uniform_resource_edge ure ON ur.uniform_resource_id = ure.uniform_resource_id AND ure.nature = 'ingest_fs_path' LEFT JOIN ur_ingest_session_fs_path p ON ure.node_id = p.ur_ingest_session_fs_path_id LEFT JOIN ur_ingest_session_fs_path_entry pe ON ur.uniform_resource_id = pe.uniform_resource_id |
Error We are sorry, but an error occurred while generating this page. You should contact the site's administrator.
Error in query number 6:
Parsing failed: SQLPage couldn't understand the SQL file. Please check for syntax errors:
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE ' END) || ' ' ||
⬆️
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
Backtrace
sql parser error: Expected: ), found: $current_page at Line: 42, Column: 35"console/content/view/console_information_schema_view.auto.sql" contains a syntax error preventing SQLPage from parsing and preparing its SQL statements.You can hide error messages like this one from your users by setting the 'environment' configuration option to 'production'.