Clockodo
Explore the interactive ERD
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 | PKFK |
user_id | Unknown | PKFK |
week_number | Unknown | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
year | String | PKFK |
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 | PKFK |
year | String | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
time_since | Unknown | |
time_until | Unknown |
worktime
| Column | Type | Keys |
|---|---|---|
date | LocalDate | PK |
user_id | Unknown | PKFK |
offsets | Unknown |