SchemaSpy - Table HLPDTEST.STATEGPS.T_PROJECT_ROLE_USERS

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

PROJECT_USER_ID

number

22

APPLICATION_ID

number

22

√

null

T_GPS_APPLICATIONS.APPLICATION_ID

FK_APP_ID_PRU C

ROLE_ID

number

22

√

null

T_GPS_ROLES.ROLE_ID

Implied Constraint R

USER_ID

number

22

√

null

T_GPS_USERS.USER_ID

Implied Constraint R

ACTIVE

varchar2

20

√

null

Table contained 500 rows at Fri Oct 30 01:06 IST 2020

Indexes:

Column(s)	Type	Sort	Constraint Name
PROJECT_USER_ID	Primary key	Asc	PK_PROJECT_USER_ID