WebSphere Commerce database table: BZRPENT

This table contains the data for a Brokat Repository Entry. This table reflects the directory structure of the Brokat repository. This table is deprecated and is provided for backward compatibility only.


Column Description(s):
Column NameColumn TypeDescription
BZRPENT_ID INTEGER NOT NULL Primary key.
PATH VARCHAR(1024) NOT NULL This unique index contains the path of the Brokat repository.
TYPE VARCHAR(64) This field indicates if the entry is a directory or a file: 0=file and 1=directory.
PARENT INTEGER 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.
DIRECTORY INTEGER NOT NULL The name of the directory that contains the template files.
LASTUPDATE TIMESTAMP NOT NULL The timestamp of the most recent update.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031204810 BZRPENT_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_146 PARENT BZRPENT BZRPENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_146 PARENT BZRPENT BZRPENT_ID Cascade
F_147 BZRPENT_ID BZRPENTAT BZRPENT_ID Cascade
F_148 BZRPENT_ID BZRPENTSTG BZRPENT_ID Cascade

Feedback