# Clockodo schema ERD

Table and field reference for the Fivetran Clockodo connector.

## Table & Field Reference

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| active | Unknown |  |
| billable_default | Unknown |  |
| billed_completely | Unknown |  |
| billed_money | Unknown |  |
| budget_is_hours | Unknown |  |
| budget_is_not_strict | Unknown |  |
| budget_money | Unknown |  |
| completed | Unknown |  |
| completed_at | Unknown |  |
| deadline | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| number | Unknown |  |
| revenue_factor | Unknown |  |
| test_data | Unknown |  |

### entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| project_id | Unknown | FK |
| user_id | Unknown | FK |
| billable | Unknown |  |
| clocked | Unknown |  |
| clocked_offline | Unknown |  |
| duration | Unknown |  |
| hourly_rate | Unknown |  |
| revenue | Unknown |  |
| service_id | Unknown |  |
| service_name | Unknown |  |
| test_data | Unknown |  |
| text | Unknown |  |
| text_id | Unknown |  |
| time_clocked_since | Unknown |  |
| time_insert | Unknown |  |
| time_last_change | Unknown |  |
| time_last_change_work_time | Unknown |  |
| time_since | Unknown |  |
| time_until | Unknown |  |
| type | Unknown |  |

### target_hour

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| surcharge_id | Unknown | FK |
| user_id | Unknown | FK |
| absence_fixed_credit | Unknown |  |
| compensation_daily | Unknown |  |
| compensation_monthly | Unknown |  |
| date_since | Unknown |  |
| date_until | Unknown |  |
| friday | Unknown |  |
| monday | Unknown |  |
| saturday | Unknown |  |
| sunday | Unknown |  |
| test_data | Unknown |  |
| thursday | Unknown |  |
| tuesday | Unknown |  |
| type | Unknown |  |
| wednesday | Unknown |  |

### user_report_day_detail

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| month_number | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| week_number | Unknown | PK, FK |
| count_absence_home_office | Unknown |  |
| count_absence_maternity_protection | Unknown |  |
| count_absence_military_service | Unknown |  |
| count_absence_out_of_office | Unknown |  |
| count_absence_quarantine | Unknown |  |
| count_absence_regular_holidays | Unknown |  |
| count_absence_school | Unknown |  |
| count_absence_sick_child | Unknown |  |
| count_absence_sick_self | Unknown |  |
| count_absence_special_leaves | Unknown |  |
| count_reduction_used | Unknown |  |
| diff | Unknown |  |
| hours | Unknown |  |
| hours_without_compensation | Unknown |  |
| nonbusiness | Unknown |  |
| surcharges_night | Unknown |  |
| surcharges_night_increased | Unknown |  |
| surcharges_nonbusiness | Unknown |  |
| surcharges_nonbusiness_special | Unknown |  |
| surcharges_saturday | Unknown |  |
| surcharges_sunday | Unknown |  |
| target | Unknown |  |
| target_raw | Unknown |  |
| weekday | Unknown |  |
| work_end | Unknown |  |
| work_start | Unknown |  |

### user_report_week_detail

| Column | Type | Keys |
| --- | --- | --- |
| week_number | Unknown | PK |
| month_number | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| year | String | PK, FK |
| diff | Unknown |  |
| sum_hours | Unknown |  |
| sum_reduction_used | Unknown |  |
| sum_target | Unknown |  |
| surcharges_night | Unknown |  |
| surcharges_night_increased | Unknown |  |
| surcharges_nonbusiness | Unknown |  |
| surcharges_nonbusiness_special | Unknown |  |
| surcharges_saturday | Unknown |  |
| surcharges_sunday | Unknown |  |

### user_report_month_detail

| Column | Type | Keys |
| --- | --- | --- |
| month_number | Unknown | PK |
| user_id | Unknown | PK, FK |
| year | String | PK, FK |
| diff | Unknown |  |
| sum_hours | Unknown |  |
| sum_hours_without_compensation | Unknown |  |
| sum_overtime_reduced | Unknown |  |
| sum_reduction_used | Unknown |  |
| sum_target | Unknown |  |
| surcharges_night | Unknown |  |
| surcharges_night_increased | Unknown |  |
| surcharges_nonbusiness | Unknown |  |
| surcharges_nonbusiness_special | Unknown |  |
| surcharges_saturday | Unknown |  |
| surcharges_sunday | Unknown |  |

### user_report

| Column | Type | Keys |
| --- | --- | --- |
| year | String | PK |
| user_id | Unknown | PK, FK |
| diff | Unknown |  |
| holidays_carry | Unknown |  |
| holidays_quota | Unknown |  |
| overtime_carryover | Unknown |  |
| overtime_reduced | Unknown |  |
| sum_absence_home_office | Unknown |  |
| sum_absence_maternity_protection | Unknown |  |
| sum_absence_military_service | Unknown |  |
| sum_absence_out_of_office | Unknown |  |
| sum_absence_quarantine | Unknown |  |
| sum_absence_regular_holidays | Unknown |  |
| sum_absence_school | Unknown |  |
| sum_absence_sick_child | Unknown |  |
| sum_absence_sick_self | Unknown |  |
| sum_absence_special_leaves | Unknown |  |
| sum_hours | Unknown |  |
| sum_reduction_planned | Unknown |  |
| sum_reduction_used | Unknown |  |
| sum_target | Unknown |  |
| surcharges_night | Unknown |  |
| surcharges_night_increased | Unknown |  |
| surcharges_nonbusiness | Unknown |  |
| surcharges_nonbusiness_special | Unknown |  |
| surcharges_saturday | Unknown |  |
| surcharges_sunday | Unknown |  |
| workdays | Unknown |  |

### worktime_interval_change

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| worktime_change_request_id | Unknown | PK, FK |
| time_since | Unknown |  |
| time_until | Unknown |  |
| type | Unknown |  |

### worktime_change_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| declined_by_id | Unknown | FK |
| user_id | Unknown | FK |
| date | Unknown |  |
| declined_at | Unknown |  |
| status | Unknown |  |

### surcharge

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accumulation | Unknown |  |
| name | Unknown |  |
| night_increased_percent | Unknown |  |
| night_increased_time_since | Unknown |  |
| night_increased_time_since_is_previous_day | Unknown |  |
| night_increased_time_until | Unknown |  |
| night_increased_time_until_is_next_day | Unknown |  |
| night_percent | Unknown |  |
| night_time_since | Unknown |  |
| night_time_since_is_previous_day | Unknown |  |
| night_time_until | Unknown |  |
| night_time_until_is_next_day | Unknown |  |
| nonbusiness_percent | Unknown |  |
| nonbusiness_special_percent | Unknown |  |
| nonbusiness_special_time_since | Unknown |  |
| nonbusiness_special_time_since_is_previous_day | Unknown |  |
| nonbusiness_special_time_until | Unknown |  |
| nonbusiness_special_time_until_is_next_day | Unknown |  |
| nonbusiness_time_since | Unknown |  |
| nonbusiness_time_since_is_previous_day | Unknown |  |
| nonbusiness_time_until | Unknown |  |
| nonbusiness_time_until_is_next_day | Unknown |  |
| saturday_percent | Unknown |  |
| saturday_time_since | Unknown |  |
| saturday_time_since_is_previous_day | Unknown |  |
| saturday_time_until | Unknown |  |
| saturday_time_until_is_next_day | Unknown |  |
| sunday_percent | Unknown |  |
| sunday_time_since | Unknown |  |
| sunday_time_since_is_previous_day | Unknown |  |
| sunday_time_until | Unknown |  |
| sunday_time_until_is_next_day | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| billable_default | Unknown |  |
| color | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| number | Unknown |  |
| test_data | Unknown |  |

### absence

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| approved_by | Unknown | FK |
| user_id | Unknown | FK |
| count_days | Unknown |  |
| count_hours | Unknown |  |
| date_approved | Unknown |  |
| date_enquired | Unknown |  |
| date_since | Unknown |  |
| date_until | Unknown |  |
| note | Unknown |  |
| sick_note | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leader | Unknown | FK |
| name | Unknown |  |

### carryover_time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| hours | Unknown |  |
| note | Unknown |  |
| year | Unknown |  |

### user_absence_manager

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

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | FK |
| active | Unknown |  |
| boss | Unknown |  |
| can_add_customers | Unknown |  |
| can_generally_manage_absences | Unknown |  |
| can_generally_see_absences | Unknown |  |
| creator | Unknown |  |
| default_holidays_count | Unknown |  |
| default_target_hours | Unknown |  |
| edit_lock | Unknown |  |
| edit_lock_dyn | Unknown |  |
| edit_lock_sync | Unknown |  |
| email | Unknown |  |
| initials | Unknown |  |
| languages | Unknown |  |
| name | Unknown |  |
| nonbusinessgroups_id | Unknown |  |
| number | Unknown |  |
| role | Unknown |  |
| timeformat_12_h | Unknown |  |
| timezone | Unknown |  |
| wage_type | Unknown |  |
| weekend_friday | Unknown |  |
| weekstart_monday | Unknown |  |
| worktime_edit_lock_days | Unknown |  |
| worktime_regulation_id | Unknown |  |

### worktime_interval

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| date | LocalDate | PK, FK |
| user_id | Unknown | PK, FK |
| time_since | Unknown |  |
| time_until | Unknown |  |

### worktime

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| user_id | Unknown | PK, FK |
| offsets | Unknown |  |

## Relationships

- project(customer_id) → customer(id)
- entry(user_id) → users(id)
- entry(customer_id) → customer(id)
- entry(project_id) → project(id)
- target_hour(user_id) → users(id)
- target_hour(surcharge_id) → surcharge(id)
- user_report_day_detail(user_id) → user_report_week_detail(user_id)
- user_report_day_detail(month_number) → user_report_week_detail(month_number)
- user_report_day_detail(week_number) → user_report_week_detail(week_number)
- user_report_week_detail(user_id) → user_report_month_detail(user_id)
- user_report_week_detail(year) → user_report_month_detail(year)
- user_report_week_detail(month_number) → user_report_month_detail(month_number)
- user_report_month_detail(user_id) → user_report(user_id)
- user_report_month_detail(year) → user_report(year)
- user_report(user_id) → users(id)
- worktime_interval_change(worktime_change_request_id) → worktime_change_request(id)
- worktime_change_request(user_id) → users(id)
- worktime_change_request(declined_by_id) → users(id)
- absence(user_id) → users(id)
- absence(approved_by) → users(id)
- team(leader) → users(id)
- carryover_time(user_id) → users(id)
- user_absence_manager(id) → users(id)
- user_absence_manager(user_id) → users(id)
- users(team_id) → team(id)
- worktime_interval(user_id) → worktime(user_id)
- worktime_interval(date) → worktime(date)
- worktime(user_id) → users(id)