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 Descriptions
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
SQL060903235254230 STORECGRY_ID Primary Key

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