USR$BRD DISPOSALDIAGNOSIS
Материал из GedeminWiki
Таблица для связи документа "Выбытие" и справочника "Диагноз".
CREATE TABLE USR$BRD_DISPOSALDIAGNOSIS ( ID DINTKEY NOT NULL, DISABLED DDISABLED, EDITIONDATE DEDITIONDATE, EDITORKEY DINTKEY, USR$DIAGNOSISKEY USR$BRD_D_DIAGNOSISKEY, /* ссылка на справочник «Диагноз» */ USR$ACTKEY USR$BRD_D_DOCUMENTKET, /* ссылка на шапку документа «Выбытие» */ USR$QUANTITY USR$BRD_D_COUNT, /* количество */ PRIMARY KEY (ID) ); ALTER TABLE USR$BRD_DISPOSALDIAGNOSIS ADD CONSTRAINT USR$FKBRD_DISPOSALDIAGNOSIS____ FOREIGN KEY (USR$DIAGNOSISKEY) REFERENCES USR$BRD_DIAGNOSIS (ID) ON UPDATE CASCADE; ALTER TABLE USR$BRD_DISPOSALDIAGNOSIS ADD CONSTRAINT USR$FKBRD_DISPOSALDIAGNOSIS____ FOREIGN KEY (USR$ACTKEY) REFERENCES GD_DOCUMENT (ID) ON UPDATE CASCADE ON DELETE CASCADE; ALTER TABLE USR$BRD_DISPOSALDIAGNOSIS ADD CONSTRAINT USR$FK_BRD_DISPOSALDI248366____ FOREIGN KEY (EDITORKEY) REFERENCES GD_PEOPLE (CONTACTKEY) ON UPDATE CASCADE;