| West Wind Web Store |
Web Store Database Structure
|
| Table | Description |
|---|---|
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. |