from django.db import models

 class TabSource(models.Model):
     date=models.DateField()
     dsp=models.CharField(max_length=30)
     advertiser=models.CharField(max_length=100)
     insertion_order=models.CharField(max_length=300)
     insertion_order_id models.IntegerField()
     strategy_name=models.CharField(max_length=300)
     creative_name=models.CharField(max_length=400)
     spent_budget=models.DecimalField(null=True, max_digits=2)
     impressions=models.IntegerField()
     clics=models.IntegerField()
     conversions=models.IntegerField()
     post_clics_conversions=models.IntegerField()
     post_view_conversions=models.IntegerField()

     def __unicode__(self):
         return "{} {}".format(self.dsp, self.insertion_order)

class TabInfo(models.Model):
    start_date=models.DateField()
    end_date=models.DateField()
    advertiser=models.CharField(max_length=100)
    dsp=models.CharField(max_length=30)
    insertion_order=models.CharField(max_length=300)
    signed_budget=models.DecimalField(null=True, max_digits=2)

    def  __unicode__(self):
        return "{} {}".format(self.dsp, self.insertion_order)