Table Schema: mf_catalogs

This topic describes the columns in the mf_catalogs table.

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

Return to index of tables