7shifts

Explore the interactive ERD

Table & Field Reference

task_tag

Column	Type	Keys
`uuid`	Unknown	PK
`task_id`	Unknown	PKFK
`task_list_id`	Unknown	PKFK
`user_id`	Unknown	FK

task

Column	Type	Keys
`id`	Unknown	PK
`task_list_id`	Unknown	PKFK
`task_completion_event_user_id`	Unknown	FK
`task_template_uuid`	Unknown	FK
`user_id`	Unknown	FK
`completed_at`	Unknown
`description`	Unknown
`task_completion_event_completed_at`	Unknown
`task_completion_event_completion_value`	Unknown
`task_completion_primitive_type`	Unknown
`task_completion_type`	Unknown
`task_completion_unit`	Unknown
`title`	Unknown

task_list_assignment

Column	Type	Keys
`index`	Unknown	PK
`task_list_id`	Unknown	PKFK
`company_id`	Unknown	FK
`department_id`	Unknown	FK
`location_id`	Unknown	FK
`role_id`	Unknown	FK
`user_id`	Unknown	FK

task_list

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`location_id`	Unknown	FK
`description`	Unknown
`due`	Unknown
`due_date_end`	Unknown
`due_date_start`	Unknown
`recurrence_interval`	Unknown
`recurrence_rrule`	Unknown
`start_date`	Unknown
`task_list_template_uuid`	Unknown
`time_frame_end`	Unknown
`time_frame_end_time`	Unknown
`time_frame_start`	Unknown
`time_frame_start_time`	Unknown
`title`	Unknown

time_punch_break

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`time_punch_id`	Unknown	PKFK
`custom_break_id`	Unknown
`in_time`	Unknown
`out_time`	Unknown
`paid`	Unknown

time_punch

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`department_id`	Unknown	FK
`location_id`	Unknown	FK
`role_id`	Unknown	FK
`shift_id`	Unknown	FK
`user_id`	Unknown	FK
`approved`	Unknown
`auto_clocked_out`	Unknown
`clocked_in`	Unknown
`clocked_in_offline`	Unknown
`clocked_out`	Unknown
`clocked_out_offline`	Unknown
`created`	Unknown
`deleted`	Unknown
`editable_punch`	Unknown
`hourly_wage`	Unknown
`modified`	Instant
`notes`	Unknown
`pos_type`	Unknown
`tips`	Unknown

event_location

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`event_id`	Unknown	PKFK
`location_id`	Unknown	FK

event_start

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`event_id`	Unknown	PKFK
`date_time`	Unknown

event_end

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`event_id`	Unknown	PKFK
`date_time`	Unknown

event

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`all_day`	Unknown
`color`	Unknown
`description`	Unknown
`end_date`	Unknown
`end_time`	Unknown
`is_multi_day`	Unknown
`recurrence`	Unknown
`start_date`	Unknown
`start_time`	Unknown
`title`	Unknown
`type`	Unknown

engage_overview

Column	Type	Keys
`_fivetran_id`	String	PK
`company_id`	Unknown	FK
`location_id`	Unknown	FK
`most_drops_user_id`	Unknown	FK
`most_eager_user_id`	Unknown	FK
`most_late_user_id`	Unknown	FK
`most_reliable_user_id`	Unknown	FK
`most_sick_user_id`	Unknown	FK
`average_tenure`	Unknown
`lates_current`	Unknown
`lates_previous`	Unknown
`most_drops_user_primary_role`	Unknown
`most_eager_user_primary_role`	Unknown
`most_late_user_primary_role`	Unknown
`most_reliable_user_primary_role`	Unknown
`most_sick_user_primary_role`	Unknown
`no_shows_current`	Unknown
`no_shows_previous`	Unknown
`shift_bids_current`	Unknown
`shift_bids_previous`	Unknown
`shift_drops_current`	Unknown
`shift_drops_previous`	Unknown
`shift_feedback_current`	Unknown
`shift_feedback_previous`	Unknown
`sick_shifts_current`	Unknown
`sick_shifts_previous`	Unknown

engage_overview_score

Column	Type	Keys
`_fivetran_id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`company_id`	Unknown	FK
`location_id`	Unknown	FK
`current_score`	Unknown
`engagement_type`	String
`metrics_dropped_shifts_ranking`	Unknown
`metrics_dropped_shifts_stat`	Unknown
`metrics_lates_ranking`	Unknown
`metrics_lates_stat`	Unknown
`metrics_no_shows_ranking`	Unknown
`metrics_no_shows_stat`	Unknown
`metrics_shift_bids_ranking`	Unknown
`metrics_shift_bids_stat`	Unknown
`metrics_total_shifts`	Unknown
`user_primary_role`	Unknown

availability_reason

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`comment_required`	Unknown
`created`	Unknown
`modified`	Unknown
`reason`	Unknown
`sort`	Unknown

daily_stats_interval

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`actual_labor`	Unknown
`actual_sales`	Unknown
`actual_spmh`	Unknown
`day`	Unknown
`end_date`	Unknown
`labor_ratio`	Unknown
`past_actual_sales`	Unknown
`past_projected_sales`	Unknown
`projected_labor`	Unknown
`projected_labor_minutes`	Unknown
`projected_labor_ratio`	Unknown
`projected_sales`	Unknown
`projected_spmh`	Unknown
`start_date`	Unknown

daily_stats

Column	Type	Keys
`_fivetran_id`	String	PK
`company_id`	Unknown	FK
`location_id`	Unknown	FK
`current_actual_labor`	Unknown
`current_actual_sales`	Unknown
`current_labor_ratio`	Unknown
`current_labor_target`	Unknown
`current_projected_labor`	Unknown
`current_projected_sales`	Unknown
`current_spmh`	Unknown
`past_actual_labor`	Unknown
`past_actual_sales`	Unknown
`past_labor_ratio`	Unknown
`past_projected_sales`	Unknown
`past_spmh`	Unknown

log_book_comment

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`log_book_id`	Unknown	PKFK
`user_id`	Unknown	FK
`created`	Unknown
`message`	Unknown
`uuid`	Unknown

company_labour_setting_custom_min_wage

Column	Type	Keys
`_fivetran_id`	String	PK
`company_id`	Unknown	FK

company_labour_setting

Column	Type	Keys
`company_id`	Unknown	PKFK
`auto_break_enabled`	Unknown
`auto_break_hours`	Unknown
`auto_break_hours_2`	Unknown
`auto_break_minutes`	Unknown
`auto_break_minutes_2`	Unknown
`consecutive_days_multiplier`	Unknown
`consecutive_days_threshold`	Unknown
`daily_overtime_multiplier`	Unknown
`daily_overtime_threshold`	Unknown
`exception_cost_enabled`	Unknown
`is_custom`	Unknown
`is_custom_min_wage`	Unknown
`jurisdiction`	Unknown
`ot_alerts_buffer_minutes`	Unknown
`ot_alerts_enabled`	Unknown
`overtime_by_location_enabled`	Unknown
`overtime_enabled`	Unknown
`premium_overtime_multiplier`	Unknown
`premium_overtime_threshold`	Unknown
`regular_rate_of_pay_enabled`	Unknown
`split_hours_on_holiday`	Unknown
`tipped_minimum_wage_enabled`	Unknown
`use_jurisdiction_minimum_wage_for_ot`	Unknown
`wage_based_roles_enabled`	Unknown
`weekly_overtime_multiplier`	Unknown
`weekly_overtime_threshold`	Unknown

user_wage

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`role_id`	Unknown	FK
`cents`	Unknown
`created`	Unknown
`effective_date`	Unknown
`modified`	Unknown
`table_type`	String
`type`	Unknown

department

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`location_id`	Unknown	FK
`created`	Unknown
`deleted`	Unknown
`is_default`	Unknown
`modified`	Instant
`name`	Unknown

log_book_post_attachment

Column	Type	Keys
`file_id`	Unknown	PK
`company_id`	Unknown	PKFK
`log_book_post_id`	Unknown	PKFK
`file_name`	Unknown
`full_path`	Unknown

log_book_post

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`location_id`	Unknown	FK
`log_book_category_id`	Unknown	FK
`user_id`	Unknown	FK
`created`	Unknown
`date`	Unknown
`log_book_comment_count`	Unknown
`message`	Unknown
`uuid`	Unknown

company

Column	Type	Keys
`id`	Unknown	PK
`converted`	Unknown
`country`	Unknown
`created`	Unknown
`days_to_expire`	Unknown
`expires`	Unknown
`modified`	Unknown
`name`	Unknown
`photo`	Unknown
`plan_id`	Unknown
`pos`	Unknown
`start_week_on`	Unknown
`status`	Unknown
`trial`	Unknown
`uuid`	Unknown
`custom_`

user_location_assignment

Column	Type	Keys
`company_id`	Unknown	PKFK
`id`	Unknown	PKFK
`user_id`	Unknown	PKFK

user_department_assignment

Column	Type	Keys
`company_id`	Unknown	PKFK
`id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`appear_on_schedule`	Unknown

user_role_assignment

Column	Type	Keys
`company_id`	Unknown	PKFK
`id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`is_primary`	Unknown
`skill_level`	Unknown

task_template

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`task_list_template_id`	Unknown	PKFK
`created`	Unknown
`description`	Unknown
`sort`	Unknown
`task_completion_primitive_type`	Unknown
`task_completion_type`	Unknown
`task_completion_unit`	Unknown
`title`	Unknown
`uuid`	Unknown

task_list_template_assignment

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`task_list_template_id`	Unknown	PKFK
`department_id`	Unknown	FK
`location_id`	Unknown	FK
`role_id`	Unknown	FK
`user_id`	Unknown	FK

task_list_template

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`activated_at`	Unknown
`created`	Unknown
`description`	Unknown
`due`	Unknown
`recurrence`	Unknown
`status`	Unknown
`time_frame_end`	Unknown
`time_frame_start`	Unknown
`title`	Unknown
`uuid`	Unknown

task_management_setting

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`can_use_task_management`	Unknown
`employee_login`	Unknown
`employee_reminder`	Unknown
`enabled`	Unknown
`has_created_list`	Unknown
`overdue_alert`	Unknown
`prompted_auto_assign_id`	Unknown

time_off_hour

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`time_off_id`	Unknown	PKFK
`date`	Unknown
`hours`	Unknown

time_off

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`status_action_user_id`	Unknown	FK
`user_id`	Unknown	FK
`amount_of_hours`	Unknown
`category`	Unknown
`comment`	Unknown
`created`	Unknown
`from_date`	Unknown
`modified`	Unknown
`partial`	Unknown
`partial_from`	Unknown
`partial_to`	Unknown
`status`	Unknown
`status_action_message`	Unknown
`to_date`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`active`	Unknown
`address`	Unknown
`appear_as_employee`	Unknown
`birth_date`	Unknown
`city`	Unknown
`created`	Unknown
`email`	Unknown
`employee_id`	Unknown
`first_name`	Unknown
`hire_date`	Unknown
`home_number`	Unknown
`hourly_wage`	Unknown
`identity_id`	Unknown
`invite_accepted`	Unknown
`invite_status`	Unknown
`invited`	Unknown
`is_new`	Unknown
`language_name`	Unknown
`last_login`	Unknown
`last_name`	Unknown
`max_weekly_hours`	Unknown
`mobile_number`	Unknown
`modified`	Instant
`notes`	Unknown
`notify_ot_risk`	Unknown
`permissions_template_id`	Unknown
`photo`	Unknown
`postal_zip`	Unknown
`preferred_first_name`	Unknown
`preferred_last_name`	Unknown
`pronoun`	Unknown
`prov_state`	Unknown
`punch_id`	Unknown
`push`	Unknown
`skill_level`	Unknown
`sms_me_schedule`	Unknown
`subscribe_to_update`	Unknown
`time_zone`	Unknown
`type`	Unknown
`wage_type`	Unknown
`custom_`

day_part_setting_segment

Column	Type	Keys
`uuid`	Unknown	PK
`company_id`	Unknown	PKFK
`day_part_uuid`	Unknown	PKFK
`day_of_week`	Unknown
`end_time`	Unknown
`start_time`	Unknown

day_part_setting

Column	Type	Keys
`uuid`	Unknown	PK
`company_id`	Unknown	PKFK
`location_id`	Unknown	FK
`created`	Unknown
`modified`	Unknown
`name`	Unknown

location

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`auto_send_log_book_time`	Unknown
`city`	Unknown
`country`	Unknown
`created`	Unknown
`deleted`	Unknown
`department_based_budget`	Unknown
`formatted_address`	Unknown
`fri_hours_close`	Unknown
`fri_hours_open`	Unknown
`fri_is_closed`	Unknown
`hash`	Unknown
`holiday_pay`	Unknown
`latitude`	Unknown
`longitude`	Unknown
`mapping_id`	Unknown
`message`	Unknown
`modified`	Unknown
`mon_hours_close`	Unknown
`mon_hours_open`	Unknown
`mon_is_closed`	Unknown
`name`	Unknown
`place_id`	Unknown
`sat_hours_close`	Unknown
`sat_hours_open`	Unknown
`sat_is_closed`	Unknown
`shift_feedback`	Unknown
`state`	Unknown
`sun_hours_close`	Unknown
`sun_hours_open`	Unknown
`sun_is_closed`	Unknown
`thu_hours_close`	Unknown
`thu_hours_open`	Unknown
`thu_is_closed`	Unknown
`timezone`	Unknown
`timezone_updated`	Unknown
`tue_hours_close`	Unknown
`tue_hours_open`	Unknown
`tue_is_closed`	Unknown
`wed_hours_close`	Unknown
`wed_hours_open`	Unknown
`wed_is_closed`	Unknown

company_inactive_reason

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`inactive_reason`	Unknown

role_station

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`role_id`	Unknown	PKFK
`name`	Unknown
`station_number`	Unknown

role

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`department_id`	Unknown	FK
`location_id`	Unknown	FK
`color`	Unknown
`created`	Unknown
`is_tipped_role`	Unknown
`job_code`	Unknown
`modified`	Unknown
`name`	Unknown
`num_of_stations`	Unknown
`sort`	Unknown

daily_sales_labor

Column	Type	Keys
`_fivetran_id`	String	PK
`department_id`	Unknown	FK
`location_id`	Unknown	FK
`actual_items`	Unknown
`actual_labor_cost`	Unknown
`actual_labor_minutes`	Unknown
`actual_ot_minutes`	Unknown
`actual_sales`	Unknown
`date`	Unknown
`id`	Unknown
`items_per_labor_hour`	Unknown
`labor_percent`	Unknown
`labor_target`	Unknown
`projected_items`	Unknown
`projected_items_override`	Unknown
`projected_items_per_labor_hour`	Unknown
`projected_labor_cost`	Unknown
`projected_labor_minutes`	Unknown
`projected_sales`	Unknown
`projected_sales_override`	Unknown
`projected_sales_per_labor_hour`	Unknown
`sales_per_labor_hour`	Unknown

shift_break

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`shift_id`	Unknown	PKFK
`break_type_id`	Unknown
`end_date`	Unknown
`length`	Unknown
`name`	Unknown
`start_date`	Unknown
`type`	Unknown

shift

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`department_id`	Unknown	FK
`location_id`	Unknown	FK
`role_id`	Unknown	FK
`user_id`	Unknown	FK
`attendance_status`	Unknown
`business_decline`	Unknown
`created`	Unknown
`deleted`	Unknown
`draft`	Unknown
`end_date`	Unknown
`hourly_wage`	Unknown
`is_close`	Unknown
`is_open`	Unknown
`late_minutes`	Unknown
`modified`	Instant
`notes`	Unknown
`notified`	Unknown
`open_offer_type`	Unknown
`publish_status`	Unknown
`soft_deleted`	Unknown
`start_date`	Unknown
`station`	Unknown
`station_id`	Unknown
`station_name`	Unknown
`unassigned`	Unknown
`unassigned_skill_level`	Unknown

receipt_line_external_category

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`receipt_id`	Unknown	PKFK
`receipt_line_index`	Unknown	PKFK
`category_id`	Unknown

receipt_line

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`receipt_id`	Unknown	PKFK
`created`	Unknown
`external_item_id`	Unknown
`gross_item_price`	Unknown
`id`	Unknown
`item_discount`	Unknown
`net_item_price`	Unknown
`price`	Unknown
`quantity`	Unknown

receipt_tip_detail

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`receipt_id`	Unknown	PKFK
`type`	Unknown
`value`	Unknown

receipt

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`location_id`	Unknown	FK
`created_date`	Unknown
`date`	Unknown
`external_user_id`	Unknown
`gross_total`	Unknown
`modified_date`	Instant
`net_total`	Unknown
`pos_id`	Unknown
`receipt_id`	Unknown
`revenue_center`	Unknown
`status`	Unknown
`tips`	Unknown
`total_item_discount`	Unknown
`total_receipt_discount`	Unknown

log_book_category

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`col`	Unknown
`created`	Unknown
`field_type`	Unknown
`name`	Unknown
`notify`	Unknown
`required`	Unknown
`sort`	Unknown
`uuid`	Unknown

shift_feedback

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`shift_id`	Unknown	FK
`comment`	Unknown
`dismissed`	Unknown
`end_date`	Unknown
`notified`	Unknown
`rating`	Unknown
`start_date`	Unknown
`station_name`	Unknown

availability

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`fri_reason`	Unknown	FK
`mon_reason`	Unknown	FK
`old_approved_data_id`	Unknown	FK
`sat_reason`	Unknown	FK
`status_action_user_id`	Unknown	FK
`sun_reason`	Unknown	FK
`thu_reason`	Unknown	FK
`tue_reason`	Unknown	FK
`user_id`	Unknown	FK
`wed_reason`	Unknown	FK
`created`	Unknown
`fri`	Unknown
`fri_comment`	Unknown
`fri_from`	Unknown
`fri_to`	Unknown
`modified`	Unknown
`mon`	Unknown
`mon_comment`	Unknown
`mon_from`	Unknown
`mon_to`	Unknown
`repeat`	Unknown
`sat`	Unknown
`sat_comment`	Unknown
`sat_from`	Unknown
`sat_to`	Unknown
`status`	Unknown
`status_action_message`	Unknown
`sun`	Unknown
`sun_comment`	Unknown
`sun_from`	Unknown
`sun_to`	Unknown
`thu`	Unknown
`thu_comment`	Unknown
`thu_from`	Unknown
`thu_to`	Unknown
`tue`	Unknown
`tue_comment`	Unknown
`tue_from`	Unknown
`tue_to`	Unknown
`wed`	Unknown
`wed_comment`	Unknown
`wed_from`	Unknown
`wed_to`	Unknown
`week`	Unknown
`week_to`	Unknown

task_list_daily_summary_task_list

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`location_id`	Unknown	PKFK
`task_list_daily_summary_date`	Unknown	PKFK
`completion_percentage`	Unknown
`completion_status`	Unknown
`description`	Unknown
`title`	Unknown
`total_tasks`	Unknown
`total_tasks_completed`	Unknown

task_list_daily_summary

Column	Type	Keys
`date`	Unknown	PK
`company_id`	Unknown	PKFK
`location_id`	Unknown	PKFK
`has_recent_task_completed`	Unknown
`report_time`	Unknown
`total_completed_percentage`	Unknown
`total_in_progress_percentage`	Unknown
`total_incomplete_percentage`	Unknown