# EasyPost schema ERD

Table and field reference for the Fivetran EasyPost connector.

## Table & Field Reference

### insurance

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| from_address_id | Unknown | FK |
| shipment_id | Unknown | FK |
| to_address_id | Unknown | FK |
| tracking_code | Unknown | FK |
| amount | Unknown |  |
| created_at | Unknown |  |
| fee_amount | Unknown |  |
| fee_charged | Unknown |  |
| fee_object | Unknown |  |
| fee_refunded | Unknown |  |
| fee_type | Unknown |  |
| messages | Json |  |
| mode | Unknown |  |
| provider | Unknown |  |
| reference | Unknown |  |
| status | Unknown |  |
| tracker | Unknown |  |
| updated_at | Unknown |  |

### address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| carrier_facility | Unknown |  |
| city | Unknown |  |
| company | Unknown |  |
| country | Unknown |  |
| created_at | Instant |  |
| email | Unknown |  |
| federal_tax_id | Unknown |  |
| mode | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| residential | Unknown |  |
| state | Unknown |  |
| state_tax_id | Unknown |  |
| street_1 | Unknown |  |
| street_2 | Unknown |  |
| updated_at | Unknown |  |
| verification_zip_4_details | Unknown |  |
| verification_zip_4_success | Boolean |  |
| verifications_delivery_latitude | Unknown |  |
| verifications_delivery_longitude | Unknown |  |
| verifications_delivery_success | Unknown |  |
| verifications_delivery_time_zone | Unknown |  |
| zip | Unknown |  |

### address_error

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | Unknown | PK |
| address_id | Unknown | FK |
| code | Unknown |  |
| field | Unknown |  |
| message | Unknown |  |
| suggestion | Unknown |  |
| type | Unknown |  |

### end_shipper

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| city | Unknown |  |
| company | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| mode | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| state | Unknown |  |
| street_1 | Unknown |  |
| street_2 | Unknown |  |
| updated_at | Unknown |  |
| zip | Unknown |  |

### scan_form_tracking_code

| Column | Type | Keys |
| --- | --- | --- |
| tracking_code | Unknown | PK |
| scan_form_id | Unknown | PK, FK |

### scan_form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_id | Unknown | FK |
| batch_id | Unknown | FK |
| confirmation | Unknown |  |
| created_at | Unknown |  |
| form_file_type | Unknown |  |
| message | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### batch_shipment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| batch_id | Unknown | FK |
| batch_message | Unknown |  |
| batch_status | Unknown |  |
| reference | Unknown |  |
| tracking_code | Unknown |  |

### batch

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| scan_form_id | Unknown | FK |
| created_at | Unknown |  |
| mode | Unknown |  |
| pickup | Unknown |  |
| reference | Unknown |  |
| state | Unknown |  |
| status_created | Unknown |  |
| status_creation_failed | Unknown |  |
| status_postage_purchase_failed | Unknown |  |
| status_postage_purchased | Unknown |  |
| status_queued_for_purchase | Unknown |  |
| updated_at | Unknown |  |

### tracker_detail

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| tracker_id | Unknown | FK |
| carrier_code | Unknown |  |
| datetime | Unknown |  |
| description | Unknown |  |
| message | Unknown |  |
| source | Unknown |  |
| status | Unknown |  |
| status_detail | Unknown |  |

### tracker

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | FK |
| carrier | Unknown |  |
| carrier_alternate_identifier | Unknown |  |
| carrier_container_type | Unknown |  |
| carrier_destination_location | Unknown |  |
| carrier_destination_tracking_location | Unknown |  |
| carrier_est_delivery_date_local | Unknown |  |
| carrier_est_delivery_time_local | Unknown |  |
| carrier_guaranteed_delivery_date | Unknown |  |
| carrier_initial_delivery_attempt | Unknown |  |
| carrier_object | Unknown |  |
| carrier_origin_location | Unknown |  |
| carrier_origin_tracking_city | Unknown |  |
| carrier_origin_tracking_country | Unknown |  |
| carrier_origin_tracking_object | Unknown |  |
| carrier_origin_tracking_state | Unknown |  |
| carrier_origin_tracking_zip | Unknown |  |
| carrier_service | Unknown |  |
| created_at | Unknown |  |
| est_delivery_date | Unknown |  |
| fees | Json |  |
| mode | Unknown |  |
| public_url | Unknown |  |
| signed_by | Unknown |  |
| status | Unknown |  |
| status_detail | Unknown |  |
| tracking_code | Unknown |  |
| updated_at | Unknown |  |
| weight | Unknown |  |

### shipment_rate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | FK |
| billing_type | Unknown |  |
| carrier | Unknown |  |
| carrier_account_id | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| delivery_date | Unknown |  |
| delivery_date_guaranteed | Unknown |  |
| delivery_days | Unknown |  |
| est_delivery_days | Unknown |  |
| list_currency | Unknown |  |
| list_rate | Unknown |  |
| mode | Unknown |  |
| object | Unknown |  |
| rate | Unknown |  |
| retail_currency | Unknown |  |
| retail_rate | Unknown |  |
| service | Unknown |  |
| updated_at | Unknown |  |

### shipment_fee

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| shipment_id | Unknown | FK |
| amount | Unknown |  |
| charged | Unknown |  |
| object | Unknown |  |
| refunded | Unknown |  |
| type | Unknown |  |

### shipment_message

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| shipment_id | Unknown | FK |
| carrier | Unknown |  |
| carrier_account_id | Unknown |  |
| message | Unknown |  |
| type | Unknown |  |

### shipment_parcel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | FK |
| created_at | Unknown |  |
| height | Unknown |  |
| length | Unknown |  |
| mode | Unknown |  |
| object | Unknown |  |
| predefined_package | Unknown |  |
| updated_at | Unknown |  |
| weight | Unknown |  |
| width | Unknown |  |

### shipment_custom_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_custom_info_id | Unknown | FK |
| code | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| description | Unknown |  |
| eccn | Unknown |  |
| hs_tariff_number | Unknown |  |
| manufacturer | Unknown |  |
| mode | Unknown |  |
| object | Unknown |  |
| origin_country | Unknown |  |
| printed_commodity_identifier | Unknown |  |
| quantity | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |
| weight | Unknown |  |

### shipment_custom_info

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | FK |
| contents_explanation | Unknown |  |
| contents_type | Unknown |  |
| created_at | Unknown |  |
| customs_certify | Unknown |  |
| customs_signer | Unknown |  |
| declaration | Unknown |  |
| eel_pfc | Unknown |  |
| mode | Unknown |  |
| non_delivery_option | Unknown |  |
| object | Unknown |  |
| restriction_comments | Unknown |  |
| restriction_type | Unknown |  |
| updated_at | Unknown |  |

### shipment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| batch_id | Unknown | FK |
| buyer_address_id | Unknown | FK |
| from_address_id | Unknown | FK |
| return_address_id | Unknown | FK |
| scan_form_id | Unknown | FK |
| selected_rate_id | Unknown | FK |
| to_address_id | Unknown | FK |
| tracker_id | Unknown | FK |
| created_at | Unknown |  |
| forms | Json |  |
| insurance | Unknown |  |
| is_return | Unknown |  |
| mode | Unknown |  |
| object | Unknown |  |
| postage_abel_date | Unknown |  |
| postage_created_at | Unknown |  |
| postage_date_advance | Unknown |  |
| postage_id | Unknown |  |
| postage_integrated_form | Unknown |  |
| postage_label_epl_2_url | Unknown |  |
| postage_label_file | Unknown |  |
| postage_label_file_type | Unknown |  |
| postage_label_pdf_url | Unknown |  |
| postage_label_resolution | Unknown |  |
| postage_label_size | Unknown |  |
| postage_label_type | Unknown |  |
| postage_label_url | Unknown |  |
| postage_label_zpl_url | Unknown |  |
| postage_object | Unknown |  |
| postage_updated_at | Unknown |  |
| refund_status | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |
| usps_zone | Unknown |  |
| option_** |  |  |

### shipment_invoice_report

| Column | Type | Keys |
| --- | --- | --- |
| shipment_id | Unknown | PK, FK |
| adjustment_amount | Unknown |  |
| adjustment_reason | Unknown |  |
| captured_currency | Unknown |  |
| captured_height | Unknown |  |
| captured_length | Unknown |  |
| captured_package | Unknown |  |
| captured_service | Unknown |  |
| captured_weight | Unknown |  |
| captured_width | Unknown |  |
| carrier | Unknown |  |
| carrier_account_id | Unknown |  |
| carrier_invoice_id | Unknown |  |
| claimed_height | Unknown |  |
| claimed_length | Unknown |  |
| claimed_package | Unknown |  |
| claimed_service | Unknown |  |
| claimed_weight | Unknown |  |
| claimed_width | Unknown |  |
| clawback_payment_log | Unknown |  |
| final_invoice_amount | Unknown |  |
| initially_paid_amount | Unknown |  |
| initially_paid_payment_log | Unknown |  |
| invoice_date | Unknown |  |
| invoice_payment_log | Unknown |  |
| label_date | Unknown |  |
| package_dispute_id | Unknown |  |
| quoted_amount | Unknown |  |
| quoted_currency | Unknown |  |
| refund_payment_log | Unknown |  |
| status | Unknown |  |
| tracking_code | Unknown |  |
| user_id | Unknown |  |
| user_parent_id | Unknown |  |

### cash_flow_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| bank_account_refund | Unknown |  |
| bank_debits | Unknown |  |
| carbon_offset_fees | Unknown |  |
| credit_card_debits | Unknown |  |
| credit_card_fees | Unknown |  |
| credit_card_refund | Unknown |  |
| date | Unknown |  |
| dispute_reinstatements | Unknown |  |
| dispute_withdrawals | Unknown |  |
| end_balance | Unknown |  |
| insurance_fees | Unknown |  |
| invoice_adjustment_fees | Unknown |  |
| label_fees | Unknown |  |
| manual_credits | Unknown |  |
| manual_debits | Unknown |  |
| payment_failure_deduction | Unknown |  |
| postage_fees | Unknown |  |
| refunds | Unknown |  |
| start_balance | Unknown |  |
| total_fees | Unknown |  |
| tracker_fees | Unknown |  |
| user_id | Unknown |  |
| utc_offset | Unknown |  |
| wire_transfer_debits | Unknown |  |

### payment_log_report

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | FK |
| amount | Unknown |  |
| balance | Unknown |  |
| charge_type | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| source_type | Unknown |  |
| status | Unknown |  |
| target_type | Unknown |  |

## Relationships

- insurance(from_address_id) → address(id)
- insurance(to_address_id) → address(id)
- insurance(shipment_id) → shipment(id)
- insurance(tracking_code) → tracker(tracking_code)
- address_error(address_id) → address(id)
- scan_form_tracking_code(scan_form_id) → scan_form(id)
- scan_form(address_id) → address(id)
- scan_form(batch_id) → batch(id)
- batch_shipment(batch_id) → batch(id)
- batch(scan_form_id) → scan_form(id)
- tracker_detail(tracker_id) → tracker(id)
- tracker(shipment_id) → shipment(id)
- shipment_rate(shipment_id) → shipment(id)
- shipment_fee(shipment_id) → shipment(id)
- shipment_message(shipment_id) → shipment(id)
- shipment_parcel(shipment_id) → shipment(id)
- shipment_custom_item(shipment_custom_info_id) → shipment_custom_info(id)
- shipment_custom_info(shipment_id) → shipment(id)
- shipment(buyer_address_id) → address(id)
- shipment(selected_rate_id) → shipment_rate(id)
- shipment(return_address_id) → address(id)
- shipment(scan_form_id) → scan_form(id)
- shipment(from_address_id) → address(id)
- shipment(to_address_id) → address(id)
- shipment(batch_id) → batch(id)
- shipment(tracker_id) → tracker(id)
- shipment_invoice_report(shipment_id) → shipment(id)
- payment_log_report(shipment_id) → shipment(id)