USR$BRD BIRTH

CREATE TABLE USR$BRD_BIRDBIRTH 
(
  DOCUMENTKEY		DINTKEY NOT NULL,
  RESERVED		DINTEGER,
  USR$INCUBDEPTKEY	USR$BRD_DEPTKEY,             /* подразделение инкубатора */
  USR$EMPLOYEEKEY	USR$BRD_D_EMPLOYEEKEY,       /* МОЛ */
  USR$PRICEKEY		USR$BRD_D_PRICEKEY,          /* прайс-лист */
 PRIMARY KEY (DOCUMENTKEY)
);
 
ALTER TABLE USR$BRD_BIRDBIRTH ADD CONSTRAINT USR$FKBRD_BIRDBIRTH1464 
  FOREIGN KEY (USR$INCUBDEPTKEY) REFERENCES GD_CONTACT (ID) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_BIRDBIRTH ADD CONSTRAINT USR$FKBRD_BIRDBIRTH1483 
  FOREIGN KEY (USR$EMPLOYEEKEY) REFERENCES GD_CONTACT (ID) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_BIRDBIRTH ADD CONSTRAINT USR$FKBRD_BIRDBIRTH1503 
  FOREIGN KEY (USR$PRICEKEY) REFERENCES INV_PRICE (DOCUMENTKEY) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_BIRDBIRTH ADD CONSTRAINT USR$FKUSR$BRD_BIRDBIRTH_DK 
  FOREIGN KEY (DOCUMENTKEY) REFERENCES GD_DOCUMENT (ID) 
  ON UPDATE CASCADE 
  ON DELETE CASCADE;