In our system we have an API call that returns a list of stations. Each station among other things has a name and a corresponding code.
For example, the response looks like:
name: "New York C",
name: "Oslo C",
This list is quite big and contains approximately 3500 stations.
What we need to do is to create a widget that can be configured to have max 50 stations to choose from. These stations are a subset of those that are returned by the above mentioned call.
Basically, we don't even need to save the names, just codes will be enough.
The question is how do we save the subset of stations (codes) in DB?
I know about 1NF and I have read this how-to-store-a-list-in-a-column-of-a-database-table.
The thing is that there is no need to import all 3500 stations and put to the database because we have access to the call from the widget. But we still need to save the configured subset of data.
Any help would be appreciated.