Ticket #12599: models.py

# coding=utf8

# This is an auto-generated Django model module.
# You'll have to do the following manually to clean this up:
#     * Rearrange models' order
#     * Make sure each model has one field with primary_key=True
# Feel free to rename the models, but don't rename db_table values or field names.
#
# Also note: You'll have to insert the output of 'django-admin.py sqlcustom [appname]'
# into your database.

from django.db import models
from django.utils.translation import ugettext_lazy as _

class Person(models.Model):
    name = models.CharField(max_length=512)
    class Meta:
        verbose_name = _("Person")
        verbose_name_plural = _("People")
    def __unicode__(self):
        return self.name

class Expense(models.Model):
    year = models.DateField()
    person = models.ForeignKey(Person)
    salary = models.FloatField()
    allowance = models.FloatField()
    cta = models.FloatField()
    mea = models.FloatField()
    consphone = models.FloatField()
    officegrant = models.FloatField()
    office = models.FloatField()
    ssa = models.FloatField()
    mobile = models.FloatField()
    travel = models.FloatField()
    committeetravel = models.FloatField()
    isdn = models.FloatField()
    trainingtravel = models.FloatField()
    cttee_ent = models.FloatField()
    ipu = models.FloatField()
    bpa = models.FloatField()

class Moffice(models.Model):
    moffice_id = models.IntegerField(primary_key=True,db_column='moffice_id')
    dept = models.CharField(max_length=765,blank=True)
    position = models.CharField(max_length=600)
    from_date = models.DateField()
    to_date = models.DateField()
    person = models.ForeignKey(Person,db_column='person')
    source = models.CharField(max_length=765,blank=True)
    class Meta:
        db_table = u'moffice'
        verbose_name = _("Ministerial position")