Item_collections

This table includes data related to the Item Collection record, which represents an individual item collection.
This table contains the names and descriptions of item collections only. Items contained in the item collections are captured in the Item_collection_item_map table.

Columns

Name Type Length Precision Scale References In Description
description VARCHAR2 2000 Description of the item collection
is_inactive VARCHAR2 3 Whether item collection is inactive
item_collection_extid VARCHAR2 255 Item collection external ID
item_collection_id NUMBER 39 0 Item collection ID
name VARCHAR2 200 Name of the item collection

Primary key

PK Column Name
item_collection_id

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Item_collection_item_map_item_collections_fk item_collection_id Item_collection_item_map item_collection_id 1