MMv4 KB
 
vendor_attr_data DB Table
  Last Edited - 07/2/2009 11:17am PDT
  Category Path - Developer's Guide > Database Structure
 

This article outlines the database structure for the MMv4 vendor_attr_data database table. This table contains the data associated with any custom vendor fields that have been created.

For example, if a custom vendor field has been created to record the fax number associated with a vendor, then this table will include an entry recording the fax number for each individual vendor.

  • id
    Primary Key of the table.
    int(10) | unsigned | auto increment | primary key | indexed
  • container_id
    Reference to the vendor_attr.id that this node is associated with.
    int(10) | unsigned | indexed
  • content
    This is the actual value that is selected or input by the user when the form field was submitted.
    text
  • object_id
    Reference to the object (in this case, the vendor.id) that this record is associated with.
    int(10) | unsigned | indexed

 

Powered by ModularKB