PodcastEpisodes table: Difference between revisions
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> |