We list here the data elements as they can be deduced from the document gathering phase. In many cases, they are not in a format already suitable for the final model because they are prefixed with a table name. For example, a data element identified as pilot_last_name
will become the column last_name
in the pilot
table. Sample values and more detailed information about each data element appear in the next section.
Data elements | |
---|---|
flight_departure_moment |
seat_id |
flight_arrival_moment |
plane_section |
departure_airport_code |
ticket_refundability |
arrival_airport_code |
gate_id |
airline_code |
boarding_time |
airline_name |
max_number_in_cabin_bags |
airport_name |
max_number_registered_bags |
plane_brand |
max_weight_registered_bags_kg |
plane_model |
tag_id |
pilot_last_name |
ticket_issued_on |
pilot_first_name |
number_meals |
flight_attendant_last_name |
web_site_quick_reference |
flight_attendant_first_name |
meal_supplier |
passenger_last_name |
plane_id |
passenger_first_name... |