Просмотр исходного текста страницы USR$BRD DISPOSALLINE

Таблица-позиция складского документа "Выбытие".

<syntaxhighlight lang="SQL">
CREATE TABLE USR$BRD_DISPOSALLINE 
(
  DOCUMENTKEY	DINTKEY NOT NULL,
  RESERVED	DINTEGER,
  MASTERKEY	DMASTERKEY,
  FROMCARDKEY	DINTKEY,
  QUANTITY	DQUANTITY,
  REMAINS	DQUANTITY,
  TOCARDKEY	DINTKEY,
  DISABLED	DDISABLED,
  USR$DEPTKEY	USR$BRD_DEPTKEY,    /* с подразделения */
  USR$WEIGHTSUM	USR$BRD_D_COUNT,    /* общий вес */
  USR$AVGWEIGHT	USR$BRD_D_COUNT,    /* вес 1-го ТМЦ */
  USR$SUMNCU	USR$BRD_D_COUNT,    /* сумма в рублях */
 PRIMARY KEY (DOCUMENTKEY)
);

/*  Foreign Keys */

ALTER TABLE USR$BRD_DISPOSALLINE ADD CONSTRAINT USR$FKBRD_DISPOSALLINE____ 
  FOREIGN KEY (USR$DEPTKEY) REFERENCES GD_CONTACT (ID) 
  ON UPDATE CASCADE;

ALTER TABLE USR$BRD_DISPOSALLINE ADD CONSTRAINT USR$FKUSR$BRD_DISPOSALLINE_DK 
  FOREIGN KEY (DOCUMENTKEY) REFERENCES GD_DOCUMENT (ID) 
  ON UPDATE CASCADE 
  ON DELETE CASCADE;

ALTER TABLE USR$BRD_DISPOSALLINE ADD CONSTRAINT USR$FKUSR$BRD_DISPOSALLINE_FC 
  FOREIGN KEY (FROMCARDKEY) REFERENCES INV_CARD (ID) 
  ON UPDATE CASCADE;

ALTER TABLE USR$BRD_DISPOSALLINE ADD CONSTRAINT USR$FKUSR$BRD_DISPOSALLINE_MK 
  FOREIGN KEY (MASTERKEY) REFERENCES GD_DOCUMENT (ID) 
  ON UPDATE CASCADE 
  ON DELETE CASCADE;

ALTER TABLE USR$BRD_DISPOSALLINE ADD CONSTRAINT USR$FKUSR$BRD_DISPOSALLINE_TC 
  FOREIGN KEY (TOCARDKEY) REFERENCES INV_CARD (ID) 
  ON UPDATE CASCADE;

</syntaxhighlight>

[[Category:База данных]]