# Database Overview

{% hint style="info" %}
**GitBook tip:** A succinct video overview is a great way to introduce youself to BXI product.
{% endhint %}

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*