Table slot9.WORLD.TSTA.USER_GROUP_USERS
Joins a user group to a user
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
ID number 38
DS_ICR_CAT_QUERIES.ID Implied Constraint R
GROUP_ID number 38
USER_GROUPS.ID USRGRP_USR_USRGRP_FK R
LOGIN_ID varchar2 100
IJIS_USER_PROFILES.LOGIN_ID USRGRP_USR_IUP_FK R
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"GROUP_ID" IS NOT NULL USRGRP_USR_GRP_ID_NN
"ID" IS NOT NULL USRGRP_USR_ID_NN
"LOGIN_ID" IS NOT NULL USRGRP_USR_LOGIN_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc USRGRP_USR_PK
LOGIN_ID Performance Asc USRGRP_USR_IUP_FK_I
GROUP_ID Performance Asc USRGRP_USR_USRGRP_FK_I

Close relationships  within of separation: