PodcastEpisodes table: Difference between revisions

Revision as of 17:43, 10 April 2024

Name	Value Type	Possible Values	Description
ID	INTEGER	AUTOINCREMENT (1 to inf.)	Primary key
IDPodcast	INTEGER	ID	Link to Podcasts table
IDTrack	INTEGER	-1(Not Downloaded),ID	Link to Songs table
Downloaded	INTEGER	0(Not Downloaded), 1(Downloaded)	Episode download status
title	TEXT	NYT: Health Update for 04/01/2008	From <item><title>. Also stored in ID3 Title tag.
autor	TEXT	Jane Brody of The New York Times	From <item><author>. Also stored in ID3 Artist tag. Note that the field is named "autor" and not "author". This is a typo in the code but it is being left as-is for backwards compatibility.
link	TEXT		From <item><link>. Infrequently used.
description	TEXT	The effectiveness of weight loss drugs.	From <item><description>. Also stored in ID3 Comment tag.
subtitle	TEXT		From <channel><subtitle>
summary	TEXT		From <channel><summary>
PubDate	REAL	39535.447916667	Publication date. From <item><pubdate>. Formatted as the number of days since December 30, 1899.
NetSource	TEXT	http://podcasts.nytimes.com/podcasts/2008/03/28/01healthupdate.mp3	URL for media file. From <item><enclosure url>
keywords	TEXT		From <item><keywords>
category	TEXT	News	From <item><category>
MIME	TEXT	audio/mpeg	MIME type of the NetSource file. From <item><enclosure type>
GUID	TEXT	http://podcasts.nytimes.com/podcasts/2008/03/28/01healthupdate.mp3	Globally Unique Identifier (New for 3.1)
ViewStatus	INTEGER	0 = VS_VISIBLE 1 = VS_HIDDEN	Show Removed Episode (New for 3.1)

Note: iTunes feed tags take precedence over standard tags. e.g. <iTunes:author> is used in preference to <author>.

@@ Line 36: / Line 36: @@
 | Jane Brody of The New York Times
 | From <item><author>. Also stored in ID3 Artist tag.
+Note that the field '''is''' named "autor" and not "author". This is a typo in the code but it is being left as-is for backwards compatibility.
 |-
 | link