GD USERCOMPANY
Материал из GedeminWiki
/* * У каждого пользователя системы есть своя фирма * "по-умолчанию". */ CREATE TABLE gd_usercompany ( userkey dintkey, companykey dforeignkey ); ALTER TABLE gd_usercompany ADD CONSTRAINT gd_pk_usercompany PRIMARY KEY (userkey); ALTER TABLE gd_usercompany ADD CONSTRAINT gd_fk_uc_userkey FOREIGN KEY (userkey) REFERENCES gd_user(id) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE gd_usercompany ADD CONSTRAINT gd_fk_uc_companykey FOREIGN KEY (companykey) REFERENCES gd_ourcompany(companykey) ON DELETE CASCADE ON UPDATE CASCADE;