Table slot9.WORLD.TSTA.SUBSCRIPTION_TYPE_CODES
This table defines a subscription type for each master indices type
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
SUB_TYPE_CODE varchar2 30
CITATION_ADDRESS_VW.SUB_TYPE_CODE Implied Constraint R
DISPATCH_EVENT_PEOPLE_VW.SUB_TYPE_CODE Implied Constraint R
DISPATCH_SEARCH_VW.SUB_TYPE_CODE Implied Constraint R
SUBSCRIPTIONS.SUB_TYPE_CODE SUBSCRIPTIONS_CD_FK R
SUBSCRIPTIONS_QUEUE.SUB_TYPE_CODE Implied Constraint R
WARRANT_PERSON_ADDR_VW.SUB_TYPE_CODE Implied Constraint R
SUB_TYPE_DESC varchar2 4000  √  null
ACTIVE varchar2 1  √  null
SUBSCRIPTION_INDEX_JSP varchar2 255  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null
NOTIFY_TYPE_CD number 8  √  null
NOTIFICATION_DEF_MASTERS.NOTIFY_TYPE_CD SUBTYPCD_NDM_FK R
Defines which notifications to create for particular types of subscriptions.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"SUB_TYPE_CODE" IS NOT NULL SUB_TYPE_CODES_CD_NN

Indexes:
Column(s) Type Sort Constraint Name
SUB_TYPE_CODE Primary key Asc SUBSCRIPTION_TYPE_CODES_PK
NOTIFY_TYPE_CD Performance Asc SUBTYPCD_NDM_FK_I

Close relationships  within of separation: