books_schema.txt
text/plain
Filename: books_schema.txt
Type: text/plain
Part: 2
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)