Table Schema: mf_campaigns

This topic describes the columns in the mf_campaigns table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
campaign_guid uniqueidentifier 1 0 1   3  
company_guid uniqueidentifier 0 0 2   0  
catalog_guid uniqueidentifier 0 1 3   0  
campaign_id varchar (100) 0 1 4   0  
campaign_label varchar (100) 0 1 5   0  
campaign_label_short varchar (50) 0 1 6   0  
campaign_description varchar (255) 0 1 7   0  
campaign_start datetime 0 1 8   0  
campaign_end datetime 0 1 9   0  
campaign_flag tinyint 0 0 10   0  
campaign_alert tinyint 0 0 11   0  
campaign_visible tinyint 0 0 12   0  
campaign_new tinyint 0 0 13 Status flag- Indicates whether the order is new 0  
campaign_approved tinyint 0 0 14 Work Flow flag- Indicates whether the order is approved 0  
campaign_suspended tinyint 0 0 15   0  
campaign_locked tinyint 0 0 16   0  
campaign_closed tinyint 0 0 17   0  
campaign_filed tinyint 0 0 18 Workflow flag- if set indicates that the record is filed 0  
lu_dt datetime 0 0 19   0  
cr_dt datetime 0 0 20   0  
lu_guid uniqueidentifier 0 1 21   0  
cr_guid uniqueidentifier 0 1 22   0  

Return to index of tables

X Privacy Update: We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used and to tailor advertising. By continuing to use this site you are giving us your consent to do this.