FourKites

Explore the interactive ERD

Column	Type	Keys
`id`	Unknown	PK
`shipment_id`	Unknown	PKFK
`arrival_time`	Unknown
`city`	Unknown
`country`	Unknown
`customer_id`	Unknown
`customer_name`	Unknown
`departure_time`	Unknown
`external_address_id`	Unknown
`latitude`	Unknown
`longitude`	Unknown
`schedule_appointment_time`	Unknown
`schedule_appointment_window_end`	Unknown
`schedule_appointment_window_start`	Unknown
`schedule_want_time`	Unknown
`sequence`	Unknown
`state`	Unknown
`status`	Unknown
`stop_name`	Unknown
`stop_type`	Unknown
`timezone`	Unknown

Column	Type	Keys
`id`	Unknown	PK
`four_kites_eta`	Unknown
`identifiers_consignment_number`	Unknown
`identifiers_consignment_sequence`	Unknown
`identifiers_pro_number`	Unknown
`latest_location_latitude`	Unknown
`latest_location_longitude`	Unknown
`latest_location_name`	Unknown
`latest_location_timezone`	Unknown
`latest_location_updated_time`	Unknown
`load_number`	Unknown
`number_of_delivery_stop`	Unknown
`remaining_distance_in_meter`	Unknown
`scac`	Unknown
`stakeholder_carrier`	Unknown
`stakeholder_shipper`	Unknown
`stakeholder_third_party_logistics`	Unknown
`status`	Unknown
`timezone`	Unknown
`total_distance_in_meter`	Unknown