zCRT_retained_FinalApiPriceSnapshot
efacdb_full ยท Useful derived outputs
Updated
2026-04-03 14:55:20
Columns
Full schema, no data mutation.| # | Name | Type | Key | Nullable | Default | Comment |
|---|
| 1 | run_id | char(36) | PRI | NO | - | - |
| 2 | partid | varchar(30) | PRI | NO | - | - |
| 3 | snapshot_ts | datetime | - | NO | CURRENT_TIMESTAMP | - |
| 4 | price_wholesale | decimal(19,4) | - | YES | - | - |
| 5 | price_trade | decimal(19,4) | - | YES | - | - |
| 6 | price_retail | decimal(19,4) | - | YES | - | - |
Indexes
| Name | Unique | Columns |
|---|
| PRIMARY | Yes | run_id, partid |
| idx_partid | No | partid |
| idx_run_snapshot_ts | No | run_id, snapshot_ts |
Foreign Keys
EFACS has few enforced keys; many relationships are conventional.| Column | References |
|---|
| No enforced foreign keys found for this table. |