PodcastEpisodes table
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 |