RPL RECORD

Версия 13:40, 21 августа 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
 );