Table Schema: mf_categories

This topic describes the columns in the mf_categories 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
category_guid	uniqueidentifier	1	0	1	7
parent_guid	uniqueidentifier	0	1	2	0
sync_guid	uniqueidentifier	0	1	3	0
company_guid	uniqueidentifier	0	1	4	0	mf_companies.company_guid
category_cd	varchar (256)	0	1	5	0
category_name	varchar (256)	0	0	6	0
category_label_short	varchar (256)	0	1	7	0
category_description	varchar (2000)	0	1	8	0
category_description_html	text	0	1	9	0
category_tag	varchar (255)	0	1	10	0
category_seo_title	varchar (255)	0	1	11	0
category_seo_keywords	varchar (1000)	0	1	12	0
category_seo_description	varchar (2000)	0	1	13	0
manufacturer_flag	tinyint	0	1	14	0
model_flag	tinyint	0	1	15	0
brand_flag	tinyint	0	1	16	0
deleted	tinyint	0	1	17	0
lu_dt	datetime	0	1	18	0
cr_dt	datetime	0	1	19	0
lu_guid	uniqueidentifier	0	1	20	0
cr_guid	uniqueidentifier	0	1	21	0