class Request(models.Model):
    id = models.IntegerField(primary_key=True)
    request_made = models.DateField(auto_now_add=True)
    requested_completion = models.DateField()
    cd_serial_number = models.ForeignKey(Cd)
    creator = models.ForeignKey(User)

    def __str__(self):
        return ("Request by %s on %s" % (self.creator, self.request_made))
    class Meta:
        db_table = 'license_request'
    class Admin:
        pass

class Site(models.Model):
    id = models.AutoField(primary_key=True)
    company_name = models.CharField(core=True, maxlength=255)
    contact_name = models.CharField(maxlength=180, core=True)
    contact_phone = models.CharField(maxlength=60, core=True)
    contact_email = models.EmailField()
    contact_fax = models.CharField(maxlength=60)
    contact_mobile = models.CharField(maxlength=60)
    street_number = models.CharField(maxlength=60)
    city = models.CharField(maxlength=180)
    region = models.CharField(maxlength=180)
    country = models.CharField(maxlength=60)
    postal_code = models.CharField(maxlength=60)
    request = models.ForeignKey(Request, edit_inline=models.STACKED, num_in_admin=1)

    class Meta:
        db_table = 'license_site'
    class Admin:
        pass

    def __str__(self):
        return self.company_name