# Papershift schema ERD

Table and field reference for the Fivetran Papershift connector.

## Table & Field Reference

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| external_id | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### time_tracking_break

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

### time_tracking_filter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| time_tracking_id | Unknown | PK, FK |
| active | Unknown |  |
| external_id | Unknown |  |
| title | Unknown |  |

### time_tracking

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| location_id | Unknown | FK |
| user_id | Unknown | FK |
| working_area_id | Unknown | FK |
| actual_ends_at | Unknown |  |
| actual_starts_at | Unknown |  |
| break_time | Unknown |  |
| confirmed | Unknown |  |
| created_at | Unknown |  |
| employee_id | Unknown |  |
| end_signature_id | Unknown |  |
| ends_at | Unknown |  |
| filters | Unknown |  |
| is_confirmed | Unknown |  |
| last_edit_by | Unknown |  |
| secure_id | Unknown |  |
| start_signature_id | Unknown |  |
| starts_at | Unknown |  |
| updated_at | Instant |  |

### evaluation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| actual | Unknown |  |
| charged | Unknown |  |
| compensation | Unknown |  |
| created_at | Unknown |  |
| day | Unknown |  |
| payout | Unknown |  |
| plan | Unknown |  |
| target | Unknown |  |
| updated_at | Instant |  |
| vacation | Unknown |  |
| vacation_source_id | Unknown |  |
| vacation_source_type | Unknown |  |

### shifts_tags

| Column | Type | Keys |
| --- | --- | --- |
| shifts_id | Unknown | PK, FK |
| tag_id | Unknown | PK, FK |

### shifts

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| location_id | Unknown | FK |
| working_area_id | Unknown | FK |
| company_id | Unknown |  |
| created_at | Unknown |  |
| edited | Unknown |  |
| ends_at | Unknown |  |
| event_note_content | Unknown |  |
| exact_pause_duration | Unknown |  |
| import_id | Unknown |  |
| note | Unknown |  |
| number_of_employees | Unknown |  |
| outlook_id | Unknown |  |
| recurrence_id | Unknown |  |
| remove | Unknown |  |
| shift_id | Unknown |  |
| starts_at | Unknown |  |
| status | Unknown |  |
| updated_at | Instant |  |
| user_shift | Unknown |  |
| uuid | Unknown |  |
| visible | Unknown |  |

### working_area

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| location_id | Unknown | FK |
| custom_field_values | Json |  |
| external_id | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |

### absence

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| absence_type_external_id | Unknown |  |
| absence_type_id | Unknown |  |
| charge_days_job_status | Unknown |  |
| confirm_message | Unknown |  |
| confirmed | Unknown |  |
| confirmed_at | Unknown |  |
| confirmed_by | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| ends_at | Unknown |  |
| external_id | Unknown |  |
| force_calc_custom_hours | Unknown |  |
| full_day | Unknown |  |
| import_id | Unknown |  |
| note | Unknown |  |
| outlook_id | Unknown |  |
| paid_hours | Unknown |  |
| secure_id | Unknown |  |
| starts_at | Unknown |  |
| status | Unknown |  |
| time_zone | Unknown |  |
| title | Unknown |  |
| updated_at | Instant |  |
| uuid | Unknown |  |
| vacation_days | Unknown |  |

### user_working_area

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

### user_location

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

### user_tags

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

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| abbrev | Unknown |  |
| birthday_level | Unknown |  |
| birthday_value | Unknown |  |
| cost_center_level | Unknown |  |
| cost_center_value | Unknown |  |
| cost_object_level | Unknown |  |
| cost_object_value | Unknown |  |
| descending_level | Unknown |  |
| descending_value | Unknown |  |
| email | Unknown |  |
| end_of_contract_level | Unknown |  |
| end_of_contract_value | Unknown |  |
| enterprise_id | Unknown |  |
| external_id | Unknown |  |
| home_office | Unknown |  |
| initial_time_account | Unknown |  |
| locale | Unknown |  |
| name | Unknown |  |
| phone_level | Unknown |  |
| phone_value | Unknown |  |
| salary | Unknown |  |
| staff_number | Unknown |  |
| start_of_work_level | Unknown |  |
| start_of_work_value | Unknown |  |
| status | Unknown |  |
| trial_period_level | Unknown |  |
| trial_period_value | Unknown |  |
| working_sessions_creator | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| location_id | Unknown | FK |
| active | Unknown |  |
| color | Unknown |  |
| external_id | Unknown |  |
| title | Unknown |  |

## Relationships

- time_tracking_break(time_tracking_id) → time_tracking(id)
- time_tracking_filter(time_tracking_id) → time_tracking(id)
- time_tracking(user_id) → users(id)
- time_tracking(location_id) → location(id)
- time_tracking(working_area_id) → working_area(id)
- evaluation(user_id) → users(id)
- shifts_tags(tag_id) → tags(id)
- shifts_tags(shifts_id) → shifts(id)
- shifts(location_id) → location(id)
- shifts(working_area_id) → working_area(id)
- working_area(location_id) → location(id)
- absence(user_id) → users(id)
- user_working_area(working_area_id) → working_area(id)
- user_working_area(user_id) → users(id)
- user_location(location_id) → location(id)
- user_location(user_id) → users(id)
- user_tags(tag_id) → tags(id)
- user_tags(user_id) → users(id)
- tags(location_id) → location(id)