port share table structure#

An output table for the shipment leg that use airport and railport This table is mainly used for analyzing and checking port share

Table Structure#

Field	Type	NULL allowed	Default Value	Foreign key	Description
port	INTEGER	NO			The identifier of the port
shipment	INTEGER	NO			The unique identifier of this shipment
leg	INTEGER	NO			The identifier of the internal trip leg for the shipment
tons	NUMERIC	NO			The shipment size of this shipment leg
mode	INTEGER	NO			The freight mode used for this shipment leg

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE Port_Share (
    "port"           INTEGER NOT NULL,
    "shipment"       INTEGER NOT NULL,
    "leg"            INTEGER NOT NULL,
    "tons"           NUMERIC NOT NULL,
    "mode"           INTEGER NOT NULL
);