-- @tag: bank_transactions
-- @description: Erstellen der Tabelle bank_transactions.
--- @depends: release_3_0_0 currencies
+-- @depends: release_3_2_0 currencies
CREATE TABLE bank_transactions (
id SERIAL PRIMARY KEY,
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,
-
+ itime TIMESTAMP DEFAULT now(),
FOREIGN KEY (currency_id) REFERENCES currencies (id),
FOREIGN KEY (local_bank_account_id) REFERENCES bank_accounts (id)
);