A product can have different prices depending on the customer's purchasing the product, the region the customer is in, the currency selected, and the order type. I need help building out the pricing table for the product.
products table
- product_id
- sku
- product_name
- description
- specifications
- category_id
regions table
- region_id
- region_name (example:
United States)
customer_types table
- customer_type_id
- customer_type (example:
employee, registered, and first-time)
currencies table
- currency_id
- currency_code
order type table
- order_type_id
- order_type (example:
subscribe-and-save or single-purchase)