USR$BRD INCUBATIONLINE
Материал из GedeminWiki
Таблица-позиция складского документа "Закладка яиц в инкубатор"
CREATE TABLE USR$BRD_INCUBATIONLINE ( DOCUMENTKEY DINTKEY NOT NULL, RESERVED DINTEGER, MASTERKEY DMASTERKEY, FROMCARDKEY DINTKEY, QUANTITY DQUANTITY, REMAINS DQUANTITY, TOCARDKEY DINTKEY, DISABLED DDISABLED, PRIMARY KEY (DOCUMENTKEY) ); ALTER TABLE USR$BRD_INCUBATIONLINE ADD CONSTRAINT USR$FKUSR$BRD_INCUBATIONLINE_DK FOREIGN KEY (DOCUMENTKEY) REFERENCES GD_DOCUMENT (ID) ON UPDATE CASCADE ON DELETE CASCADE; ALTER TABLE USR$BRD_INCUBATIONLINE ADD CONSTRAINT USR$FKUSR$BRD_INCUBATIONLINE_FC FOREIGN KEY (FROMCARDKEY) REFERENCES INV_CARD (ID) ON UPDATE CASCADE; ALTER TABLE USR$BRD_INCUBATIONLINE ADD CONSTRAINT USR$FKUSR$BRD_INCUBATIONLINE_MK FOREIGN KEY (MASTERKEY) REFERENCES GD_DOCUMENT (ID) ON UPDATE CASCADE ON DELETE CASCADE; ALTER TABLE USR$BRD_INCUBATIONLINE ADD CONSTRAINT USR$FKUSR$BRD_INCUBATIONLINE_TC FOREIGN KEY (TOCARDKEY) REFERENCES INV_CARD (ID) ON UPDATE CASCADE;