MMv4 KB
 
customer_field_data DB Table
  Last Edited - 05/19/2010 9:21am PDT
  Category Path - Developer's Guide > Database Structure
 
This article outlines the database structure for the MMv4 customer_field_data database table. This table contains the data associated with any custom customer fields that have been created.

For example, if a custom customer field has been created to record the customer's favorite color, then this table will include an entry recording the color each customer has selected.

  • id
    Primary Key of the table.
    int(10) | unsigned | auto increment | primary key | indexed
  • container_id
    Reference to the customer_field.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 customer.id) that this record is associated with.
    int(10) | unsigned | indexed

 

Powered by ModularKB