first of all, I want to say how happy I am with CI. RIight now, I want to migrate the code of my old project into the CI MVC-Framework. Everything worked fine but I'm experiencing a problem now:
I have a DB table for users, cars, bicycles and motorbikes. The tables cars, bicycles and motorbikes have a different data structure but an unique id. The user table has an id and a vehicle_id. Each user can either have a car or a bicycle or a motorbike.
In my old model, I stored a vehicle_type in the user table. If the vehicle_type equaled 1, then the vehicle_id has been linked to the car, vehicle_type 2 has been linked to bicycle etc.
I think it's not the best solution and as I'm changing the whole model and the data access (with DMZ) now, I want to change this.
Do you guys have any suggestions to solve this problem with the help of DMZ?