PodcastEpisodes table: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
(Added changes from 5.0) |
||
| Line 29: | Line 29: | ||
| title | | title | ||
| TEXT | | TEXT | ||
| NYT: Health Update for | | 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 | ||
| | | 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 | ||
| | | 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/ | | 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) | ||
Revision as of 17:32, 10 April 2024
Fields
| 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. |
| 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>.
