Leg Definitions¶
The leg_defs database table stores static details about the legs in the simulation. Simulation
results at the leg level are stored in the leg_details table instead.
The leg_defs table is created by the
[create_table_leg_defs][passengersim.database.tables.create_table_leg_defs] function, which is
called in the [Simulation][passengersim.Simulation] initialization step, so it should be available
and populated for every simulation run.
Table Schema¶
Column |
Data Type |
Description |
|---|---|---|
leg_id |
INTEGER PRIMARY KEY |
Unique identifier for a given leg [1] |
flt_no |
INTEGER |
Flight number label for this leg |
carrier |
TEXT |
Name of carrier for this leg |
orig |
TEXT |
Origin (typically an airport code or similar) |
dest |
TEXT |
Destination (typically an airport code or similar) |
dep_time |
INTEGER |
|
arr_time |
INTEGER |
|
capacity |
INTEGER |
Number of seats on this leg |
distance |
FLOAT |
Distance from |