PodcastEpisodes table: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
({{DatabaseTablesList}}, formatting, added missing duration field, and asterisks for non IUNICODE fields) |
||
| 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''' | ||
| 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 | ||
| | | | ||
Latest revision as of 16:38, 11 April 2024
- [Database Structure]
- Albums
- Artists
- ArtistsAlbums
- ArtistsSongs
- Covers
- DBInfo
- DeviceFilters
- DeviceTracks
- Devices
- Downloads
- Filters
- Folders
- FoldersHier
- Genres
- GenresSongs
- LastTreePath
- Lists
- ListsSongs
- Medias
- OrganizeRules
- PathProcessing
- Pinned
- Played
- PlaylistSongs
- Playlists
- PodcastDirs
- PodcastEpisodes
- Podcasts
- Radio
- RemoteClients
- Songs
- SynchAlbum
- SynchArtist
- SynchLocation
- SynchPlaylist
- SynchPodcast
- URLRequestCache
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.
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> | |
| 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 | News | From <item><category> |
| mime | TEXT* | audio/mpeg | MIME type of the NetSource file. From <item><enclosure type>
Added in version 5.0 |
| GUID | TEXT | http://podcasts.nytimes.com/podcasts/2008/03/28/01healthupdate.mp3 | Globally Unique Identifier
Added in version 3.1 |
| ViewStatus | INTEGER |
0 = VS_VISIBLE 1 = VS_HIDDEN |
Show Removed Episode
Added in version 3.1 |
Note: iTunes feed tags take precedence over standard tags. e.g. <iTunes:author> is used in preference to <author>.
