AC ACCVALUE
Материал из GedeminWiki
Таблица-связка счета с единицей измерения измерения.
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;