# 15Five schema ERD

Table and field reference for the Fivetran 15Five connector.

## Table & Field Reference

### high_five_receiver

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| high_five_id | Unknown | PK, FK |
| receiver_id | Unknown | FK |
| url | Unknown |  |

### high_five_email_receiver

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| high_five_id | Unknown | PK, FK |
| email | Unknown |  |

### high_five

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_detail_id | Unknown | FK |
| create_ts | Instant |  |
| creator | Unknown |  |
| creator_id | Unknown |  |
| report | Unknown |  |
| text | Unknown |  |

### security_audit

| Column | Type | Keys |
| --- | --- | --- |
| create_ts | Unknown | PK |
| actor | Unknown | FK |
| type | Unknown |  |
| custom_** |  |  |

### group_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_group_set | Json | FK |
| create_ts | Unknown |  |
| name_plural | Unknown |  |
| name_singular | Unknown |  |

### feature

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| demographic_attribute | Unknown |  |
| pulse | Unknown |  |

### one_on_one

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_1_details_id | Unknown | FK |
| user_2_details_id | Unknown | FK |
| create_ts | Unknown |  |
| end_ts | Unknown |  |
| for_date | Unknown |  |
| is_draft | Unknown |  |
| user_1 | Unknown |  |
| user_1_role | Unknown |  |
| user_2 | Unknown |  |
| user_2_role | Unknown |  |

### user_vacation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| creation_date | Unknown |  |
| end_dt | Unknown |  |
| note | Unknown |  |
| start_dt | Unknown |  |

### review_cycle_participant

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| review_cycle_id | Unknown | PK, FK |
| participant_id | Unknown | FK |

### review_cycle

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_detail_id | Unknown | FK |
| actual_start_ts | Unknown |  |
| create_ts | Instant |  |
| cycle_end_ts | Unknown |  |
| cycle_start_ts | Unknown |  |
| days_remaining | Unknown |  |
| does_manager_review | Unknown |  |
| does_peer_review | Unknown |  |
| does_self_review | Unknown |  |
| does_upward_review | Unknown |  |
| hierarchy_update_ts | Instant |  |
| lock_ts | Unknown |  |
| manager_review_end_ts | Unknown |  |
| name | Unknown |  |
| peer_manager_approval_due_ts | Unknown |  |
| peer_review_end_ts | Unknown |  |
| peer_review_template_id | Unknown |  |
| peer_review_template_name | Unknown |  |
| peer_review_transparency | Unknown |  |
| peer_selection_due_ts | Unknown |  |
| self_review_end_ts | Unknown |  |
| share_and_finalize_end_ts | Unknown |  |
| statistics_number_of_reviews_completed | Unknown |  |
| statistics_number_of_reviews_uncompleted | Unknown |  |
| status | Unknown |  |
| template_id | Unknown |  |
| template_name | Unknown |  |
| update_ts | Instant |  |
| upward_review_end_ts | Unknown |  |
| upward_review_template_id | Unknown |  |
| upward_review_template_name | Unknown |  |
| upward_review_transparency | Unknown |  |
| viewing_permissions | Unknown |  |

### question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| groups | Unknown |  |
| is_active | Unknown |  |
| is_optional | Unknown |  |
| metrics_params | Json |  |
| question_frequency | Unknown |  |
| question_text | Unknown |  |
| question_type | Unknown |  |
| users | Unknown |  |

### check_in_comment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| check_in_id | Unknown | FK |
| comment_text | Unknown |  |
| users | Unknown |  |

### check_in_goal

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| check_in_id | Unknown | FK |
| goals | Json |  |

### check_in_accomplishment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| check_in_id | Unknown | FK |
| goals | Json |  |

### check_in

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| due_date | Unknown |  |
| high_five | Json |  |
| objective | Json |  |
| reporting_period | Unknown |  |
| reporting_period_end | Unknown |  |
| reporting_period_start | Unknown |  |
| reviewed_by | Unknown |  |
| reviewed_ts | Unknown |  |
| submit_ts | Unknown |  |
| users | Unknown |  |
| was_submitted_late | Unknown |  |

### check_in_answer

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| answer_text | Unknown |  |
| check_in_id | Unknown |  |
| create_ts | Unknown |  |
| goal_completed_ts | Unknown |  |
| goal_status | Unknown |  |
| goal_status_comment | Json |  |
| metrics_value | Unknown |  |
| object_type | Unknown |  |
| question_text | Unknown |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| create_ts | Unknown |  |
| group_admin | Json |  |
| group_type | Unknown |  |
| group_type_name | Unknown |  |
| is_peer_drilldown | Unknown |  |
| is_peer_view | Unknown |  |
| member | Json |  |
| members_count | Unknown |  |
| mention_name | Unknown |  |
| name | Unknown |  |
| skip_company_wide_question | Unknown |  |

### company_group_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| company_group_id | Unknown | FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bi_weekly_due_day | Unknown |  |
| bi_weekly_due_day_which_week | Unknown |  |
| current_checkin_streak | Unknown |  |
| due_day | Unknown |  |
| email | Unknown |  |
| employee_id | Unknown |  |
| first_login_ts | Unknown |  |
| first_name | Unknown |  |
| hire_date_ts | Unknown |  |
| is_active | Unknown |  |
| is_company_admin | Unknown |  |
| is_reporter | Unknown |  |
| is_reviewer | Unknown |  |
| last_login_ts | Unknown |  |
| last_name | Unknown |  |
| location | Unknown |  |
| mention_name | Unknown |  |
| monthly_due_day | Unknown |  |
| monthly_due_day_which_in_month | Unknown |  |
| phone | Unknown |  |
| reporting_period | Unknown |  |
| reviewer_id | Unknown |  |
| skip_company_wide_question | Unknown |  |
| start_date_ts | Unknown |  |
| title | Unknown |  |

### answer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| answer_text | Unknown |  |
| comment | Json |  |
| create_ts | Unknown |  |
| goal_completed_ts | Unknown |  |
| goal_status | Unknown |  |
| goal_status_comment | Json |  |
| metrics_value | Unknown |  |
| question | Unknown |  |
| users | Unknown |  |

### pulse

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| create_ts | Unknown |  |
| report | Unknown |  |
| users | Unknown |  |
| value | Unknown |  |

### people_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| datatype | Unknown |  |
| is_default | Unknown |  |
| is_only_admin_editable | Unknown |  |
| name | Unknown |  |
| slug | Unknown |  |

## Relationships

- high_five_receiver(receiver_id) → users(id)
- high_five_receiver(high_five_id) → high_five(id)
- high_five_email_receiver(high_five_id) → high_five(id)
- high_five(creator_detail_id) → users(id)
- security_audit(actor) → users(id)
- group_type(company_group_set) → groups(id)
- one_on_one(user_2_details_id) → users(id)
- one_on_one(user_1_details_id) → users(reviewer_id)
- user_vacation(user_id) → users(id)
- review_cycle_participant(participant_id) → users(id)
- review_cycle_participant(review_cycle_id) → review_cycle(id)
- review_cycle(creator_detail_id) → users(id)
- check_in_comment(check_in_id) → check_in(id)
- check_in_goal(check_in_id) → check_in(id)
- check_in_accomplishment(check_in_id) → check_in(id)
- company_group_id(company_group_id) → groups(id)
- company_group_id(users_id) → users(id)