-- @tag: periodic_invoices
--- @description: Neue Tabellen und Spalten für Wiederkehrende Rechnungen
+-- @description: Neue Tabellen und Spalten für Wiederkehrende Rechnungen
-- @depends: release_2_6_1
CREATE TABLE periodic_invoices_configs (
- id integer NOT NULL DEFAULT nextval('id'),
- oe_id integer NOT NULL,
- periodicity varchar(10) NOT NULL,
- print boolean DEFAULT 'f',
- printer_id integer,
- copies integer,
- active boolean DEFAULT 't',
- start_date date,
- ar_chart_id integer NOT NULL,
+ id integer NOT NULL DEFAULT nextval('id'),
+ oe_id integer NOT NULL,
+ periodicity varchar(10) NOT NULL,
+ print boolean DEFAULT 'f',
+ printer_id integer,
+ copies integer,
+ active boolean DEFAULT 't',
+ terminated boolean DEFAULT 'f',
+ start_date date,
+ end_date date,
+ ar_chart_id integer NOT NULL,
+ extend_automatically_by integer,
PRIMARY KEY (id),
FOREIGN KEY (oe_id) REFERENCES oe (id),
);
CREATE TABLE periodic_invoices (
- id integer NOT NULL DEFAULT nextval('id'),
- config_id integer NOT NULL,
- ar_id integer NOT NULL,
- period_start_date date NOT NULL,
- itime timestamp DEFAULT now(),
+ id integer NOT NULL DEFAULT nextval('id'),
+ config_id integer NOT NULL,
+ ar_id integer NOT NULL,
+ period_start_date date NOT NULL,
+ itime timestamp DEFAULT now(),
PRIMARY KEY (id),
FOREIGN KEY (config_id) REFERENCES periodic_invoices_configs (id),