Java Cart .

Java Cart Tables

Notes

To be certain of the most up to date table definitions look at DBUtilControllerServlet, which has complete SQL to create and populate test tables. At this time I have no admin modules to edit the tables on-line, so you can't update or even view inventory, but that would be necessary for a finished system.

Category

Categories, descriptions, and the parent category.

Item

Information about an individual item.

ItemSizeColor

Additonal item information if an item has a size and/or color.

ItemCategory

What item is in what category. An item can be in multiple categories.

ItemInventory

Inventory information for items with inventory.

ItemGroup

What group an item is in, for items in groups.
Groups are designed to be used to have similar items, such as hats of the same style but different colors, stored as their own items with different inventories or pricing, and yet can be presented to the customer together as if they were the same item.
Comments
Sign in to be the first to comment on Java Cart Tables.