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