asins_schema.txt

text/plain

Filename: asins_schema.txt
Type: text/plain
Part: 3
Message: Queries containing ORDER BY and LIMIT started to work slowly
                                     Table "public.asins"
      Column      |         Type          |                     Modifiers                      
------------------+-----------------------+----------------------------------------------------
 id               | integer               | not null default nextval('isbns_id_seq'::regclass)
 value            | character varying(50) | 
 rank_type        | popularitytypeenum    | 
 sell_constraints | character varying(50) | 
 isbn_thirteen    | character varying(20) | 
Indexes:
    "isbns_pkey" PRIMARY KEY, btree (id)
    "isbns_value_key" UNIQUE CONSTRAINT, btree (value)
    "index_value_asins" btree (value)
Referenced by:
    TABLE "asins_statistics" CONSTRAINT "asins_statistics_asin_id_fkey" FOREIGN KEY (asin_id) REFERENCES asins(id) ON DELETE CASCADE
    TABLE "books_to_replenish" CONSTRAINT "books_to_replenish_asin_id_fkey" FOREIGN KEY (asin_id) REFERENCES asins(id) ON DELETE CASCADE
    TABLE "inventory_item" CONSTRAINT "inventory_item_asin_id_fkey" FOREIGN KEY (asin_id) REFERENCES asins(id) ON DELETE CASCADE
    TABLE "inventory_items" CONSTRAINT "inventory_items_asin_id_fkey" FOREIGN KEY (asin_id) REFERENCES asins(id) ON DELETE CASCADE
    TABLE "orders_on_amazon" CONSTRAINT "orders_on_amazon_asin_id_fkey" FOREIGN KEY (asin_id) REFERENCES asins(id) ON DELETE CASCADE
    TABLE "orders_on_amazon_sold" CONSTRAINT "orders_on_amazon_sold_asin_id_fkey" FOREIGN KEY (asin_id) REFERENCES asins(id) ON DELETE CASCADE