Table HLPDTEST.STATEGPS.T_GPS_MODEL_SEARCH_ATTRIBUTES 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
APPLICATION_ID number 22  √  null
T_GPS_APPLICATIONS.APPLICATION_ID FK_T_GPS_MODEL_SEARCH_ATTBTS C
ATTRIBUTE_ID number 22
T_GPS_MODEL_SR_ATT_CLASSES.ATTRIBUTE_ID FK_T_GPS_MODEL_SR_ATT_CLASSES C
T_GPS_WORKFLOW_STATES.ATTRIBUTE_ID Implied Constraint R
T_ORA_CLOUD_IMPL_ATTRIBUTES_VL.ATTRIBUTE_ID Implied Constraint R
ATTRIBUTE_NAME varchar2 255  √  null
ATTRIBUTE_CLASS varchar2 255  √  null

Table contained 4 rows at Tue Sep 22 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
ATTRIBUTE_ID Primary key Asc SYS_C0010037
ATTRIBUTE_NAME + APPLICATION_ID + ATTRIBUTE_ID Performance Asc/Asc/Asc T_GPS_MODEL_SRCH_ATT_INDEX
APPLICATION_ID Performance Asc T_GPS_MODEL_SRCH_ID_INDEX

Close relationships  within of separation: