emissions_run

emissions_run

Variable	Type	NOT NULL	Constraint
scenario_id	TEXT	✓
performance_run_id	TEXT	✓
id	TEXT	✓
emissions_model	TEXT	✓	None, Boeing Fuel Flow Method 2
save_segment_results	INTEGER	✓	0, 1

Table Constraint	Details
PRIMARY KEY	scenario_id, performance_run_id, id
FOREIGN KEY	scenario_id, performance_run_id from performance_run

fuel_emissions_run_output

Variable	Type	NOT NULL	Constraint
scenario_id	TEXT	✓
performance_run_id	TEXT	✓
emissions_run_id	TEXT	✓
fuel	REAL	✓
hc	REAL	✓
co	REAL	✓
nox	REAL	✓

Table Constraint	Details
PRIMARY KEY	scenario_id, performance_run_id, emissions_run_id
FOREIGN KEY	scenario_id, performance_run_id, emissions_run_id from emissions_run

emissions_run_output_operations

Variable	Type	NOT NULL	Constraint
scenario_id	TEXT	✓
performance_run_id	TEXT	✓
emissions_run_id	TEXT	✓
operation_id	TEXT	✓
operation	TEXT	✓
operation_type	TEXT	✓
fuel	REAL	✓
hc	REAL	✓
co	REAL	✓
nox	REAL	✓

Table Constraint	Details
PRIMARY KEY	scenario_id, performance_run_id, emissions_run_id, operation_id, operation, operation_type
FOREIGN KEY	scenario_id, performance_run_id, emissions_run_id from emissions_run_output
FOREIGN KEY	scenario_id, performance_run_id, operation_id, operation, operation_type from performance_run_output

emissions_run_output_segments

Variable	Type	NOT NULL	Constraint
scenario_id	TEXT	✓
performance_run_id	TEXT	✓
emissions_run_id	TEXT	✓
operation_id	TEXT	✓
operation	TEXT	✓
operation_type	TEXT	✓
segment_number	INTEGER	✓
fuel	REAL	✓
hc	REAL	✓
co	REAL	✓
nox	REAL	✓

Table Constraint	Details
PRIMARY KEY	scenario_id, performance_run_id, emissions_run_id, operation_id, operation, operation_type, segment_number
FOREIGN KEY	scenario_id, performance_run_id, emissions_run_id, operation_id, operation, operation_type from emissions_run_output_operation