[ ] Change all IDs to unsigned integers with a size of 1 (many are signed, and some have a size of 255)
[ ] Change all name columns to reflect what they are the name of
For example, role.name should be role.roleName. This will remove the need to alias the name field in a JOIN with another entity where it could either conflict or be ambiguous. In the case of joining model with brand, for example, brand.name is aliased to just brand to make it less ambiguous. If it were brandName, it would not have to be aliased and would be consistent across all responses.
Database Schema (September 9, 2017)
1(many are signed, and some have a size of255)namecolumns to reflect what they are the name of For example,role.nameshould berole.roleName. This will remove the need to alias thenamefield in aJOINwith another entity where it could either conflict or be ambiguous. In the case of joiningmodelwithbrand, for example,brand.nameis aliased to justbrandto make it less ambiguous. If it werebrandName, it would not have to be aliased and would be consistent across all responses.