Table slot9.WORLD.TSTA.EJS_NOTES_FLASHBACK
This table is used to recover EJS Notes (narratives) that may have been changed or lost
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
FLASHBACK_ID number 0
OPERATION varchar2 100
FLASHBACK_SAVE_DATE date 7
NOTE_ID number 0
EJS_NOTES.NOTE_ID Implied Constraint R
NARRATIVE clob 4000  √  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
TABLE_NAME varchar2 100  √  null
INCIDENT_ID number 0  √  null
INCIDENTS.INCIDENT_ID Implied Constraint R
SUPP_SEQ number 0  √  null
NARRATIVE_NUMBER number 0  √  null
NARR_TITLE varchar2 4000  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
operation IN ( 'INSERT' , 'UPDATE' , 'DELETE' ) CK_EJSNFLSH_OPERATION
"FLASHBACK_ID" IS NOT NULL EJSNFLSH_FLASHBACK_ID_NN
"FLASHBACK_SAVE_DATE" IS NOT NULL EJSNFLSH_FLASHBACK_SAVE_NN
"NOTE_ID" IS NOT NULL EJSNFLSH_NOTE_ID_NN
"OPERATION" IS NOT NULL EJSNFLSH_OPERATION_NN

Indexes:
Column(s) Type Sort Constraint Name
FLASHBACK_ID Primary key Asc EJSNFLSH_PK
NOTE_ID Performance Asc EJSNFLSH_NOTE_ID_I

Close relationships: