Konnect Insights
Explore the interactive ERD
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 |