Skip to content

Instantly share code, notes, and snippets.

@lfittl
Created August 28, 2009 21:39
Show Gist options
  • Save lfittl/177281 to your computer and use it in GitHub Desktop.
Save lfittl/177281 to your computer and use it in GitHub Desktop.
Table "public.feeds"
Column | Type | Modifiers
-------------------------+--------------------------+----------------------------------------------------
id | bigint | not null default nextval('feeds_id_seq'::regclass)
url | character varying(2048) | default NULL::character varying
name | character varying(255) | default NULL::character varying
imported_at | timestamp with time zone |
blog_id | bigint |
humane_url | character varying(2048) | default NULL::character varying
type | character varying(255) | default NULL::character varying
last_error | character varying(1024) | default NULL::character varying
username | character varying(255) | default NULL::character varying
supports_guids | boolean | default true
is_gone | boolean | default false
tried_at | timestamp with time zone |
deleted | boolean | default false
poll | boolean | default true
newest_post_at | timestamp with time zone | default now()
max_skips | integer | default 0
authorization | text |
for_storefront | boolean | default false
check_interval_override | integer |
feed_user_id | bigint |
if_modified_since | timestamp with time zone |
Indexes:
"feeds_pkey" PRIMARY KEY, btree (id)
"feed_blog_url_uniqueness" UNIQUE, btree (blog_id, url) WHERE NOT deleted
"feeds_for_storefront" btree (id) WHERE for_storefront
"feeds_twitterers" btree (username) WHERE NOT deleted AND type::text = 'Twitter'::text
"index_feeds_on_humane_url" btree (humane_url)
Foreign-key constraints:
"fk_feeds_blogs" FOREIGN KEY (blog_id) REFERENCES blogs(id) ON UPDATE CASCADE ON DELETE CASCADE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment