Table Schema: mf

This topic describes the columns in the mf_catalogs 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
catalog_guid	uniqueidentifier	1	0	1	22
company_guid	uniqueidentifier	0	0	2	0	mf_companies.company_guid
catalog_handler_guid	uniqueidentifier	0	1	3	0	mf_catalog_handlers.catalog_handler_guid
catalog_state_id	smallint	0	1	4	0	mf_country_regions.country_region_id
catalog_country_id	smallint	0	1	5	0	mf_countries.country_id
catalog_cd	varchar (50)	0	1	6	0
catalog_label	varchar (50)	0	1	7	0
catalog_label_short	varchar (50)	0	1	8	0
catalog_description	varchar (255)	0	1	9	0
catalog_name	varchar (75)	0	1	10	0
catalog_attention	varchar (255)	0	1	11	0
catalog_company_name	varchar (255)	0	1	12	0
catalog_address	varchar (80)	0	1	13	0
catalog_address2	varchar (80)	0	1	14	0
catalog_address3	varchar (80)	0	1	15	0
catalog_city	varchar (50)	0	1	16	0
catalog_postal_code	varchar (50)	0	1	17	0
catalog_country_region_name	nvarchar (50)	0	1	18	0
catalog_phone	varchar (50)	0	1	19	0
catalog_fax	varchar (50)	0	1	20	0
catalog_email	varchar (80)	0	1	21	0
catalog_email_from	varchar (80)	0	1	22	0
catalog_email_from_display_name	varchar (100)	0	1	23	0
catalog_email_copies	varchar (80)	0	1	24	0
catalog_url	varchar (80)	0	1	25	0
catalog_contact	varchar (75)	0	1	26	0
catalog_contact_email	varchar (75)	0	1	27	0
catalog_order	smallint	0	1	28	0
catalog_default	tinyint	0	0	29	0
catalog_alert	tinyint	0	0	30	0
catalog_visible	tinyint	0	0	31	0
catalog_new	tinyint	0	0	32	0
catalog_approved	tinyint	0	0	33	0
catalog_suspended	tinyint	0	0	34	0
catalog_locked	tinyint	0	0	35	0
catalog_closed	tinyint	0	0	36	0
catalog_filed	tinyint	0	0	37	0
catalog_flag	tinyint	0	0	38	0
lu_dt	datetime	0	0	39	0
cr_dt	datetime	0	0	40	0
lu_guid	uniqueidentifier	0	1	41	0
cr_guid	uniqueidentifier	0	1	42	0

Table Schema: mf_catalogs