SchemaSpy - Table slot9.WORLD.TSTA.ITEM_INSPECTION_ITEMS

This table stores the inventory items inspected during an inspection run in the application

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

INSPECTION_RUN_ID

number

38

ITEM_INSPECTION_RUNS.INSPECTION_RUN_ID

Implied Constraint R

INSTANCE_ID

number

38

INC_REVIEW_ROUTE_INSTANCES.INSTANCE_ID

Implied Constraint R

LOT_NUMBER

varchar2

50

√

null

STATUS_CODE

varchar2

30

EJS_CODES.CODE

ITINSPI_EJSCD_STATCD_FK R

STATUS_CODE_TYPE

varchar2

30

EJS_CODES.CODE_TYPE

ITINSPI_EJSCD_STATCD_FK R

USABILITY_CODE

varchar2

30

EJS_CODES.CODE

ITINSPI_EJSCD_USABCD_FK R

USABILITY_CODE_TYPE

varchar2

30

EJS_CODES.CODE_TYPE

ITINSPI_EJSCD_USABCD_FK R

EXPIRATION_DATE

date

7

√

null

SERIALIZED_HINT_FLAG

varchar2

1

√

'N'

LOCATION_ID

number

0

√

null

ITEM_LOCATIONS.LOCATION_ID

ITINSPI_ITLC_FK R

SUB_LOCATION_ID

number

0

√

null

ITEM_SUB_LOCATIONS.SUB_LOCATION_ID

ITINSPI_ITSLC_FK R

ORGANIZATION_ID

number

0

√

null

ITEM_ORGANIZATIONS.ORGANIZATION_ID

ITINSPI_ITOR_FK R

EMPLOYEE_ID

number

30

√

null

EMPLOYEES.EJS_EMP_ID

ITINSPI_EMP1_FK R

OFFICER_ID

number

0

√

null

OFFICERS.OFFICER_ID

ITINSPI_OFF1_FK R

CUSTODY_ORDER_ID

number

0

√

null

ITEM_ORDERS.ORDER_ID

ITINSPI_ITORD_FK R

PARENT_INSTANCE_ID

number

0

√

null

CREATOR_ID

varchar2

100

√

null

CREATOR_DATE

date

7

√

null

UPDATOR_ID

varchar2

100

√

null

UPDATOR_DATE

date

7

√

null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
SERIALIZED_HINT_FLAG IN ('Y', 'N')	CK_ITINSPI_HINT_FLAG
"INSPECTION_RUN_ID" IS NOT NULL	ITINSPI_INSP_RID_NN
"INSTANCE_ID" IS NOT NULL	ITINSPI_INST_ID_NN
"STATUS_CODE" IS NOT NULL	ITINSPI_STAT_CD_NN
"STATUS_CODE_TYPE" IS NOT NULL	ITINSPI_STAT_CD_TYP_NN
"USABILITY_CODE" IS NOT NULL	ITINSPI_USA_CD_NN
"USABILITY_CODE_TYPE" IS NOT NULL	ITINSPI_USA_CD_TYP_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
INSPECTION_RUN_ID + INSTANCE_ID	Primary key	Asc/Asc	ITINSPI_PK
STATUS_CODE_TYPE + STATUS_CODE	Performance	Asc/Asc	ITINSPI_EJSCD_STATCD_FK_I
USABILITY_CODE_TYPE + USABILITY_CODE	Performance	Asc/Asc	ITINSPI_EJSCD_USABCD_FK_I
EMPLOYEE_ID	Performance	Asc	ITINSPI_EMP1_I
INSPECTION_RUN_ID	Performance	Asc	ITINSPI_INSPECT_RUNID_I
INSTANCE_ID	Performance	Asc	ITINSPI_INSTANCE_ID_I
LOCATION_ID	Performance	Asc	ITINSPI_ITLC_FK_I
ORGANIZATION_ID	Performance	Asc	ITINSPI_ITOR_FK_I
CUSTODY_ORDER_ID	Performance	Asc	ITINSPI_ITORD_FK_I
SUB_LOCATION_ID	Performance	Asc	ITINSPI_ITSLC_FK_I
OFFICER_ID	Performance	Asc	ITINSPI_OFF1_I
PARENT_INSTANCE_ID	Performance	Asc	ITINSPI_PAR_ID_I