The structure of these database tables maps directly the oData member of the respective business objects.

TableDescription
wws_customers The master customer table that holds all information about visitors. The Customer table is also used for profile management of users on the site, so temporary visitors get temporary customer records.
wws_id This table holds a tablename and ID value that is incremented whenever a new id is requested using a stored procedure. This mechanism is used to allow PKs to be created without inserting data into a table and read that PK back easily.
wws_invoice The invoice table acts as an invoice header. It has links to the Customer table and lineitems.
wws_items The inventory table holds all product information as well as some processing information such as discounts and commission values.
wws_lineitems The lineitem detail table that is related to the invoice.
wws_lookups Generic overloaded lookup table. Table currently holds the list of countries/countrycode and the store's categories. Overloading is done on the TYPE field.
wws_tlineitems The temporary lineitems table. This table is used only on the Web for items added before an invoice is created. Items are added here and then discarded when the 'real' invoice is created.


Last Updated: 6/13/2003