port share table structure

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