Flake в 15:14, 9 февраля 2011

2011-02-09T15:14:14Z

Flake: Новая страница: « CREATE TABLE USR$BRD_AGEDOCLINE ( DOCUMENTKEY DINTKEY NOT NULL, RESERVED DINTEGER, MASTERKEY DMASTERKEY, FROMCARDKEY DINTKEY, …»

2011-02-07T14:47:35Z

Новая страница: «<syntaxhighlight lang="SQL"> CREATE TABLE USR$BRD_AGEDOCLINE ( DOCUMENTKEY DINTKEY NOT NULL, RESERVED DINTEGER, MASTERKEY DMASTERKEY, FROMCARDKEY DINTKEY, …»

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

<syntaxhighlight lang="SQL">
CREATE TABLE USR$BRD_AGEDOCLINE
(
DOCUMENTKEY DINTKEY NOT NULL,
RESERVED DINTEGER,
MASTERKEY DMASTERKEY,
FROMCARDKEY DINTKEY,
QUANTITY DQUANTITY,
REMAINS DQUANTITY,
TOCARDKEY DINTKEY,
DISABLED DDISABLED,
USR$SUMNCU USR$BRD_D_COUNT, /* сумма в рублях */
PRIMARY KEY (DOCUMENTKEY)
);

ALTER TABLE USR$BRD_AGEDOCLINE ADD CONSTRAINT USR$FKUSR$BRD_AGEDOCLINE_DK
FOREIGN KEY (DOCUMENTKEY) REFERENCES GD_DOCUMENT (ID)
ON UPDATE CASCADE
ON DELETE CASCADE;

ALTER TABLE USR$BRD_AGEDOCLINE ADD CONSTRAINT USR$FKUSR$BRD_AGEDOCLINE_FC
FOREIGN KEY (FROMCARDKEY) REFERENCES INV_CARD (ID)
ON UPDATE CASCADE;

ALTER TABLE USR$BRD_AGEDOCLINE ADD CONSTRAINT USR$FKUSR$BRD_AGEDOCLINE_MK
FOREIGN KEY (MASTERKEY) REFERENCES GD_DOCUMENT (ID)
ON UPDATE CASCADE
ON DELETE CASCADE;

ALTER TABLE USR$BRD_AGEDOCLINE ADD CONSTRAINT USR$FKUSR$BRD_AGEDOCLINE_TC
FOREIGN KEY (TOCARDKEY) REFERENCES INV_CARD (ID)
ON UPDATE CASCADE;
</syntaxhighlight>

[[Category:База данных]]

@@ Строка 11: / Строка 11: @@
    DISABLED	DDISABLED,
    USR$SUMNCU	USR$BRD_D_COUNT,         /* сумма в рублях */
   PRIMARY KEY (DOCUMENTKEY)
 );

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

Flake в 15:14, 9 февраля 2011

Flake: Новая страница: « CREATE TABLE USR$BRD_AGEDOCLINE ( DOCUMENTKEY DINTKEY NOT NULL, RESERVED DINTEGER, MASTERKEY DMASTERKEY, FROMCARDKEY DINTKEY, …»