Leapsome
Explore the interactive ERD
Table & Field Reference
review_participant_manager
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
review_participant_id | Unknown | PKFK |
user_id | Unknown | FK |
average_rating | Unknown | |
last_modified_on | Unknown | |
preferred_name | Unknown |
review_participant_additional_manager
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
review_participant_id | Unknown | PKFK |
user_id | Unknown | FK |
average_rating | Unknown | |
last_modified_on | Unknown | |
preferred_name | Unknown |
review_participant_peer
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
review_participant_id | Unknown | PKFK |
user_id | Unknown | FK |
average_rating | Unknown | |
last_modified_on | Unknown | |
preferred_name | Unknown |
review_participant_direct_report
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
review_participant_id | Unknown | PKFK |
user_id | Unknown | FK |
average_rating | Unknown | |
last_modified_on | Unknown | |
preferred_name | Unknown |
review_participant
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
review_id | Unknown | FK |
reviewee_user_id | Unknown | FK |
last_modified_on | Instant | |
reviewee_average_rating | Unknown | |
reviewee_last_modified_on | Unknown | |
reviewee_preferred_name | Unknown | |
signature_manager | Instant | |
signature_reviewee | Instant |
absence
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | FK |
absence_end | Instant | |
absence_start | Instant | |
absence_type | Unknown | |
activity_type | Unknown | |
created_at | Instant | |
status | Unknown | |
time_unit | Unknown | |
updated_at | Instant |
document_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
employee_team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
name | Unknown |
employee_department
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
name | Unknown |
employee_business_unit
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
name | Unknown |
employee_cost_center
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
name | Unknown |
employee_division
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
name | Unknown |
employee_other_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
name | Unknown |
employee_additional_compensation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
amount | Unknown | |
amount_type | Unknown | |
comment | Unknown | |
effective_at | Instant | |
name | Unknown | |
recurrence | Unknown | |
valid_until | Instant |
employee_additional_manager
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
name | Unknown |
employee_indirect_manager
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | PKFK |
name | Unknown |
employee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
manager_id | Unknown | FK |
compensation_currency | Unknown | |
compensation_frequency | Unknown | |
compensation_salary | Unknown | |
displayed_name | Unknown | |
email | Unknown | |
end_date | Instant | |
first_name | Unknown | |
full_name | Unknown | |
last_name | Unknown | |
level | Unknown | |
lifecycle_status | Unknown | |
manager_name | Unknown | |
middle_name | Unknown | |
phone | Unknown | |
start_date | Instant | |
status | Unknown | |
title | Unknown | |
work_location_id | Unknown | |
custom_attribute_** |
work_location
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
administrative_division | Unknown | |
city | Unknown | |
country | Unknown | |
created_at | Instant | |
currency | Unknown | |
is_primary | Unknown | |
name | Unknown | |
remote | Unknown | |
status | Unknown | |
street | Unknown | |
updated_at | Instant | |
zip | Unknown |
payroll_cycle
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
approval_start_at | Instant | |
approved_at | Instant | |
approved_by | Unknown | |
compensations_base_salary_custom_name | Unknown | |
compensations_compensable_time_custom_name | Unknown | |
compensations_hours_worked_custom_name | Unknown | |
compensations_paid_absences_custom_name | Unknown | |
compensations_salary_per_hour_custom_name | Unknown | |
compensations_salary_type_custom_name | Unknown | |
created_at | Instant | |
custom_period_end_at | Instant | |
custom_period_start_at | Instant | |
end_at | Instant | |
name | Unknown | |
prorate_type | Unknown | |
review_start_at | Instant | |
start_at | Instant | |
status | Unknown | |
updated_at | Instant |
feedback
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
receiver_id | Unknown | FK |
sender_id | Unknown | FK |
badge_icon | Unknown | |
badge_name | Unknown | |
comments_count | Unknown | |
created_at | Instant | |
likes_count | Unknown | |
message | Unknown | |
type | Unknown | |
visibility | Unknown |
review
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Instant | |
kickoff_date | Instant | |
last_modified_on | Instant | |
name | Unknown | |
status | Unknown | |
template | Unknown |
goal_key_result
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
goal_id | Unknown | PKFK |
metric_current | Unknown | |
metric_end | Unknown | |
metric_start | Unknown | |
metric_type | Unknown | |
name | Unknown | |
weight | Unknown |
goal
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contributor_id | Unknown | FK |
managed_by_id | Unknown | FK |
owner_user_id | Unknown | FK |
parent_id | Unknown | FK |
user_id | Unknown | FK |
created_at | Instant | |
deadline | Instant | |
description | Unknown | |
name | Unknown | |
progress | Unknown | |
progress_status | Unknown | |
status | Unknown | |
tag_id | Unknown | |
type | Unknown | |
updated_at | Instant |
time_tracking_timesheet_project
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
time_tracking_timesheet_id | Unknown | PKFK |
title | Unknown |
time_tracking_timesheet
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | FK |
compensable_hour | Unknown | |
end_date | Instant | |
hours_worked | Unknown | |
overtime_hour | Unknown | |
start_date | Instant | |
status | Unknown | |
work_duration | Unknown |
review_question
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
get_review_id | Unknown | PKFK |
name | Unknown |
get_review
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
timeline_conversations_deadline | Instant | |
timeline_manager_reviews_deadline | Instant | |
timeline_peer_approval_deadline | Instant | |
timeline_peer_nominations_deadline | Instant | |
timeline_peer_reviews_deadline | Instant | |
timeline_start | Instant |
goal_comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
goal_id | Unknown | PKFK |
sender_id | Unknown | FK |
content | Unknown | |
created_at | Instant | |
updated_at | Instant |
payroll_cycle_participant_compensation
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
payroll_cycle_participant_id | Unknown | PKFK |
amount | Unknown | |
amount_type | Unknown | |
comment | Unknown | |
effective_at | Instant | |
name | Unknown | |
recurrence | Unknown | |
valid_until | Instant |
payroll_cycle_participant_salary_info_period
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
payroll_cycle_participant_id | Unknown | PKFK |
base_salary | Unknown | |
compensation_type | Unknown | |
currency | Unknown | |
salary | Unknown | |
salary_remuneration_period | Unknown |
payroll_cycle_participant
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
payroll_cycle_id | Unknown | PKFK |
email | Unknown | |
is_active_participant | Unknown |
goal_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
created_at | Instant | |
name | Unknown | |
status | Unknown | |
updated_at | Instant |