Block Rss Client Table Schema (block_rss_client)


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

block_rss_client table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
userid BIGINT 19 0
user.id blocrssclie_use_fk R
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

Table contained -1 rows

block_rss_client table indexes

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

block_rss_client table relationships

Close relationships within degrees of separation