SchemaSpy - Table slot9.WORLD.TSTA.ITEM

This table stores the description information for inventory items added in the application. When adding multiple items in bulk, one descriptor row is created and linked to all the inventory item instances

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

DESCRIPTOR_ID

number

ITEM_DESCRIPTOR_LOCATIONS.DESCRIPTOR_ID	IDL_ITDS_FK R
ITEM_GUN_DESCRIPTORS.DESCRIPTOR_ID	ITGS_ITDS_FK R
ITEM_INSTANCES.DESCRIPTOR_ID	ITII_ITDS_FK R

CATEGORY_ID

number

ITEM_CATEGORY_CODES.CATEGORY_ID

ITDS_ICC_FK R

AGENCY_CODE

varchar2

AGENCY_CODES.AGENCY_CODE

ITDS_AGNCY_CD_FK R

GROUP_NUMBER

varchar2

255

√

null

GROUP_FLAG

varchar2

√

'N'

ITEM_NUMBER

varchar2

255

√

null

MAKE_ID

number

√

null

ITEM_MAKE_CODES.MAKE_ID

ITDS_ITMK_FK R

MODEL_ID

number

√

null

ITEM_MODEL_CODES.MODEL_ID

ITDS_ITMO_FK R

SIZE_ID

number

√

null

ITEM_SIZE_CODES.SIZE_ID

ITDS_ITSZ_FK R

LINE_ID

number

√

null

ITEM_LINE_CODES.LINE_ID

ITDS_ITLN_FK R

COLOR_CODE

varchar2

√

null

EJS_CODES.CODE

ITDS_EJSCD_COLOR_FK R

COLOR_CODE_TYPE

varchar2

√

null

EJS_CODES.CODE_TYPE

ITDS_EJSCD_COLOR_FK R

SEC_COLOR_CODE

varchar2

√

null

EJS_CODES.CODE

ITDS_EJSCD_SECCLRCD_FK R

SEC_COLOR_CODE_TYPE

varchar2

√

null

EJS_CODES.CODE_TYPE

ITDS_EJSCD_SECCLRCD_FK R

DESCRIPTION

varchar2

500

√

null

SELF_CHECKOUT_FLAG

varchar2

√

'N'

CONSUMABLE_FLAG

varchar2

√

'N'

SERVICE_LIFE_MONTHS

number

√

null

SERVICE_LIFE_YEARS

number

√

null

QUANTITY_ID

number

√

null

ITEM_QUANTITY_CODES.QUANTITY_ID

ITDS_IQC_FK R

QUANTITY_AMOUNT

number

36,2

√

null

SUB_QUANTITY_ID

number

√

null

ITEM_QUANTITY_CODES.QUANTITY_ID

ITDS_IQC_SUB_FK R

SUB_QUANTITY_AMOUNT

number

36,2

√

null

CREATOR_ID

varchar2

100

√

null

CREATOR_DATE

date

√

null

UPDATOR_ID

varchar2

100

√

null

UPDATOR_DATE

date

√

null

REC_ID

number

√

null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
CONSUMABLE_FLAG IN ('Y', 'N')	CK_ITDS_CONSUM_FLAG
GROUP_FLAG IN ('Y', 'N')	CK_ITDS_GROUP_FLAG
SELF_CHECKOUT_FLAG IN ('Y', 'N')	CK_ITDS_SELF_CO_FLG
"AGENCY_CODE" IS NOT NULL	ITDS_AGENCY_CD_NN
"CATEGORY_ID" IS NOT NULL	ITDS_CAT_ID_NN
"DESCRIPTOR_ID" IS NOT NULL	ITDS_DESC_ID_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
DESCRIPTOR_ID	Primary key	Asc	ITDS_PK
AGENCY_CODE	Performance	Asc	ITDS_AGNCY_CD_FK_I
CONSUMABLE_FLAG	Performance	Asc	ITDS_CONSUM_FLG_I
COLOR_CODE_TYPE + COLOR_CODE	Performance	Asc/Asc	ITDS_EJSCD_COLOR_FK_I
SEC_COLOR_CODE_TYPE + SEC_COLOR_CODE	Performance	Asc/Asc	ITDS_EJSCD_SECCLRCD_FK_I
GROUP_FLAG	Performance	Asc	ITDS_GRP_FLG_I
CATEGORY_ID	Performance	Asc	ITDS_ICC_FK_I
QUANTITY_ID	Performance	Asc	ITDS_IQC_FK_I
SUB_QUANTITY_ID	Performance	Asc	ITDS_IQC_SUB_FK_I
ITEM_NUMBER	Performance	Asc	ITDS_ITEM_NUM_I
LINE_ID	Performance	Asc	ITDS_ITLN_FK_I
MAKE_ID	Performance	Asc	ITDS_ITMK_FK_I
MODEL_ID	Performance	Asc	ITDS_ITMO_FK_I
SIZE_ID	Performance	Asc	ITDS_ITSZ_FK_I