orchestration_session_state

Column Type PK Required Default
orchestration_session_state_id TEXT Yes Yes
session_id TEXT No Yes
session_entry_id TEXT No No
from_state TEXT No Yes
to_state TEXT No Yes
transition_result TEXT No No
transition_reason TEXT No No
transitioned_at TIMESTAMPTZ 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_state_id orchestration_session_state_orchestration_session_state_id_from_state_to_state_unique
from_state orchestration_session_state_orchestration_session_state_id_from_state_to_state_unique
to_state orchestration_session_state_orchestration_session_state_id_from_state_to_state_unique
orchestration_session_state_id sqlite_autoindex_orchestration_session_state_1

SQL DDL

CREATE TABLE `orchestration_session_state` (
	`orchestration_session_state_id` text PRIMARY KEY NOT NULL,
	`session_id` text NOT NULL,
	`session_entry_id` text,
	`from_state` text NOT NULL,
	`to_state` text NOT NULL,
	`transition_result` text,
	`transition_reason` text,
	`transitioned_at` TIMESTAMPTZ,
	`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
)