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)