Betterworks

Explore the interactive ERD

Table & Field Reference

recognition_mentioned_users

Column	Type	Keys
`id`	Unknown	PK
`recognition_id`	Unknown	PKFK
`name`	Unknown
`uuid`	Unknown

recognition_hashtag

Column	Type	Keys
`recognition_hashtag_id`	Unknown	PKFK
`recognition_id`	Unknown	PKFK

recognition

Column	Type	Keys
`id`	Unknown	PK
`comment_author_id`	Unknown	FK
`shoutout_author_id`	Unknown	FK
`shoutout_for_user_id`	Unknown	FK
`team_id`	Unknown	FK
`comment_created`	Unknown
`comment_created_on`	Unknown
`comment_edited`	Unknown
`comment_id`	Unknown
`comment_is_key_result`	Unknown
`comment_modified_on`	Unknown
`comment_text`	Unknown
`comment_uuid`	Unknown
`created`	Unknown
`created_on`	Unknown
`for_group`	Unknown
`for_group_id`	Unknown
`for_group_name`	Unknown
`for_group_uuid`	Unknown
`goal_id`	Unknown
`goal_name`	Unknown
`goal_owner_group_id`	Unknown
`goal_owner_group_is_active`	Unknown
`goal_owner_group_is_team`	Unknown
`goal_owner_group_name`	Unknown
`goal_owner_group_parent_id`	Unknown
`goal_owner_group_uuid`	Unknown
`goal_owner_user_id`	Unknown
`goal_owner_user_name`	Unknown
`goal_owner_user_uuid`	Unknown
`goal_uuid`	Unknown
`group_picture_uris_medium`	Unknown
`group_picture_uris_small`	Unknown
`modified_on`	Unknown
`shoutout_created`	Unknown
`shoutout_edited`	Unknown
`shoutout_id`	Unknown
`shoutout_text`	Unknown
`shoutout_uuid`	Unknown
`team_created_on`	Unknown
`team_is_active`	Unknown
`team_modified_on`	Unknown
`team_name`	Unknown
`team_picture_uris_medium`	Unknown
`team_picture_uris_small`	Unknown
`team_uuid`	Unknown
`uuid`	Unknown

calibration_cycle

Column	Type	Keys
`id`	Unknown	PK
`conversation_cycle_id`	Unknown
`name`	Unknown

feedback_response

Column	Type	Keys
`id`	Unknown	PK
`feedback_id`	Unknown	FK
`answer`	Unknown
`hide_numbers`	Unknown
`question`	Unknown
`question_id`	Unknown
`question_option`	Json
`question_uuid`	Unknown
`type`	Unknown
`uuid`	Unknown

feedback

Column	Type	Keys
`id`	Unknown	PK
`created_by_id`	Unknown	FK
`cycle_id`	Unknown	FK
`for_user_id`	Unknown	FK
`requested_by_id`	Unknown	FK
`created`	Unknown
`created_on`	Unknown
`cycle_enable_anytime_nomination`	Unknown
`cycle_end`	Unknown
`cycle_feedback_start`	Unknown
`cycle_grace_period_end`	Unknown
`cycle_selection_end`	Unknown
`cycle_start`	Unknown
`cycle_uuid`	Unknown
`employee_can_view`	Unknown
`employee_see_identity`	Unknown
`hold_feedback`	Unknown
`manager_can_view`	Unknown
`manager_see_identity`	Unknown
`modified_on`	Unknown
`name`	Unknown
`status`	Unknown
`template_name`	Unknown
`template_type`	Unknown
`updated`	Unknown
`uuid`	Unknown

x_axes_labels

Column	Type	Keys
`index`	Unknown	PK
`calibration_cycle_template_id`	Unknown	PKFK
`x_label`	Unknown

y_axes_labels

Column	Type	Keys
`index`	Unknown	PK
`calibration_cycle_template_id`	Unknown	PKFK
`y_label`	Unknown

histogram_content

Column	Type	Keys
`index`	Unknown	PK
`calibration_cycle_template_id`	Unknown	PKFK
`bg`	Unknown
`color`	Unknown
`label`	Unknown

talent_record_columns

Column	Type	Keys
`index`	Unknown	PK
`calibration_cycle_template_id`	Unknown	PKFK
`display_type`	Unknown
`label`	Unknown
`read_only`	Unknown
`sortable`	Unknown
`talent_key`	Unknown

mapping

Column	Type	Keys
`id`	Unknown	PK
`calibration_cycle_template_id`	Unknown	PKFK
`mappings_properties_created_by`	Unknown
`mappings_properties_created_on`	Unknown
`mappings_properties_cycle_template_id`	Unknown
`mappings_properties_expression`	Unknown
`mappings_properties_modified_by`	Unknown
`mappings_properties_modified_on`	Unknown
`mappings_properties_talent_key`	Unknown
`type`	Unknown

calibration_cycle_template

Column	Type	Keys
`id`	Unknown	PK
`box_number`	Unknown
`configuration_matrix_axes_x_length`	Unknown
`configuration_matrix_axes_x_talent_key`	Unknown
`configuration_matrix_axes_x_title`	Unknown
`configuration_matrix_axes_y_length`	Unknown
`configuration_matrix_axes_y_talent_key`	Unknown
`configuration_matrix_axes_y_title`	Unknown
`configuration_matrix_content`	Json
`created_by`	Unknown
`created_on`	Unknown
`dimension`	Unknown
`label_type`	Unknown
`modified_by`	Unknown
`modified_on`	Unknown
`name`	Unknown
`talent_key`	Unknown
`title`	Unknown
`type`	Unknown

conversation_template_allowed_employee

Column	Type	Keys
`id`	Unknown	PK
`conversation_template_id`	Unknown	PKFK
`email`	Unknown
`is_active`	Unknown
`name`	Unknown

conversation_template_allowed_group

Column	Type	Keys
`index`	Unknown	PK
`conversation_template_id`	Unknown	PKFK
`allowed_group`	Unknown

conversation_template_deployments_cycle

Column	Type	Keys
`id`	Unknown	PK
`conversation_template_deployment_conversation_tempalate_id`	Unknown	PKFK
`conversation_template_deployment_id`	Unknown	PKFK
`ends`	Unknown
`grace_period_end`	Unknown
`lock_date`	Unknown
`lock_on_share`	Unknown
`review_end`	Unknown
`role`	Unknown
`stage`	Unknown
`start`	Unknown
`submit_end`	Unknown
`uuid`	Unknown

conversation_template_deployment

Column	Type	Keys
`id`	Unknown	PK
`conversation_tempalate_id`	Unknown	PKFK
`description`	Unknown
`name`	Unknown
`uuid`	Unknown

conversation_template_hrq_participant

Column	Type	Keys
`index`	Unknown	PK
`conversation_template_id`	Unknown	PKFK
`hrq_participants`	Unknown

conversation_template_participant

Column	Type	Keys
`index`	Unknown	PK
`conversation_template_id`	Unknown	PKFK
`participants`	Unknown

conversation_template

Column	Type	Keys
`id`	Unknown	PK
`created_by_id`	Unknown	FK
`updated_by_id`	Unknown	FK
`created`	Unknown
`created_on`	Unknown
`description`	Unknown
`enabled`	Unknown
`hr_admin_permission`	Unknown
`hrq_enabled`	Unknown
`hrq_is_concurrent`	Unknown
`hrq_notification_on_due`	Unknown
`hrq_notification_on_start`	Unknown
`is_goal_creation_enabled`	Unknown
`matrix_manager_can_see_direct_report_responses`	Unknown
`matrix_manager_can_see_responses`	Unknown
`matrix_manager_enabled`	Unknown
`modified_on`	Unknown
`name`	Unknown
`notification_midcycle_days`	Unknown
`notification_on_end`	Unknown
`notification_on_start`	Unknown
`notification_overdue_days`	Unknown
`only_managers_can_initiate`	Unknown
`require_marked_as_met`	Unknown
`skip_level_managers_level`	Unknown
`skip_level_managers_permission`	Unknown
`super_admin_permission`	Unknown
`type`	Unknown
`updated`	Unknown
`uuid`	Unknown

department

Column	Type	Keys
`id`	Unknown	PK
`created_on`	Unknown
`is_active`	Unknown
`modified_on`	Unknown
`name`	Unknown
`parent_id`	Unknown
`parent_name`	Unknown
`parent_uuid`	Unknown
`uuid`	Unknown

feedback_cycle

Column	Type	Keys
`id`	Unknown	PK
`feedback_template_id`	Unknown	PKFK
`cycle_end`	Unknown
`cycle_start`	Unknown
`enable_anytime_nomination`	Unknown
`feedback_start`	Unknown
`grace_period_end`	Unknown
`selection_end`	Unknown
`uuid`	Unknown

feedback_template_allowed_provider

Column	Type	Keys
`id`	Unknown	PK
`feedback_template_id`	Unknown	PKFK
`name`	Unknown
`uuid`	Unknown

feedback_template_allowed_employee

Column	Type	Keys
`id`	Unknown	PK
`feedback_template_id`	Unknown	PKFK
`name`	Unknown
`uuid`	Unknown

feedback_template_question

Column	Type	Keys
`id`	Unknown	PK
`template_id`	Unknown	FK
`hide_number`	Unknown
`mandatory`	Unknown
`options`	Json
`orders`	Unknown
`text`	Unknown
`type`	Unknown
`uuid`	Unknown

feedback_template

Column	Type	Keys
`id`	Unknown	PK
`created`	Unknown
`created_on`	Unknown
`custom_note_enabled`	Unknown
`default_provider_type`	Unknown
`default_providers_includes_direct`	Unknown
`default_providers_includes_manager`	Unknown
`default_providers_includes_peer`	Unknown
`default_providers_limit`	Unknown
`employee_can_choose`	Unknown
`employee_can_view`	Unknown
`employee_see_identity`	Unknown
`enabled`	Unknown
`hold_feedback`	Unknown
`manager_can_choose`	Unknown
`manager_can_view`	Unknown
`manager_see_identity`	Unknown
`modified_on`	Unknown
`name`	Unknown
`notify_cycle_started`	Unknown
`notify_feedback_reminder`	Unknown
`notify_feedback_requested`	Unknown
`questions_locked`	Unknown
`skip_level_can_view`	Unknown
`skip_level_managers_level`	Unknown
`skip_level_see_identity`	Unknown
`summary_visible_employee`	Unknown
`summary_visible_manager`	Unknown
`type`	Unknown
`updated`	Unknown
`uuid`	Unknown

conversations_manager_response

Column	Type	Keys
`id`	Unknown	PK
`conversation_id`	Unknown	PKFK
`answer`	Unknown
`created`	Unknown
`created_on`	Unknown
`lock_date`	Unknown
`modified_on`	Unknown
`question`	Unknown
`question_id`	Unknown
`question_options`	Unknown
`question_uuid`	Unknown
`rating_range`	Unknown
`type`	Unknown
`updated`	Unknown
`uuid`	Unknown

conversations_contributor

Column	Type	Keys
`conversation_id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`response`	Unknown
`status`	Unknown

conversations_employee_response

Column	Type	Keys
`id`	Unknown	PK
`conversation_id`	Unknown	PKFK
`answer`	Unknown
`created`	Unknown
`created_on`	Unknown
`lock_date`	Unknown
`modified_on`	Unknown
`question`	Unknown
`question_id`	Unknown
`question_options`	Unknown
`question_uuid`	Unknown
`rating_range`	Unknown
`type`	Unknown
`updated`	Unknown
`uuid`	Unknown

conversations_post_manager_response

Column	Type	Keys
`id`	Unknown	PK
`conversation_id`	Unknown	PKFK
`answer`	Unknown
`created`	Unknown
`created_on`	Unknown
`lock_date`	Unknown
`modified_on`	Unknown
`question`	Unknown
`question_id`	Unknown
`question_options`	Unknown
`question_uuid`	Unknown
`rating_range`	Unknown
`type`	Unknown
`updated`	Unknown
`uuid`	Unknown

conversations_post_employee_response

Column	Type	Keys
`id`	Unknown	PK
`conversation_id`	Unknown	PKFK
`answer`	Unknown
`created`	Unknown
`created_on`	Unknown
`lock_date`	Unknown
`modified_on`	Unknown
`question`	Unknown
`question_id`	Unknown
`question_options`	Unknown
`question_uuid`	Unknown
`rating_range`	Unknown
`type`	Unknown
`updated`	Unknown
`uuid`	Unknown

conversation

Column	Type	Keys
`id`	Unknown	PK
`created_by_id`	Unknown	FK
`employee_id`	Unknown	FK
`employee_response_created_by_id`	Unknown	FK
`employee_response_updated_by_id`	Unknown	FK
`manager_id`	Unknown	FK
`manager_response_created_by_id`	Unknown	FK
`manager_response_updated_by_id`	Unknown	FK
`post_employee_response_created_by_id`	Unknown	FK
`post_employee_response_updated_by_id`	Unknown	FK
`post_manager_response_created_by_id`	Unknown	FK
`post_manager_response_updated_by_id`	Unknown	FK
`created`	Unknown
`created_on`	Unknown
`deployment_id`	Unknown
`deployment_uuid`	Unknown
`description`	Unknown
`employee_notes`	Unknown
`employee_notes_updated`	Unknown
`employee_response_created`	Unknown
`employee_response_created_on`	Unknown
`employee_response_id`	Unknown
`employee_response_modified_on`	Unknown
`employee_response_shared_on`	Unknown
`employee_response_submitted_on`	Unknown
`employee_response_unlocked_until`	Unknown
`employee_response_updated`	Unknown
`employee_response_uuid`	Unknown
`employee_review_end`	Unknown
`employee_status`	Unknown
`employee_submit_end`	Unknown
`ends`	Unknown
`grace_period_end`	Unknown
`manager_notes`	Unknown
`manager_notes_updated`	Unknown
`manager_response_created`	Unknown
`manager_response_created_on`	Unknown
`manager_response_id`	Unknown
`manager_response_modified_on`	Unknown
`manager_response_shared_on`	Unknown
`manager_response_submitted_on`	Unknown
`manager_response_unlocked_until`	Unknown
`manager_response_updated`	Unknown
`manager_response_uuid`	Unknown
`manager_review_end`	Unknown
`manager_status`	Unknown
`manager_submit_end`	Unknown
`marked_as_met`	Unknown
`modified_on`	Unknown
`name`	Unknown
`post_employee_questionnaire_pending`	Unknown
`post_employee_response_created`	Unknown
`post_employee_response_created_on`	Unknown
`post_employee_response_id`	Unknown
`post_employee_response_modified_on`	Unknown
`post_employee_response_shared_on`	Unknown
`post_employee_response_submitted_on`	Unknown
`post_employee_response_unlocked_until`	Unknown
`post_employee_response_updated`	Unknown
`post_employee_response_uuid`	Unknown
`post_manager_questionnaire_pending`	Unknown
`post_manager_response_created`	Unknown
`post_manager_response_created_on`	Unknown
`post_manager_response_id`	Unknown
`post_manager_response_modified_on`	Unknown
`post_manager_response_shared_on`	Unknown
`post_manager_response_submitted_on`	Unknown
`post_manager_response_unlocked_until`	Unknown
`post_manager_response_updated`	Unknown
`post_manager_response_uuid`	Unknown
`start`	Unknown
`type`	Unknown
`uuid`	Unknown

hashtag

Column	Type	Keys
`id`	Unknown	PK
`created_on`	Unknown
`modified_on`	Unknown
`name`	Unknown

report_run

Column	Type	Keys
`id`	Unknown	PK
`created_by_id`	Unknown	FK
`created`	Unknown
`date_range_end`	Unknown
`date_range_start`	Unknown
`error`	Unknown
`finished`	Unknown
`report`	Unknown
`result_created`	Unknown
`result_expires_on`	Unknown
`result_file_name`	Unknown
`result_type`	Unknown
`result_url`	Unknown
`status`	Unknown
`template`	Unknown

goal_children

Column	Type	Keys
`id`	Unknown	PK
`goal_id`	Unknown	PKFK
`modified_on`	Unknown
`name`	Unknown
`uuid`	Unknown

goal_category

Column	Type	Keys
`id`	Unknown	PK
`goal_id`	Unknown	PKFK
`name`	Unknown
`uuid`	Unknown

goal

Column	Type	Keys
`id`	Unknown	PK
`created_by_id`	Unknown	FK
`last_checked_in_byid`	Unknown	FK
`owner_team_id`	Unknown	FK
`owner_user_id`	Unknown	FK
`parent_id`	Unknown	FK
`updated_by_id`	Unknown	FK
`attribute_scope`	Unknown
`attribute_type`	Unknown
`created`	Unknown
`created_on`	Unknown
`description`	Unknown
`ends`	Unknown
`integration_identifier`	Unknown
`integration_last_sync`	Unknown
`integration_type`	Unknown
`is_key_result`	Unknown
`is_shared_with_downline`	Unknown
`last_checked_in`	Unknown
`measurement_condition`	Unknown
`measurement_current`	Unknown
`measurement_done`	Unknown
`measurement_expected`	Unknown
`measurement_initial`	Unknown
`measurement_is_binary`	Unknown
`measurement_is_numeric`	Unknown
`measurement_lower_limit`	Unknown
`measurement_lower_mid`	Unknown
`measurement_progress`	Unknown
`measurement_target`	Unknown
`measurement_type`	Unknown
`measurement_unit`	Unknown
`measurement_updated`	Unknown
`measurement_upper_limit`	Unknown
`measurement_upper_mid`	Unknown
`modified_on`	Unknown
`name`	Unknown
`owner_group_id`	Unknown
`owner_group_name`	Unknown
`owner_group_parent_id`	Unknown
`owner_group_picture_uris_medium`	Unknown
`owner_group_picture_uris_small`	Unknown
`owner_group_uuid`	Unknown
`owner_team_picture_uris_medium`	Unknown
`owner_team_picture_uris_small`	Unknown
`start`	Unknown
`stats_cheers`	Unknown
`stats_comments`	Unknown
`stats_last_assessed`	Unknown
`stats_nudges`	Unknown
`stats_views`	Unknown
`updated`	Unknown
`uuid`	Unknown
`visibility`	Unknown

team_member

Column	Type	Keys
`id`	Unknown	PK
`team_id`	Unknown	PKFK
`name`	Unknown
`uuid`	Unknown

team

Column	Type	Keys
`id`	Unknown	PK
`created_on`	Unknown
`is_active`	Unknown
`modified_on`	Unknown
`name`	Unknown
`picture_uris_medium`	Unknown
`picture_uris_small`	Unknown
`uuid`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`department_id`	Unknown	FK
`about`	Unknown
`created_on`	Unknown
`deactivated_on`	Unknown
`deactivation_date`	Unknown
`email`	Unknown
`employee_id`	Unknown
`first_name`	Unknown
`is_active`	Unknown
`is_admin`	Unknown
`is_goalmaster`	Unknown
`is_group_admin`	Unknown
`is_super_admin`	Unknown
`last_name`	Unknown
`locale`	Unknown
`manager_id`	Unknown
`manager_name`	Unknown
`manager_uuid`	Unknown
`modified_on`	Unknown
`name`	Unknown
`phone`	Unknown
`preferred_name`	Unknown
`title`	Unknown
`uuid`	Unknown
`attributes_`
`custom_value_`

rating

Column	Type	Keys
`id`	Unknown	PK
`calibration_talent_record_id`	Unknown	PKFK
`max`	Unknown
`min`	Unknown
`rating_type_id`	Unknown
`talent_key`	Unknown
`value`	Unknown
`options_`

nine_box_position

Column	Type	Keys
`index`	Unknown	PK
`calibration_talent_record_id`	Unknown	PKFK
`nine_box_position`	Unknown

calibration_talent_record

Column	Type	Keys
`id`	Unknown	PK
`cycle_id`	Unknown	FK
`comments_employee`	Unknown
`comments_manager`	Unknown
`compensation_raise`	Unknown
`compensation_raise_percent`	Unknown
`created_by`	Unknown
`created_on`	Unknown
`critical_skills`	Unknown
`development_opportunities`	Unknown
`fellowships`	Unknown
`internal_mobility`	Unknown
`modified_by`	Unknown
`modified_on`	Unknown
`nominate_as_mentor`	Unknown
`potential_next_roles`	Unknown
`promotion_promote`	Unknown
`promotion_rationale`	Unknown
`promotion_role`	Unknown
`relocate`	Unknown
`special_program`	Unknown
`subject_id`	Unknown

feedback_request_template_question

Column	Type	Keys
`index`	Unknown	PK
`feedback_request_uuid`	Unknown	PKFK
`template_question`	Unknown

feedback_request_question

Column	Type	Keys
`index`	Unknown	PK
`feedback_request_uuid`	Unknown	PKFK
`hide_number`	Unknown
`id`	Unknown
`mandatory`	Unknown
`option`	Json
`orders`	Unknown
`template_id`	Unknown
`text`	Unknown
`type`	Unknown
`uuid`	Unknown

feedback_request_response

Column	Type	Keys
`index`	Unknown	PK
`feedback_request_uuid`	Unknown	PKFK
`feedback_id`	Unknown	FK
`answer`	Unknown
`hide_number`	Unknown
`id`	Unknown
`multiple_choice_answer`	Unknown
`options_answer`	Unknown
`question`	Unknown
`question_id`	Unknown
`question_option`	Unknown
`rating`	Unknown
`rating_range`	Unknown
`type`	Unknown
`uuid`	Unknown

feedback_request

Column	Type	Keys
`uuid`	Unknown	PK
`created_by_id`	Unknown	FK
`department_id`	Unknown	FK
`feedback_id`	Unknown	FK
`for_user_id`	Unknown	FK
`from_user_id`	Unknown	FK
`requested_by_id`	Unknown	FK
`adhoc_cycle_ends`	Unknown
`adhoc_cycle_id`	Unknown
`adhoc_cycle_notification_reminder_date`	Unknown
`adhoc_cycle_questions_locked`	Unknown
`adhoc_cycle_start`	Unknown
`adhoc_cycle_template_id`	Unknown
`adhoc_cycle_template_name`	Unknown
`can_view_feedback`	Unknown
`created`	Unknown
`created_on`	Unknown
`custom_note`	Unknown
`cycle_enable_anytime_nomination`	Unknown
`cycle_ends`	Unknown
`cycle_feedback_start`	Unknown
`cycle_grace_period_end`	Unknown
`cycle_id`	Unknown
`cycle_selection_end`	Unknown
`cycle_start`	Unknown
`cycle_uuid`	Unknown
`decline_reason`	Unknown
`declined`	Unknown
`employee_can_view`	Unknown
`employee_see_identity`	Unknown
`expired`	Unknown
`feedback_uuid`	Unknown
`hold_feedback`	Unknown
`id`	Unknown
`manager_can_view`	Unknown
`manager_see_identity`	Unknown
`modified_on`	Unknown
`question`	Unknown
`skip_level_can_view`	Unknown
`skip_level_managers_level`	Unknown
`skip_level_see_identity`	Unknown
`status`	Unknown
`template_id`	Unknown
`template_uuid`	Unknown