Table slot9.WORLD.TSTA.MASTER_REPORT_PREFERENCES
Master Report Preferences Header, Footer, Alignment
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
REPORT_PREFERENCE_ID number 0
MASTER_REPORT_REFERENCES.REPORT_PREFERENCE_ID MRREF_MRREF_FK R
Unique ID for Report Preference (Oracle Sequence)
PREFERENCE_NAME varchar2 40  √  null Name of Preference
PREFERENCE_DESCRIPTION varchar2 255  √  null Detailed Description of Preference
HEADER_TEXT varchar2 2000  √  null Text of Header
FOOTER_TEXT varchar2 2000  √  null Text of Footer
HEADER_ALIGNMENT_CODE varchar2 30  √  null
EJS_CODES.CODE MRPREF_EJSCD_HEADER_FK R
Alignment of Header Code (Center,Left, Right)
FOOTER_ALIGNMENT_CODE varchar2 30  √  null
EJS_CODES.CODE MRPREF_EJSCD_FOOTER_FK R
Alignment of FooterCode (Center,Left, Right)
CREATOR_ID varchar2 100  √  null Person creating the record.
CREATOR_DATE date 7  √  null Date the record was created.
UPDATOR_ID varchar2 100  √  null Person updating the record.
UPDATOR_DATE date 7  √  null Date the record was updated.
HEADER_ALIGNMENT_CODE_TYPE varchar2 30  √  'REPORT_ALIGNMENT_CODES'
EJS_CODES.CODE_TYPE MRPREF_EJSCD_HEADER_FK R
EJS_CODES Code Type for Header Alignment Code
FOOTER_ALIGNMENT_CODE_TYPE varchar2 30  √  'REPORT_ALIGNMENT_CODES'
EJS_CODES.CODE_TYPE MRPREF_EJSCD_FOOTER_FK R
EJS_CODES Code Type for Footer Alignment Code

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"REPORT_PREFERENCE_ID" IS NOT NULL MRPREF_REPORT_PREFERENCE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
REPORT_PREFERENCE_ID Primary key Asc MRPREF_PK
FOOTER_ALIGNMENT_CODE_TYPE + FOOTER_ALIGNMENT_CODE Performance Asc/Asc MRPREF_EJSCD_FOOTER_FK_I
HEADER_ALIGNMENT_CODE_TYPE + HEADER_ALIGNMENT_CODE Performance Asc/Asc MRPREF_EJSCD_HEADER_FK_I

Close relationships  within of separation: