This article outlines the database structure for the MMv4 product_com_val database table.

• id
  Primary Key of admins table.
  int(10) | unsigned | auto increment | primary key | indexed
• pid
  A reference to the product.id field.
  int(10) | unsigned | indexed
• aff_id
  A reference to the affiliate.id field. If the value of this field is zero, then this commission rule will be applied to every affiliate that sells this product.
  int(10) | unsigned | indexed
• value
  The numeric value of the commission value.
  double(16,2)
  
• type
  Determines whether the product_com_val.value field is a dollar value or percentage of the product's purchase price.
  char(1) | Values: D,P | Default: D
• com_max
  The maximum value per unit of the product that an affiliate may earn as a commission.
  double(16,2) | unsigned