# Namely schema ERD

Table and field reference for the Fivetran Namely connector.

## Table & Field Reference

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_country_id | Unknown | FK |
| group_type_id | Unknown | FK |
| address_address_1 | Unknown |  |
| address_address_2 | Unknown |  |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_phone | Unknown |  |
| address_state | Unknown |  |
| address_state_id | Unknown |  |
| address_zip | Unknown |  |
| count | Unknown |  |
| is_team | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### group_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deletable | Unknown |  |
| field_name | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| x_groups_as_team | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| profile | Unknown | FK |
| appreciations | Json |  |
| can_comment | Unknown |  |
| can_destroy | Unknown |  |
| can_edit | Unknown |  |
| can_like | Unknown |  |
| content | Unknown |  |
| created_at | Instant |  |
| file | Unknown |  |
| href | Unknown |  |
| html_content | Unknown |  |
| liked_by_current_profile | Unknown |  |
| likes_count | Unknown |  |
| time | Instant |  |
| type | Unknown |  |
| updated_at | Instant |  |
| use_comments | Unknown |  |
| utc_offset | Unknown |  |
| years_at_company | Unknown |  |

### comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| profile | Unknown | FK |
| can_destroy | Unknown |  |
| content | Unknown |  |
| created_at | Instant |  |
| html_content | Unknown |  |
| liked_by_current_profile | Unknown |  |
| likes_count | Unknown |  |
| utc_offset | Unknown |  |

### profile_group

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK, FK |
| profile_id | Unknown | PK, FK |

### profile_image

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| profile_id | Unknown | PK, FK |
| filename | Unknown |  |
| mime_type | Unknown |  |
| original | Unknown |  |
| thumb_150_x_150 | Unknown |  |
| thumb_150_x_150_c | Unknown |  |
| thumb_300_x_300 | Unknown |  |
| thumb_450_x_450 | Unknown |  |
| thumb_75_x_75 | Unknown |  |
| thumb_75_x_75_c | Unknown |  |
| thumb_800_x_800 | Unknown |  |

### reports_to

| Column | Type | Keys |
| --- | --- | --- |
| profile_id | Unknown | PK, FK |
| reports_to_profile_id | Unknown | PK, FK |

### profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| home_country_id | Unknown | FK |
| job_id | Unknown | FK |
| office_country_id | Unknown | FK |
| access_role | Unknown |  |
| allergies | Unknown |  |
| anthem_member_id | Unknown |  |
| bio | Unknown |  |
| communication_style | Unknown |  |
| company | Unknown |  |
| company_uuid | Unknown |  |
| created_at | Instant |  |
| current_job_description | Unknown |  |
| date_format | Unknown |  |
| departure_date | Unknown |  |
| diversity_stats | Json |  |
| division | Unknown |  |
| dob | Unknown |  |
| email | Unknown |  |
| emergency_contact | Unknown |  |
| emergency_contact_phone | Unknown |  |
| emergency_contact_relationship | Unknown |  |
| employee_id | Unknown |  |
| employee_level | Unknown |  |
| employee_type | Unknown |  |
| employee_wage_theft_prevention_act | Unknown |  |
| engineering_team | Unknown |  |
| ethnicity | Unknown |  |
| first_name | Unknown |  |
| full_name | Unknown |  |
| gender | Unknown |  |
| gender_identity | Json |  |
| home_address_1 | Unknown |  |
| home_address_2 | Unknown |  |
| home_city | Unknown |  |
| home_phone | Unknown |  |
| home_state_id | Unknown |  |
| home_zip | Unknown |  |
| hrbp | Unknown |  |
| is_namely_admin | Unknown |  |
| job_description | Unknown |  |
| last_name | Unknown |  |
| linkedin_url | Unknown |  |
| marital_status | Unknown |  |
| middle_name | Unknown |  |
| mobile_phone | Unknown |  |
| namely_time_employee_url | Unknown |  |
| namely_time_manager_url | Unknown |  |
| offer_letter | Unknown |  |
| office_address_1 | Unknown |  |
| office_address_2 | Unknown |  |
| office_city | Unknown |  |
| office_direct_dial | Unknown |  |
| office_main_number | Unknown |  |
| office_phone | Unknown |  |
| office_state_id | Unknown |  |
| office_zip | Unknown |  |
| on_target_earnings | Unknown |  |
| people_partner | Unknown |  |
| personal_email | Unknown |  |
| preferred_name | Unknown |  |
| preferred_pronoun | Unknown |  |
| relationship_disclosure | Unknown |  |
| resume | Unknown |  |
| salary_amount_raw | Unknown |  |
| salary_currency_type | Unknown |  |
| salary_date | Unknown |  |
| salary_guid | Unknown |  |
| salary_is_hourly | Boolean |  |
| salary_payroll_company_name | Unknown |  |
| salary_payroll_job_id | Unknown |  |
| salary_rate | Unknown |  |
| salary_yearly_amount | Double |  |
| ssn | Unknown |  |
| start_date | Unknown |  |
| t_shirt_size | Unknown |  |
| team_positions | Json |  |
| temporary_address_covid_19 | Unknown |  |
| updated_at | Instant |  |
| user_status | Unknown |  |

### country

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| subdivision_type | Unknown |  |

### resource_in_folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| folder_id | Unknown | FK |
| file_format | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| file_url | Unknown |  |
| last_edited | Unknown |  |
| link | Unknown |  |
| title | Unknown |  |

### resource_not_in_folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| folder_id | Unknown | FK |
| file_format | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| file_url | Unknown |  |
| last_edited | Unknown |  |
| link | Unknown |  |
| title | Unknown |  |

### section_block_title

| Column | Type | Keys |
| --- | --- | --- |
| block_title | Unknown | PK |
| profile_field_section_id | Unknown | PK, FK |

### profile_field_section

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| title | Unknown |  |

### comment_like

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| comment_id | Unknown | PK, FK |
| full_name | Unknown |  |
| href | Unknown |  |
| job_title | Unknown |  |

### folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| items_count | Unknown |  |
| position | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### job_tier

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| defaults | Unknown |  |
| numerical_id | Unknown |  |
| title | Unknown |  |

### profile_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| section | Unknown | FK |
| block_index | Unknown |  |
| defaults | Unknown |  |
| deletable | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| valid_format_info | Unknown |  |

### team_category

| Column | Type | Keys |
| --- | --- | --- |
| category_id | Unknown | PK |
| team_id | Unknown | PK, FK |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| count | Unknown |  |
| created_at | Instant |  |
| email | Unknown |  |
| name | Unknown |  |
| updated_at | Instant |  |

### category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| title | Unknown |  |

### job_title

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_tier | Unknown | FK |
| parent_id | Unknown | FK |
| active | Unknown |  |
| title | Unknown |  |

### event_like

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| full_name | Unknown |  |
| href | Unknown |  |
| job_title | Unknown |  |

### notification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| profile_id | Unknown | FK |
| requester_id | Unknown | FK |
| responder_id | Unknown | FK |
| action_url | Unknown |  |
| read | Unknown |  |
| seen | Unknown |  |
| text | Unknown |  |
| time_off_request_id | Unknown |  |
| timestamps | Instant |  |
| type | Unknown |  |

## Relationships

- groups(group_type_id) → group_type(id)
- groups(address_country_id) → country(id)
- event(profile) → profile(id)
- comment(profile) → profile(id)
- comment(event_id) → event(id)
- profile_group(group_id) → groups(id)
- profile_group(profile_id) → profile(id)
- profile_image(profile_id) → profile(id)
- reports_to(reports_to_profile_id) → profile(id)
- reports_to(profile_id) → profile(id)
- profile(job_id) → job_title(id)
- profile(office_country_id) → country(id)
- profile(home_country_id) → country(id)
- resource_in_folder(folder_id) → folder(id)
- resource_not_in_folder(folder_id) → folder(id)
- section_block_title(profile_field_section_id) → profile_field_section(id)
- comment_like(comment_id) → comment(id)
- profile_field(section) → profile_field_section(id)
- team_category(team_id) → team(id)
- job_title(job_tier) → job_tier(id)
- job_title(parent_id) → job_title(id)
- event_like(event_id) → event(id)
- notification(profile_id) → profile(id)
- notification(requester_id) → profile(id)
- notification(responder_id) → profile(id)