orchestration_session_log
| Column |
Type |
PK |
Required |
Default |
| orchestration_session_log_id |
numeric |
Yes |
Yes |
|
| category |
TEXT |
No |
No |
|
| parent_exec_id |
numeric |
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` numeric PRIMARY KEY NOT NULL,
`category` text,
`parent_exec_id` numeric,
`content` text NOT NULL,
`sibling_order` integer,
`elaboration` text,
FOREIGN KEY (`parent_exec_id`) REFERENCES `orchestration_session_log`(`orchestration_session_log_id`) ON UPDATE no action ON DELETE no action
)