2 -- @description: Verknüpfungen zwischen Aufträgen, Lieferscheinen und Rechnungen
3 -- @depends: delivery_orders
4 CREATE TABLE record_links (
5 from_table varchar(50) NOT NULL,
6 from_id integer NOT NULL,
7 to_table varchar(50) NOT NULL,
8 to_id integer NOT NULL,
10 itime timestamp DEFAULT now()
13 CREATE INDEX idx_record_links_from_table ON record_links (from_table);
14 CREATE INDEX idx_record_links_from_id ON record_links (from_id);
15 CREATE INDEX idx_record_links_to_table ON record_links (to_table);
16 CREATE INDEX idx_record_links_to_id ON record_links (to_id);