Database Overview
Get amazing things done with awesome feature one. But remember that awesome feature two and three exist too. In fact, Awesome Product is full of awesome features.
Database Structure Overview
Aircraft and Fleet Management
Aircraft:
Actype (Aircraft Type) - ManyToOne
Flight - OneToMany
AircraftCrew (Assigned Crew) - OneToMany
ATLArchive (Technical Archive) - OneToMany
Maintenance - OneToMany
DueMaintenance (Scheduled Maintenance) - OneToMany
AircraftCategory (Categories) - ManyToMany
Airport (Operational Base) - ManyToOne
Flight and Operations Management
Flight:
Aircraft - ManyToOne
Airport (Departure/Arrival) - ManyToOne
FlightCrew - OneToMany
FlightPassenger (Passengers) - OneToMany
Handler (Airport Handlers) - ManyToOne
Catering - ManyToOne
FlightFuel - OneToMany
ATL (Technical Documentation) - OneToMany
Crew Management
Crew:
User (System User) - OneToOne
Rank - ManyToOne
ExpiredItem (Documents/Certifications) - OneToMany
CrewExtra - OneToMany
FlightCrew (Flight Assignments) - OneToMany
AircraftCrew (Aircraft Qualifications) - OneToMany
CrewAirplaneCertification - OneToMany
CrewAirportCertification - OneToMany
Airport Management
Airport:
Flight - OneToMany
CrewAirportCertification (Crew Certifications) - OneToMany
FlightFuel - OneToMany
Maintenance - OneToMany
Catering - OneToMany
AirportOperationalNote - OneToMany
AirportRunways - OneToMany
AirportAvailability - OneToMany
Commercial Management
Broker:
SalesQuote - OneToMany
Referent - OneToMany
AddressBookPassenger:
JetCard - OneToMany
User and Permission System
User:
Crew - OneToOne
UserGroup - ManyToMany
Aircraft (Managed Aircraft) - ManyToMany
Documentation and Maintenance
ATL (Aircraft Technical Log):
Aircraft - ManyToOne
Flight - ManyToOne
ATLArchive - ManyToOne
Fuel Management
FuelSupplier:
FuelSupplierAirportCost - OneToMany
Fuel Invoice:
Fuel invoice checking and control
FlightFuel:
Flight - ManyToOne
Airport - ManyToOne
Last updated