I think that the column 'vehicle_reference' in the vehicle table is supposed to be from 1 to 'number_of_vehicles' in the collsions table. However, for collision reference '2022461173282', 'number_of_vehicles = 3, but the 'vehicle_reference's for vehicles in that collision are 1,2 and 4.
This may break some code assumptions. I'll report the issue to dft, and, it may get addressed. I'll update this issue with any responses.
I think that the column 'vehicle_reference' in the vehicle table is supposed to be from 1 to 'number_of_vehicles' in the collsions table. However, for collision reference '2022461173282', 'number_of_vehicles = 3, but the 'vehicle_reference's for vehicles in that collision are 1,2 and 4.
This may break some code assumptions. I'll report the issue to dft, and, it may get addressed. I'll update this issue with any responses.