Client Models

gistfile1.py

# -*- coding: utf-8 -*-
from django.db import models
from django.contrib.auth.models import User

class Client(models.Model):
    user = models.OneToOneField(User, blank=True, null=True, )

    name = models.CharField(max_length=8, )
    tel = models.CharField(max_length=32, blank=True)
    email = models.CharField(max_length=32, blank=True)

    class Meta:
        db_table = 'client'


class Record(models.Model):
    STARTER_CLIENT, STARTER_ADMIN = 0, 1
    STARTER_CHOICES = ((STARTER_CLIENT, u'客戶'), (STARTER_ADMIN, u'管理員'))

    starter = models.PositiveIntegerField(choices=STARTER_CHOICES, default=STARTER_CLIENT)
    client = models.ForeignKey(Client)
    creator = models.ForeignKey(User, blank=True, null=True)

    memo = models.CharField(max_length=32, blank=True)
    create_time = models.DateTimeField(auto_now_add=True)
    update_time = models.DateTimeField(auto_now=True)
    message = modelsCharField(max_length=256, blank=True)

    class Meta:
        db_table = 'client_record'


class Todo(models.Model):
    STATUS_NEW, STATUS_CLOSED = 0, 1
    STATUS_CHOICES = ((STATUS_NEW, u'新'), (STATUS_CLOSED, u'結束'))

    status = models.PositiveSmallIntegerField(choices=STATUS_CHOICES, default=STATUS_NEW)
    owner = models.ForeignKey(User)
    record = models.ForeignKey(Record)

    create_time = models.DateTimeField(auto_now_add=True)
    update_time = models.DateTimeField(auto_now=True)
    due_time = models.DateTimeField()

    class Meta:
        db_table = 'client_todo'