Difference between revisions of "Database description"

Jump to: navigation, search
(→‎Dump of OF 3.5 structure)
(→‎Dump of OF 4 structure)
 
(10 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
=[[Database_OF21|Dump of OF 2.1 structure]]=
+
=[[Database-OF21|Dump of OF 2.1 structure]]=
−
=[[Database_OF35|Dump of OF 3.5 structure]]=
+
=[[Database-OF35|Dump of OF 3.5 structure]]=
 
==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.
 +
 +
==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==
 
==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:
+
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 club:
 
**name
 
**name
Line 36: Line 41:
 
**default_notification
 
**default_notification
 
**welcome_cell
 
**welcome_cell
−
*Table user:
+
 
 +
*Table journal: all fields
 +
*Table log: all fields
 +
*Table parameter: all fields
 +
 
 +
*Table person:
 
**hash_password
 
**hash_password
 +
 +
 +
Example of unallowed queries :
 +
<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>
 +
 +
=[[OF_doc4-fr:Structure-de-la-base-de-données|Dump of OF 4 structure]]=

Latest revision as of 13:00, 21 November 2020

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.

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 : 

SELECT * FROM club;
 
SELECT hash_password FROM person;
 
SELECT person.id, validity.*
FROM person
LEFT JOIN validity ON (person.id=validity.person_id);

Dump of OF 4 structure