Fivetran documentation

Search the docs

/

Short.io

Explore the interactive ERD

Table & Field Reference

domain

Column	Type	Keys
`id`	String	PK
`case_sensitive`	Boolean
`client_storage`	String
`cloaking`	Boolean
`created_at`	Instant
`export_enabled`	Boolean
`hide_referer`	Boolean
`hide_visitor_ip`	Boolean
`hostname`	String
`https_level`	String
`https_links`	Boolean
`increment_counter`	String
`integration_adroll`	String
`integration_fb`	String
`integration_ga`	String
`integration_gtm`	String
`is_favorite`	Boolean
`last_purge_date`	Instant
`link_type`	String
`provider`	String
`purge_expired_links`	Boolean
`redirect_404`	String
`robots`	String
`segment_key`	String
`setup_type`	String
`state`	String
`support_deprecated_link_id`	Boolean
`team_id`	String
`title`	String
`unicode_hostname`	String
`updated_at`	Instant
`webhook_url`	String

domain_statistics_os

Column	Type	Keys
`os`	String	PK
`domain_id`	String	PKFK
`domain_statistics_interval_start_date`	Instant	PKFK
`score`	Int

domain_statistics_city

Column	Type	Keys
`city`	String	PK
`domain_id`	String	PKFK
`domain_statistics_interval_start_date`	Instant	PKFK
`name`	String
`score`	Int

domain_statistics_country

Column	Type	Keys
`country`	String	PK
`domain_id`	String	PKFK
`domain_statistics_interval_start_date`	Instant	PKFK
`country_name`	String
`score`	Int

domain_statistics_browser

Column	Type	Keys
`browser`	String	PK
`domain_id`	String	PKFK
`domain_statistics_interval_start_date`	Instant	PKFK
`score`	Int

domain_statistics_social

Column	Type	Keys
`social`	String	PK
`domain_id`	String	PKFK
`domain_statistics_interval_start_date`	Instant	PKFK
`score`	Int

domain_statistics_referer

Column	Type	Keys
`referer`	String	PK
`domain_id`	String	PKFK
`domain_statistics_interval_start_date`	Instant	PKFK
`score`	Int

domain_statistics

Column	Type	Keys
`interval_start_date`	Instant	PK
`domain_id`	String	PKFK
`click_statistics`	Json
`clicks`	String
`clicks_per_link`	String
`clicks_per_link_change`	String
`human_clicks`	String
`human_clicks_change`	String
`human_clicks_change_positive`	Boolean
`human_clicks_per_link`	String
`interval_end_date`	Instant
`interval_prev_end_date`	Instant
`interval_prev_start_date`	Instant
`links`	String
`links_change`	String
`links_change_positive`	Boolean
`prev_clicks_change`	String

link_statistics_os

Column	Type	Keys
`os`	String	PK
`domain_id`	Int	PKFK
`link_id`	String	PKFK
`link_statistics_interval_start_date`	Instant	PKFK
`score`	Int

link_statistics_city

Column	Type	Keys
`city`	String	PK
`domain_id`	Int	PKFK
`link_id`	String	PKFK
`link_statistics_interval_start_date`	Instant	PKFK
`name`	String
`score`	Int

link_statistics_country

Column	Type	Keys
`country`	String	PK
`domain_id`	Int	PKFK
`link_id`	String	PKFK
`link_statistics_interval_start_date`	Instant	PKFK
`country_name`	String
`score`	Int

link_statistics_browser

Column	Type	Keys
`browser`	String	PK
`domain_id`	Int	PKFK
`link_id`	String	PKFK
`link_statistics_interval_start_date`	Instant	PKFK
`score`	Int

link_statistics_social

Column	Type	Keys
`social`	String	PK
`domain_id`	Int	PKFK
`link_id`	String	PKFK
`link_statistics_interval_start_date`	Instant	PKFK
`score`	Int

link_statistics_referer

Column	Type	Keys
`referer`	String	PK
`domain_id`	Int	PKFK
`link_id`	String	PKFK
`link_statistics_interval_start_date`	Instant	PKFK
`score`	Int

link_statistics

Column	Type	Keys
`interval_start_date`	Instant	PK
`domain_id`	Int	PKFK
`link_id`	String	PKFK
`click_statistics`	Json
`human_clicks`	Int
`human_clicks_change`	String
`interval_end_date`	Instant
`interval_prev_end_date`	Instant
`interval_prev_start_date`	Instant
`total_clicks`	Int
`total_clicks_change`	String

link_tag

Column	Type	Keys
`tag_name`	String	PK
`domain_id`	Int	PKFK
`link_id`	String	PKFK

link

Column	Type	Keys
`domain_id`	Int	PK
`id`	String	PKFK
`android_url`	String
`archived`	Boolean
`clicks_limit`	String
`cloaking`	String
`created_at`	Instant
`expired_url`	String
`expires_at`	String
`has_password`	Boolean
`icon`	String
`integration_adroll`	String
`integration_fb`	String
`integration_ga`	String
`integration_gtm`	String
`iphone_url`	String
`original_url`	String
`owner_email`	String
`owner_id`	String
`owner_name`	String
`owner_photo_url`	String
`password_contact`	String
`path`	String
`redirect_type`	String
`secure_short_url`	String
`short_url`	String
`source`	String
`split_percent`	String
`split_url`	String
`title`	String
`user_email`	String
`user_id`	String
`user_name`	String
`user_photo_url`	String