sdrel

This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Structure-data relation table. Maps the hierarchical relation master file (folder) → register → document object in a single table — one row per storage location of a document, carrying references to stamm_id, register (register ID) and object_id plus the respective object types.

Belongs to the hierarchical object types (stamm, register, object) and is the central table for the folder–register–document assignment. The nesting of registers among each other is, however, not represented here — that is handled by osparregrel.

1. Columns

Name Type Length Description

loeschen

smallint

zeitstempel

int

stamm_id

int

object_id

int

objekttyp

int

register

int

regtype

int

deleted

int