USR$BRD CONSTCARD

CREATE TABLE USR$BRD_CONSTCARD 
(
  ID			DINTKEY NOT NULL,
  DISABLED		DDISABLED,
  EDITIONDATE		DEDITIONDATE,
  EDITORKEY		DINTKEY,
  USR$FIRSTDOCUMENTKEY	USR$BRD_D_DOCUMENTKET,   /* ссылка на gd_document, на позицию создавшую карточку постоянных признаков */ 
  USR$BIRTHDATE		USR$BRD_D_DATE,          /* дата происхождения ТМЦ */ 
 PRIMARY KEY (ID)
);
 
ALTER TABLE USR$BRD_CONSTCARD ADD CONSTRAINT USR$FKBRD_CONSTCARD1498 
  FOREIGN KEY (USR$FIRSTDOCUMENTKEY) REFERENCES GD_DOCUMENT (ID) 
  ON UPDATE CASCADE 
  ON DELETE CASCADE;
 
ALTER TABLE USR$BRD_CONSTCARD ADD CONSTRAINT USR$FK_BRD_CONSTCARD_EDITORKEY 
  FOREIGN KEY (EDITORKEY) REFERENCES GD_PEOPLE (CONTACTKEY) 
  ON UPDATE CASCADE;