WebSphere Commerce database table: BZRPENTAT

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 Descriptions
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
SQL060903235133660 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
Related reference

Blaze layer data model

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.

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