Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PATTRDESC
Reserved for IBM internal use.
Column Name Column Type Description PATTRIBUTE_ID BIGINT NOT NULL The identifier of the personalization attribute. LANGUAGE_ID INTEGER NOT NULL Language this description pertains to. For a list of language components, see the LANGUAGE table. DESCRIPTION VARCHAR(1024) A brief description of the personalization attribute. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030407270 PATTRIBUTE_ID+LANGUAGE_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_564 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade F_565 PATTRIBUTE_ID PATTRIBUTE PATTRIBUTE_ID Cascade _vcc_freeselect_bottom_