Database Table: BZRPENT

This table contains the data for a Brokat Repository Entry. This table reflects the directory structure of the Brokat repository.

Column Name Column Type Column Description
BZRPENT_ID INTEGER
NOT NULL
Primary key.
DIRECTORY INTEGER
NOT NULL
Directory name.
LASTUPDATE TIMESTAMP
NOT NULL
Last update timestamp.
PARENT INTEGER
NULL
Foreign key to the BZRPENT table, describing a parent and child relationship. The current row is the child. The row to which this foreign key points is the parent.
PATH VARCHAR (1024)
NOT NULL
This unique index contains the path of the Brokat repository.
TYPE VARCHAR (64)
NULL
This field indicates if the entry is a directory or a file: 0=file and 1=directory.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034848250 BZRPENT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_146 PARENT BZRPENT BZRPENT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_146 BZRPENT_ID BZRPENT PARENT Cascade
F_147 BZRPENT_ID BZRPENTAT BZRPENT_ID Cascade
F_148 BZRPENT_ID BZRPENTSTG BZRPENT_ID Cascade