CREATE TABLE ctb_aux_apuracao_impostos_item
(
  terminal_ip character varying(15) NOT NULL,
  sequencia_nota integer NOT NULL,
  sequencia_item integer NOT NULL,
  tipo_produto character varying(1) NOT NULL,
  produto integer NOT NULL,
  valor_total numeric(18, 6) NOT NULL,
  quantidade numeric(18, 6) NOT NULL,

  cst_pis integer NOT NULL,
  base_pis numeric(18,6) NOT NULL,
  aliquota_pis numeric(18,6) NOT NULL,
  valor_pis numeric(18,6) NOT NULL,

  cst_cofins integer NOT NULL,
  base_cofins numeric(18,6) NOT NULL,
  aliquota_cofins numeric(18,6) NOT NULL,
  valor_cofins numeric(18,6) NOT NULL,

  cst_icms integer NOT NULL,
  base_icms numeric(18,6) NOT NULL,
  aliquota_icms numeric(18,6) NOT NULL,
  valor_icms numeric(18,6) NOT NULL,

  CONSTRAINT pk_ctb_aux_apuracao_impostos_item PRIMARY KEY (terminal_ip, sequencia_nota, sequencia_item),
  CONSTRAINT fk_ctb_aux_apuracao_impostos_item_sequencia FOREIGN KEY (terminal_ip, sequencia_nota)
      REFERENCES ctb_aux_apuracao_impostos (terminal_ip, sequencia) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE RESTRICT
)
WITH (
  OIDS=FALSE
);
ALTER TABLE ctb_aux_apuracao_impostos_item
  OWNER TO postgres;