MMv4 KB
 
product_com_val DB Table
  Last Edited - 07/1/2009 2:57pm PDT
  Category Path - Developer's Guide > Database Structure
 

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
Powered by ModularKB