Schema

Using the supplied table structures as a starting point here is what we would have for a generic commerce oriented schema.