31.1 The most important Archivista tables
In the following we would like to introduce you to the most important
tables of an Archivista database. Please note that table and field names
are in German as yet. For a conversion table of field names please see
chapter 31.5.
- Table 'archiv': Each record corresponds to an Archivista
document. The field 'Laufnummer' (English: 'counter') administrates the
document number. The field 'Gesperrt' (English: 'locked') is essential in
that each time a user tries to change a document the system checks this
field to find out whether or not somebody else is already working on the
same document. If the field 'Gesperrt' is empty, the user's ID is entered
in the field and he is free to make changes. After he has
finished the content of the field 'Gesperrt' is erased again.
- Table 'archivseiten': Each record corresponds to a page in a
document. The necessary link between documents and pages is saved in the
field 'Seite' (English: 'page'): the last three digits denominate the pages
of a document while the preceding digits stand for the document number.
Let us make an example: '2412004' can be parsed into document number '2412'
and page number '4.' It is important to know that there is no relational
mapping between the two tables as yet. That is, an application must take
care, for example, that all pages in table 'archivseiten' are deleted, the
page counter in table 'archiv' (field 'Seiten') is updated and the document
itself is deleted (if there are no longer any records in table
'archivseiten').
- Table 'archivbilder': In this table the image data and (if set up accordingly) the PDF files are stored. The link between file and page from the 'archive' table is analogous to the 'archive pages' table.
- Table 'parameter': In this table you find all settings which
play a role in any Archivista database. Most relevant are certainly the
entries regarding the archive directories. These entries begin with 'Pfad
...' (English: path).
- Table 'user': In this table you find the user specific
settings. For more information see 31.3.