MMv4 KB
 
ptcs DB Table
  Last Edited - 01/19/2010 1:08pm PST
  Category Path - Developer's Guide > Database Structure
 

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

  • id
    Primary Key of the table.
    int(10) | unsigned | auto increment | primary key | indexed
  • display_order
    The order in which the UpSell / DownSell chain will be displayed in the storefront.
    int(10) | unsigned | indexed
  • active
    If this field contains a value greater than zero, then the UpSell/DownSell chain is active.
    int(10) | unsigned |  indexed
  • name
    This is the name of the UpSell/DownSell chain, this name is only visable to store admin; customers will never see this name.
    varcahr(255) | indexed
  • current_thread
    The system ID (SID) of the current thread of rules to be used in the next order that trigger's this specific UpSell/DownSell chain.
    int(10) | unsigned |  indexed
Powered by ModularKB