IBM SG24-6320-00 manual Catalog, Database tables

6320ch_application_used.fm		Draft Document for Review July 28, 2004 7:33 pm
	Default Command(s)	Override Command	Description
	TXSearchSampleCmd	N/A	Sample commands
	TXSearchSampleCmdImpl		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.

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-2provides a summary of custom tables that were created for use with the application.

Table 4-2Custom Tables

Table	Description
RURALZIPCODES	Implements dynamic shiprates for FedEx,
SHIPRATE	UPS, USPS. Based on factors such as
SURCHARGE	zipcode, shipping zone, and order weight,
ZIPCODE	the application will deliver real time ship
ZONE	rates to the customer.
XBLOCKIPS	Non-Commerce related tables. Part of
XPOTIPS	external application that records potential
	fraudulent payment transactions.

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.

62Keeping Commerce Applications Updated WebSphere Commerce 5.1 to 5.6 Migration Guide