Table slot9.WORLD.TSTA.PRINT_TEMPLATES
This table defines the print templates supported for printing INCIDENTS in the application
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
TEMPLATE_ID number 0
CHARGE_LANGUAGE_TEMPLATES.TEMPLATE_ID Implied Constraint R
NARRATIVE_TEMPLATES.TEMPLATE_ID Implied Constraint R
PRINT_TEMPLATE_OPTIONS.TEMPLATE_ID PRTEO_PRTE_FK R
DESCRIPTION varchar2 255
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE PRTE_AGNCY_CD_FK R
DEFAULT_FLAG varchar2 1  √  'N'
TYPE_CODE varchar2 30
EJS_CODES.CODE PRTE_EJS_CODES_TYPE_FK R
TYPE_CODE_TYPE varchar2 30
EJS_CODES.CODE_TYPE PRTE_EJS_CODES_TYPE_FK R
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
EXTERNAL_ID varchar2 50  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DESCRIPTION" IS NOT NULL PRTE_DESC_NN
"TYPE_CODE" IS NOT NULL PRTE_TEMP_TYP_CD_NN
"TYPE_CODE_TYPE" IS NOT NULL PRTE_TEMP_TYP_TYP_NN
"TEMPLATE_ID" IS NOT NULL PRTE_TEMPLATE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name Anomalies
TEMPLATE_ID Primary key Asc PRTE_PK  
AGENCY_CODE Performance Asc PRTE_AGNCY_CD_FK_I  
DEFAULT_FLAG Performance Asc PRTE_DEFAULT_FLAG_I  
TYPE_CODE_TYPE + TYPE_CODE Performance Asc/Asc PRTE_EJS_CODES_TYPE_FK_I  
EXTERNAL_ID Must be unique Asc PRTE_EXTERNAL_ID_UK This unique column is also nullable

Close relationships  within of separation: