https://gsbelarus.com:80/gs/wiki/index.php?action=history&feed=atom&title=USR%24BRD_BIRTHLINE
USR$BRD BIRTHLINE - История изменений
2026-07-16T22:44:34Z
История изменений этой страницы в вики
MediaWiki 1.19.16
https://gsbelarus.com:80/gs/wiki/index.php?title=USR$BRD_BIRTHLINE&diff=4164&oldid=prev
Flake: Новая страница: «<syntaxhighlight lang="SQL"> CREATE TABLE USR$BRD_BIRDBIRTHLINE ( DOCUMENTKEY DINTKEY NOT NULL, RESERVED DINTEGER, MASTERKEY DMASTERKEY, FROMCARDKEY DIN…»
2011-02-07T14:53:17Z
<p>Новая страница: «<syntaxhighlight lang="SQL"> CREATE TABLE USR$BRD_BIRDBIRTHLINE ( DOCUMENTKEY DINTKEY NOT NULL, RESERVED DINTEGER, MASTERKEY DMASTERKEY, FROMCARDKEY DIN…»</p>
<p><b>Новая страница</b></p><div><syntaxhighlight lang="SQL"><br />
CREATE TABLE USR$BRD_BIRDBIRTHLINE <br />
(<br />
DOCUMENTKEY DINTKEY NOT NULL,<br />
RESERVED DINTEGER,<br />
MASTERKEY DMASTERKEY,<br />
FROMCARDKEY DINTKEY,<br />
INQUANTITY DQUANTITY,<br />
OUTQUANTITY DQUANTITY,<br />
REMAINS DQUANTITY,<br />
DISABLED DDISABLED,<br />
USR$INWEIGHT USR$BRD_D_COUNT, /* общий вес ТМЦ */<br />
USR$SUMNCU USR$BRD_D_COUNT, /* вес одного ТМЦ */<br />
USR$INAVGWEIGHT USR$BRD_D_COUNT, /* сумма в рублях */<br />
PRIMARY KEY (DOCUMENTKEY)<br />
);<br />
<br />
ALTER TABLE USR$BRD_BIRDBIRTHLINE ADD CONSTRAINT USR$FKUSR$BRD_BIRDBIRTHLINE_DK <br />
FOREIGN KEY (DOCUMENTKEY) REFERENCES GD_DOCUMENT (ID) <br />
ON UPDATE CASCADE <br />
ON DELETE CASCADE;<br />
<br />
ALTER TABLE USR$BRD_BIRDBIRTHLINE ADD CONSTRAINT USR$FKUSR$BRD_BIRDBIRTHLINE_FC <br />
FOREIGN KEY (FROMCARDKEY) REFERENCES INV_CARD (ID) <br />
ON UPDATE CASCADE;<br />
<br />
ALTER TABLE USR$BRD_BIRDBIRTHLINE ADD CONSTRAINT USR$FKUSR$BRD_BIRDBIRTHLINE_MK <br />
FOREIGN KEY (MASTERKEY) REFERENCES GD_DOCUMENT (ID) <br />
ON UPDATE CASCADE <br />
ON DELETE CASCADE;<br />
</syntaxhighlight><br />
<br />
[[Category:База данных]]</div>
Flake