https://gsbelarus.com:80/gs/wiki/index.php?action=history&feed=atom&title=USR%24BRD_CONSTCARD
USR$BRD CONSTCARD - История изменений
2026-07-17T03:05:05Z
История изменений этой страницы в вики
MediaWiki 1.19.16
https://gsbelarus.com:80/gs/wiki/index.php?title=USR$BRD_CONSTCARD&diff=4165&oldid=prev
Flake: Новая страница: «<syntaxhighlight lang="SQL"> CREATE TABLE USR$BRD_CONSTCARD ( ID DINTKEY NOT NULL, DISABLED DDISABLED, EDITIONDATE DEDITIONDATE, EDITORKEY DINTKEY, U…»
2011-02-07T14:58:03Z
<p>Новая страница: «<syntaxhighlight lang="SQL"> CREATE TABLE USR$BRD_CONSTCARD ( ID DINTKEY NOT NULL, DISABLED DDISABLED, EDITIONDATE DEDITIONDATE, EDITORKEY DINTKEY, U…»</p>
<p><b>Новая страница</b></p><div><syntaxhighlight lang="SQL"><br />
CREATE TABLE USR$BRD_CONSTCARD <br />
(<br />
ID DINTKEY NOT NULL,<br />
DISABLED DDISABLED,<br />
EDITIONDATE DEDITIONDATE,<br />
EDITORKEY DINTKEY,<br />
USR$FIRSTDOCUMENTKEY USR$BRD_D_DOCUMENTKET, /* ссылка на gd_document, на позицию создавшую карточку постоянных признаков */ <br />
USR$BIRTHDATE USR$BRD_D_DATE, /* дата происхождения ТМЦ */ <br />
PRIMARY KEY (ID)<br />
);<br />
<br />
ALTER TABLE USR$BRD_CONSTCARD ADD CONSTRAINT USR$FKBRD_CONSTCARD1498 <br />
FOREIGN KEY (USR$FIRSTDOCUMENTKEY) REFERENCES GD_DOCUMENT (ID) <br />
ON UPDATE CASCADE <br />
ON DELETE CASCADE;<br />
<br />
ALTER TABLE USR$BRD_CONSTCARD ADD CONSTRAINT USR$FK_BRD_CONSTCARD_EDITORKEY <br />
FOREIGN KEY (EDITORKEY) REFERENCES GD_PEOPLE (CONTACTKEY) <br />
ON UPDATE CASCADE;<br />
</syntaxhighlight><br />
<br />
[[Category:База данных]]</div>
Flake