static emf, user foreign keys, MainView