Table HLPDTEST.STATEGPS.T_CATEGORIES Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
CATEGORY_ID number 22
BPM_MODELS_REPORT_V.CATEGORY_ID Implied Constraint R
T_ALL_BPM_LATEST_VER_MODELS_V.CATEGORY_ID Implied Constraint R
T_APP_GROUPS.CATEGORY_ID FK_CATEGORY_ID C
T_BPM_MODEL_NODE_PROPS_PIVOT_V.CATEGORY_ID Implied Constraint R
T_CATEGORIES_V.CATEGORY_ID Implied Constraint R
T_CHILD_CATEGORIES.CATEGORY_ID FK_T_CHILD_CATEGORIES1 C
T_CHILD_CATEGORIES.CHILD_CATEGORY_ID FK_T_CHILD_CATEGORIES2 C
T_GPS_MASTER_MODELS.CATEGORY_ID FK_T_GPS_MASTER_MODELS C
T_GPS_MODELS.CATEGORY_ID SYS_C0010298 C
T_GPS_MODELS_HIERARCHY.CATEGORY_ID Implied Constraint R
T_GPS_MODELS_HIERARCHY_V.CATEGORY_ID Implied Constraint R
T_GPS_ROLE_CATEGORIES.CATEGORY_ID FK_T_GPS_ROLE_CATEGORIES_CAT C
T_GPS_USER_CATEGORIES.CATEGORY_ID FK_T_GPS_USER_CAT_ID C
CATEGORY_NAME varchar2 255  √  null
URL varchar2 255  √  null
GROUP_IMAGE varchar2 255  √  null
DISPLAY_NAME varchar2 255  √  null
TRADING_PARTY_ID number 22  √  null
T_TRADING_PARTY.TRADING_PARTY_ID Implied Constraint R

Table contained 301 rows at Thu Oct 28 01:06 IST 2021

Indexes:
Column(s) Type Sort Constraint Name Anomalies
CATEGORY_NAME Must be unique Asc SYS_C009973 This unique column is also nullable
CATEGORY_ID + CATEGORY_NAME Performance Asc/Asc T_CATEGORIES_INDEX  

Close relationships  within of separation: