Fivetran documentation

Search the docs

/

Tremendous

Explore the interactive ERD

Table & Field Reference

reward_custom_field

Column	Type	Keys
`id`	Unknown	PK
`reward_id`	Unknown	PKFK
`label`	Unknown
`value`	Unknown

reward

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	FK
`created_at`	Instant
`deliver_at`	Unknown
`delivery_method`	Unknown
`delivery_status`	Unknown
`recipient_email`	Unknown
`recipient_name`	Unknown
`recipient_phone`	Unknown
`value_currency_code`	Unknown
`value_denomination`	Unknown

balance_transaction

Column	Type	Keys
`_fivetran_id`	String	PK
`action`	Unknown
`amount`	Unknown
`balance`	Unknown
`created_at`	Unknown
`description`	Unknown

product_currency_code

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`currency_code`	Unknown

product_sku

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`max`	Unknown
`min`	Unknown

product_country

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`abbr`	Unknown

product_image

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`src`	Unknown
`type`	Unknown

product

Column	Type	Keys
`id`	Unknown	PK
`category`	Unknown
`description`	Unknown
`disclosure`	Unknown
`name`	Unknown

role

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`title`	Unknown

funding_source_usage_permission

Column	Type	Keys
`index`	Unknown	PK
`funding_source_id`	Unknown	PKFK
`usage_permission`	Unknown

funding_source

Column	Type	Keys
`id`	Unknown	PK
`account_number_mask`	Unknown
`account_routing_mask`	Unknown
`account_type`	Unknown
`accountholder_name`	Unknown
`available_cents`	Unknown
`bank_name`	Unknown
`expired`	Unknown
`last_4`	Unknown
`last_payment_failed_at`	Unknown
`method`	Unknown
`network`	Unknown
`pending_cents`	Unknown
`refundable`	Unknown
`status`	Unknown
`type`	Unknown

organization

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`name`	Unknown
`status`	Unknown
`website`	Unknown

member

Column	Type	Keys
`id`	Unknown	PK
`role_id`	Unknown	FK
`active`	Unknown
`created_at`	Unknown
`email`	Unknown
`last_login_at`	Unknown
`name`	Unknown
`status`	Unknown

campaign_product

Column	Type	Keys
`index`	Unknown	PK
`campaign_id`	Unknown	PKFK
`product`	Unknown	FK

campaign

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`email_button_color`	Unknown
`email_logo_background_color`	Unknown
`email_logo_image_height_px`	Unknown
`email_logo_image_url`	Unknown
`email_sender_name`	Unknown
`email_subject_line`	Unknown
`name`	Unknown
`webpage_background_color`	Unknown
`webpage_headline`	Unknown
`webpage_logo_background_color`	Unknown
`webpage_logo_image_height_px`	Unknown
`webpage_logo_image_url`	Unknown
`webpage_message`	Unknown

orders

Column	Type	Keys
`id`	Unknown	PK
`campaign_id`	Unknown	FK
`invoice_id`	Unknown	FK
`channel`	Unknown
`created_at`	Unknown
`external_id`	Unknown
`payment_channel`	Unknown
`payment_fees`	Unknown
`payment_refund_total`	Unknown
`payment_subtotal`	Unknown
`payment_total`	Unknown
`status`	Unknown

invoice_order

Column	Type	Keys
`index`	Unknown	PK
`invoice_id`	Unknown	PKFK
`order_id`	Unknown	FK

invoice_reward

Column	Type	Keys
`index`	Unknown	PK
`invoice_id`	Unknown	PKFK
`reward_id`	Unknown	FK

invoice

Column	Type	Keys
`id`	Unknown	PK
`amount`	Unknown
`created_at`	Instant
`paid_at`	Unknown
`po_number`	Unknown
`status`	Unknown

fraud_review_custom_field

Column	Type	Keys
`id`	Unknown	PK
`fraud_review_reward_id`	Unknown	PKFK
`label`	Unknown
`value`	Unknown

fraud_review_reason

Column	Type	Keys
`reason`	Unknown	PK
`fraud_review_reward_id`	Unknown	PKFK

fraud_review

Column	Type	Keys
`reward_id`	Unknown	PKFK
`order_id`	Unknown	FK
`created_at`	Instant
`currency_code`	Unknown
`deliver_at`	Unknown
`delivery_method`	Unknown
`delivery_status`	Unknown
`denomination`	Unknown
`recipient_email`	Unknown
`recipient_name`	Unknown
`recipient_phone`	Unknown
`status`	Unknown