[mythtv-users] Join DB table recordedprogram to recorded

[Hika van den Hoven]

Hoi Nicolas,

Sunday, December 28, 2014, 7:16:11 PM, you wrote:

> Hello,

> I just found out that the database table's fields
> recordedprogram.starttime and recorded.starttime does not qualify
> for joining, as it is documented in the wiki:
> http://www.mythtv.org/wiki/Recordedprogram_table.
> Whereas recorded.starttime seems to represent the real start of
> recording, recordedprogram.starttime seems to tell the original start of the broadcast.

> Instead, recordedprogram.title = recorded.title and
> recordedprogram.subtitle = recorded.subtitle seem to be suitable for
> joining the tables (additionally to chanid, of course).

> Am I right with using these?

> Thanks,
> Nicolas

starttime in recordedprogram matches with progstart in recorded, which
is the start of the program, not the recording.
chanid and starttime are the unique index keys in recorded, so any
search on them will be faster. but chanid and progstart will also
produce an unique key.



Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens