Database Table: STORECGRY

Each row of this table represents a StoreCategory. Store categories 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 Column Description
NAME CHARACTER (50)
NOT NULL
A unique name for the StoreCategory.
REMARK VARCHAR (254)
NULL
This column is deprecated and is provided for backward compatibility only.
STORECGRY_ID INTEGER
NOT NULL
Generated unique key.
Indexes:
Index Name Indexed Column Names Index Type
I0000239 NAME Unique Index
SQL030416035113150 STORECGRY_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_773 STORECGRY_ID STORE STORECGRY_ID Cascade
F_949 STORECGRY_ID STCGRYDESC STORECGRY_ID Cascade