Reply to thread

Message

<blockquote data-quote="Laban" data-source="post: 161002" data-attributes="member: 53075">The link between the two is a one to many relationship:channel:&nbsp;&nbsp; channelid int,&nbsp;&nbsp; externalid..&nbsp; (not sure how this is used either, need to look at the code)&nbsp;&nbsp; ...program:&nbsp;&nbsp; programid&nbsp; int,&nbsp;&nbsp; channelid&nbsp;&nbsp; int,&nbsp;&nbsp; name ...This means that you'll need an extra row in the program table for each channel you want to assign the program to. That's easy to do of course. Not sure if this'll create some other problems in the tv-engine though.The other solution is of course to make the relationship a many-to-many but that's not for me to decide <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />&nbsp; Besides, i doubt that this'll be a commonly used thing anyway.</blockquote>

[QUOTE="Laban, post: 161002, member: 53075"] The link between the two is a one to many relationship: channel: channelid int, externalid.. (not sure how this is used either, need to look at the code) ... program: programid int, channelid int, name ... This means that you'll need an extra row in the program table for each channel you want to assign the program to. That's easy to do of course. Not sure if this'll create some other problems in the tv-engine though. The other solution is of course to make the relationship a many-to-many but that's not for me to decide :-) Besides, i doubt that this'll be a commonly used thing anyway. [/QUOTE]

Verification