AC AUTOENTRY
Материал из GedeminWiki
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;