Fivetran documentation

Search the docs

/

Threads

Explore the interactive ERD

Table & Field Reference

media_insight_value

Column	Type	Keys
`index`	Unknown	PK
`media_insight_id`	Unknown	PKFK
`value`	Unknown

media_insight

Column	Type	Keys
`id`	Unknown	PK
`user_thread_id`	Unknown	PKFK
`description`	Unknown
`name`	Unknown
`period`	Unknown
`title`	Unknown

user_thread

Column	Type	Keys
`id`	Unknown	PK
`owner_id`	Unknown	FK
`alt_text`	Unknown
`children`	Json
`ghost_post_expiration_timestamp`	Instant
`ghost_post_status`	Unknown
`gif_url`	Unknown
`has_replies`	Unknown
`is_quote_post`	Unknown
`is_spoiler_media`	Unknown
`is_verified`	Unknown
`link_attachment_url`	Unknown
`media_product_type`	Unknown
`media_type`	Unknown
`media_url`	Unknown
`permalink`	Unknown
`poll_attachment`	Json
`post_timestamp`	Instant
`profile_picture_url`	Unknown
`quoted_post_id`	Unknown
`reply_audience`	Unknown
`reposted_post_id`	Unknown
`shortcode`	Unknown
`text`	Unknown
`text_attachment`	Json
`text_entities`	Json
`thumbnail_url`	Unknown
`topic_tag`	Unknown
`username`	Unknown

profile

Column	Type	Keys
`id`	Unknown	PK
`biography`	Unknown
`is_verified`	Unknown
`name`	Unknown
`profile_picture_url`	Unknown
`username`	Unknown

mention_child

Column	Type	Keys
`id`	Unknown	PK
`mention_id`	Unknown	PKFK

mention

Column	Type	Keys
`id`	Unknown	PK
`alt_text`	Unknown
`gif_url`	Unknown
`has_replies`	Unknown
`is_quote_post`	Unknown
`is_reply`	Unknown
`is_spoiler_media`	Unknown
`link_attachment_url`	Unknown
`media_product_type`	Unknown
`media_type`	Unknown
`media_url`	Unknown
`permalink`	Unknown
`post_timestamp`	Instant
`quoted_post_id`	Unknown
`replied_to_id`	Unknown
`reply_audience`	Unknown
`reposted_post_id`	Unknown
`root_post_id`	Unknown
`shortcode`	Unknown
`text`	Unknown
`text_attachment_background_color`	Unknown
`text_attachment_text`	Unknown
`text_entities_spoiler`	Unknown
`thumbnail_url`	Unknown
`username`	Unknown

media_reply_child

Column	Type	Keys
`id`	Unknown	PK
`media_reply_id`	Unknown	PKFK

media_reply_poll_option

Column	Type	Keys
`index`	Unknown	PK
`media_reply_id`	Unknown	PKFK
`label`	Unknown
`vote_count`	Unknown

media_reply

Column	Type	Keys
`id`	Unknown	PK
`user_thread_id`	Unknown	PKFK
`gif_url`	Unknown
`has_replies`	Unknown
`hide_status`	Unknown
`is_quote_post`	Unknown
`is_reply`	Unknown
`is_reply_owned_by_me`	Unknown
`is_verified`	Unknown
`media_product_type`	Unknown
`media_type`	Unknown
`media_url`	Unknown
`permalink`	Unknown
`poll_attachment_expiration`	Unknown
`post_timestamp`	Instant
`profile_picture_url`	Unknown
`quoted_post_id`	Unknown
`replied_to_id`	Unknown
`reply_audience`	Unknown
`reposted_post_id`	Unknown
`root_post_id`	Unknown
`shortcode`	Unknown
`text`	Unknown
`thumbnail_url`	Unknown
`topic_tag`	Unknown
`username`	Unknown

insight_daily_view

Column	Type	Keys
`end_time`	Instant	PK
`insight_id`	Unknown	PKFK
`value`	Unknown

insight_link_value

Column	Type	Keys
`index`	Unknown	PK
`insight_id`	Unknown	PKFK
`link_url`	Unknown
`value`	Unknown

insight

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`description`	Unknown
`name`	Unknown
`period`	Unknown
`title`	Unknown
`total_value_value`	Unknown

media_pending_reply_child

Column	Type	Keys
`id`	Unknown	PK
`media_pending_reply_id`	Unknown	PKFK

media_pending_reply_poll_option

Column	Type	Keys
`index`	Unknown	PK
`media_pending_reply_id`	Unknown	PKFK
`label`	Unknown
`vote_count`	Unknown

media_pending_reply

Column	Type	Keys
`id`	Unknown	PK
`user_thread_id`	Unknown	PKFK
`gif_url`	Unknown
`has_replies`	Unknown
`hide_status`	Unknown
`is_quote_post`	Unknown
`is_reply`	Unknown
`is_reply_owned_by_me`	Unknown
`is_verified`	Unknown
`media_product_type`	Unknown
`media_type`	Unknown
`media_url`	Unknown
`permalink`	Unknown
`poll_attachment_expiration`	Unknown
`post_timestamp`	Instant
`profile_picture_url`	Unknown
`quoted_post_id`	Unknown
`replied_to_id`	Unknown
`reply_approval_status`	Unknown
`reply_audience`	Unknown
`reposted_post_id`	Unknown
`root_post_id`	Unknown
`shortcode`	Unknown
`text`	Unknown
`thumbnail_url`	Unknown
`topic_tag`	Unknown
`username`	Unknown

ghost_post

Column	Type	Keys
`id`	Unknown	PK
`owner_id`	Unknown	FK
`ghost_post_expiration_timestamp`	Unknown
`ghost_post_status`	Unknown
`media_product_type`	Unknown
`media_type`	Unknown
`permalink`	Unknown
`post_timestamp`	Instant
`shortcode`	Unknown
`text`	Unknown
`username`	Unknown

reply

Column	Type	Keys
`id`	Unknown	PK
`owner_id`	Unknown	FK
`has_replies`	Unknown
`is_quote_post`	Unknown
`is_reply`	Unknown
`is_reply_owned_by_me`	Unknown
`media_product_type`	Unknown
`media_type`	Unknown
`permalink`	Unknown
`post_timestamp`	Instant
`replied_to_id`	Unknown
`reply_audience`	Unknown
`root_post_id`	Unknown
`shortcode`	Unknown
`text`	Unknown
`topic_tag`	Unknown

media_conversation_child

Column	Type	Keys
`id`	Unknown	PK
`media_conversation_id`	Unknown	PKFK

media_conversation_poll_option

Column	Type	Keys
`index`	Unknown	PK
`media_conversation_id`	Unknown	PKFK
`label`	Unknown
`vote_count`	Unknown

media_conversation

Column	Type	Keys
`id`	Unknown	PK
`user_thread_id`	Unknown	PKFK
`root_post_id`	Unknown	FK
`gif_url`	Unknown
`has_replies`	Unknown
`hide_status`	Unknown
`is_quote_post`	Unknown
`is_reply`	Unknown
`is_reply_owned_by_me`	Unknown
`is_verified`	Unknown
`media_product_type`	Unknown
`media_type`	Unknown
`media_url`	Unknown
`permalink`	Unknown
`poll_attachment_expiration`	Unknown
`post_timestamp`	Instant
`profile_picture_url`	Unknown
`quoted_post_id`	Unknown
`replied_to_id`	Unknown
`reply_audience`	Unknown
`reposted_post_id`	Unknown
`shortcode`	Unknown
`text`	Unknown
`thumbnail_url`	Unknown
`topic_tag`	Unknown
`username`	Unknown