Demand Detail¶

The demand_detail database table stores details about the results of the simulation at the demand level.

The table is created by the [create_table_demand_detail] [passengersim.database.tables.create_table_demand_detail] function, and (potentially) populated during a simulation run. To be populated with data, one of the follow flags must be set on [Config.db.write_items][passengersim.config.DatabaseConfig.write_items]:

“demand”: The table will be populated at each DCP during the simulation.
“demand_final”: The table will be populated only at the end of each sample (i.e. DCP 0) during the simulation

Table Schema¶

Column	Data Type	Description
scenario	VARCHAR(20) NOT NULL	Scenario name [1]
iteration	INT NOT NULL
trial	INT NOT NULL
sample	INT NOT NULL	Sample number within trial
days_prior	INT NOT NULL	Days before departure
segment	VARCHAR(10) NOT NULL	Customer segment, typically business or leisure
orig	VARCHAR(10) NOT NULL	Origin (typically an airport code or similar)
dest	VARCHAR(10) NOT NULL	Destination (typically an airport code or similar)
updated_at	DATETIME NOT NULL	Time each row was written to the database
sample_demand	FLOAT
sold	INT	Number of customers in this demand bucket who bought something
no_go	INT	Number of customers in this demand bucket who bought nothing
revenue	FLOAT	Revenue attributable to these customers