USR$BRD AGEDOCLINE

CREATE TABLE USR$BRD_AGEDOCLINE 
(
  DOCUMENTKEY	DINTKEY NOT NULL,
  RESERVED	DINTEGER,
  MASTERKEY	DMASTERKEY,
  FROMCARDKEY	DINTKEY,
  QUANTITY	DQUANTITY,
  REMAINS	DQUANTITY,
  TOCARDKEY	DINTKEY,
  DISABLED	DDISABLED,
  USR$SUMNCU	USR$BRD_D_COUNT,         /* сумма в рублях */
  USR$OLDWEIGHT	USR$BRD_D_COUNT,         /* старый вес */
  USR$NEWWEIGHT	USR$BRD_D_COUNT,         /* новый вес */
  USR$AVGWEIGHT	USR$BRD_D_COUNT,         /* новый вес 1-ой головы */
 PRIMARY KEY (DOCUMENTKEY)
);
 
ALTER TABLE USR$BRD_AGEDOCLINE ADD CONSTRAINT USR$FKUSR$BRD_AGEDOCLINE_DK 
  FOREIGN KEY (DOCUMENTKEY) REFERENCES GD_DOCUMENT (ID) 
  ON UPDATE CASCADE 
  ON DELETE CASCADE;
 
ALTER TABLE USR$BRD_AGEDOCLINE ADD CONSTRAINT USR$FKUSR$BRD_AGEDOCLINE_FC 
  FOREIGN KEY (FROMCARDKEY) REFERENCES INV_CARD (ID) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_AGEDOCLINE ADD CONSTRAINT USR$FKUSR$BRD_AGEDOCLINE_MK 
  FOREIGN KEY (MASTERKEY) REFERENCES GD_DOCUMENT (ID) 
  ON UPDATE CASCADE 
  ON DELETE CASCADE;
 
ALTER TABLE USR$BRD_AGEDOCLINE ADD CONSTRAINT USR$FKUSR$BRD_AGEDOCLINE_TC 
  FOREIGN KEY (TOCARDKEY) REFERENCES INV_CARD (ID) 
  ON UPDATE CASCADE;