SchemaSpy - Table HLPDTEST.STATEGPS.T_GPS_MODEL_SEARCH

Generated by
SchemaSpy

Legend:

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

√

null

T_GPS_APPLICATIONS.APPLICATION_ID

FK_T_GPS_MODEL_SEARCH_ATTBTS C

ATTRIBUTE_ID

number

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

ATTRIBUTE_NAME

varchar2

255

√

null

ATTRIBUTE_CLASS

varchar2

255

√

null

Table contained 1 rows at Sat Dec 05 01:06 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