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' |
| expected_schema_view | table_name | /console/info-schema/view.sql?name=expected_schema_view&stats=yes | [Content](console/info-schema/view.sql?name=expected_schema_view&stats=yes) | [expected_schema_view (view) Schema](console/info-schema/view.sql?name=expected_schema_view&stats=yes) | /console/content/view/expected_schema_view.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/expected_schema_view.sql?stats=yes) | [expected_schema_view (view) Content](console/content/view/expected_schema_view.sql?stats=yes) | CREATE VIEW expected_schema_view AS SELECT 'uniform_resource_institution' AS table_name, 'institution_id' AS column_name, 'TEXT' AS column_type, 1 AS is_primary_key, 1 AS not_null UNION ALL SELECT 'uniform_resource_institution', 'institution_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'city', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'state', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'country', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'lab_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_lab', 'lab_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'lab_pi', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'institution_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'study_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_study', 'study_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'start_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'end_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'treatment_modalities', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'funding_source', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'nct_number', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'study_description', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'participant_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_participant', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'site_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'diagnosis_icd', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'med_rxnorm', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'treatment_modality', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_participant', 'gender', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'race_ethnicity', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_participant', 'age', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'bmi', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'baseline_hba1c', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'diabetes_type', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'study_arm', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'site_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_site', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'site_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'site_type', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'investigator_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_investigator', 'investigator_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'email', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'institution_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_publication', 'publication_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_publication', 'publication_title', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_publication', 'digital_object_identifier', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_publication', 'publication_site', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_publication', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_publication', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'author_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_author', 'name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'email', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'investigator_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'metadata_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'devicename', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'device_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'source_platform', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'patient_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'file_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'file_format', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'file_upload_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'data_start_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'data_end_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'tenant_id', 'TEXT', 0, 1 | |
| expected_schema_view | column_name | /console/info-schema/view.sql?name=expected_schema_view&stats=yes | [Content](console/info-schema/view.sql?name=expected_schema_view&stats=yes) | [expected_schema_view (view) Schema](console/info-schema/view.sql?name=expected_schema_view&stats=yes) | /console/content/view/expected_schema_view.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/expected_schema_view.sql?stats=yes) | [expected_schema_view (view) Content](console/content/view/expected_schema_view.sql?stats=yes) | CREATE VIEW expected_schema_view AS SELECT 'uniform_resource_institution' AS table_name, 'institution_id' AS column_name, 'TEXT' AS column_type, 1 AS is_primary_key, 1 AS not_null UNION ALL SELECT 'uniform_resource_institution', 'institution_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'city', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'state', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'country', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'lab_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_lab', 'lab_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'lab_pi', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'institution_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'study_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_study', 'study_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'start_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'end_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'treatment_modalities', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'funding_source', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'nct_number', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'study_description', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'participant_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_participant', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'site_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'diagnosis_icd', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'med_rxnorm', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'treatment_modality', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_participant', 'gender', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'race_ethnicity', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_participant', 'age', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'bmi', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'baseline_hba1c', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'diabetes_type', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'study_arm', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'site_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_site', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'site_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'site_type', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'investigator_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_investigator', 'investigator_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'email', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'institution_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_publication', 'publication_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_publication', 'publication_title', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_publication', 'digital_object_identifier', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_publication', 'publication_site', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_publication', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_publication', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'author_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_author', 'name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'email', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'investigator_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'metadata_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'devicename', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'device_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'source_platform', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'patient_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'file_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'file_format', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'file_upload_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'data_start_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'data_end_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'tenant_id', 'TEXT', 0, 1 | |
| expected_schema_view | column_type | /console/info-schema/view.sql?name=expected_schema_view&stats=yes | [Content](console/info-schema/view.sql?name=expected_schema_view&stats=yes) | [expected_schema_view (view) Schema](console/info-schema/view.sql?name=expected_schema_view&stats=yes) | /console/content/view/expected_schema_view.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/expected_schema_view.sql?stats=yes) | [expected_schema_view (view) Content](console/content/view/expected_schema_view.sql?stats=yes) | CREATE VIEW expected_schema_view AS SELECT 'uniform_resource_institution' AS table_name, 'institution_id' AS column_name, 'TEXT' AS column_type, 1 AS is_primary_key, 1 AS not_null UNION ALL SELECT 'uniform_resource_institution', 'institution_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'city', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'state', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'country', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'lab_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_lab', 'lab_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'lab_pi', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'institution_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'study_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_study', 'study_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'start_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'end_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'treatment_modalities', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'funding_source', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'nct_number', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'study_description', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'participant_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_participant', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'site_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'diagnosis_icd', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'med_rxnorm', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'treatment_modality', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_participant', 'gender', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'race_ethnicity', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_participant', 'age', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'bmi', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'baseline_hba1c', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'diabetes_type', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'study_arm', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'site_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_site', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'site_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'site_type', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'investigator_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_investigator', 'investigator_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'email', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'institution_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_publication', 'publication_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_publication', 'publication_title', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_publication', 'digital_object_identifier', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_publication', 'publication_site', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_publication', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_publication', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'author_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_author', 'name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'email', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'investigator_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'metadata_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'devicename', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'device_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'source_platform', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'patient_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'file_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'file_format', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'file_upload_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'data_start_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'data_end_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'tenant_id', 'TEXT', 0, 1 | |
| expected_schema_view | is_primary_key | /console/info-schema/view.sql?name=expected_schema_view&stats=yes | [Content](console/info-schema/view.sql?name=expected_schema_view&stats=yes) | [expected_schema_view (view) Schema](console/info-schema/view.sql?name=expected_schema_view&stats=yes) | /console/content/view/expected_schema_view.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/expected_schema_view.sql?stats=yes) | [expected_schema_view (view) Content](console/content/view/expected_schema_view.sql?stats=yes) | CREATE VIEW expected_schema_view AS SELECT 'uniform_resource_institution' AS table_name, 'institution_id' AS column_name, 'TEXT' AS column_type, 1 AS is_primary_key, 1 AS not_null UNION ALL SELECT 'uniform_resource_institution', 'institution_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'city', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'state', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'country', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'lab_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_lab', 'lab_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'lab_pi', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'institution_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'study_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_study', 'study_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'start_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'end_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'treatment_modalities', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'funding_source', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'nct_number', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'study_description', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'participant_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_participant', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'site_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'diagnosis_icd', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'med_rxnorm', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'treatment_modality', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_participant', 'gender', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'race_ethnicity', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_participant', 'age', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'bmi', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'baseline_hba1c', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'diabetes_type', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'study_arm', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'site_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_site', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'site_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'site_type', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'investigator_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_investigator', 'investigator_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'email', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'institution_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_publication', 'publication_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_publication', 'publication_title', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_publication', 'digital_object_identifier', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_publication', 'publication_site', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_publication', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_publication', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'author_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_author', 'name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'email', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'investigator_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'metadata_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'devicename', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'device_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'source_platform', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'patient_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'file_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'file_format', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'file_upload_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'data_start_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'data_end_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'tenant_id', 'TEXT', 0, 1 | |
| expected_schema_view | not_null | /console/info-schema/view.sql?name=expected_schema_view&stats=yes | [Content](console/info-schema/view.sql?name=expected_schema_view&stats=yes) | [expected_schema_view (view) Schema](console/info-schema/view.sql?name=expected_schema_view&stats=yes) | /console/content/view/expected_schema_view.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/expected_schema_view.sql?stats=yes) | [expected_schema_view (view) Content](console/content/view/expected_schema_view.sql?stats=yes) | CREATE VIEW expected_schema_view AS SELECT 'uniform_resource_institution' AS table_name, 'institution_id' AS column_name, 'TEXT' AS column_type, 1 AS is_primary_key, 1 AS not_null UNION ALL SELECT 'uniform_resource_institution', 'institution_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'city', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'state', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'country', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_institution', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'lab_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_lab', 'lab_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'lab_pi', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'institution_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_lab', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'study_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_study', 'study_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'start_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'end_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'treatment_modalities', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'funding_source', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'nct_number', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'study_description', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_study', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'participant_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_participant', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'site_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'diagnosis_icd', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'med_rxnorm', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'treatment_modality', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_participant', 'gender', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'race_ethnicity', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_participant', 'age', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'bmi', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'baseline_hba1c', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'diabetes_type', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'study_arm', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_participant', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'site_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_site', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'site_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'site_type', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_site', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'investigator_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_investigator', 'investigator_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'email', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'institution_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_investigator', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_publication', 'publication_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_publication', 'publication_title', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_publication', 'digital_object_identifier', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_publication', 'publication_site', 'TEXT', 0, 0 UNION ALL SELECT 'uniform_resource_publication', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_publication', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'author_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_author', 'name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'email', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'investigator_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_author', 'tenant_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'metadata_id', 'TEXT', 1, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'devicename', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'device_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'source_platform', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'patient_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'file_name', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'file_format', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'file_upload_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'data_start_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'data_end_date', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'study_id', 'TEXT', 0, 1 UNION ALL SELECT 'uniform_resource_cgm_file_metadata', 'tenant_id', 'TEXT', 0, 1 | |
| drh_device | tenant_id | VARCHAR | /console/info-schema/view.sql?name=drh_device&stats=yes | [Content](console/info-schema/view.sql?name=drh_device&stats=yes) | [drh_device (view) Schema](console/info-schema/view.sql?name=drh_device&stats=yes) | /console/content/view/drh_device.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/drh_device.sql?stats=yes) | [drh_device (view) Content](console/content/view/drh_device.sql?stats=yes) | CREATE VIEW drh_device AS SELECT ( select party_id from party limit 1 ) as tenant_id, (select study_id from uniform_resource_study limit 1 ) as study_id, device_id, name, created_at FROM device d |
| drh_device | study_id | TEXT | /console/info-schema/view.sql?name=drh_device&stats=yes | [Content](console/info-schema/view.sql?name=drh_device&stats=yes) | [drh_device (view) Schema](console/info-schema/view.sql?name=drh_device&stats=yes) | /console/content/view/drh_device.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/drh_device.sql?stats=yes) | [drh_device (view) Content](console/content/view/drh_device.sql?stats=yes) | CREATE VIEW drh_device AS SELECT ( select party_id from party limit 1 ) as tenant_id, (select study_id from uniform_resource_study limit 1 ) as study_id, device_id, name, created_at FROM device d |
| drh_device | device_id | VARCHAR | /console/info-schema/view.sql?name=drh_device&stats=yes | [Content](console/info-schema/view.sql?name=drh_device&stats=yes) | [drh_device (view) Schema](console/info-schema/view.sql?name=drh_device&stats=yes) | /console/content/view/drh_device.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/drh_device.sql?stats=yes) | [drh_device (view) Content](console/content/view/drh_device.sql?stats=yes) | CREATE VIEW drh_device AS SELECT ( select party_id from party limit 1 ) as tenant_id, (select study_id from uniform_resource_study limit 1 ) as study_id, device_id, name, created_at FROM device d |
| drh_device | name | TEXT | /console/info-schema/view.sql?name=drh_device&stats=yes | [Content](console/info-schema/view.sql?name=drh_device&stats=yes) | [drh_device (view) Schema](console/info-schema/view.sql?name=drh_device&stats=yes) | /console/content/view/drh_device.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/drh_device.sql?stats=yes) | [drh_device (view) Content](console/content/view/drh_device.sql?stats=yes) | CREATE VIEW drh_device AS SELECT ( select party_id from party limit 1 ) as tenant_id, (select study_id from uniform_resource_study limit 1 ) as study_id, device_id, name, created_at FROM device d |
| drh_device | created_at | TIMESTAMPTZ | /console/info-schema/view.sql?name=drh_device&stats=yes | [Content](console/info-schema/view.sql?name=drh_device&stats=yes) | [drh_device (view) Schema](console/info-schema/view.sql?name=drh_device&stats=yes) | /console/content/view/drh_device.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/drh_device.sql?stats=yes) | [drh_device (view) Content](console/content/view/drh_device.sql?stats=yes) | CREATE VIEW drh_device AS SELECT ( select party_id from party limit 1 ) as tenant_id, (select study_id from uniform_resource_study limit 1 ) as study_id, device_id, name, created_at FROM device d |
| drh_number_of_files_converted | file_count | /console/info-schema/view.sql?name=drh_number_of_files_converted&stats=yes | [Content](console/info-schema/view.sql?name=drh_number_of_files_converted&stats=yes) | [drh_number_of_files_converted (view) Schema](console/info-schema/view.sql?name=drh_number_of_files_converted&stats=yes) | /console/content/view/drh_number_of_files_converted.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/drh_number_of_files_converted.sql?stats=yes) | [drh_number_of_files_converted (view) Content](console/content/view/drh_number_of_files_converted.sql?stats=yes) | CREATE VIEW drh_number_of_files_converted AS SELECT COUNT(*) AS file_count FROM uniform_resource WHERE content_digest != '-' | |
| drh_converted_files_list | file_basename | TEXT | /console/info-schema/view.sql?name=drh_converted_files_list&stats=yes | [Content](console/info-schema/view.sql?name=drh_converted_files_list&stats=yes) | [drh_converted_files_list (view) Schema](console/info-schema/view.sql?name=drh_converted_files_list&stats=yes) | /console/content/view/drh_converted_files_list.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/drh_converted_files_list.sql?stats=yes) | [drh_converted_files_list (view) Content](console/content/view/drh_converted_files_list.sql?stats=yes) | CREATE VIEW drh_converted_files_list AS SELECT file_basename FROM ur_ingest_session_fs_path_entry WHERE file_extn IN ('csv', 'xls', 'xlsx', 'json','html') |
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: END, found: ' ||
' at Line: 42, Column: 149"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'.