Description: Vínculo do agent com management unit, work plan e rotação.
Loading diagram…
erDiagram
MANAGEMENT_UNIT {
string id PK
string name
string business_unit__id
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
MANAGEMENT_UNIT_AGENT {
string id
string user__id
string work_plan__id
string work_plan__management_unit__id
string work_plan_rotation__id
boolean accept_direct_shift_trades
boolean schedulable
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
}
WORK_PLANS {
string id PK
string name
boolean enabled
boolean valid
boolean constrain_weekly_paid_time
boolean flexible_weekly_paid_time
float weekly_exact_paid_minutes
float weekly_minimum_paid_minutes
float weekly_maximum_paid_minutes
boolean constrain_paid_time_granularity
float paid_time_granularity_minutes
boolean constrain_minimum_time_between_shifts
float minimum_time_between_shifts_minutes
float maximum_days
string start_day_of_weekend
float minimum_consecutive_non_working_minutes_per_week
boolean constrain_maximum_consecutive_working_weekends
float maximum_consecutive_working_weekends
float minimum_working_days_per_week
boolean constrain_maximum_consecutive_working_days
float maximum_consecutive_working_days
float minimum_shift_start_distance_minutes
float minimum_days_off_per_planning_period
float maximum_days_off_per_planning_period
float minimum_paid_minutes_per_planning_period
float maximum_paid_minutes_per_planning_period
string shift_start_variance_type
float agent_count
string managment_unit_id
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
WORK_PLANS_ROTATIONS {
string id PK
string name
boolean enabled
string date_range__start_business_unit_date
string date_range__end_business_unit_date
float agent_count
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
MANAGEMENT_UNIT_AGENT }o--|| USERS : user__id
MANAGEMENT_UNIT_AGENT }o--|| WORK_PLANS : work_plan__id
MANAGEMENT_UNIT_AGENT }o--|| MANAGEMENT_UNIT : work_plan__management_unit__id
MANAGEMENT_UNIT_AGENT }o--|| WORK_PLANS_ROTATIONS : work_plan_rotation__id
| Source table |
Source column |
Target column |
| - |
- |
- |