SchemaSpy - Table HLPDTEST.STATEGPS.T_GPS

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_ID

number

GPS_EWKS_NODE_PROPS_CONFIG_V.ROLE_ID	Implied Constraint R
GPS_EWKS_NODE_PROPS_VW.ROLE_ID	Implied Constraint R
GPS_NODE_PORPS_CONFIG_V.ROLE_ID	Implied Constraint R
GPS_NODE_PROPS_VW.ROLE_ID	Implied Constraint R
PROJECT_NATIVE_TASKS_V.ROLE_ID	Implied Constraint R
T_GPS_ROLE_APPLICATIONS.ROLE_ID	FK_T_GPS_ROLES_ROLE_ID C
T_PROJECT_NATIVE_TASK_V.ROLE_ID	Implied Constraint R
T_PROJECT_ROLE_USERS.ROLE_ID	Implied Constraint R
T_PROJECT_TASK.ROLE_ID	Implied Constraint R

ROLE_NAME

varchar2

255

√

null

DESCRIPTION

varchar2

255

√

null

LAST_UPDATED_ON

timestamp(6)

11,6

√

now

USER_NAME

varchar2

255

√

null

Table contained 2,420 rows at Sun Jan 24 01:06 IST 2021

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
ROLE_ID	Primary key	Asc	SYS_C0010078
ROLE_NAME	Must be unique	Asc	SYS_C0010079	This unique column is also nullable
ROLE_NAME + ROLE_ID	Performance	Asc/Asc	T_GPS_ROLES_RNAME_INDEX