For anyone having a similar problem, the answer is: Single Table Inheritance
How to work with Model Statuses from multiple Third-Party Sources
If need to integrate several third-party APIS that will all be queried under the same local Model.
One API could return Inactive instead of Paused and so forth, so I was thinking maybe it's a good idea to create ENUM Classes for each API that map their status to an app internal status.
But that would make things like working with bulk data harder/impossible (Think of insertion of Bulk Data from an API, I would always need to loop over all Models to map statuses instead of writing raw DB bulk queries where possible).
How would you solve saving statuses for things like Active, Paused, Suspended etc. that come from each API?
Please or to participate in this conversation.