Component Custom Fields table (component_custom_fields)

Column Type Description
active boolean

Defines whether this custom field is active.

  • "true" indicates the custom field is active.

  • "false" indicates the custom field is deactivated.
component_id int8

ID of the BOM component.

Use this column to join with other reporting.component* tables to obtain more information.
custom_field_id integer ID of the BOM component custom field.
custom_field_label text Label of this custom field.
custom_field_type text Type of custom field. For example, MULTISELECT or TEXT.
project_version_id UUID Project version ID of the project version where this BOM component appears in the BOM.
values text[] Data stored for this BOM component custom field for this component.