Whose idea was adding nickname column into vehicle table? Also made it required field when putting vehicle into VG is so annoying, like really!
vehicle table have primary key id, so WTF it isnt used when searching for vehicle (select is searching for nickname and territory_id)? Also why nickname isnt unique column when you searching with it for vehicle? This is huge nonsense for me.
Nickname should be only optional (when its empty, put there object name for example: HMWEE_DE_USA_BLABLA_CUP), searching fo vehicle should be made for its id - which is PK and unique