zAR_DRR_executions
efacdb_full ยท Custom/model/helper tables
Columns
Full schema, no data mutation.| # | Name | Type | Key | Nullable | Default | Comment |
|---|
| 1 | execution_id | int | PRI | NO | - | - |
| 2 | procedure_id | int | MUL | NO | - | - |
| 3 | started_at | timestamp | MUL | YES | CURRENT_TIMESTAMP | - |
| 4 | completed_at | timestamp | - | YES | - | - |
| 5 | status | enum('running','completed','failed','cancelled') | MUL | YES | running | - |
| 6 | error_message | text | - | YES | - | - |
| 7 | execution_log | text | - | YES | - | - |
| 8 | triggered_by | enum('manual','scheduled','api') | - | YES | manual | - |
| 9 | triggered_by_user | varchar(100) | - | YES | - | - |
Indexes
| Name | Unique | Columns |
|---|
| PRIMARY | Yes | execution_id |
| idx_procedure_id | No | procedure_id |
| idx_started_at | No | started_at |
| idx_status | No | status |
Foreign Keys
EFACS has few enforced keys; many relationships are conventional.| Column | References |
|---|
| procedure_id | zAR_DRR_procedures.procedure_id |