Table slot9.WORLD.TSTA.PRINT_TEMPLATE_OPTIONS
This table defines the sections of an INCIDENT included in each print template for printing an INCIDENT 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
PRINT_OPTION_VALUES.TEMPLATE_ID PRTEOV_PRTEO_FK R
PRINT_TEMPLATES.TEMPLATE_ID PRTEO_PRTE_FK R
OPTION_CODE varchar2 30
PRINT_OPTION_VALUES.OPTION_CODE PRTEOV_PRTEO_FK R
EJS_CODES.CODE PRTEO_EJS_CODES_OPTTYP_FK R
OPTION_CODE_TYPE varchar2 30
PRINT_OPTION_VALUES.OPTION_CODE_TYPE PRTEOV_PRTEO_FK R
EJS_CODES.CODE_TYPE PRTEO_EJS_CODES_OPTTYP_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
"OPTION_CODE" IS NOT NULL PRTEO_OPT_CD_NN
"OPTION_CODE_TYPE" IS NOT NULL PRTEO_OPT_TYP_NN
"TEMPLATE_ID" IS NOT NULL PRTEO_TEMPLATE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
TEMPLATE_ID + OPTION_CODE + OPTION_CODE_TYPE Primary key Asc/Asc/Asc PRTEO_PK
OPTION_CODE_TYPE + OPTION_CODE Performance Asc/Asc PRTEO_EJS_CODES_OPTTYP_FK_I
TEMPLATE_ID Performance Asc PRTEO_PRTE_FK_I

Close relationships  within of separation: