this schema structures the XML representatation of the evisioner shopping cart, catalog, and order. Catalog are named, viewable components in a hierarchy. Each Catalog holds its children Catalogs and a flat collection of CatalogItem.<p> -----------------------------------------------------<br> xDoclet mapping generation instructions<br> -----------------------------------------------------<br> @castor:class id="id" table="CATALOG" id-type="string" @castor:class field-name="id" field-type="string" sql-name="ID" sql-type="char" method-name="Id" @castor:class field-name="parent_id" field-type="string" sql-name="PARENT_ID" sql-type="char" method-name="Parent_id" @castor:class field-name="catalogItem" field-type="com.evisioner.commerce.CatalogItem" collection="vector" many-key="catalog_id" method-name="CatalogItem" @castor:class field-name="name" field-type="string" sql-name="NAME" sql-type="char" method-name="Name" @castor:class field-name="nickname" field-type="string" sql-name="NICKNAME" sql-type="char" method-name="Nickname" @castor:class field-name="description" field-type="string" sql-name="DESCRIPTION" sql-type="char" method-name="Description" @castor:class field-name="img" field-type="string" sql-name="IMG" sql-type="char" method-name="img" @castor:class field-name="color" field-type="string" sql-name="COLOR" sql-type="char" method-name="Color" CatalogItem represent a class of goods displayed in a Catalog.<p> -----------------------------------------------------<br> xDoclet mapping generation instructions<br> -----------------------------------------------------<br> @castor:class id="id" table="CATALOG_ITEM" key-generator="MAX" id-type="integer" @castor:class field-name="id" field-type="integer" sql-name="ID" sql-type="integer" method-name="Id" @castor:class field-name="catalog_id" field-type="string" sql-name="CATALOG_ID" sql-type="char" method-name="Catalog_id" @castor:class field-name="name" field-type="string" sql-name="NAME" sql-type="char" method-name="Name" @castor:class field-name="nickname" field-type="string" sql-name="NICKNAME" sql-type="char" method-name="Nickname" @castor:class field-name="description" field-type="string" sql-name="DESCRIPTION" sql-type="char" method-name="Description" @castor:class field-name="img" field-type="string" sql-name="IMG" sql-type="char" method-name="img" @castor:class field-name="color" field-type="string" sql-name="COLOR" sql-type="char" method-name="Color" Cart hold CartItem. Cart don't go away after a purchase. Instead they are kept in a different state and used for order history.<p> -----------------------------------------------------<br> xDoclet mapping generation instructions<br> -----------------------------------------------------<br> @castor:class id="id" table="CART" key-generator="MAX" id-type="integer" @castor:class field-name="id" field-type="integer" sql-name="ID" sql-type="integer" method-name="Id" @castor:class field-name="order_id" field-type="integer" sql-name="ORDER_ID" sql-type="integer" method-name="Order_id" @castor:class field-name="username" field-type="string" sql-name="USERNAME" sql-type="char" method-name="Username" @castor:class field-name="name" field-type="string" sql-name="NAME" sql-type="char" method-name="Name" @castor:class field-name="nickname" field-type="string" sql-name="NICKNAME" sql-type="char" method-name="Nickname" @castor:class field-name="description" field-type="string" sql-name="DESCRIPTION" sql-type="char" method-name="Description" @castor:class field-name="img" field-type="string" sql-name="img" sql-type="char" method-name="img" @castor:class field-name="color" field-type="string" sql-name="COLOR" sql-type="char" method-name="Color" @castor:class field-name="cartItem" field-type="com.evisioner.commerce.CartItem" collection="vector" many-key="cart_id" method-name="CartItem" CartItem represent a number of specifically configured CatalogItem to be purchased. <p> -----------------------------------------------------<br> xDoclet mapping generation instructions<br> -----------------------------------------------------<br> @castor:class id="id" table="CART_ITEM" key-generator="MAX" id-type="integer" @castor:class field-name="cart_id" field-type="integer" sql-name="CART_ID" sql-type="integer" method-name="Cart_id" @castor:class field-name="catalog_item_id" field-type="integer" sql-name="CATALOG_ITEM_ID" sql-type="integer" method-name="Catalog_item_id" @castor:class field-name="id" field-type="integer" sql-name="ID" sql-type="integer" method-name="Id" @castor:class field-name="name" field-type="string" sql-name="NAME" sql-type="char" method-name="Name" @castor:class field-name="nickname" field-type="string" sql-name="NICKNAME" sql-type="char" method-name="Nickname" @castor:class field-name="description" field-type="string" sql-name="DESCRIPTION" sql-type="char" method-name="Description" @castor:class field-name="img" field-type="string" sql-name="img" sql-type="char" method-name="img" @castor:class field-name="color" field-type="string" sql-name="COLOR" sql-type="char" method-name="Color" Order are a cart with its items along with purchaser, payment and shipping data.<p> -----------------------------------------------------<br> xDoclet mapping generation instructions<br> -----------------------------------------------------<br> @castor:class id="id" table="ORDERS" key-generator="MAX" id-type="integer" @castor:class field-name="id" field-type="integer" sql-name="ID" sql-type="integer" method-name="Id" @castor:class field-name="state" field-type="integer" sql-name="STATE" sql-type="integer" method-name="State" @castor:class field-name="order_date" field-type="date" sql-name="ORDER_DATE" sql-type="date" method-name="Order_date" @castor:class field-name="cart" field-type="com.evisioner.commerce.Cart" collection="vector" many-key="order_id" method-name="Cart"