RPL RECORD

Текущая версия на 14:38, 6 сентября 2009

 CREATE TABLE rpl_record (
   id           DINTKEY,
   basekey      DINTKEY,
   editiondate  DTIMESTAMP,
   state        SMALLINT,

   CONSTRAINT pk_rpl_record PRIMARY KEY (id, basekey),
   CONSTRAINT fk_rpl_record FOREIGN KEY (basekey)
     REFERENCES rpl_database (id)
     ON DELETE CASCADE
     ON UPDATE CASCADE,
   CONSTRAINT fk_rpl_record_gd_ruid FOREIGN KEY (ID)
     REFERENCES GD_RUID (ID)
     ON DELETE CASCADE
     ON UPDATE CASCADE
 );