Reference > Database > WebSphere Commerce database tables > B


WebSphere Commerce database table: BZRPENTAT

This table contains the data for the attributes for a Brokat repository item. This table is deprecated and is provided for backward compatibility only.

Column Name Column Type Description
BZRPENTAT_ID INTEGER NOT NULL Primary key.
BZRPENT_ID INTEGER NOT NULL Foreign key to the BZRPENT table.
NAME VARCHAR(254) NOT NULL Brokat repository entry attributes are name value pairs associated with a Brokat repository entry. This is the "name".
VALUE VARCHAR(254) This is the "value" in name-value pair.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000049 BZRPENT_ID+NAME Unique Index
SQL100520030306420 BZRPENTAT_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_147 BZRPENT_ID BZRPENT BZRPENT_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search