# Workleap Officevibe schema ERD

Table and field reference for the Fivetran Workleap Officevibe connector.

## Table & Field Reference

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_type | Unknown |  |
| name | Unknown |  |

### group_user

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK, FK |
| group_id | Unknown | PK, FK |

### feedback_label

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| color | Unknown |  |
| title | Unknown |  |

### engagement_metric_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| engagement_date | Unknown | PK, FK |
| display_name | Unknown |  |
| value | Unknown |  |

### engagement

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| group_name | Unknown |  |

### user_managed_group

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_email | Unknown | PK, FK |
| managed_group | Unknown |  |

### user_member_group

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_email | Unknown | PK, FK |
| member_group | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| first_name | Unknown |  |
| fist_name | Unknown |  |
| is_admin | Unknown |  |
| is_company_manager | Unknown |  |
| is_group_manager | Unknown |  |
| job_title | Unknown |  |
| last_name | Unknown |  |
| user_name | Unknown |  |

### feedback_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| feedback_id | Unknown | PK, FK |
| tags | Unknown | FK |

### feedback_reply

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| feedback_id | Unknown | PK, FK |
| user_email | Unknown | FK |
| creation_date | Unknown |  |
| message | Unknown |  |
| user_display_name | Unknown |  |

### feedback

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_email | Unknown | FK |
| creation_date | Unknown |  |
| last_modification_date | Unknown |  |
| message | Unknown |  |
| network_id | Unknown |  |
| question_asked | Unknown |  |
| user_display_name | Unknown |  |

## Relationships

- group_user(email) → users(email)
- group_user(group_id) → groups(id)
- engagement_metric_value(engagement_date) → engagement(date)
- user_managed_group(user_email) → users(email)
- user_member_group(user_email) → users(email)
- feedback_tag(tags) → feedback_label(id)
- feedback_tag(feedback_id) → feedback(id)
- feedback_reply(user_email) → users(email)
- feedback_reply(feedback_id) → feedback(id)
- feedback(user_email) → users(email)