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