Description: Child table derived from the nested structure of short_term_forecast_planning_groups extracted from Genesys Cloud.
Loading diagram…
erDiagram
QUEUES {
string id PK
string name
string division__id
string division__name
float member_count
float media_settings__call__alerting_timeout_seconds
float media_settings__call__service_level__percentage
float media_settings__call__service_level__duration_ms
float media_settings__socialexpression__alerting_timeout_seconds
float media_settings__socialexpression__service_level__percentage
float media_settings__socialexpression__service_level__duration_ms
float media_settings__chat__alerting_timeout_seconds
float media_settings__chat__service_level__percentage
float media_settings__chat__service_level__duration_ms
float media_settings__callback__alerting_timeout_seconds
float media_settings__callback__service_level__percentage
float media_settings__callback__service_level__duration_ms
float media_settings__message__alerting_timeout_seconds
float media_settings__message__service_level__percentage
float media_settings__message__service_level__duration_ms
float media_settings__videocomm__alerting_timeout_seconds
float media_settings__videocomm__service_level__percentage
float media_settings__videocomm__service_level__duration_ms
float media_settings__email__alerting_timeout_seconds
float media_settings__email__service_level__percentage
float media_settings__email__service_level__duration_ms
datetime date_created
datetime date_modified
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
SHORT_TERM_FORECAST_PLANNING_GROUPS__ROUTE_PATHS {
string queue__id
string media_type
boolean exported
string _sdc_source_key_id
bigint _sdc_sequence
bigint _sdc_level_0_id
}
SHORT_TERM_FORECAST_PLANNING_GROUPS__ROUTE_PATHS }o--|| QUEUES : queue__id
| Source column |
Target table |
Target column |
queue__id |
queues |
id |
| Source table |
Source column |
Target column |
| - |
- |
- |