# 7shifts schema ERD

Table and field reference for the Fivetran 7shifts connector.

## Table & Field Reference

### task_tag

| Column | Type | Keys |
| --- | --- | --- |
| uuid | Unknown | PK |
| task_id | Unknown | PK, FK |
| task_list_id | Unknown | PK, FK |
| user_id | Unknown | FK |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| task_list_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| time_punch_id | Unknown | PK, FK |
| custom_break_id | Unknown |  |
| in_time | Unknown |  |
| out_time | Unknown |  |
| paid | Unknown |  |

### time_punch

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| 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 | PK, FK |
| event_id | Unknown | PK, FK |
| location_id | Unknown | FK |

### event_start

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| date_time | Unknown |  |

### event_end

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| date_time | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| 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 | PK, FK |
| user_id | Unknown | PK, FK |
| 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 | PK, FK |
| comment_required | Unknown |  |
| created | Unknown |  |
| modified | Unknown |  |
| reason | Unknown |  |
| sort | Unknown |  |

### daily_stats_interval

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| 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 | PK, FK |
| log_book_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| user_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| log_book_post_id | Unknown | PK, FK |
| file_name | Unknown |  |
| full_path | Unknown |  |

### log_book_post

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| 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 | PK, FK |
| id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### user_department_assignment

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| appear_on_schedule | Unknown |  |

### user_role_assignment

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| is_primary | Unknown |  |
| skill_level | Unknown |  |

### task_template

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| task_list_template_id | Unknown | PK, FK |
| 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 | PK, FK |
| task_list_template_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| time_off_id | Unknown | PK, FK |
| date | Unknown |  |
| hours | Unknown |  |

### time_off

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| day_part_uuid | Unknown | PK, FK |
| day_of_week | Unknown |  |
| end_time | Unknown |  |
| start_time | Unknown |  |

### day_part_setting

| Column | Type | Keys |
| --- | --- | --- |
| uuid | Unknown | PK |
| company_id | Unknown | PK, FK |
| location_id | Unknown | FK |
| created | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| 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 | PK, FK |
| inactive_reason | Unknown |  |

### role_station

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| role_id | Unknown | PK, FK |
| name | Unknown |  |
| station_number | Unknown |  |

### role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| 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 | PK, FK |
| shift_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| receipt_id | Unknown | PK, FK |
| receipt_line_index | Unknown | PK, FK |
| category_id | Unknown |  |

### receipt_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| receipt_id | Unknown | PK, FK |
| 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 | PK, FK |
| receipt_id | Unknown | PK, FK |
| type | Unknown |  |
| value | Unknown |  |

### receipt

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| location_id | Unknown | PK, FK |
| task_list_daily_summary_date | Unknown | PK, FK |
| 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 | PK, FK |
| location_id | Unknown | PK, FK |
| has_recent_task_completed | Unknown |  |
| report_time | Unknown |  |
| total_completed_percentage | Unknown |  |
| total_in_progress_percentage | Unknown |  |
| total_incomplete_percentage | Unknown |  |

## Relationships

- task_tag(task_id) → task(id)
- task_tag(user_id) → users(id)
- task_tag(task_list_id) → task(task_list_id)
- task(task_template_uuid) → task_list_template(uuid)
- task(user_id) → users(id)
- task(task_completion_event_user_id) → users(id)
- task(task_list_id) → task_list(id)
- task_list_assignment(company_id) → company(id)
- task_list_assignment(location_id) → location(id)
- task_list_assignment(department_id) → department(id)
- task_list_assignment(role_id) → role(id)
- task_list_assignment(user_id) → users(id)
- task_list_assignment(task_list_id) → task_list(id)
- task_list(company_id) → company(id)
- task_list(location_id) → location(id)
- time_punch_break(company_id) → time_punch(company_id)
- time_punch_break(time_punch_id) → time_punch(id)
- time_punch(user_id) → users(id)
- time_punch(shift_id) → shift(id)
- time_punch(department_id) → department(id)
- time_punch(role_id) → role(id)
- time_punch(location_id) → location(id)
- time_punch(company_id) → company(id)
- event_location(location_id) → location(id)
- event_location(event_id) → event(id)
- event_location(company_id) → event(company_id)
- event_start(event_id) → event(id)
- event_start(company_id) → event(company_id)
- event_end(event_id) → event(id)
- event_end(company_id) → event(company_id)
- event(company_id) → company(id)
- engage_overview(most_reliable_user_id) → users(id)
- engage_overview(most_eager_user_id) → users(id)
- engage_overview(most_sick_user_id) → users(id)
- engage_overview(most_late_user_id) → users(id)
- engage_overview(most_drops_user_id) → users(id)
- engage_overview(company_id) → company(id)
- engage_overview(location_id) → location(id)
- engage_overview_score(user_id) → users(id)
- engage_overview_score(_fivetran_id) → engage_overview(_fivetran_id)
- engage_overview_score(company_id) → engage_overview(_fivetran_id)
- engage_overview_score(location_id) → engage_overview(_fivetran_id)
- availability_reason(company_id) → company(id)
- daily_stats_interval(_fivetran_id) → daily_stats(_fivetran_id)
- daily_stats(company_id) → company(id)
- daily_stats(location_id) → location(id)
- log_book_comment(log_book_id) → log_book_post(id)
- log_book_comment(user_id) → users(id)
- log_book_comment(company_id) → company(id)
- company_labour_setting_custom_min_wage(company_id) → company_labour_setting(company_id)
- company_labour_setting(company_id) → company(id)
- user_wage(role_id) → role(id)
- user_wage(company_id) → company(id)
- user_wage(user_id) → users(id)
- department(company_id) → company(id)
- department(location_id) → location(id)
- log_book_post_attachment(log_book_post_id) → log_book_post(id)
- log_book_post_attachment(company_id) → log_book_post(company_id)
- log_book_post(user_id) → users(id)
- log_book_post(log_book_category_id) → log_book_category(id)
- log_book_post(location_id) → location(id)
- log_book_post(company_id) → company(id)
- user_location_assignment(id) → location(id)
- user_location_assignment(company_id) → company(id)
- user_location_assignment(user_id) → users(id)
- user_department_assignment(id) → department(id)
- user_department_assignment(company_id) → company(id)
- user_department_assignment(user_id) → users(id)
- user_role_assignment(id) → role(id)
- user_role_assignment(company_id) → company(id)
- user_role_assignment(user_id) → users(id)
- task_template(task_list_template_id) → task_list_template(id)
- task_template(company_id) → task_list_template(company_id)
- task_list_template_assignment(location_id) → location(id)
- task_list_template_assignment(department_id) → department(id)
- task_list_template_assignment(role_id) → role(id)
- task_list_template_assignment(user_id) → users(id)
- task_list_template_assignment(task_list_template_id) → task_list_template(id)
- task_list_template_assignment(company_id) → task_list_template(company_id)
- task_list_template(company_id) → company(id)
- task_management_setting(company_id) → company(id)
- time_off_hour(time_off_id) → time_off(id)
- time_off_hour(company_id) → time_off(company_id)
- time_off(user_id) → users(id)
- time_off(status_action_user_id) → users(id)
- time_off(company_id) → company(id)
- users(company_id) → company(id)
- day_part_setting_segment(day_part_uuid) → day_part_setting(uuid)
- day_part_setting_segment(company_id) → day_part_setting(company_id)
- day_part_setting(location_id) → location(id)
- day_part_setting(company_id) → company(id)
- location(company_id) → company(id)
- company_inactive_reason(company_id) → company(id)
- role_station(role_id) → role(id)
- role_station(company_id) → role(company_id)
- role(department_id) → department(id)
- role(location_id) → location(id)
- role(company_id) → company(id)
- daily_sales_labor(department_id) → department(id)
- daily_sales_labor(location_id) → location(id)
- shift_break(shift_id) → shift(id)
- shift_break(company_id) → shift(company_id)
- shift(user_id) → users(id)
- shift(department_id) → department(id)
- shift(role_id) → role(id)
- shift(location_id) → location(id)
- shift(company_id) → company(id)
- receipt_line_external_category(receipt_line_index) → receipt_line(index)
- receipt_line_external_category(receipt_id) → receipt_line(receipt_id)
- receipt_line_external_category(company_id) → receipt_line(company_id)
- receipt_line(receipt_id) → receipt(id)
- receipt_line(company_id) → receipt(company_id)
- receipt_tip_detail(receipt_id) → receipt(id)
- receipt_tip_detail(company_id) → receipt(company_id)
- receipt(location_id) → location(id)
- receipt(company_id) → company(id)
- log_book_category(company_id) → company(id)
- shift_feedback(shift_id) → shift(id)
- shift_feedback(company_id) → company(id)
- availability(thu_reason) → availability_reason(id)
- availability(user_id) → users(id)
- availability(sat_reason) → availability_reason(id)
- availability(fri_reason) → availability_reason(id)
- availability(wed_reason) → availability_reason(id)
- availability(tue_reason) → availability_reason(id)
- availability(sun_reason) → availability_reason(id)
- availability(mon_reason) → availability_reason(id)
- availability(old_approved_data_id) → availability(id)
- availability(status_action_user_id) → users(id)
- availability(company_id) → company(id)
- task_list_daily_summary_task_list(task_list_daily_summary_date) → task_list_daily_summary(date)
- task_list_daily_summary_task_list(location_id) → task_list_daily_summary(location_id)
- task_list_daily_summary_task_list(company_id) → task_list_daily_summary(company_id)
- task_list_daily_summary(company_id) → company(id)
- task_list_daily_summary(location_id) → location(id)