Add foreign keys
Aus Wiki
Version vom 29. Juli 2021, 06:22 Uhr von 129.187.36.61 (Diskussion) (Die Seite wurde neu angelegt: „ ALTER TABLE `objects` ADD CONSTRAINT `fk_objects_uid` FOREIGN KEY (`uid`) REFERENCES `attributes`(`oid`) ON DELETE CASCADE ON UPDATE NO ACTION; CASCADE ->…“)
ALTER TABLE `objects` ADD CONSTRAINT `fk_objects_uid` FOREIGN KEY (`uid`) REFERENCES `attributes`(`oid`) ON DELETE CASCADE ON UPDATE NO ACTION;
CASCADE -> Delete entry if parent deleted