USR$BRD HEALTHTYPE

Справочник "Состояние здоровья"

CREATE TABLE USR$BRD_HEALTHTYPE 
(
  ID			DINTKEY NOT NULL,
  DISABLED		DDISABLED,
  EDITIONDATE		DEDITIONDATE,
  EDITORKEY		DINTKEY,
  USR$NAME		USR$BRD_D_NAME,                           /* наименование записи */
  USR$ISBIRTHWASTE	USR$BRD_D_BOOLEAN DEFAULT '0' NOT NULL,   /* является ли отходом выбытия */
 PRIMARY KEY (ID)
);
 
ALTER TABLE USR$BRD_HEALTHTYPE ADD CONSTRAINT USR$FK_BRD_HEALTHTYPE_EDITORKEY 
  FOREIGN KEY (EDITORKEY) REFERENCES GD_PEOPLE (CONTACTKEY) 
  ON UPDATE CASCADE;