ER диаграмма базы данных Bookings
This ER diagram shows the main entities and foreign key relationships for the Bookings database.
Bookings Database ERD
Entity relationship diagram for the Bookings database with 8 main tables and key foreign key relationships.
aircrafts_data
PK
aircraft_code
model
range
aircraft catalog
airports_data
PK
airport_code
airport_name
city
coordinates
timezone
flights
PK
flight_id
flight_no
scheduled_departure
scheduled_arrival
FK
departure_airport -> airports_data
FK
arrival_airport -> airports_data
FK
aircraft_code -> aircrafts_data
status
actual_departure
actual_arrival
bookings
PK
book_ref
book_date
total_amount
seats
PK
FK
aircraft_code
PK
seat_no
fare_conditions
ticket_flights
PK
FK
ticket_no -> tickets
PK
FK
flight_id -> flights
fare_conditions
amount
ticket to flight map
boarding_passes
PK
FK
ticket_no
PK
FK
flight_id
boarding_no
seat_no
check-in data
tickets
PK
ticket_no
FK
book_ref -> bookings
passenger_id
passenger_name
contact_data
Legend
PK
Primary key
FK
Foreign key
Child table points to parent table
One connector line per FK
No connector through table bodies
N:1
N:1
N:1
N:1
N:1
N:1
N:1
N:1