Table Schema: mf_provider

This topic describes the columns in the mf_provider_attributes table.

Column Name: The name of the column.
Data Type: The data type of the column.
Primary Key: The value is 1 if the column is part of the primary key; 0 if not.
Is Nullable: The value is 1 if the column can have a NULL value; 0 if not.
Column ID: The ID number of the column.
Comment: Text describing the column data (if available).
Reference Count: The number of other columns that have a foreign key pointing to this column. Only tables that exist in the reporting database are considered.
Reference To: The parent table and column (if there is an upward constraint). Only tables that exist in the reporting database are considered.

Column Name	Data Type	Primary Key	Is Nullable	Column ID	Reference Count	Reference To
provider_guid	uniqueidentifier	1	0	1	2	mf_provider.provider_guid
attribute_cd	varchar (50)	1	0	2	2
attribute_data_type_id	int	0	0	3	0	mf_attribute_data_types.attribute_data_type_id
attribute_group	varchar (50)	0	1	4	0
attribute_label	varchar (50)	0	1	5	0
attribute_label_short	varchar (50)	0	1	6	0
attribute_description	varchar (255)	0	0	7	0
attribute_mandatory	tinyint	0	0	8	0
attribute_readonly	tinyint	0	0	9	0
attribute_secure	tinyint	0	0	10	0
attribute_suppress_stage	tinyint	0	0	11	0
attribute_default_value	varchar (50)	0	1	12	0
attribute_selection_type	varchar (30)	0	1	13	0
attribute_ui_display	varchar (75)	0	1	14	0
attribute_ui_editor	varchar (75)	0	1	15	0
attribute_list	varchar (2000)	0	1	16	0
attribute_list_cd	varchar (2000)	0	1	17	0
attribute_list_data	text	0	1	18	0
attribute_sort_profile	smallint	0	1	19	0
attribute_sort_company	smallint	0	1	20	0
attribute_sort_catalog	smallint	0	1	21	0
attribute_sort_site	smallint	0	1	22	0
attribute_sort_category	smallint	0	1	23	0
attribute_sort_item	smallint	0	1	24	0
attribute_sort_auction	smallint	0	1	25	0
attribute_sort_user	smallint	0	1	26	0
attribute_sort_order	smallint	0	1	27	0
attribute_sort_customer	smallint	0	1	28	0
lu_dt	datetime	0	1	29	0
cr_dt	datetime	0	1	30	0
lu_guid	uniqueidentifier	0	1	31	0
cr_guid	uniqueidentifier	0	1	32	0

Table Schema: mf_provider_attributes