Table "public.books"
                   Column                   |            Type             |                     Modifiers                      
--------------------------------------------+-----------------------------+----------------------------------------------------
 id                                         | integer                     | not null default nextval('books_id_seq'::regclass)
 link                                       | character varying(300)      | 
 asin                                       | character varying(60)       | 
 title                                      | character varying(400)      | 
 isbn                                       | character varying(50)       | 
 newer_edition_available                    | boolean                     | 
 newer_edition_link                         | character varying(150)      | 
 cover_type                                 | character varying(100)      | 
 block_until                                | timestamp without time zone | 
 latest_trade_in_available                  | boolean                     | 
 latest_trade_in_price                      | double precision            | 
 latest_rank                                | bigint                      | 
 latest_profit_like_new                     | double precision            | 
 latest_profit_very_good                    | double precision            | 
 latest_profit_ratio                        | double precision            | 
 latest_profit_trade_in                     | double precision            | 
 category_id                                | integer                     | 
 aob_username                               | character varying(250)      | 
 latest_minimum_price                       | double precision            | 
 latest_minimum_shipping                    | double precision            | 
 bsr                                        | integer                     | default 1000
 quantity_in_transit                        | integer                     | default 0
 latest_minimum_price_like_new              | double precision            | default '1000000'::double precision
 latest_minimum_price_very_good             | double precision            | default '1000000'::double precision
 latest_minimum_shipping_like_new           | double precision            | default '1000000'::double precision
 latest_minimum_shipping_very_good          | double precision            | default '1000000'::double precision
 total_minimum_price_and_shipping           | double precision            | 
 recent_minimum_price_and_shipping          | double precision            | 
 seventy_five_percentile_price_and_shipping | double precision            | 
 bsr_str                                    | character varying(50)       | 
 bsr_id                                     | integer                     | 
 latest_profit_ratio_like_new               | double precision            | 
 latest_profit_ratio_very_good              | double precision            | 
Indexes:
    "books_pkey" PRIMARY KEY, btree (id)
    "books_asin_key" UNIQUE CONSTRAINT, btree (asin)
    "books_isbn_key" UNIQUE CONSTRAINT, btree (isbn)
    "books_link_key" UNIQUE CONSTRAINT, btree (link)
    "index_asin_books" btree (asin)
    "index_isbn_books" btree (isbn)
    "index_latest_rank_books" btree (latest_rank)
    "index_title_books" btree (title)