doc29_noise

Variable	Type	NOT NULL	Constraint
id	TEXT	✓
lateral_directivity	TEXT	✓	`Wing`, `Fuselage`, `Propeller`
start_of_roll_correction	TEXT	✓	`None`, `Jet`, `Turboprop`

Table Constraint	Details
PRIMARY KEY	id

doc29_noise_npd_data

Variable	Type	NOT NULL	Constraint
noise_id	TEXT	✓
operation	TEXT	✓	`Arrival`, `Departure`
noise_metric	TEXT	✓	`LAMAX`, `SEL`
thrust	REAL	✓
l_200_ft	REAL	✓
l_400_ft	REAL	✓
l_630_ft	REAL	✓
l_1000_ft	REAL	✓
l_2000_ft	REAL	✓
l_4000_ft	REAL	✓
l_6300_ft	REAL	✓
l_10000_ft	REAL	✓
l_16000_ft	REAL	✓
l_25000_ft	REAL	✓

Table Constraint	Details
PRIMARY KEY	noise_id, operation, noise_metric, thrust
FOREIGN KEY	noise_id from doc29_noise

Variable	Type	NOT NULL	Constraint
noise_id	TEXT	✓
operation	TEXT	✓	`Arrival`, `Departure`
l_50_hz	REAL	✓
l_63_hz	REAL	✓
l_80_hz	REAL	✓
l_100_hz	REAL	✓
l_125_hz	REAL	✓
l_160_hz	REAL	✓
l_200_hz	REAL	✓
l_250_hz	REAL	✓
l_315_hz	REAL	✓
l_400_hz	REAL	✓
l_500_hz	REAL	✓
l_630_hz	REAL	✓
l_800_hz	REAL	✓
l_1000_hz	REAL	✓
l_1250_hz	REAL	✓
l_1600_hz	REAL	✓
l_2000_hz	REAL	✓
l_2500_hz	REAL	✓
l_3150_hz	REAL	✓
l_4000_hz	REAL	✓
l_5000_hz	REAL	✓
l_6300_hz	REAL	✓
l_8000_hz	REAL	✓
l_10000_hz	REAL	✓

Table Constraint	Details
PRIMARY KEY	noise_id, operation
FOREIGN KEY	noise_id from doc29_noise