orchestration_session_issue_relation

Column Type PK Required Default
orchestration_session_issue_relation_id numeric Yes Yes
issue_id_prime numeric 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` numeric PRIMARY KEY NOT NULL,
	`issue_id_prime` numeric NOT NULL,
	`issue_id_rel` text NOT NULL,
	`relationship_nature` text NOT NULL,
	`elaboration` text,
	FOREIGN KEY (`issue_id_prime`) REFERENCES `orchestration_session_issue`(`orchestration_session_issue_id`) ON UPDATE no action ON DELETE no action
)