USR$BRD KIND

Справочник "Вид животных"

CREATE TABLE USR$BRD_KIND 
(
  ID			DINTKEY NOT NULL,
  DISABLED		DDISABLED,
  EDITIONDATE		DEDITIONDATE,
  EDITORKEY		DINTKEY,
  USR$NAME		USR$BRD_D_NAME,         /* наименование записи */
  USR$MALEGOODKEY	USR$BRD_D_GOODKEY,      /* мужская особь (ссылка на gd_good) */
  USR$FEMALEGOODKEY	USR$BRD_D_GOODKEY,      /* женская особь (ссылка на gd_good) */
  USR$BABYGOODKEY	USR$BRD_D_GOODKEY,      /* детеныш (ссылка на gd_good) */
 PRIMARY KEY (ID)
);
 
ALTER TABLE USR$BRD_KIND ADD CONSTRAINT USR$FKBRD_KIND____ 
  FOREIGN KEY (USR$MALEGOODKEY) REFERENCES GD_GOOD (ID) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_KIND ADD CONSTRAINT USR$FKBRD_KIND____ 
  FOREIGN KEY (USR$FEMALEGOODKEY) REFERENCES GD_GOOD (ID) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_KIND ADD CONSTRAINT USR$FKBRD_KIND____ 
  FOREIGN KEY (USR$BABYGOODKEY) REFERENCES GD_GOOD (ID) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_KIND ADD CONSTRAINT USR$FK_BRD_KIND_EDITORKEY 
  FOREIGN KEY (EDITORKEY) REFERENCES GD_PEOPLE (CONTACTKEY) 
  ON UPDATE CASCADE;