Airports | |
---|---|
Column name | Key Relationship |
Name | |
Country | |
tla (three letter acronym) | Primary Key, Used as a foreign key in flights table |
Carriers | |
---|---|
Column name | Key Relationship |
acronym | Primary Key |
name | |
callsign | |
country |
Flights | |
---|---|
Column name | Key Relationship |
date | date type |
departuretime | time without timezone |
arrivaltime | time without timezone |
carrier/td> | |
flightnum | |
arrivaldelay | |
departuredelay | |
origin | references airports tla |
destination | references airports tla |
distance | |
cancelled | boolean |