PodcastEpisodes table - Revision history

Drakinite: {{DatabaseTablesList}}, formatting, added missing duration field, and asterisks for non IUNICODE fields

2024-04-11T16:38:59Z

{{DatabaseTablesList}}, formatting, added missing duration field, and asterisks for non IUNICODE fields

← Older revision		Revision as of 16:38, 11 April 2024
Line 1:		Line 1:
			{{DatabaseTablesList}}
	== Fields ==		== Fields ==
	{\| border="1"		{\| border="1"
Line 12:		Line 13:
	\| Primary key		\| Primary key
	\|-		\|-
	\| IDPodcast		\| '''IDPodcast'''
	\| INTEGER		\| INTEGER
	\| ID		\| ID
	\| Link to Podcasts table		\| Link to Podcasts table
	\|-		\|-
	\| IDTrack		\| '''IDTrack'''
	\| INTEGER		\| INTEGER
	\| -1(Not Downloaded),ID		\| -1(Not Downloaded),ID
	\| Link to Songs table		\| Link to Songs table
	\|-		\|-
	\| Downloaded		\| '''Downloaded'''
	\| INTEGER		\| INTEGER
	\| 0(Not Downloaded), 1(Downloaded)		\| 0(Not Downloaded), 1(Downloaded)
	\| Episode download status		\| Episode download status
	\|-		\|-
	\| title		\| '''title'''
	\| TEXT		\| TEXT
	\| NYT: Health Update for 04/01/2008		\| NYT: Health Update for 04/01/2008
	\| From <item><title>. Also stored in ID3 Title tag.		\| From <item><title>. Also stored in ID3 Title tag.
	\|-		\|-
	\| autor		\| '''autor'''
	\| TEXT		\| TEXT
	\| Jane Brody of The New York Times		\| Jane Brody of The New York Times
Line 38:		Line 39:
	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.		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		\| '''link'''
	\| TEXT		\| TEXT
	\|		\|
	\| From <item><link>. Infrequently used.		\| From <item><link>. Infrequently used.
	\|-		\|-
	\| description		\| '''description'''
	\| TEXT		\| TEXT
	\| The effectiveness of weight loss drugs.		\| The effectiveness of weight loss drugs.
	\| From <item><description>. Also stored in ID3 Comment tag.		\| From <item><description>. Also stored in ID3 Comment tag.
	\|-		\|-
	\| subtitle		\| '''subtitle'''
	\| TEXT		\| TEXT
	\|		\|
	\| From <channel><subtitle>		\| From <channel><subtitle>
	\|-		\|-
	\| summary		\| '''summary'''
	\| TEXT		\| TEXT
	\|		\|
	\| From <channel><summary>		\| From <channel><summary>
	\|-		\|-
	\| PubDate		\| '''PubDate'''
	\| REAL		\| REAL
	\| 39535.447916667		\| 39535.447916667
	\| Publication date. From <item><pubdate>. Formatted as the number of days since December 30, 1899.		\| Publication date. From <item><pubdate>. Formatted as the number of days since December 30, 1899.
	\|-		\|-
	\| NetSource		\| '''NetSource'''
	\| TEXT		\| TEXT
	\| http://podcasts.nytimes.com/podcasts/2008/03/28/01healthupdate.mp3		\| http://podcasts.nytimes.com/podcasts/2008/03/28/01healthupdate.mp3
	\| URL for media file. From <item><enclosure url>		\| URL for media file. From <item><enclosure url>
	\|-		\|-
	\| keywords		\| '''keywords'''
	\| TEXT		\| TEXT
	\|		\|
	\| From <item><keywords>		\| From <item><keywords>
	\|-		\|-
	\| category		\| '''duration'''
			\| TEXT*
			\| 1:03
			\| From <item><itunes:duration>
			This is the self-reported duration of the podcast from the XML, which may or may not be accurate to the real duration of the audio file.
			\|-
			\| '''category'''
	\| TEXT		\| TEXT
	\| News		\| News
	\| From <item><category>		\| From <item><category>
	\|-		\|-
	\| ~~MIME~~		\| '''mime'''
	\| TEXT		\| TEXT*
	\| audio/mpeg		\| audio/mpeg
	\| MIME type of the NetSource file. From <item><enclosure type>		\| MIME type of the NetSource file. From <item><enclosure type>
	Added in version 5.0		Added in version 5.0
	\|-		\|-
	\| GUID		\| '''GUID'''
	\| TEXT		\| TEXT
	\| http://podcasts.nytimes.com/podcasts/2008/03/28/01healthupdate.mp3		\| http://podcasts.nytimes.com/podcasts/2008/03/28/01healthupdate.mp3
Line 90:		Line 97:
	Added in version 3.1		Added in version 3.1
	\|-		\|-
	\| ViewStatus		\| '''ViewStatus'''
	\| INTEGER		\| INTEGER
	\|		\|

Drakinite at 17:47, 10 April 2024

2024-04-10T17:47:59Z

← Older revision		Revision as of 17:47, 10 April 2024
Line 82:		Line 82:
	\| audio/mpeg		\| audio/mpeg
	\| MIME type of the NetSource file. From <item><enclosure type>		\| MIME type of the NetSource file. From <item><enclosure type>
			Added in version 5.0
	\|-		\|-
	\| GUID		\| GUID
Line 87:		Line 88:
	\| http://podcasts.nytimes.com/podcasts/2008/03/28/01healthupdate.mp3		\| http://podcasts.nytimes.com/podcasts/2008/03/28/01healthupdate.mp3
	\| Globally Unique Identifier		\| Globally Unique Identifier
	~~(New for~~ 3.1)		Added in version 3.1
	\|-		\|-
	\| ViewStatus		\| ViewStatus
Line 95:		Line 96:
	1 = VS_HIDDEN		1 = VS_HIDDEN
	\| Show Removed Episode		\| Show Removed Episode
	~~(New for~~ 3.1)		Added in version 3.1
	\|}		\|}

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

Drakinite: Added comment about 'autor' typo

2024-04-10T17:43:44Z

Added comment about 'autor' typo

← Older revision		Revision as of 17:43, 10 April 2024
Line 36:		Line 36:
	\| Jane Brody of The New York Times		\| Jane Brody of The New York Times
	\| From <item><author>. Also stored in ID3 Artist tag.		\| 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		\| link

Drakinite: Added changes from 5.0

2024-04-10T17:32:01Z

Added changes from 5.0

← Older revision		Revision as of 17:32, 10 April 2024
Line 29:		Line 29:
	\| title		\| title
	\| TEXT		\| TEXT
	\| NYT: Health Update for 03/25/2008		\| NYT: Health Update for 04/01/2008
	\| From <item><title>. Also stored in ID3 Title tag.		\| From <item><title>. Also stored in ID3 Title tag.
	\|-		\|-
Line 44:		Line 44:
	\| description		\| description
	\| TEXT		\| TEXT
	\| ~~Monitoring carbon monoxide levels in your bloodstream~~.		\| The effectiveness of weight loss drugs.
	\| From <item><description>. Also stored in ID3 Comment tag.		\| From <item><description>. Also stored in ID3 Comment tag.
	\|-		\|-
Line 59:		Line 59:
	\| PubDate		\| PubDate
	\| REAL		\| REAL
	\| ~~39528~~.0		\| 39535.447916667
	\| Publication date. From <item><pubdate>		\| Publication date. From <item><pubdate>. Formatted as the number of days since December 30, 1899.
	\|-		\|-
	\| NetSource		\| NetSource
	\| TEXT		\| TEXT
	\| http://podcasts.nytimes.com/podcasts/2008/03/21/~~25healthupdate~~.mp3		\| http://podcasts.nytimes.com/podcasts/2008/03/28/01healthupdate.mp3
	\| URL for media file. From <item><enclosure url>		\| URL for media file. From <item><enclosure url>
	\|-		\|-
Line 76:		Line 76:
	\| News		\| News
	\| From <item><category>		\| From <item><category>
			\|-
			\| MIME
			\| TEXT
			\| audio/mpeg
			\| MIME type of the NetSource file. From <item><enclosure type>
	\|-		\|-
	\| GUID		\| GUID
	\| TEXT		\| TEXT
	\|		\| http://podcasts.nytimes.com/podcasts/2008/03/28/01healthupdate.mp3
	\| Globally Unique Identifier		\| Globally Unique Identifier
	(New for 3.1)		(New for 3.1)

Owyn at 23:56, 14 December 2008

2008-12-14T23:56:08Z

← Older revision		Revision as of 23:56, 14 December 2008
Line 78:		Line 78:
	\|-		\|-
	\| GUID		\| GUID
	\| TEXT ~~COLLATE IUNICODE~~		\| TEXT
	\|		\|
	\| Globally Unique Identifier		\| Globally Unique Identifier

Owyn: Changes for 3.1

2008-12-14T23:55:14Z

Changes for 3.1

@@ Line 76: / Line 76: @@
 | News
 | From <item><category>
 |}
 Note: iTunes feed tags take precedence over standard tags. e.g. <iTunes:author> is used in preference to <author>.

Ludek: /* Fields */

2008-05-12T19:15:41Z

Fields

← Older revision		Revision as of 19:15, 12 May 2008
Line 65:		Line 65:
	\| TEXT		\| TEXT
	\| http://podcasts.nytimes.com/podcasts/2008/03/21/25healthupdate.mp3		\| http://podcasts.nytimes.com/podcasts/2008/03/21/25healthupdate.mp3
	\| URL for media file. From <item><~~guid~~>		\| URL for media file. From <item><enclosure url>
	\|-		\|-
	\| keywords		\| keywords

Owyn at 03:39, 21 April 2008

2008-04-21T03:39:52Z

← Older revision		Revision as of 03:39, 21 April 2008
Line 24:		Line 24:
	\| Downloaded		\| Downloaded
	\| INTEGER		\| INTEGER
	\| 0(Not Downloaded),1(Downloaded)		\| 0(Not Downloaded), 1(Downloaded)
	\| Episode download status		\| Episode download status
	\|-		\|-
Line 65:		Line 65:
	\| TEXT		\| TEXT
	\| http://podcasts.nytimes.com/podcasts/2008/03/21/25healthupdate.mp3		\| http://podcasts.nytimes.com/podcasts/2008/03/21/25healthupdate.mp3
	\| From <item><guid>		\| URL for media file. From <item><guid>
	\|-		\|-
	\| keywords		\| keywords
Line 77:		Line 77:
	\| From <item><category>		\| From <item><category>
	\|}		\|}

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

Owyn: More details

2008-04-21T03:25:12Z

More details

← Older revision		Revision as of 03:25, 21 April 2008
Line 14:		Line 14:
	\| IDPodcast		\| IDPodcast
	\| INTEGER		\| INTEGER
	\|		\| ID
	\| Link to Podcasts table		\| Link to Podcasts table
	\|-		\|-
Line 25:		Line 25:
	\| INTEGER		\| INTEGER
	\| 0(Not Downloaded),1(Downloaded)		\| 0(Not Downloaded),1(Downloaded)
	\|		\| Episode download status
	\|-		\|-
	\| title		\| title
	\| TEXT		\| TEXT
	\| NYT: Health Update for 03/25/2008		\| NYT: Health Update for 03/25/2008
	\|		\| From <item><title>. Also stored in ID3 Title tag.
	\|-		\|-
	\| autor		\| autor
	\| TEXT		\| TEXT
	\| Jane Brody of The New York Times		\| Jane Brody of The New York Times
	\|		\| From <item><author>. Also stored in ID3 Artist tag.
	\|-		\|-
	\| link		\| link
	\| TEXT		\| TEXT
	\|		\|
	\|		\| From <item><link>. Infrequently used.
	\|-		\|-
	\| description		\| description
	\| TEXT		\| TEXT
	\| Monitoring carbon monoxide levels in your bloodstream.		\| Monitoring carbon monoxide levels in your bloodstream.
	\|		\| From <item><description>. Also stored in ID3 Comment tag.
	\|-		\|-
	\| subtitle		\| subtitle
	\| TEXT		\| TEXT
	\|		\|
	\|		\| From <channel><subtitle>
	\|-		\|-
	\| summary		\| summary
	\| TEXT		\| TEXT
	\|		\|
	\|		\| From <channel><summary>
	\|-		\|-
	\| PubDate		\| PubDate
	\| REAL		\| REAL
	\| 39528.0		\| 39528.0
	\|		\| Publication date. From <item><pubdate>
	\|-		\|-
	\| NetSource		\| NetSource
	\| TEXT		\| TEXT
	\| http://podcasts.nytimes.com/podcasts/2008/03/21/25healthupdate.mp3		\| http://podcasts.nytimes.com/podcasts/2008/03/21/25healthupdate.mp3
	\|		\| From <item><guid>
	\|-		\|-
	\| keywords		\| keywords
	\| TEXT		\| TEXT
	\|		\|
	\|		\| From <item><keywords>
	\|-		\|-
	\| category		\| category
	\| TEXT		\| TEXT
	\| News		\| News
	\|		\| From <item><category>
	\|}		\|}

Owyn: Add typical data, etc

2008-04-20T13:12:14Z

Add typical data, etc

← Older revision		Revision as of 13:12, 20 April 2008
Line 10:		Line 10:
	\| INTEGER		\| INTEGER
	\| AUTOINCREMENT (1 to inf.)		\| AUTOINCREMENT (1 to inf.)
	\|		\| Primary key
	\|-		\|-
	\| IDPodcast		\| IDPodcast
	\| INTEGER		\| INTEGER
	\|		\|
	\|		\| Link to Podcasts table
	\|-		\|-
	\| IDTrack		\| IDTrack
	\| INTEGER		\| INTEGER
	\|		\| -1(Not Downloaded),ID
	\|		\| Link to Songs table
	\|-		\|-
	\| Downloaded		\| Downloaded
	\| INTEGER		\| INTEGER
	\|		\| 0(Not Downloaded),1(Downloaded)
	\|		\|
	\|-		\|-
	\| title		\| title
	\| TEXT		\| TEXT
	\|		\| NYT: Health Update for 03/25/2008
	\|		\|
	\|-		\|-
	\| autor		\| autor
	\| TEXT		\| TEXT
	\|		\| Jane Brody of The New York Times
	\|		\|
	\|-		\|-
Line 44:		Line 44:
	\| description		\| description
	\| TEXT		\| TEXT
	\|		\| Monitoring carbon monoxide levels in your bloodstream.
	\|		\|
	\|-		\|-
Line 59:		Line 59:
	\| PubDate		\| PubDate
	\| REAL		\| REAL
	\|		\| 39528.0
	\|		\|
	\|-		\|-
	\| NetSource		\| NetSource
	\| TEXT		\| TEXT
	\|		\| http://podcasts.nytimes.com/podcasts/2008/03/21/25healthupdate.mp3
	\|		\|
	\|-		\|-
Line 74:		Line 74:
	\| category		\| category
	\| TEXT		\| TEXT
	\|		\| News
	\|		\|
	\|}		\|}