orchestration_nature

Column	Type	PK	Required	Default
orchestration_nature_id	TEXT	Yes	Yes
nature	TEXT	No	Yes
elaboration	TEXT	No	No
created_at	TIMESTAMPTZ	No	No	CURRENT_TIMESTAMP
created_by	TEXT	No	No	'UNKNOWN'
updated_at	TIMESTAMPTZ	No	No
updated_by	TEXT	No	No
deleted_at	TIMESTAMPTZ	No	No
deleted_by	TEXT	No	No
activity_log	TEXT	No	No

Foreign Keys

No data

Indexes

Column Name	Index Name
orchestration_nature_id	orchestration_nature_orchestration_nature_id_nature_unique
nature	orchestration_nature_orchestration_nature_id_nature_unique
orchestration_nature_id	idx_orchestration_nature__orchestration_nature_id__nature
nature	idx_orchestration_nature__orchestration_nature_id__nature
orchestration_nature_id	sqlite_autoindex_orchestration_nature_1

SQL DDL

CREATE TABLE `orchestration_nature` (
	`orchestration_nature_id` text PRIMARY KEY NOT NULL,
	`nature` text NOT NULL,
	`elaboration` text,
	`created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP,
	`created_by` text DEFAULT 'UNKNOWN',
	`updated_at` TIMESTAMPTZ,
	`updated_by` text,
	`deleted_at` TIMESTAMPTZ,
	`deleted_by` text,
	`activity_log` text
)