Difference between revisions of "PodcastEpisodes table"

From MediaMonkey Wiki
Jump to: navigation, 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>