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:

NameTypeDescription
STORECGRY_IDINTEGER NOT NULLGenerated unique key.
NAMECHAR (50) NOT NULLA unique name for the StoreCategory.
REMARKVARCHAR (254)This column is deprecated and is provided for backward compatibility only.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>STORECGRY_IDPrimary Key
I0000239NAMEUnique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_773STORECGRY_IDSTORESTORECGRY_IDCascade
F_949STORECGRY_IDSTCGRYDESCSTORECGRY_IDCascade