WebSphere Commerce database table: PROFNVSTRG

This table holds additional attributes for the profiles in the form of name-value pairs. Can be utilized for user-attributes.

Column Descriptions
Column Name Column Type Description
PROFNVSTRG_ID INTEGER NOT NULL Unique key for this table.
PROFILE_ID INTEGER NOT NULL Foreign key to profile table. Represents the profile this record is applicable to.
PROFILEATTNAME VARCHAR(254) NOT NULL Name of the attribute.
PROFILEATTVALUE VARCHAR(254) NOT NULL Value for the attribute.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000193 PROFILE_ID+PROFILEATTNAME Unique Index
SQL060903235236840 PROFNVSTRG_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_627 PROFILE_ID PROFILE PROFILE_ID Cascade
Related reference