# Khoros Communities schema ERD

Table and field reference for the Fivetran Khoros Communities connector.

## Table & Field Reference

### export_community_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| document_id | Unknown | PK, FK |
| label | Unknown |  |

### product_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| document_id | Unknown | PK, FK |
| product_tag | Unknown |  |

### request_header_referrer_url

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| document_id | Unknown | PK, FK |
| request_header_referrer_url | Unknown |  |

### request_header_referrer_host

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| document_id | Unknown | PK, FK |
| request_header_referrer_host | Unknown |  |

### export_community

| Column | Type | Keys |
| --- | --- | --- |
| document_id | Unknown | PK |
| action_duration | Unknown |  |
| action_is_moderator_action | Unknown |  |
| action_is_solution_view | Unknown |  |
| action_key | Unknown |  |
| action_span_second | Unknown |  |
| action_weight | Unknown |  |
| badge_activation_date | Unknown |  |
| badge_is_retroactive | Unknown |  |
| badge_title | Unknown |  |
| badge_uid | Unknown |  |
| board_title | Unknown |  |
| board_uid | Unknown |  |
| community_app | Unknown |  |
| community_audit_board_com | Unknown |  |
| conversation_title | Unknown |  |
| conversation_uid | Unknown |  |
| event_time_ms | Unknown |  |
| group_hub_uid | Unknown |  |
| message_is_topic | Unknown |  |
| message_subject | Unknown |  |
| message_type | Unknown |  |
| message_uid | Unknown |  |
| node_ancestor_path | Unknown |  |
| occasion_end_time | Unknown |  |
| occasion_is_invited | Unknown |  |
| occasion_rsvp_response | Unknown |  |
| occasion_start_time | Unknown |  |
| parent_conversation_uid | Unknown |  |
| private_message_new_thread | Unknown |  |
| private_message_type | Unknown |  |
| product_is_product_page | Unknown |  |
| product_mention | Unknown |  |
| product_title | Unknown |  |
| product_uid | Unknown |  |
| request_device | Unknown |  |
| request_geo_city | Unknown |  |
| request_geo_country | Unknown |  |
| request_geo_country_code | Unknown |  |
| request_geo_geohash | Unknown |  |
| request_geo_latitude | Unknown |  |
| request_geo_longitude | Unknown |  |
| request_geo_postal | Unknown |  |
| request_geo_region | Unknown |  |
| request_geo_timezone | Unknown |  |
| request_headers_user_agent | Unknown |  |
| request_url_host | Unknown |  |
| search_entity_type | Unknown |  |
| search_filter | Unknown |  |
| search_has_result | Unknown |  |
| search_is_promoted_search_result | Unknown |  |
| search_location | Unknown |  |
| search_page_number | Unknown |  |
| search_result | Unknown |  |
| search_terms | Unknown |  |
| search_type | Unknown |  |
| status | Unknown |  |
| subscription_type | Unknown |  |
| survey_id | Unknown |  |
| survey_response | Unknown |  |
| survey_type | Unknown |  |
| tags | Unknown |  |
| target_user_community_rank_name | Unknown |  |
| target_user_community_role_name | Unknown |  |
| target_user_login | Unknown |  |
| target_user_registration_status | Unknown |  |
| target_user_sso_id | Unknown |  |
| target_user_uid | Unknown |  |
| user_community_rank_name | Unknown |  |
| user_community_role_name | Unknown |  |
| user_login | Unknown |  |
| user_registration_status | Unknown |  |
| user_sso_id | Unknown |  |
| user_uid | Unknown |  |
| visit_id | Unknown |  |
| visitor_id | Unknown |  |

## Relationships

- export_community_label(document_id) → export_community(document_id)
- product_tag(document_id) → export_community(document_id)
- request_header_referrer_url(document_id) → export_community(document_id)
- request_header_referrer_host(document_id) → export_community(document_id)