USR$BRD SORTDOC
Материал из GedeminWiki
Таблица-шапка складского документа "Сортировка яиц"
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;