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

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

<syntaxhighlight lang="SQL">
CREATE TABLE USR$BRD_SORTDOC 
(
  DOCUMENTKEY		DINTKEY NOT NULL,
  RESERVED		DINTEGER,
  USR$MAINDEPTKEY	USR$BRD_DEPTKEY,          /* подразделение (ограничение для позиции) */
  USR$EMPLOYEEKEY	USR$BRD_D_EMPLOYEEKEY,    /* МОЛ */
 PRIMARY KEY (DOCUMENTKEY)
);

ALTER TABLE USR$BRD_SORTDOC ADD CONSTRAINT USR$FKBRD_SORTDOC____ 
  FOREIGN KEY (USR$EMPLOYEEKEY) REFERENCES GD_CONTACT (ID) 
  ON UPDATE CASCADE;

ALTER TABLE USR$BRD_SORTDOC ADD CONSTRAINT USR$FKBRD_SORTDOC____ 
  FOREIGN KEY (USR$MAINDEPTKEY) REFERENCES GD_CONTACT (ID) 
  ON UPDATE CASCADE;

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

</syntaxhighlight>

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