feed


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('system.feed_id_seq'::regclass)
feed_config.feed_id fk_feed_id R
name text 2147483647 null
shortname text 2147483647 √ null
pipelinename text 2147483647 √ null
enabled bool 1 √ null
overwrite bool 1 √ null
servername text 2147483647 √ null
url text 2147483647 √ null
key text 2147483647 √ null
filename text 2147483647 √ null
tablename text 2147483647 √ null
pollinterval int4 10 √ null
username text 2147483647 √ null
password text 2147483647 √ null
autosubscribe bool 1 √ false
mapping bool 1 √ false
isrunning bool 1 √ false
laststarttime timestamp 29,6 √ null
lastendtime timestamp 29,6 √ null

Table contained 34 rows

Indexes

Constraint Name Type Sort Column(s)
pk_feed Primary key Asc id
uk_feed_name Must be unique Asc name

Relationships

Close relationships within degrees of separation