# Instagram Business schema ERD

Table and field reference for the Fivetran Instagram Business connector.

## Table & Field Reference

### media_insights

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | Long | FK |
| carousel_album_engagement | Long |  |
| carousel_album_follows | Long |  |
| carousel_album_impressions | Long |  |
| carousel_album_reach | Long |  |
| carousel_album_reposts | Long |  |
| carousel_album_saved | Long |  |
| carousel_album_shares | Long |  |
| carousel_album_views | Long |  |
| comment_count | Long |  |
| ig_reels_avg_watch_time | Long |  |
| ig_reels_video_view_total_time | Long |  |
| like_count | Long |  |
| navigation | Long |  |
| reel_comments | Long |  |
| reel_crossposted_views | Long |  |
| reel_facebook_views | Long |  |
| reel_likes | Long |  |
| reel_reach | Long |  |
| reel_reposts | Long |  |
| reel_saved | Long |  |
| reel_shares | Long |  |
| reel_total_interactions | Long |  |
| reel_views | Long |  |
| reels_skip_rate | Long |  |
| story_exits | Long |  |
| story_follows | Long |  |
| story_impressions | Long |  |
| story_reach | Long |  |
| story_replies | Long |  |
| story_shares | Long |  |
| story_swipe_forward | Long |  |
| story_taps_back | Long |  |
| story_taps_forward | Long |  |
| story_views | Long |  |
| video_photo_engagement | Long |  |
| video_photo_follows | Long |  |
| video_photo_impressions | Long |  |
| video_photo_reach | Long |  |
| video_photo_reposts | Long |  |
| video_photo_saved | Long |  |
| video_photo_shares | Long |  |
| video_photo_views | Long |  |

### user_insights

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | Long | FK |
| comments | Long |  |
| date | LocalDate |  |
| follower_count | Long |  |
| likes | Long |  |
| reach | Long |  |
| reach_28_d | Long |  |
| reach_7_d | Long |  |
| replies | Long |  |
| reposts | Long |  |
| saves | Long |  |
| shares | Long |  |
| total_interactions | Long |  |
| unfollower_count | Long |  |
| views | Long |  |

### media_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| user_id | Long | FK |
| caption | String |  |
| carousel_album_id | Long |  |
| created_time | Instant |  |
| id | Long |  |
| ig_id | Long |  |
| is_comment_enabled | Boolean |  |
| is_story | Boolean |  |
| media_product_type | String |  |
| media_type | String |  |
| media_url | String |  |
| owner_id | Long |  |
| permalink | String |  |
| shortcode | String |  |
| thumbnail_url | String |  |
| username | String |  |

### media_comment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| media_id | Long | FK |
| created_time | Instant |  |
| hidden | Boolean |  |
| id | Long |  |
| like_count | Long |  |
| owner_id | Long |  |
| owner_username | String |  |
| parent_id | Long |  |
| text | String |  |

### user_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| followers_count | Long |  |
| follows_count | Long |  |
| has_profile_pic | Boolean |  |
| id | Long |  |
| ig_id | Long |  |
| is_published | Boolean |  |
| media_count | Long |  |
| name | String |  |
| profile_picture_url | String |  |
| username | String |  |
| website | String |  |

### collaborator

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| media_id | Long | FK |
| collaborator_id | Long |  |
| invite_status | String |  |
| username | String |  |

### user_lifetime_insights

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | Long | FK |
| date | LocalDate |  |
| key | String |  |
| metric | String |  |
| value | Long |  |

## Relationships

- media_insights(id) → media_history(_fivetran_id)
- user_insights(id) → user_history(_fivetran_id)
- media_history(user_id) → user_history(_fivetran_id)
- media_comment(media_id) → media_history(_fivetran_id)
- collaborator(media_id) → media_history(_fivetran_id)
- user_lifetime_insights(id) → user_history(_fivetran_id)