# Betterworks schema ERD

Table and field reference for the Fivetran Betterworks connector.

## Table & Field Reference

### recognition_mentioned_users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| recognition_id | Unknown | PK, FK |
| name | Unknown |  |
| uuid | Unknown |  |

### recognition_hashtag

| Column | Type | Keys |
| --- | --- | --- |
| recognition_hashtag_id | Unknown | PK, FK |
| recognition_id | Unknown | PK, FK |

### 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 | PK, FK |
| x_label | Unknown |  |

### y_axes_labels

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| calibration_cycle_template_id | Unknown | PK, FK |
| y_label | Unknown |  |

### histogram_content

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| calibration_cycle_template_id | Unknown | PK, FK |
| bg | Unknown |  |
| color | Unknown |  |
| label | Unknown |  |

### talent_record_columns

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| calibration_cycle_template_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| email | Unknown |  |
| is_active | Unknown |  |
| name | Unknown |  |

### conversation_template_allowed_group

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_template_id | Unknown | PK, FK |
| allowed_group | Unknown |  |

### conversation_template_deployments_cycle

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conversation_template_deployment_conversation_tempalate_id | Unknown | PK, FK |
| conversation_template_deployment_id | Unknown | PK, FK |
| 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 | PK, FK |
| description | Unknown |  |
| name | Unknown |  |
| uuid | Unknown |  |

### conversation_template_hrq_participant

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_template_id | Unknown | PK, FK |
| hrq_participants | Unknown |  |

### conversation_template_participant

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_template_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| name | Unknown |  |
| uuid | Unknown |  |

### feedback_template_allowed_employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| feedback_template_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| user_id | Unknown | PK, FK |
| response | Unknown |  |
| status | Unknown |  |

### conversations_employee_response

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| modified_on | Unknown |  |
| name | Unknown |  |
| uuid | Unknown |  |

### goal_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| goal_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| template_question | Unknown |  |

### feedback_request_question

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| feedback_request_uuid | Unknown | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- recognition_mentioned_users(recognition_id) → recognition(id)
- recognition_hashtag(recognition_hashtag_id) → hashtag(id)
- recognition_hashtag(recognition_id) → recognition(id)
- recognition(comment_author_id) → users(id)
- recognition(team_id) → team(id)
- recognition(shoutout_author_id) → users(id)
- recognition(shoutout_for_user_id) → users(id)
- feedback_response(feedback_id) → feedback(id)
- feedback(requested_by_id) → users(id)
- feedback(created_by_id) → users(id)
- feedback(for_user_id) → users(id)
- feedback(cycle_id) → calibration_cycle(id)
- x_axes_labels(calibration_cycle_template_id) → calibration_cycle_template(id)
- y_axes_labels(calibration_cycle_template_id) → calibration_cycle_template(id)
- histogram_content(calibration_cycle_template_id) → calibration_cycle_template(id)
- talent_record_columns(calibration_cycle_template_id) → calibration_cycle_template(id)
- mapping(calibration_cycle_template_id) → calibration_cycle_template(id)
- conversation_template_allowed_employee(conversation_template_id) → conversation_template(id)
- conversation_template_allowed_group(conversation_template_id) → conversation_template(id)
- conversation_template_deployments_cycle(conversation_template_deployment_id) → conversation_template_deployment(id)
- conversation_template_deployments_cycle(conversation_template_deployment_conversation_tempalate_id) → conversation_template_deployment(conversation_tempalate_id)
- conversation_template_deployment(conversation_tempalate_id) → conversation_template(id)
- conversation_template_hrq_participant(conversation_template_id) → conversation_template(id)
- conversation_template_participant(conversation_template_id) → conversation_template(id)
- conversation_template(created_by_id) → users(id)
- conversation_template(updated_by_id) → users(id)
- feedback_cycle(feedback_template_id) → feedback_template(id)
- feedback_template_allowed_provider(feedback_template_id) → feedback_template(id)
- feedback_template_allowed_employee(feedback_template_id) → feedback_template(id)
- feedback_template_question(template_id) → feedback_template(id)
- conversations_manager_response(conversation_id) → conversation(id)
- conversations_contributor(user_id) → users(id)
- conversations_contributor(conversation_id) → conversation(id)
- conversations_employee_response(conversation_id) → conversation(id)
- conversations_post_manager_response(conversation_id) → conversation(id)
- conversations_post_employee_response(conversation_id) → conversation(id)
- conversation(manager_id) → users(id)
- conversation(employee_id) → users(id)
- conversation(created_by_id) → users(id)
- conversation(employee_response_updated_by_id) → users(id)
- conversation(employee_response_created_by_id) → users(id)
- conversation(manager_response_updated_by_id) → users(id)
- conversation(manager_response_created_by_id) → users(id)
- conversation(post_manager_response_updated_by_id) → users(id)
- conversation(post_manager_response_created_by_id) → users(id)
- conversation(post_employee_response_updated_by_id) → users(id)
- conversation(post_employee_response_created_by_id) → users(id)
- report_run(created_by_id) → users(id)
- goal_children(goal_id) → goal(id)
- goal_category(goal_id) → goal(id)
- goal(owner_user_id) → users(id)
- goal(owner_team_id) → team(id)
- goal(updated_by_id) → users(id)
- goal(last_checked_in_byid) → users(id)
- goal(parent_id) → users(id)
- goal(created_by_id) → users(id)
- team_member(team_id) → team(id)
- users(department_id) → department(id)
- rating(calibration_talent_record_id) → calibration_talent_record(id)
- nine_box_position(calibration_talent_record_id) → calibration_talent_record(id)
- calibration_talent_record(cycle_id) → calibration_cycle(id)
- feedback_request_template_question(feedback_request_uuid) → feedback_request(uuid)
- feedback_request_question(feedback_request_uuid) → feedback_request(uuid)
- feedback_request_response(feedback_id) → feedback(id)
- feedback_request_response(feedback_request_uuid) → feedback_request(uuid)
- feedback_request(department_id) → department(id)
- feedback_request(requested_by_id) → users(id)
- feedback_request(created_by_id) → users(id)
- feedback_request(from_user_id) → users(id)
- feedback_request(for_user_id) → users(id)
- feedback_request(feedback_id) → feedback(id)