Table HLPDTEST.STATEGPS.T_GPS_MODELS 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
MODEL_ID number 22
BPM_MODELS_REPORT_V.MODEL_ID Implied Constraint R
T_BPM_APR_REQUESTS.MODEL_ID MODEL_ID_FKEY C
T_BPM_MODEL_NODE_PROPS_PIVOT_V.MODEL_ID Implied Constraint R
T_GPS_MASTER_MODELS.MODEL_ID MODEL_ID_FK C
T_GPS_MODEL_NODE_PROPS_COMP_V.MODEL_ID Implied Constraint R
T_GPS_MODEL_PROPERTIES.MODEL_ID SYS_C0010358 C
T_GPS_MODELS_HIERARCHY.MODEL_ID Implied Constraint R
T_GPS_MODELS_HIERARCHY_V.MODEL_ID Implied Constraint R
T_GPS_NODE_MODEL_RELATIONS.MODEL_ID SYS_C0010406 C
T_GPS_NODES.MODEL_ID SYS_C0010416 C
T_GPS_PATH.MODEL_ID SYS_C0010395 C
T_SCENARIO_PROPERTIES.MODEL_ID SCENARIO_MODEL_ID_FK C
MODEL_NAME varchar2 255
CATEGORY_ID number 22
T_CATEGORIES.CATEGORY_ID SYS_C0010298 C
ROOT_NODE_KEY varchar2 1000  √  null
MODEL_TYPE varchar2 255  √  null
DESCRIPTION varchar2 4000  √  null
NODE_ID number 22  √  null
T_GPS_NODES.NODE_ID FK_T_GPS_MODEL_NODE_ID C
MODEL_STATUS number 4  √  1
CREATED_BY varchar2 255  √  null
CREATED_DATE date 7  √  null
PUBLIC_ACCESS varchar2 10  √  null Enable / Disable Public Access for the vesioned model

Table contained 54,602 rows at Tue Sep 22 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
MODEL_ID Primary key Asc SYS_C0010036
MODEL_NAME + CATEGORY_ID + MODEL_STATUS Must be unique Asc/Asc/Asc SYS_C0015791
CATEGORY_ID + MODEL_NAME Performance Asc/Asc T_GPS_MODELS_MODEL_NAME_INDEX
NODE_ID Performance Asc T_GPS_MODELS_NODE_ID_CN1
NODE_ID + MODEL_STATUS Performance Asc/Asc T_GPS_MODELS_NODE_ID_CN2
CATEGORY_ID Performance Asc T_GPS_MODELS_NODE_ID_CN3

Close relationships  within of separation: