code_notebook_sql_cell_migratable_state

Column	Type
code_notebook_cell_id	VARCHAR
notebook_kernel_id	VARCHAR
notebook_name	TEXT
cell_name	TEXT
interpretable_code	TEXT
interpretable_code_hash	TEXT
description	TEXT
cell_governance	TEXT
arguments	TEXT
activity_log	TEXT
version_timestamp
is_idempotent
from_state	TEXT
to_state	TEXT
transition_reason	TEXT
transition_result	TEXT
transitioned_at	TIMESTAMPTZ

SQL DDL

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