feedservers


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int4 10 √ null
feedids.feedserver fk_feedids_feedserver C

Feed server ID
owneruser int4 10 √ null
users.ID fk_feedservers_owneruser C

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
ownergroup int4 10 √ null
groups.ID fk_feedservers_ownergroup C

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
creator int4 10 √ null
users.ID fk_feedservers_creator N

Creator user ID (defaults to authenticated user on creation)
creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)
lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
recipientuser int4 10 √ null
users.ID fk_feedservers_recipientuser N

Recipient user ID (PUBLIC if recipientuser=null and recipientgroup=null)
recipientgroup int4 10 √ null
groups.ID fk_feedservers_recipientgroup N

Recipient group ID (PUBLIC if recipientuser=null and recipientgroup=null)
activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)
name text 2147483647 null

Name
url text 2147483647 null

Feed URL
username text 2147483647 ''::text

Username
password text 2147483647 ''::text
etag text 2147483647 ''::text

Entity tag (ETag) (RFC 7232)
description text 2147483647 ''::text

Detailed general description
notify int2 5 0

Notify about new records

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_feedservers Primary key Asc ID
i_feedservers_noowner Performance Asc ownergroup
i_feedservers_owner Performance Asc/Asc owneruser + ownergroup
s_feedservers Performance Asc/Asc name + url

Relationships

Close relationships within degrees of separation