Home Logistics & DeliveryFreight Forwarding

Freight Forwarding

International freight forwarding with multi-modal transport, customs declarations, and container tracking

SchemaVerse

Logistics & DeliveryPostgreSQLLogisticsNormalized

freight-forwarding.dbml

12 tables|21 relations

shipping_agents

idinteger

agent_codevarchar(20)

*UQ

company_namevarchar(255)

contact_namevarchar(200)

emailvarchar(255)

phonevarchar(30)

addresstext

countryvarchar(100)

license_numbervarchar(100)

is_activeboolean

created_attimestamp

updated_attimestamp

ports

idinteger

locodevarchar(10)

*UQ

namevarchar(255)

port_typevarchar(20)

cityvarchar(100)

countryvarchar(100)

country_codevarchar(3)

latdecimal(10,7)

lngdecimal(10,7)

timezonevarchar(50)

is_activeboolean

created_attimestamp

transport_modes

idinteger

namevarchar(50)

*UQ

descriptiontext

typical_transit_daysinteger

created_attimestamp

container_types

idinteger

iso_codevarchar(10)

*UQ

namevarchar(100)

length_ftinteger

max_payload_kginteger

teu_equivalentdecimal(4,2)

is_reeferboolean

is_open_topboolean

is_flat_rackboolean

created_attimestamp

containers

idinteger

container_type_idinteger

FK*

container_numbervarchar(11)

*UQ

owner_namevarchar(255)

tare_weight_kgdecimal(10,2)

max_gross_weight_kgdecimal(10,2)

statusvarchar(20)

created_attimestamp

updated_attimestamp

shipments

idinteger

shipment_numbervarchar(30)

*UQ

origin_agent_idinteger

FK*

destination_agent_idinteger

shipper_namevarchar(255)

shipper_addresstext

consignee_namevarchar(255)

consignee_addresstext

notify_party_namevarchar(255)

origin_port_idinteger

FK*

destination_port_idinteger

FK*

incotermvarchar(10)

commodity_descriptiontext

hs_codevarchar(20)

total_gross_weight_kgdecimal(12,3)

total_volume_cbmdecimal(10,3)

declared_valuedecimal(15,2)

declared_currencyvarchar(3)

statusvarchar(30)

estimated_departure_attimestamp

actual_departure_attimestamp

estimated_arrival_attimestamp

actual_arrival_attimestamp

special_handlingtext

created_attimestamp

updated_attimestamp

bills_of_lading

idinteger

shipment_idinteger

FK*

bl_typevarchar(10)

bl_numbervarchar(50)

*UQ

carrier_namevarchar(255)

vessel_namevarchar(255)

voyage_numbervarchar(50)

port_of_loading_idinteger

FK*

port_of_discharge_idinteger

FK*

place_of_receiptvarchar(255)

place_of_deliveryvarchar(255)

issued_atdate

issue_placevarchar(255)

freight_paid_atvarchar(20)

is_originalboolean

statusvarchar(20)

created_attimestamp

transport_legs

idinteger

shipment_idinteger

FK*

transport_mode_idinteger

FK*

sequence_orderinteger

origin_port_idinteger

FK*

destination_port_idinteger

FK*

carrier_namevarchar(255)

conveyance_refvarchar(100)

departure_attimestamp

arrival_attimestamp

statusvarchar(20)

notestext

created_attimestamp

updated_attimestamp

customs_declarations

idinteger

shipment_idinteger

FK*

declaration_typevarchar(20)

declaration_numbervarchar(50)

filing_countryvarchar(3)

port_idinteger

FK*

declared_valuedecimal(15,2)

declared_currencyvarchar(3)

duties_amountdecimal(12,2)

taxes_amountdecimal(12,2)

statusvarchar(30)

filed_attimestamp

cleared_attimestamp

customs_officervarchar(200)

examination_notestext

created_attimestamp

updated_attimestamp

freight_charges

idinteger

shipment_idinteger

FK*

transport_leg_idinteger

charge_typevarchar(50)

descriptionvarchar(255)

quantitydecimal(10,3)

unitvarchar(20)

unit_ratedecimal(12,4)

amountdecimal(12,2)

currencyvarchar(3)

is_prepaidboolean

created_attimestamp

tracking_events

idinteger

shipment_idinteger

FK*

transport_leg_idinteger

container_idinteger

event_codevarchar(10)

event_descriptionvarchar(255)

port_idinteger

location_namevarchar(255)

event_attimestamp

sourcevarchar(30)

created_attimestamp

documents

idinteger

shipment_idinteger

FK*

document_typevarchar(50)

titlevarchar(255)

file_urlvarchar(500)

file_size_bytesinteger

issued_atdate

issued_byvarchar(255)

is_verifiedboolean

verified_attimestamp

created_attimestamp

React Flow

About this Schema

Overview

International freight forwarding schema for logistics companies managing cross-border shipments. Models multi-modal transport legs, container tracking, customs clearance, and bills of lading.

Key Design Decisions

Multi-modal Transport: Sea, air, road, and rail legs within a single shipment
Container Tracking: Container-level visibility with seal numbers and weight
Customs Clearance: Declaration documents with HS codes and duty calculations
Bill of Lading: Legal document generation with shipper/consignee details

Tables

10-14 tables covering shipments, transport legs, transport modes, containers, container types, customs declarations, bills of lading, freight charges, shipping agents, ports, tracking events, and documents.

Comments

Loading comments...