--- /dev/null
+-- @tag: bank_transactions
+-- @description: Erstellen der Tabelle bank_transactions.
+-- @depends: release_3_0_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,
+ remote_name_1 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,
+
+ FOREIGN KEY (currency_id) REFERENCES currencies (id),
+ FOREIGN KEY (local_bank_account_id) REFERENCES bank_accounts (id)
+);