Created
August 28, 2009 21:39
-
-
Save lfittl/177281 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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