add missing NOT NULL and ON DELETE CASCADE for participation constraints