Vehicle Database

[E400]

RE: Vehicle Database
Great to hear that you're thinking along the same lines Quackdave! I'd be happy to share the development with you if you were interested.

I've started on the databases but I've been busy with work so haven't really got very far at all.

What I was thinking was having a Vehicles table containing the reg, chassis, body work, decks etc, with a VehicleID field to use as an identifier. I've then got another table containing the VehicleID and fields for operator, depot, fleet number, livery, seats, doors etc. This means that the vehicle data once in the database will only change if there is a registration change, but both the old and the new would be listed alongside the unique VehicleID. This way, I can store in the vehicle details table the person who made the edit and the person who approved it, so we have a running history of accountable changes for each vehicle. So every time the vehicle changes depot or is sold to another operator, the vehicle details table gets a new entry, leaving historical entries intact.

I like your idea of viewing the latest edits or latest approved data - this would be easy to introduce if all data is accountable to users and moderators, as described above, and I'd quite like that functionality myself now you've mentioned it.

As I say I'm busy right now, and I'm away from home sporadically for the next couple of weeks, so I'll really get down to starting work shortly and hopefully have a decent prototype in not too long. A couple of users have already expressed interest in testing it, so fingers crossed it can be made to work.