# Circle Community Platform schema ERD

Table and field reference for the Fivetran Circle Community Platform connector.

## Table & Field Reference

### analytics_tracker_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| community_member_id | Unknown | FK |
| initiator_id | Unknown | FK |
| initiator_public_uid | Unknown | FK |
| post_id | Unknown | FK |
| space_id | Unknown | FK |
| created_at | Instant |  |
| initiator_email | Unknown |  |
| initiator_first_name | Unknown |  |
| initiator_is_admin | Unknown |  |
| initiator_is_moderator | Unknown |  |
| initiator_last_name | Unknown |  |
| initiator_name | Unknown |  |
| name | Unknown |  |
| properties_ahoy_visitor | Unknown |  |
| properties_app_type | Unknown |  |
| properties_browser_family | Unknown |  |
| properties_browser_name | Unknown |  |
| properties_browser_version | Unknown |  |
| properties_city | Unknown |  |
| properties_community_id | Unknown |  |
| properties_community_member_id | Unknown |  |
| properties_country | Unknown |  |
| properties_country_code | Unknown |  |
| properties_device | Unknown |  |
| properties_device_brand | Unknown |  |
| properties_device_id | Unknown |  |
| properties_device_name | Unknown |  |
| properties_device_type | Unknown |  |
| properties_duration | Unknown |  |
| properties_is_bot | Unknown |  |
| properties_is_desktop | Unknown |  |
| properties_is_mobile | Unknown |  |
| properties_is_tablet | Unknown |  |
| properties_os_family | Unknown |  |
| properties_os_name | Unknown |  |
| properties_os_version | Unknown |  |
| properties_page_view_id | Unknown |  |
| properties_platform | Unknown |  |
| properties_post_id | Unknown |  |
| properties_post_view_id | Unknown |  |
| properties_postal_code | Unknown |  |
| properties_referer | Unknown |  |
| properties_screen | Unknown |  |
| properties_screen_time_seconds | Unknown |  |
| properties_space_id | Unknown |  |
| properties_state | Unknown |  |
| properties_state_code | Unknown |  |
| properties_time_spent_seconds | Unknown |  |
| properties_url | Unknown |  |
| properties_user_agent | Unknown |  |
| properties_user_id | Unknown |  |
| triggered_at | Instant |  |
| version | Unknown |  |

### community_event_initiator

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| community_event_id | Unknown | PK, FK |
| email | Unknown |  |
| first_name | Unknown |  |
| is_admin | Unknown |  |
| is_moderator | Unknown |  |
| last_name | Unknown |  |
| name | Unknown |  |
| public_uid | Unknown |  |
| type | Unknown |  |

### community_event_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| community_event_id | Unknown | PK, FK |
| community_member_id | Unknown | FK |
| parent_comment_id | Unknown | FK |
| post_id | Unknown | FK |
| record_owner_is_admin | Unknown |  |
| type | Unknown |  |

### community_event_posts_basic

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| community_event_id | Unknown | PK, FK |
| community_member_id | Unknown | FK |
| space_id | Unknown | FK |
| name | Unknown |  |
| published_at | Instant |  |
| record_owner_is_admin | Unknown |  |
| slug | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### community_event_space

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| community_event_id | Unknown | PK, FK |
| name | Unknown |  |
| slug | Unknown |  |
| type | Unknown |  |

### community_event_space_member

| Column | Type | Keys |
| --- | --- | --- |
| community_event_id | Unknown | PK, FK |
| community_member_id | Unknown | PK, FK |
| space_id | Unknown | PK, FK |
| type | Unknown |  |

### community_event_space_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| community_event_id | Unknown | PK, FK |
| name | Unknown |  |
| slug | Unknown |  |
| type | Unknown |  |

### community_event_space_group_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| community_event_id | Unknown | PK, FK |
| community_member_id | Unknown | FK |
| space_group_id | Unknown | FK |
| type | Unknown |  |

### community_event_chat_room

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| community_event_id | Unknown | PK, FK |
| parent_id | Unknown | FK |
| is_embedded | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| uuid | Unknown |  |

### community_event_chat_room_message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| community_event_id | Unknown | PK, FK |
| chat_room_id | Unknown | FK |
| type | Unknown |  |

### community_event_lesson

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| community_event_id | Unknown | PK, FK |
| type | Unknown |  |

### community_event_section

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| community_event_id | Unknown | PK, FK |
| space_id | Unknown | FK |
| type | Unknown |  |

### community_event_quiz_attempt

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| community_event_id | Unknown | PK, FK |
| grade | Unknown |  |
| quiz_id | Unknown |  |
| result | Unknown |  |
| type | Unknown |  |

### community_event_posts_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| community_event_id | Unknown | PK, FK |
| community_member_id | Unknown | FK |
| space_id | Unknown | FK |
| is_recurring | Unknown |  |
| name | Unknown |  |
| published_at | Instant |  |
| record_owner_is_admin | Unknown |  |
| slug | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### community_event_member_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| community_event_id | Unknown | PK, FK |
| color | Unknown |  |
| display_format | Unknown |  |
| is_public | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### community_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| name | Unknown |  |
| recurring_event_setting_type | Unknown |  |
| triggered_at | Instant |  |
| version | Unknown |  |

## Relationships

- analytics_tracker_event(initiator_id) → community_event_initiator(id)
- analytics_tracker_event(initiator_public_uid) → community_event_initiator(public_uid)
- analytics_tracker_event(post_id) → community_event_posts_basic(id)
- analytics_tracker_event(space_id) → community_event_space_member(space_id)
- analytics_tracker_event(community_member_id) → community_event_initiator(id)
- community_event_initiator(community_event_id) → community_event(id)
- community_event_comment(post_id) → community_event_posts_basic(id)
- community_event_comment(community_member_id) → community_event_initiator(id)
- community_event_comment(parent_comment_id) → community_event_comment(id)
- community_event_comment(community_event_id) → community_event(id)
- community_event_posts_basic(space_id) → community_event_space(id)
- community_event_posts_basic(community_member_id) → community_event_initiator(id)
- community_event_posts_basic(community_event_id) → community_event(id)
- community_event_space(community_event_id) → community_event(id)
- community_event_space_member(space_id) → community_event_space(id)
- community_event_space_member(community_member_id) → community_event_initiator(id)
- community_event_space_member(community_event_id) → community_event(id)
- community_event_space_group(community_event_id) → community_event(id)
- community_event_space_group_member(community_member_id) → community_event_initiator(id)
- community_event_space_group_member(space_group_id) → community_event_space_group(id)
- community_event_space_group_member(community_event_id) → community_event(id)
- community_event_chat_room(parent_id) → community_event_space(id)
- community_event_chat_room(community_event_id) → community_event(id)
- community_event_chat_room_message(chat_room_id) → community_event_chat_room(id)
- community_event_chat_room_message(community_event_id) → community_event(id)
- community_event_lesson(community_event_id) → community_event(id)
- community_event_section(space_id) → community_event_space(id)
- community_event_section(community_event_id) → community_event(id)
- community_event_quiz_attempt(community_event_id) → community_event(id)
- community_event_posts_event(space_id) → community_event_space(id)
- community_event_posts_event(community_member_id) → community_event_initiator(id)
- community_event_posts_event(community_event_id) → community_event(id)
- community_event_member_tag(community_event_id) → community_event(id)