| 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 |