Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| interface_id | varchar | 100 | null |
|
|
Unique interface name to represent a batch execution. Refer to EXECUTION_MAP table PK |
||
| execution_id | int4 | 10 | null |
|
|
The execution ID that represent a batch execution. Refer to EXECUTION_MAP table PK |
||
| last_run_ts | timestamp | 29,6 | √ | null |
|
|
Last timestamp this interface/execution_id was executed for batch execution |
|
| current_run_ts | timestamp | 29,6 | √ | null |
|
|
Current timestamp this interface was executed of this batch execution. It will be the next last_run_ts for this execution. |
|
| updated_at | timestamp | 29,6 | now() |
|
|
Timestamp of the last time this record was updated |
||
| created_at | timestamp | 29,6 | now() |
|
|
Timestamp of the time this record was created |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| etl_execution_schedule_pk | Primary key | Asc/Asc | interface_id + execution_id |
Relationships
Close relationships within degrees of separation
