Leave Dates
Explore the interactive ERD
Table & Field Reference
calendar
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
name | Unknown |
user_profile_employment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_profile_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
created_at | Instant | |
deleted_at | Instant | |
description | Unknown | |
name | Unknown | |
updated_at | Instant |
leave_limit
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
id | Unknown | PKFK |
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 | PKFK |
is_enabled_to_see_employment_own_data | Unknown | |
name | Unknown |
company_role
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
company_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
employments_count | Unknown | |
followers | Json | |
name | Unknown | |
visible_scopes | Json |
leave_timeline
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
leave_detail_id | Unknown | PKFK |
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 |