SchemaSpy - Table slot9.WORLD.TSTA.SCREEN_ITEMS

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

ITEM_ID

number

38

PROFILE_SCREEN_ITEMS.ITEM_ID	PROSI_SCRI_FK R
SCREEN_ITEM_PARAMETERS.ITEM_ID	SCRIP_SCRI_FK R

ITEM_CODE

varchar2

100

DISPLAY_NAME

varchar2

100

AREA_CODE

varchar2

30

EJS_CODES.CODE

SCRI_AC_FK R

AREA_CODE_TYPE

varchar2

30

√

'AREA_CODE_TYPE'

EJS_CODES.CODE_TYPE

SCRI_AC_FK R

DESCRIPTION

varchar2

500

√

null

PERMISSION_ID

number

10

EJS_PERMISSIONS.PERMISSION_ID

SCRI_PID_FK R

MAX_INSTANCES

number

0

1

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
"AREA_CODE" IS NOT NULL	SCRI_AREA_CODE_NN
"DISPLAY_NAME" IS NOT NULL	SCRI_DISPLAY_NAME_NN
"ITEM_CODE" IS NOT NULL	SCRI_ITEM_CODE_NN
"ITEM_ID" IS NOT NULL	SCRI_ITEM_ID_NN
"MAX_INSTANCES" IS NOT NULL	SCRI_MAX_INST_NN
"PERMISSION_ID" IS NOT NULL	SCRI_PERM_ID_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
ITEM_ID	Primary key	Asc	SCRI_PK
AREA_CODE + AREA_CODE_TYPE	Performance	Asc/Asc	SCRI_AC_FK_I
AREA_CODE_TYPE + AREA_CODE	Performance	Asc/Asc	SCRI_EJSCD_AC_FK_I
PERMISSION_ID	Performance	Asc	SCRI_PERM_ID_FK_I