PodcastEpisodes table: Difference between revisions

From MediaMonkey Wiki
Jump to navigation Jump to search
(Add typical data, etc)
(More details)
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>
|}
|}

Revision as of 03:25, 21 April 2008

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 03/25/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 Monitoring carbon monoxide levels in your bloodstream. From <item><description>. Also stored in ID3 Comment tag.
subtitle TEXT From <channel><subtitle>
summary TEXT From <channel><summary>
PubDate REAL 39528.0 Publication date. From <item><pubdate>
NetSource TEXT http://podcasts.nytimes.com/podcasts/2008/03/21/25healthupdate.mp3 From <item><guid>
keywords TEXT From <item><keywords>
category TEXT News From <item><category>