Table HLPDTEST.STATEGPS.T_GPS_MASTER_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
MASTER_MODEL_ID number 22
T_GPS_MASTER_MODELS_PROPERTIES.MASTER_MODEL_ID MASTERMODELID_FK C
MODEL_ID number 22  √  null
T_GPS_MODELS.MODEL_ID MODEL_ID_FK C
MODEL_NAME varchar2 4000  √  null
DESCRIPTION varchar2 4000  √  null
CATEGORY_ID number 22
T_CATEGORIES.CATEGORY_ID FK_T_GPS_MASTER_MODELS C
LAST_UPDATED_BY varchar2 255  √  null
LAST_UPDATED_DATE date 7  √  null
MODEL_TYPE varchar2 4000  √  null

Table contained 22,239 rows at Thu Oct 28 01:06 IST 2021

Indexes:
Column(s) Type Sort Constraint Name Anomalies
MASTER_MODEL_ID Primary key Asc SYS_C0010029  
MODEL_ID Must be unique Asc SYS_C0010030 This unique column is also nullable
MODEL_NAME + CATEGORY_ID Must be unique Asc/Asc SYS_C0014395  

Close relationships  within of separation: