Fivetran documentation

Search the docs

/

Webconnex

Explore the interactive ERD

Table & Field Reference

coupon_discount

Column	Type	Keys
`index`	Unknown	PK
`coupon_id`	Unknown	PKFK
`value`	Unknown
`value_type`	Unknown

coupon_code

Column	Type	Keys
`index`	Unknown	PK
`coupon_id`	Unknown	PKFK
`code`	Unknown
`date_created`	Unknown
`date_updated`	Unknown
`redeemed`	Unknown

coupon

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	FK
`available`	Unknown
`currency`	Unknown
`date_created`	Unknown
`date_updated`	Unknown
`name`	Unknown
`redeemed`	Unknown

ticket_field_data

Column	Type	Keys
`index`	Unknown	PK
`ticket_id`	Unknown	PKFK
`amount`	Unknown
`label`	Unknown
`path`	Unknown

ticket

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`form_id`	Unknown	FK
`order_id`	Unknown	FK
`amount`	Unknown
`currency`	Unknown
`date_created`	Unknown
`date_updated`	Instant
`display_id`	Unknown
`event_date`	Unknown
`fee`	Unknown
`form_acc_ref`	Unknown
`level_key`	Unknown
`level_label`	Unknown
`order_customer_id`	Unknown
`order_email`	Unknown
`status`	Unknown
`total`	Unknown

membership

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`registrant_id`	Unknown	FK
`auto_renew`	Unknown
`date_created`	Unknown
`date_updated`	Instant
`email`	Unknown
`expiration_date`	Unknown
`fee`	Unknown
`first_name`	Unknown
`imported_member_id`	Unknown
`last_name`	Unknown
`level_active`	Unknown
`level_allow_auto_renew`	Unknown
`level_expiration_schedule`	Unknown
`level_expiration_type`	Unknown
`level_fee`	Unknown
`level_hash`	Unknown
`level_id`	Unknown
`level_name`	Unknown
`level_next_renewal_date`	Unknown
`member_id`	Unknown
`payment_mask`	Unknown
`payment_method`	Unknown
`status`	Unknown

subscription

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`form_id`	Unknown	FK
`order_id`	Unknown	FK
`adjustment`	Unknown
`amount`	Unknown
`category`	Unknown
`currency`	Unknown
`date_created`	Unknown
`date_last`	Unknown
`date_next`	Unknown
`date_updated`	Instant
`deductible`	Unknown
`display_id`	Unknown
`order_email`	Unknown
`payments_completed`	Unknown
`payments_remaining`	Unknown
`schedule`	Unknown
`status`	Unknown

form

Column	Type	Keys
`id`	Unknown	PK
`date_archived`	Unknown
`date_created`	Unknown
`date_updated`	Instant
`name`	Unknown
`product`	Unknown
`status`	Unknown

coupon_form_discount

Column	Type	Keys
`index`	Unknown	PK
`coupon_form_id`	Unknown	PKFK
`distribute`	Unknown
`per_ticket`	Unknown
`value`	Unknown
`value_type`	Unknown

coupon_form_code

Column	Type	Keys
`index`	Unknown	PK
`coupon_form_id`	Unknown	PKFK
`code`	Unknown
`date_created`	Unknown
`redeemed`	Unknown

coupon_form

Column	Type	Keys
`id`	Unknown	PK
`form_id`	Unknown	PKFK
`available`	Unknown
`currency`	Unknown
`date_created`	Unknown
`date_updated`	Unknown
`name`	Unknown
`product_id`	Unknown
`redeemed`	Unknown

orders

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`form_id`	Unknown	FK
`billing_address_city`	Unknown
`billing_address_country`	Unknown
`billing_address_postal_code`	Unknown
`billing_address_state`	Unknown
`billing_address_street_1`	Unknown
`billing_first_name`	Unknown
`billing_last_name`	Unknown
`billing_phone`	Unknown
`currency`	Unknown
`customer_email`	Unknown
`date_created`	Unknown
`date_updated`	Instant
`display_id`	Unknown
`form_acc_ref`	Unknown
`form_name`	Unknown
`metadata`	Unknown
`order_number`	Unknown
`status`	Unknown
`total`	Unknown

form_inventory

Column	Type	Keys
`_fivetran_id`	String	PK
`form_id`	Unknown	FK
`date_created`	Unknown
`date_updated`	Unknown
`key`	Unknown
`name`	Unknown
`path`	Unknown
`quantity`	Unknown
`sold`	Unknown

registrant_field_data

Column	Type	Keys
`index`	Unknown	PK
`registrant_id`	Unknown	PKFK
`amount`	Unknown
`label`	Unknown
`path`	Unknown
`value`	Unknown

registrant

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`form_id`	Unknown	FK
`order_id`	Unknown	FK
`amount`	Unknown
`checked_in`	Unknown
`currency`	Unknown
`date_checked_in`	Unknown
`date_created`	Unknown
`date_updated`	Instant
`display_id`	Unknown
`form_acc_ref`	Unknown
`metadata`	Unknown
`outstanding_amount`	Unknown
`source_type`	Unknown
`status`	Unknown
`total`	Unknown

transaction

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`form_id`	Unknown	FK
`order_id`	Unknown	FK
`billing_email`	Unknown
`cc_expiration`	Unknown
`currency`	Unknown
`date_created`	Unknown
`date_updated`	Instant
`deductible`	Unknown
`display_id`	Unknown
`exp_month`	Unknown
`exp_year`	Unknown
`gateway_message`	Unknown
`gateway_reference`	Unknown
`metadata`	Unknown
`order_email`	Unknown
`payment_mask`	Unknown
`payment_method`	Unknown
`payment_type`	Unknown
`source_type`	Unknown
`status`	Unknown
`total`	Unknown
`transaction_type`	Unknown

customer

Column	Type	Keys
`id`	Unknown	PK
`amount`	Unknown
`date_created`	Unknown
`date_updated`	Instant
`display_id`	Unknown
`email`	Unknown