PodcastEpisodes table: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
(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 |