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