# TikTok Organic schema ERD

Table and field reference for the Fivetran TikTok Organic connector.

## Table & Field Reference

### profile_audience_age

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| profile_username | Unknown | PK, FK |
| age | Unknown |  |
| percentage | Unknown |  |

### profile_audience_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| profile_username | Unknown | PK, FK |
| country | Unknown |  |
| percentage | Unknown |  |

### profile_audience_city

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| profile_username | Unknown | PK, FK |
| city_name | Unknown |  |
| percentage | Unknown |  |

### profile_metric_audience_activity

| Column | Type | Keys |
| --- | --- | --- |
| hour | Unknown | PK |
| date | Unknown | PK, FK |
| profile_username | Unknown | PK, FK |
| count | Unknown |  |

### profile_metric

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| profile_username | Unknown | PK, FK |
| address_clicks | Unknown |  |
| app_download_clicks | Unknown |  |
| bio_link_clicks | Unknown |  |
| comments | Unknown |  |
| daily_lost_followers | Unknown |  |
| daily_new_followers | Unknown |  |
| daily_total_followers | Unknown |  |
| email_clicks | Unknown |  |
| engaged_audience | Unknown |  |
| followers_count | Unknown |  |
| lead_submissions | Unknown |  |
| likes | Unknown |  |
| phone_number_clicks | Unknown |  |
| profile_views | Unknown |  |
| shares | Unknown |  |
| unique_video_views | Unknown |  |
| video_views | Unknown |  |

### profile_audience_gender

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| profile_username | Unknown | PK, FK |
| gender | Unknown |  |
| percentage | Unknown |  |

### profile

| Column | Type | Keys |
| --- | --- | --- |
| username | Unknown | PK |
| bio_description | Unknown |  |
| display_name | Unknown |  |
| followers_count | Unknown |  |
| following_count | Unknown |  |
| is_business_account | Unknown |  |
| is_verified | Unknown |  |
| profile_deep_link | Unknown |  |
| profile_image | Unknown |  |
| total_likes | Unknown |  |
| videos_count | Unknown |  |

### replies_to_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_comment_id | Unknown | FK |
| username | Unknown | FK |
| video_id | Unknown | FK |
| create_time | Instant |  |
| display_name | Unknown |  |
| liked | Unknown |  |
| likes | Unknown |  |
| owner | Unknown |  |
| pinned | Unknown |  |
| profile_image | Unknown |  |
| replies | Unknown |  |
| status | Unknown |  |
| text | Unknown |  |
| unique_identifier | Unknown |  |

### video_impression_source

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| video_id | Unknown | PK, FK |
| impression_source | Unknown |  |
| percentage | Unknown |  |

### video_audience_gender

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| video_id | Unknown | PK, FK |
| gender | Unknown |  |
| percentage | Unknown |  |

### video_audience_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| video_id | Unknown | PK, FK |
| percentage | Unknown |  |
| type | Unknown |  |

### video_engagement_like

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| video_id | Unknown | PK, FK |
| percentage | Unknown |  |
| second | Unknown |  |

### video_audience_city

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| video_id | Unknown | PK, FK |
| city_name | Unknown |  |
| percentage | Unknown |  |

### video_audience_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| video_id | Unknown | PK, FK |
| country | Unknown |  |
| percentage | Unknown |  |

### video_view_retention

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| video_id | Unknown | PK, FK |
| percentage | Unknown |  |
| second | Unknown |  |

### video

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_clicks | Unknown |  |
| app_download_clicks | Unknown |  |
| average_time_watched | Unknown |  |
| caption | Unknown |  |
| comments | Unknown |  |
| create_time | Unknown |  |
| email_clicks | Unknown |  |
| embed_url | Unknown |  |
| favorites | Unknown |  |
| full_video_watched_rate | Unknown |  |
| lead_submissions | Unknown |  |
| likes | Unknown |  |
| new_followers | Unknown |  |
| phone_number_clicks | Unknown |  |
| profile_views | Unknown |  |
| reach | Unknown |  |
| share_url | Unknown |  |
| shares | Unknown |  |
| thumbnail_url | Unknown |  |
| total_time_watched | Unknown |  |
| video_duration | Unknown |  |
| video_views | Unknown |  |
| website_clicks | Unknown |  |

### comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_comment_id | Unknown | FK |
| username | Unknown | FK |
| video_id | Unknown | FK |
| create_time | Instant |  |
| display_name | Unknown |  |
| liked | Unknown |  |
| likes | Unknown |  |
| owner | Unknown |  |
| pinned | Unknown |  |
| profile_image | Unknown |  |
| replies | Unknown |  |
| status | Unknown |  |
| text | Unknown |  |
| unique_identifier | Unknown |  |

## Relationships

- profile_audience_age(profile_username) → profile(username)
- profile_audience_country(profile_username) → profile(username)
- profile_audience_city(profile_username) → profile(username)
- profile_metric_audience_activity(date) → profile_metric(date)
- profile_metric_audience_activity(profile_username) → profile_metric(profile_username)
- profile_metric(profile_username) → profile(username)
- profile_audience_gender(profile_username) → profile(username)
- replies_to_comment(username) → profile(username)
- replies_to_comment(parent_comment_id) → comment(id)
- replies_to_comment(video_id) → video(id)
- video_impression_source(video_id) → video(id)
- video_audience_gender(video_id) → video(id)
- video_audience_type(video_id) → video(id)
- video_engagement_like(video_id) → video(id)
- video_audience_city(video_id) → video(id)
- video_audience_country(video_id) → video(id)
- video_view_retention(video_id) → video(id)
- comment(username) → profile(username)
- comment(parent_comment_id) → comment(id)
- comment(video_id) → video(id)