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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000239 NAME Unique Index
SQL050212031314730 STORECGRY_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_949 STORECGRY_ID STCGRYDESC STORECGRY_ID Cascade
F_773 STORECGRY_ID STORE STORECGRY_ID Cascade

Feedback