# Pipe17 schema ERD

Table and field reference for the Fivetran Pipe17 connector.

## Table & Field Reference

### purchase_cost

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_id | String | PK, FK |
| cost | Double |  |
| name | String |  |
| quantity | Long |  |

### purchase_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| purchase_id | String | PK, FK |
| location_id | String | FK |
| sku | String | FK |
| name | String |  |
| price | Double |  |
| quantity | Long |  |
| received_quantity | Long |  |
| routed | Boolean |  |
| shipped_quantity | Long |  |
| upc | String |  |

### purchase

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| billing_address_email | String | FK |
| external_order_id | String | FK |
| integration_id | String | FK |
| organization_key | String | FK |
| to_location_id | String | FK |
| vendor_address_email | String | FK |
| actual_arrival_date | Instant |  |
| billing_address_first_name | String |  |
| billing_address_last_name | String |  |
| created_at | Instant |  |
| currency | String |  |
| employee_name | String |  |
| expected_arrival_date | Instant |  |
| incoterms | String |  |
| purchase_notes | String |  |
| purchase_order_date | Instant |  |
| purchase_tax | Double |  |
| reference_number | String |  |
| ship_by_date | Instant |  |
| shipping_carrier | String |  |
| shipping_notes | String |  |
| shipping_service | String |  |
| status | String |  |
| sub_total_price | Double |  |
| time_stamp | Instant |  |
| to_address_first_name | String |  |
| to_address_last_name | String |  |
| total_price | Double |  |
| updated_at | Instant |  |
| vendor_address_first_name | String |  |
| vendor_address_last_name | String |  |
| custom_** |  |  |

### account_integration

| Column | Type | Keys |
| --- | --- | --- |
| account_user_id | String | PK, FK |
| integration_id | String | PK, FK |

### account_role_id

| Column | Type | Keys |
| --- | --- | --- |
| role_id | String | PK |
| account_user_id | String | PK, FK |
| id | Unknown | FK |

### account_payment_sale_discount_code

| Column | Type | Keys |
| --- | --- | --- |
| sales_discount_code | String | PK |
| account_user_id | String | PK, FK |

### account

| Column | Type | Keys |
| --- | --- | --- |
| user_id | String | PK, FK |
| organization_key | String | FK |
| activation_key | String |  |
| billingamount | Double |  |
| billingbase_period | String |  |
| billingcharge_enterprise_support | Boolean |  |
| billingdeleted_at | Instant |  |
| billingeffective_plan | String |  |
| billingnote | String |  |
| billingoverage_amount | Double |  |
| billingoverage_period | String |  |
| billingpaused_at | Instant |  |
| billingplan | String |  |
| billingquota | Double |  |
| billingrenewal_date | Instant |  |
| billingsource | String |  |
| billingstart_date | Instant |  |
| billingstatus | String |  |
| branding_copyright | String |  |
| branding_logo_url | String |  |
| branding_privacy_url | String |  |
| created_at | Instant |  |
| expiration_date | Instant |  |
| is_multi_organization_allowed | Boolean |  |
| is_rebranding_allowed | Boolean |  |
| payment_expiration_date | Instant |  |
| pricing_id | String |  |
| secondary_organization_limit | Long |  |
| status | String |  |
| updated_at | Instant |  |

### inventory

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| integration_id | String | FK |
| location_id | String | FK |
| order_id | String | FK |
| organization_key | String | FK |
| sku | String | FK |
| user | Unknown | FK |
| available | Long |  |
| available_to_promise | Long |  |
| commit_ship | Long |  |
| commit_transferred | Long |  |
| committed | Long |  |
| committed_future | Long |  |
| created_at | Instant |  |
| entity_id | String |  |
| entity_type | String |  |
| event | String |  |
| future | Long |  |
| id | String |  |
| incoming | Long |  |
| on_hand | Long |  |
| order_type | String |  |
| quantity | Long |  |
| status | String |  |
| unavailable | Long |  |
| updated_at | Instant |  |
| user_id | String |  |

### transfer_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| transfer_id | String | PK, FK |
| location_id | String | FK |
| name | String |  |
| quantity | Long |  |
| received_quantity | Long |  |
| routed | Boolean |  |
| shipped_quantity | Long |  |
| sku | String |  |
| upc | String |  |

### transfer

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| from_location_id | String | FK |
| integration_id | String | FK |
| organization_key | String | FK |
| to_location_id | String | FK |
| actual_arrival_date | Instant |  |
| created_at | Instant |  |
| employee_name | String |  |
| expected_arrival_date | Instant |  |
| expected_ship_date | Instant |  |
| external_order_id | String |  |
| incoterms | String |  |
| order_source_type | String |  |
| ship_by_date | Instant |  |
| shipping_carrier | String |  |
| shipping_notes | String |  |
| shipping_service | String |  |
| status | String |  |
| time_stamp | String |  |
| to_address_first_name | String |  |
| to_address_last_name | String |  |
| transfer_notes | String |  |
| transfer_order_date | Instant |  |
| updated_at | Instant |  |
| custom_** |  |  |

### product_published

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | String | PK, FK |
| integration_id | String | FK |
| buffer_inventory | Long |  |
| external_product_id | String |  |
| inventory_not_tracked | Boolean |  |
| name | String |  |
| sku | Unknown |  |
| status | String |  |
| updated_at | Instant |  |

### product_bundle_item

| Column | Type | Keys |
| --- | --- | --- |
| sku | String | PK |
| product_id | String | PK, FK |
| quantity | Long |  |

### product_variant_option

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | String | PK, FK |
| name | String |  |
| value | String |  |

### product_price

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | String | PK, FK |
| currency | String |  |
| name | String |  |
| value | Double |  |

### product_image_url

| Column | Type | Keys |
| --- | --- | --- |
| image_url | String | PK |
| product_id | String | PK, FK |

### product_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | String | PK, FK |
| tags | String |  |

### product_type

| Column | Type | Keys |
| --- | --- | --- |
| type | String | PK |
| product_id | String | PK, FK |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| integration_id | String | FK |
| mapped_product_integration_id | String | FK |
| organization_key | String | FK |
| cost | Double |  |
| cost_currency | String |  |
| country_of_origin | String |  |
| created_at | Instant |  |
| description | String |  |
| dimensions_unit | String |  |
| external_product_api_id | String |  |
| external_product_created_at | Instant |  |
| external_product_id | String |  |
| external_product_updated_at | Instant |  |
| harmonized_code | String |  |
| height | Double |  |
| hide_in_store | Boolean |  |
| inventory_not_tracked | Boolean |  |
| length | Double |  |
| mapped_product_buffer_inventory | Long |  |
| mapped_product_external_product_id | String |  |
| mapped_product_inventory_not_tracked | Boolean |  |
| mapped_product_name | String |  |
| mapped_product_sku | String |  |
| mapped_product_status | String |  |
| mapped_product_updated_at | Instant |  |
| name | String |  |
| parent_external_product_id | String |  |
| part_id | String |  |
| sku | String |  |
| status | String |  |
| taxable | Boolean |  |
| upc | String |  |
| updated_at | Instant |  |
| vendor | String |  |
| weight | Double |  |
| weight_unit | String |  |
| width | Double |  |
| custom_** |  |  |

### order_additional_charge

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | String | PK, FK |
| orders_id | String | PK, FK |
| label | String |  |
| reference | String |  |
| type | String |  |
| value | Double |  |

### order_discount

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_id | String | PK, FK |
| line_item_id | String | FK |
| label | String |  |
| reference | String |  |
| type | String |  |
| value | Double |  |

### order_payment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_id | String | PK, FK |
| amount | Double |  |
| conversion | Long |  |
| currency | String |  |
| custom_method | String |  |
| kind | String |  |
| method | String |  |
| reference | String |  |
| status | String |  |

### order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| orders_id | String | PK, FK |
| location_id | String | FK |
| sku | String | FK |
| item_discount | Double |  |
| item_price | Double |  |
| item_tax | Double |  |
| name | String |  |
| quantity | Long |  |
| requires_shipping | Boolean |  |
| routed | Boolean |  |
| taxable | Boolean |  |
| custom_** |  |  |

### order_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_id | String | PK, FK |
| tags | String |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| billing_address_email | String | FK |
| customer_id | Unknown | FK |
| integration_id | String | FK |
| location_id | String | FK |
| organization_key | String | FK |
| shipping_address_email | String | FK |
| billing_address_first_name | String |  |
| billing_address_last_name | String |  |
| created_at | Instant |  |
| currency | String |  |
| expected_delivery_date | Instant |  |
| external_order_api_id | String |  |
| external_order_created_at | Instant |  |
| external_order_id | String |  |
| external_order_updated_at | Instant |  |
| external_order_url | String |  |
| fulfillment_status | String |  |
| gift_note | String |  |
| incoterms | String |  |
| order_discount | Double |  |
| order_note | String |  |
| order_source | String |  |
| order_source_type | String |  |
| order_tax | Double |  |
| payment_status | String |  |
| require_shipping_labels | Boolean |  |
| routing_status | String |  |
| ship_after_date | Instant |  |
| ship_by_date | Instant |  |
| ship_cancel_by_date | Instant |  |
| shipping_address_first_name | String |  |
| shipping_address_last_name | String |  |
| shipping_carrier | String |  |
| shipping_class | String |  |
| shipping_code | String |  |
| shipping_note | String |  |
| shipping_price | Double |  |
| status | String |  |
| sub_total_price | Double |  |
| time_stamp | Instant |  |
| total_price | Double |  |
| updated_at | Instant |  |
| custom_** |  |  |

### label

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| organization_key | String | FK |
| tracking_number | String | FK |
| content_type | String |  |
| created_at | Instant |  |
| file_name | String |  |
| label_type | String |  |
| shipping_method | String |  |
| status | String |  |
| updated_at | Instant |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| billing_email | Unknown | FK |
| organization_key | String | FK |
| shipping_email | Unknown | FK |
| company | String |  |
| created_at | Instant |  |
| display_name | String |  |
| email | String |  |
| external_customer_id | String |  |
| first_name | String |  |
| last_name | String |  |
| phone | String |  |
| status | String |  |
| updated_at | Instant |  |
| custom_** |  |  |

### mapping_attribute

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| mapping_id | String | FK |
| defaults | Json |  |
| enabled | Boolean |  |
| lookup | Json |  |
| missing | String |  |
| name | String |  |
| require | String |  |
| source | String |  |
| target | String |  |
| type | String |  |

### mapping

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| connector_id | String | FK |
| organization_key | String | FK |
| created_at | Instant |  |
| description | String |  |
| is_public | Boolean |  |
| origin_id | String |  |
| updated_at | Instant |  |
| uuid | String |  |

### user_role

| Column | Type | Keys |
| --- | --- | --- |
| role | String | PK |
| users_id | String | PK, FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| email | String | FK |
| organization_key | String | FK |
| created_at | Instant |  |
| description | String |  |
| last_ip_address | String |  |
| last_login | Instant |  |
| logins_count | Long |  |
| name | String |  |
| phone | String |  |
| status | String |  |
| time_zone | String |  |
| updated_at | Instant |  |

### connector_entity

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| connector_id | String | PK, FK |
| mapping_uuid | String | FK |
| routing_uuid | String | FK |
| direction | String |  |
| name | String |  |
| path | Json |  |

### connector_action_field

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| connector_id | String | FK |
| groups | String |  |
| options_common | Boolean |  |
| options_component | String |  |
| options_default_value | Json |  |
| options_end_adornment | String |  |
| options_extra | Json |  |
| options_fields | Json |  |
| options_genkey | String |  |
| options_group | String |  |
| options_helper_text | String |  |
| options_hidden | Boolean |  |
| options_label | String |  |
| options_place_holder | String |  |
| options_read_me | String |  |
| options_read_only | Boolean |  |
| options_start_adornment | String |  |
| options_wizard | Boolean |  |
| path | String |  |
| secret | Boolean |  |
| type | String |  |

### connector_action

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| connector_id | String | FK |
| action_name | String |  |
| action_type | String |  |
| description | String |  |
| verb | String |  |

### connector

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| organization_key | String | FK |
| availability_status | String |  |
| capability | Json |  |
| connection_type | String |  |
| connection_url | String |  |
| connector_name | String |  |
| connector_type | String |  |
| created_at | Instant |  |
| description | String |  |
| display_name | String |  |
| intent_name | String |  |
| intent_rank | Long |  |
| intent_show | Boolean |  |
| is_public | Boolean |  |
| logo_url | String |  |
| organization_unique | Boolean |  |
| organization_wide_access | Boolean |  |
| pricing_category | String |  |
| rank | Long |  |
| read_me | String |  |
| self_service_mode | String |  |
| slug | String |  |
| status | String |  |
| updated_at | Instant |  |
| version | String |  |
| webhook_topics | Json |  |
| webhook_url | String |  |

### connector_field

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| connector_id | String | FK |
| groups | String |  |
| options | Json |  |
| options_common | Boolean |  |
| options_component | String |  |
| options_default_value | Json |  |
| options_end_adornment | String |  |
| options_extra | Json |  |
| options_fields | Json |  |
| options_genkey | String |  |
| options_group | String |  |
| options_helper_text | String |  |
| options_hidden | Boolean |  |
| options_label | String |  |
| options_place_holder | String |  |
| options_read_me | String |  |
| options_read_only | Boolean |  |
| options_start_adornment | String |  |
| options_wizard | Boolean |  |
| path | String |  |
| secret | Boolean |  |
| status | Unknown |  |
| type | String |  |

### location_external_system

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| location_id | String | PK, FK |
| integration_id | String | FK |
| location_value | String |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| integration_id | String | FK |
| organization_key | String | FK |
| address_1 | String |  |
| address_2 | String |  |
| city | String |  |
| company | String |  |
| country | String |  |
| created_at | Instant |  |
| email | String |  |
| exclude_from_totals | Boolean |  |
| fulfillment_integration_id | String |  |
| infinite | Boolean |  |
| inventory_integration_id | String |  |
| merged_with_location_id | String |  |
| name | String |  |
| phone | String |  |
| preserve_bundles | Boolean |  |
| state_or_province | String |  |
| status | String |  |
| updated_at | Instant |  |
| zip_code_or_postal_code | String |  |

### routing

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| organization_key | String | FK |
| created_at | Instant |  |
| description | String |  |
| enabled | Boolean |  |
| filter | String |  |
| is_public | Boolean |  |
| updated_at | Instant |  |
| uuid | String |  |

### shipment_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| shipment_id | String | PK, FK |
| sku | String | FK |
| bundle_quantity | Long |  |
| bundle_sku | String |  |
| item_price | Double |  |
| name | String |  |
| quantity | Long |  |
| shipped_quantity | Long |  |
| custom_** |  |  |

### shipment_shipping_label

| Column | Type | Keys |
| --- | --- | --- |
| shipping_label | String | PK |
| shipment_id | String | PK, FK |

### shipment_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipment_id | String | PK, FK |
| tags | String |  |

### shipment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| integration_id | String | FK |
| location_id | String | FK |
| order_id | String | FK |
| order_type | String | FK |
| organization_key | String | FK |
| created_at | Instant |  |
| expected_delivery_date | Instant |  |
| expected_ship_date | Instant |  |
| external_order_id | String |  |
| external_reference_id | String |  |
| external_reference_url | String |  |
| external_shipment_id | String |  |
| fulfillment_integration_id | String |  |
| gift_note | String |  |
| incoterms | String |  |
| order_create_time | String |  |
| sent_to_fulfillment_at | Instant |  |
| ship_after_date | Instant |  |
| ship_by_date | Instant |  |
| ship_cancel_by_date | Instant |  |
| shipping_address_first_name | String |  |
| shipping_address_last_name | String |  |
| shipping_carrier | String |  |
| shipping_class | String |  |
| shipping_code | String |  |
| shipping_method_mapping | Boolean |  |
| shipping_note | String |  |
| status | String |  |
| updated_at | Instant |  |
| version | Long |  |
| custom_** |  |  |

### fulfillment_line_item

| Column | Type | Keys |
| --- | --- | --- |
| fulfillment_id | String | PK, FK |
| sku | String | PK, FK |
| unique_id | String | FK |
| bundle_quantity | Long |  |
| bundle_quantity_partial | Json |  |
| bundle_sku | String |  |
| quantity | Long |  |

### fulfillment_tracking_number

| Column | Type | Keys |
| --- | --- | --- |
| tracking_number | String | PK |
| fulfillment_id | String | PK, FK |

### fulfillment_tracking_url

| Column | Type | Keys |
| --- | --- | --- |
| tracking_url | String | PK |
| fulfillment_id | String | PK, FK |

### fulfillment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| integration_id | String | FK |
| location_id | String | FK |
| organization_key | String | FK |
| shipment_id | String | FK |
| actual_ship_date | Instant |  |
| created_at | Instant |  |
| expected_arrival_date | Instant |  |
| external_fulfillment_id | String |  |
| external_order_id | String |  |
| shipping_carrier | String |  |
| shipping_charge | Double |  |
| shipping_class | String |  |
| updated_at | Instant |  |
| weight | Double |  |
| weight_unit | String |  |
| custom_** |  |  |

### supplier_contact

| Column | Type | Keys |
| --- | --- | --- |
| email | String | PK |
| supplier_id | String | PK, FK |
| organization_key | Unknown | FK |
| first_name | String |  |
| last_name | String |  |
| phone | String |  |

### supplier

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| organization_key | String | FK |
| address_address_1 | String |  |
| address_address_2 | String |  |
| address_city | String |  |
| address_country | String |  |
| address_state_or_province | String |  |
| address_zip_code_or_postal_code | String |  |
| created_at | Instant |  |
| name | String |  |
| updated_at | Instant |  |

### organization_setting

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_key | String | PK, FK |
| path | String |  |
| type | String |  |
| value | Json |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| organization_key | String | PK |
| account_id | String | FK |
| email | String | FK |
| branding_copyright | String |  |
| branding_logo_url | String |  |
| branding_privacy_url | String |  |
| created_at | Instant |  |
| is_holding_organization | Boolean |  |
| logo_url | String |  |
| name | String |  |
| organization_mode | String |  |
| phone | String |  |
| status | String |  |
| tier | String |  |
| time_zone | String |  |
| updated_at | Instant |  |

### role

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| organization_key | String | FK |
| created_at | Instant |  |
| description | String |  |
| is_public | Boolean |  |
| name | String |  |
| status | String |  |
| updated_at | Instant |  |

### arrival_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| arrival_id | String | PK, FK |
| unique_id | Unknown | FK |
| name | String |  |
| quantity | Long |  |
| received_quantity | Long |  |
| sku | String |  |
| upc | String |  |

### arrival

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| from_location_id | String | FK |
| fulfillment_id | String | FK |
| integration_id | String | FK |
| organization_key | String | FK |
| purchase_id | String | FK |
| to_location_id | String | FK |
| transfer_id | String | FK |
| created_at | Instant |  |
| expected_arrival_date | Instant |  |
| external_arrival_id | String |  |
| external_order_id | String |  |
| incoterms | String |  |
| sender_name | String |  |
| shipping_carrier | String |  |
| shipping_method | String |  |
| shipping_note | String |  |
| status | String |  |
| total_weight | String |  |
| updated_at | Instant |  |
| weight_unit | String |  |
| custom_** |  |  |

### inventory_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| integration_id | String | FK |
| organization_key | String | FK |
| created_at | Instant |  |
| description | String |  |
| event | String |  |
| partner | String |  |
| ptype | String |  |
| rule | String |  |
| status | String |  |
| updated_at | Instant |  |

### receipt_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| receipt_id | String | PK, FK |
| quantity | Long |  |
| sku | String |  |

### receipt

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| arrival_id | String | FK |
| integration_id | String | FK |
| organization_key | String | FK |
| created_at | Instant |  |
| currency | String |  |
| external_order_id | String |  |
| external_receipt_id | String |  |
| shipping_carrier | String |  |
| shipping_class | String |  |
| updated_at | Instant |  |
| custom_** |  |  |

### tracking

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| fulfillment_id | String | FK |
| organization_key | String | FK |
| actual_arrival_date | Instant |  |
| actual_ship_date | Instant |  |
| created_at | Instant |  |
| expected_arrival_date | Instant |  |
| shipping_carrier | String |  |
| status | String |  |
| tracking_number | String |  |
| updated_at | Instant |  |
| url | String |  |

### shipping_method_mapped_method

| Column | Type | Keys |
| --- | --- | --- |
| method_id | String | PK |
| shipping_method_id | String | PK, FK |

### shipping_method

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| integration_id | String | FK |
| organization_key | String | FK |
| created_at | Instant |  |
| description | String |  |
| external_method_id | String |  |
| is_default | Boolean |  |
| is_passthrough | Boolean |  |
| name | String |  |
| shipping_carrier | String |  |
| shipping_code | String |  |
| shipping_service | String |  |
| source_integration_id | String |  |
| source_type | String |  |
| status | String |  |
| updated_at | Instant |  |

### integration_entity_restriction

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| integration_id | String | PK, FK |
| path | String |  |
| type | String |  |
| value | Json |  |

### integration_entity

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| integration_id | String | PK, FK |
| mapping_uuid | String | FK |
| routing_uuid | String | FK |
| direction | String |  |
| name | String |  |

### integration_connection_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| integration_id | String | PK, FK |
| path | String |  |
| value | Json |  |

### integration_setting_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| integration_id | String | PK, FK |
| path | String |  |
| value | Json |  |

### integration

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| connector_id | String | FK |
| organization_key | String | FK |
| capability | Json |  |
| connector_name | String |  |
| created_at | Instant |  |
| environment | String |  |
| error_text | String |  |
| integration_name | String |  |
| status | String |  |
| updated_at | Instant |  |
| variables_property_1_type | String |  |
| variables_property_1_value | Json |  |
| variables_property_2_type | String |  |
| variables_property_2_value | Json |  |
| version | String |  |

### action_param

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| integration_action_id | String | PK, FK |
| path | String |  |
| value | Json |  |

### integration_action

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| integration_id | String | FK |
| organization_key | String | FK |
| action_name | String |  |
| action_type | String |  |
| created_at | Instant |  |
| progress | Long |  |
| status | String |  |
| updated_at | Instant |  |

## Relationships

- purchase_cost(purchase_id) → purchase(id)
- purchase_line_item(sku) → product(sku)
- purchase_line_item(location_id) → location(id)
- purchase_line_item(purchase_id) → purchase(id)
- purchase(external_order_id) → orders(id)
- purchase(organization_key) → organization(organization_key)
- purchase(integration_id) → integration(id)
- purchase(to_location_id) → location(id)
- purchase(billing_address_email) → location(email)
- purchase(vendor_address_email) → location(email)
- account_integration(integration_id) → integration(id)
- account_integration(account_user_id) → account(user_id)
- account_role_id(id) → role(id)
- account_role_id(account_user_id) → account(user_id)
- account_payment_sale_discount_code(account_user_id) → account(user_id)
- account(user_id) → users(id)
- account(organization_key) → organization(organization_key)
- inventory(sku) → product(sku)
- inventory(order_id) → orders(id)
- inventory(organization_key) → organization(organization_key)
- inventory(integration_id) → integration(id)
- inventory(location_id) → location(id)
- inventory(user) → users(id)
- transfer_line_item(location_id) → location(id)
- transfer_line_item(transfer_id) → transfer(id)
- transfer(from_location_id) → location(id)
- transfer(organization_key) → organization(organization_key)
- transfer(integration_id) → integration(id)
- transfer(to_location_id) → location(id)
- product_published(integration_id) → integration(id)
- product_published(product_id) → product(id)
- product_bundle_item(product_id) → product(id)
- product_variant_option(product_id) → product(id)
- product_price(product_id) → product(id)
- product_image_url(product_id) → product(id)
- product_tag(product_id) → product(id)
- product_type(product_id) → product(id)
- product(organization_key) → organization(organization_key)
- product(integration_id) → integration(id)
- product(mapped_product_integration_id) → integration(id)
- order_additional_charge(line_item_id) → order_line_item(id)
- order_additional_charge(orders_id) → orders(id)
- order_discount(line_item_id) → order_line_item(id)
- order_discount(orders_id) → orders(id)
- order_payment(orders_id) → orders(id)
- order_line_item(sku) → product(sku)
- order_line_item(location_id) → location(id)
- order_line_item(orders_id) → orders(id)
- order_tag(orders_id) → orders(id)
- orders(organization_key) → organization(organization_key)
- orders(integration_id) → integration(id)
- orders(customer_id) → customer(id)
- orders(location_id) → location(id)
- orders(billing_address_email) → location(email)
- orders(shipping_address_email) → location(email)
- label(tracking_number) → tracking(tracking_number)
- label(organization_key) → organization(organization_key)
- customer(billing_email) → location(email)
- customer(organization_key) → organization(organization_key)
- customer(shipping_email) → location(email)
- mapping_attribute(mapping_id) → mapping(id)
- mapping(connector_id) → connector(id)
- mapping(organization_key) → organization(organization_key)
- user_role(users_id) → users(id)
- users(email) → location(email)
- users(organization_key) → organization(organization_key)
- connector_entity(mapping_uuid) → mapping(uuid)
- connector_entity(routing_uuid) → routing(uuid)
- connector_entity(connector_id) → connector(id)
- connector_action_field(connector_id) → connector_action(connector_id)
- connector_action(connector_id) → connector(id)
- connector(organization_key) → organization(organization_key)
- connector_field(connector_id) → connector(id)
- location_external_system(integration_id) → integration(id)
- location_external_system(location_id) → location(id)
- location(organization_key) → organization(organization_key)
- location(integration_id) → integration(id)
- routing(organization_key) → organization(organization_key)
- shipment_line_item(sku) → product(sku)
- shipment_line_item(shipment_id) → shipment(id)
- shipment_shipping_label(shipment_id) → shipment(id)
- shipment_tag(shipment_id) → shipment(id)
- shipment(order_type) → inventory(order_type)
- shipment(order_id) → orders(id)
- shipment(organization_key) → organization(organization_key)
- shipment(integration_id) → integration(id)
- shipment(location_id) → location(id)
- fulfillment_line_item(sku) → product(sku)
- fulfillment_line_item(unique_id) → shipment_line_item(id)
- fulfillment_line_item(fulfillment_id) → fulfillment(id)
- fulfillment_tracking_number(fulfillment_id) → fulfillment(id)
- fulfillment_tracking_url(fulfillment_id) → fulfillment(id)
- fulfillment(organization_key) → organization(organization_key)
- fulfillment(integration_id) → integration(id)
- fulfillment(shipment_id) → shipment(id)
- fulfillment(location_id) → location(id)
- supplier_contact(supplier_id) → supplier(id)
- supplier_contact(organization_key) → organization(organization_key)
- supplier(organization_key) → organization(organization_key)
- organization_setting(organization_key) → organization(organization_key)
- organization(email) → location(email)
- organization(account_id) → account(user_id)
- role(organization_key) → organization(organization_key)
- arrival_line_item(unique_id) → receipt_line_item(id)
- arrival_line_item(arrival_id) → arrival(id)
- arrival(from_location_id) → location(id)
- arrival(fulfillment_id) → fulfillment(id)
- arrival(organization_key) → organization(organization_key)
- arrival(integration_id) → integration(id)
- arrival(transfer_id) → transfer(id)
- arrival(to_location_id) → location(id)
- arrival(purchase_id) → purchase(id)
- inventory_rule(organization_key) → organization(organization_key)
- inventory_rule(integration_id) → integration(id)
- receipt_line_item(receipt_id) → receipt(id)
- receipt(arrival_id) → arrival(id)
- receipt(organization_key) → organization(organization_key)
- receipt(integration_id) → integration(id)
- tracking(fulfillment_id) → fulfillment(id)
- tracking(organization_key) → organization(organization_key)
- shipping_method_mapped_method(shipping_method_id) → shipping_method(id)
- shipping_method(organization_key) → organization(organization_key)
- shipping_method(integration_id) → integration(id)
- integration_entity_restriction(integration_id) → integration_entity(integration_id)
- integration_entity(mapping_uuid) → mapping(uuid)
- integration_entity(routing_uuid) → routing(uuid)
- integration_entity(integration_id) → integration(id)
- integration_connection_field(integration_id) → integration(id)
- integration_setting_field(integration_id) → integration(id)
- integration(connector_id) → connector(id)
- integration(organization_key) → organization(organization_key)
- action_param(integration_action_id) → integration_action(id)
- integration_action(organization_key) → organization(organization_key)
- integration_action(integration_id) → integration(id)