Table Schema: mf_clients

This topic describes the columns in the mf_clients table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
client_guid uniqueidentifier 1 0 1   0  
company_guid uniqueidentifier 0 0 2   0 mf_companies.company_guid
site_guid uniqueidentifier 0 1 3   0 mf_sites.site_guid
client_type_id int 0 1 4   0 mf_client_types.client_type_id
client_name varchar (255) 0 1 5   0  
client_description varchar (250) 0 1 6   0  
client_localuser varchar (50) 0 1 7   0  
client_computer varchar (50) 0 1 8   0  
client_xml text 0 1 9   0  
client_accesses int 0 0 10   0  
client_syncs int 0 0 11   0  
client_last_access datetime 0 1 12   0  
client_last_upload_date datetime 0 1 13   0  
client_last_download_date datetime 0 1 14   0  
client_last_getconfig_date datetime 0 1 15   0  
client_last_sync_date datetime 0 1 16   0  
client_start_sync_date datetime 0 1 17   0  
client_last_sync_check varchar (100) 0 1 18   0  
client_getconfig tinyint 0 0 19   0  
client_enabled tinyint 0 0 20   0  
lu_dt datetime 0 0 21   0  
cr_dt datetime 0 0 22   0  
lu_guid uniqueidentifier 0 1 23   0  
cr_guid uniqueidentifier 0 1 24   0  

Return to index of tables