# Konnect Insights schema ERD

Table and field reference for the Fivetran Konnect Insights connector.

## Table & Field Reference

### groups

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

### classification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| parent_classification_id | Unknown | FK |
| profile_id | Unknown | FK |
| created_at | Unknown |  |
| hierarchy | Unknown |  |
| level | Unknown |  |
| name | Unknown |  |

### additional_info

| Column | Type | Keys |
| --- | --- | --- |
| conversation_custom_field_id | Unknown | PK |
| group_id | Unknown | FK |
| created_at | Unknown |  |
| field | Unknown |  |
| field_name | Unknown |  |
| field_type | Unknown |  |
| field_values | Unknown |  |
| type | Unknown |  |

### topic

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| created_at | Unknown |  |
| created_by | Unknown |  |
| name | Unknown |  |

### message_cluster

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cluster_id | Unknown | FK |
| group_id | Unknown | FK |
| case_type | Unknown |  |
| classification_1 | Unknown |  |
| classification_1_sentiment | Unknown |  |
| classification_2 | Unknown |  |
| classification_3 | Unknown |  |
| classification_msg | Unknown |  |
| classified_by | Unknown |  |
| classified_comment | Unknown |  |
| classified_date | Unknown |  |
| gender | Unknown |  |
| is_classification_automated | Unknown |  |
| is_classified | Unknown |  |
| languages | Unknown |  |
| likes_count | Unknown |  |
| link | Unknown |  |
| media_type | Unknown |  |
| message_title | Unknown |  |
| profile_id | Unknown |  |
| profile_name | Unknown |  |
| publish_date | Unknown |  |
| sentiment | Unknown |  |
| star_rating | Unknown |  |
| ticket_date | Unknown |  |
| ticket_id | Unknown |  |
| ticket_status | Unknown |  |
| title | Unknown |  |
| unique_contact_id | Unknown |  |
| unique_message_id | Unknown |  |
| user_favourites_count | Unknown |  |
| user_image_url | Unknown |  |
| user_name | Unknown |  |
| user_profile_url | Unknown |  |
| user_unique_name | Unknown |  |

### profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| created_at | Unknown |  |
| created_by | Unknown |  |
| location_data | Unknown |  |
| logo_html | Unknown |  |
| media | Unknown |  |
| name | Unknown |  |
| page_user_id | Unknown |  |

### message_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| profile_id | Unknown | FK |
| case_type | Unknown |  |
| classification_1 | Unknown |  |
| classification_1_sentiment | Unknown |  |
| classification_2 | Unknown |  |
| classification_3 | Unknown |  |
| classification_msg | Unknown |  |
| classified_by | Unknown |  |
| classified_comment | Unknown |  |
| classified_date | Unknown |  |
| gender | Unknown |  |
| is_classification_automated | Unknown |  |
| is_classified | Unknown |  |
| languages | Unknown |  |
| likes_count | Unknown |  |
| link | Unknown |  |
| media_type | Unknown |  |
| message_title | Unknown |  |
| profile_name | Unknown |  |
| publish_date | Unknown |  |
| sentiment | Unknown |  |
| star_rating | Unknown |  |
| ticket_date | Unknown |  |
| ticket_id | Unknown |  |
| ticket_status | Unknown |  |
| title | Unknown |  |
| unique_contact_id | Unknown |  |
| unique_message_id | Unknown |  |
| user_favourites_count | Unknown |  |
| user_image_url | Unknown |  |
| user_name | Unknown |  |
| user_profile_url | Unknown |  |
| user_unique_name | Unknown |  |

### message_topic

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| topic_id | Unknown | FK |
| case_type | Unknown |  |
| classification_1 | Unknown |  |
| classification_1_sentiment | Unknown |  |
| classification_2 | Unknown |  |
| classification_3 | Unknown |  |
| country | Unknown |  |
| gender | Unknown |  |
| is_classification_automated | Unknown |  |
| is_classified | Unknown |  |
| is_replied_tweet | Unknown |  |
| is_retweeted_tweet | Unknown |  |
| languages | Unknown |  |
| likes_count | Unknown |  |
| media_type | Unknown |  |
| profile_id | Unknown |  |
| profile_name | Unknown |  |
| sentiment | Unknown |  |
| shares_count | Unknown |  |
| star_rating | Unknown |  |
| ticket_date | Unknown |  |
| ticket_id | Unknown |  |
| ticket_status | Unknown |  |
| title | Unknown |  |
| unique_contact_id | Unknown |  |
| unique_message_id | Unknown |  |
| user_favourites_count | Unknown |  |

### commenter_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| type | Unknown |  |

### commenter_level

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| level | Unknown |  |

### conversation_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| type | Unknown |  |

### cluster

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| created_at | Unknown |  |
| created_by | Unknown |  |
| name | Unknown |  |

### severity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| type | Unknown | PK |
| group_id | Unknown | FK |
| and_contain | Unknown |  |
| color | Unknown |  |
| contain | Unknown |  |
| created_at | Unknown |  |
| display_name | Unknown |  |
| does_not_contain | Unknown |  |
| followers_greater_than | Unknown |  |
| followers_less_than | Unknown |  |
| sentiment_name | Unknown |  |
| sentiments | Unknown |  |

## Relationships

- classification(profile_id) → profile(id)
- classification(parent_classification_id) → classification(id)
- classification(group_id) → groups(id)
- additional_info(group_id) → groups(id)
- topic(group_id) → groups(id)
- message_cluster(group_id) → groups(id)
- message_cluster(cluster_id) → cluster(id)
- profile(group_id) → groups(id)
- message_profile(profile_id) → profile(id)
- message_profile(group_id) → groups(id)
- message_topic(group_id) → groups(id)
- message_topic(topic_id) → topic(id)
- commenter_type(group_id) → groups(id)
- commenter_level(group_id) → groups(id)
- conversation_type(group_id) → groups(id)
- cluster(group_id) → groups(id)
- severity(group_id) → groups(id)