Only you can really answer that question. If you are trying to determine whether to have a global
Types table and a global
Statuses table for all other tables that have this data, or whether to have a
Types table and a
Statuses table for each table that requires type/status data.
Would the pertinent data fields be the same or similiar? In other words, would the multiple tables have the same schema and structure? If so, you could think of combining them. How many tables are we talking about, and how many Types and Statuses would there be? You don't want to saturate what would normally have been a quick operation (though choose indexes and keep statistics updated often obviously).
Answering these questions will allow you to determine what to do.
But the main point here is that, if the
Statuses are not related then they should be kept in separate tables. You never know if down the line you want to add a certain field. That'd be much easier if it's isolated to a smaller