Reference > Database > WebSphere Commerce database tables > P
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 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 SQL100520030414630 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
_vcc_freeselect_bottom_