User:Jakob.scholbach/zeteo/database structure
There are four intertwined databases.
References
[edit]- fields: author, coauthors, editors, others, title, publisher, origdate, url, urlformat, date, wikilink, accessdate, isbn, series, language, oclc, doi, additional_id, edition, volume, issue, journal, chapter, chapterurl, pages, comment, verification
- author, coauthors, editors, others are linked to Authors database
- publisher is linked to Publishers database
- journal is linked to Journals
- isbn is automatically converted into well-hyphened ISBN-13 when an item is saved
- comment is just to comment on the quality of the database entry etc., i.e. not directly linked to the reference
- verification has three options: not verified, verified and complete+verified.
Authors
[edit]fields: name, firstname, wikilink, alias
alias is a pointer to another author item, which contains the full (or the correct) information about this author. This is inteded for acronyms, existence of several transcriptions etc. Example: item A has alias=B. Whenever item A is requested (for export of citations etc.), the values of B will be shown.
sample entry: Birkhoff, Garrett, en:Garrett Birkhoff
Journals
[edit]fields: name, abbrname, wikilink, issn, alias
sample entry: Inventiones Mathematicae, Invent. Math., 0020-9910, en:Inventiones Mathematicae
Publishers
[edit]- fields: name, location, wikilink, alias