AC ACCANALYTICSEXT

Таблица-связка счета с объектами аналитики для развернутого сальдо.

CREATE TABLE ac_accanalyticsext
(
  id          dintkey,
  accountkey  dintkey,
  valuekey    dintkey,
 
  CONSTRAINT ac_pk_ac_accanalyticsext PRIMARY KEY (id)
 );
 
COMMIT;
 
CREATE UNIQUE INDEX ac_idx_accanalyticsext
  ON ac_accanalyticsext (accountkey, valuekey);
 
COMMIT;
 
ALTER TABLE ac_accanalyticsext ADD CONSTRAINT fk_ac_accanalyticsext_account
  FOREIGN KEY (accountkey) REFERENCES ac_account(id)
  ON UPDATE CASCADE
  ON DELETE CASCADE;
 
ALTER TABLE ac_accanalyticsext ADD CONSTRAINT fk_ac_accanalyticsext_value
  FOREIGN KEY (valuekey) REFERENCES at_relation_fields(id)
  ON UPDATE CASCADE
  ON DELETE CASCADE;