# Lucca schema ERD

Table and field reference for the Fivetran Lucca connector.

## Table & Field Reference

### work_contract

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| author_id | Unknown | FK |
| internship_supervisor_id | Unknown | FK |
| last_modifier_id | Unknown | FK |
| owner_id | Unknown | FK |
| created_at | Unknown |  |
| ends_on | Unknown |  |
| establishment_id | Unknown |  |
| external_id | Unknown |  |
| hiring_type_id | Unknown |  |
| is_applicable | Unknown |  |
| last_modified_at | Unknown |  |
| renewed_trial_period_days | Unknown |  |
| spc_id | Unknown |  |
| starts_on | Unknown |  |
| temporary_contract_ground_id | Unknown |  |
| termination_reason_id | Unknown |  |
| trial_period_days | Unknown |  |
| trial_period_end_date | Unknown |  |
| trial_period_end_date_2 | Unknown |  |
| type_id | Unknown |  |

### leave_request_approval_detail

| Column | Type | Keys |
| --- | --- | --- |
| leave_request_id | Unknown | PK |
| id | Unknown | PK, FK |
| approver_id | Unknown | FK |
| substituted_approver_id | Unknown | FK |
| approved | Unknown |  |
| comment | Unknown |  |
| date | Unknown |  |
| name | Unknown |  |

### leave_authorized_operation_scope

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leave_authorized_operation_id | Unknown | PK, FK |
| leave_authorized_operation_leave_id | Unknown | PK, FK |
| code | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| value | Unknown |  |

### leave_authorized_operation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leave_id | Unknown | PK, FK |
| description | Unknown |  |
| is_admin | Unknown |  |
| is_business_item_specific | Unknown |  |
| is_scope_specific | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |

### leave

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cancellation_user_id | Unknown | FK |
| leave_account_id | Unknown | FK |
| leave_period_id | Unknown | FK |
| authorized_actions_details | Unknown |  |
| calendar | Unknown |  |
| cancellation_date | Unknown |  |
| cancellation_user | Unknown |  |
| code | Unknown |  |
| color | Unknown |  |
| comment | Unknown |  |
| creation_date | Unknown |  |
| date | Unknown |  |
| days_off_check_id | Unknown |  |
| duration | Unknown |  |
| ends_at | Unknown |  |
| granularity | Unknown |  |
| is_a_m | Unknown |  |
| is_active | Unknown |  |
| is_actual_work | Unknown |  |
| is_being_imported | Unknown |  |
| is_cancellable | Unknown |  |
| is_public | Unknown |  |
| is_real_leave | Unknown |  |
| is_remote_work | Unknown |  |
| key_item_1 | Unknown |  |
| key_item_2 | Unknown |  |
| key_item_3 | Unknown |  |
| leave_account_duration | Unknown |  |
| name | Unknown |  |
| nature | Unknown |  |
| nature_of_half_day | Unknown |  |
| owner_id | Unknown |  |
| scope | Unknown |  |
| start_date_time | Unknown |  |
| starts_at | Unknown |  |
| status | Unknown |  |
| time_line | Unknown |  |
| type | Unknown |  |
| unit | Unknown |  |
| url | Unknown |  |
| value | Unknown |  |
| working_time_type | Unknown |  |

### department_user

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

### department_current_user

| Column | Type | Keys |
| --- | --- | --- |
| current_users | Unknown | PK, FK |
| department_id | Unknown | PK, FK |

### department_authorized_operation_scope

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| department_authorized_operation_id | Unknown | PK, FK |
| department_id | Unknown | PK, FK |
| code | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| value | Unknown |  |

### department_authorized_operation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| department_id | Unknown | PK, FK |
| description | Unknown |  |
| is_admin | Unknown |  |
| is_business_item_specific | Unknown |  |
| is_scope_specific | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |

### department

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| head_id | Unknown | FK |
| parent_id | Unknown | FK |
| authorized_actions | Json |  |
| code | Unknown |  |
| description | Unknown |  |
| hierarchy | Unknown |  |
| is_active | Unknown |  |
| level | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| sort_order | Unknown |  |
| url | Unknown |  |

### cancelation_request_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leave_request_id | Unknown | PK, FK |
| author_id | Unknown |  |
| comment | Unknown |  |
| creation_date | Unknown |  |
| is_active | Unknown |  |
| name | Unknown |  |
| next_approver_id | Unknown |  |
| rank | Unknown |  |

### leave_account_legal_entity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leave_account_id | Unknown | PK, FK |
| name | Unknown |  |
| url | Unknown |  |

### leave_account_authorized_operation_scopes

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leave_account_authorized_operation_id | Unknown | FK |
| leave_account_id | Unknown | FK |
| code | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| value | Unknown |  |

### leave_account_authorized_operation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leave_account_id | Unknown | PK, FK |
| description | Unknown |  |
| is_admin | Unknown |  |
| is_business_item_specific | Unknown |  |
| is_scope_specific | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |

### leave_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| deleted_by_id | Unknown | FK |
| modified_by_id | Unknown | FK |
| allow_before_consumption | Unknown |  |
| allow_input | Unknown |  |
| allow_outer_consumption | Unknown |  |
| allow_select | Unknown |  |
| allow_simulation | Unknown |  |
| atp | Unknown |  |
| authorized_actions | Json |  |
| auto_credit | Unknown |  |
| color | Unknown |  |
| complete_consumption | Unknown |  |
| consumption_end_date | Unknown |  |
| consumption_start_date | Unknown |  |
| created_at | Unknown |  |
| credit_account | Unknown |  |
| custom_color | Unknown |  |
| debit_account | Unknown |  |
| debit_allowed_rounding_limits | Unknown |  |
| debit_authorization | Unknown |  |
| deleted_at | Unknown |  |
| duration_hour | Unknown |  |
| entitlement_end_date | Unknown |  |
| entitlement_start_date | Unknown |  |
| extend_to_following_non_working_days | Unknown |  |
| french_sick_leave_nature | Unknown |  |
| half_day_authorization | Unknown |  |
| has_entitlement_period | Unknown |  |
| i_1_8_n_labels | Json |  |
| is_absenteeism | Unknown |  |
| is_active | Unknown |  |
| is_actual_work | Unknown |  |
| is_full_entitlement | Unknown |  |
| is_leave | Unknown |  |
| is_movement_account | Unknown |  |
| is_orphan | Unknown |  |
| is_pristine | Unknown |  |
| is_public | Unknown |  |
| is_recurring | Unknown |  |
| is_remote_work | Unknown |  |
| leave_account_category_id | Unknown |  |
| leave_account_category_name | Unknown |  |
| leave_account_category_url | Unknown |  |
| leave_account_type | Unknown |  |
| leave_profile_entitlements | Json |  |
| modified_at | Unknown |  |
| name | Unknown |  |
| nbj | Unknown |  |
| need_approval | Unknown |  |
| need_cancellation_approval | Unknown |  |
| need_supporting_documentation | Unknown |  |
| position | Unknown |  |
| requested_permission | Unknown |  |
| selected_date | Unknown |  |
| selected_user | Unknown |  |
| step_hour | Unknown |  |
| type | Unknown |  |
| unit | Unknown |  |
| url | Unknown |  |
| warning | Unknown |  |

### leave_request_log

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leave_request_id | Unknown | PK, FK |
| comment | Unknown |  |
| date | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |

### leave_request_approval

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leave_request_id | Unknown | PK, FK |
| approved | Unknown |  |
| approver_id | Unknown |  |
| comment | Unknown |  |
| date | Unknown |  |
| name | Unknown |  |
| substituted_approver_id | Unknown |  |

### leave_request_cancellation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leave_request_id | Unknown | PK, FK |
| approved | Unknown |  |
| author_id | Unknown |  |
| comment | Unknown |  |
| creation_date | Unknown |  |
| is_active | Unknown |  |
| name | Unknown |  |
| next_approver_id | Unknown |  |
| rank | Unknown |  |

### leave_request_authorized_operation_scope

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| leave_request_authorized_operation_id | Unknown | FK |
| leave_request_id | Unknown | FK |
| code | Unknown |  |
| description | Unknown |  |
| id | Unknown |  |
| name | Unknown |  |
| value | Unknown |  |

### leave_request_authorized_operation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leave_request_id | Unknown | PK, FK |
| description | Unknown |  |
| is_admin | Unknown |  |
| is_business_item_specific | Unknown |  |
| is_scope_specific | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |

### leave_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cancellation_user_id | Unknown | FK |
| leave_period_id | Unknown | FK |
| next_approver_id | Unknown | FK |
| owner_id | Unknown | FK |
| author_id | Unknown |  |
| author_name | Unknown |  |
| author_url | Unknown |  |
| authorized_actions | Json |  |
| cancellation_date | Unknown |  |
| cancellation_request_pending | Json |  |
| creation_date | Unknown |  |
| days_off_check_id | Unknown |  |
| is_active | Unknown |  |
| name | Unknown |  |
| owner_comment | Unknown |  |
| source | Unknown |  |
| status | Unknown |  |
| url | Unknown |  |
| warnings | Json |  |

### user_location

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| owner_id | Long | FK |
| area_id | Long |  |
| created_at | Instant |  |
| date | LocalDate |  |
| deleted_at | Instant |  |
| position | String |  |
| status | String |  |
| work_location_id | Long |  |

### period_leaves

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leave_period_id | Unknown | PK, FK |
| name | Unknown |  |
| url | Unknown |  |

### leave_period_log

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leave_period_id | Unknown | PK, FK |
| name | Unknown |  |
| url | Unknown |  |

### leave_period_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leave_period_id | Unknown | PK, FK |
| name | Unknown |  |
| url | Unknown |  |

### leave_period_authorized_operation_scopes

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leave_period_authorized_operation_id | Unknown | FK |
| leave_period_id | Unknown | FK |
| code | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| value | Unknown |  |

### leave_period_authorized_operation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| leave_period_id | Unknown | PK, FK |
| description | Unknown |  |
| is_admin | Unknown |  |
| is_business_item_specific | Unknown |  |
| is_scope_specific | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |

### leave_period

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_id | Unknown | FK |
| attachment | Json |  |
| attachment_id | Unknown |  |
| attachment_name | Unknown |  |
| attachment_preview | Json |  |
| authorized_actions | Json |  |
| confirmation_date | Unknown |  |
| duration | Unknown |  |
| duration_unit | Unknown |  |
| ends_am | Unknown |  |
| ends_on | Unknown |  |
| is_confirmed | Unknown |  |
| is_half_day | Unknown |  |
| migration_transation_id | Unknown |  |
| name | Unknown |  |
| relate_to_one_day | Unknown |  |
| starts_am | Unknown |  |
| starts_on | Unknown |  |
| supporting_documentation_controls | Unknown |  |
| time_zone_id | Unknown |  |
| url | Unknown |  |
| warnings | Json |  |

### user_habilited_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| users_id | Unknown | PK, FK |
| name | Unknown |  |
| url | Unknown |  |

### user_work_cycle

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| users_id | Unknown | PK, FK |
| name | Unknown |  |
| url | Unknown |  |

### user_authorized_operation_scope

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_authorized_operation_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| code | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| value | Unknown |  |

### user_authorized_operation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| description | Unknown |  |
| is_admin | Unknown |  |
| is_business_item_specific | Unknown |  |
| is_scope_specific | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address | Unknown |  |
| application_data_manager_2 | Json |  |
| application_data_manager_2_id | Json |  |
| attributes | Json |  |
| bank_name | Unknown |  |
| bic | Unknown |  |
| birth_date | Unknown |  |
| calendar_id | Unknown |  |
| calendar_name | Unknown |  |
| calendar_url | Unknown |  |
| civil_title | Unknown |  |
| corporate_card | Unknown |  |
| created_at | Unknown |  |
| created_on | Unknown |  |
| csp_id | Unknown |  |
| csp_name | Unknown |  |
| csp_url | Unknown |  |
| culture_code | Unknown |  |
| culture_id | Unknown |  |
| culture_name | Unknown |  |
| current_delegatee | Json |  |
| current_delegatee_id | Unknown |  |
| department_id | Unknown |  |
| direct_line | Unknown |  |
| display_name | Unknown |  |
| dt_contract_end | Unknown |  |
| dt_contract_start | Unknown |  |
| employee_number | Unknown |  |
| external_id | Unknown |  |
| first_name | Unknown |  |
| french_car_tax_horse_power | Unknown |  |
| french_motocycles_tax_horse_power | Unknown |  |
| gender | Unknown |  |
| iban | Unknown |  |
| insurance_number | Unknown |  |
| job_qualification | Json |  |
| job_qualification_id | Unknown |  |
| job_title | Unknown |  |
| last_annual_review_date_link | Unknown |  |
| last_annual_review_date_value | Json |  |
| last_fixed_working_days_review_date_link | Unknown |  |
| last_fixed_working_days_review_date_value | Json |  |
| last_name | Unknown |  |
| last_professional_review_date_link | Unknown |  |
| last_professional_review_date_value | Json |  |
| legal_entity_id | Unknown |  |
| legal_entity_name | Unknown |  |
| legal_entity_url | Unknown |  |
| login | Unknown |  |
| mail | Unknown |  |
| manager_id | Unknown |  |
| modified_at | Unknown |  |
| modified_on | Unknown |  |
| name | Unknown |  |
| nationality_currency_id | Unknown |  |
| nationality_id | Unknown |  |
| nationality_name | Unknown |  |
| personal_account | Unknown |  |
| personal_card | Unknown |  |
| personal_email | Unknown |  |
| personal_mobile | Unknown |  |
| picture_extension | Unknown |  |
| picture_href | Unknown |  |
| picture_id | Unknown |  |
| picture_mime_type | Unknown |  |
| picture_name | Unknown |  |
| picture_url | Unknown |  |
| professional_mobile | Unknown |  |
| profile_figgo_id | Unknown |  |
| profile_figgo_name | Unknown |  |
| profile_figgo_url | Unknown |  |
| profile_utime_id | Unknown |  |
| profile_utime_name | Unknown |  |
| profile_utime_url | Unknown |  |
| quote | Unknown |  |
| rib | Unknown |  |
| role_principal_id | Unknown |  |
| role_principal_name | Unknown |  |
| role_principal_url | Unknown |  |
| seniority_date | Unknown |  |
| site | Json |  |
| site_id | Unknown |  |
| unit_sell_price | Unknown |  |
| url | Unknown |  |
| extended_data_** |  |  |

## Relationships

- work_contract(author_id) → users(id)
- work_contract(owner_id) → users(id)
- work_contract(internship_supervisor_id) → users(id)
- work_contract(last_modifier_id) → users(id)
- leave_request_approval_detail(id) → leave_request_approval(id)
- leave_request_approval_detail(approver_id) → users(id)
- leave_request_approval_detail(substituted_approver_id) → users(id)
- leave_authorized_operation_scope(leave_authorized_operation_leave_id) → leave_authorized_operation(leave_id)
- leave_authorized_operation_scope(leave_authorized_operation_id) → leave_authorized_operation(id)
- leave_authorized_operation(leave_id) → leave(id)
- leave(leave_period_id) → leave_period(id)
- leave(cancellation_user_id) → users(id)
- leave(leave_account_id) → leave_account(id)
- department_user(user_id) → users(id)
- department_user(department_id) → department(id)
- department_current_user(current_users) → users(id)
- department_current_user(department_id) → department(id)
- department_authorized_operation_scope(department_id) → department_authorized_operation(department_id)
- department_authorized_operation_scope(department_authorized_operation_id) → department_authorized_operation(id)
- department_authorized_operation(department_id) → department(id)
- department(head_id) → users(id)
- department(parent_id) → department(id)
- cancelation_request_detail(leave_request_id) → leave_request_cancellation(leave_request_id)
- leave_account_legal_entity(leave_account_id) → leave_account(id)
- leave_account_authorized_operation_scopes(leave_account_id) → leave_account_authorized_operation(leave_account_id)
- leave_account_authorized_operation_scopes(leave_account_authorized_operation_id) → leave_account_authorized_operation(id)
- leave_account_authorized_operation(leave_account_id) → leave_account(id)
- leave_account(modified_by_id) → users(id)
- leave_account(created_by_id) → users(id)
- leave_account(deleted_by_id) → users(id)
- leave_request_log(leave_request_id) → leave_request(id)
- leave_request_approval(leave_request_id) → leave_request(id)
- leave_request_cancellation(leave_request_id) → leave_request(id)
- leave_request_authorized_operation_scope(leave_request_id) → leave_request_authorized_operation(leave_request_id)
- leave_request_authorized_operation_scope(leave_request_authorized_operation_id) → leave_request_authorized_operation(id)
- leave_request_authorized_operation(leave_request_id) → leave_request(id)
- leave_request(leave_period_id) → leave_period(id)
- leave_request(owner_id) → users(id)
- leave_request(next_approver_id) → users(id)
- leave_request(cancellation_user_id) → users(id)
- user_location(owner_id) → users(id)
- period_leaves(leave_period_id) → leave_period(id)
- leave_period_log(leave_period_id) → leave_period(id)
- leave_period_account(leave_period_id) → leave_period(id)
- leave_period_authorized_operation_scopes(leave_period_id) → leave_period_authorized_operation(leave_period_id)
- leave_period_authorized_operation_scopes(leave_period_authorized_operation_id) → leave_period_authorized_operation(id)
- leave_period_authorized_operation(leave_period_id) → leave_period(id)
- leave_period(owner_id) → users(id)
- user_habilited_role(users_id) → users(id)
- user_work_cycle(users_id) → users(id)
- user_authorized_operation_scope(user_id) → user_authorized_operation(user_id)
- user_authorized_operation_scope(user_authorized_operation_id) → user_authorized_operation(id)
- user_authorized_operation(user_id) → users(id)