orchestration_session_exec
| Column |
Type |
PK |
Required |
Default |
| orchestration_session_exec_id |
VARCHAR |
Yes |
Yes |
|
| exec_nature |
TEXT |
No |
Yes |
|
| session_id |
VARCHAR |
No |
Yes |
|
| session_entry_id |
VARCHAR |
No |
No |
|
| parent_exec_id |
VARCHAR |
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" VARCHAR PRIMARY KEY NOT NULL,
"exec_nature" TEXT NOT NULL,
"session_id" VARCHAR NOT NULL,
"session_entry_id" VARCHAR,
"parent_exec_id" VARCHAR,
"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 CHECK(json_valid(output_nature) OR output_nature IS NULL),
"narrative_md" TEXT,
"elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL),
FOREIGN KEY("session_id") REFERENCES "orchestration_session"("orchestration_session_id"),
FOREIGN KEY("session_entry_id") REFERENCES "orchestration_session_entry"("orchestration_session_entry_id"),
FOREIGN KEY("parent_exec_id") REFERENCES "orchestration_session_exec"("orchestration_session_exec_id")
)