USR$BRD WEIGHT
Материал из GedeminWiki
Служебная таблица для хранения весов ТМЦ.
CREATE TABLE USR$BRD_WEIGHT ( ID DINTKEY NOT NULL, DISABLED DDISABLED, EDITIONDATE DEDITIONDATE, EDITORKEY DINTKEY, USR$RECORDDATE USR$BRD_D_DATE, /* дата добавления веса */ USR$DELTA USR$BRD_D_COUNT, /* изменение веса */ USR$DOCUMENTKEY USR$BRD_D_DOCUMENTKET, /* документ создавший вес */ USR$DEPTKEY USR$BRD_DEPTKEY, /* подразделение */ USR$GOODKEY USR$BRD_D_GOODKEY, /* ТМЦ */ USR$CONSTCARDKEY USR$BRD_D_CONSTCARDKEY, /* карточка постоянных признаков (ссылка на «Карточка постоянных признаков») */ PRIMARY KEY (ID) ); CREATE DESCENDING INDEX USR$_X_BRD_WEIGHT_RECORDDATE ON USR$BRD_WEIGHT(USR$RECORDDATE); ALTER TABLE USR$BRD_WEIGHT ADD CONSTRAINT USR$FKBRD_WEIGHT____ FOREIGN KEY (USR$DOCUMENTKEY) REFERENCES GD_DOCUMENT (ID) ON UPDATE CASCADE ON DELETE CASCADE; ALTER TABLE USR$BRD_WEIGHT ADD CONSTRAINT USR$FKBRD_WEIGHT____ FOREIGN KEY (USR$DEPTKEY) REFERENCES GD_CONTACT (ID) ON UPDATE CASCADE; ALTER TABLE USR$BRD_WEIGHT ADD CONSTRAINT USR$FKBRD_WEIGHT____ FOREIGN KEY (USR$GOODKEY) REFERENCES GD_GOOD (ID) ON UPDATE CASCADE; ALTER TABLE USR$BRD_WEIGHT ADD CONSTRAINT USR$FKBRD_WEIGHT____ FOREIGN KEY (USR$CONSTCARDKEY) REFERENCES USR$BRD_CONSTCARD (ID) ON UPDATE CASCADE ON DELETE CASCADE; ALTER TABLE USR$BRD_WEIGHT ADD CONSTRAINT USR$FK_BRD_WEIGHT_EDITORKEY FOREIGN KEY (EDITORKEY) REFERENCES GD_PEOPLE (CONTACTKEY) ON UPDATE CASCADE;