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.