Flake: Новая страница: «Таблица-позиция складского документа "Выбытие". CREATE TABLE USR$BRD_DISPOSALLINE ( DOCUMENT…»

2011-02-07T15:12:23Z

Новая страница: «Таблица-позиция складского документа "Выбытие". <syntaxhighlight lang="SQL"> CREATE TABLE USR$BRD_DISPOSALLINE ( DOCUMENT…»

Новая страница

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

<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:База данных]]

USR$BRD DISPOSALLINE - История изменений

Flake: Новая страница: «Таблица-позиция складского документа "Выбытие". CREATE TABLE USR$BRD_DISPOSALLINE ( DOCUMENT…»