table aviation_occurrence_airplane
General information
Table: aviation_occurrence_airplane
Description: aviation occurrence/airplane
Type: Relation
Rows: 18,968
columns: 13
Data: 176,131
columns
field
description
Type
Unit
associated date
foreign table
id
Unique identifier
Integer
id_airplane
airplane
foreign key
airplane
id_aviation_occurrence
aviation occurrence
foreign key
accident
id_departure_airport
departure airport
foreign key
airport
id_destination_airport
destination airport
foreign key
airport
id_operator
operator
foreign key
airline
crew_fatalities
crew fatalities
Integer
crew_number
crew number
Integer
date_first_flight
date First flight
Date
flight_number
flight number
Text
passengers_fatalities
passengers fatalities
Integer
passengers_number
passengers number
Integer
registration
registration
Text
Relations
description
related table
relationship table
Table in which FK is located