[mythtv] Design of program table

[Brian May]

Hamish suggested I should have two video sources for each video
card (DVB and analog) even though most of the channels (except 31) are
the same. I have noticed a the database design seems very odd in this
regard.

In particular, since each video card has a separate source, they require
separate entries in the channel table.

Each channel for a given source/card has a unique channel ID, and
every pair of channels has the same callsign to indicate it is the
same.

So far everyone is perfectly fine.

Now we come to the program table. This lists all upcoming TV
shows. Every TV show has a unique channel id. Why is this? Why isn't
the TV show entry in the program table associated with the callsign?

What happens if the callsign ABC is associated with channel id 1002
and 2002, and each channel has a completely set of TV programs? Isn't
this wrong?

Mythtv will only display one TV guide if the callsign is the same for
both channels. Which guide will it use? The one for the first channel
or the second channel?
-- 
Brian May <bam at snoopy.apana.org.au>