Description: Trocas de turno weekly em management units.
Loading diagram…
erDiagram
BUSINESS_UNITS {
string id PK
string name
boolean authorized
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
MANAGEMENT_UNIT_WEEK_SHIFT_TRADES {
string id
string week_date
string schedule__id
string schedule__week_date
string schedule__business_unit__id
string state
string initiating_user__id
string initiating_shift_id
datetime initiating_shift_start
datetime initiating_shift_end
string receiving_user__id
string receiving_shift_id
datetime receiving_shift_start
datetime receiving_shift_end
datetime expiration
boolean one_sided
string reviewed_by__id
datetime reviewed_date
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
}
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
}
MANAGEMENT_UNIT_WEEK_SHIFT_TRADES }o--|| USERS : initiating_user__id
MANAGEMENT_UNIT_WEEK_SHIFT_TRADES }o--|| USERS : receiving_user__id
MANAGEMENT_UNIT_WEEK_SHIFT_TRADES }o--|| USERS : reviewed_by__id
MANAGEMENT_UNIT_WEEK_SHIFT_TRADES }o--|| BUSINESS_UNITS : schedule__business_unit__id
| Source column |
Target table |
Target column |
initiating_user__id |
users |
id |
receiving_user__id |
users |
id |
reviewed_by__id |
users |
id |
schedule__business_unit__id |
business_units |
id |
| Source table |
Source column |
Target column |
| - |
- |
- |