Advertisement
jeffdh5

Untitled

Mar 3rd, 2019
287
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.39 KB | None | 0 0
  1. class Campaign(db.Model):
  2. id = db.Column(db.Integer(), primary_key=True)
  3. user_id = db.Column(db.Integer(), ForeignKey('user_v2.id'))
  4. sku = db.Column(db.String())
  5. category = db.Column(db.String())
  6. campaign_type = db.Column(db.String())
  7. marketplace = db.Column(db.String())
  8. name = db.Column(db.String())
  9. product_url = db.Column(db.String())
  10. product_name = db.Column(db.String(), nullable=True)
  11. product_description = db.Column(db.String())
  12. #headline = db.Column(db.String(), nullable=True)
  13. #description_headline = db.Column(db.String(), nullable=True)
  14. price = db.Column(db.Float())
  15. percent_discount = db.Column(db.Float())
  16. #sale_price = db.Column(db.Float())
  17. start_date = db.Column(db.String())
  18. epoch_start_date = db.Column(db.Integer())
  19. end_date = db.Column(db.String())
  20. epoch_end_date = db.Column(db.Integer())
  21. is_show_logo = db.Column(db.Boolean())
  22. #logo_url = db.Column(db.String(), nullable=True)
  23. #is_logo_clickable = db.Column(db.Boolean())
  24. #logo_redirect_url = db.Column(db.String(), nullable=True)
  25. #navigation_link_name = db.Column(db.String(), nullable=True)
  26. #navigation_link_url = db.Column(db.String(), nullable=True)
  27. display_countdown = db.Column(db.Boolean())
  28. artificial_urgency = db.Column(db.Boolean())
  29. #array
  30. image_urls = db.Column(db.String())
  31. #array
  32. #video_urls = db.Column(db.String())
  33. #show_discount_value = db.Column(db.Boolean())
  34. show_coupon_left = db.Column(db.Boolean())
  35. artificial_scarcity = db.Column(db.Boolean())
  36. show_video = db.Column(db.Boolean())
  37. video_url = db.Column(db.String(), nullable=True)
  38. privacy_text = db.Column(db.String(), nullable=True)
  39. show_privacy_in_footer = db.Column(db.Boolean())
  40. show_privacy_in_optin = db.Column(db.Boolean())
  41. #encourage_headline = db.Column(db.String(), nullable=True)
  42. require_email = db.Column(db.Boolean())
  43. require_first_name = db.Column(db.Boolean())
  44. require_last_name = db.Column(db.Boolean())
  45. verify_email_address = db.Column(db.Boolean())
  46. send_follow_up_email = db.Column(db.Boolean())
  47. send_follow_up_email_in = db.Column(db.Integer(), nullable=True)
  48. facebook_pixel_tracking = db.Column(db.Boolean())
  49. facebook_pixel_id = db.Column(db.String(), nullable=True)
  50. google_analytics_tracking = db.Column(db.Boolean())
  51. google_analytics_id = db.Column(db.String(), nullable=True)
  52. redirect_on_voucher_claimed = db.Column(db.Boolean())
  53. voucher_claimed_redirect_url = db.Column(db.String(), nullable=True)
  54. #promo_code = db.Column(db.String(), nullable=True)
  55. total_voucher = db.Column(db.Integer(), nullable=True)
  56. remaining_voucher = db.Column(db.Integer(), nullable=True)
  57. custom_url_name = db.Column(db.String(), nullable=True)
  58. created_at = db.Column(db.String())
  59. epoch_created_at = db.Column(db.Integer())
  60. email_from_name = db.Column(db.String())
  61. email_reply_to = db.Column(db.String())
  62. email_footer_address = db.Column(db.String())
  63. email_followup_subject = db.Column(db.String())
  64. email_followup_headline = db.Column(db.String())
  65. email_followup_body = db.Column(db.String())
  66. email_voucher_coupon_subject = db.Column(db.String())
  67. email_voucher_coupon_headline = db.Column(db.String())
  68. email_voucher_coupon_body = db.Column(db.String())
  69. is_active = db.Column(db.Boolean())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement