zCRT_retained_VolumeSetSummary
efacdb_full ยท Custom/model/helper tables
Updated
2026-04-03 14:25:41
Columns
Full schema, no data mutation.| # | Name | Type | Key | Nullable | Default | Comment |
|---|
| 1 | label_id | int | PRI | NO | - | - |
| 2 | ts_last_calc | datetime | MUL | YES | - | - |
| 3 | latest_calc_value | decimal(19,4) | - | YES | - | - |
| 4 | value_original_price_now_zero | decimal(19,4) | - | YES | - | - |
| 5 | composite_calc_value | decimal(19,4) | - | YES | - | - |
| 6 | target_min_value | decimal(19,4) | - | YES | - | - |
| 7 | target_max_value | decimal(19,4) | - | YES | - | - |
| 8 | status_flag | enum('OK','BELOW_MIN','ABOVE_MAX') | - | YES | - | - |
| 9 | last_run_id | char(36) | MUL | YES | - | - |
Indexes
| Name | Unique | Columns |
|---|
| PRIMARY | Yes | label_id |
| idx_vss_last_run_id | No | last_run_id |
| idx_vss_ts_last_calc | No | ts_last_calc |
Foreign Keys
EFACS has few enforced keys; many relationships are conventional.| Column | References |
|---|
| label_id | zCRT_inputs_VolumeSets.label_id |