Monday, January 28, 2013

Week 4 - Class Notes

deals

reviews
- review_id
- product_id
- username
- comments
- rating
- timestamp

order
- order_id
- subtotal
- shipping
- tax
- grand total (Based on third rule of normilization there is no need to store grand total because you can figure it out from the data. Some sites will have a grand total in the data for efficiency.)


related_items
-related_items_id
-source_product_id
-target_product_id


products
- product_id
- images
- title
- price
- discount
- description
- item number
- inventory



order_item
- order_item_id
- order_id
- product_id
- price
- quantity - line_item (not necessary)

category_to_product_lookup
- id
- category_id
- product_id


categories
- category_id
- title


customers
- customer_id
- billing_address_line1
- billing_address_line2
- billing_city
- billing_state
- billing_zip
- phone
- firstname
- lastname
- email address
- credit card (number, name, ccc, exp date, type)
- shipping_address_line1
- shipping_address_line2
- shipping_city
- shipping_state
- shipping_zip





No comments:

Post a Comment