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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000239 | NAME | Unique Index |
SQL030416035113150 | STORECGRY_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
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 |