SchemaSpy - Table slot9.WORLD.TSTA.USER_LOV_CODES

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

CODE

varchar2

10

EXTERNAL_SYSTEM_CODES.CODE

Implied Constraint R

DESCRIPTION

varchar2

40

√

null

ULTC_TYPE_CODE

varchar2

30

EJS_CODES.CODE

ULOV_ULTC_TYPE_COD_EJS_CODE_FK R

ACTIVE

varchar2

1

√

'N'

CREATOR_ID

varchar2

100

√

null

CREATOR_DATE

date

7

√

null

UPDATOR_DATE

date

7

√

null

UPDATOR_ID

varchar2

100

√

null

COMMENTS

varchar2

255

√

null

ULTC_TYPE_CODE_TYPE

varchar2

30

√

'USER_LOV_TYPE_CODES'

EJS_CODES.CODE_TYPE

ULOV_ULTC_TYPE_COD_EJS_CODE_FK R

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_ULOV_ACTIVE
"CODE" IS NOT NULL	ULOV_CODE_NN
"ULTC_TYPE_CODE" IS NOT NULL	ULOV_ULTC_TYPE_CODE_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
ULTC_TYPE_CODE + CODE	Primary key	Asc/Asc	ULOV_PK
ULTC_TYPE_CODE	Performance	Asc	ULOV_ULTC_FK_I
ULTC_TYPE_CODE_TYPE + ULTC_TYPE_CODE	Performance	Asc/Asc	ULOV_ULTC_TYPE_COD_EJS_CODE_I