zAR-BIP-model-runs
efacdb_full ยท Custom/model/helper tables
Updated
2026-05-20 07:36:37
Columns
Full schema, no data mutation.| # | Name | Type | Key | Nullable | Default | Comment |
|---|
| 1 | modelrunid | bigint | PRI | NO | - | - |
| 2 | run-name | varchar(180) | - | NO | - | - |
| 3 | status | varchar(24) | MUL | NO | queued | - |
| 4 | staffingsetid | bigint | - | NO | - | - |
| 5 | paramsetid | bigint | - | NO | - | - |
| 6 | statesetid | bigint | MUL | NO | - | - |
| 7 | demand-set-id | bigint | - | NO | - | - |
| 8 | policy-set-id | bigint | - | NO | - | - |
| 9 | workcentresetid | bigint | - | YES | - | - |
| 10 | labourcapacitysetid | bigint | - | YES | - | - |
| 11 | specific-forced-order-cases | int | - | NO | 1 | - |
| 12 | generator-stress | varchar(40) | - | NO | none | - |
| 13 | horizon-months | int | - | NO | 24 | - |
| 14 | horizon-days | int | - | NO | 730 | - |
| 15 | scenario-count | int | - | NO | 0 | - |
| 16 | completed-scenarios | int | - | NO | 0 | - |
| 17 | current-scenario | int | - | NO | 0 | - |
| 18 | current-day | int | - | NO | 0 | - |
| 19 | current-date | date | - | YES | - | - |
| 20 | progress-pct | decimal(6,2) | - | NO | 0.00 | - |
| 21 | inputs-json | longtext | - | YES | - | - |
| 22 | summary-json | longtext | - | YES | - | - |
| 23 | created-by | varchar(120) | - | YES | - | - |
| 24 | created-at | timestamp | - | NO | CURRENT_TIMESTAMP | - |
| 25 | started-at | datetime | - | YES | - | - |
| 26 | completed-at | datetime | - | YES | - | - |
| 27 | error-message | text | - | YES | - | - |
Indexes
| Name | Unique | Columns |
|---|
| PRIMARY | Yes | modelrunid |
| ix-zar-bip-model-runs-state | No | statesetid, paramsetid |
| ix-zar-bip-model-runs-status | No | status, created-at |
Status Counts
| Status | Count |
|---|
| complete | 2 |
| running | 1 |
Foreign Keys
EFACS has few enforced keys; many relationships are conventional.| Column | References |
|---|
| No enforced foreign keys found for this table. |