Item_collection_item_map

This table includes data related to the Item Collection Item Map record, which maps items to the item collection they belong to.
The Item_collections table contains details of the item collections.
The mapping between item collections and the items they contain is done using the item_collection_id column.

Columns

Name Type Length Precision Scale References In Description
item_collection_id NUMBER 39 0 item_collection_id
Item_collections
Item collection ID from the item_collection table
item_collection_item_map_id NUMBER 39 0 Unique identifier of the Item to Item Collection relationship/assignment
item_id NUMBER 39 0 item_id
Items
Item ID of an item in the item collection
item_map_extid VARCHAR2 255 External identifier of the Item to Item Collection relationship/assignment

Primary key

PK Column Name
item_collection_item_map_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
item_collection_item_map_item_collections_fk item_collection_id Item_collections item_collection_id 1
item_collection_item_map_items_fk item_id Items item_id 1