USR$BRD DIAGNOSIS
Материал из GedeminWiki
Справочник "Диагноз"
CREATE TABLE USR$BRD_DIAGNOSIS ( ID DINTKEY NOT NULL, DISABLED DDISABLED, EDITIONDATE DEDITIONDATE, EDITORKEY DINTKEY, USR$NAME USR$BRD_D_NAME, /* наименование записи */ PRIMARY KEY (ID) ); ALTER TABLE USR$BRD_DIAGNOSIS ADD CONSTRAINT USR$FK_BRD_DIAGNOSIS_EDITORKEY FOREIGN KEY (EDITORKEY) REFERENCES GD_PEOPLE (CONTACTKEY) ON UPDATE CASCADE;