USR$BRD DISPOSALREASON

Справочник "Причина выбытия"

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;