so iam create a ecommerce base site. where user can buy stuff. i need some help with coming up a good database structures. so far i got 5 tables.
here is what iam thinking:
"user" table to keep track of users
"user_info" table to keep there detial inforamtion
"billing" table if they want to buy a item
"item" table info about item
"cart" table - not sure about this one.
-------
user
-------
user_id
user name
password
-------
user_info
-------
user_info_id
user id
item_brought //int array?
first_name
last_name
dob
-----------
item
----------
item_id
item_name
item_des
...
--------
billing
-------
billing_id
user_id
email
area_code primary_phone
street_address
apt, suite, bldg.(optional)
zipcode
country
state
city
----------
cart
--------
cart_id
user_id
Quantity
color
size
let me know if i could add more tables or if there is a better way to create tables.