USR$BRD EGGINCOMELINE
Материал из GedeminWiki
Таблица-позиция складского документа "Приход яиц"
CREATE TABLE USR$BRD_EGGINCOMELINE ( DOCUMENTKEY DINTKEY NOT NULL, RESERVED DINTEGER, MASTERKEY DMASTERKEY, FROMCARDKEY DINTKEY, QUANTITY DQUANTITY, REMAINS DQUANTITY, DISABLED DDISABLED, USR$DEPTKEY USR$BRD_DEPTKEY, /* на подразделение */ USR$WEIGHT USR$BRD_D_COUNT, /* общий вес (для типа яиц «яичная масса») */ USR$SUMNCU USR$BRD_D_COUNT, /* сумма в рублях */ PRIMARY KEY (DOCUMENTKEY) ); ALTER TABLE USR$BRD_EGGINCOMELINE ADD CONSTRAINT USR$FCUSR$BRD_EGGINCOMELINE_FC FOREIGN KEY (FROMCARDKEY) REFERENCES INV_CARD (ID) ON UPDATE CASCADE; ALTER TABLE USR$BRD_EGGINCOMELINE ADD CONSTRAINT USR$FKBRD_EGGINCOMELINE____ FOREIGN KEY (USR$DEPTKEY) REFERENCES GD_CONTACT (ID) ON UPDATE CASCADE; ALTER TABLE USR$BRD_EGGINCOMELINE ADD CONSTRAINT USR$FKUSR$BRD_EGGINCOMELINE_DK FOREIGN KEY (DOCUMENTKEY) REFERENCES GD_DOCUMENT (ID) ON UPDATE CASCADE ON DELETE CASCADE; ALTER TABLE USR$BRD_EGGINCOMELINE ADD CONSTRAINT USR$FKUSR$BRD_EGGINCOMELINE_MK FOREIGN KEY (MASTERKEY) REFERENCES GD_DOCUMENT (ID) ON UPDATE CASCADE ON DELETE CASCADE;