-- @tag: taxzone_charts
-- @description: Neue Tabelle für Buchungskonten der Steuerzonen 
-- @depends: release_3_1_0
-- @ignore: 0

CREATE TABLE taxzone_charts (
  id SERIAL PRIMARY KEY,
  taxzone_id integer     NOT NULL, 
  buchungsgruppen_id integer     NOT NULL, 
  income_accno_id integer     NOT NULL, 
  expense_accno_id integer     NOT NULL, 
  itime timestamp DEFAULT now(),
  FOREIGN KEY (taxzone_id)         REFERENCES tax_zones       (id),
  FOREIGN KEY (income_accno_id)    REFERENCES chart           (id),
  FOREIGN KEY (expense_accno_id)   REFERENCES chart           (id),
  FOREIGN KEY (buchungsgruppen_id) REFERENCES buchungsgruppen (id)
);