AC AUTOENTRY

CREATE TABLE AC_AUTOENTRY (
    ID             DINTKEY NOT NULL,
    ENTRYKEY       DINTKEY NOT NULL,
    TRRECORDKEY    DINTKEY NOT NULL,
    BEGINDATE      DDATE_NOTNULL NOT NULL,
    ENDDATE        DDATE_NOTNULL NOT NULL,
    CREDITACCOUNT  DINTKEY NOT NULL,
    DEBITACCOUNT   DINTKEY NOT NULL,
    EDITIONDATE    DEDITIONDATE
);
 
ALTER TABLE AC_AUTOENTRY ADD CONSTRAINT PK_AC_AUTOENTRY
  PRIMARY KEY (ID);
ALTER TABLE AC_AUTOENTRY ADD CONSTRAINT FK_AC_AUTOENTRY_CREDIT
  FOREIGN KEY (CREDITACCOUNT) REFERENCES AC_ACCOUNT (ID);
ALTER TABLE AC_AUTOENTRY ADD CONSTRAINT FK_AC_AUTOENTRY_DEBIT
  FOREIGN KEY (DEBITACCOUNT) REFERENCES AC_ACCOUNT (ID);
ALTER TABLE AC_AUTOENTRY ADD CONSTRAINT FK_AC_AUTOENTRY_ENTRYKEY
  FOREIGN KEY (ENTRYKEY) REFERENCES AC_ENTRY (ID) ON DELETE CASCADE;
ALTER TABLE AC_AUTOENTRY ADD CONSTRAINT FK_AC_AUTOENTRY_TRRECORDKEY
  FOREIGN KEY (TRRECORDKEY) REFERENCES AC_TRRECORD (ID) ON DELETE CASCADE;