and would do well to have constraints such as this one applied in a business logic layer rather than at this level, since you would actually need as many columns in the "orders" table as types of ...