Table Schema: mf_company_categories

This topic describes the columns in the mf_company_categories table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
category_guid uniqueidentifier 1 0 1   0 mf_categories.category_guid
company_guid uniqueidentifier 1 0 2   0 mf_companies.company_guid
catalog_guid uniqueidentifier 0 1 3   0 mf_catalogs.catalog_guid
image_guid uniqueidentifier 0 1 4   0  
category_order smallint 0 0 5   0  
category_root tinyint 0 0 6   0  
category_visible tinyint 0 0 7   0  
category_cd varchar (256) 0 1 8   0  
category_item_count int 0 0 9   0  
category_item_available_count int 0 0 10   0  
category_item_physical_count int 0 0 11   0  
lu_dt datetime 0 0 12   0  
cr_dt datetime 0 0 13   0  
lu_guid uniqueidentifier 0 1 14   0  
cr_guid uniqueidentifier 0 1 15   0  

Return to index of tables