# eBay schema ERD

Table and field reference for the Fivetran eBay connector.

## Table & Field Reference

### orders_fulfillment_start_instruction

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| ebay_supported_fulfillment | Unknown |  |
| fulfillment_instructions_type | Unknown |  |
| max_estimated_delivery_date | Unknown |  |
| min_estimated_delivery_date | Unknown |  |
| ship_to_contact_address_city | Unknown |  |
| ship_to_contact_address_country_code | Unknown |  |
| ship_to_contact_address_line_1 | Unknown |  |
| ship_to_contact_address_line_2 | Unknown |  |
| ship_to_contact_address_postalcode | Unknown |  |
| ship_to_contact_address_state | Unknown |  |
| ship_to_email | Unknown |  |
| ship_to_fullname | Unknown |  |
| ship_to_phone_number | Unknown |  |
| shipping_service_code | Unknown |  |

### orders_line_item_refund

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_line_item_id | Unknown | PK, FK |
| orders_line_item_order_id | Unknown | PK, FK |
| amount_currency | Unknown |  |
| amount_value | Unknown |  |
| converted_from_currency | Unknown |  |
| converted_from_value | Unknown |  |
| refund_date | Unknown |  |
| refund_id | Unknown |  |
| refund_reference_id | Unknown |  |
| refund_status | Unknown |  |

### orders_line_item_promotion

| Column | Type | Keys |
| --- | --- | --- |
| promotion_id | Unknown | PK |
| orders_line_item_id | Unknown | PK, FK |
| orders_line_item_order_id | Unknown | PK, FK |
| amount_currency | Unknown |  |
| amount_value | Unknown |  |
| converted_from_currency | Unknown |  |
| converted_from_value | Unknown |  |
| description | Unknown |  |

### orders_line_item_tax

| Column | Type | Keys |
| --- | --- | --- |
| tax_type | Unknown | PK |
| orders_line_item_id | Unknown | PK, FK |
| orders_line_item_order_id | Unknown | PK, FK |
| amount_currency | Unknown |  |
| amount_value | Unknown |  |
| converted_from_currency | Unknown |  |
| converted_from_value | Unknown |  |

### orders_line_item_variation_aspect

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_line_item_id | Unknown | PK, FK |
| orders_line_item_order_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### orders_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | PK, FK |
| buyer_protection | Unknown |  |
| cost_currency | Unknown |  |
| cost_value | Unknown |  |
| fulfillment_status | Unknown |  |
| guaranteed_delivery | Unknown |  |
| item_country_code | Unknown |  |
| item_location | Unknown |  |
| item_postal_code | Unknown |  |
| legacy_item_id | Unknown |  |
| legacy_variation_id | Unknown |  |
| listing_marketplace_id | Unknown |  |
| max_estimated_delivery_date | Unknown |  |
| min_estimated_delivery_date | Unknown |  |
| purchase_marketplace_id | Unknown |  |
| quantity | Unknown |  |
| ship_by_date | Unknown |  |
| shipping_cost_currency | Unknown |  |
| shipping_cost_value | Unknown |  |
| sku | Unknown |  |
| sold_format | Unknown |  |
| sold_via_ad_campaign | Unknown |  |
| title | Unknown |  |
| total_currency | Unknown |  |
| total_value | Unknown |  |

### orders_payment_refund

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_payment_order_id | Unknown | PK, FK |
| orders_payment_reference_id | Unknown | PK, FK |
| amount_currency | Unknown |  |
| amount_value | Unknown |  |
| converted_from_currency | Unknown |  |
| converted_from_value | Unknown |  |
| refund_date | Unknown |  |
| refund_id | Unknown |  |
| refund_reference_id | Unknown |  |
| refund_status | Unknown |  |

### orders_payment_hold

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_payment_order_id | Unknown | PK, FK |
| orders_payment_reference_id | Unknown | PK, FK |
| amount_currency | Unknown |  |
| amount_value | Unknown |  |
| expected_release_date | Unknown |  |
| reason | Unknown |  |
| release_date | Unknown |  |
| seller_action_to_release | Unknown |  |
| state | Unknown |  |

### orders_payment

| Column | Type | Keys |
| --- | --- | --- |
| reference_id | Unknown | PK |
| order_id | Unknown | PK, FK |
| amount_currency | Unknown |  |
| amount_value | Unknown |  |
| date | Unknown |  |
| method | Unknown |  |
| status | Unknown |  |

### order_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| adjustment_currency | Unknown |  |
| adjustment_value | Unknown |  |
| buyer_contact_address_city | Unknown |  |
| buyer_contact_address_country_code | Unknown |  |
| buyer_contact_address_line_1 | Unknown |  |
| buyer_contact_address_postal_code | Unknown |  |
| buyer_contact_address_state | Unknown |  |
| buyer_email | Unknown |  |
| buyer_fullname | Unknown |  |
| buyer_phone_number | Unknown |  |
| buyer_secondary_phone_number | Unknown |  |
| buyer_tax_address_city | Unknown |  |
| buyer_tax_address_country_code | Unknown |  |
| buyer_tax_address_postal_code | Unknown |  |
| buyer_tax_address_state | Unknown |  |
| buyer_username | Unknown |  |
| cancel_request | Json |  |
| cancel_state | Unknown |  |
| creation_date | Unknown |  |
| delivery_cost_currency | Unknown |  |
| delivery_cost_value | Unknown |  |
| delivery_discount_currency | Unknown |  |
| delivery_discount_value | Unknown |  |
| ebay_collect_and_remit_tax | Unknown |  |
| fee_currency | Unknown |  |
| fee_value | Unknown |  |
| fulfillment_href | Json |  |
| last_modified_date | Unknown |  |
| legacy_order_id | Unknown |  |
| order_fulfillment_status | Unknown |  |
| order_payment_status | Unknown |  |
| payment_refund | Json |  |
| payment_total_due_seller_currency | Unknown |  |
| payment_total_due_seller_value | Unknown |  |
| price_discount_currency | Unknown |  |
| price_discount_value | Unknown |  |
| price_subtotal_currency | Unknown |  |
| price_subtotal_value | Unknown |  |
| sales_record_reference | Unknown |  |
| seller_id | Unknown |  |
| tax_currency | Unknown |  |
| tax_value | Unknown |  |
| total_currency | Unknown |  |
| total_fee_basis_amountcurrency | Unknown |  |
| total_fee_basis_amountvalue | Unknown |  |
| total_marketplace_feecurrency | Unknown |  |
| total_marketplace_feevalue | Unknown |  |
| total_value | Unknown |  |

### shipping_fulfillment_line_item

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | Unknown | PK, FK |
| shipping_fulfillment_fivetran_id | Unknown | PK, FK |
| quantity | Unknown |  |

### shipping_fulfillment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| order_id | Unknown | FK |
| carrier_code | Unknown |  |
| fulfillment_id | Unknown |  |
| service_code | Unknown |  |
| shipped_date | Unknown |  |
| tracking_number | Unknown |  |

### payment_dispute_activity

| Column | Type | Keys |
| --- | --- | --- |
| activity_date | Unknown | PK |
| payment_dispute_id | Unknown | PK, FK |
| activity_type | Unknown |  |
| actor | Unknown |  |

### payment_dispute_line_item

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | Unknown | PK, FK |
| payment_dispute_id | Unknown | PK, FK |
| item_id | Unknown |  |

### payment_dispute

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| amount_currency | Unknown |  |
| amount_value | Unknown |  |
| buyer_provided_note | Unknown |  |
| buyer_username | Unknown |  |
| open_date | Unknown |  |
| reason | Unknown |  |
| respond_by_date | Unknown |  |
| revision | Unknown |  |
| seller_response | Unknown |  |
| status | Unknown |  |

## Relationships

- orders_fulfillment_start_instruction(order_id) → order_history(id)
- orders_line_item_refund(orders_line_item_order_id) → orders_line_item(order_id)
- orders_line_item_refund(orders_line_item_id) → orders_line_item(id)
- orders_line_item_promotion(orders_line_item_order_id) → orders_line_item(order_id)
- orders_line_item_promotion(orders_line_item_id) → orders_line_item(id)
- orders_line_item_tax(orders_line_item_order_id) → orders_line_item(order_id)
- orders_line_item_tax(orders_line_item_id) → orders_line_item(id)
- orders_line_item_variation_aspect(orders_line_item_order_id) → orders_line_item(order_id)
- orders_line_item_variation_aspect(orders_line_item_id) → orders_line_item(id)
- orders_line_item(order_id) → order_history(id)
- orders_payment_refund(orders_payment_order_id) → orders_payment(order_id)
- orders_payment_refund(orders_payment_reference_id) → orders_payment(reference_id)
- orders_payment_hold(orders_payment_order_id) → orders_payment(order_id)
- orders_payment_hold(orders_payment_reference_id) → orders_payment(reference_id)
- orders_payment(order_id) → order_history(id)
- shipping_fulfillment_line_item(line_item_id) → orders_line_item(id)
- shipping_fulfillment_line_item(shipping_fulfillment_fivetran_id) → shipping_fulfillment(_fivetran_id)
- shipping_fulfillment(order_id) → order_history(id)
- payment_dispute_activity(payment_dispute_id) → payment_dispute(id)
- payment_dispute_line_item(line_item_id) → orders_line_item(id)
- payment_dispute_line_item(payment_dispute_id) → payment_dispute(id)
- payment_dispute(order_id) → order_history(id)