Standard LibraryRSSD Schema
Orchestration Session Log
Description
An orchestration issue is generated when an error or warning needs to be created during the orchestration of an entry in a session.
Table Definition
CREATE TABLE "orchestration_session_log" (
"orchestration_session_log_id" UUID PRIMARY KEY NOT NULL,
"category" TEXT,
"parent_exec_id" UUID,
"content" TEXT NOT NULL,
"sibling_order" INTEGER,
"elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL),
FOREIGN KEY("parent_exec_id") REFERENCES "orchestration_session_log"("orchestration_session_log_id")
)Columns
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| orchestration_session_log_id | UUID | false | orchestration_session_log | {"isSqlDomainZodDescrMeta":true,"isUuid":true} | ||
| category | TEXT | true | ||||
| parent_exec_id | UUID | true | orchestration_session_log | {"isSqlDomainZodDescrMeta":true,"isUuid":true} | ||
| content | TEXT | false | ||||
| sibling_order | INTEGER | true | ||||
| elaboration | TEXT | true | isse-specific attributes/properties in JSON ("custom data") |
Constraints
| Name | Type | Definition |
|---|---|---|
| orchestration_session_log_id | PRIMARY KEY | PRIMARY KEY (orchestration_session_log_id) |
| - (Foreign key ID: 0) | FOREIGN KEY | FOREIGN KEY (parent_exec_id) REFERENCES orchestration_session_log (orchestration_session_log_id) ON UPDATE NO ACTION ON DELETE NO ACTION MATCH NONE |
| sqlite_autoindex_orchestration_session_log_1 | PRIMARY KEY | PRIMARY KEY (orchestration_session_log_id) |
| - | CHECK | CHECK(json_valid(elaboration) OR elaboration IS NULL) |
Indexes
| Name | Definition |
|---|---|
| sqlite_autoindex_orchestration_session_log_1 | PRIMARY KEY (orchestration_session_log_id) |
Relations
How is this guide?
Last updated on