freight delivery table structure

freight delivery table structure#

An output table for the freight tours synthesized by CRISTAL, including their mode, volume, trip type, origin and destination

Table Structure#

Field

Type

NULL allowed

Default Value

Foreign key

Description

tour_id

INTEGER

NO

0

Freight tour identifier

leg_id

INTEGER

NO

0

Freight trip leg identifier within a tour

origin_loc_id

INTEGER

NO

0

The trip’s origin location (foreign key to the Location table)

destination_loc_id

INTEGER

NO

0

The trip’s destination location (foreign key to the Location table)

volume

INTEGER

NO

0

Shipment volume (units: lbs.)

is_e_commerce

INTEGER

NO

0

boolean flag - is this an e-commerce delivery?

pickup_trip

INTEGER

NO

0

boolean flag - is this a pick up trip?

OHD

INTEGER

NO

0

boolean flag - is this delivery performed in off hours?

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE Freight_Delivery (
    "tour_id"               INTEGER NOT NULL DEFAULT 0,
    "leg_id"                INTEGER NOT NULL DEFAULT 0,
    "origin_loc_id"         INTEGER NOT NULL DEFAULT 0,
    "destination_loc_id"    INTEGER NOT NULL DEFAULT 0,
    "volume"                INTEGER NOT NULL DEFAULT 0,
    "is_e_commerce"         INTEGER NOT NULL DEFAULT 0,
    "pickup_trip"           INTEGER NOT NULL DEFAULT 0,
    "OHD"                   INTEGER NOT NULL DEFAULT 0
);