username
user info
passsword
email
phone number
address
product
procuct specs
description
price
quantity
garantee
orders
activity
recent pages
messages
wishlist
comments


entity : user - order - comment - prodcut - wishlist - user_profile - category



user : username - address - email - password - user_id(PK) - phone_number - created_at - removed_at - updated_at
user_profile : autorize_code - birth_day - first_name - last_name - created_at - removed_at - updated_at - user_id(foreign_key)
prodcut : name - specs - price - description - quantity - garantee - product_id - created_at - removed_at - updated_at - category
orders : order_id - user_id(foreign_key) - date - product_id  - price - created_at - removed_at - updated_at  - quantity_ordered
wishlist :  wishlist_id - product_id - created_at - removed_at - updated_at - user_id
comments : comments_id - comment_date - created_at - removed_at - updated_at - content - user_id - product_id 




User Table: user_id (PK), username, email(unique), password,  created_at, removed_at, updated_at , is_deleted , role
User Profile Table: user_profile_id (PK), authorize_code(unique), birth_day, first_name, last_name, created_at,  updated_at, user_id (FK), is_deleted , removed_at
Phone Table : created_at,  updated_at, user_id (FK), is_deleted , removed_at , Phone_id , 
Product Table: product_id (PK), name, price, description, quantity, guarantee, created_at, removed_at, updated_at, category, is_deleted
Orders Table: order_id (PK), user_id (FK), date, product_id (FK), price, created_at, removed_at, updated_at, quantity_ordered, is_deleted
Wishlist Table: wishlist_id (PK), product_id (FK), created_at, removed_at, updated_at, user_id (FK), is_deleted
Comments Table: comments_id (PK), comment_date, created_at, removed_at, updated_at, content, user_id (FK), product_id (FK), is_deleted
specs Table : spec_id(PK) , product_id(FK) , type , value , is_deleted,created_at, removed_at, updated_at
address Table : address_id(PK) , user_id(FK) , address , created_at, removed_at, updated_at,is_deleted