GD USERCOMPANY

/*
 *  У каждого пользователя системы есть своя фирма
 *  "по-умолчанию".
 */
 
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;