Lucca
Explore the interactive ERD
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 | PKFK |
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 | PKFK |
leave_authorized_operation_leave_id | Unknown | PKFK |
code | Unknown | |
description | Unknown | |
name | Unknown | |
value | Unknown |
leave_authorized_operation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
leave_id | Unknown | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
department_current_user
| Column | Type | Keys |
|---|---|---|
current_users | Unknown | PKFK |
department_id | Unknown | PKFK |
department_authorized_operation_scope
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
department_authorized_operation_id | Unknown | PKFK |
department_id | Unknown | PKFK |
code | Unknown | |
description | Unknown | |
name | Unknown | |
value | Unknown |
department_authorized_operation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
department_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
comment | Unknown | |
date | Unknown | |
name | Unknown | |
status | Unknown |
leave_request_approval
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
leave_request_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
name | Unknown | |
url | Unknown |
leave_period_log
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
leave_period_id | Unknown | PKFK |
name | Unknown | |
url | Unknown |
leave_period_account
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
leave_period_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
name | Unknown | |
url | Unknown |
user_work_cycle
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
users_id | Unknown | PKFK |
name | Unknown | |
url | Unknown |
user_authorized_operation_scope
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_authorized_operation_id | Unknown | PKFK |
user_id | Unknown | PKFK |
code | Unknown | |
description | Unknown | |
name | Unknown | |
value | Unknown |
user_authorized_operation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
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_** |