I want to have a model called Status which will be relatively static after some user-defined set up (and different users may have different values on status).
The status can apply to different Models, such as Contact and Events.
so contact.status set of possible values will be different from event.status
I want to design the app so that status table has different types (contacts and events).
What is the right strategy and format for this?
I am thinking of saying that:
Contacts :has_one Status
and store a status_id in the contacts table. Ditto with Events.
Status table will have the status value, type, and date.
does this make sense? Can you suggest a better approach?