Advertisement
jeffdh5

Untitled

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