SchemaSpy - Table slot9.WORLD.TSTA.AUDIT_ACTION_CODES

Legacy table. 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

ACTION_CODE

varchar2

3

EJS_AUDITS.ACTION_CODE

EJSA_AAC_FK R

DESCRIPTION

varchar2

255

√

null

NAME

varchar2

30

EJS_AUDITS.NAME

EJSA_AAC_FK R

INSTALL_SUBSYSTEMS.NAME

AAC_IS_FK R

APPLICATION

varchar2

15

EJS_AUDITS.APPLICATION

EJSA_AAC_FK R

INSTALL_SUBSYSTEMS.INSTALL_APPLICATION

AAC_IS_FK R

Name of Application

REC_ID

number

0

√

null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
"ACTION_CODE" IS NOT NULL	AAC_ACTION_CODE_NN
"APPLICATION" IS NOT NULL	AAC_APPLICATION_NN
"NAME" IS NOT NULL	AAC_NAME_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
ACTION_CODE + NAME + APPLICATION	Primary key	Asc/Asc/Asc	AAC_PK
NAME + APPLICATION	Performance	Asc/Asc	AAC_IS_FK_I