SchemaSpy - Table HLPDTEST.STATEGPS.T_GPS_USER

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

USER_APP_ID

number

T_GPS_USER_APP_OPERATIONS.USER_APP_ID	FK_T_GPS_USER_APPOPERATION_ID C
T_GPS_USER_CATEGORIES.USER_APP_ID	FK_T_GPS_USER_USER_APP_ID C
T_GPS_USER_CUSTOM_SETS.USER_APP_ID	FK_T_GPS_USER_CUSTOM_SETS C
T_GPS_USER_MENUCONFIG.USER_APP_ID	SYS_C0010219 C
T_GPS_USER_NODETYPES.USER_APP_ID	FK_T_GPS_USER_NT_USER_APP C
T_GPS_USER_VIEWER_SETS.USER_APP_ID	FK_T_GPS_USER_VIEWER_APP_ID C
T_GPS_USER_WORKFLOW_TYPES.USER_APP_ID	FK_T_GPS_USER_WT_USER_APP_ID C

USER_ID

number

T_GPS_USERS.USER_ID

FK_T_GPS_USERS_USER_ID C

APPLICATION_ID

number

T_GPS_APPLICATIONS.APPLICATION_ID

FK_T_GPS_USERS_APP_ID C

DESCRIPTION

varchar2

255

√

null

Table contained 28,583 rows at Mon Mar 01 01:05 IST 2021

Indexes:

Column(s)	Type	Sort	Constraint Name
USER_APP_ID	Primary key	Asc	SYS_C0010096
USER_ID + APPLICATION_ID	Must be unique	Asc/Asc	SYS_C0013697
USER_ID + USER_APP_ID	Performance	Asc/Asc	T_GPS_USER_APPLICATIONS_INDEX