SchemaSpy - Table HLPDTEST.STATEGPS.T_GPS_COND_ST_CHANGE_PROPS

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

SET_ID

number

22

√

null

T_GPS_COND_ST_CHANGE_SETS.SET_ID

SYS_C0010396 C

PROPERTY_ID

number

22

T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID

Implied Constraint R

PROPERTY_NAME

varchar2

2500

√

null

OPERATOR

varchar2

25

√

null

PROPERTY_VALUE

varchar2

500

√

null

NOTIFICATION_DISPLAY

varchar2

10

√

null

VALID_EXPRESSION

varchar2

10

√

'true'

Table contained 2,560 rows at Wed Oct 28 01:06 IST 2020

Indexes:

Column(s)	Type	Sort	Constraint Name
PROPERTY_ID	Primary key	Asc	SYS_C0010009
SET_ID	Performance	Asc	T_GPS_COND_ST_CH_PROPS_INDEX