Fivetran documentation

Search the docs

/

Listen360

Explore the interactive ERD

Table & Field Reference

organization

Column	Type	Keys
`id`	Unknown	PK
`average_job_value`	Unknown
`city`	Unknown
`country`	Unknown
`created_at`	Unknown
`custom_choice_10_label`	Unknown
`custom_choice_1_label`	Unknown
`custom_choice_2_label`	Unknown
`custom_choice_3_label`	Unknown
`custom_choice_4_label`	Unknown
`custom_choice_5_label`	Unknown
`custom_choice_6_label`	Unknown
`custom_choice_7_label`	Unknown
`custom_choice_8_label`	Unknown
`custom_choice_9_label`	Unknown
`customer_lifetime`	Unknown
`customer_lifetime_interval`	Unknown
`email`	Unknown
`external_name`	Unknown
`franchise_royalty_percentage`	Unknown
`jobs_performed_per_interval`	Unknown
`latitude`	Unknown
`locale`	Unknown
`longitude`	Unknown
`marketing_radius_miles`	Unknown
`name`	Unknown
`net_promoter_score`	Unknown
`one_to_five_rating`	Unknown
`operating_radius_miles`	Unknown
`parent_id`	Unknown
`phone_number`	Unknown
`postal_code`	Unknown
`recurring_jobs_interval`	Unknown
`reference`	Unknown
`region`	Unknown
`root_id`	Unknown
`status`	Unknown
`street_address`	Unknown
`time_zone`	Unknown
`type`	Unknown
`updated_at`	Unknown
`website`	Unknown
`zero_to_ten_rating`	Unknown

membership

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`accepted_at`	Unknown
`country`	Unknown
`created_at`	Unknown
`email`	Unknown
`first_name`	Unknown
`invited_by_id`	Unknown
`last_name`	Unknown
`mobile_phone_number`	Unknown
`revoked_at`	Unknown
`role`	Unknown
`status`	Unknown
`user_id`	Unknown

custom_attribute

Column	Type	Keys
`_fivetran_id`	String	PK
`organization_id`	Unknown	FK
`attach_to`	Unknown
`created_at`	Unknown
`mandatory`	Unknown
`name`	Unknown
`ordinal`	Unknown
`restrict_to_predefined_choices`	Unknown
`updated_at`	Unknown

review_note

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`review_id`	Unknown	PKFK
`author_name`	Unknown
`body`	Unknown
`created_at`	Unknown

review

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`censored`	Unknown
`comments`	Unknown
`completed_at`	Unknown
`customer_full_name`	Unknown
`customer_reference`	Unknown
`customer_work_city`	Unknown
`customer_work_email`	Unknown
`customer_work_region`	Unknown
`flagged_for_follow_up`	Unknown
`has_notes`	Unknown
`initial`	Unknown
`invited_at`	Unknown
`job_reference`	Unknown
`net_promoter_label`	Unknown
`organization_reference`	Unknown
`public_display_comments`	Unknown
`public_display_customer_location`	Unknown
`public_response`	Unknown
`public_reviewer_name`	Unknown
`recommendation_likelihood`	Unknown
`updated_at`	Unknown

customer

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`company_name`	Unknown
`created_at`	Unknown
`custom_choice_10_label`	Unknown
`custom_choice_1_label`	Unknown
`custom_choice_2_label`	Unknown
`custom_choice_3_label`	Unknown
`custom_choice_4_label`	Unknown
`custom_choice_5_label`	Unknown
`custom_choice_6_label`	Unknown
`custom_choice_7_label`	Unknown
`custom_choice_8_label`	Unknown
`custom_choice_9_label`	Unknown
`first_name`	Unknown
`full_name`	Unknown
`last_name`	Unknown
`last_survey_bounced`	Unknown
`mobile_phone_number`	Unknown
`name`	Unknown
`net_promoter_label`	Unknown
`permits_contact`	Unknown
`permits_email_contact`	Unknown
`permits_sms_contact`	Unknown
`reference`	Unknown
`status`	Unknown
`title`	Unknown
`updated_at`	Unknown
`work_city`	Unknown
`work_country`	Unknown
`work_email`	Unknown
`work_phone_number`	Unknown
`work_postal_code`	Unknown
`work_region`	Unknown
`work_street`	Unknown

job_performer

Column	Type	Keys
`id`	Unknown	PK
`job_id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`country`	Unknown
`created_at`	Unknown
`email`	Unknown
`mobile_phone_number`	Unknown
`name`	Unknown
`reference`	Unknown
`status`	Unknown

job

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`customer_id`	Unknown	FK
`commenced_at`	Unknown
`completed_at`	Unknown
`created_at`	Unknown
`currency`	Unknown
`custom_choice_10_label`	Unknown
`custom_choice_1_label`	Unknown
`custom_choice_2_label`	Unknown
`custom_choice_3_label`	Unknown
`custom_choice_4_label`	Unknown
`custom_choice_5_label`	Unknown
`custom_choice_6_label`	Unknown
`custom_choice_7_label`	Unknown
`custom_choice_8_label`	Unknown
`custom_choice_9_label`	Unknown
`reference`	Unknown
`status`	Unknown
`updated_at`	Unknown
`value`	Unknown

technician

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`country`	Unknown
`created_at`	Unknown
`email`	Unknown
`mobile_phone_number`	Unknown
`name`	Unknown
`reference`	Unknown
`status`	Unknown