Table slot9.WORLD.TSTA.NARRATIVE_SEARCHES
This table is not currently used
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
SEARCH_ID number 0
EXT_SEARCHES.SEARCH_ID Implied Constraint R
NARRATIVE_SEARCH_ACCESS.SEARCH_ID NSA_NS_FK C
NARRATIVE_SEARCH_RESULTS.SEARCH_ID Implied Constraint R
SEARCH_PROMPT varchar2 40
SEARCH_TABLE varchar2 30
SEARCH_COLUMN varchar2 30
ACTIVE varchar2 1 'N' Yes or No Fields
COL_PROMPT1 varchar2 40  √  null
COL_PROMPT2 varchar2 40  √  null
COL_PROMPT3 varchar2 40  √  null
COL_PROMPT4 varchar2 40  √  null
COL_PROMPT5 varchar2 40  √  null
COL_VALUE1 varchar2 80  √  null
COL_VALUE2 varchar2 80  √  null
COL_VALUE3 varchar2 80  √  null
COL_VALUE4 varchar2 80  √  null
COL_VALUE5 varchar2 80  √  null
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
INDEX_NAME varchar2 25  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
ACTIVE IN ('N', 'Y') CK_NS_ACTIVE
"ACTIVE" IS NOT NULL NS_ACTIVE_NN
"SEARCH_COLUMN" IS NOT NULL NS_SEARCH_COLUMN_NN
"SEARCH_ID" IS NOT NULL NS_SEARCH_ID_NN
"SEARCH_PROMPT" IS NOT NULL NS_SEARCH_PROMPT_NN
"SEARCH_TABLE" IS NOT NULL NS_SEARCH_TABLE_NN

Indexes:
Column(s) Type Sort Constraint Name
SEARCH_ID Primary key Asc NS_PK

Close relationships  within of separation: