ㅇㄴㅁㄹ
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