orchestration_session_issue

Column Type PK Required Default
orchestration_session_issue_id numeric Yes Yes
session_id TEXT No Yes
session_entry_id TEXT No No
issue_type TEXT No Yes
issue_message TEXT No Yes
issue_row INTEGER No No
issue_column TEXT No No
invalid_value TEXT No No
remediation TEXT No No
elaboration TEXT No No

Foreign Keys

Column Name Foreign Key
session_entry_id session_entry_id references orchestration_session_entry.orchestration_session_entry_id
session_id session_id references orchestration_session.orchestration_session_id

Indexes

Column Name Index Name
orchestration_session_issue_id sqlite_autoindex_orchestration_session_issue_1

SQL DDL

CREATE TABLE `orchestration_session_issue` (
	`orchestration_session_issue_id` numeric PRIMARY KEY NOT NULL,
	`session_id` text NOT NULL,
	`session_entry_id` text,
	`issue_type` text NOT NULL,
	`issue_message` text NOT NULL,
	`issue_row` integer,
	`issue_column` text,
	`invalid_value` text,
	`remediation` text,
	`elaboration` text,
	FOREIGN KEY (`session_id`) REFERENCES `orchestration_session`(`orchestration_session_id`) ON UPDATE no action ON DELETE no action,
	FOREIGN KEY (`session_entry_id`) REFERENCES `orchestration_session_entry`(`orchestration_session_entry_id`) ON UPDATE no action ON DELETE no action
)