Table slot9.WORLD.TSTA.REPORT_PARAMETER_LISTS
Administration table used for reporting
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_LIST_ID number 0
REPORT_PARAMETER_INSTANCES.PARAMETER_LIST_ID RPI_LIST_ID_FK R
REPORT_PARAMETER_VALUES.PARAMETER_LIST_ID RPV_PLIST_ID_FK R
EXTERNAL_ID varchar2 100
NAME varchar2 255
DESCRIPTION varchar2 500  √  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

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"PARAMETER_LIST_ID" IS NOT NULL RPL_LIST_ID_NN
"NAME" IS NOT NULL RPL_NAME_NN
"EXTERNAL_ID" IS NOT NULL RRL_EXT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
PARAMETER_LIST_ID Primary key Asc RPL_PK
EXTERNAL_ID Must be unique Asc RPL_EXTERNAL_ID_UK

Close relationships  within of separation: