Database description

Revision as of 16:24, 2 October 2014 by Claratte (Talk | contribs) (Dump of OF 3.5 structure)

Jump to: navigation, search

Dump of OF 2.1 structure

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.

Hidden fields

Following fields can not be exported et should not be in included in SELECT statement. Moreover, SELECT with wild-card * is not possible on 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 user:
    • hash_password