lab11
Tables (5)
aircraft
- Aircraft_ID — int(11) — Primary key — NOT NULL
- Aircraft — varchar(50)
- Description — varchar(50)
- Max_Gross_Weight — varchar(50)
- Total_disk_area — varchar(50)
- Max_disk_Loading — varchar(50)
airport
- Airport_ID — int(11) — Primary key — NOT NULL
- Airport_Name — varchar(255)
- Total_Passengers — int(11)
- Change_2007_Percent — varchar(50)
- International_Passengers — int(11)
- Domestic_Passengers — int(11)
- Transit_Passengers — int(11)
- Aircraft_Movements — int(11)
- Freight_Metric_Tonnes — int(11)
airport_aircraft
- Aircraft_ID — int(11) — Foreign key → aircraft.Aircraft_ID — NOT NULL
- Airport_ID — int(11) — Foreign key → airport.Airport_ID — NOT NULL
- ID — int(11)
match
- Round — int(11) — Primary key — NOT NULL
- Location — varchar(255)
- Country — varchar(255)
- Date — varchar(255)
- Fastest_Qualifying — varchar(255)
- Winning_Aircraft — int(11) — Foreign key
- Winning_Pilot — int(11) — Foreign key → pilot.Pilot_Id — NOT NULL
pilot
- Pilot_Id — int(11) — Primary key — NOT NULL
- Name — varchar(50)
- Age — int(11)