Table slot9.WORLD.TSTA.POD_AFFILIATES
TABLE LINKING AFFILATE CODES TO PSEUDO ORG DESCRIPTORS
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
POD_AC_ID number 38 Primary key of the relationship between the Affiliate Codes and the Pseudo Org Descriptors
POD_ID number 38  √  null
PSEUDO_ORG_DESCRIPTORS.POD_ID ORGSTRPA_ORGSTRPOD_FK R
Foreign key to the PSEUDO_ORG_DESCRIPTOR table to join the AFFILIATE to the POD and establish the AFFILIATE entity position and ownership in the hierarchy.
AFFILIATE_CODE varchar2 30  √  null
AFFILIATE_CODES.AFFILIATE_CODE ORGSTRPA_ORGSTRAC_FK R
Foreign Key to the AFFILIATE_CODES table to join the Affiliates to the POD
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
"POD_AC_ID" IS NOT NULL ORGSTRPA_POD_AC_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
POD_AC_ID Primary key Asc ORGSTRPA_PK
AFFILIATE_CODE Performance Asc ORGSTRPA_ORGSTRAC_FK_I
POD_ID Performance Asc ORGSTRPA_ORGSTRPOD_FK_I

Close relationships  within of separation: