Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: STORECGRY
Each row of this table represents a StoreCategory. StoreCategories can be used to group Stores of similar types together for display purposes. For example, in order to display all clothing stores in a mall together in the mall directory, you could create a clothing StoreCategory.
Column Name Column Type Description STORECGRY_ID INTEGER NOT NULL Generated unique key. NAME CHAR(50) NOT NULL A unique name for the StoreCategory. REMARK VARCHAR(254) This column is deprecated and is provided for backward compatibility only. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000239 NAME Unique Index SQL100520030433370 STORECGRY_ID Primary Key
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_949 STORECGRY_ID STCGRYDESC STORECGRY_ID Cascade F_773 STORECGRY_ID STORE STORECGRY_ID Cascade
Related reference
_vcc_freeselect_bottom_