add foreign keys to deployables
add foreign keys for deployments