Description: WFM short-term forecasts.
Loading diagram…
erDiagram
PLANNING_GROUP_RESULTS {
string planning_group_id
string forecast_id
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
SHORT_TERM_FORECASTS {
string id PK
string week_date
float week_count
string creation_method
string description
boolean legacy
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
WEEK_SCHEDULE_METADATA {
string id
string week_date
float week_count
string description
boolean published
string short_term_forecast__id
boolean generation_results__failed
string generation_results__run_id
float generation_results__message_count
float metadata__version
string metadata__modified_by__id
datetime metadata__date_modified
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
WEEK_SCHEDULES {
string id PK
string week_date
float week_count
string description
boolean published
string short_term_forecast__id
boolean generation_results__failed
string generation_results__run_id
float generation_results__message_count
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
PLANNING_GROUP_RESULTS }o--|| SHORT_TERM_FORECASTS : forecast_id
WEEK_SCHEDULE_METADATA }o--|| SHORT_TERM_FORECASTS : short_term_forecast__id
WEEK_SCHEDULES }o--|| SHORT_TERM_FORECASTS : short_term_forecast__id
| Source column |
Target table |
Target column |
| - |
- |
- |