Hi Dojo,
I need some ideas how to implement some data. I’m importing data (TV channels) into a table which is working fine. But each channel can have multiple sources, this is a bit tricky to implement. But every source has an ID. My idea was to make a separate table just for sources and in the tv channels table I would make one column and add the ID’s here like: 1;3;5
Is this the best solution? Or do I need to make in the tv channels table 3 columns with foreign keys and put 1 3 5 in it?
Hi Ive, indeed a source can be linked to multiple channels
Hi Stefan – not sure about the exact application, but this feels like something you would want to model in DataMiner DOM. This will give you probably more options to manage what seems to be operational type of data (TV channel line-up data). This includes building a nice user-definable app to view and manage that data. And this data can then be used to drive your technology workflows if needed.
Hi Stefan,
I see that this question has been inactive for some time. Do you still need help with this? If not, could you select the answer (using the ✓ icon)?
Hi Stefan,
If you are importing this into an element, then you\’ll need to add an extra table to accommodate the many-to-many relationship of your data.
This intermediate table should then contain a foreign key to both the channels and sources table.
e.g.
If you are opting to use DOM, then you\’ll need two DOM definitions.
One for the channels and one for the sources.
The channels definition could then have a DOM Instance Field Descriptor linking to the source\’s Definition, which allows multiple values.
e.g.
Hi Stefan,
I understand that every channel can have multiple sources.
Can one source also be linked to multiple channels?
This info will help us understand if the data has a one-to-many or many-to-many relation.