# Culture Amp schema ERD

Table and field reference for the Fivetran Culture Amp connector.

## Table & Field Reference

### performance_cycle

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| name | Unknown |  |
| processed_at | Unknown |  |
| state | Unknown |  |
| updated_at | Instant |  |

### manager_review_multiple_choice_option

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| manager_review_id | Unknown | PK, FK |
| multiple_choice_index | Unknown | PK, FK |
| option | Unknown |  |

### manager_review_multiple_choice

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| manager_review_id | Unknown | PK, FK |
| answer | Unknown |  |
| text | Unknown |  |

### manager_review_open_text_question

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| manager_review_id | Unknown | PK, FK |
| answer | Unknown |  |
| text | Unknown |  |

### manager_review_performance_rating_bucket

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| manager_review_id | Unknown | PK, FK |
| created_at | Unknown |  |
| description | Unknown |  |
| id | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |

### manager_review_performance_rating_question

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| manager_review_id | Unknown | PK, FK |
| description | Unknown |  |
| title | Unknown |  |

### manager_review_performance_rating

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| manager_review_id | Unknown | PK, FK |
| created_at | Unknown |  |
| description | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |

### manager_review

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| manager_id | Unknown | FK |
| performance_cycle_id | Unknown | FK |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| processed_at | Unknown |  |
| review_acknowledged | Unknown |  |
| status | Unknown |  |
| updated_at | Instant |  |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| birth_date | Unknown |  |
| email | Unknown |  |
| end_date | Unknown |  |
| identifier | Unknown |  |
| name | Unknown |  |
| processed_at | Unknown |  |
| start_date | Unknown |  |

## Relationships

- manager_review_multiple_choice_option(manager_review_id) → manager_review_multiple_choice(manager_review_id)
- manager_review_multiple_choice_option(multiple_choice_index) → manager_review_multiple_choice(index)
- manager_review_multiple_choice(manager_review_id) → manager_review(id)
- manager_review_open_text_question(manager_review_id) → manager_review(id)
- manager_review_performance_rating_bucket(manager_review_id) → manager_review(id)
- manager_review_performance_rating_question(manager_review_id) → manager_review(id)
- manager_review_performance_rating(manager_review_id) → manager_review(id)
- manager_review(performance_cycle_id) → performance_cycle(id)
- manager_review(manager_id) → employee(id)
- manager_review(employee_id) → employee(id)