| 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' |
| linkedin_profile |
f_name |
TEXT |
/console/info-schema/view.sql?name=linkedin_profile&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_profile&stats=yes) |
[linkedin_profile (view) Schema](console/info-schema/view.sql?name=linkedin_profile&stats=yes) |
/console/content/view/linkedin_profile.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_profile.sql?stats=yes) |
[linkedin_profile (view) Content](console/content/view/linkedin_profile.sql?stats=yes) |
CREATE VIEW linkedin_profile AS
SELECT
p.'First Name' as f_name,
p.'Last Name' as l_name,
p.'First Name' || ' ' || p.'Last Name' as full_name,
p.Address as address,
p.'Birth Date' as birth_date
FROM uniform_resource_profile p |
| linkedin_profile |
l_name |
TEXT |
/console/info-schema/view.sql?name=linkedin_profile&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_profile&stats=yes) |
[linkedin_profile (view) Schema](console/info-schema/view.sql?name=linkedin_profile&stats=yes) |
/console/content/view/linkedin_profile.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_profile.sql?stats=yes) |
[linkedin_profile (view) Content](console/content/view/linkedin_profile.sql?stats=yes) |
CREATE VIEW linkedin_profile AS
SELECT
p.'First Name' as f_name,
p.'Last Name' as l_name,
p.'First Name' || ' ' || p.'Last Name' as full_name,
p.Address as address,
p.'Birth Date' as birth_date
FROM uniform_resource_profile p |
| linkedin_profile |
full_name |
|
/console/info-schema/view.sql?name=linkedin_profile&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_profile&stats=yes) |
[linkedin_profile (view) Schema](console/info-schema/view.sql?name=linkedin_profile&stats=yes) |
/console/content/view/linkedin_profile.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_profile.sql?stats=yes) |
[linkedin_profile (view) Content](console/content/view/linkedin_profile.sql?stats=yes) |
CREATE VIEW linkedin_profile AS
SELECT
p.'First Name' as f_name,
p.'Last Name' as l_name,
p.'First Name' || ' ' || p.'Last Name' as full_name,
p.Address as address,
p.'Birth Date' as birth_date
FROM uniform_resource_profile p |
| linkedin_profile |
address |
TEXT |
/console/info-schema/view.sql?name=linkedin_profile&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_profile&stats=yes) |
[linkedin_profile (view) Schema](console/info-schema/view.sql?name=linkedin_profile&stats=yes) |
/console/content/view/linkedin_profile.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_profile.sql?stats=yes) |
[linkedin_profile (view) Content](console/content/view/linkedin_profile.sql?stats=yes) |
CREATE VIEW linkedin_profile AS
SELECT
p.'First Name' as f_name,
p.'Last Name' as l_name,
p.'First Name' || ' ' || p.'Last Name' as full_name,
p.Address as address,
p.'Birth Date' as birth_date
FROM uniform_resource_profile p |
| linkedin_profile |
birth_date |
TEXT |
/console/info-schema/view.sql?name=linkedin_profile&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_profile&stats=yes) |
[linkedin_profile (view) Schema](console/info-schema/view.sql?name=linkedin_profile&stats=yes) |
/console/content/view/linkedin_profile.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_profile.sql?stats=yes) |
[linkedin_profile (view) Content](console/content/view/linkedin_profile.sql?stats=yes) |
CREATE VIEW linkedin_profile AS
SELECT
p.'First Name' as f_name,
p.'Last Name' as l_name,
p.'First Name' || ' ' || p.'Last Name' as full_name,
p.Address as address,
p.'Birth Date' as birth_date
FROM uniform_resource_profile p |
| linkedin_profile_education |
School Name |
TEXT |
/console/info-schema/view.sql?name=linkedin_profile_education&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_profile_education&stats=yes) |
[linkedin_profile_education (view) Schema](console/info-schema/view.sql?name=linkedin_profile_education&stats=yes) |
/console/content/view/linkedin_profile_education.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_profile_education.sql?stats=yes) |
[linkedin_profile_education (view) Content](console/content/view/linkedin_profile_education.sql?stats=yes) |
CREATE VIEW linkedin_profile_education AS
SELECT
"School Name",
"Start Date",
"End Date",
"Notes",
"Degree Name",
"Activities"
FROM uniform_resource_education |
| linkedin_profile_education |
Start Date |
TEXT |
/console/info-schema/view.sql?name=linkedin_profile_education&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_profile_education&stats=yes) |
[linkedin_profile_education (view) Schema](console/info-schema/view.sql?name=linkedin_profile_education&stats=yes) |
/console/content/view/linkedin_profile_education.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_profile_education.sql?stats=yes) |
[linkedin_profile_education (view) Content](console/content/view/linkedin_profile_education.sql?stats=yes) |
CREATE VIEW linkedin_profile_education AS
SELECT
"School Name",
"Start Date",
"End Date",
"Notes",
"Degree Name",
"Activities"
FROM uniform_resource_education |
| linkedin_profile_education |
End Date |
TEXT |
/console/info-schema/view.sql?name=linkedin_profile_education&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_profile_education&stats=yes) |
[linkedin_profile_education (view) Schema](console/info-schema/view.sql?name=linkedin_profile_education&stats=yes) |
/console/content/view/linkedin_profile_education.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_profile_education.sql?stats=yes) |
[linkedin_profile_education (view) Content](console/content/view/linkedin_profile_education.sql?stats=yes) |
CREATE VIEW linkedin_profile_education AS
SELECT
"School Name",
"Start Date",
"End Date",
"Notes",
"Degree Name",
"Activities"
FROM uniform_resource_education |
| linkedin_profile_education |
Notes |
TEXT |
/console/info-schema/view.sql?name=linkedin_profile_education&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_profile_education&stats=yes) |
[linkedin_profile_education (view) Schema](console/info-schema/view.sql?name=linkedin_profile_education&stats=yes) |
/console/content/view/linkedin_profile_education.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_profile_education.sql?stats=yes) |
[linkedin_profile_education (view) Content](console/content/view/linkedin_profile_education.sql?stats=yes) |
CREATE VIEW linkedin_profile_education AS
SELECT
"School Name",
"Start Date",
"End Date",
"Notes",
"Degree Name",
"Activities"
FROM uniform_resource_education |
| linkedin_profile_education |
Degree Name |
TEXT |
/console/info-schema/view.sql?name=linkedin_profile_education&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_profile_education&stats=yes) |
[linkedin_profile_education (view) Schema](console/info-schema/view.sql?name=linkedin_profile_education&stats=yes) |
/console/content/view/linkedin_profile_education.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_profile_education.sql?stats=yes) |
[linkedin_profile_education (view) Content](console/content/view/linkedin_profile_education.sql?stats=yes) |
CREATE VIEW linkedin_profile_education AS
SELECT
"School Name",
"Start Date",
"End Date",
"Notes",
"Degree Name",
"Activities"
FROM uniform_resource_education |
| linkedin_profile_education |
Activities |
TEXT |
/console/info-schema/view.sql?name=linkedin_profile_education&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_profile_education&stats=yes) |
[linkedin_profile_education (view) Schema](console/info-schema/view.sql?name=linkedin_profile_education&stats=yes) |
/console/content/view/linkedin_profile_education.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_profile_education.sql?stats=yes) |
[linkedin_profile_education (view) Content](console/content/view/linkedin_profile_education.sql?stats=yes) |
CREATE VIEW linkedin_profile_education AS
SELECT
"School Name",
"Start Date",
"End Date",
"Notes",
"Degree Name",
"Activities"
FROM uniform_resource_education |
| linkedin_connection_overview |
first_name |
TEXT |
/console/info-schema/view.sql?name=linkedin_connection_overview&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_connection_overview&stats=yes) |
[linkedin_connection_overview (view) Schema](console/info-schema/view.sql?name=linkedin_connection_overview&stats=yes) |
/console/content/view/linkedin_connection_overview.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_connection_overview.sql?stats=yes) |
[linkedin_connection_overview (view) Content](console/content/view/linkedin_connection_overview.sql?stats=yes) |
CREATE VIEW linkedin_connection_overview AS
SELECT
c."First Name" AS first_name,
c."Last Name" AS last_name,
c."Email Address" AS email,
c."Company" AS company,
c."Position" AS position,
c."Connected On" AS connection_date
FROM uniform_resource_connections c |