GD RUID

Версия 13:43, 9 ноября 2006

Таблица GD_RUID.

CREATE TABLE gd_ruid
(
  id         dintkey,
  xid        dintkey,
  dbid       dintkey,
  modified   TIMESTAMP NOT NULL,
  editorkey  dforeignkey,

  CONSTRAINT gd_pk_ruid_id PRIMARY KEY (id),
  CONSTRAINT gd_fk_ruid_ek FOREIGN KEY (editorkey)
    REFERENCES gd_people (contactkey)
    ON UPDATE CASCADE
    ON DELETE SET NULL 
);

CREATE UNIQUE INDEX gd_x_ruid_xid ON gd_ruid(xid, dbid);