reviewed foreign keys and checks