block_rss_client

0 rows


Description

Remote news feed information. Contains the news feed id, the userid of the user who added the feed, the title of the feed itself and a description of the feed contents along with the url used to access the remote feed. Preferredtitle is a field for future use - intended to allow for custom titles rather than those found in the feed

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 0
user.id block_rss_client_erd_useridR
title LONGTEXT 2147483647 null
preferredtitle VARCHAR 64
description LONGTEXT 2147483647 null
shared TINYINT 3 0
url VARCHAR 255
skiptime BIGINT 19 0

How many seconds skip this feed for (increases every time it fails, resets to 0 when it succeeds)

skipuntil BIGINT 19 0

Do not query this RSS feed again until this time

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
block_rss_client_erd_userid Performance Asc userid

Relationships