logo
ExamplesEditorPricingDocs
37.1kSign in

International freight forwarding database schema

A SQL Server schema for international freight: bookings and incoterms, shipments and container consolidation, multi-leg sea, air and road journeys, carrier rate contracts, customs declarations, milestone events, documents, charges and invoicing.

Freight Forwarding ER diagram

International freight forwarding database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 clients idBIGINT client_codeVARCHAR legal_nameNVARCHAR country_codeCHAR tax_identifierVARCHAR default_incotermCHAR credit_limit_minorBIGINT currency_codeCHAR is_activeBIT created_atDATETIME2 carriers idBIGINT scac_codeVARCHAR iata_codeCHAR nameNVARCHAR modeVARCHAR edi_partner_idVARCHAR is_activeBIT rate_contracts idBIGINT carrier_idBIGINT contract_numberVARCHAR modeVARCHAR origin_locodeVARCHAR destination_locodeVARCHAR equipment_typeVARCHAR rate_basisVARCHAR rate_minorBIGINT currency_codeCHAR free_daysSMALLINT valid_fromDATE valid_toDATE bookings idBIGINT public_referenceUNIQUEIDEN… booking_numberVARCHAR client_idBIGINT incotermCHAR incoterm_placeNVARCHAR modeVARCHAR service_typeVARCHAR origin_locodeVARCHAR destination_locodeVARCHAR cargo_ready_dateDATE required_delivery…DATE statusVARCHAR created_atDATETIME2 shipments idBIGINT booking_idBIGINT shipment_numberVARCHAR master_document_n…VARCHAR house_document_nu…VARCHAR shipper_nameNVARCHAR consignee_nameNVARCHAR gross_weight_kgDECIMAL volume_cbmDECIMAL package_countINTEGER goods_descriptionNVARCHAR is_hazardousBIT statusVARCHAR created_atDATETIME2 containers idBIGINT container_numberVARCHAR equipment_typeVARCHAR seal_numberVARCHAR tare_weight_kgDECIMAL is_shipper_ownedBIT reefer_setpoint_cDECIMAL shipment_containers shipment_idBIGINT container_idBIGINT package_countINTEGER gross_weight_kgDECIMAL volume_cbmDECIMAL stuffed_atDATETIME2 shipment_legs idBIGINT shipment_idBIGINT leg_sequenceSMALLINT modeVARCHAR carrier_idBIGINT origin_locodeVARCHAR destination_locodeVARCHAR vessel_or_flightVARCHAR voyage_numberVARCHAR scheduled_departu…DATETIMEOF… scheduled_arrivalDATETIMEOF… actual_departureDATETIMEOF… actual_arrivalDATETIMEOF… leg_events idBIGINT leg_idBIGINT event_codeVARCHAR event_timeDATETIMEOF… location_locodeVARCHAR sourceVARCHAR remarksNVARCHAR recorded_atDATETIME2 customs_declarations idBIGINT shipment_idBIGINT declaration_typeVARCHAR country_codeCHAR customs_office_co…VARCHAR declaration_refer…VARCHAR hs_codeVARCHAR customs_value_min…BIGINT duty_minorBIGINT vat_minorBIGINT currency_codeCHAR statusVARCHAR submitted_atDATETIME2 cleared_atDATETIME2 documents idBIGINT shipment_idBIGINT document_typeVARCHAR document_numberVARCHAR storage_keyVARCHAR content_typeVARCHAR file_hashBINARY is_originalBIT issued_atDATETIME2 released_atDATETIME2 charges idBIGINT shipment_idBIGINT leg_idBIGINT invoice_idBIGINT charge_codeVARCHAR charge_basisVARCHAR quantityDECIMAL cost_minorBIGINT sell_minorBIGINT currency_codeCHAR exchange_rateDECIMAL is_billableBIT invoices idBIGINT client_idBIGINT booking_idBIGINT invoice_numberVARCHAR statusVARCHAR issued_onDATE due_onDATE subtotal_minorBIGINT tax_minorBIGINT total_minorBIGINT currency_codeCHAR

Related database schemas

PostgreSQL
Logistics

Vehicle fleet management database schema

How a vehicle fleet is modelled: vehicles and drivers, licence entitlements with expiry, assignment history, downsampled telematics and fault codes, maintenance due by mileage or date, work orders and parts, fuel, inspections and incidents.

PostgreSQL
Logistics

Last-mile delivery & route planning database schema

Delivery operations modelled properly: depots, drivers and shifts, vehicle capacity constraints, orders with time windows, routes planned per day, stops in planned and actual sequence, geofenced arrivals, failed attempts, proof of delivery and re-sequencing history.

PostgreSQL
Logistics

Parcel tracking and courier network schema

A courier network schema built on an append-only scan log: shipments and the packages inside them, hubs and planned routes, scan events as the only truth, derived status, delivery attempts, exceptions, proof of delivery, and promised versus actual delivery.

PostgreSQL
Logistics

Returns & RMA (reverse logistics) database schema

How returns are actually modelled: RMA authorisations and eligibility windows, versioned policies, return reasons, inbound inspection and grading, dispositions from restock to scrap, refunds against exchanges and store credit, labels, restocking fees and return-abuse signals.