Table slot9.WORLD.TSTA.APPLICATION_SEQUENCES
This is an Interact Administration table
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
SEQUENCE_NAME varchar2 40 Name of Sequence used by application
COLUMN_NAME varchar2 40  √  null Name of Appliation Column mapping to sequence
TABLE_NAME varchar2 40  √  null
APPLICATION_TABLES.TABLE_NAME APSEQ_AT_FK R
Name of Table/View used by application
START_VALUE number 0  √  1 Starting Value
INC_VALUE number 0  √  1 Increment Value
RESET_ANUALLY varchar2 1  √  'N' Should Sequence be reset annually
EJS_VER varchar2 15  √  null EJS Major and Minor Release Number when added
EJS_REL_VER varchar2 30  √  null EJS REL_MOD_VER of last update
NOTES varchar2 2000  √  null Comments Regarding Sequence
IGNORE_MAX varchar2 1  √  'N'
REC_ID number 0  √  null
CACHE_FLAG varchar2 1

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CACHE_FLAG" IS NOT NULL APSEQ_CACHE_FLAG_NN
"SEQUENCE_NAME" IS NOT NULL APSEQ_SEQUENCE_NAME_NN
RESET_ANUALLY IN ('Y', 'N') CK_APSEQ_RESET_ANUALLY

Indexes:
Column(s) Type Sort Constraint Name
SEQUENCE_NAME Primary key Asc APSEQ_PK
TABLE_NAME Performance Asc APSEQ_AT_FK_I

Close relationships  within of separation: