store

Database Diagram for Hudson University Licensed Products

Netsale Netsale.netsale_id Netsale.sale_time Netsale.customer_id Netsale.shipping Netsale.tax Netsale.total Netsale_Line Netsale_Line.netsale_id Netsale_Line.product_id Netsale_Line.price Netsale_Line.qty Netsale_Line.size Customer Customer.customer_id Customer.first_name Customer.last_name Customer.address Customer.city Customer.state Customer.zip Customer.email Customer.phone Size Size.product_id Size.size Wholesale Wholesale.order_id Wholesale.outlet Wholesale.date Product Product.product_id Product.name Product.in_store Product.embellishment_type Product.fabric Product.fit Product.graphic_type Product.origin Product.season_code Product.vendor Product.color_code Product.single_sku_catalog_entry Product.catalog Product.category Product.subcategory Product.current_price Wholesale_Line Wholesale_Line.order_id Wholesale_Line.product_id Wholesale_Line.size Wholesale_Line.price Wholesale_Line.quantity Vendor Vendor.name Vendor.url Vendor.address Vendor.address2 Vendor.city Vendor.state Vendor.zip Vendor.phone Vendor.fax Netsale JOIN Customer ON Netsale.customer_id = Customer.customer_id Netsale JOIN Netsale_Line ON Netsale.netsale_id = Netsale_Line.netsale_id Netsale_Line JOIN Product ON Netsale_Line.product_id = Product.product_id Wholesale_Line JOIN Product ON Wholesale_Line.product_id = Product.product_id Wholesale_Line JOIN Wholesale ON Wholesale_Line.order_id = Wholesale.order_id Product JOIN Size ON Product.product_id = Size.product_id Vendor JOIN Product ON Vendor.name = Product.vendor