# Threads schema ERD

Table and field reference for the Fivetran Threads connector.

## Table & Field Reference

### media_insight_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| media_insight_id | Unknown | PK, FK |
| value | Unknown |  |

### media_insight

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_thread_id | Unknown | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |

### media_reply_poll_option

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| media_reply_id | Unknown | PK, FK |
| label | Unknown |  |
| vote_count | Unknown |  |

### media_reply

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_thread_id | Unknown | PK, 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 |  |
| 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 | PK, FK |
| value | Unknown |  |

### insight_link_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| insight_id | Unknown | PK, FK |
| 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 | PK, FK |

### media_pending_reply_poll_option

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| media_pending_reply_id | Unknown | PK, FK |
| label | Unknown |  |
| vote_count | Unknown |  |

### media_pending_reply

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_thread_id | Unknown | PK, 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_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 | PK, FK |

### media_conversation_poll_option

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| media_conversation_id | Unknown | PK, FK |
| label | Unknown |  |
| vote_count | Unknown |  |

### media_conversation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_thread_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- media_insight_value(media_insight_id) → media_insight(id)
- media_insight(user_thread_id) → user_thread(id)
- user_thread(owner_id) → profile(id)
- mention_child(mention_id) → mention(id)
- media_reply_child(media_reply_id) → media_reply(id)
- media_reply_poll_option(media_reply_id) → media_reply(id)
- media_reply(user_thread_id) → user_thread(id)
- insight_daily_view(insight_id) → insight(id)
- insight_link_value(insight_id) → insight(id)
- insight(user_id) → profile(id)
- media_pending_reply_child(media_pending_reply_id) → media_pending_reply(id)
- media_pending_reply_poll_option(media_pending_reply_id) → media_pending_reply(id)
- media_pending_reply(user_thread_id) → user_thread(id)
- ghost_post(owner_id) → profile(id)
- reply(owner_id) → profile(id)
- media_conversation_child(media_conversation_id) → media_conversation(id)
- media_conversation_poll_option(media_conversation_id) → media_conversation(id)
- media_conversation(root_post_id) → user_thread(id)
- media_conversation(user_thread_id) → user_thread(id)