Difference between revisions of "PodcastEpisodes table"

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

Revision as of 13:12, 20 April 2008

Fields

Name Value Type Possible Values Description
ID INTEGER AUTOINCREMENT (1 to inf.) Primary key
IDPodcast INTEGER Link to Podcasts table
IDTrack INTEGER -1(Not Downloaded),ID Link to Songs table
Downloaded INTEGER 0(Not Downloaded),1(Downloaded)
title TEXT NYT: Health Update for 03/25/2008
autor TEXT Jane Brody of The New York Times
link TEXT
description TEXT Monitoring carbon monoxide levels in your bloodstream.
subtitle TEXT
summary TEXT
PubDate REAL 39528.0
NetSource TEXT http://podcasts.nytimes.com/podcasts/2008/03/21/25healthupdate.mp3
keywords TEXT
category TEXT News