USR$BRD EGGSORT

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

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