Difference between revisions of "Database description"
(→Hidden fields) |
(→Dump of OF 4 structure) |
||
(9 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | =[[ | + | =[[Database-OF21|Dump of OF 2.1 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 | + | 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 37: | Line 42: | ||
**welcome_cell | **welcome_cell | ||
+ | *Table journal: all fields | ||
+ | *Table log: all fields | ||
*Table parameter: all fields | *Table parameter: all fields | ||
− | *Table | + | *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
Contents
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
- 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);