updated fields and created relationships between tables