tec4 - 4:39 pm on Oct 10, 2012 (gmt 0)

With the configuration table holding the user_id and user_type fields, is there a way I can have the row be deleted automatically if a particular user was removed from the system or would this have to be manual?

I've worked with foreign keys and such, but not sure how to do this if the type and id pertain to different tables (for example: agents, leads, partners).

What would be a good way to set that up structurally?