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
|
