Database Overview

GitBook tip: A succinct video overview is a great way to introduce youself to BXI product.

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