Revision 17935f41 policy/django/models.py
| b/policy/django/models.py | ||
|---|---|---|
| 1 |
from django.db import models |
|
| 2 |
|
|
| 3 |
class Limits(models.Model): |
|
| 4 |
lim_id = models.IntegerField(primary_key=True) |
|
| 5 |
lim_desc = models.CharField(max_length=45) |
|
| 6 |
|
|
| 1 | 7 |
class Users(models.Model): |
| 8 |
user_id = models.IntegerField(primary_key=True) |
|
| 2 | 9 |
user_name = models.CharField(max_length=255) |
| 3 | 10 |
user_credit = models.IntegerField() |
| 4 | 11 |
user_quota = models.IntegerField() |
| 5 | 12 |
user_created = models.DateField() |
| 6 | 13 |
limits = models.ManyToManyField(Limits, through='UserLimit') |
| 7 | 14 |
|
| 8 |
class Limits(models.Model): |
|
| 9 |
lim_desc = models.CharField(max_length=45) |
|
| 10 |
|
|
| 11 | 15 |
class UserLimit(models.Model): |
| 12 |
lim_id = models.ForeignKey(Limits) |
|
| 13 |
user_id = models.ForeignKey(Users) |
|
| 16 |
lim_id = models.ForeignKey(Limits, primary_key=True)
|
|
| 17 |
user_id = models.ForeignKey(Users, primary_key=True)
|
|
| 14 | 18 |
ul_value = models.IntegerField() |
| 15 | 19 |
|
| 16 | 20 |
class Flavor(models.Model): |
| 17 |
flv_desc = models.CharField(max_length=255) |
|
| 18 |
flv_cost_active = models.IntegerField() |
|
| 19 |
flv_cost_inactive = models.IntegerField() |
|
| 20 |
flv_detailed = models.CharField(max_length=1000) |
|
| 21 |
flv_id = models.IntegerField(primary_key=True) |
|
| 22 |
flv_desc = models.CharField(max_length=255) |
|
| 23 |
flv_cost_active = models.IntegerField() |
|
| 24 |
flv_cost_inactive = models.IntegerField() |
|
| 25 |
flv_detailed = models.CharField(max_length=1000) |
|
| 21 | 26 |
|
| 22 | 27 |
class VMachine(models.Model): |
| 28 |
vm_id = models.IntegerField(primary_key=True) |
|
| 23 | 29 |
vm_alias = models.CharField(max_length=255) |
| 24 | 30 |
vm_created = models.DateTimeField() |
| 25 | 31 |
vm_state = models.IntegerField() |
| ... | ... | |
| 28 | 34 |
flv_id = models.ForeignKey(Flavor) |
| 29 | 35 |
|
| 30 | 36 |
class ChargingLog(models.Model): |
| 37 |
cl_id = models.IntegerField(primary_key=True) |
|
| 31 | 38 |
vm_id = models.ForeignKey(VMachine) |
| 32 | 39 |
cl_date = models.DateTimeField() |
| 33 | 40 |
cl_credit = models.IntegerField() |
Also available in: Unified diff