orchestration_session_exec

Column Type PK Required Default
orchestration_session_exec_id TEXT Yes Yes
exec_nature TEXT No Yes
session_id TEXT No Yes
session_entry_id TEXT No No
parent_exec_id TEXT No No
namespace TEXT No No
exec_identity TEXT No No
exec_code TEXT No Yes
exec_status INTEGER No Yes
input_text TEXT No No
exec_error_text TEXT No No
output_text TEXT No No
output_nature TEXT No No
narrative_md TEXT No No
elaboration TEXT No No

Foreign Keys

Column Name Foreign Key
parent_exec_id parent_exec_id references orchestration_session_exec.orchestration_session_exec_id
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_exec_id sqlite_autoindex_orchestration_session_exec_1

SQL DDL

CREATE TABLE `orchestration_session_exec` (
	`orchestration_session_exec_id` text PRIMARY KEY NOT NULL,
	`exec_nature` text NOT NULL,
	`session_id` text NOT NULL,
	`session_entry_id` text,
	`parent_exec_id` text,
	`namespace` text,
	`exec_identity` text,
	`exec_code` text NOT NULL,
	`exec_status` integer NOT NULL,
	`input_text` text,
	`exec_error_text` text,
	`output_text` text,
	`output_nature` text,
	`narrative_md` 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,
	FOREIGN KEY (`parent_exec_id`) REFERENCES `orchestration_session_exec`(`orchestration_session_exec_id`) ON UPDATE no action ON DELETE no action
)