Description: Relationship between queues and member users.
Loading diagram…
erDiagram
QUEUE_MEMBERSHIP {
string id PK
string queue_id
string user_id
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
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
}
USERS {
string id PK
string name
string division__id
string department
string email
string state
string title
string username
string manager__id
float version
string employer_info__official_name
string employer_info__employee_id
string employer_info__employee_type
string employer_info__date_hire
string routing_status__status
datetime routing_status__start_time
string presence__id
string presence__name
string presence__source
boolean presence__primary
string presence__presence_definition__id
string presence__presence_definition__system_presence
string presence__message
datetime presence__modified_date
string team__id
string team__name
string team__description
datetime team__date_modified
float team__member_count
boolean acd_auto_answer
string language_preference
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
QUEUE_MEMBERSHIP }o--|| QUEUES : queue_id
QUEUE_MEMBERSHIP }o--|| USERS : user_id
| Source column |
Target table |
Target column |
queue_id |
queues |
id |
user_id |
users |
id |
| Source table |
Source column |
Target column |
| - |
- |
- |