Table Schema: mf_categories

This topic describes the columns in the mf_categories table.

Column Name Data Type Primary Key Is Nullable Column ID Comment 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  

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.