Description: Forecast results by planning group.
Loading diagram…
erDiagram
PLANNING_GROUP {
string id PK
string name
string service_goal_template__id
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
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
}
PLANNING_GROUP_RESULTS }o--|| SHORT_TERM_FORECASTS : forecast_id
PLANNING_GROUP_RESULTS }o--|| PLANNING_GROUP : planning_group_id
| Source table |
Source column |
Target column |
| - |
- |
- |