feedservers

Module: control

RSS/Atom feed server configurations.

Name	Type	Nullable	Default Value	Notes
PKID	integer			Feed server ID
owneruser users.ID	integer			Owner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
ownergroup groups.ID	integer			Owner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
creator	integer			Creator user ID (defaults to authenticated user on creation)
creationdate	bigint		date_part('epoch', now())	Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint		date_part('epoch', now())	Last modification date and time as a Unix timestamp (auto-reset on modification)
recipientuser users.ID	integer			Recipient user ID (PUBLIC if `recipientuser`=`null` and `recipientgroup`=`null`)
recipientgroup groups.ID	integer			Recipient group ID (PUBLIC if `recipientuser`=`null` and `recipientgroup`=`null`)
channel channels.ID	integer			Channel ID
activity	smallint		0	Activity (`0`=ACTIVE, `1`=DEACTIVATED, `2`=DELETED)
name	text			Name
url	text			Feed URL
username	text		''	Username
notify	smallint		0	Notify about new records
etag	text		''	Entity tag (ETag) (RFC 7232)
description	text		''	Detailed general description
password	bytea

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_feedservers_ownergroup					gin	ownergroup
fk_feedservers_owneruser					gin	owneruser
i_feedservers_noowner					gin	ownergroup
pk_feedservers					btree	ID
s_feedservers_name					gin	name
s_feedservers_url					gin	url

Name	Type
c_feedservers_owner	check
c_feedservers_recipient	check
dc_feedservers_activity	check
dc_feedservers_description	check
dc_feedservers_name	check
dc_feedservers_url	check
dc_feedservers_username	check
fk_feedservers_channel	foreign_key
fk_feedservers_ownergroup	foreign_key
fk_feedservers_owneruser	foreign_key
fk_feedservers_recipientgroup	foreign_key
fk_feedservers_recipientuser	foreign_key
pk_feedservers	primary_key

Loading...