ㅇㄴㅁㄹ

Tables (3)

Aircraft (항공기)

  • aircraftNumber (비행기 번호) — int — Primary key — NOT NULL
  • aircraftName (비행기이름) — varchar(20) — NOT NULL
  • aircraftCase (비행기 종류) — varchar(20) — NOT NULL

Flight (Untitled)

  • pilotNumber (파일럿 번호) — int — Foreign key → Pilot1.pilotNumber — NOT NULL
  • aircraftNumber (비행기 번호) — int — Foreign key → Aircraft.aircraftNumber — NOT NULL
  • flightDate (운항일자) — varchar(20) — NOT NULL

Pilot1 (파일럿1)

  • pilotNumber (파일럿 번호) — int — Primary key — NOT NULL
  • pilotName (파일럿이름) — varchar(20)
  • rank (등급) — int — NOT NULL
  • age (나이) — int — NOT NULL