orchestration_session_entry

Column Type PK Required Default
orchestration_session_entry_id VARCHAR Yes Yes
session_id VARCHAR No Yes
ingest_src TEXT No Yes
ingest_table_name TEXT No No
elaboration TEXT No No

Foreign Keys

Column Name Foreign Key
session_id session_id references orchestration_session.orchestration_session_id

Indexes

Column Name Index Name
orchestration_session_entry_id sqlite_autoindex_orchestration_session_entry_1

SQL DDL

CREATE TABLE "orchestration_session_entry" (
    "orchestration_session_entry_id" VARCHAR PRIMARY KEY NOT NULL,
    "session_id" VARCHAR NOT NULL,
    "ingest_src" TEXT NOT NULL,
    "ingest_table_name" TEXT,
    "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL),
    FOREIGN KEY("session_id") REFERENCES "orchestration_session"("orchestration_session_id")
)