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
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
);