When I Work

Explore the interactive ERD

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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`user_id`	Unknown	PKFK

user_position

Column	Type	Keys
`position_id`	Unknown	PKFK
`user_id`	Unknown	PKFK

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	PKFK

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