zPipeline_SP_Log
efacdb_full ยท Custom/model/helper tables
Updated
2026-04-03 14:26:47
Columns
Full schema, no data mutation.| # | Name | Type | Key | Nullable | Default | Comment |
|---|
| 1 | id | bigint | PRI | NO | - | - |
| 2 | ts | datetime(6) | MUL | NO | CURRENT_TIMESTAMP(6) | - |
| 3 | procedure_name | varchar(128) | MUL | NO | - | - |
| 4 | event_type | enum('start','end','info','error') | - | NO | info | - |
| 5 | run_id | varchar(64) | MUL | YES | - | - |
| 6 | message | varchar(500) | - | YES | - | - |
| 7 | started_at | datetime(6) | - | YES | - | - |
| 8 | duration_ms | bigint | - | YES | - | - |
Indexes
| Name | Unique | Columns |
|---|
| PRIMARY | Yes | id |
| idx_proc_ts | No | procedure_name, ts |
| idx_run | No | run_id |
| idx_ts | No | ts |
Foreign Keys
EFACS has few enforced keys; many relationships are conventional.| Column | References |
|---|
| No enforced foreign keys found for this table. |