orchestration_session

Column Type PK Required Default
orchestration_session_id TEXT Yes Yes
device_id TEXT No Yes
orchestration_nature_id TEXT No Yes
version TEXT No Yes
orch_started_at TIMESTAMPTZ No No
orch_finished_at TIMESTAMPTZ No No
elaboration TEXT No No
args_json TEXT No No
diagnostics_json TEXT No No
diagnostics_md TEXT No No

Foreign Keys

Column Name Foreign Key
orchestration_nature_id orchestration_nature_id references orchestration_nature.orchestration_nature_id
device_id device_id references device.device_id

Indexes

Column Name Index Name
orchestration_session_id sqlite_autoindex_orchestration_session_1

SQL DDL

CREATE TABLE `orchestration_session` (
	`orchestration_session_id` text PRIMARY KEY NOT NULL,
	`device_id` text NOT NULL,
	`orchestration_nature_id` text NOT NULL,
	`version` text NOT NULL,
	`orch_started_at` TIMESTAMPTZ,
	`orch_finished_at` TIMESTAMPTZ,
	`elaboration` text,
	`args_json` text,
	`diagnostics_json` text,
	`diagnostics_md` text,
	FOREIGN KEY (`device_id`) REFERENCES `device`(`device_id`) ON UPDATE no action ON DELETE no action,
	FOREIGN KEY (`orchestration_nature_id`) REFERENCES `orchestration_nature`(`orchestration_nature_id`) ON UPDATE no action ON DELETE no action,
	CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("orchestration_session"."elaboration") OR "orchestration_session"."elaboration" IS NULL),
	CONSTRAINT "args_json_check_valid_json" CHECK(json_valid("orchestration_session"."args_json") OR "orchestration_session"."args_json" IS NULL),
	CONSTRAINT "diagnostics_json_check_valid_json" CHECK(json_valid("orchestration_session"."diagnostics_json") OR "orchestration_session"."diagnostics_json" IS NULL)
)