hi guys, i want to practice , so i decide to make a simple e-commerce fashion online shop.
In my mind, i have database designs:
1. Table for product which have product_id, type(such as t-shirt, shirt, etc), price, size(if the product is t-shirt or anything that has a size)
2. Table for selling log, which it has selling_id, and product_id(refers to product table), user_id(people that have bought the product(s))
3. Table for user, it has user_id and other user's informations.
The question is : i dont know if my database design is correct , i mean i think it fits for the situation but i dont know if in the future it will cause problem(even if it for practice, i just dont like it if it bad)
please give me some tips, i will really appreciate it