Table slot9.WORLD.TSTA.EJS_REPORT_PARAMETERS
This table is an administrative table that is configured under Administration Reports
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
PARAMETER_ID number 0
REPORT_USER_PARAMETERS.PARAMETER_ID Implied Constraint R
PARAMETER_NAME varchar2 40  √  null
PROCEDURE_NAME varchar2 255  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REPORT_ID number 4
EJS_REPORTS.REPORT_ID ERP_ER_FK R
PARAMETER_TYPE_CODE varchar2 1
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"PARAMETER_ID" IS NOT NULL ERP_PARAMETER_ID_NN
"PARAMETER_TYPE_CODE" IS NOT NULL ERP_PARAMETER_TYPE_CODE_NN
"REPORT_ID" IS NOT NULL ERP_REPORT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
PARAMETER_ID Primary key Asc ERP_PK
REPORT_ID Performance Asc ERP_ER_FK_I

Close relationships  within of separation: