# Jibble schema ERD

Table and field reference for the Fivetran Jibble connector.

## Table & Field Reference

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address | Unknown |  |
| code | Unknown |  |
| coordinates_latitude | Unknown |  |
| coordinates_longitude | Unknown |  |
| geo_fence_radius | Unknown |  |
| geo_fence_units | Unknown |  |
| name | Unknown |  |
| odata_etag | Unknown |  |

### member_overridden_property

| Column | Type | Keys |
| --- | --- | --- |
| overridden_property | Unknown | PK |
| member_id | Unknown | PK, FK |

### member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| organization_id | Unknown | FK |
| schedule_id | Unknown | FK |
| calendar_id | Unknown |  |
| code | Unknown |  |
| country_code | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| full_name | Unknown |  |
| has_embedding | Unknown |  |
| invited_at | Unknown |  |
| join_date | Unknown |  |
| kiosk | Json |  |
| latest_time_entry_time | Unknown |  |
| managed_unit | Json |  |
| manager | Json |  |
| nfc_token | Unknown |  |
| odata_etag | Unknown |  |
| phone_number | Unknown |  |
| picture | Unknown |  |
| pin_code | Unknown |  |
| position_id | Unknown |  |
| preferred_name | Unknown |  |
| project | Json |  |
| removed_at | Unknown |  |
| role | Unknown |  |
| status | Unknown |  |
| unit_time_off_policies | Json |  |
| updated_at | Instant |  |
| user_id | Unknown |  |
| work_start_date | Unknown |  |
| work_types | Json |  |
| custom_** |  |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| face_recognition_model_id | Unknown |  |
| name | Unknown |  |
| odata_etag | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |
| custom_** |  |  |

### role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| description | Unknown |  |
| do_propagate_name | Unknown |  |
| name | Unknown |  |
| orders | Unknown |  |
| organization_role_policy | Json |  |
| role_policies | Json |  |
| user_roles | Json |  |

### time_off_holiday

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| time_off_overview_id | Unknown | PK, FK |
| is_short_day | Unknown |  |
| name | Unknown |  |
| rule | Json |  |

### time_off_overview

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| person_id | Unknown | FK |
| duration | Unknown |  |
| end_date | Unknown |  |
| end_time | Unknown |  |
| kind | Unknown |  |
| note | Unknown |  |
| part_day_leave_duration | Unknown |  |
| part_of_day | Unknown |  |
| policy_id | Unknown |  |
| start_date | Instant |  |
| start_time | Unknown |  |
| status | Unknown |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| schedule_id | Unknown | FK |
| activity | Json |  |
| calendar_id | Unknown |  |
| created_at | Unknown |  |
| first_approver | Json |  |
| kiosk | Json |  |
| manager | Json |  |
| name | Unknown |  |
| odata_etag | Unknown |  |
| overridden_property | Json |  |
| project | Json |  |
| second_approvers | Json |  |
| status | Unknown |  |
| unit_time_off_policy | Json |  |
| updated_at | Instant |  |
| work_type | Json |  |
| custom_** |  |  |

### timesheet_auto_deduction

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| date | Unknown | PK, FK |
| timesheet_id | Unknown | PK, FK |
| duration | Unknown |  |
| name | Unknown |  |
| threshold | Unknown |  |

### timesheet_daily

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| timesheet_id | Unknown | PK, FK |
| daily_double_overtime_is_edited | Unknown |  |
| daily_double_overtime_payroll_hour_id | Unknown |  |
| daily_double_overtime_time | Unknown |  |
| daily_overtime_is_edited | Unknown |  |
| daily_overtime_payroll_hour_id | Unknown |  |
| daily_overtime_time | Unknown |  |
| end_offset | Unknown |  |
| end_time | Unknown |  |
| first_in | Unknown |  |
| first_in_location_id | Unknown |  |
| first_in_offset | Unknown |  |
| first_in_timestamp | Unknown |  |
| has_archived_screenshots | Unknown |  |
| last_out | Unknown |  |
| last_out_location_id | Unknown |  |
| last_out_offset | Unknown |  |
| last_out_timestamp | Unknown |  |
| payroll_hours_billing | Unknown |  |
| payroll_hours_total | Unknown |  |
| public_holiday_overtime_is_edited | Unknown |  |
| public_holiday_overtime_payroll_hour_id | Unknown |  |
| public_holiday_overtime_time | Unknown |  |
| regular_is_edited | Unknown |  |
| regular_payroll_hour_id | Unknown |  |
| regular_time | Unknown |  |
| rest_day_overtime_is_edited | Unknown |  |
| rest_day_overtime_payroll_hour_id | Unknown |  |
| rest_day_overtime_time | Unknown |  |
| start_offset | Unknown |  |
| start_time | Unknown |  |
| time_off_holiday | Json |  |
| time_off_is_rest_day | Unknown |  |
| time_off_paid_time_off | Unknown |  |
| time_off_short_day | Json |  |
| time_off_type | Json |  |
| time_off_unpaid_time_off | Unknown |  |
| tracked_hours_added | Unknown |  |
| tracked_hours_breaks | Json |  |
| tracked_hours_paid_break_time | Unknown |  |
| tracked_hours_total | Unknown |  |
| tracked_hours_total_auto_deduction_time | Unknown |  |
| tracked_hours_total_break_time | Unknown |  |
| tracked_hours_unpaid_break_time | Unknown |  |
| tracked_hours_worked | Unknown |  |
| weekly_overtime_is_edited | Unknown |  |
| weekly_overtime_payroll_hour_id | Unknown |  |
| weekly_overtime_time | Unknown |  |

### timesheet

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| person_id | Unknown | FK |
| summary_added | Unknown |  |
| summary_auto_deduction_time | Unknown |  |
| summary_break_time | Unknown |  |
| summary_daily_double_overtime | Unknown |  |
| summary_daily_overtime | Unknown |  |
| summary_paid_break_time | Unknown |  |
| summary_paid_time_off | Unknown |  |
| summary_payroll | Unknown |  |
| summary_public_holiday_overtime | Unknown |  |
| summary_regular | Unknown |  |
| summary_rest_day_overtime | Unknown |  |
| summary_tracked | Unknown |  |
| summary_unpaid_break_time | Unknown |  |
| summary_unpaid_time_off | Unknown |  |
| summary_weekly_overtime | Unknown |  |
| summary_worked | Unknown |  |
| total | Unknown |  |
| total_payroll | Unknown |  |
| total_tracked | Unknown |  |

### time_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activity_id | Unknown | FK |
| location_id | Unknown | FK |
| next_time_entry_id | Unknown | FK |
| organization_id | Unknown | FK |
| person_id | Unknown | FK |
| previous_time_entry_id | Unknown | FK |
| address | Unknown |  |
| auto_clock_out_time | Unknown |  |
| belongs_to_date | Unknown |  |
| break_id | Unknown |  |
| client_type | Unknown |  |
| clock_in_out_reminder_time | Unknown |  |
| coordinate | Unknown |  |
| created_at | Unknown |  |
| event_id | Unknown |  |
| face_similarity | Unknown |  |
| is_automatic | Unknown |  |
| is_end_of_day | Unknown |  |
| is_face_recognized | Unknown |  |
| is_from_speed_kiosk | Unknown |  |
| is_locked | Unknown |  |
| is_manual | Unknown |  |
| is_manual_location | Unknown |  |
| is_offline | Unknown |  |
| is_outside_geofence | Unknown |  |
| is_unusual | Unknown |  |
| kiosk_id | Unknown |  |
| local_time | Unknown |  |
| note | Unknown |  |
| offsets | Unknown |  |
| picture | Unknown |  |
| platform_client_version | Unknown |  |
| platform_device_id | Unknown |  |
| platform_device_model | Unknown |  |
| platform_device_name | Unknown |  |
| platform_os | Unknown |  |
| project_id | Unknown |  |
| status | Unknown |  |
| time | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### schedule_auto_deduction

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| schedule_id | Unknown | PK, FK |
| duration | Unknown |  |
| name | Unknown |  |
| threshold | Unknown |  |

### schedule_break

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| schedule_id | Unknown | PK, FK |
| allow_to_be_taken_from_to | Unknown |  |
| duration | Unknown |  |
| from_time | Unknown |  |
| name | Unknown |  |
| to_time | Unknown |  |

### schedule_day

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| schedule_id | Unknown | PK, FK |
| day | Unknown |  |
| duration | Unknown |  |
| from_time | Unknown |  |
| to_time | Unknown |  |

### schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| breaks_type | Unknown |  |
| created_at | Unknown |  |
| daily_double_overtime_multiplier | Unknown |  |
| daily_overtime_multiplier | Unknown |  |
| defaults | Unknown |  |
| exclude_early_clock_in | Unknown |  |
| location | Json |  |
| name | Unknown |  |
| odata_etag | Unknown |  |
| overtime_daily | Unknown |  |
| overtime_daily_double | Unknown |  |
| overtime_daily_double_duration | Unknown |  |
| overtime_daily_double_from | Unknown |  |
| overtime_daily_duration | Unknown |  |
| overtime_daily_from | Unknown |  |
| overtime_end_work_day_at | Unknown |  |
| overtime_public_holiday | Unknown |  |
| overtime_rest_day | Unknown |  |
| overtime_time_range_style | Unknown |  |
| overtime_weekly | Unknown |  |
| overtime_weekly_duration | Unknown |  |
| public_holiday_overtime_multiplier | Unknown |  |
| rest_day_overtime_multiplier | Unknown |  |
| updated_at | Instant |  |
| weekly_hours | Unknown |  |
| weekly_overtime_multiplier | Unknown |  |
| work_arrangement | Unknown |  |

### activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| assigned_group | Json |  |
| code | Unknown |  |
| color | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| odata_etag | Unknown |  |
| status | Unknown |  |
| updated_at | Instant |  |

## Relationships

- member_overridden_property(member_id) → member(id)
- member(group_id) → groups(id)
- member(organization_id) → organization(id)
- member(schedule_id) → schedule(id)
- role(organization_id) → organization(id)
- time_off_holiday(time_off_overview_id) → time_off_overview(id)
- time_off_overview(person_id) → member(id)
- groups(organization_id) → organization(id)
- groups(schedule_id) → schedule(id)
- timesheet_auto_deduction(timesheet_id) → timesheet_daily(timesheet_id)
- timesheet_auto_deduction(date) → timesheet_daily(date)
- timesheet_daily(timesheet_id) → timesheet(id)
- timesheet(person_id) → member(id)
- time_entry(activity_id) → activity(id)
- time_entry(previous_time_entry_id) → time_entry(id)
- time_entry(next_time_entry_id) → time_entry(id)
- time_entry(person_id) → member(id)
- time_entry(organization_id) → organization(id)
- time_entry(location_id) → location(id)
- schedule_auto_deduction(schedule_id) → schedule(id)
- schedule_break(schedule_id) → schedule(id)
- schedule_day(schedule_id) → schedule(id)
- schedule(organization_id) → organization(id)
- activity(organization_id) → organization(id)