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;
Персональные инструменты
Пространства имён

Варианты
Действия
Навигация
Инструменты