This section gives an overview over the design of the reference database with MySQL as the database server. The same design is used with the other database engines, although the details may differ somewhat. This will be mentioned where appropriate.
The requirements of the database necessitate some tables which hold the data proper and some tables which cross-reference these tables.