Difference between revisions of "Database description"

Jump to: navigation, search
(Created page with "=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 nul...")
 
(→‎Dump of OF 3.5 structure)
Line 3: Line 3:
 
==booking table==
 
==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.
 
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

Revision as of 17:24, 2 October 2014

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