rma
id
reason
timestamp
orderid
status: enum(waiting, done)
bookrolled: enum(no, yes)
rma_products
orders_products_id <- links to orders_products.id
quantity <- limited to orders_products.quantity
accepted: enum(no, yes)
orders
id
user_id
timestamp
paid
sent
bookrolled
paymethod
payment_info
trackingnumber
status: enum(pending_created, dropped, pending_shipment, done) <-- new
if pending_shipment, shops are to send to kleidoo
orders_priducts
order_id
shop_id <-- -1 if no shop accepted - this is new use of field
v_vs_id
size
color
prodnumber
product_title
brand_name
nowprice
quantity
trackingnumber <-- to kleidoo, new
admin_recieved <-- to kleidoo, new