RP ADDITIONALFUNCTION
Материал из GedeminWiki
CREATE TABLE rp_additionalfunction
( mainfunctionkey dintkey, addfunctionkey dintkey, reserved dinteger );
ALTER TABLE rp_additionalfunction ADD CONSTRAINT rp_pk_additionalfunction PRIMARY KEY (mainfunctionkey, addfunctionkey);
ALTER TABLE rp_additionalfunction ADD CONSTRAINT rp_fk_additionalfunction_mfk FOREIGN KEY (mainfunctionkey) REFERENCES gd_function(id) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE rp_additionalfunction ADD CONSTRAINT rp_fk_additionalfunction_afk FOREIGN KEY (addfunctionkey) REFERENCES gd_function(id) ON UPDATE CASCADE;