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