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 |