zCRT_mgr_Run
efacdb_full ยท Custom/model/helper tables
Updated
2026-04-03 14:25:46
Columns
Full schema, no data mutation.| # | Name | Type | Key | Nullable | Default | Comment |
|---|
| 1 | run_id | char(36) | PRI | NO | - | - |
| 2 | sp_logical_name | varchar(64) | MUL | NO | - | - |
| 3 | status | enum('scheduled','running','complete','failed','timeout') | MUL | NO | scheduled | - |
| 4 | requested_by | varchar(64) | - | YES | - | - |
| 5 | requested_at | datetime | MUL | NO | CURRENT_TIMESTAMP | - |
| 6 | started_at | datetime | - | YES | - | - |
| 7 | finished_at | datetime | - | YES | - | - |
| 8 | error_text | text | - | YES | - | - |
Indexes
| Name | Unique | Columns |
|---|
| PRIMARY | Yes | run_id |
| idx_mgr_run_requested_at | No | requested_at |
| idx_mgr_run_sp_name | No | sp_logical_name |
| idx_mgr_run_status | No | status |
Status Counts
| Status | Count |
|---|
| complete | 15 |
| timeout | 12 |
| failed | 3 |
Foreign Keys
EFACS has few enforced keys; many relationships are conventional.| Column | References |
|---|
| No enforced foreign keys found for this table. |