This dataset is an sqldump from the database (PostgreSQL version 12.5) that is used to power the open access platform https://www.dbbe.ugent.be/.
Contents
The database consists of 3 schemas:
data - contains the actual data
logic - contains other information required to run the database (user roles, revision information, feedback information, ...)
migration - contains information on the mapping between the previous data platform and the current one
The database dump contains the schema and table creation instruction for all 3 schemas, but only contains the data for the data schema. It can be used to create and populate a database that can be used to run the code hosted on https://github.com/GhentCDH/dbbe.
Acknowledgements
Acknowledgements can be reconstructed by mapping the acknowledgement to the document table using the document_acknowledgement join table. For translations, the source of a translation can be reconstructed by mapping the translation table with one of the bibliography tables (article, book, bookchapter, online_source, blog_post, phd, bib_varia) using the reference join table.