SchemaSpy - Table slot9.WORLD.TSTA.REPORT_PARAMETER_INSTANCES

Administration table used for reporting

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

INSTANCE_ID

number

0

PARAMETER_INSTANCE_ATTRIBUTES.INSTANCE_ID	RPTPIA_RINST_FK C
REPORT_PARAMETER_INSTANCES.PARENT_INSTANCE_ID	RPI_PARENT_ID_FK R

ITEM_INSTANCES.INSTANCE_ID

Implied Constraint R

PARAMETER_GROUP_ID

number

0

REPORT_PARAMETER_GROUPS.PARAMETER_GROUP_ID

RPINST_RPG_FK C

DISPLAY_INDEX

number

0

LABEL

varchar2

100

√

null

JASPER_NAME

varchar2

100

√

null

REQUIRED

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

NAME

varchar2

100

√

null

DESCRIPTION

varchar2

500

√

null

JAVA_TYPE_ID

number

0

REPORT_JAVA_TYPES.JAVA_TYPE_ID

RPI_RJT_FK R

TYPE_CODE

varchar2

30

EJS_CODES.CODE

RPI_TCT_FK R

TYPE_CODE_TYPE

varchar2

30

EJS_CODES.CODE_TYPE

RPI_TCT_FK R

STORED_PROCEDURE_ID

number

0

√

null

REPORT_STORED_PROCEDURES.STORED_PROCEDURE_ID

RPI_STORED_FK R

PARAMETER_LIST_ID

number

0

√

null

REPORT_PARAMETER_LISTS.PARAMETER_LIST_ID

RPI_LIST_ID_FK R

SOURCE_CODE_TYPE

varchar2

30

√

null

ALLOW_ALL

varchar2

1

√

'N'

PARENT_INSTANCE_ID

number

0

√

null

REPORT_PARAMETER_INSTANCES.INSTANCE_ID

RPI_PARENT_ID_FK R

DEFAULT_VALUE

varchar2

100

√

null

SEND_ALL_FLAG

varchar2

1

√

'N'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
REQUIRED IN ( 'Y','N')	CK_RPINST_REQUIRED
SEND_ALL_FLAG IN ( 'Y','N')	CK_RPINST_SEND_ALL_FLAG
"DISPLAY_INDEX" IS NOT NULL	RPINST_DISPLAY_INDEX_NN
"INSTANCE_ID" IS NOT NULL	RPINST_INSTANCE_ID_NN
"PARAMETER_GROUP_ID" IS NOT NULL	RPINST_PARAM_GROUP_ID_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
INSTANCE_ID	Primary key	Asc	RPINST_PK
TYPE_CODE_TYPE + TYPE_CODE	Performance	Asc/Asc	RPINST_EJSCD_FK_I
JAVA_TYPE_ID	Performance	Asc	RPINST_RJT_FK_I
PARAMETER_GROUP_ID	Performance	Asc	RPINST_RPG_FK_I
PARENT_INSTANCE_ID	Performance	Asc	RPINST_RPINST_FK_I
PARAMETER_LIST_ID	Performance	Asc	RPINST_RPL_FK_I
STORED_PROCEDURE_ID	Performance	Asc	RPINST_RSPROC_FK_I