Squarespace

Explore the interactive ERD

Table & Field Reference

refund

Column	Type	Keys
`id`	Unknown	PK
`payment_id`	Unknown	FK
`amount_currency`	Unknown
`amount_value`	Unknown
`external_transaction_id`	Unknown
`refunded_on`	Unknown

fee_refund

Column	Type	Keys
`id`	Unknown	PK
`processing_fee_id`	Unknown	FK
`amount_currency`	Unknown
`amount_gateway_currency`	Unknown
`amount_gateway_currency_value`	Unknown
`amount_value`	Unknown
`exchange_rate`	Unknown
`external_transaction_id`	Unknown
`refunded_on`	Unknown

processing_fee

Column	Type	Keys
`id`	Unknown	PK
`payment_id`	Unknown	FK
`amount_currency`	Unknown
`amount_gateway_currency`	Unknown
`amount_gateway_currency_value`	Unknown
`amount_value`	Unknown
`exchange_rate`	Unknown
`net_amount_currency`	Unknown
`net_amount_gateway_currency`	Unknown
`net_amount_gateway_currency_value`	Unknown
`net_amount_value`	Unknown
`refunded_amount_currency`	Unknown
`refunded_amount_gateway_currency`	Unknown
`refunded_amount_gateway_currency_value`	Unknown
`refunded_amount_value`	Unknown

payment

Column	Type	Keys
`id`	Unknown	PK
`transaction_id`	Unknown	FK
`amount_currency`	Unknown
`amount_value`	Unknown
`credit_card_type`	Unknown
`external_customer_id`	Unknown
`external_transaction_id`	Unknown
`external_transaction_properties`	Json
`gift_card_id`	Unknown
`net_amount_currency`	Unknown
`net_amount_value`	Unknown
`paid_on`	Unknown
`provider`	Unknown
`refunded_amount_currency`	Unknown
`refunded_amount_value`	Unknown

sale_line_item_tax

Column	Type	Keys
`_fivetran_id`	String	PK
`sale_line_item_id`	Unknown	FK
`amount_currency`	Unknown
`amount_value`	Unknown
`jurisdiction`	Unknown
`name`	Unknown
`rate`	Unknown

sale_line_item

Column	Type	Keys
`id`	Unknown	PK
`transaction_id`	Unknown	FK
`discount_amount_currency`	Unknown
`discount_amount_value`	Unknown
`total_currency`	Unknown
`total_net_sales_currency`	Unknown
`total_net_sales_value`	Unknown
`total_sales_currency`	Unknown
`total_sales_value`	Unknown
`total_value`	Unknown

discount

Column	Type	Keys
`_fivetran_id`	String	PK
`transaction_id`	Unknown	FK
`amount_currency`	Unknown
`amount_value`	Unknown
`description`	Unknown
`name`	Unknown

shipping_line_item_tax

Column	Type	Keys
`_fivetran_id`	String	PK
`shipping_line_item_id`	Unknown	FK
`amount_currency`	Unknown
`amount_value`	Unknown
`description`	Unknown
`name`	Unknown
`rate`	Unknown

shipping_line_item

Column	Type	Keys
`id`	Unknown	PK
`transaction_id`	Unknown	FK
`amount_currency`	Unknown
`amount_value`	Unknown
`description`	Unknown
`discount_amount_currency`	Unknown
`discount_amount_value`	Unknown
`net_amount_currency`	Unknown
`net_amount_value`	Unknown

transaction

Column	Type	Keys
`id`	Unknown	PK
`customer_email`	Unknown	FK
`sales_order_id`	Unknown	FK
`created_on`	Unknown
`modified_on`	Unknown
`payment_gateway_error`	Unknown
`sale_order_id`	Unknown
`total_currency`	Unknown
`total_net_payment_currency`	Unknown
`total_net_payment_value`	Unknown
`total_net_sales_currency`	Unknown
`total_net_sales_value`	Unknown
`total_net_shipping_currency`	Unknown
`total_net_shipping_value`	Unknown
`total_sales_currency`	Unknown
`total_sales_value`	Unknown
`total_taxes_currency`	Unknown
`total_taxes_value`	Unknown
`total_value`	Unknown
`voided`	Unknown

store_page

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

profile

Column	Type	Keys
`id`	Unknown	PK
`accepts_marketing`	Unknown
`address_address_1`	Unknown
`address_address_2`	Unknown
`address_city`	Unknown
`address_country_code`	Unknown
`address_first_name`	Unknown
`address_last_name`	Unknown
`address_phone`	Unknown
`address_postal_code`	Unknown
`address_state`	Unknown
`created_on`	Instant
`email`	Unknown
`first_name`	Unknown
`has_account`	Unknown
`is_customer`	Unknown
`last_name`	Unknown
`transactions_summary_donation_count`	Unknown
`transactions_summary_first_donation_submitted_on`	Unknown
`transactions_summary_first_order_submitted_on`	Unknown
`transactions_summary_last_donation_submitted_on`	Unknown
`transactions_summary_last_order_submitted_on`	Unknown
`transactions_summary_order_count`	Unknown
`transactions_summary_total_donation_amount_currency`	Unknown
`transactions_summary_total_donation_amount_value`	Unknown
`transactions_summary_total_order_amount_currency`	Unknown
`transactions_summary_total_order_amount_value`	Unknown
`transactions_summary_total_refund_amount_currency`	Unknown
`transactions_summary_total_refund_amount_value`	Unknown

inventory

Column	Type	Keys
`variant_id`	Unknown	PKFK
`descriptor`	Unknown
`is_unlimited`	Unknown
`quantity`	Unknown
`sku`	Unknown

image

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	FK
`alt_text`	Unknown
`available_formats`	Json
`original_size_height`	Unknown
`original_size_width`	Unknown
`url`	Unknown

variant

Column	Type	Keys
`id`	Unknown	PK
`image_id`	Unknown	FK
`product_id`	Unknown	FK
`attributes_flavor`	Unknown
`image_available_formats`	Json
`image_original_size_height`	Unknown
`image_original_size_width`	Unknown
`image_title`	Unknown
`image_url`	Unknown
`pricing_base_price_currency`	Unknown
`pricing_base_price_value`	Unknown
`pricing_on_sale`	Unknown
`pricing_sale_price_currency`	Unknown
`pricing_sale_price_value`	Unknown
`shipping_measurements_dimensions_height`	Unknown
`shipping_measurements_dimensions_length`	Unknown
`shipping_measurements_dimensions_unit`	Unknown
`shipping_measurements_dimensions_width`	Unknown
`shipping_measurements_weight_unit`	Unknown
`shipping_measurements_weight_value`	Unknown
`sku`	Unknown
`stock_quantity`	Unknown
`stock_unlimited`	Unknown

product

Column	Type	Keys
`id`	Unknown	PK
`store_page_id`	Unknown	FK
`created_on`	Unknown
`description`	Unknown
`is_visible`	Unknown
`modified_on`	Unknown
`name`	Unknown
`seo_options_description`	Unknown
`seo_options_title`	Unknown
`tags`	Json
`type`	Unknown
`url`	Unknown
`url_slug`	Unknown
`variant_attributes`	Json

fulfillment

Column	Type	Keys
`_fivetran_id`	String	PK
`orders_id`	Unknown	FK
`carrier_name`	Unknown
`service`	Unknown
`ship_date`	Unknown
`tracking_number`	Unknown
`tracking_url`	Unknown

form_submission

Column	Type	Keys
`_fivetran_id`	String	PK
`orders_id`	Unknown	FK
`label`	Unknown
`value`	Unknown

discount_line

Column	Type	Keys
`_fivetran_id`	String	PK
`orders_id`	Unknown	FK
`amount_currency`	Unknown
`amount_value`	Unknown
`description`	Unknown
`name`	Unknown
`promo_code`	Unknown

shipping_line

Column	Type	Keys
`_fivetran_id`	String	PK
`orders_id`	Unknown	FK
`amount_currency`	Unknown
`amount_value`	Unknown
`method`	Unknown

internal_note

Column	Type	Keys
`content`	Unknown	PK
`orders_id`	Unknown	FK

variant_option

Column	Type	Keys
`_fivetran_id`	String	PK
`line_item_id`	Unknown	FK
`option_name`	Unknown
`value`	Unknown

customization

Column	Type	Keys
`_fivetran_id`	String	PK
`line_item_id`	Unknown	FK
`label`	Unknown
`value`	Unknown

line_item

Column	Type	Keys
`id`	Unknown	PK
`orders_id`	Unknown	FK
`product_id`	Unknown	FK
`variant_id`	Unknown	FK
`line_item_type`	Unknown
`product_name`	Unknown
`quantity`	Unknown
`sku`	Unknown
`unit_price_paid_currency`	Unknown
`unit_price_paid_value`	Unknown

orders

Column	Type	Keys
`id`	Unknown	PK
`customer_email`	Unknown	FK
`billing_address_address_1`	Unknown
`billing_address_address_2`	Unknown
`billing_address_city`	Unknown
`billing_address_country_code`	Unknown
`billing_address_first_name`	Unknown
`billing_address_last_name`	Unknown
`billing_address_phone`	Unknown
`billing_address_postal_code`	Unknown
`billing_address_state`	Unknown
`channel`	Unknown
`channel_name`	Unknown
`created_on`	Unknown
`discount_total_currency`	Unknown
`discount_total_value`	Unknown
`external_order_reference`	Unknown
`fulfilled_on`	Unknown
`fulfillment_status`	Unknown
`grand_total_currency`	Unknown
`grand_total_value`	Unknown
`modified_on`	Unknown
`order_number`	Unknown
`price_tax_interpretation`	Unknown
`refunded_total_currency`	Unknown
`refunded_total_value`	Unknown
`shipping_address_address_1`	Unknown
`shipping_address_address_2`	Unknown
`shipping_address_city`	Unknown
`shipping_address_country_code`	Unknown
`shipping_address_first_name`	Unknown
`shipping_address_last_name`	Unknown
`shipping_address_phone`	Unknown
`shipping_address_postal_code`	Unknown
`shipping_address_state`	Unknown
`shipping_total_currency`	Unknown
`shipping_total_value`	Unknown
`subtotal_currency`	Unknown
`subtotal_value`	Unknown
`tax_total_currency`	Unknown
`tax_total_value`	Unknown
`test_mode`	Unknown