Kevin's Airline

Tables (9)

E_AIR_Aircraft (Untitled9)

  • aircraft_id (Key) — NUMBER — Primary key — NOT NULL
  • model (Field) — VARCHAR(50)
  • seat_capacity (Field2) — NUMBER
  • airport_id (Key2) — NUMBER — Foreign key → E_AIR_Airport.airport_id — NOT NULL

E_AIR_Airport (Untitled8)

  • airport_id (Key) — NUMBER — Primary key — NOT NULL
  • name (Field) — VARCHAR(100)
  • code (Field2) — VARCHAR(10)
  • country (Field3) — VARCHAR(100)

E_AIR_Booking (Untitled3)

  • booking_id (Key) — NUMBER — Primary key — NOT NULL
  • booking_date (Field) — DATE
  • status (Field2) — VARCHAR(20)
  • customer_id (Key2) — NUMBER — Foreign key → E_AIR_Customer.customer_id — NOT NULL

E_AIR_Booking_flight (Untitled5)

  • booking_id (Key) — NUMBER — Foreign key → E_AIR_Booking.booking_id — NOT NULL
  • flight_id (Key2) — NUMBER — Foreign key → E_AIR_Flight.flight_id — NOT NULL

E_AIR_Customer (Untitled4)

  • customer_id (Key) — NUMBER — Primary key — NOT NULL
  • name (Field) — VARCHAR(100)
  • id (Field2) — VARCHAR(50)
  • password (Field3) — VARCHAR2(100)
  • eamil (Field4) — VARCHAR2(100)
  • phone (Field5) — VARCHAR2(20)
  • gender (Field6) — CHAR(1)
  • passport_no (Field7) — VARCHAR(20)

E_AIR_Flight (Untitled7)

  • flight_id (Key) — NUMBER — Primary key — NOT NULL
  • flight_code (Field) — VARCHAR(20)
  • depart_time (Field2) — DATE
  • arrival_time (Field3) — DATE
  • departure_airport_id (Key2) — NUMBER — Foreign key → E_AIR_Airport.airport_id — NOT NULL
  • arrival_airport_id (Key3) — NUMBER — Foreign key → E_AIR_Airport.airport_id — NOT NULL
  • aircraft_id (Key4) — NUMBER — Foreign key → E_AIR_Aircraft.aircraft_id — NOT NULL

E_AIR_Passenger (Untitled6)

  • passenger_id (Key) — NUMBER — Primary key — NOT NULL
  • name (Field) — VARCHAR(100)
  • gender (Field2) — CHAR(1)
  • passport_no (Field3) — VARCHAR(20)
  • birthday (Field4) — DATE
  • customer_id (Key2) — NUMBER — Foreign key → E_AIR_Customer.customer_id — NOT NULL
  • booking_id (Key3) — NUMBER — Foreign key → E_AIR_Booking.booking_id — NOT NULL

E_AIR_Payment (Untitled)

  • payment_id (Key) — NUMBER — Primary key — NOT NULL
  • amount (Field2) — NUMBER
  • status (Field) — VARCHAR(20)
  • payment_date (Field3) — DATE
  • booking_id (Key2) — NUMBER — Foreign key → E_AIR_Booking.booking_id — NOT NULL
  • method_id (Key3) — NUMBER — Foreign key → E_AIR_Payment_method.method_id — NOT NULL

E_AIR_Payment_method (Untitled2)

  • method_id (Key) — NUMBER — Primary key — NOT NULL
  • method_name (Field) — VARCHAR(50)