USR$BRD BIRTHLINE

CREATE TABLE USR$BRD_BIRDBIRTHLINE 
(
  DOCUMENTKEY		DINTKEY NOT NULL,
  RESERVED		DINTEGER,
  MASTERKEY		DMASTERKEY,
  FROMCARDKEY		DINTKEY,
  INQUANTITY		DQUANTITY,
  OUTQUANTITY		DQUANTITY,
  REMAINS		DQUANTITY,
  DISABLED		DDISABLED,
  USR$INWEIGHT		USR$BRD_D_COUNT,            /* общий вес ТМЦ */
  USR$SUMNCU		USR$BRD_D_COUNT,            /* вес одного ТМЦ */
  USR$INAVGWEIGHT	USR$BRD_D_COUNT,            /* сумма в рублях */
 PRIMARY KEY (DOCUMENTKEY)
);
 
ALTER TABLE USR$BRD_BIRDBIRTHLINE ADD CONSTRAINT USR$FKUSR$BRD_BIRDBIRTHLINE_DK 
  FOREIGN KEY (DOCUMENTKEY) REFERENCES GD_DOCUMENT (ID) 
  ON UPDATE CASCADE 
  ON DELETE CASCADE;
 
ALTER TABLE USR$BRD_BIRDBIRTHLINE ADD CONSTRAINT USR$FKUSR$BRD_BIRDBIRTHLINE_FC 
  FOREIGN KEY (FROMCARDKEY) REFERENCES INV_CARD (ID) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_BIRDBIRTHLINE ADD CONSTRAINT USR$FKUSR$BRD_BIRDBIRTHLINE_MK 
  FOREIGN KEY (MASTERKEY) REFERENCES GD_DOCUMENT (ID) 
  ON UPDATE CASCADE 
  ON DELETE CASCADE;