Fivetran documentation

Search the docs

/

G2

Explore the interactive ERD

Table & Field Reference

track_prospect

Column	Type	Keys
`id`	Long	PK
`external_id`	String
`first_seen_occurred_at`	Instant
`first_seen_path`	String
`first_seen_scope`	String
`industry`	String
`isp`	Boolean
`last_seen_occurred_at`	Instant
`last_seen_path`	String
`last_seen_scope`	String
`organization`	String
`saw_first`	String
`visitor_id`	String

answer

Column	Type	Keys
`id`	Long	PK
`product_id`	String	FK
`question_id`	String	FK
`survey_response_id`	Long	FK
`created_at`	Instant
`input_type`	String
`question_text`	String
`question_type`	String
`updated_at`	Instant
`value`	String

resource_subscription

Column	Type	Keys
`id`	Long	PK
`product_uuid`	String	FK
`post_url`	String
`product_id`	String
`subscribed_resource`	String
`updated_at`	Instant

vendor_product

Column	Type	Keys
`product_id`	String	PKFK
`vendor_id`	String	PKFK

question

Column	Type	Keys
`id`	Long	PK
`survey_response_id`	Long	FK
`description`	String
`input_type`	String
`is_required`	Boolean
`question_type`	String
`text_template`	String
`title`	String

company

Column	Type	Keys
`id`	Long	PK
`event_stream_id`	Long	FK
`external_id`	String	FK
`alexa_global_rank`	Long
`alexa_us_rank`	Long
`annual_revenue`	String
`city`	String
`company_type`	String
`country`	String
`country_code`	String
`crunchbase`	String
`description`	String
`domain`	String
`domain_aliases`	Json
`email_provider`	String
`employees`	Long
`employees_range`	String
`founded_year`	Long
`latitude`	String
`legal_name`	String
`linkedin`	String
`location`	String
`longitude`	String
`market_cap`	String
`name`	String
`postal_code`	String
`raised`	String
`site_author`	String
`site_h_1`	String
`site_meta`	String
`site_title`	String
`state`	String
`state_code`	String
`street_name`	String
`street_number`	String
`sub_premise`	String
`tags`	Json
`tech`	Json
`time_zone`	String
`twitter`	String
`twitter_avatar`	String
`twitter_bio`	String
`twitter_followers`	Long
`twitter_following`	Long
`twitter_id`	String
`twitter_location`	String
`twitter_site`	String
`url`	String
`utc_offset`	Long

event_stream

Column	Type	Keys
`id`	Long	PK
`visitor_id`	String	FK
`category_ids`	Json
`city`	String
`country`	String
`country_code`	String
`created_at`	Instant
`organization`	String
`product_ids`	Json
`state`	String
`state_code`	String
`tags`	String
`time`	Instant
`title`	String
`url`	String

product_rating

Column	Type	Keys
`product_id`	String	PKFK
`main_category_id`	String	FK
`category_average_ease_of_setup`	Double
`category_average_ease_of_use`	Double
`category_average_quality_of_support`	Double
`category_name`	String
`product_average_ease_of_setup`	Double
`product_average_ease_of_use`	Double
`product_average_quality_of_support`	Double

product_feature

Column	Type	Keys
`product_feature_id`	Long	PK
`product_id`	String	FK
`question_id`	Long	FK
`available`	Boolean
`description`	String
`percentage`	Double
`review_count`	Long
`section_title`	String
`text`	String

product

Column	Type	Keys
`id`	String	PK
`avg_rating`	Double
`created_at`	Instant
`description`	String
`detail_description`	String
`domain`	String
`image_url`	String
`name`	String
`product_type`	String
`product_url`	String
`public_detail_url`	String
`review_count`	Long
`short_name`	String
`slug`	String
`star_rating`	Double
`updated_at`	Instant

category

Column	Type	Keys
`id`	String	PK
`description`	String
`name`	String
`slug`	String
`updated_at`	Instant

product_category

Column	Type	Keys
`category_id`	String	PKFK
`product_id`	String	PKFK

vendor

Column	Type	Keys
`id`	String	PK
`company_website`	String
`description`	String
`name`	String
`public_product_count`	Long
`slug`	String
`updated_at`	Instant

product_competitor

Column	Type	Keys
`competitor_id`	String	PKFK
`product_id`	String	FK

survey_response

Column	Type	Keys
`id`	Long	PK
`product_id`	String	FK
`country_name`	String
`default_sort`	Double
`ease_of_doing_business_with_text`	String
`ease_of_doing_business_with_value`	Double
`ease_of_setup_text`	String
`ease_of_setup_value`	Double
`hate_text`	String
`hate_value`	String
`is_business_partner`	Boolean
`is_public`	Boolean
`love_text`	String
`love_value`	String
`meet_requirement_text`	String
`meet_requirement_value`	Double
`moderated_at`	Instant
`percent_complete`	Double
`product_name`	String
`recommendation_text`	String
`recommendation_value`	String
`reference_user_consent`	String
`regions`	Json
`review_source`	String
`slug`	String
`star_rating`	Double
`status`	String
`submitted_at`	Instant
`title`	String
`updated_at`	Instant
`user_id`	String
`user_image_url`	String
`user_name`	String
`verified_current_user`	Boolean
`votes_down`	Long
`votes_total`	Long
`votes_up`	Long

history_compared_product

Column	Type	Keys
`history_id`	Long	PKFK
`product_id`	String	PKFK
`product_name`	String

history

Column	Type	Keys
`id`	Long	PK
`category_pageview`	Long
`company_country`	String
`company_domain`	String
`company_name`	String
`company_state`	String
`comparison_pageview`	Long
`competitor_pageview`	Long
`direct_pageview`	Long
`intent_score`	Long
`last_seen_at`	Instant
`product_profile_pageview`	Long
`sponsored_content_pageview`	Long
`total_pageview`	Long
`visitor_count`	Long