user {
id integer(2) pk increments
role integer
email string(40)
username string(50)
password string(40)
full_name string(40)
photo string(100)
}
order {
id integer(4) pk increments
uid varchar(10)
item integer(1)
total decimal
date date
time time
}
product {
id integer(2) pk increments
type integer
name string(80)
image string(255)
price decimal
}
cart {
id integer(4) pk increments
order_id integer(4) > order.id
product_id integer(4) > product.id
name varchar(80)
quantity integer(2)
price decimal
subtotal decimal
}