Table Schema: mf_activities

This topic describes the columns in the mf_activities table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
activity_guid uniqueidentifier 1 0 1   1  
company_guid uniqueidentifier 0 0 2   0  
site_guid uniqueidentifier 0 1 3   0  
user_guid uniqueidentifier 0 1 4   0 mf_users.user_guid
activity_code_guid uniqueidentifier 0 1 5   0 mf_activity_codes.activity_code_guid
activity_result_guid uniqueidentifier 0 1 6   0 mf_activity_results.activity_result_guid
activity_date datetime 0 0 7   0  
activity_followup_date datetime 0 1 8   0  
activity_subject varchar (150) 0 1 9   0  
activity_notes varchar (3000) 0 1 10   0  
activity_notes_p varchar (3000) 0 1 11   0  
activity_new tinyint 0 0 12   0  
activity_flag tinyint 0 0 13   0  
activity_alert tinyint 0 0 14   0  
activity_closed tinyint 0 0 15   0  
lu_dt datetime 0 0 16   0  
cr_dt datetime 0 0 17   0  
lu_guid uniqueidentifier 0 1 18   0  
cr_guid uniqueidentifier 0 1 19   0  
lu_user varchar (50) 0 1 20   0  
cr_user varchar (50) 0 1 21   0  

Return to index of tables