Table Schema: mf_attributes

This topic describes the columns in the mf_attributes table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
attribute_guid uniqueidentifier 1 0 1   5  
company_guid uniqueidentifier 0 1 2   0 mf_companies.company_guid
addin_guid uniqueidentifier 0 1 3   0  
reference_guid uniqueidentifier 0 1 4   0  
attribute_handler_guid uniqueidentifier 0 1 5   0 mf_attribute_handlers.attribute_handler_guid
attribute_group_guid uniqueidentifier 0 1 6   0 mf_attribute_groups.attribute_group_guid
attribute_type_id smallint 0 0 7   0  
attribute_data_type_id int 0 0 8   0 mf_attribute_data_types.attribute_data_type_id
attribute_display_type_id int 0 0 9   0 mf_attribute_display_types.attribute_display_type_id
attribute_cd varchar (50) 0 1 10   0  
attribute_name varchar (50) 0 0 11   0  
attribute_group varchar (50) 0 1 12   0  
attribute_id varchar (50) 0 1 13   0  
attribute_label varchar (50) 0 1 14   0  
attribute_label_short varchar (50) 0 1 15   0  
attribute_description varchar (255) 0 1 16   0  
attribute_tag varchar (255) 0 1 17   0  
attribute_configuration_id varchar (25) 0 1 18   0  
attribute_configuration_label varchar (50) 0 1 19   0  
attribute_configuration_data varchar (max) 0 1 20   0  
attribute_configuration_serialization_type_id smallint 0 1 21   0  
attribute_configuration_version varchar (10) 0 1 22   0  
attribute_order smallint 0 0 23   0  
attribute_allow_multiple_values tinyint 0 0 24   0  
attribute_allow_range tinyint 0 0 25   0  
attribute_allow_other tinyint 0 0 26   0  
attribute_allow_customer_search tinyint 0 0 27   0  
attribute_allow_customer_modification tinyint 0 0 28   0  
attribute_required tinyint 0 0 29   0  
attribute_searchable tinyint 0 0 30   0  
attribute_visible tinyint 0 0 31   0  
attribute_visible_customer tinyint 0 0 32   0  
attribute_deleted tinyint 0 0 33   0  
lu_dt datetime 0 0 34   0  
cr_dt datetime 0 0 35   0  
lu_guid uniqueidentifier 0 1 36   0  
cr_guid uniqueidentifier 0 1 37   0  
attribute_abbr varchar (10) 0 1 38   0  
attribute_mask varchar (50) 0 1 39   0  
deleted tinyint 0 0 40   0  
sync_guid uniqueidentifier 0 1 41   0  
attribute_clonable bit 0 0 43   0  

Return to index of tables

X Privacy Update: We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used and to tailor advertising. By continuing to use this site you are giving us your consent to do this.