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 | idx_orchestration_nature__orchestration_nature_id__nature |
| nature | idx_orchestration_nature__orchestration_nature_id__nature |
| orchestration_nature_id | sqlite_autoindex_orchestration_nature_2 |
| nature | sqlite_autoindex_orchestration_nature_2 |
| 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 CHECK(json_valid(elaboration) OR elaboration IS NULL),
"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,
UNIQUE("orchestration_nature_id", "nature")
)