Concerns about existing database table

Apparently 3 or 4 live web sites use this table and t开发者_如何学Pythonhe owner doesn't want to spend the time to fix it and the code that accesses it. What do you typically do in this situation, it doesn't seem like I have any choice other than to deal with it.

If the client insists on you using this structure (and as it appears that he has several websites running with it, the client probably does), you need to adapt yourself to it. It is a horrible mess, but unless you get paid to fix it, you can't really tell the boss what to do.

There are several dependent applications and unless you can change them, you need to keep using it.

There are ways to mitigate this issue - if you have the time, create a better structure, migrate the data and create a view over the new structure that is identical to the above and that can be used seamlessly by applications that insist on using the old/broken structure.

The only solution is incremental cleanups, and this assumes you can also cleanup the application code that uses this table.