GD TAXACTUAL

Таблица актуальности налогов.

CREATE TABLE GD_TAXACTUAL (
    ID              DINTKEY,
    TAXNAMEKEY      DINTKEY,
    ACTUALDATE      DDATE NOT NULL,
    REPORTGROUPKEY  DINTKEY,
    REPORTDAY       DSMALLINT NOT NULL,
    TYPEKEY         DINTKEY,
    DESCRIPTION     DTEXT120,
    TRRECORDKEY     DFOREIGNKEY NOT NULL,
    EDITIONDATE     DEDITIONDATE
);
 
ALTER TABLE GD_TAXACTUAL ADD CONSTRAINT CHK_GD_TAXACTUAL_RD
  CHECK (0 < reportday AND reportday < 32);
ALTER TABLE GD_TAXACTUAL ADD PRIMARY KEY (ID);
ALTER TABLE GD_TAXACTUAL ADD CONSTRAINT FK_GD_TAXACTUAL
  FOREIGN KEY (TAXNAMEKEY) REFERENCES GD_TAXNAME (ID)
  ON UPDATE CASCADE;
ALTER TABLE GD_TAXACTUAL ADD CONSTRAINT FK_GD_TAXACTUAL_T
  FOREIGN KEY (TYPEKEY) REFERENCES GD_TAXTYPE (ID)
  ON UPDATE CASCADE;
ALTER TABLE GD_TAXACTUAL ADD CONSTRAINT FK_GD_TAXACTUAL_TRG
  FOREIGN KEY (REPORTGROUPKEY) REFERENCES RP_REPORTGROUP (ID)
  ON UPDATE CASCADE;
ALTER TABLE GD_TAXACTUAL ADD CONSTRAINT FK_GD_TAXACTUAL_TRRECORD
  FOREIGN KEY (TRRECORDKEY) REFERENCES AC_TRRECORD (ID)
  ON UPDATE CASCADE;
 
CREATE UNIQUE INDEX GD_IDX_TAXACTUAL
  ON GD_TAXACTUAL (TAXNAMEKEY, ACTUALDATE);