USR$BRD INCUBATION

Таблица-шапка складского документа "Закладка яиц в инкубатор"

CREATE TABLE USR$BRD_INCUBATION 
(
  DOCUMENTKEY		DINTKEY NOT NULL,
  RESERVED		DINTEGER,
  USR$CONTACTKEY	USR$BRD_D_EMPLOYEEKEY,   /* МОЛ */
  USR$DEPTKEY		USR$BRD_DEPTKEY,         /* подразделение */
 PRIMARY KEY (DOCUMENTKEY)
);
 
ALTER TABLE USR$BRD_INCUBATION ADD CONSTRAINT USR$FKBRD_INCUBATION____ 
  FOREIGN KEY (USR$CONTACTKEY) REFERENCES GD_CONTACT (ID) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_INCUBATION ADD CONSTRAINT USR$FKBRD_INCUBATION____ 
  FOREIGN KEY (USR$DEPTKEY) REFERENCES GD_CONTACT (ID) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_INCUBATION ADD CONSTRAINT USR$FKUSR$BRD_INCUBATION_DK 
  FOREIGN KEY (DOCUMENTKEY) REFERENCES GD_DOCUMENT (ID) 
  ON UPDATE CASCADE 
  ON DELETE CASCADE;