USR$BRD EGGTYPE

Справочник "Тип яйца"

CREATE TABLE USR$BRD_EGGTYPE 
(
  ID		DINTKEY NOT NULL,
  DISABLED	DDISABLED,
  EDITIONDATE	DEDITIONDATE,
  EDITORKEY	DINTKEY,
  USR$NAME	USR$BRD_D_NAME,     /* наименование записи */
 PRIMARY KEY (ID)
);
 
ALTER TABLE USR$BRD_EGGTYPE ADD CONSTRAINT USR$FK_BRD_EGGTYPE_EDITORKEY 
  FOREIGN KEY (EDITORKEY) REFERENCES GD_PEOPLE (CONTACTKEY) 
  ON UPDATE CASCADE;