console_information_schema_view (view) Content
- Start Row: 0
- Rows per Page: 50
- Total Rows: 497
- Current Page: 1
- Total Pages: 10
| code_notebook_cell_versions | notebook_name | TEXT | /console/info-schema/view.sql?name=code_notebook_cell_versions&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_cell_versions&stats=yes) | [code_notebook_cell_versions (view) Schema](console/info-schema/view.sql?name=code_notebook_cell_versions&stats=yes) | /console/content/view/code_notebook_cell_versions.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_cell_versions.sql?stats=yes) | [code_notebook_cell_versions (view) Content](console/content/view/code_notebook_cell_versions.sql?stats=yes) | CREATE VIEW "code_notebook_cell_versions" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All cells and how many different versions of each cell are available SELECT notebook_name, notebook_kernel_id, cell_name, COUNT(*) OVER(PARTITION BY notebook_name, cell_name) AS versions, code_notebook_cell_id FROM code_notebook_cell ORDER BY notebook_name, cell_name |
| code_notebook_cell_versions | notebook_kernel_id | VARCHAR | /console/info-schema/view.sql?name=code_notebook_cell_versions&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_cell_versions&stats=yes) | [code_notebook_cell_versions (view) Schema](console/info-schema/view.sql?name=code_notebook_cell_versions&stats=yes) | /console/content/view/code_notebook_cell_versions.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_cell_versions.sql?stats=yes) | [code_notebook_cell_versions (view) Content](console/content/view/code_notebook_cell_versions.sql?stats=yes) | CREATE VIEW "code_notebook_cell_versions" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All cells and how many different versions of each cell are available SELECT notebook_name, notebook_kernel_id, cell_name, COUNT(*) OVER(PARTITION BY notebook_name, cell_name) AS versions, code_notebook_cell_id FROM code_notebook_cell ORDER BY notebook_name, cell_name |
| code_notebook_cell_versions | cell_name | TEXT | /console/info-schema/view.sql?name=code_notebook_cell_versions&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_cell_versions&stats=yes) | [code_notebook_cell_versions (view) Schema](console/info-schema/view.sql?name=code_notebook_cell_versions&stats=yes) | /console/content/view/code_notebook_cell_versions.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_cell_versions.sql?stats=yes) | [code_notebook_cell_versions (view) Content](console/content/view/code_notebook_cell_versions.sql?stats=yes) | CREATE VIEW "code_notebook_cell_versions" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All cells and how many different versions of each cell are available SELECT notebook_name, notebook_kernel_id, cell_name, COUNT(*) OVER(PARTITION BY notebook_name, cell_name) AS versions, code_notebook_cell_id FROM code_notebook_cell ORDER BY notebook_name, cell_name |
| code_notebook_cell_versions | versions | /console/info-schema/view.sql?name=code_notebook_cell_versions&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_cell_versions&stats=yes) | [code_notebook_cell_versions (view) Schema](console/info-schema/view.sql?name=code_notebook_cell_versions&stats=yes) | /console/content/view/code_notebook_cell_versions.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_cell_versions.sql?stats=yes) | [code_notebook_cell_versions (view) Content](console/content/view/code_notebook_cell_versions.sql?stats=yes) | CREATE VIEW "code_notebook_cell_versions" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All cells and how many different versions of each cell are available SELECT notebook_name, notebook_kernel_id, cell_name, COUNT(*) OVER(PARTITION BY notebook_name, cell_name) AS versions, code_notebook_cell_id FROM code_notebook_cell ORDER BY notebook_name, cell_name | |
| code_notebook_cell_versions | code_notebook_cell_id | VARCHAR | /console/info-schema/view.sql?name=code_notebook_cell_versions&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_cell_versions&stats=yes) | [code_notebook_cell_versions (view) Schema](console/info-schema/view.sql?name=code_notebook_cell_versions&stats=yes) | /console/content/view/code_notebook_cell_versions.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_cell_versions.sql?stats=yes) | [code_notebook_cell_versions (view) Content](console/content/view/code_notebook_cell_versions.sql?stats=yes) | CREATE VIEW "code_notebook_cell_versions" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All cells and how many different versions of each cell are available SELECT notebook_name, notebook_kernel_id, cell_name, COUNT(*) OVER(PARTITION BY notebook_name, cell_name) AS versions, code_notebook_cell_id FROM code_notebook_cell ORDER BY notebook_name, cell_name |
| code_notebook_cell_latest | code_notebook_cell_id | VARCHAR | /console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | [code_notebook_cell_latest (view) Schema](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | /console/content/view/code_notebook_cell_latest.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_cell_latest.sql?stats=yes) | [code_notebook_cell_latest (view) Content](console/content/view/code_notebook_cell_latest.sql?stats=yes) | CREATE VIEW "code_notebook_cell_latest" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- Retrieve the latest version of each code_notebook_cell. -- Notebooks can have multiple versions of cells, where the interpretable_code and other metadata may be updated over time. -- The latest record is determined by the most recent COALESCE(updated_at, created_at) timestamp. SELECT c.code_notebook_cell_id, -- Selects the unique ID of the notebook cell c.notebook_kernel_id, -- References the kernel associated with this cell c.notebook_name, -- The name of the notebook containing this cell c.cell_name, -- The name of the cell within the notebook c.interpretable_code, -- The latest interpretable code associated with the cell c.interpretable_code_hash, -- Hash of the latest interpretable code c.description, -- Description of the cell's purpose or content c.cell_governance, -- Governance details for the cell (if any) c.arguments, -- Arguments or parameters related to the cell's execution c.activity_log, -- Log of activities related to this cell COALESCE(c.updated_at, c.created_at) AS version_timestamp -- The latest timestamp (updated or created) FROM ( SELECT code_notebook_cell_id, notebook_kernel_id, notebook_name, cell_name, interpretable_code, interpretable_code_hash, description, cell_governance, arguments, activity_log, updated_at, created_at, ROW_NUMBER() OVER ( PARTITION BY code_notebook_cell_id ORDER BY COALESCE(updated_at, created_at) DESC -- Orders by the latest timestamp ) AS rn FROM code_notebook_cell ) c WHERE c.rn = 1 |
| code_notebook_cell_latest | notebook_kernel_id | VARCHAR | /console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | [code_notebook_cell_latest (view) Schema](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | /console/content/view/code_notebook_cell_latest.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_cell_latest.sql?stats=yes) | [code_notebook_cell_latest (view) Content](console/content/view/code_notebook_cell_latest.sql?stats=yes) | CREATE VIEW "code_notebook_cell_latest" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- Retrieve the latest version of each code_notebook_cell. -- Notebooks can have multiple versions of cells, where the interpretable_code and other metadata may be updated over time. -- The latest record is determined by the most recent COALESCE(updated_at, created_at) timestamp. SELECT c.code_notebook_cell_id, -- Selects the unique ID of the notebook cell c.notebook_kernel_id, -- References the kernel associated with this cell c.notebook_name, -- The name of the notebook containing this cell c.cell_name, -- The name of the cell within the notebook c.interpretable_code, -- The latest interpretable code associated with the cell c.interpretable_code_hash, -- Hash of the latest interpretable code c.description, -- Description of the cell's purpose or content c.cell_governance, -- Governance details for the cell (if any) c.arguments, -- Arguments or parameters related to the cell's execution c.activity_log, -- Log of activities related to this cell COALESCE(c.updated_at, c.created_at) AS version_timestamp -- The latest timestamp (updated or created) FROM ( SELECT code_notebook_cell_id, notebook_kernel_id, notebook_name, cell_name, interpretable_code, interpretable_code_hash, description, cell_governance, arguments, activity_log, updated_at, created_at, ROW_NUMBER() OVER ( PARTITION BY code_notebook_cell_id ORDER BY COALESCE(updated_at, created_at) DESC -- Orders by the latest timestamp ) AS rn FROM code_notebook_cell ) c WHERE c.rn = 1 |
| code_notebook_cell_latest | notebook_name | TEXT | /console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | [code_notebook_cell_latest (view) Schema](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | /console/content/view/code_notebook_cell_latest.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_cell_latest.sql?stats=yes) | [code_notebook_cell_latest (view) Content](console/content/view/code_notebook_cell_latest.sql?stats=yes) | CREATE VIEW "code_notebook_cell_latest" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- Retrieve the latest version of each code_notebook_cell. -- Notebooks can have multiple versions of cells, where the interpretable_code and other metadata may be updated over time. -- The latest record is determined by the most recent COALESCE(updated_at, created_at) timestamp. SELECT c.code_notebook_cell_id, -- Selects the unique ID of the notebook cell c.notebook_kernel_id, -- References the kernel associated with this cell c.notebook_name, -- The name of the notebook containing this cell c.cell_name, -- The name of the cell within the notebook c.interpretable_code, -- The latest interpretable code associated with the cell c.interpretable_code_hash, -- Hash of the latest interpretable code c.description, -- Description of the cell's purpose or content c.cell_governance, -- Governance details for the cell (if any) c.arguments, -- Arguments or parameters related to the cell's execution c.activity_log, -- Log of activities related to this cell COALESCE(c.updated_at, c.created_at) AS version_timestamp -- The latest timestamp (updated or created) FROM ( SELECT code_notebook_cell_id, notebook_kernel_id, notebook_name, cell_name, interpretable_code, interpretable_code_hash, description, cell_governance, arguments, activity_log, updated_at, created_at, ROW_NUMBER() OVER ( PARTITION BY code_notebook_cell_id ORDER BY COALESCE(updated_at, created_at) DESC -- Orders by the latest timestamp ) AS rn FROM code_notebook_cell ) c WHERE c.rn = 1 |
| code_notebook_cell_latest | cell_name | TEXT | /console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | [code_notebook_cell_latest (view) Schema](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | /console/content/view/code_notebook_cell_latest.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_cell_latest.sql?stats=yes) | [code_notebook_cell_latest (view) Content](console/content/view/code_notebook_cell_latest.sql?stats=yes) | CREATE VIEW "code_notebook_cell_latest" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- Retrieve the latest version of each code_notebook_cell. -- Notebooks can have multiple versions of cells, where the interpretable_code and other metadata may be updated over time. -- The latest record is determined by the most recent COALESCE(updated_at, created_at) timestamp. SELECT c.code_notebook_cell_id, -- Selects the unique ID of the notebook cell c.notebook_kernel_id, -- References the kernel associated with this cell c.notebook_name, -- The name of the notebook containing this cell c.cell_name, -- The name of the cell within the notebook c.interpretable_code, -- The latest interpretable code associated with the cell c.interpretable_code_hash, -- Hash of the latest interpretable code c.description, -- Description of the cell's purpose or content c.cell_governance, -- Governance details for the cell (if any) c.arguments, -- Arguments or parameters related to the cell's execution c.activity_log, -- Log of activities related to this cell COALESCE(c.updated_at, c.created_at) AS version_timestamp -- The latest timestamp (updated or created) FROM ( SELECT code_notebook_cell_id, notebook_kernel_id, notebook_name, cell_name, interpretable_code, interpretable_code_hash, description, cell_governance, arguments, activity_log, updated_at, created_at, ROW_NUMBER() OVER ( PARTITION BY code_notebook_cell_id ORDER BY COALESCE(updated_at, created_at) DESC -- Orders by the latest timestamp ) AS rn FROM code_notebook_cell ) c WHERE c.rn = 1 |
| code_notebook_cell_latest | interpretable_code | TEXT | /console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | [code_notebook_cell_latest (view) Schema](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | /console/content/view/code_notebook_cell_latest.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_cell_latest.sql?stats=yes) | [code_notebook_cell_latest (view) Content](console/content/view/code_notebook_cell_latest.sql?stats=yes) | CREATE VIEW "code_notebook_cell_latest" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- Retrieve the latest version of each code_notebook_cell. -- Notebooks can have multiple versions of cells, where the interpretable_code and other metadata may be updated over time. -- The latest record is determined by the most recent COALESCE(updated_at, created_at) timestamp. SELECT c.code_notebook_cell_id, -- Selects the unique ID of the notebook cell c.notebook_kernel_id, -- References the kernel associated with this cell c.notebook_name, -- The name of the notebook containing this cell c.cell_name, -- The name of the cell within the notebook c.interpretable_code, -- The latest interpretable code associated with the cell c.interpretable_code_hash, -- Hash of the latest interpretable code c.description, -- Description of the cell's purpose or content c.cell_governance, -- Governance details for the cell (if any) c.arguments, -- Arguments or parameters related to the cell's execution c.activity_log, -- Log of activities related to this cell COALESCE(c.updated_at, c.created_at) AS version_timestamp -- The latest timestamp (updated or created) FROM ( SELECT code_notebook_cell_id, notebook_kernel_id, notebook_name, cell_name, interpretable_code, interpretable_code_hash, description, cell_governance, arguments, activity_log, updated_at, created_at, ROW_NUMBER() OVER ( PARTITION BY code_notebook_cell_id ORDER BY COALESCE(updated_at, created_at) DESC -- Orders by the latest timestamp ) AS rn FROM code_notebook_cell ) c WHERE c.rn = 1 |
| code_notebook_cell_latest | interpretable_code_hash | TEXT | /console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | [code_notebook_cell_latest (view) Schema](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | /console/content/view/code_notebook_cell_latest.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_cell_latest.sql?stats=yes) | [code_notebook_cell_latest (view) Content](console/content/view/code_notebook_cell_latest.sql?stats=yes) | CREATE VIEW "code_notebook_cell_latest" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- Retrieve the latest version of each code_notebook_cell. -- Notebooks can have multiple versions of cells, where the interpretable_code and other metadata may be updated over time. -- The latest record is determined by the most recent COALESCE(updated_at, created_at) timestamp. SELECT c.code_notebook_cell_id, -- Selects the unique ID of the notebook cell c.notebook_kernel_id, -- References the kernel associated with this cell c.notebook_name, -- The name of the notebook containing this cell c.cell_name, -- The name of the cell within the notebook c.interpretable_code, -- The latest interpretable code associated with the cell c.interpretable_code_hash, -- Hash of the latest interpretable code c.description, -- Description of the cell's purpose or content c.cell_governance, -- Governance details for the cell (if any) c.arguments, -- Arguments or parameters related to the cell's execution c.activity_log, -- Log of activities related to this cell COALESCE(c.updated_at, c.created_at) AS version_timestamp -- The latest timestamp (updated or created) FROM ( SELECT code_notebook_cell_id, notebook_kernel_id, notebook_name, cell_name, interpretable_code, interpretable_code_hash, description, cell_governance, arguments, activity_log, updated_at, created_at, ROW_NUMBER() OVER ( PARTITION BY code_notebook_cell_id ORDER BY COALESCE(updated_at, created_at) DESC -- Orders by the latest timestamp ) AS rn FROM code_notebook_cell ) c WHERE c.rn = 1 |
| code_notebook_cell_latest | description | TEXT | /console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | [code_notebook_cell_latest (view) Schema](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | /console/content/view/code_notebook_cell_latest.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_cell_latest.sql?stats=yes) | [code_notebook_cell_latest (view) Content](console/content/view/code_notebook_cell_latest.sql?stats=yes) | CREATE VIEW "code_notebook_cell_latest" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- Retrieve the latest version of each code_notebook_cell. -- Notebooks can have multiple versions of cells, where the interpretable_code and other metadata may be updated over time. -- The latest record is determined by the most recent COALESCE(updated_at, created_at) timestamp. SELECT c.code_notebook_cell_id, -- Selects the unique ID of the notebook cell c.notebook_kernel_id, -- References the kernel associated with this cell c.notebook_name, -- The name of the notebook containing this cell c.cell_name, -- The name of the cell within the notebook c.interpretable_code, -- The latest interpretable code associated with the cell c.interpretable_code_hash, -- Hash of the latest interpretable code c.description, -- Description of the cell's purpose or content c.cell_governance, -- Governance details for the cell (if any) c.arguments, -- Arguments or parameters related to the cell's execution c.activity_log, -- Log of activities related to this cell COALESCE(c.updated_at, c.created_at) AS version_timestamp -- The latest timestamp (updated or created) FROM ( SELECT code_notebook_cell_id, notebook_kernel_id, notebook_name, cell_name, interpretable_code, interpretable_code_hash, description, cell_governance, arguments, activity_log, updated_at, created_at, ROW_NUMBER() OVER ( PARTITION BY code_notebook_cell_id ORDER BY COALESCE(updated_at, created_at) DESC -- Orders by the latest timestamp ) AS rn FROM code_notebook_cell ) c WHERE c.rn = 1 |
| code_notebook_cell_latest | cell_governance | TEXT | /console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | [code_notebook_cell_latest (view) Schema](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | /console/content/view/code_notebook_cell_latest.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_cell_latest.sql?stats=yes) | [code_notebook_cell_latest (view) Content](console/content/view/code_notebook_cell_latest.sql?stats=yes) | CREATE VIEW "code_notebook_cell_latest" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- Retrieve the latest version of each code_notebook_cell. -- Notebooks can have multiple versions of cells, where the interpretable_code and other metadata may be updated over time. -- The latest record is determined by the most recent COALESCE(updated_at, created_at) timestamp. SELECT c.code_notebook_cell_id, -- Selects the unique ID of the notebook cell c.notebook_kernel_id, -- References the kernel associated with this cell c.notebook_name, -- The name of the notebook containing this cell c.cell_name, -- The name of the cell within the notebook c.interpretable_code, -- The latest interpretable code associated with the cell c.interpretable_code_hash, -- Hash of the latest interpretable code c.description, -- Description of the cell's purpose or content c.cell_governance, -- Governance details for the cell (if any) c.arguments, -- Arguments or parameters related to the cell's execution c.activity_log, -- Log of activities related to this cell COALESCE(c.updated_at, c.created_at) AS version_timestamp -- The latest timestamp (updated or created) FROM ( SELECT code_notebook_cell_id, notebook_kernel_id, notebook_name, cell_name, interpretable_code, interpretable_code_hash, description, cell_governance, arguments, activity_log, updated_at, created_at, ROW_NUMBER() OVER ( PARTITION BY code_notebook_cell_id ORDER BY COALESCE(updated_at, created_at) DESC -- Orders by the latest timestamp ) AS rn FROM code_notebook_cell ) c WHERE c.rn = 1 |
| code_notebook_cell_latest | arguments | TEXT | /console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | [code_notebook_cell_latest (view) Schema](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | /console/content/view/code_notebook_cell_latest.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_cell_latest.sql?stats=yes) | [code_notebook_cell_latest (view) Content](console/content/view/code_notebook_cell_latest.sql?stats=yes) | CREATE VIEW "code_notebook_cell_latest" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- Retrieve the latest version of each code_notebook_cell. -- Notebooks can have multiple versions of cells, where the interpretable_code and other metadata may be updated over time. -- The latest record is determined by the most recent COALESCE(updated_at, created_at) timestamp. SELECT c.code_notebook_cell_id, -- Selects the unique ID of the notebook cell c.notebook_kernel_id, -- References the kernel associated with this cell c.notebook_name, -- The name of the notebook containing this cell c.cell_name, -- The name of the cell within the notebook c.interpretable_code, -- The latest interpretable code associated with the cell c.interpretable_code_hash, -- Hash of the latest interpretable code c.description, -- Description of the cell's purpose or content c.cell_governance, -- Governance details for the cell (if any) c.arguments, -- Arguments or parameters related to the cell's execution c.activity_log, -- Log of activities related to this cell COALESCE(c.updated_at, c.created_at) AS version_timestamp -- The latest timestamp (updated or created) FROM ( SELECT code_notebook_cell_id, notebook_kernel_id, notebook_name, cell_name, interpretable_code, interpretable_code_hash, description, cell_governance, arguments, activity_log, updated_at, created_at, ROW_NUMBER() OVER ( PARTITION BY code_notebook_cell_id ORDER BY COALESCE(updated_at, created_at) DESC -- Orders by the latest timestamp ) AS rn FROM code_notebook_cell ) c WHERE c.rn = 1 |
| code_notebook_cell_latest | activity_log | TEXT | /console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | [code_notebook_cell_latest (view) Schema](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | /console/content/view/code_notebook_cell_latest.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_cell_latest.sql?stats=yes) | [code_notebook_cell_latest (view) Content](console/content/view/code_notebook_cell_latest.sql?stats=yes) | CREATE VIEW "code_notebook_cell_latest" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- Retrieve the latest version of each code_notebook_cell. -- Notebooks can have multiple versions of cells, where the interpretable_code and other metadata may be updated over time. -- The latest record is determined by the most recent COALESCE(updated_at, created_at) timestamp. SELECT c.code_notebook_cell_id, -- Selects the unique ID of the notebook cell c.notebook_kernel_id, -- References the kernel associated with this cell c.notebook_name, -- The name of the notebook containing this cell c.cell_name, -- The name of the cell within the notebook c.interpretable_code, -- The latest interpretable code associated with the cell c.interpretable_code_hash, -- Hash of the latest interpretable code c.description, -- Description of the cell's purpose or content c.cell_governance, -- Governance details for the cell (if any) c.arguments, -- Arguments or parameters related to the cell's execution c.activity_log, -- Log of activities related to this cell COALESCE(c.updated_at, c.created_at) AS version_timestamp -- The latest timestamp (updated or created) FROM ( SELECT code_notebook_cell_id, notebook_kernel_id, notebook_name, cell_name, interpretable_code, interpretable_code_hash, description, cell_governance, arguments, activity_log, updated_at, created_at, ROW_NUMBER() OVER ( PARTITION BY code_notebook_cell_id ORDER BY COALESCE(updated_at, created_at) DESC -- Orders by the latest timestamp ) AS rn FROM code_notebook_cell ) c WHERE c.rn = 1 |
| code_notebook_cell_latest | version_timestamp | /console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | [code_notebook_cell_latest (view) Schema](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes) | /console/content/view/code_notebook_cell_latest.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_cell_latest.sql?stats=yes) | [code_notebook_cell_latest (view) Content](console/content/view/code_notebook_cell_latest.sql?stats=yes) | CREATE VIEW "code_notebook_cell_latest" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- Retrieve the latest version of each code_notebook_cell. -- Notebooks can have multiple versions of cells, where the interpretable_code and other metadata may be updated over time. -- The latest record is determined by the most recent COALESCE(updated_at, created_at) timestamp. SELECT c.code_notebook_cell_id, -- Selects the unique ID of the notebook cell c.notebook_kernel_id, -- References the kernel associated with this cell c.notebook_name, -- The name of the notebook containing this cell c.cell_name, -- The name of the cell within the notebook c.interpretable_code, -- The latest interpretable code associated with the cell c.interpretable_code_hash, -- Hash of the latest interpretable code c.description, -- Description of the cell's purpose or content c.cell_governance, -- Governance details for the cell (if any) c.arguments, -- Arguments or parameters related to the cell's execution c.activity_log, -- Log of activities related to this cell COALESCE(c.updated_at, c.created_at) AS version_timestamp -- The latest timestamp (updated or created) FROM ( SELECT code_notebook_cell_id, notebook_kernel_id, notebook_name, cell_name, interpretable_code, interpretable_code_hash, description, cell_governance, arguments, activity_log, updated_at, created_at, ROW_NUMBER() OVER ( PARTITION BY code_notebook_cell_id ORDER BY COALESCE(updated_at, created_at) DESC -- Orders by the latest timestamp ) AS rn FROM code_notebook_cell ) c WHERE c.rn = 1 | |
| code_notebook_sql_cell_migratable_version | code_notebook_cell_id | VARCHAR | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes) | [code_notebook_sql_cell_migratable_version (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes) | [code_notebook_sql_cell_migratable_version (view) Content](console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_version" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All cells that are candidates for migration (including duplicates) SELECT c.code_notebook_cell_id, c.notebook_name, c.cell_name, c.interpretable_code, c.interpretable_code_hash, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent, COALESCE(c.updated_at, c.created_at) version_timestamp FROM code_notebook_cell c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_version | notebook_name | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes) | [code_notebook_sql_cell_migratable_version (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes) | [code_notebook_sql_cell_migratable_version (view) Content](console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_version" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All cells that are candidates for migration (including duplicates) SELECT c.code_notebook_cell_id, c.notebook_name, c.cell_name, c.interpretable_code, c.interpretable_code_hash, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent, COALESCE(c.updated_at, c.created_at) version_timestamp FROM code_notebook_cell c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_version | cell_name | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes) | [code_notebook_sql_cell_migratable_version (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes) | [code_notebook_sql_cell_migratable_version (view) Content](console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_version" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All cells that are candidates for migration (including duplicates) SELECT c.code_notebook_cell_id, c.notebook_name, c.cell_name, c.interpretable_code, c.interpretable_code_hash, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent, COALESCE(c.updated_at, c.created_at) version_timestamp FROM code_notebook_cell c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_version | interpretable_code | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes) | [code_notebook_sql_cell_migratable_version (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes) | [code_notebook_sql_cell_migratable_version (view) Content](console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_version" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All cells that are candidates for migration (including duplicates) SELECT c.code_notebook_cell_id, c.notebook_name, c.cell_name, c.interpretable_code, c.interpretable_code_hash, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent, COALESCE(c.updated_at, c.created_at) version_timestamp FROM code_notebook_cell c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_version | interpretable_code_hash | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes) | [code_notebook_sql_cell_migratable_version (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes) | [code_notebook_sql_cell_migratable_version (view) Content](console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_version" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All cells that are candidates for migration (including duplicates) SELECT c.code_notebook_cell_id, c.notebook_name, c.cell_name, c.interpretable_code, c.interpretable_code_hash, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent, COALESCE(c.updated_at, c.created_at) version_timestamp FROM code_notebook_cell c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable_version | is_idempotent | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes) | [code_notebook_sql_cell_migratable_version (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes) | [code_notebook_sql_cell_migratable_version (view) Content](console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_version" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All cells that are candidates for migration (including duplicates) SELECT c.code_notebook_cell_id, c.notebook_name, c.cell_name, c.interpretable_code, c.interpretable_code_hash, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent, COALESCE(c.updated_at, c.created_at) version_timestamp FROM code_notebook_cell c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name | |
| code_notebook_sql_cell_migratable_version | version_timestamp | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes) | [code_notebook_sql_cell_migratable_version (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes) | [code_notebook_sql_cell_migratable_version (view) Content](console/content/view/code_notebook_sql_cell_migratable_version.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable_version" AS -- code provenance: `RssdInitSqlNotebook.notebookBusinessLogicViews` (file:///home/baasit/www.surveilr.com/lib/std/lifecycle.sql.ts) -- All cells that are candidates for migration (including duplicates) SELECT c.code_notebook_cell_id, c.notebook_name, c.cell_name, c.interpretable_code, c.interpretable_code_hash, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent, COALESCE(c.updated_at, c.created_at) version_timestamp FROM code_notebook_cell c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name | |
| code_notebook_sql_cell_migratable | code_notebook_cell_id | VARCHAR | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | [code_notebook_sql_cell_migratable (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | [code_notebook_sql_cell_migratable (view) Content](console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable" 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.*, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent FROM code_notebook_cell_latest c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable | notebook_kernel_id | VARCHAR | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | [code_notebook_sql_cell_migratable (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | [code_notebook_sql_cell_migratable (view) Content](console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable" 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.*, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent FROM code_notebook_cell_latest c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable | notebook_name | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | [code_notebook_sql_cell_migratable (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | [code_notebook_sql_cell_migratable (view) Content](console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable" 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.*, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent FROM code_notebook_cell_latest c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable | cell_name | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | [code_notebook_sql_cell_migratable (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | [code_notebook_sql_cell_migratable (view) Content](console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable" 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.*, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent FROM code_notebook_cell_latest c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable | interpretable_code | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | [code_notebook_sql_cell_migratable (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | [code_notebook_sql_cell_migratable (view) Content](console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable" 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.*, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent FROM code_notebook_cell_latest c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable | interpretable_code_hash | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | [code_notebook_sql_cell_migratable (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | [code_notebook_sql_cell_migratable (view) Content](console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable" 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.*, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent FROM code_notebook_cell_latest c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable | description | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | [code_notebook_sql_cell_migratable (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | [code_notebook_sql_cell_migratable (view) Content](console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable" 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.*, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent FROM code_notebook_cell_latest c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable | cell_governance | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | [code_notebook_sql_cell_migratable (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | [code_notebook_sql_cell_migratable (view) Content](console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable" 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.*, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent FROM code_notebook_cell_latest c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable | arguments | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | [code_notebook_sql_cell_migratable (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | [code_notebook_sql_cell_migratable (view) Content](console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable" 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.*, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent FROM code_notebook_cell_latest c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable | activity_log | TEXT | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | [code_notebook_sql_cell_migratable (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | [code_notebook_sql_cell_migratable (view) Content](console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable" 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.*, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent FROM code_notebook_cell_latest c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name |
| code_notebook_sql_cell_migratable | version_timestamp | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | [code_notebook_sql_cell_migratable (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | [code_notebook_sql_cell_migratable (view) Content](console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable" 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.*, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent FROM code_notebook_cell_latest c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name | |
| code_notebook_sql_cell_migratable | is_idempotent | /console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes | [Content](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | [code_notebook_sql_cell_migratable (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes) | /console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | [code_notebook_sql_cell_migratable (view) Content](console/content/view/code_notebook_sql_cell_migratable.sql?stats=yes) | CREATE VIEW "code_notebook_sql_cell_migratable" 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.*, CASE WHEN c.cell_name LIKE '%_once_%' THEN FALSE ELSE TRUE END AS is_idempotent FROM code_notebook_cell_latest c WHERE c.notebook_name = 'ConstructionSqlNotebook' ORDER BY c.cell_name | |
| code_notebook_sql_cell_migratable_state | code_notebook_cell_id | VARCHAR | /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 | notebook_kernel_id | VARCHAR | /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 | notebook_name | 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 | cell_name | 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 | interpretable_code | 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 | interpretable_code_hash | 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 | description | 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 | cell_governance | 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 | arguments | 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 | activity_log | 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 | version_timestamp | /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 | is_idempotent | /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 | from_state | 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 | to_state | 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 | transition_reason | 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 |
(Page 1 of 10) Next