USR$BRD AGEDOC

CREATE TABLE USR$BRD_AGEDOC 
(
  DOCUMENTKEY	DINTKEY NOT NULL,
  RESERVED	DINTEGER,
  USR$DEPTKEY	USR$BRD_DEPTKEY,            /* подразделение */
  USR$PRICEKEY	USR$BRD_D_PRICEKEY,         /* прайс-лист */
 PRIMARY KEY (DOCUMENTKEY)
);
 
ALTER TABLE USR$BRD_AGEDOC ADD CONSTRAINT USR$FKBRD_AGEDOC1505 
  FOREIGN KEY (USR$DEPTKEY) REFERENCES GD_CONTACT (ID) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_AGEDOC ADD CONSTRAINT USR$FKBRD_AGEDOC1511 
  FOREIGN KEY (USR$PRICEKEY) REFERENCES INV_PRICE (DOCUMENTKEY) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_AGEDOC ADD CONSTRAINT USR$FKUSR$BRD_AGEDOC_DK 
  FOREIGN KEY (DOCUMENTKEY) REFERENCES GD_DOCUMENT (ID) 
  ON UPDATE CASCADE 
  ON DELETE CASCADE;