Standard LibraryRSSD Schema
Orchestration Session Entry
Description
An orchestration session entry records a specific file that that is ingested or otherwise orchestrated
Table Definition
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")
)Columns
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| orchestration_session_entry_id | VARCHAR | false | orchestration_session_state orchestration_session_exec orchestration_session_issue | orchestration_session_entry primary key and internal label (UUID) | ||
| session_id | VARCHAR | false | orchestration_session | orchestration_session row this entry describes | ||
| ingest_src | TEXT | false | The name of the file or URI of the source of the ingestion | |||
| ingest_table_name | TEXT | true | If the ingestion was done into a temp or actual table, this is the table name | |||
| elaboration | TEXT | true | JSON governance data (description, documentation, usage, etc. in JSON) |
Constraints
| Name | Type | Definition |
|---|---|---|
| orchestration_session_entry_id | PRIMARY KEY | PRIMARY KEY (orchestration_session_entry_id) |
| - (Foreign key ID: 0) | FOREIGN KEY | FOREIGN KEY (session_id) REFERENCES orchestration_session (orchestration_session_id) ON UPDATE NO ACTION ON DELETE NO ACTION MATCH NONE |
| sqlite_autoindex_orchestration_session_entry_1 | PRIMARY KEY | PRIMARY KEY (orchestration_session_entry_id) |
| - | CHECK | CHECK(json_valid(elaboration) OR elaboration IS NULL) |
Indexes
| Name | Definition |
|---|---|
| sqlite_autoindex_orchestration_session_entry_1 | PRIMARY KEY (orchestration_session_entry_id) |
Relations
How is this guide?
Last updated on