Table slot9.WORLD.TSTA.IJIS_USER_PROFILE_AFFILIATES
Legacy table. This table is not currently used
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
IUP_AO_ID number 38 Unique identifier identifying each row in the table.
AFFILIATE_CODE varchar2 30
AFFILIATE_CODES.AFFILIATE_CODE ORGSTRIUPA_ORGSTRAC_FK R
Foreign key linking to the AFFILIATE_CODES table.
LOGIN_ID varchar2 30
IJIS_USER_PROFILES.LOGIN_ID ORGSTRIUPA_IUP_FK R
Foreign Key linking to the IJIS_USER_PROFILES table.
CREATOR_ID varchar2 100  √  null USER ID for the initial record creation.
CREATOR_DATE date 7  √  null Date record was created.
UPDATOR_ID varchar2 100  √  null USER ID for the last record update.
UPDATOR_DATE date 7  √  null Date record was last updated.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AFFILIATE_CODE" IS NOT NULL ORGSTRIUPA_AFFILIATE_CODE_NN
"IUP_AO_ID" IS NOT NULL ORGSTRIUPA_IUP_AO_ID_NN
"LOGIN_ID" IS NOT NULL ORGSTRIUPA_LOGIN_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
IUP_AO_ID Primary key Asc ORGSTRIUPA_PK
LOGIN_ID Performance Asc ORGSTRIUPA_IUP_FK_I
AFFILIATE_CODE Performance Asc ORGSTRIUPA_ORGSTRAC_FK_I

Close relationships  within of separation: