orchestration_session_log
| Column |
Type |
PK |
Required |
Default |
| orchestration_session_log_id |
UUID |
Yes |
Yes |
|
| category |
TEXT |
No |
No |
|
| parent_exec_id |
UUID |
No |
No |
|
| content |
TEXT |
No |
Yes |
|
| sibling_order |
INTEGER |
No |
No |
|
| elaboration |
TEXT |
No |
No |
|
Foreign Keys
| Column Name |
Foreign Key |
| parent_exec_id |
parent_exec_id references orchestration_session_log.orchestration_session_log_id |
Indexes
| Column Name |
Index Name |
| orchestration_session_log_id |
sqlite_autoindex_orchestration_session_log_1 |
SQL DDL
CREATE TABLE "orchestration_session_log" (
"orchestration_session_log_id" UUID PRIMARY KEY NOT NULL,
"category" TEXT,
"parent_exec_id" UUID,
"content" TEXT NOT NULL,
"sibling_order" INTEGER,
"elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL),
FOREIGN KEY("parent_exec_id") REFERENCES "orchestration_session_log"("orchestration_session_log_id")
)