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 |