db design

Tables (9)

AIRPLANE

  • Airplane_id — INT — Primary key — NOT NULL
  • Type_name — INT — Foreign key → AIRPLANE_TYPE.Type_name — NOT NULL
  • Total_no_of_seats — VARCHAR(45)
  • INDEX — `fk_AIRPLANE_AIRLINE_TYPE1_idx`

AIRPLANE_TYPE

  • Type_name — INT — Primary key — NOT NULL
  • Max_seats — VARCHAR(45)
  • Company — VARCHAR(45)

AIRPORT

  • Airport_code — INT — Primary key — NOT NULL
  • City — VARCHAR(45)
  • State — VARCHAR(45)
  • Name — VARCHAR(45)

CAN_LAND

  • Airport_code — INT — Foreign key → AIRPORT.Airport_code — NOT NULL
  • Type_name — INT — Foreign key → AIRPLANE_TYPE.Type_name — NOT NULL
  • INDEX — `fk_AIRPORT_has_AIRLINE_TYPE_AIRLINE_TYPE1_idx`
  • INDEX — `fk_AIRPORT_has_AIRLINE_TYPE_AIRPORT_idx`

FARE

  • Restrictions — INT — Primary key — NOT NULL
  • Flight_Number — INT — Foreign key → FLIGHT.Number — NOT NULL
  • Amount — VARCHAR(45)
  • Code — VARCHAR(45)
  • INDEX — `fk_FARE_FLIGHT1_idx`

FLIGHT

  • Number — INT — Primary key — NOT NULL
  • Airline — VARCHAR(45)
  • Weekdays — VARCHAR(45)

FLIGHT_LEG

  • Leg_no — INT — Primary key — NOT NULL
  • Departure_irport_code — INT — Foreign key → AIRPORT.Airport_code — NOT NULL
  • Arrival_airport_code — INT — Foreign key → AIRPORT.Airport_code — NOT NULL
  • FLIGHT_Number — INT — Foreign key → FLIGHT.Number — NOT NULL
  • INDEX — `fk_FLIGHT_LEG_FLIGHT1_idx`
  • INDEX — `fk_FLIGHT_LEG_AIRPORT1_idx`
  • INDEX — `fk_FLIGHT_LEG_AIRPORT2_idx`

LEG_INSTANCE

  • Date — INT — Primary key — NOT NULL
  • Leg_no — INT — Foreign key → FLIGHT_LEG.Leg_no — NOT NULL
  • No_of_avail_seats — VARCHAR(45)
  • Airplane_id — INT — Foreign key → AIRPLANE.Airplane_id — NOT NULL
  • Airport_code — INT — Foreign key → AIRPORT.Airport_code — NOT NULL
  • AIRPORT_Airport_code1 — INT — Foreign key → AIRPORT.Airport_code
  • INDEX — `fk_LEG_INSTANCE_AIRPLANE1_idx`
  • INDEX — `fk_LEG_INSTANCE_AIRPORT1_idx`
  • INDEX — `fk_LEG_INSTANCE_FLIGHT_LEG1_idx`
  • INDEX — `fk_LEG_INSTANCE_AIRPORT2_idx`

SEAT

  • Seat_no — INT — Primary key — NOT NULL
  • Date — INT — Foreign key → LEG_INSTANCE.Date — NOT NULL
  • INDEX — `fk_SEAT_LEG_INSTANCE1_idx`