-- Table: prices.detail

-- DROP TABLE prices.detail;

CREATE TABLE prices.detail
(
  article character varying(128) NOT NULL,
  name character varying(256) NOT NULL,
  description character varying(256),
  brand_id integer,
  brand_name character varying(128),
  brand_name_temp character varying(128),
  detail_id serial NOT NULL,
  CONSTRAINT detail_pkey PRIMARY KEY (detail_id),
  CONSTRAINT detail_brand_fkey FOREIGN KEY (brand_id)
      REFERENCES prices.brand (brand_id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE prices.detail
  OWNER TO koan;

-- Index: prices.detail_article_idx

-- DROP INDEX prices.detail_article_idx;

CREATE INDEX detail_article_idx
  ON prices.detail
  USING gin
  (article COLLATE pg_catalog."default" gin_trgm_ops);

-- Index: prices.detail_article_idx1

-- DROP INDEX prices.detail_article_idx1;

CREATE INDEX detail_article_idx1
  ON prices.detail
  USING hash
  (article COLLATE pg_catalog."default");

-- Index: prices.fki_detail_brand_fkey

-- DROP INDEX prices.fki_detail_brand_fkey;

CREATE INDEX fki_detail_brand_fkey
  ON prices.detail
  USING btree
  (brand_id);