Namely

Explore the interactive ERD

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	PKFK
`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	PKFK
`profile_id`	Unknown	PKFK

profile_image

Column	Type	Keys
`id`	Unknown	PK
`profile_id`	Unknown	PKFK
`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	PKFK
`reports_to_profile_id`	Unknown	PKFK

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	PKFK

profile_field_section

Column	Type	Keys
`id`	Unknown	PK
`title`	Unknown

comment_like

Column	Type	Keys
`id`	Unknown	PK
`comment_id`	Unknown	PKFK
`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	PKFK

team

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

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	PKFK
`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