USR$BRD DISPOSALREASON
Материал из GedeminWiki
Справочник "Причина выбытия"
CREATE TABLE USR$BRD_DISPOSALREASON ( ID DINTKEY NOT NULL, DISABLED DDISABLED, EDITIONDATE DEDITIONDATE, EDITORKEY DINTKEY, USR$NAME USR$BRD_D_NAME, /* наименование записи */ PRIMARY KEY (ID) ); ALTER TABLE USR$BRD_DISPOSALREASON ADD CONSTRAINT USR$FK_BRD_DISPOSALRE246890____ FOREIGN KEY (EDITORKEY) REFERENCES GD_PEOPLE (CONTACTKEY) ON UPDATE CASCADE;