added URL shortnening and fixed uniqueness dependencies of relationships