SchemaSpy - Table HLPDTEST.STATEGPS.T_GPS_ROLE

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

ROLE_WORKFLOW_TYPE_ID

number

√

null

T_GPS_ROLE_WORKFLOW_TYPES.ROLE_WORKFLOW_TYPE_ID

FK_T_GPS_ROLE_STATES_RWT_F C

FROM_STATE_ID

number

√

null

FK_T_GPS_ROLE_STATES_WFS_F C

ROLE_STATE_ID

number

T_GPS_ROLE_NODETYPE_STATES.ROLE_STATE_ID	FK_ROLE_STATE_ID C
T_GPS_ROLE_OPERATIONS.ROLE_STATE_ID	CON_ROLE_STATE_ID C

TO_STATE_ID

number

√

null

Table contained 22,639 rows at Mon Mar 01 01:05 IST 2021

Indexes:

Column(s)	Type	Sort	Constraint Name
ROLE_STATE_ID	Primary key	Asc	PK_T_GPS_ROLE_STATES
FROM_STATE_ID + ROLE_WORKFLOW_TYPE_ID	Performance	Asc/Asc	T_GPS_ROLE_STATES_ID_INDEX
ROLE_WORKFLOW_TYPE_ID	Performance	Asc	T_GPS_ROLE_STATES_INDEX