Synnefo

class Users(models.Model):

    user_name = models.CharField(max_length=255)

    user_credit = models.IntegerField()

    user_quota = models.IntegerField()

    user_created = models.DateField()

    limits = models.ManyToManyField(Limits, through='UserLimit')

class Limits(models.Model):

    lim_desc = models.CharField(max_length=45)

class UserLimit(models.Model):

    lim_id = models.ForeignKey(Limits)

    user_id = models.ForeignKey(Users)

    ul_value = models.IntegerField()

class Flavor(models.Model):

        flv_desc = models.CharField(max_length=255)

        flv_cost_active = models.IntegerField()

        flv_cost_inactive = models.IntegerField()

        flv_detailed = models.CharField(max_length=1000)

class VMachine(models.Model):

    vm_alias = models.CharField(max_length=255)

    vm_created = models.DateTimeField()

    vm_state = models.IntegerField()

    vm_started = models.DateTimeField()

    user_id = models.ForeignKey(Users)

    flv_id = models.ForeignKey(Flavor)

class ChargingLog(models.Model):

    vm_id = models.ForeignKey(VMachine)

    cl_date = models.DateTimeField()

    cl_credit = models.IntegerField()

    cl_message = models.CharField(max_length=1000)