finished schema and updated connector