Custom Field Values

Custom Field Values

FieldTypeDescription
id 🔑INTEGERLegacy row identifier (same value as custom_field_value_id).
custom_field_value_idINTEGERUnique identifier for the custom field value record.
agency_id 🔗INTEGERThe ID of the agency this custom field value belongs to.
labelSTRINGThe label of this custom field.
slugSTRINGThe slug of this custom field.
modelSTRINGThe model of the custom field this value belongs to.
model_id 🔗INTEGERThe ID of the model object this custom field value belongs to (e.g., license, person, etc.).
typeSTRINGThe type of this custom field.
valueSTRINGThe value of this custom field.
created_atTIMESTAMPThe timestamp when this custom field value record was created.
updated_atTIMESTAMPThe timestamp when this custom field value record was last updated.

Key Information

Primary Keys

  • id - Legacy row identifier (same value as custom_field_value_id).

Foreign Keys

  • agency_id - The ID of the agency this custom field value belongs to.
  • model_id - The ID of the model object this custom field value belongs to (e.g., license, person, etc.).