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

Таблица-позиция складского документа "Сортировка яиц"

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

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

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

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

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

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

</syntaxhighlight>

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