-- @tag: bank_transactions
-- @description: Erstellen der Tabelle bank_transactions.
-- @depends: release_3_2_0 currencies

CREATE TABLE bank_transactions (
  id SERIAL PRIMARY KEY,
  transaction_id INTEGER,
  remote_bank_code TEXT,
  remote_account_number TEXT,
  transdate DATE NOT NULL,
  valutadate DATE NOT NULL,
  amount numeric(15,5) NOT NULL,
  remote_name TEXT,
  purpose TEXT,
  invoice_amount numeric(15,5) DEFAULT 0,
  local_bank_account_id INTEGER NOT NULL,
  currency_id INTEGER NOT NULL,
  cleared BOOLEAN NOT NULL DEFAULT FALSE,
  itime TIMESTAMP DEFAULT now(),
  FOREIGN KEY (currency_id)            REFERENCES currencies (id),
  FOREIGN KEY (local_bank_account_id)  REFERENCES bank_accounts (id)
);