Well, I am not good at this stuff, but I am trying to do my best and once it all will be better performed to obtain the fastest result. But not today.

DB ER diagram

Orders

Order details

Order status

Products

Product Categories

Users

User roles

Procedures

Functions

Scalar-valued

Table-valued