Просмотр исходного текста страницы RP ADDITIONALFUNCTION


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;


[[Category:База данных]]