operations

operations_flights

Variable	Type	NOT NULL	Constraint
id	TEXT	✓
airport_id	TEXT	✓
runway_id	TEXT	✓
operation	TEXT	✓
route_id	TEXT	✓
time	TEXT	✓	yyyy-mm-dd HH:MM:SS
count	REAL	✓	≥ 0
fleet_id	TEXT	✓
weight	REAL	✓	> 0

Table Constraint	Details
PRIMARY KEY	id, operation
FOREIGN KEY	airport_id, runway_id, operation, route_id from airports_routes
FOREIGN KEY	fleet_id from fleet

operations_flights_arrival

Variable	Type	NOT NULL	Constraint
operation_id	TEXT	✓
operation	TEXT	✓
doc29_profile_id	TEXT

Table Constraint	Details
PRIMARY KEY	operation_id, operation
FOREIGN KEY	operation_id, operation from operations_flights

operations_flights_departure

Variable	Type	NOT NULL	Constraint
operation_id	TEXT	✓
operation	TEXT	✓
doc29_profile_id	TEXT
thrust_percentage_takeoff	REAL	✓	0.5 ≤ x ≤ 1
thrust_percentage_climb	REAL	✓	0.5 ≤ x ≤ 1

Table Constraint	Details
PRIMARY KEY	operation_id, operation
FOREIGN KEY	operation_id, operation from operations_flights

operations_tracks_4d

Variable	Type	NOT NULL	Constraint
id	TEXT	✓
operation	TEXT	✓	Arrival, Departure
time	TEXT	✓	yyyy-mm-dd HH:MM:SS
count	REAL	✓	≥ 0
fleet_id	TEXT	✓

Table Constraint	Details
PRIMARY KEY	id, operation
FOREIGN KEY	fleet_id from fleet

operations_tracks_4d_points

Variable	Type	NOT NULL	Constraint
operation_id	TEXT	✓
operation	TEXT	✓	Arrival, Departure
point_number	INTEGER	✓	≥ 1
flight_phase	TEXT	✓	Approach, Landing Roll, Takeoff Roll, Initial Climb, Climb
cumulative_ground_distance	REAL	✓
longitude	REAL	✓	-180 ≤ x ≤ 180
latitude	REAL	✓	-90 ≤ x ≤ 90
altitude_msl	REAL	✓
true_airspeed	REAL	✓	≥ 0
groundspeed	REAL	✓	≥ 0
corrected_net_thrust_per_engine	REAL	✓
bank_angle	REAL	✓	-90 ≤ x ≤ 90
fuel_flow_per_engine	REAL	✓	≥ 0

Table Constraint	Details
PRIMARY KEY	operation_id, operation, point_number
FOREIGN KEY	operation_id, operation from operation_tracks_4d