Skip to main content
`Ctrl`+`K`

# trips schedule table structure

The trips_schedule table holds information on the sequence of stops of a trip.

trip_id is an unique identifier of a trip

seq identifies the sequence of the stops for a trip

arrival identifies the arrival time at the stop

departure identifies the departure time at the stop

Field | Type | NULL allowed | Default Value
--- | --- | --- | ---
trip_id* | INTEGER | NO |
seq | INTEGER | NO |
arrival | INTEGER | NO |
departure | INTEGER | NO |

(* - Primary key)

The SQL statement for table and index creation is below.

    CREATE TABLE IF NOT EXISTS trips_schedule (
         trip_id   INTEGER  NOT NULL,
         seq       INTEGER  NOT NULL,
         arrival   INTEGER  NOT NULL,
         departure INTEGER  NOT NULL,
         PRIMARY KEY(trip_id,"seq"),
         FOREIGN KEY(trip_id) REFERENCES trips(trip_id) deferrable initially deferred
    );