Breathe HR

Explore the interactive ERD

Table & Field Reference

company_project

Column	Type	Keys
`id`	Unknown	PKFK
`complete`	Unknown
`created_at`	Unknown
`due_on`	Unknown
`name`	Unknown
`updated_at`	Unknown

employee_expense

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`employee_expense_claim_id`	Unknown	FK
`employee_id`	Unknown	FK
`amount`	Unknown
`chargeable_to_client`	Unknown
`client_name`	Unknown
`company_expense_type_id`	Unknown
`company_mileage_rate_id`	Unknown
`company_project_id`	Unknown
`description`	Unknown
`expense_date`	Unknown
`miles`	Unknown
`payable_to_employee`	Unknown
`vat`	Unknown

holiday_allowance

Column	Type	Keys
`id`	Unknown	PK
`amount`	Unknown
`carryover_allowed`	Unknown
`created_at`	Unknown
`depends_on_service`	Unknown
`is_default`	Unknown
`name`	Unknown
`negative_carryover_allowed`	Unknown
`unit`	Unknown
`updated_at`	Unknown
`year_1`	Unknown
`year_10`	Unknown
`year_2`	Unknown
`year_3`	Unknown
`year_4`	Unknown
`year_5`	Unknown
`year_6`	Unknown
`year_7`	Unknown
`year_8`	Unknown
`year_9`	Unknown

bonus

Column	Type	Keys
`id`	Unknown	PK
`amount`	Unknown
`award_date`	Unknown
`created_at`	Unknown
`description`	Unknown
`updated_at`	Unknown

company_document

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`nice_name`	Unknown
`updated_at`	Unknown

employee_expense_claim

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`approver_id`	Unknown	FK
`closed_by_id`	Unknown	FK
`employee_id`	Unknown	FK
`paid_by_id`	Unknown	FK
`rejected_by_id`	Unknown	FK
`approved_date`	Unknown
`closed_date`	Unknown
`description`	Unknown
`employee_expense`	Unknown
`old_claim_status`	Unknown
`paid`	Unknown
`paid_date`	Unknown
`reject_reason`	Unknown
`rejected_date`	Unknown
`remuneration_currency_id`	Unknown
`state`	Unknown
`submitted_date`	Unknown
`third_party_email`	Unknown

working_pattern

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`fri`	Unknown
`fri_hr`	Unknown
`is_default`	Unknown
`mon`	Unknown
`mon_hr`	Unknown
`name`	Unknown
`sat`	Unknown
`sat_hr`	Unknown
`sun`	Unknown
`sun_hr`	Unknown
`thu`	Unknown
`thu_hr`	Unknown
`tue`	Unknown
`tue_hr`	Unknown
`updated_at`	Unknown
`wed`	Unknown
`wed_hr`	Unknown

salary

Column	Type	Keys
`id`	Unknown	PK
`amount`	Unknown
`basis`	Unknown
`created_at`	Unknown
`end_date`	Unknown
`start_date`	Unknown
`updated_at`	Unknown

employee

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`department_id`	Unknown	FK
`division_id`	Unknown	FK
`holiday_allowance_id`	Unknown	FK
`location_id`	Unknown	FK
`working_pattern_id`	Unknown	FK
`address_1`	Unknown
`address_2`	Unknown
`address_3`	Unknown
`age`	Unknown
`bank_branch`	Unknown
`bank_name`	Unknown
`building_society`	Unknown
`city`	Unknown
`contract_provider`	Unknown
`contract_type`	Unknown
`country`	Unknown
`county`	Unknown
`created_at`	Unknown
`ddi`	Unknown
`dob`	Unknown
`driving_license`	Unknown
`duties`	Json
`email`	Unknown
`employee_ref`	Unknown
`ethnicity`	Unknown
`facebook`	Unknown
`first_name`	Unknown
`full_or_part_time`	Unknown
`gender`	Unknown
`holiday_approver`	Unknown
`home_telephone`	Unknown
`hr`	Unknown
`hr_partner_id`	Unknown
`is_line_manager`	Unknown
`job_start_date`	Unknown
`job_title`	Unknown
`join_date`	Unknown
`known_as`	Unknown
`last_name`	Unknown
`leaving_date`	Unknown
`length_of_service_in_month`	Unknown
`line_manager`	Unknown
`linked_in`	Unknown
`marital_status`	Unknown
`middle_name`	Unknown
`national_insurance_no`	Unknown
`nationality`	Unknown
`notice_period`	Unknown
`person_type`	Unknown
`personal_email`	Unknown
`personal_mobile`	Unknown
`postcode`	Unknown
`probation_date`	Unknown
`receives_statutory_holiday`	Unknown
`ref_number`	Unknown
`remuneration_currency_created_at`	Unknown
`remuneration_currency_currency_code`	Unknown
`remuneration_currency_currency_symbol`	Unknown
`remuneration_currency_deleted_at`	Unknown
`remuneration_currency_description`	Unknown
`remuneration_currency_id`	Unknown
`remuneration_currency_updated_at`	Unknown
`salary`	Unknown
`skype`	Unknown
`sort_code`	Unknown
`status`	Unknown
`statutory_holiday_country`	Unknown
`total_working_hour`	Unknown
`twitter`	Unknown
`updated_at`	Unknown
`uuid`	Unknown
`work_ext`	Unknown
`work_mobile`	Unknown
`custom_field_`

benefit

Column	Type	Keys
`id`	Unknown	PK
`amount`	Unknown
`created_at`	Unknown
`employee_contribution`	Unknown
`employer_contribution`	Unknown
`end_date`	Unknown
`pension_opt_out`	Unknown
`provider`	Unknown
`review_date`	Unknown
`start_date`	Unknown
`updated_at`	Unknown

division

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`name`	Unknown
`updated_at`	Unknown

statutory_holiday_country

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`name`	Unknown
`updated_at`	Unknown

company_training_type

Column	Type	Keys
`id`	Unknown	PKFK
`created_at`	Unknown
`name`	Unknown
`updated_at`	Unknown

employee_training_course

Column	Type	Keys
`id`	Unknown	PK
`employee_id`	Unknown	FK
`company_training_category`	Unknown
`company_training_provider`	Unknown
`company_training_type`	Unknown
`cost`	Unknown
`end_on`	Unknown
`expires_on`	Unknown
`follow_up_date`	Unknown
`half_day`	Unknown
`half_day_am_pm`	Unknown
`hour`	Unknown
`name`	Unknown
`note`	Unknown
`outcome`	Unknown
`rejection_reason`	Unknown
`remuneration_currency_id`	Unknown
`start_on`	Unknown
`status`	Unknown

location

Column	Type	Keys
`id`	Unknown	PKFK
`created_at`	Unknown
`name`	Unknown
`updated_at`	Unknown

department

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`name`	Unknown
`updated_at`	Unknown

job

Column	Type	Keys
`employee_id`	Unknown	PKFK
`start_date`	Unknown	FK
`contract_end_date`	Unknown
`created_at`	Unknown
`end_date`	Unknown
`full_time_part_time`	Unknown
`title`	Unknown
`updated_at`	Unknown

other_leave_reason

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`name`	Unknown

account

Column	Type	Keys
`id`	Unknown	PK
`domain`	Unknown
`health_and_safety_enabled`	Unknown
`name`	Unknown
`using_rta`	Unknown
`uuid`	Unknown

change_request

Column	Type	Keys
`id`	Unknown	PK
`approved`	Unknown
`approved_at`	Unknown
`created_at`	Unknown
`field_name`	Unknown
`updated_at`	Unknown
`value`	Unknown

absence

Column	Type	Keys
`id`	Unknown	PK
`employee_id`	Unknown	FK
`approved_by`	Unknown
`cancelled`	Unknown
`created_at`	Unknown
`deducted`	Unknown
`end_date`	Unknown
`half_end`	Unknown
`half_end_am_pm`	Unknown
`half_start`	Unknown
`half_start_am_pm`	Unknown
`leave_reason`	Unknown
`note`	Unknown
`start_date`	Unknown
`type`	Unknown
`updated_at`	Unknown
`work_unit`	Unknown

sickness

Column	Type	Keys
`id`	Unknown	PK
`employee_id`	Unknown	FK
`company_sickness_type`	Unknown
`deducted`	Unknown
`end_date`	Unknown
`fit_note_required`	Unknown
`half_end`	Unknown
`half_end_am_pm`	Unknown
`half_start`	Unknown
`half_start_am_pm`	Unknown
`reason`	Unknown
`review_note`	Unknown
`start_date`	Unknown
`status`	Unknown

leave_request

Column	Type	Keys
`id`	Unknown	PK
`action`	Unknown
`created_at`	Unknown
`end_date`	Unknown
`half_end`	Unknown
`half_end_am_pm`	Unknown
`half_start`	Unknown
`half_start_am_pm`	Unknown
`note`	Unknown
`start_date`	Unknown
`status`	Unknown
`updated_at`	Unknown