# When I Work schema ERD

Table and field reference for the Fivetran When I Work connector.

## Table & Field Reference

### time_off_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| creator_id | Unknown | FK |
| type_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| end_time | Unknown |  |
| hours | Unknown |  |
| paid | Unknown |  |
| start_time | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |
| user_status | Unknown |  |

### time_off_request_message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| request_id | Unknown | FK |
| swap_id | Unknown | FK |
| user_id | Unknown | FK |
| actor | Unknown |  |
| content | Unknown |  |
| conversation_id | Unknown |  |
| created_at | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### time_off_request_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| allow_paid | Unknown |  |
| allow_unpaid | Unknown |  |
| built_in | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| enabled | Unknown |  |
| is_deleted | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### shift

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| creator_id | Unknown | FK |
| location_id | Unknown | FK |
| openshift_approval_request_id | Unknown | FK |
| site_id | Unknown | FK |
| user_id | Unknown | FK |
| acknowledged | Unknown |  |
| acknowledged_at | Unknown |  |
| alerted | Unknown |  |
| break_time | Unknown |  |
| color | Unknown |  |
| created_at | Unknown |  |
| end_time | Unknown |  |
| instances | Unknown |  |
| is_open | Unknown |  |
| is_shared | Unknown |  |
| linked_users | Unknown |  |
| notes | Unknown |  |
| notified_at | Unknown |  |
| position_id | Unknown |  |
| published | Unknown |  |
| published_date | Unknown |  |
| requires_openshift_approval | Unknown |  |
| shiftchain_key | Unknown |  |
| start_time | Unknown |  |
| updated_at | Unknown |  |

### admin

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| account_id | Unknown | FK |

### punch_state

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| break_creator_id | Unknown | FK |
| break_id | Unknown | FK |
| punch_time_id | Unknown | FK |
| shift_id | Unknown | FK |
| available_shifts | Json |  |
| break_is_punched | Unknown |  |
| can_clock_in | Unknown |  |
| can_clock_out | Unknown |  |
| can_end_break | Unknown |  |
| can_start_break | Unknown |  |
| error_code | Unknown |  |
| job_sites | Unknown |  |
| needs_break_confirmation | Unknown |  |
| positions | Unknown |  |
| punch_start_time | Unknown |  |
| schedules | Unknown |  |

### shift_request_messages

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| request_id | Unknown | FK |
| swap_id | Unknown | FK |
| user_id | Unknown | FK |
| actor | Unknown |  |
| content | Unknown |  |
| created_at | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### swap_status

| Column | Type | Keys |
| --- | --- | --- |
| shift_id | Unknown | PK, FK |
| shift_request_swap_id | Unknown | FK |
| user_id | Unknown | FK |
| status | Unknown |  |
| user_status | Unknown |  |

### shift_request_swap

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accepted_id | Unknown | FK |
| account_id | Unknown | FK |
| creator_id | Unknown | FK |
| location_id | Unknown | FK |
| shift_id | Unknown | FK |
| updater_id | Unknown | FK |
| user_id | Unknown | FK |
| actionable | Unknown |  |
| allowed_statuses | Unknown |  |
| canceled_id | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| user_status | Unknown |  |

### scheduled_shift_break

| Column | Type | Keys |
| --- | --- | --- |
| shift_id | Unknown | PK, FK |
| length | Unknown |  |
| type | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| user_id | Unknown | FK |
| all_day | Unknown |  |
| created_at | Unknown |  |
| end_time | Unknown |  |
| login_id | Unknown |  |
| notes | Unknown |  |
| recurrence | Unknown |  |
| recurrence_end | Unknown |  |
| start_time | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### annotation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| creator_id | Unknown | FK |
| all_location | Unknown |  |
| announcement | Unknown |  |
| business_closed | Unknown |  |
| color | Unknown |  |
| created_at | Unknown |  |
| end_date | Unknown |  |
| locations | Json |  |
| message | Unknown |  |
| no_time_off | Unknown |  |
| relevant_at | Unknown |  |
| start_date | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### shift_break

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| edited_by | Unknown | FK |
| time_id | Unknown | FK |
| end_time | Unknown |  |
| is_orphaned | Unknown |  |
| is_punched | Unknown |  |
| length | Unknown |  |
| rounded_end_time | Unknown |  |
| rounded_length | Unknown |  |
| rounded_start_time | Unknown |  |
| start_time | Unknown |  |
| type | Unknown |  |

### schedule_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| location_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| end_date | Unknown |  |
| name | Unknown |  |
| start_date | Unknown |  |
| updated_at | Unknown |  |

### schedule_template_shift

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| block_id | Unknown | FK |
| location_id | Unknown | FK |
| openshift_approval_request_id | Unknown | FK |
| position_id | Unknown | FK |
| site_id | Unknown | FK |
| template_id | Unknown | FK |
| user_id | Unknown | FK |
| end_time | Unknown |  |
| is_shared | Unknown |  |
| linked_user | Unknown |  |
| requires_openshift_approval | Unknown |  |
| start_time | Unknown |  |

### user_location

| Column | Type | Keys |
| --- | --- | --- |
| location_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### user_position

| Column | Type | Keys |
| --- | --- | --- |
| position_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| activated | Unknown |  |
| affiliate | Unknown |  |
| alert_settings_absences_email | Unknown |  |
| alert_settings_absences_sms | Unknown |  |
| alert_settings_attendance_email | Unknown |  |
| alert_settings_attendance_sms | Unknown |  |
| alert_settings_availability_email | Unknown |  |
| alert_settings_availability_sms | Unknown |  |
| alert_settings_hire_email | Unknown |  |
| alert_settings_hire_sms | Unknown |  |
| alert_settings_new_employee_email | Unknown |  |
| alert_settings_new_employee_sms | Unknown |  |
| alert_settings_ot_alerts_email | Unknown |  |
| alert_settings_ot_alerts_sms | Unknown |  |
| alert_settings_payroll_sms | Unknown |  |
| alert_settings_reminders_email | Unknown |  |
| alert_settings_reminders_sms | Unknown |  |
| alert_settings_reporting_email | Unknown |  |
| alert_settings_reporting_sms | Unknown |  |
| alert_settings_schedule_email | Unknown |  |
| alert_settings_schedule_sms | Unknown |  |
| alert_settings_shift_bidding_email | Unknown |  |
| alert_settings_shift_bidding_sms | Unknown |  |
| alert_settings_swaps_email | Unknown |  |
| alert_settings_swaps_sms | Unknown |  |
| alert_settings_timeoff_email | Unknown |  |
| alert_settings_timeoff_sms | Unknown |  |
| alert_settings_workchat_alerts | Unknown |  |
| alert_settings_workchat_badge_icon | Unknown |  |
| alert_settings_workchat_in_app | Unknown |  |
| alert_settings_workplace_alerts_email | Unknown |  |
| alert_settings_workplace_alerts_sms | Unknown |  |
| avatar_key | Unknown |  |
| country_code | Unknown |  |
| country_id | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| delete_at | Unknown |  |
| delete_reason | Unknown |  |
| deleted_at | Unknown |  |
| deletion_queued | Unknown |  |
| dismissed_at | Unknown |  |
| email | Unknown |  |
| employee_code | Unknown |  |
| first_name | Unknown |  |
| hired_on | Unknown |  |
| hourly_rate | Unknown |  |
| hours_max | Unknown |  |
| hours_preferred | Unknown |  |
| infotip | Unknown |  |
| invited_at | Unknown |  |
| is_active | Unknown |  |
| is_deleted | Unknown |  |
| is_hidden | Unknown |  |
| is_internal_login | Unknown |  |
| is_onboarded | Unknown |  |
| is_payroll | Unknown |  |
| is_private | Unknown |  |
| is_trusted | Unknown |  |
| last_login | Unknown |  |
| last_name | Unknown |  |
| login_id | Unknown |  |
| migration_id | Unknown |  |
| my_position | Unknown |  |
| notes | Unknown |  |
| notified_at | Unknown |  |
| password | Unknown |  |
| phone_number | Unknown |  |
| position_quality | Unknown |  |
| position_rates | Unknown |  |
| queued_delete_type | Unknown |  |
| reminder_time | Unknown |  |
| role | Unknown |  |
| sleep_end | Unknown |  |
| sleep_start | Unknown |  |
| terminated_at | Unknown |  |
| timezone_id | Unknown |  |
| timezone_name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| uuid | Unknown |  |

### shift_break_audit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| time_id | Unknown | FK |
| created_at | Unknown |  |
| note | Unknown |  |
| taken | Unknown |  |
| updated_at | Unknown |  |

### user_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| open_shift_request_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| deleted_at | Unknown |  |

### open_shift_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| creator_id | Unknown | FK |
| shift_id | Unknown | FK |
| updater_id | Unknown | FK |
| created_at | Unknown |  |
| is_shared | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |
| user_status | Unknown |  |

### site

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| location_id | Unknown | FK |
| place_id | Unknown | FK |
| color | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| is_deleted | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### shift_template_block

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| location_id | Unknown | FK |
| position_id | Unknown | FK |
| updated_by | Unknown | FK |
| break_time | Unknown |  |
| color | Unknown |  |
| created_at | Unknown |  |
| end_time | Unknown |  |
| is_shared | Unknown |  |
| notes | Unknown |  |
| requires_openshift_approval | Unknown |  |
| start_time | Unknown |  |
| updated_at | Unknown |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| place_updated_by | Unknown | FK |
| updated_by | Unknown | FK |
| address | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| ip_address | Unknown |  |
| is_default | Unknown |  |
| is_deleted | Unknown |  |
| max_hours | Unknown |  |
| name | Unknown |  |
| place_address | Unknown |  |
| place_business_name | Unknown |  |
| place_confirmed | Unknown |  |
| place_country | Unknown |  |
| place_formatted_phone_number | Unknown |  |
| place_id | Unknown |  |
| place_international_phone_number | Unknown |  |
| place_latitude | Unknown |  |
| place_locality | Unknown |  |
| place_longitude | Unknown |  |
| place_postal_code | Unknown |  |
| place_region | Unknown |  |
| place_street_name | Unknown |  |
| place_street_number | Unknown |  |
| place_sub_locality | Unknown |  |
| place_type | Unknown |  |
| place_unique_id | Unknown |  |
| place_updated_at | Unknown |  |
| place_website | Unknown |  |
| radius | Unknown |  |
| sort | Unknown |  |
| updated_at | Unknown |  |

### position

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| color | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| sort | Unknown |  |
| updated_at | Unknown |  |

### payroll

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| creator_id | Unknown | FK |
| created_at | Unknown |  |
| end_date | Unknown |  |
| is_closed | Unknown |  |
| offsets | Unknown |  |
| start_date | Unknown |  |
| updated_at | Unknown |  |

### time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| creator_id | Unknown | FK |
| location_id | Unknown | FK |
| modified_by | Unknown | FK |
| position_id | Unknown | FK |
| shift_id | Unknown | FK |
| site_id | Unknown | FK |
| user_id | Unknown | FK |
| alert_type | Unknown |  |
| created_at | Unknown |  |
| end_time | Unknown |  |
| hourly_rate | Unknown |  |
| is_alerted | Unknown |  |
| is_approved | Unknown |  |
| length | Unknown |  |
| notes | Unknown |  |
| rounded_end_time | Unknown |  |
| rounded_length | Unknown |  |
| rounded_start_time | Unknown |  |
| split_time | Unknown |  |
| start_time | Unknown |  |
| sync_hash | Unknown |  |
| sync_id | Unknown |  |
| updated_at | Unknown |  |

### account_feature

| Column | Type | Keys |
| --- | --- | --- |
| feature | Unknown | PK |
| account_id | Unknown | PK, FK |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| master_id | Unknown | FK |
| owner_id | Unknown | FK |
| place_id | Unknown | FK |
| account_group | String |  |
| additional_features | Unknown |  |
| agent_id | Unknown |  |
| attendance_alert_employee | Unknown |  |
| attendance_alert_manager | Unknown |  |
| attendance_freemium | Unknown |  |
| availability_migrated | Unknown |  |
| bad_credit_card | Unknown |  |
| billing_address | Unknown |  |
| billing_city | Unknown |  |
| billing_country | Unknown |  |
| billing_discount | Unknown |  |
| billing_engine | Unknown |  |
| billing_phone | Unknown |  |
| billing_state | Unknown |  |
| billing_type | Unknown |  |
| billing_zip | Unknown |  |
| business_id | Unknown |  |
| cancel_reason_feedback | Unknown |  |
| cancel_reason_id | Unknown |  |
| company | Unknown |  |
| converted_at | Unknown |  |
| country_dialing_code | Unknown |  |
| country_id | Unknown |  |
| country_is_deleted | Unknown |  |
| country_is_enabled | Unknown |  |
| country_iso_2 | Unknown |  |
| country_iso_3 | Unknown |  |
| country_name | Unknown |  |
| country_sms_cost | Unknown |  |
| country_sms_credit_cost | Unknown |  |
| country_updated_by | Unknown |  |
| created_at | Unknown |  |
| credit_attempts | Unknown |  |
| credit_balance | Unknown |  |
| credit_eft_number | Unknown |  |
| credit_email | Unknown |  |
| credit_exp | Unknown |  |
| credit_name | Unknown |  |
| credit_number | Unknown |  |
| credit_phone_number | Unknown |  |
| credit_recurring_day | Unknown |  |
| deactivated_at | Unknown |  |
| deleted_at | Unknown |  |
| employee_count | Unknown |  |
| enabled | Unknown |  |
| has_billing | Unknown |  |
| has_saml | Unknown |  |
| industry_id | Unknown |  |
| is_deactivated | Unknown |  |
| is_default_location_address | Unknown |  |
| is_deleted | Unknown |  |
| is_demo | Unknown |  |
| limited_features_shift_acknowledgement | Boolean |  |
| location_count | Unknown |  |
| logo | Unknown |  |
| master_plan_id | Unknown |  |
| organization_id | Unknown |  |
| owner_email | Unknown |  |
| owner_name | Unknown |  |
| payroll_date | Unknown |  |
| payroll_hours_max | Unknown |  |
| payroll_overtime_multiplier | Unknown |  |
| place_confirmed | Unknown |  |
| plan_custom | Unknown |  |
| plan_expires | Unknown |  |
| plan_id | Unknown |  |
| plan_texting | Unknown |  |
| plan_type | Unknown |  |
| plan_units | Unknown |  |
| previous_plan_id | Unknown |  |
| previous_plan_units | Unknown |  |
| previous_type | Unknown |  |
| primary_contact | Unknown |  |
| real_type | Unknown |  |
| ref_employees | Unknown |  |
| ref_plan_id | Unknown |  |
| ref_status | Unknown |  |
| referral_code | Unknown |  |
| referral_id | Unknown |  |
| required_features | Unknown |  |
| settings_attendance_billing_recurring | Unknown |  |
| settings_attendance_on_demand_pay_enabled | Unknown |  |
| settings_attendance_role_permissions_managers_can_manage_account_settings | Unknown |  |
| settings_attendance_role_permissions_managers_can_manage_workplace_objects | Unknown |  |
| settings_attendance_role_permissions_supervisors_can_approve_own_timesheet | Unknown |  |
| settings_attendance_role_permissions_supervisors_can_edit_all_shift_details | Unknown |  |
| settings_attendance_role_permissions_supervisors_can_edit_employee_timesheets | Unknown |  |
| settings_attendance_role_permissions_supervisors_can_manage_workplace_objects | Unknown |  |
| settings_attendance_role_permissions_supervisors_can_view_employee_wages | Unknown |  |
| settings_attendance_started_at | Unknown |  |
| settings_attendance_tasks_enabled | Unknown |  |
| settings_attendance_trial_activated | Unknown |  |
| settings_attendance_trial_enabled | Unknown |  |
| settings_attendance_trial_ended_at | Unknown |  |
| settings_attendance_trial_expires_at | Unknown |  |
| settings_attendance_trial_started_at | Unknown |  |
| settings_availability_days_notice | Unknown |  |
| settings_availability_enabled | Unknown |  |
| settings_availability_is_public | Unknown |  |
| settings_break_rules_enabled | Unknown |  |
| settings_break_rules_rules | Unknown |  |
| settings_breaks_paid_track_missed | Unknown |  |
| settings_breaks_unpaid_auto_deduct | Unknown |  |
| settings_breaks_unpaid_enabled | Unknown |  |
| settings_breaks_unpaid_enabled_at | Unknown |  |
| settings_breaks_unpaid_manually_record | Unknown |  |
| settings_clockin_enabled | Unknown |  |
| settings_clockin_mobile_enabled | Unknown |  |
| settings_clockin_mobile_radius | Unknown |  |
| settings_clockin_mobile_strict | Unknown |  |
| settings_clockin_mobile_strict_out | Unknown |  |
| settings_clockin_photo_enabled | Unknown |  |
| settings_clockin_window | Unknown |  |
| settings_clockin_work_enabled | Unknown |  |
| settings_clockin_work_radius | Unknown |  |
| settings_clockin_work_strict | Unknown |  |
| settings_clockin_work_strict_out | Unknown |  |
| settings_conversations_enabled | Unknown |  |
| settings_integrations_revel | Unknown |  |
| settings_integrations_square | Unknown |  |
| settings_marketing_attribution_id | Unknown |  |
| settings_marketing_funnel | Unknown |  |
| settings_payroll_adp_enabled | Unknown |  |
| settings_payroll_adp_viewable | Unknown |  |
| settings_payroll_dbl_multiplier | Unknown |  |
| settings_payroll_enabled | Unknown |  |
| settings_payroll_hours_dot_daily | Unknown |  |
| settings_payroll_hours_dot_daily_enabled | Unknown |  |
| settings_payroll_hours_max | Unknown |  |
| settings_payroll_hours_max_daily | Unknown |  |
| settings_payroll_hours_max_daily_enabled | Unknown |  |
| settings_payroll_hours_max_enabled | Unknown |  |
| settings_payroll_is_onboarded | Unknown |  |
| settings_payroll_max_enforcement_enabled | Unknown |  |
| settings_payroll_ot_alerts_clockin | Unknown |  |
| settings_payroll_ot_alerts_clockout | Unknown |  |
| settings_payroll_ot_alerts_within | Unknown |  |
| settings_payroll_ot_multiplier | Unknown |  |
| settings_payroll_reveal_attendance | Unknown |  |
| settings_payroll_rounding_enabled | Unknown |  |
| settings_payroll_rounding_minute_increment | Unknown |  |
| settings_payroll_start_date | Unknown |  |
| settings_payroll_timesheets | Unknown |  |
| settings_payroll_type | Unknown |  |
| settings_payroll_use_sow_for_ot | Unknown |  |
| settings_payroll_work_day_start | Unknown |  |
| settings_permissions_text_credit | Unknown |  |
| settings_privacy_enabled | Unknown |  |
| settings_schedule_currency | Unknown |  |
| settings_schedule_enabled | Unknown |  |
| settings_schedule_is_visible | Unknown |  |
| settings_schedule_open_scheduling | Unknown |  |
| settings_schedule_positions_only | Unknown |  |
| settings_schedule_preferred_hours | Unknown |  |
| settings_schedule_shared_openshifts | Unknown |  |
| settings_schedule_shift_acknowledgement | Unknown |  |
| settings_schedule_sort_employees | Unknown |  |
| settings_schedule_split_shifts | Unknown |  |
| settings_schedule_start_of_week | Unknown |  |
| settings_schedule_track_absences | Unknown |  |
| settings_schedule_twenty_four_hour | Unknown |  |
| settings_schedule_worktags | Unknown |  |
| settings_scheduling_rules_enabled | Unknown |  |
| settings_scheduling_rules_max_consecutive_days_enabled | Unknown |  |
| settings_scheduling_rules_max_consecutive_days_rule | Unknown |  |
| settings_scheduling_rules_max_days_in_week_enabled | Unknown |  |
| settings_scheduling_rules_max_days_in_week_rule | Unknown |  |
| settings_scheduling_rules_min_hours_between_shifts_diff_day_enabled | Unknown |  |
| settings_scheduling_rules_min_hours_between_shifts_diff_day_rule | Unknown |  |
| settings_scheduling_rules_min_hours_between_shifts_same_day_enabled | Unknown |  |
| settings_scheduling_rules_min_hours_between_shifts_same_day_rule | Unknown |  |
| settings_social_enabled | Unknown |  |
| settings_swaps_drop_hours_before | Unknown |  |
| settings_swaps_enable_drops | Unknown |  |
| settings_swaps_enable_partial_openshift | Unknown |  |
| settings_swaps_enable_releases | Unknown |  |
| settings_swaps_enable_swaps | Unknown |  |
| settings_swaps_enabled | Unknown |  |
| settings_swaps_manager_approval | Unknown |  |
| settings_swaps_partial_openshift_coverage | Unknown |  |
| settings_swaps_release_hours_before | Unknown |  |
| settings_swaps_swap_hours_before | Unknown |  |
| settings_timeoff_days_notice | Unknown |  |
| settings_timeoff_enabled | Unknown |  |
| settings_timeoff_is_public | Unknown |  |
| settings_timeoff_manager_approval | Unknown |  |
| settings_timeoff_max_hours_per_day | Unknown |  |
| settings_timeoff_supervisor_autoapprove | Unknown |  |
| settings_workchat_custom_channels_allowed | Unknown |  |
| settings_workchat_enabled | Unknown |  |
| settings_workchat_last_enabled_date | Unknown |  |
| settings_workchat_managed_channel_conversations_allowed | Unknown |  |
| settings_workchat_toggled | Unknown |  |
| split_shifts | Unknown |  |
| subscriptions | Unknown |  |
| tax_exemption | Unknown |  |
| text_credits | Unknown |  |
| time_format | Unknown |  |
| timezone_id | Unknown |  |
| timezone_name | Unknown |  |
| toggles | Unknown |  |
| trial_created_at | Unknown |  |
| trial_length | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| updated_by | Unknown |  |
| user_count | Unknown |  |
| user_count_local | Unknown |  |
| uses_features | Unknown |  |
| utm_campaign | Unknown |  |
| utm_content | Unknown |  |
| utm_medium | Unknown |  |
| utm_source | Unknown |  |
| utm_term | Unknown |  |
| wb_expires | Unknown |  |

## Relationships

- time_off_request(user_id) → users(id)
- time_off_request(creator_id) → users(id)
- time_off_request(account_id) → account(id)
- time_off_request(type_id) → time_off_request_type(id)
- time_off_request_message(user_id) → users(id)
- time_off_request_message(request_id) → time_off_request(id)
- time_off_request_message(swap_id) → shift_request_swap(id)
- time_off_request_message(account_id) → account(id)
- time_off_request_type(account_id) → account(id)
- shift(user_id) → users(id)
- shift(openshift_approval_request_id) → open_shift_request(id)
- shift(location_id) → location(id)
- shift(creator_id) → users(id)
- shift(account_id) → account(id)
- shift(site_id) → site(id)
- admin(id) → users(id)
- admin(account_id) → account(id)
- punch_state(shift_id) → shift(id)
- punch_state(break_id) → shift_break(id)
- punch_state(punch_time_id) → time(id)
- punch_state(break_creator_id) → users(id)
- shift_request_messages(user_id) → users(id)
- shift_request_messages(request_id) → user_request(id)
- shift_request_messages(swap_id) → shift_request_swap(id)
- shift_request_messages(account_id) → account(id)
- swap_status(shift_id) → shift(id)
- swap_status(user_id) → users(id)
- swap_status(shift_request_swap_id) → shift_request_swap(id)
- shift_request_swap(user_id) → users(id)
- shift_request_swap(shift_id) → shift(id)
- shift_request_swap(accepted_id) → users(id)
- shift_request_swap(updater_id) → users(id)
- shift_request_swap(location_id) → location(id)
- shift_request_swap(creator_id) → users(id)
- shift_request_swap(account_id) → account(id)
- scheduled_shift_break(shift_id) → shift(id)
- event(user_id) → users(id)
- event(account_id) → account(id)
- annotation(creator_id) → users(id)
- annotation(account_id) → account(id)
- shift_break(edited_by) → users(id)
- shift_break(creator_id) → users(id)
- shift_break(time_id) → time(id)
- schedule_template(user_id) → users(id)
- schedule_template(location_id) → location(id)
- schedule_template(account_id) → account(id)
- schedule_template_shift(position_id) → position(id)
- schedule_template_shift(block_id) → shift_template_block(id)
- schedule_template_shift(template_id) → schedule_template(id)
- schedule_template_shift(user_id) → users(id)
- schedule_template_shift(openshift_approval_request_id) → open_shift_request(id)
- schedule_template_shift(location_id) → location(id)
- schedule_template_shift(account_id) → account(id)
- schedule_template_shift(site_id) → site(id)
- user_location(location_id) → location(id)
- user_location(user_id) → users(id)
- user_position(position_id) → position(id)
- user_position(user_id) → users(id)
- users(account_id) → account(id)
- shift_break_audit(time_id) → time(id)
- shift_break_audit(creator_id) → users(id)
- user_request(user_id) → users(id)
- user_request(open_shift_request_id) → open_shift_request(id)
- open_shift_request(shift_id) → shift(id)
- open_shift_request(updater_id) → users(id)
- open_shift_request(creator_id) → users(id)
- open_shift_request(account_id) → account(id)
- site(place_id) → location(place_id)
- site(location_id) → location(id)
- site(account_id) → account(id)
- shift_template_block(position_id) → position(id)
- shift_template_block(location_id) → location(id)
- shift_template_block(updated_by) → users(id)
- shift_template_block(account_id) → account(id)
- location(updated_by) → users(id)
- location(account_id) → account(id)
- location(place_updated_by) → users(id)
- position(account_id) → account(id)
- payroll(creator_id) → users(id)
- payroll(account_id) → account(id)
- time(position_id) → position(id)
- time(user_id) → users(id)
- time(shift_id) → shift(id)
- time(location_id) → location(id)
- time(modified_by) → users(id)
- time(creator_id) → users(id)
- time(account_id) → account(id)
- time(site_id) → site(id)
- account_feature(account_id) → account(id)
- account(place_id) → location(place_id)
- account(master_id) → account(id)
- account(owner_id) → users(id)