Advertisement
jeffdh5

Untitled

Feb 25th, 2019
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.87 KB | None | 0 0
  1. fields to show seller only:
  2. sku = db.Column(db.String())
  3. campaign_type = db.Column(db.String())
  4. marketplace = db.Column(db.String())
  5. product_url = db.Column(db.String())
  6. name = db.Column(db.String()) ==> this represents the campaign name
  7. start_date = db.Column(db.String())
  8. epoch_start_date = db.Column(db.Integer())
  9. is_show_logo = db.Column(db.Boolean()) (default to False - not built yet)
  10. send_follow_up_email = db.Column(db.Boolean())
  11. followup_email_wait_time_in_seconds = db.Column(db.Integer(), default=0)
  12. facebook_pixel_tracking = db.Column(db.Boolean())
  13. facebook_pixel_id = db.Column(db.String(), nullable=True)
  14. google_analytics_tracking = db.Column(db.Boolean())
  15. google_analytics_id = db.Column(db.String(), nullable=True)
  16. created_at = db.Column(db.String())
  17. epoch_created_at = db.Column(db.Integer())
  18.  
  19. fields to show both:
  20. category = db.Column(db.String())
  21. product_name = db.Column(db.String(), nullable=True)
  22. product_description = db.Column(db.String())
  23. price = db.Column(db.Float())
  24. percent_discount = db.Column(db.Float())
  25. end_date = db.Column(db.String())
  26. epoch_end_date = db.Column(db.Integer())
  27. display_countdown = db.Column(db.Boolean())
  28. artificial_urgency = db.Column(db.Boolean())
  29. image_urls = db.Column(db.String())
  30. show_coupon_left = db.Column(db.Boolean())
  31. artificial_scarcity = db.Column(db.Boolean())
  32. show_video = db.Column(db.Boolean()) (default to False, not built yet)
  33. video_url = db.Column(db.String(), nullable=True) (default to False, not built yet)
  34. privacy_text = db.Column(db.String(), nullable=True) (default to False, not built yet)
  35. show_privacy_in_footer = db.Column(db.Boolean()) (default to False, not built yet)
  36. show_privacy_in_optin = db.Column(db.Boolean()) (default to False, not built yet)
  37. send_coupon_to_email_address = db.Column(db.Boolean())
  38. require_email = db.Column(db.Boolean())
  39. require_first_name = db.Column(db.Boolean())
  40. require_last_name = db.Column(db.Boolean())
  41. redirect_on_voucher_claimed = db.Column(db.Boolean())
  42. voucher_claimed_redirect_url = db.Column(db.String(), nullable=True)
  43. total_voucher = db.Column(db.Integer(), nullable=True)
  44. remaining_voucher = db.Column(db.Integer(), nullable=True)
  45. custom_url_name = db.Column(db.String(), nullable=True)
  46.  
  47. #User Level
  48. email_from_name = db.Column(db.String())
  49. email_reply_to = db.Column(db.String())
  50. #email_footer_address = db.Column(db.String())
  51.  
  52. #Campaign level
  53. email_followup_subject = db.Column(db.String())
  54. email_followup_headline = db.Column(db.String())
  55. email_followup_body = db.Column(db.String())
  56.  
  57. #Campaign level
  58. email_voucher_coupon_subject = db.Column(db.String())
  59. email_voucher_coupon_headline = db.Column(db.String())
  60. email_voucher_coupon_body = db.Column(db.String())
  61.  
  62. is_active = db.Column(db.Boolean())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement