Table slot9.WORLD.TSTA.APPLICATION_TABLES
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
TABLE_NAME varchar2 40
APPLICATION_COLUMN_AUDITS.TABLE_NAME APPCA_APP_TABLES_FK C
APPLICATION_SEQUENCES.TABLE_NAME APSEQ_AT_FK R
EJS_CODES_EXTRN_MULTI_LINKS.TABLE_NAME EXTRNML_APP_TABLES_FK R
EJS_TABLE_AUDITS.TABLE_NAME ETA_AT_FK C
EJS_XML_DEFAULT_VALUES.TABLE_NAME Implied Constraint R
USER_SCREEN_TYPES.TABLE_NAME USRSCRN_TYP_APP_TABLES_FK R
XML_DOC_APP_TABLES.TABLE_NAME XDAT_AT_FK R
Name of Table/View used by application
APPTABCD_TABLE_TYPE_CODE varchar2 30
EJS_CODES.CODE APP_TABLES_APPTABC_EJS_CODE_FK R
Application Table Type
EXPORT_ORDER number 10  √  null Order of Export
NEW_INSTALL_EXPORT varchar2 1  √  'N' Should be exported for a new install
EJS_VER varchar2 15  √  null EJS Major and Minor Implementation Version
EJS_REL_VER varchar2 30  √  null EJS Release Version of latest update
VIEW_OBJECT varchar2 1  √  'N' Object is a View not a table
NOTES varchar2 2000  √  null Comments on Table or View
APPTABCD_TABLE_TYPE_CODE_TYPE varchar2 30  √  'APPLICATION_TABLE_CODES'
EJS_CODES.CODE_TYPE APP_TABLES_APPTABC_EJS_CODE_FK R
REC_ID number 0  √  null
PRIMARY_KEY_NAME varchar2 255  √  null
PRIMARY_KEY_FORMAT_CODE varchar2 30  √  null
AUDITING_ENABLED_FLAG varchar2 1  √  'N' Turns Auditing on for a specific table. The default is Auditing Off.
AUDIT_CREATE_FLAG varchar2 1  √  'N' Whether or not this table is flagged to be audited on record creation
AUDIT_UPDATE_FLAG varchar2 1  √  'N' Whether or not this table is flagged to be audited upon records being updated
AUDIT_DELETE_FLAG varchar2 1  √  'N' Whether or not this table is flagged to be audited upon records being deleted
AUDIT_ENABLED_FLAG varchar2 1  √  'N' Whether or not this table can be audited by an administrator

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"APPTABCD_TABLE_TYPE_CODE" IS NOT NULL APP_TABLES_APPTABCD_TABLE_T_NN
"TABLE_NAME" IS NOT NULL APP_TABLES_TABLE_NAME_NN
AUDIT_CREATE_FLAG IN ('Y', 'N') CK_APP_TABLES_AUDIT_CREATE
AUDIT_DELETE_FLAG IN ('Y', 'N') CK_APP_TABLES_AUDIT_DELETE
AUDIT_ENABLED_FLAG IN ('Y', 'N') CK_APP_TABLES_AUDIT_ENABLE
AUDITING_ENABLED_FLAG IN ('Y', 'N') CK_APP_TABLES_AUDIT_ENABLE_FLG
AUDIT_UPDATE_FLAG IN ('Y', 'N') CK_APP_TABLES_AUDIT_UPDATE
NEW_INSTALL_EXPORT IN ('Y', 'N') CK_APP_TABLES_NEW_INSTALL_EXPO
VIEW_OBJECT IN ('Y', 'N') CK_APP_TABLES_VIEW_OBJECT

Indexes:
Column(s) Type Sort Constraint Name
TABLE_NAME Primary key Asc APP_TABLES_PK
AUDIT_CREATE_FLAG Performance Asc APP_TABLES_AC_I
AUDIT_DELETE_FLAG Performance Asc APP_TABLES_AD_I
APPTABCD_TABLE_TYPE_CODE_TYPE + APPTABCD_TABLE_TYPE_CODE Performance Asc/Asc APP_TABLES_APPTABC_EJS_CODE_I
AUDIT_ENABLED_FLAG Performance Asc APP_TABLES_APPTABEN_I
AUDIT_UPDATE_FLAG Performance Asc APP_TABLES_AU_I
APPTABCD_TABLE_TYPE_CODE Performance Asc AT_APPTABCD_FK_I

Close relationships  within of separation: