AC QUANTITY

Таблица количестенных показателей проводки.

CREATE TABLE ac_quantity
(
  id          dintkey  PRIMARY KEY,
  entrykey    dmasterkey,
  valuekey    dintkey,
  quantity    dcurrency
 );
 
CREATE UNIQUE INDEX ac_idx_quantity
  ON ac_quantity (entrykey, valuekey);
 
ALTER TABLE ac_quantity ADD CONSTRAINT fk_ac_quantity_entry
  FOREIGN KEY (entrykey) REFERENCES ac_entry(id)
  ON UPDATE CASCADE
  ON DELETE CASCADE;
 
ALTER TABLE ac_quantity ADD CONSTRAINT fk_ac_quantity_accvalue
  FOREIGN KEY (valuekey) REFERENCES gd_value(id)
  ON UPDATE CASCADE
  ON DELETE CASCADE;