GD RUID
Материал из GedeminWiki
Таблица GD_RUID содержит список 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);