The content of aircraft_id field in booking table might be null. In this case, it's an old booking made onto a non-existing aircraft or an aircraft which no longer exists; also called orphan booking.
- airborne :
- 0: not airborne or flight closed: the pilot has finished his flight.
- 1: airborne or flight opened: the pilot fills the flight before going flying.
Following fields can not be exported and should not be in included in SELECT statement. Moreover, SELECT with wild-card * is not possible when there is one table including hidden fields:
- Table club:
- Table journal: all fields
- Table log: all fields
- Table parameter: all fields
- Table person:
Example of unallowed queries :
SELECT * FROM club; SELECT hash_password FROM person; SELECT person.id, validity.* FROM person LEFT JOIN validity ON (person.id=validity.person_id);