Fivetran documentation

Search the docs

/

Papershift

Explore the interactive ERD

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	PKFK

time_tracking_filter

Column	Type	Keys
`id`	Unknown	PK
`time_tracking_id`	Unknown	PKFK
`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	PKFK
`tag_id`	Unknown	PKFK

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

user_location

Column	Type	Keys
`location_id`	Unknown	PKFK
`user_id`	Unknown	PKFK

user_tags

Column	Type	Keys
`tag_id`	Unknown	PKFK
`user_id`	Unknown	PKFK

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