Database model - feeds table
Explanation of the feeds table fields
| CategorieID | For future use | |
| dateAdded | The date and time the feed URL was added to the database | |
| dateLatestItem | The date and time the last Item was added to the database | |
| dateUpdated | The date and time the feed was grabbed. The field 'updateSeconds' shows the amount of seconds after this Time and date the feed will be updated again | |
| error | A number between 0 and
6.
A value of 0 means that this feed is OK. A value between 1 and 6 means that the grab failed because there is something wrong with the feed or the feed availability. Each grab failure increases the value of this field and the appropriate error message is stored in the field 'errorMessage'. If after one or more grab failures a feed grab is successful again the error field is reset to 0 and the 'errorMessage' field is cleared. After 6 failed grabs the 'error' field is set to 7 and grabbing of this feed is stopped. |
|
| errorMessage | The error Message | |
| manual | For system purposes | |
| ID | Database record identifier | |
| locked | For system purposes | |
| feedURL | The URL of the RSS, Atom or RDF feed that must be
grabbed.
This fied must be filled in by the user |
|
| updateSeconds | The interval between two update actions (in seconds) |
The other fields in this table correspond with the names of the 'elements' in the RSS 2.0 specification.