Standard LibraryRSSD Schema
Orchestration Session Issue Relation
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_issue_relation" (
"orchestration_session_issue_relation_id" UUID PRIMARY KEY NOT NULL,
"issue_id_prime" UUID NOT NULL,
"issue_id_rel" TEXT NOT NULL,
"relationship_nature" TEXT NOT NULL,
"elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL),
FOREIGN KEY("issue_id_prime") REFERENCES "orchestration_session_issue"("orchestration_session_issue_id")
)Columns
| Name | Type | Default | Nullable | Parents | Comment |
|---|---|---|---|---|---|
| orchestration_session_issue_relation_id | UUID | false | {"isSqlDomainZodDescrMeta":true,"isUuid":true} | ||
| issue_id_prime | UUID | false | orchestration_session_issue | {"isSqlDomainZodDescrMeta":true,"isUuid":true} | |
| issue_id_rel | TEXT | false | |||
| relationship_nature | TEXT | false | |||
| elaboration | TEXT | true | isse-specific attributes/properties in JSON ("custom data") |
Constraints
| Name | Type | Definition |
|---|---|---|
| orchestration_session_issue_relation_id | PRIMARY KEY | PRIMARY KEY (orchestration_session_issue_relation_id) |
| - (Foreign key ID: 0) | FOREIGN KEY | FOREIGN KEY (issue_id_prime) REFERENCES orchestration_session_issue (orchestration_session_issue_id) ON UPDATE NO ACTION ON DELETE NO ACTION MATCH NONE |
| sqlite_autoindex_orchestration_session_issue_relation_1 | PRIMARY KEY | PRIMARY KEY (orchestration_session_issue_relation_id) |
| - | CHECK | CHECK(json_valid(elaboration) OR elaboration IS NULL) |
Indexes
| Name | Definition |
|---|---|
| sqlite_autoindex_orchestration_session_issue_relation_1 | PRIMARY KEY (orchestration_session_issue_relation_id) |
Relations
How is this guide?
Last updated on