Is this you need?
You can add vehicle classes and price groups whenever you want. Of-course you have then to update costs table too. And when you add vehicle classes, then you have to update price groups too - add columns for new classes. Columns in price groups table must be in same order as vehicle classes in classes table!
In price groups table, prices in all columns must be in growing order! And every price is smallest one in group!
Your original pictured tables were flawed btw. - there were gaps (from 20000 to 21000 in one, from 15000 to 21000 in another).
|