SchemaSpy - Table slot9.WORLD.TSTA.USER_DATA_FIELDS

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_TAG_NAMES.DATA_ELEMENT	EXTN_UDDF_FK R
USER_DEFINED_DATA.DATA_ELEMENT	UDDE_UDDF_FK R

USER_DEFINED_MODULES.DATA_ELEMENT

UDDF_UDDM_FK R

FIELD_NAME

varchar2

20

EJS_XML_TAG_NAMES.FIELD_NAME	EXTN_UDDF_FK R
USER_DEFINED_DATA.FIELD_NAME	UDDE_UDDF_FK R

DATA_TYPE

varchar2

20

√

null

NAV_ORDER

number

0

√

null

PROMPT

varchar2

20

√

null

WIDTH

number

0

√

null

HEIGHT

number

0

√

null

X_POSITION

number

0

√

null

Y_POSITION

number

0

√

null

ULTC_TYPE_CODE

varchar2

30

√

null

EJS_CODES.CODE

UDDF_ULTC_TYPE_COD_EJS_CODE_FK R

VALIDATE_LOV_YN

varchar2

1

√

'N'

UPPERCASE_YN

varchar2

1

√

'N'

FORMAT_MASK

varchar2

40

√

null

INITIAL_VALUE

varchar2

255

√

null

ACTIVE_YN

varchar2

1

√

'Y'

CREATOR_DATE

date

7

√

null

CREATOR_ID

varchar2

100

√

null

UPDATOR_DATE

date

7

√

null

UPDATOR_ID

varchar2

100

√

null

ULTC_TYPE_CODE_TYPE

varchar2

30

√

null

EJS_CODES.CODE_TYPE

UDDF_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_YN IN ('Y', 'N')	CK_UDDF_ACTIVE_YN
UPPERCASE_YN IN ('Y', 'N')	CK_UDDF_UPPERCASE_YN
VALIDATE_LOV_YN IN ('N', 'Y')	CK_UDDF_VALIDATE_LOV_YN
"DATA_ELEMENT" IS NOT NULL	UDDF_DATA_ELEMENT_NN
"FIELD_NAME" IS NOT NULL	UDDF_FIELD_NAME_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
FIELD_NAME + DATA_ELEMENT	Primary key	Asc/Asc	UDDF_PK
DATA_ELEMENT	Performance	Asc	UDDF_UDDM_FK_I
ULTC_TYPE_CODE	Performance	Asc	UDDF_ULTC_FK_I
ULTC_TYPE_CODE_TYPE + ULTC_TYPE_CODE	Performance	Asc/Asc	UDDF_ULTC_TYPE_COD_EJS_CODE_I