Polish model validations

Add URL validation gem to validate Assignment URL. Add within and
uniqueness validations on User. Add dependent destroy where needed.