Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CATENTRY
This table hold the information related to a catalog entry. Examples of catalog entries include products, items, packages, and bundles.
Column Name Column Type Description CATENTRY_ID BIGINT NOT NULL The internal reference number of the catalog entry. MEMBER_ID BIGINT NOT NULL The reference number that identifies the owner of the catalog entry. Along with the PARTNUMBER, these columns are a unique index. ITEMSPC_ID BIGINT The specified item that this catalog entry relates to. This column should only be populated for catalog entries that are of type "ItemBean", "PackageBean", or "DynamicKitBean". Specified items are used for fulfillment. CATENTTYPE_ID CHAR(16) NOT NULL Identifies the type of catalog entry. Foreign key to the CATENTTYPE table. The supported default types are: ProductBean, ItemBean, PackageBean, BundleBean and DynamicKitBean. PARTNUMBER VARCHAR(64) NOT NULL The reference number that identifies the part number of the catalog entry. Along with the MEMBER_ID, these columns are a unique index. MFPARTNUMBER VARCHAR(64) The part number used by the manufacturer to identify this catalog entry. MFNAME VARCHAR(64) The name of the manufacturer of this catalog entry. MARKFORDELETE INTEGER NOT NULL Indicates if this catalog entry has been marked for deletion:
0 = No.
1 = Yes.URL VARCHAR(254) The URL to this catalog entry, which can be used as a download URL for soft goods. FIELD1 INTEGER Customizable. FIELD2 INTEGER Customizable. LASTUPDATE TIMESTAMP Indicates the last time the catalog entry was updated. FIELD3 DECIMAL (20,5) Customizable. ONSPECIAL INTEGER This flag identifies if this catalog entry is on special. ONAUCTION INTEGER This flag identifies if this catalog entry is on auction. FIELD4 VARCHAR(254) Customizable. FIELD5 VARCHAR(254) Customizable. BUYABLE INTEGER Indicates whether this catalog entry can be purchased individually: 1=yes and 0=no. OID VARCHAR(64) Reserved for IBM internal use. BASEITEM_ID BIGINT The base item to which this catalog entry relates. This column should only be populated for catalog entries that are of type ProductBean, PackageBean or DynamicKitBean. Base items are used for fulfillment. STATE CHAR(1) DEFAULT '1' Reserved for IBM internal use. STARTDATE TIMESTAMP The date when this catalog entry is introduced. This column is for the interpretation and information only. ENDDATE TIMESTAMP The date when this catalog entry is withdrawn. This column is for the interpretation and information only. RANK DOUBLE Reserved for IBM internal use. OPTCOUNTER SMALLINT Reserved for IBM internal use. AVAILABILITYDATE TIMESTAMP The date that the product is available to customers for purchase. This column is for the interpretation and information only. LASTORDERDATE TIMESTAMP The final date that the product is available for order. This is the latest date a customer can order the product. This column is for the interpretation and information only. ENDOFSERVICEDATE TIMESTAMP The date when the product is no longer in service. For example, this date can be the date that a software manufacturer stops providing upgrades for a version of their product. This column is for the interpretation and information only. DISCONTINUEDATE TIMESTAMP The date when the product is discontinued. For example, this date can be the date the manufacturer stops producing the product, or the date the store stops selling the product. IBM recommends that this column be used consistently to avoid confusion. This column is for the interpretation and information only.
Indexes Index Name Indexed Column Names Index Type I0000064 PARTNUMBER+MEMBER_ID Unique Index SQL100520030311040 CATENTRY_ID Primary Key I0000065 CATENTRY_ID+MARKFORDELETE Non-Unique Index I0000305 BUYABLE+CATENTRY_ID+CATENTTYPE_ID Non-Unique Index I0000375 RANK Non-Unique Index I0000518 CATENTTYPE_ID Non-Unique Index I0000519 MEMBER_ID Non-Unique Index I263103 CATENTRY_ID+CATENTTYPE_ID Non-Unique Index I263121 ITEMSPC_ID Non-Unique Index I263122 BASEITEM_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_202 BASEITEM_ID BASEITEM BASEITEM_ID Cascade F_204 CATENTTYPE_ID CATENTTYPE CATENTTYPE_ID Cascade F_201 ITEMSPC_ID ITEMSPC ITEMSPC_ID Cascade F_203 MEMBER_ID MEMBER MEMBER_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_69 CATENTRY_ID ATTRIBUTE CATENTRY_ID Cascade F_74 CATENTRY_ID ATTRVALUE CATENTRY_ID Cascade F_83 CATENTRY_ID AUCTION CATENTRY_ID Cascade 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_PARENT CATENTREL CATENTRY_ID Cascade F_200 CATENTRY_ID_CHILD CATENTREL CATENTRY_ID Cascade F_3566 CATENTRY_ID CATENTRYATTR CATENTRY_ID 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_1156 CATENTRY_ID DKADJMNT CATENTRY_ID Cascade F_1155 KIT_ID DKADJMNT CATENTRY_ID Cascade F_1152 CATENTRY_ID DKOFFER CATENTRY_ID Cascade F_1151 KIT_ID DKOFFER CATENTRY_ID Cascade F_1185 CATENTRY_ID DKPDCCATENTREL CATENTRY_ID Cascade F_1182 CATENTRY_ID DKPDCCOMPLIST CATENTRY_ID Cascade F_1061 CATENTRY_ID DKPDCREL CATENTRY_ID Cascade F_378 CATENTRY_ID ICTPRICES CATENTRY_ID Cascade F_382 CATENTRY_ID IITEM CATENTRY_ID Cascade F_3622 CATENTRY_ID INSRULECATENT CATENTRY_ID Cascade F_3581 CATENTRY_ID INVAVL CATENTRY_ID Cascade F_3586 CATENTRY_ID INVCNFREL CATENTRY_ID Cascade F_395 CATENTRY_ID INVENTORY CATENTRY_ID Cascade F_419 CATENTRY_ID LISTPRICE CATENTRY_ID Cascade F_431 CATENTRY_ID_FROM MASSOCCECE CATENTRY_ID Cascade F_432 CATENTRY_ID_TO MASSOCCECE CATENTRY_ID 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_ITEM PKGITEMREL CATENTRY_ID Cascade F_595 CATENTRY_ID_PKG PKGITEMREL CATENTRY_ID Cascade F_596 CATENTRY_ID_PARENT PKGITEMREL CATENTRY_ID 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_708 CATENTRY_ID RMAITEM CATENTRY_ID Cascade F_714 CATENTRY_ID RMAITEMCMP CATENTRY_ID Cascade F_781 CATENTRY_ID STORECENT CATENTRY_ID Cascade
Related reference
- Order trading agreement data model
- Attribute data model
- Messaging extension data model
- Dynamic kit data model
- User traffic data model
- Order management - RMAitem data model
- Order item data model
- Order item - allocated data model
- Order item - backordered data model
- Package data model
- Product Advisor data model
- Interest item data model
- Merchandising association data model
- Offers data model
- Catalog data model
- Catalog entry data model
- Catalog group data model
- E-coupon data model
- Fulfillment data model
- Auction data model
- Calculation code - indirect attachment data model
- Request for Quote (RFQ) data model
_vcc_freeselect_bottom_