Note
To add the script for your module, remember to read the contribution manual: CONTRIBUTING.md
Important
Remember to consistently use the same SQL formatter. It's available here: Prettier SQL
Stores information about flights, including their unique identifiers, flight numbers, base prices, tax percentages, and surcharges.
Contains details about airplane models, such as their identifiers, families or types, passenger capacities, and cargo capacities.
Maintains data related to airports, including their unique codes, names, types (e.g., international, domestic), cities, countries, and the number of runways available.
Manages the scales or segments of flights, recording details like unique identifiers, references to flight and airplane model, origin and destination airports, departure and arrival dates, and the price for each scale.
Stores information about employees, including their unique identifiers, names, and job titles or positions within the airline company.
Manages the flight crew members, recording details such as unique identifiers, references to flights and employees, and the roles or positions of crew members during flights.
Stores main info about passenger and the associated seat.
Stores crucial information about the booking, such as the associated passenger, the booked flight, the booking date, the booking status and the total price.
Manages each passenger's luggage and its unique characteristics, streamlining the process of identifying the appropriate zone for placement. Additionally, it enforces a strict limit on luggage allowance, with any excess baggage incurring an additional charge.
Categorizes items based on their designated placement zone, which may include hand luggage, cabin luggage, or checked luggage.
Contains information about where to send luggage in case of lossing it.
Stores info about passenger medical info
Gatters a lot of information from diferents moduls to generates a boarding pass
Has the information about the different Payment Methods a user can use to pay a booking
Saves the information about what Payment Method was used by the user who payed a Booking
This table stores various types of identification along with their unique identifiers.
Stores information about users including their personal details.
Stores information about different positions within the organization. Example: passenger, employee, etc.
Stores information about different privileges or permissions.
Associates users with their respective positions.
Associates positions with their respective privileges.
shows the search history of a particular person
Saves status of a seat. AVAILABLE or OCCUPIED
Store location type of a seat: WINDOW, CENTER, AISLE
Storre class type of a seat: TOURIST, FIRST_CLASS, EXECUTIVE
Save Seat's basic information. References to SeatStatus, SeatLocation, SeatClass, and Flight. Stores seat's label as seat_label.
Auxiliar entity to build relationship between a Seat and a Passenger.