SchemaSpy - Table slot9.WORLD.TSTA.USER_DEFINED_MODULES

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

DATA_ELEMENT

varchar2

20

EJS_XML_DEST_COLUMN_VW.DATA_ELEMENT	Implied Constraint R
USER_DATA_FIELDS.DATA_ELEMENT	UDDF_UDDM_FK R

TITLE

varchar2

60

√

null

WIDTH

number

0

√

null

HEIGHT

number

0

√

null

X_POS

number

0

√

null

Y_POS

number

0

√

null

OK_YN

varchar2

1

√

'N'

CANCEL_YN

varchar2

1

√

'N'

DELETE_YN

varchar2

1

√

'N'

RETURN_YN

varchar2

1

√

'N'

SCROLL_CANVAS

varchar2

1

√

'N'

CREATOR_ID

varchar2

100

√

null

CREATOR_DATE

date

7

√

null

UPDATOR_ID

varchar2

100

√

null

UPDATOR_DATE

date

7

√

null

REC_ID

number

0

√

null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
CANCEL_YN IN ('N', 'Y')	CK_UDDM_CANCEL_YN
DELETE_YN IN ('N', 'Y')	CK_UDDM_DELETE_YN
OK_YN IN ('N', 'Y')	CK_UDDM_OK_YN
RETURN_YN IN ('N', 'Y')	CK_UDDM_RETURN_YN
SCROLL_CANVAS IN ('N', 'Y')	CK_UDDM_SCROLL_CANVAS
"DATA_ELEMENT" IS NOT NULL	UDDM_DATA_ELEMENT_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
DATA_ELEMENT	Primary key	Asc	UDDM_PK