Table Schema: mf_company_searches

This topic describes the columns in the mf_company_searches table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
company_search_guid uniqueidentifier 1 0 1   0  
company_guid uniqueidentifier 0 0 2   0 mf_companies.company_guid
user_guid uniqueidentifier 0 1 3   0 mf_users.user_guid
search_id int 0 0 4   0 mf_searches.search_id
company_search_label varchar (50) 0 1 5   0  
company_search_label_short varchar (50) 0 1 6   0  
company_search_description varchar (50) 0 1 7   0  
company_search_filter text 0 0 8   0  
company_search_order smallint 0 0 9   0  
lu_dt datetime 0 0 10   0  
cr_dt datetime 0 0 11   0  
lu_guid uniqueidentifier 0 1 12   0  
cr_guid uniqueidentifier 0 1 13   0  

Return to index of tables