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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034848250 | BZRPENT_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_146 | PARENT | BZRPENT | BZRPENT_ID | Cascade |
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 |