SchemaSpy - Table slot9.WORLD.TSTA.EJS_AUDITS

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

DETAILS

varchar2

255

√

null

MODULE

varchar2

255

√

null

CREATOR_ID

varchar2

100

CREATOR_DATE_TIME

date

7

ACTION_CODE

varchar2

3

AUDIT_ACTION_CODES.ACTION_CODE

EJSA_AAC_FK R

NAME

varchar2

30

AUDIT_ACTION_CODES.NAME

EJSA_AAC_FK R

APPLICATION

varchar2

15

AUDIT_ACTION_CODES.APPLICATION

EJSA_AAC_FK R

Name of Application

REC_ID

number

0

√

null

AUDIT_DATE

date

7

√

null

TABLE_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	EJSA_ACTION_CODE_NN
"APPLICATION" IS NOT NULL	EJSA_APPLICATION_NN
"CREATOR_DATE_TIME" IS NOT NULL	EJSA_CREATOR_DATE_TIME_NN
"CREATOR_ID" IS NOT NULL	EJSA_CREATOR_ID_NN
"NAME" IS NOT NULL	EJSA_NAME_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
CREATOR_ID + CREATOR_DATE_TIME + ACTION_CODE + NAME + APPLICATION	Primary key	Asc/Asc/Asc/Asc/Asc	EJSA_PK
ACTION_CODE + NAME + APPLICATION	Performance	Asc/Asc/Asc	EJSA_AAC_FK_I