# Squarespace schema ERD

Table and field reference for the Fivetran Squarespace connector.

## 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 | PK, FK |
| 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 |  |

## Relationships

- refund(payment_id) → payment(id)
- fee_refund(processing_fee_id) → processing_fee(id)
- processing_fee(payment_id) → payment(id)
- payment(transaction_id) → transaction(id)
- sale_line_item_tax(sale_line_item_id) → sale_line_item(id)
- sale_line_item(transaction_id) → transaction(id)
- discount(transaction_id) → transaction(id)
- shipping_line_item_tax(shipping_line_item_id) → shipping_line_item(id)
- shipping_line_item(transaction_id) → transaction(id)
- transaction(customer_email) → profile(email)
- transaction(sales_order_id) → orders(id)
- inventory(variant_id) → variant(id)
- image(product_id) → product(id)
- variant(image_id) → image(id)
- variant(product_id) → product(id)
- product(store_page_id) → store_page(id)
- fulfillment(orders_id) → orders(id)
- form_submission(orders_id) → orders(id)
- discount_line(orders_id) → orders(id)
- shipping_line(orders_id) → orders(id)
- internal_note(orders_id) → orders(id)
- variant_option(line_item_id) → line_item(id)
- customization(line_item_id) → line_item(id)
- line_item(product_id) → product(id)
- line_item(variant_id) → variant(id)
- line_item(orders_id) → orders(id)
- orders(customer_email) → profile(email)