Circle Community Platform

Explore the interactive ERD

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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`name`	Unknown
`slug`	Unknown
`type`	Unknown

community_event_space_member

Column	Type	Keys
`community_event_id`	Unknown	PKFK
`community_member_id`	Unknown	PKFK
`space_id`	Unknown	PKFK
`type`	Unknown

community_event_space_group

Column	Type	Keys
`id`	Unknown	PK
`community_event_id`	Unknown	PKFK
`name`	Unknown
`slug`	Unknown
`type`	Unknown

community_event_space_group_member

Column	Type	Keys
`id`	Unknown	PK
`community_event_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`chat_room_id`	Unknown	FK
`type`	Unknown

community_event_lesson

Column	Type	Keys
`id`	Unknown	PK
`community_event_id`	Unknown	PKFK
`type`	Unknown

community_event_section

Column	Type	Keys
`id`	Unknown	PK
`community_event_id`	Unknown	PKFK
`space_id`	Unknown	FK
`type`	Unknown

community_event_quiz_attempt

Column	Type	Keys
`id`	Unknown	PK
`community_event_id`	Unknown	PKFK
`grade`	Unknown
`quiz_id`	Unknown
`result`	Unknown
`type`	Unknown

community_event_posts_event

Column	Type	Keys
`id`	Unknown	PK
`community_event_id`	Unknown	PKFK
`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	PKFK
`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