GD HOLDING
Материал из GedeminWiki
CREATE TABLE gd_holding ( holdingkey dintkey, companykey dintkey ); ALTER TABLE gd_holding ADD CONSTRAINT gd_pk_holding PRIMARY KEY (holdingkey, companykey); ALTER TABLE gd_holding ADD CONSTRAINT gd_fk_holding_companykey FOREIGN KEY (companykey) REFERENCES gd_company (contactkey) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE gd_holding ADD CONSTRAINT gd_fk_holding_holdingkey FOREIGN KEY (holdingkey) REFERENCES gd_company (contactkey) ON DELETE CASCADE ON UPDATE CASCADE;