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`