| 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' |
| console_information_schema_table |
table_name |
TEXT |
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
column_name |
BLOB |
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
data_type |
BLOB |
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
is_primary_key |
|
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
is_not_null |
|
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
default_value |
BLOB |
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
info_schema_web_ui_path |
|
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
info_schema_link_abbrev_md |
|
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
info_schema_link_full_md |
|
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
content_web_ui_path |
|
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
content_web_ui_link_abbrev_md |
|
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
content_web_ui_link_full_md |
|
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |