AC ACCVALUE

Таблица-связка счета с единицей измерения измерения.

CREATE TABLE ac_accvalue
(
  id          dintkey  PRIMARY KEY,
  accountkey  dmasterkey,
  valuekey    dintkey
 );
 
CREATE UNIQUE INDEX ac_idx_accvalue
  ON ac_accvalue (accountkey, valuekey);
 
ALTER TABLE ac_accvalue ADD CONSTRAINT fk_ac_accvalue_account
  FOREIGN KEY (accountkey) REFERENCES ac_account(id)
  ON UPDATE CASCADE
  ON DELETE CASCADE;
 
ALTER TABLE ac_accvalue ADD CONSTRAINT fk_ac_accvalue_value
  FOREIGN KEY (valuekey) REFERENCES gd_value(id)
  ON UPDATE CASCADE
  ON DELETE CASCADE;