# ReBound Returns schema ERD

Table and field reference for the Fivetran ReBound Returns connector.

## Table & Field Reference

### return_item_reason

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_id | Unknown | PK, FK |
| return_item_sku_code | Unknown | PK, FK |
| action | Unknown |  |
| additional_title | Unknown |  |
| additional_value | Unknown |  |
| reason | Unknown |  |
| wish | Unknown |  |

### return_item

| Column | Type | Keys |
| --- | --- | --- |
| sku_code | Unknown | PK |
| return_id | Unknown | PK, FK |
| cost_price | Unknown |  |
| cost_price_currency | Unknown |  |
| country_code | Unknown |  |
| dangerous_goods | Unknown |  |
| days_for_return | Unknown |  |
| dimensions_uom | Unknown |  |
| export_awb | Unknown |  |
| export_carrier_name | Unknown |  |
| export_date | Unknown |  |
| final_dest_addr_1 | Unknown |  |
| final_dest_addr_2 | Unknown |  |
| final_dest_addr_3 | Unknown |  |
| final_dest_city | Unknown |  |
| final_dest_company_name | Unknown |  |
| final_dest_country | Unknown |  |
| final_dest_id | Unknown |  |
| final_dest_name | Unknown |  |
| final_dest_neighborhood | Unknown |  |
| final_dest_state | Unknown |  |
| final_dest_suburb | Unknown |  |
| final_dest_zip | Unknown |  |
| final_disposition | Unknown |  |
| height | Unknown |  |
| hs_code | Unknown |  |
| img_path | Unknown |  |
| length | Unknown |  |
| non_returnable | Unknown |  |
| non_returnable_message | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| sku_desc | Unknown |  |
| tracking | Unknown |  |
| verification_entity | Unknown |  |
| weight | Unknown |  |
| weight_uom | Unknown |  |
| width | Unknown |  |
| custom_** |  |  |

### return

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| tracking | Unknown | FK |
| addr_1 | Unknown |  |
| addr_2 | Unknown |  |
| addr_3 | Unknown |  |
| barcode_number | Unknown |  |
| carrier | Unknown |  |
| city | Unknown |  |
| company_name | Unknown |  |
| country | Unknown |  |
| current_tracking_status | Unknown |  |
| customer_name | Unknown |  |
| date_added | Unknown |  |
| display_id | Unknown |  |
| email | Unknown |  |
| external_id | Unknown |  |
| final_dest_addr_1 | Unknown |  |
| final_dest_addr_2 | Unknown |  |
| final_dest_addr_3 | Unknown |  |
| final_dest_city | Unknown |  |
| final_dest_company_name | Unknown |  |
| final_dest_country | Unknown |  |
| final_dest_id | Unknown |  |
| final_dest_name | Unknown |  |
| final_dest_state | Unknown |  |
| final_dest_zip | Unknown |  |
| label | Unknown |  |
| order_reference | Unknown |  |
| phone | Unknown |  |
| state | Unknown |  |
| tracking_last_update | Unknown |  |
| verification_entity | Unknown |  |
| zip | Unknown |  |
| custom_** |  |  |

### tracking_event

| Column | Type | Keys |
| --- | --- | --- |
| dt | Unknown | PK |
| tracking_number | Unknown | PK, FK |
| location_city | Unknown |  |
| location_country | Unknown |  |
| location_state | Unknown |  |
| status | Unknown |  |

### tracking

| Column | Type | Keys |
| --- | --- | --- |
| tracking_number | Unknown | PK |
| carrier_name | Unknown |  |
| external_id | Unknown |  |
| order_reference | Unknown |  |
| pallet_number | Unknown |  |
| service_id | Unknown |  |
| source_country | Unknown |  |

## Relationships

- return_item_reason(return_id) → return_item(return_id)
- return_item_reason(return_item_sku_code) → return_item(sku_code)
- return_item(return_id) → return(id)
- return(tracking) → tracking(tracking_number)
- tracking_event(tracking_number) → tracking(tracking_number)