Flight Booking
Tables (10)
Airline (Untitled9)
- Airline_code (Key) — Primary key — NOT NULL
Airport (Untitled8)
- Airport_Code (Key) — Primary key — NOT NULL
Booking Agency (Untitled3)
- Agency_Code (Key) — Primary key — NOT NULL
- Passport_ID — Foreign key → Passenger.Passport_ID — NOT NULL
- Passenger_ID (Field)
- Flight_ID (Field2)
- Ticket_Price (Field3)
- CreditCard_info (Field4)
- seat_class (Field5)
- Airline (Field6)
Cabin Crew (CopyOfUntitled6)
- EMP_NUM (Key) — Primary key — NOT NULL
- Position (Field)
Employee (Untitled5)
- EMP_NUM (Key2) — Foreign key → Pliot.EMP_NUM — NOT NULL
- EMP_Name (Field)
- EMP_mobile (Field2)
- Depart_Code (Field3)
Flight (Untitled2)
- Flight_ID (Key) — Primary key — NOT NULL
- EMP_NUM (Key2) — Foreign key → Employee.EMP_NUM — NOT NULL
- Airport_Code (Key3) — Foreign key → Airport.Airport_Code — NOT NULL
- Passport_ID — Foreign key → Passenger.Passport_ID — NOT NULL
- Airline_code (Key5) — Foreign key → Airline.Airline_code — NOT NULL
- Airline_ID (Field)
- From (Field2)
- to (Field3)
- Departure_time (Field4)
- Arrival_time (Field5)
Luggage (Untitled4)
- Luggage_Code (Key) — Primary key — NOT NULL
- Passport_ID — Foreign key → Passenger.Passport_ID — NOT NULL
- weight (Field)
- price (Field2)
Passenger (Untitled)
- Passport_ID — Primary key — NOT NULL
- Flight_ID (Key)
- Visa_num
- mileage (Field)
Pliot (Untitled6)
- EMP_NUM (Key) — Primary key — NOT NULL
- license_ID (Field)
Seat (Untitled7)
- Seat_num (Key) — Primary key — NOT NULL
- Passport_ID — Foreign key → Passenger.Passport_ID — NOT NULL
- Flight_ID (Key2) — Foreign key → Flight.Flight_ID — NOT NULL
- EMP_NUM (Key22) — Foreign key → Flight.EMP_NUM — NOT NULL
- Airport_Code (Key3) — Foreign key → Flight.Airport_Code — NOT NULL
- Passport_ID (Passport_ID2) — Foreign key → Flight.Passport_ID — NOT NULL
- Airline_code (Key5) — Foreign key → Flight.Airline_code — NOT NULL