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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000193 PROFILE_ID+PROFILEATTNAME Unique Index
SQL050212031259230 PROFNVSTRG_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_627 PROFILE_ID PROFILE PROFILE_ID Cascade

Feedback