orchestration_session_issue_relation

Column Type PK Required Default
orchestration_session_issue_relation_id UUID Yes Yes
issue_id_prime UUID No Yes
issue_id_rel TEXT No Yes
relationship_nature TEXT No Yes
elaboration TEXT No No

Foreign Keys

Column Name Foreign Key
issue_id_prime issue_id_prime references orchestration_session_issue.orchestration_session_issue_id

Indexes

Column Name Index Name
orchestration_session_issue_relation_id sqlite_autoindex_orchestration_session_issue_relation_1

SQL DDL

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")
)