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.
The t_meta table contains the following meta-information about the database:
This string contains the name of the application that created the database.
This string contains the version number of the application that created the database.
This string describes the type of the database. Currently only the type "risx" is supported.
This timestamp is set by refdbd when the database is created.
This timestamp is updated by refdbd whenever the database is changed.