Database Table: CATENTRY

This table hold the information related to a CatalogEntry. Examples of CatalogEntries include Products, Items, Packages, and Bundles.

Column Name Column Type Column Description
BASEITEM_ID BIGINT
NULL
The BaseItem that this CatalogEntry relates to. This column should only be populated for CatalogEntries that are of type "ProductBean" or "PackageBean". BaseItems are used for fulfillment.
BUYABLE INTEGER
NULL
Indicates whether this CatalogEntry can be purchased individually: 1=yes and 0=no.
CATENTRY_ID BIGINT
NOT NULL
The internal reference number of the CatalogEntry.
CATENTTYPE_ID CHARACTER (16)
NOT NULL
Identifies the type of CatalogEntry. Foreign key to the CATENTTYPE table. The supported default types are: ProductBean, ItemBean, PackageBean, BundleBean and DynamicKitBean.
ENDDATE TIMESTAMP
NULL
The date when this catalog entry is withdrawn.
FIELD1 INTEGER
NULL
Customizable.
FIELD2 INTEGER
NULL
Customizable.
FIELD3 DECIMAL (20,5)
NULL
Customizable.
FIELD4 VARCHAR (254)
NULL
Customizable.
FIELD5 VARCHAR (254)
NULL
Customizable.
ITEMSPC_ID BIGINT
NULL
The SpecifiedItem that this CatalogEntry relates to. This column should only be populated for CatalogEntries that are of type "ItemBean", "PackageBean", or "DynamicKitBean". SpecifiedItems are used for fulfillment.
LASTUPDATE TIMESTAMP
NULL
Indicates the last time the CatalogEntry was updated.
MARKFORDELETE INTEGER
NOT NULL
Indicates if this CatalogEntry has been marked for deletion:
0 = No.
1 = Yes.
MEMBER_ID BIGINT
NOT NULL
The reference number that identifies the owner of the CatalogEntry. Along with the PARTNUMBER, these columns are a unique index.
MFNAME VARCHAR (64)
NULL
The name of the manufacturer of this CatalogEntry.
MFPARTNUMBER VARCHAR (64)
NULL
The part number used by the manufacturer to identify this CatalogEntry.
OID VARCHAR (64)
NULL
Reserved for IBM internal use.
ONAUCTION INTEGER
NULL
This flag identifies if this CatalogEntry is on auction.
ONSPECIAL INTEGER
NULL
This flag identifies if this CatalogEntry is on special.
PARTNUMBER VARCHAR (64)
NOT NULL
The reference number that identifies the part number of the CatalogEntry. Along with the MEMBER_ID, these columns are a unique index.
STARTDATE TIMESTAMP
NULL
The date when this catalog entry is introduced.
STATE CHARACTER (1)
NULL, DEFAULT '1'
Reserved for IBM internal use.
URL VARCHAR (254)
NULL
The URL to this CatalogEntry, which can be used as a download URL for soft goods.
Indexes:
Index Name Indexed Column Names Index Type
I0000064 PARTNUMBER, MEMBER_ID Unique Index
I0000065 CATENTRY_ID, MARKFORDELETE Non-Unique Index
I0000305 BUYABLE, CATENTRY_ID, CATENTTYPE_ID Non-Unique Index
I263103 CATENTRY_ID, CATENTTYPE_ID Non-Unique Index
I263121 ITEMSPC_ID Non-Unique Index
I263122 BASEITEM_ID Non-Unique Index
SQL030416034900700 CATENTRY_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_201 ITEMSPC_ID ITEMSPC ITEMSPC_ID Cascade
F_202 BASEITEM_ID BASEITEM BASEITEM_ID Cascade
F_203 MEMBER_ID MEMBER MEMBER_ID Cascade
F_204 CATENTTYPE_ID CATENTTYPE CATENTTYPE_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_186 CATENTRY_ID CATCLSFCOD CATENTRY_ID Cascade
F_189 CATENTRY_ID CATCONFINF CATENTRY_ID Cascade
F_192 CATENTRY_ID CATENCALCD CATENTRY_ID Cascade
F_194 CATENTRY_ID CATENTATTR CATENTRY_ID Cascade
F_196 CATENTRY_ID CATENTDESC CATENTRY_ID Cascade
F_199 CATENTRY_ID CATENTREL CATENTRY_ID_PARENT Cascade
F_200 CATENTRY_ID CATENTREL CATENTRY_ID_CHILD Cascade
F_205 CATENTRY_ID CATENTSHIP CATENTRY_ID Cascade
F_214 CATENTRY_ID CATGPENREL CATENTRY_ID Cascade
F_274 CATENTRY_ID CPPMNPROD CATENTRY_ID Cascade
F_303 CATENTRY_ID DISPENTREL CATENTRY_ID Cascade
F_378 CATENTRY_ID ICTPRICES CATENTRY_ID Cascade
F_382 CATENTRY_ID IITEM CATENTRY_ID Cascade
F_395 CATENTRY_ID INVENTORY CATENTRY_ID Cascade
F_419 CATENTRY_ID LISTPRICE CATENTRY_ID Cascade
F_431 CATENTRY_ID MASSOCCECE CATENTRY_ID_FROM Cascade
F_432 CATENTRY_ID MASSOCCECE CATENTRY_ID_TO Cascade
F_468 CATENTRY_ID OFFER CATENTRY_ID Cascade
F_475 CATENTRY_ID OICOMPLIST CATENTRY_ID Cascade
F_505 CATENTRY_ID ORDERITEMS CATENTRY_ID Cascade
F_568 CATENTRY_ID PATTRPROD CATENTRY_ID Cascade
F_588 CATENTRY_ID PKGATTR CATENTRY_ID Cascade
F_592 CATENTRY_ID PKGATTRVAL CATENTRY_ID Cascade
F_594 CATENTRY_ID PKGITEMREL CATENTRY_ID_ITEM Cascade
F_595 CATENTRY_ID PKGITEMREL CATENTRY_ID_PKG Cascade
F_596 CATENTRY_ID PKGITEMREL CATENTRY_ID_PARENT Cascade
F_629 CATENTRY_ID PRSETCEREL CATENTRY_ID Cascade
F_630 CATENTRY_ID PURCHASELT CATENTRY_ID Cascade
F_681 CATENTRY_ID RFQPROD CATENTRY_ID Cascade
F_686 CATENTRY_ID RFQRSPPROD CATENTRY_ID Cascade
F_69 CATENTRY_ID ATTRIBUTE CATENTRY_ID Cascade
F_708 CATENTRY_ID RMAITEM CATENTRY_ID Cascade
F_714 CATENTRY_ID RMAITEMCMP CATENTRY_ID Cascade
F_74 CATENTRY_ID ATTRVALUE CATENTRY_ID Cascade
F_781 CATENTRY_ID STORECENT CATENTRY_ID Cascade
F_83 CATENTRY_ID AUCTION CATENTRY_ID Cascade
F_938 CATENTRY_ID USRTRAFFIC CATENTRY_ID Cascade