Database description

Dump of OF 3.5 structure

booking table

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.

flight table

• 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.

Hidden fields

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:
  • name
  • info_cell
  • logo
  • logo_name
  • logo_ext
  • logo_size
  • first_hour_displayed
  • last_hour_displayed
  • usual_profiles
  • default_slot_range
  • min_slot_range
  • twilight_range
  • mailing_list_name
  • mailing_list_type
  • default_timezone
  • lang
  • admin_num
  • mail_from_address
  • default_view_type
  • address
  • zipcode
  • city
  • state
  • country
  • phone
  • fax
  • email
  • default_notification
  • welcome_cell

• Table journal: all fields
• Table log: all fields
• Table parameter: all fields

• Table person:
  • hash_password

Example of unallowed queries : <syntaxhighlight lang="sql">SELECT * FROM club;

SELECT hash_password FROM person;

SELECT person.id, validity.* FROM person LEFT JOIN validity ON (person.id=validity.person_id);</sql>