# Leave Dates schema ERD

Table and field reference for the Fivetran Leave Dates connector.

## Table & Field Reference

### calendar

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| created_at | Instant |  |
| deleted_at | Instant |  |
| end_date | LocalDate |  |
| hidden | Unknown |  |
| leave_owner_count | Unknown |  |
| leave_request_count | Unknown |  |
| owner_id | Unknown |  |
| start_date | LocalDate |  |
| updated_at | Instant |  |

### country

| Column | Type | Keys |
| --- | --- | --- |
| iso_code | Unknown | PK |
| flag | Unknown |  |
| name | Unknown |  |

### leave_detail_breakdown

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leave_detail_id | Unknown | PK, FK |
| duration | Unknown |  |
| duration_in_minutes | Unknown |  |
| from_date | Instant |  |
| period | Unknown |  |
| to_date | Instant |  |
| type | Unknown |  |

### leave_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| allowance_type_id | Unknown | FK |
| creator_id | Unknown | FK |
| leave_type_id | Unknown | FK |
| owner_id | Unknown | FK |
| allowance_unit_is_day | Unknown |  |
| created_at | Unknown |  |
| deducted_allowance_amount | Double |  |
| deducted_allowance_unit | Unknown |  |
| from_date | Instant |  |
| is_private | Unknown |  |
| leave_duration_days | Unknown |  |
| leave_duration_hours | Unknown |  |
| leave_duration_minutes | Unknown |  |
| minutes_per_working_day | Unknown |  |
| owner_user_id | Unknown |  |
| reason | Unknown |  |
| status | Unknown |  |
| timezone | Unknown |  |
| to_date | Instant |  |
| updated_at | Unknown |  |
| working_schedule_id | Unknown |  |

### user_profile_company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_profile_id | Unknown | PK, FK |
| name | Unknown |  |

### user_profile_employment

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

### user_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| avatar | Unknown |  |
| avatar_url | Unknown |  |
| created_at | Instant |  |
| date_of_birth | LocalDate |  |
| disable_email | Unknown |  |
| email | Unknown |  |
| enabled_slack_reports_count | Unknown |  |
| feed_last_read_at | Unknown |  |
| full_name | Unknown |  |
| is_review_reminders_enabled | Unknown |  |
| keep_leave_private | Unknown |  |
| last_logged_at | Unknown |  |
| settings_date_format | Unknown |  |
| settings_default_company | Unknown |  |
| settings_enable_comment_email | Unknown |  |
| settings_in_24_hour_clock | Unknown |  |
| share_birthday | Unknown |  |
| slack_reports_count | Unknown |  |
| updated_at | Instant |  |
| verification_pending_email | Unknown |  |
| verified_at | Unknown |  |

### employment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| department_id | Unknown | FK |
| avatar_url | Unknown |  |
| created_at | Instant |  |
| deleted_at | Instant |  |
| email | Unknown |  |
| full_name | Unknown |  |
| holiday_location | Unknown |  |
| is_admin | Unknown |  |
| is_approver | Unknown |  |
| is_hidden | Unknown |  |
| scheduled_permanent_deletion_on | Unknown |  |
| status | Unknown |  |
| timezone | Unknown |  |
| updated_at | Instant |  |

### report_employment

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| allowance_unit | Unknown |  |
| date_of_birth | Unknown |  |
| department_name | Unknown |  |
| email | Unknown |  |
| employee_code | Unknown |  |
| end_date | LocalDate |  |
| full_name | Unknown |  |
| holiday_location | Unknown |  |
| hours_per_working_day | Unknown |  |
| is_admin | Unknown |  |
| is_approver | Unknown |  |
| job_title | Unknown |  |
| start_date | Instant |  |
| timezone | Unknown |  |
| years_of_service | Double |  |

### allowance_breakdown

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allowance_type_id | Unknown | PK, FK |
| amount_in_minutes | Unknown |  |
| created_at | Instant |  |
| deleted_at | Unknown |  |
| minutes_per_working_day | Unknown |  |
| name | Unknown |  |
| policy_settings_allocation_type | Unknown |  |
| policy_settings_expiry_duration | Unknown |  |
| policy_settings_expiry_duration_unit | Unknown |  |
| policy_settings_max_amount_in_minute | Unknown |  |
| policy_settings_type | Unknown |  |
| updated_at | Instant |  |

### allowance_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| created_at | Instant |  |
| deleted_at | Instant |  |
| description | Unknown |  |
| name | Unknown |  |
| updated_at | Instant |  |

### leave_limit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| department_id | Unknown | FK |
| amount | Unknown |  |
| can_request_leave_when_limit_exceeds | Unknown |  |
| from_date | LocalDate |  |
| to_date | LocalDate |  |

### leave_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| allowance_type_id | Unknown | FK |
| accounts_to_conflicts | Unknown |  |
| approval | Unknown |  |
| colour | Unknown |  |
| created_at | Instant |  |
| deleted_at | Instant |  |
| description | Unknown |  |
| display_code | Unknown |  |
| display_icon | Unknown |  |
| is_default | Unknown |  |
| is_holiday | Unknown |  |
| is_private | Unknown |  |
| is_reason_public | Unknown |  |
| name | Unknown |  |
| only_admin | Unknown |  |
| updated_at | Instant |  |

### report_leave

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| amount | Unknown |  |
| department_name | Unknown |  |
| employee_code | Unknown |  |
| from_time | Instant |  |
| full_name | Unknown |  |
| private | Unknown |  |
| reason | Unknown |  |
| requested_at | Instant |  |
| status | Unknown |  |
| status_updated_at | Instant |  |
| status_updated_by | Unknown |  |
| timezone | Unknown |  |
| to_time | Instant |  |
| type | Unknown |  |
| unit | Unknown |  |

### company_department

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

### company_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| role | Unknown |  |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allow_calendar_align_to_start_date | Unknown |  |
| allow_employees_to_request_overtime | Unknown |  |
| allowance_accrual_enabled | Unknown |  |
| allowance_unit_is_day | Unknown |  |
| billing_status | Unknown |  |
| calendar_settings_create_before_month | Unknown |  |
| calendar_settings_hide_after_month | Unknown |  |
| calendar_settings_manage_automatically | Unknown |  |
| calendar_start_day | Unknown |  |
| calendar_start_month | Unknown |  |
| current_billing_plan | Unknown |  |
| domain_name | Unknown |  |
| employments_count | Unknown |  |
| first_day_of_week | Unknown |  |
| holiday_settings_create_before_month | Unknown |  |
| holiday_settings_manage_automatically | Unknown |  |
| manually_billed | Unknown |  |
| minutes_per_working_day | Unknown |  |
| name | Unknown |  |
| owner_id | Unknown |  |
| sso_enforced | Unknown |  |

### report_detail_allowance

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| allowance_type_id | Unknown | FK |
| company_id | Unknown | FK |
| employment_id | Unknown | FK |
| accrued_allowance | Unknown |  |
| allowance_unit | Unknown |  |
| annual_allowance | Unknown |  |
| booked_allowance | Unknown |  |
| calendar_end_date | Unknown |  |
| calendar_start_date | Unknown |  |
| carried_allowance_to_next_year | Unknown |  |
| carry_over_allowance | Unknown |  |
| carry_over_expiry_date | Unknown |  |
| department_name | Unknown |  |
| expired_carry_over_allowance | Unknown |  |
| has_time_off_in_lieu | Unknown |  |
| is_carry_over_locked | Unknown |  |
| is_unlimited | Unknown |  |
| minutes_per_working_day | Unknown |  |
| remaining_to_book | Unknown |  |
| remaining_to_take | Unknown |  |
| taken_allowance | Unknown |  |
| taken_carry_over_allowance | Unknown |  |
| time_off_in_lieu | Unknown |  |
| total_allowance | Unknown |  |

### department_approver

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| department_id | Unknown | PK, FK |
| company_id | Unknown | FK |
| align_allowance_to_start_date | Unknown |  |
| allowance_unit_is_day | Unknown |  |
| archived_at | Unknown |  |
| avatar | Unknown |  |
| avatar_url | Unknown |  |
| created_at | Unknown |  |
| date_of_birth | Unknown |  |
| deleted_at | Unknown |  |
| email | Unknown |  |
| employee_code | Unknown |  |
| end_date | Unknown |  |
| full_name | Unknown |  |
| holiday_location | Unknown |  |
| holiday_location_migrated_at | Unknown |  |
| is_admin | Unknown |  |
| is_approver | Unknown |  |
| is_enabled_to_see_employment_own_data | Unknown |  |
| is_hidden | Unknown |  |
| job_title | Unknown |  |
| minutes_per_working_day | Unknown |  |
| pivot_approvable_id | Unknown |  |
| pivot_approvable_type | Unknown |  |
| pivot_approver_id | Unknown |  |
| pivot_created_at | Unknown |  |
| pivot_updated_at | Unknown |  |
| settings_company_schedule_filter | Unknown |  |
| settings_company_schedule_order | Unknown |  |
| settings_leave_request_allowance_deduction_report_type | Unknown |  |
| start_date | Unknown |  |
| timezone | Unknown |  |
| updated_at | Unknown |  |
| user_id | Unknown |  |

### department

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| employments_count | Unknown |  |
| followers | Json |  |
| name | Unknown |  |
| visible_scopes | Json |  |

### leave_timeline

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leave_detail_id | Unknown | PK, FK |
| actor_avatar_url | Unknown |  |
| actor_full_name | Unknown |  |
| actor_id | Unknown |  |
| created_at | Instant |  |
| deleted_at | Instant |  |
| event_class | Unknown |  |
| resource_id | Unknown |  |
| resource_type | Unknown |  |
| updated_at | Instant |  |

## Relationships

- calendar(company_id) → company(id)
- leave_detail_breakdown(leave_detail_id) → leave_detail(id)
- leave_detail(leave_type_id) → leave_type(id)
- leave_detail(owner_id) → employment(id)
- leave_detail(allowance_type_id) → allowance_type(id)
- leave_detail(creator_id) → employment(id)
- leave_detail(company_id) → company(id)
- user_profile_company(user_profile_id) → user_profile(id)
- user_profile_employment(user_profile_id) → user_profile(id)
- employment(department_id) → department(id)
- employment(company_id) → company(id)
- report_employment(id) → employment(id)
- report_employment(company_id) → company(id)
- allowance_breakdown(allowance_type_id) → allowance_type(id)
- allowance_type(company_id) → company(id)
- leave_limit(department_id) → department(id)
- leave_limit(company_id) → company(id)
- leave_type(allowance_type_id) → allowance_type(id)
- leave_type(company_id) → company(id)
- report_leave(id) → leave_detail(id)
- report_leave(company_id) → company(id)
- company_department(company_id) → company(id)
- company_role(company_id) → company(id)
- report_detail_allowance(allowance_type_id) → allowance_type(id)
- report_detail_allowance(employment_id) → employment(id)
- report_detail_allowance(company_id) → company(id)
- department_approver(company_id) → company(id)
- department_approver(department_id) → department(id)
- department(company_id) → company(id)
- leave_timeline(leave_detail_id) → leave_detail(id)