Advertisement
jeffdh5

Untitled

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