kivitendo/sql/Pg-upgrade2/sepa.sql @ 7b1da9c3
| 1c603341 | Jan Büren | -- @tag: sepa
|
||
| 3774d83b | Moritz Bunkus | -- @description: Tabellen für den SEPA-XML-Exportassistenten
|
||
| 1c603341 | Jan Büren | -- @depends: release_2_6_0
|
||
-- @ignore: 0
|
||||
--DROP TABLE sepa_export_items;
|
||||
--DROP TABLE sepa_export;
|
||||
--DROP SEQUENCE sepa_export_id_seq;
|
||||
CREATE SEQUENCE sepa_export_id_seq;
|
||||
CREATE TABLE sepa_export (
|
||||
id integer NOT NULL DEFAULT nextval('sepa_export_id_seq'),
|
||||
employee_id integer NOT NULL,
|
||||
executed boolean DEFAULT FALSE,
|
||||
closed boolean DEFAULT FALSE,
|
||||
itime timestamp DEFAULT now(),
|
||||
PRIMARY KEY (id),
|
||||
FOREIGN KEY (employee_id) REFERENCES employee (id)
|
||||
);
|
||||
CREATE TABLE sepa_export_items (
|
||||
id integer NOT NULL DEFAULT nextval('id'),
|
||||
sepa_export_id integer NOT NULL,
|
||||
ap_id integer NOT NULL,
|
||||
chart_id integer NOT NULL,
|
||||
amount NUMERIC(25,5),
|
||||
reference varchar(35),
|
||||
requested_execution_date date,
|
||||
executed boolean DEFAULT FALSE,
|
||||
execution_date date,
|
||||
our_iban varchar(100),
|
||||
our_bic varchar(100),
|
||||
vendor_iban varchar(100),
|
||||
vendor_bic varchar(100),
|
||||
end_to_end_id varchar(35),
|
||||
PRIMARY KEY (id),
|
||||
FOREIGN KEY (sepa_export_id) REFERENCES sepa_export (id),
|
||||
FOREIGN KEY (ap_id) REFERENCES ap (id),
|
||||
FOREIGN KEY (chart_id) REFERENCES chart (id)
|
||||
);
|