# DSV schema ERD

Table and field reference for the Fivetran DSV connector.

## Table & Field Reference

### shipment

| Column | Type | Keys |
| --- | --- | --- |
| shipment_id | Unknown | PK |
| actual_delivery | Unknown |  |
| actual_pickup | Unknown |  |
| barcode | Unknown |  |
| barcode_latest_event | Unknown |  |
| booking_id | Unknown |  |
| from_date | Unknown |  |
| from_date_end | Unknown |  |
| from_date_start | Unknown |  |
| from_date_type | Unknown |  |
| goods_total_colli | Unknown |  |
| goods_total_load_meter | Unknown |  |
| goods_total_volume | Unknown |  |
| goods_total_weight | Unknown |  |
| main_tms_shipment_id | Unknown |  |
| mode_of_transport | Unknown |  |
| requested_delivery | Unknown |  |
| requested_pickup | Unknown |  |
| status | Unknown |  |
| to_date | Unknown |  |
| to_date_end | Unknown |  |
| to_date_start | Unknown |  |
| to_date_type | Unknown |  |

### events

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| cargo_availability | Unknown |  |
| cargo_cut_off | Unknown |  |
| code | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| groups | Unknown |  |
| location_country_code | Unknown |  |
| location_place | Unknown |  |
| location_unlocode | Unknown |  |
| transport_mode | Unknown |  |
| type | Unknown |  |
| type_value | Unknown |  |
| vessel_name | Unknown |  |
| voyage_flight_no | Unknown |  |
| voyage_id | Unknown |  |

### dangerous_package

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| package_index | Unknown | FK |
| shipment_id | Unknown | FK |
| class_name | Unknown |  |
| empty | Unknown |  |
| flash_point | Unknown |  |
| gross_quantity | Unknown |  |
| gross_quantity_unit | Unknown |  |
| limited_quantity | Unknown |  |
| marine_pollutant | Unknown |  |
| net_quantity | Unknown |  |
| net_quantity_unit | Unknown |  |
| package_count | Unknown |  |
| packing_group | Unknown |  |
| packing_kind | Unknown |  |
| proper_shipping_name | Unknown |  |
| sub_risk | Unknown |  |
| technical_name | Unknown |  |
| technical_name_national | Unknown |  |
| temperature_from | Unknown |  |
| temperature_to | Unknown |  |
| tunnel_code | Unknown |  |
| type | Unknown |  |
| un_code | Unknown |  |

### package_reference

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| package_index | Unknown | FK |
| qualifier | Unknown |  |
| reference | Unknown |  |

### package

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| cargo_aircraft_only | Unknown |  |
| container_no | Unknown |  |
| description | Unknown |  |
| goods_type | Unknown |  |
| gross_weight | Unknown |  |
| height | Unknown |  |
| height_uom | Unknown |  |
| is_dangerous | Unknown |  |
| length | Unknown |  |
| length_uom | Unknown |  |
| loading_meters | Unknown |  |
| net_weight | Unknown |  |
| package_type | Unknown |  |
| pallet_space | Unknown |  |
| quantity | Unknown |  |
| shipping_mark | Unknown |  |
| stackable | Json |  |
| temperature_controlled | Unknown |  |
| temperature_max | Unknown |  |
| temperature_min | Unknown |  |
| total_volume | Unknown |  |
| total_weight | Unknown |  |
| tracking_number | Json |  |
| volume_uom | Unknown |  |
| width | Unknown |  |
| width_uom | Unknown |  |

### product_container

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| genset | Unknown |  |
| ref | Unknown |  |
| temp | Unknown |  |
| type | Unknown |  |

### container

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| container_number | Unknown |  |
| container_type | Unknown |  |
| seal_number | Unknown |  |

### issue

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| date | Unknown |  |
| note | Unknown |  |
| party_code | Unknown |  |
| party_description | Unknown |  |
| point_code | Unknown |  |
| point_description | Unknown |  |
| reason_code | Unknown |  |
| reason_description | Unknown |  |
| resolved | Unknown |  |
| type_code | Unknown |  |
| type_description | Unknown |  |

### proof_of_delivery

| Column | Type | Keys |
| --- | --- | --- |
| document_id | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| create_date | Unknown |  |
| document_type | Unknown |  |
| download_url | Unknown |  |
| file_name | Unknown |  |
| file_type | Unknown |  |
| type_description | Unknown |  |

### selected_service

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| code | Unknown |  |
| detail | Json |  |
| name | Unknown |  |

### reference

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| type | Unknown |  |
| value | Unknown |  |

### child_shipment_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| child_shipment_id | Unknown |  |

### shipment_detail

| Column | Type | Keys |
| --- | --- | --- |
| shipment_id | Unknown | PK, FK |
| booking_id | Unknown | FK |
| booked_by | Unknown |  |
| carrier_tracking_id | Unknown |  |
| customs_entry_number | Json |  |
| customs_removal_mode | Unknown |  |
| customs_shipped_onboard_date | Unknown |  |
| customs_status | Unknown |  |
| delivery_date | Unknown |  |
| delivery_end | Unknown |  |
| delivery_instruction | Unknown |  |
| delivery_start | Unknown |  |
| goods_description | Unknown |  |
| goods_gross_weight_uom | Unknown |  |
| goods_gross_weight_value | Unknown |  |
| goods_loading_meters_uom | Unknown |  |
| goods_loading_meters_value | Unknown |  |
| goods_quantity_uom | Unknown |  |
| goods_quantity_value | Unknown |  |
| goods_volume_uom | Unknown |  |
| goods_volume_value | Unknown |  |
| incoterms_code | Unknown |  |
| incoterms_location | Unknown |  |
| master_shipment_id | Unknown |  |
| pickup_date | Unknown |  |
| pickup_end | Unknown |  |
| pickup_instruction | Unknown |  |
| pickup_start | Unknown |  |
| product_bill_of_lading | Unknown |  |
| product_container_mode | Unknown |  |
| product_drop_off | Unknown |  |
| product_name | Unknown |  |
| public_shipment_id | Unknown |  |
| service_level_code | Unknown |  |
| service_level_description | Unknown |  |
| shipment_note | Unknown |  |
| status | Unknown |  |
| transport_awb | Unknown |  |
| transport_destination_code | Unknown |  |
| transport_destination_name | Unknown |  |
| transport_house_bill_number | Unknown |  |
| transport_master_bill_number | Unknown |  |
| transport_origin_code | Unknown |  |
| transport_origin_name | Unknown |  |

### address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| address_id | Unknown |  |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_line_3 | Unknown |  |
| address_type | Unknown |  |
| city | Unknown |  |
| company_name | Unknown |  |
| country_code | Unknown |  |
| email | Unknown |  |
| instruction | Unknown |  |
| mdm | Unknown |  |
| name | Unknown |  |
| role | Unknown |  |
| state | Unknown |  |
| telephone | Unknown |  |
| zip_code | Unknown |  |

## Relationships

- events(shipment_id) → shipment_detail(shipment_id)
- dangerous_package(package_index) → package(index)
- dangerous_package(shipment_id) → package(shipment_id)
- package_reference(package_index) → package(index)
- package_reference(shipment_id) → package(shipment_id)
- package(shipment_id) → shipment_detail(shipment_id)
- product_container(shipment_id) → shipment_detail(shipment_id)
- container(shipment_id) → shipment_detail(shipment_id)
- issue(shipment_id) → shipment_detail(shipment_id)
- proof_of_delivery(shipment_id) → shipment_detail(shipment_id)
- selected_service(shipment_id) → shipment_detail(shipment_id)
- reference(shipment_id) → shipment_detail(shipment_id)
- child_shipment_id(shipment_id) → shipment_detail(shipment_id)
- shipment_detail(booking_id) → shipment(shipment_id)
- shipment_detail(shipment_id) → shipment(shipment_id)
- address(shipment_id) → shipment_detail(shipment_id)