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)