toll pricing table structure

toll pricing table structure#

Toll pricing table provides the ability to set time-varying tolls on a given link/direction which are differentiated by time of day and vehicle class.

Table Structure#

Field

Type

NULL allowed

Default Value

Foreign key

Description

link

INTEGER

NO

Link(link)

link identifier of the link that is to be tolled

dir

INTEGER

NO

0

direction of link (AB or BA, as 0 or 1) that is to be tolled

start_time

INTEGER

NO

0

Entry start time in seconds from when toll is active

end_time

INTEGER

NO

0

Entry end time in seconds after which toll specified is not active

price

REAL

NO

0

Toll price paid by passenger vehicles

md_price

REAL

NO

0

Toll price paid by medium duty vehicles (can be null, default value assumed as 1.5x price and can be customized in the scenario file)

hd_price

REAL

NO

0

Toll price paid by heavy duty vehicles (can be null, default value assumed as 2x price and can be customized in the scenario file)

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE IF NOT EXISTS Toll_Pricing(
    link            INTEGER NOT NULL,
    dir             INTEGER NOT NULL DEFAULT 0,
    start_time      INTEGER NOT NULL DEFAULT 0,
    end_time        INTEGER NOT NULL DEFAULT 0,
    price           REAL    NOT NULL DEFAULT 0,
    md_price        REAL    NOT NULL DEFAULT 0,
    hd_price        REAL    NOT NULL DEFAULT 0,
    CONSTRAINT "link_fk" FOREIGN KEY("link") REFERENCES "Link"("link") DEFERRABLE INITIALLY DEFERRED -- check
    CHECK("dir" >= 0),
    CHECK("dir" >= 0),
    CHECK("price" >= 0),
    CHECK(TYPEOF("dir") == 'integer')
);