Filter
Top Products
6320ch_application_used.fm Draft Document for Review July 28, 2004 7:33 pm
62 Keeping Commerce Applications Updated WebSphere Commerce 5.1 to 5.6 Migration Guide
4.2.3 Database tables
Custom tables were added to increase functionality. Tables were added to
implement dynamic shiprates. Other tables were added to store potential
fraudulent payment transactions.Table 4-2 provides a summary of custom tables
that were created for use with the application.
Table 4-2 Custom Tables
4.3 Catalog
The product catalog includes all the items sold on Carrotink.com. The catalog
contains the hierarchy for categories with the items being associated with the
bottom level category. The top categories are the printer brand. The
subcategories are the printer models. Some items have a 1:1 relation with their
parent category while other items have a 1:M (1 to many) relationship. This 1:M
relationship is due to the fact that one ink jet cartridge can work with different
printers.
TXSearchSampleCmd
TXSearchSampleCmdImpl
N/A Sample commands
provided by IBM for use
with the DB2 Text
Extender. The controller
command generates a
SQL statement that is
then used to query the
database to return search
results.
Default Command(s) Override Command Description
Table Description
RURALZIPCODES
SHIPRATE
SURCHARGE
ZIPCODE
ZONE
Implements dynamic shiprates for FedEx,
UPS, USPS. Based on factors such as
zipcode, shipping zone, and order weight,
the application will deliver real time ship
rates to the customer.
XBLOCKIPS
XPOTIPS
Non-Commerce related tables. Part of
external application that records potential
fraudulent payment transactions.