kivitendo/sql/Pg-upgrade2/automatic_reconciliation.sql @ 7b1da9c3
| 6a12a968 | Niclas Zimmermann | -- @tag: automatic_reconciliation
|
||
-- @description: Erstellt Tabelle reconiliation_links für den automatischen Kontenabgleich.
|
||||
| 15f58ff3 | Geoffrey Richardson | -- @depends: release_3_2_0 bank_transactions
|
||
| 6a12a968 | Niclas Zimmermann | |||
CREATE TABLE reconciliation_links (
|
||||
id integer NOT NULL DEFAULT nextval('id'),
|
||||
bank_transaction_id integer NOT NULL,
|
||||
acc_trans_id bigint NOT NULL,
|
||||
rec_group integer NOT NULL,
|
||||
PRIMARY KEY (id),
|
||||
FOREIGN KEY (bank_transaction_id) REFERENCES bank_transactions (id),
|
||||
FOREIGN KEY (acc_trans_id) REFERENCES acc_trans (acc_trans_id)
|
||||
);
|