The document database schema
document meta data
The meta data of documents are stored in the prg_documents table.
| attribute | database column name | comment | |
| locking date | timestampfield01 | timestamp when the document was locked. user_right contains then the user who locked | |
| title | field01 | copy of field01 from table prg_documents_files of actual version | |
| categories | field02 | ||
| folder containing the document | sid | unique database identifier of folder stored in intfield01 of prg_docufolders | |
| owner | tid | user who only is able to delete the document | |
| unique database identifier | intfield01 | ||
| actual version | intfield02 | unique database identifier of actual version stored in intfield01 of prg_documents_files | |
document version specific data
The version specific data of documents are stored in the prg_documents_files table.
| attribute | database column name | comment | |
| file size | intfield02 | file size in bytes | |
| version number | intfield03 | incremented by one for every new version | |
| title | field01 | title is version specific because e.g. default title is the file name that can end with file specific endings like .mpg | |
| description | field02 | description is version specific to be able to describe changings between versions | |
| mime type | field03 | ||
| name of file in filespool | field04 | ||
| name of uploaded file | field05 | ||
| md5 sum | field06 | used to detect changings in file for automatic uploaded file via WebDAV (prevents new versions if autosaved documents isn't changed | |
| document meta data | sid | unique database identifier of document meta data stored in intfield01 of prg_documents | |
| unique database identifier | intfield01 | ||
