Django项目之CRM客户关系管理——表结构的设计及MySQL的连接

先附上整个系统的表结构设计：

from django.db import models
from django.contrib.auth.models import User

# Create your models here.

class Customer(models.Model):
    """客户信息表"""
    name = models.CharField(max_length=32,blank=True,null=True)#blank的作用是，admin操作时，允许null
    qq = models.CharField(max_length=64,unique=True)
    qq_name = models.CharField(max_length=32,blank=True,null=True)
    phone = models.CharField(max_length=64,blank=True,null=True)
    source_choices = ((0,'转介绍'),
                      (1, 'QQ群'),
                      (2, '官网'),
                      (3, '百度推广'),
                      (4, '51CTO'),
                      (5, '知乎'),
                      (6, '市场推广'),
                      )
    source = models.SmallIntegerField(choices=source_choices)
    referral_form = models.CharField(verbose_name="转介绍人qq",max_length=64,null=True,blank=True)
    consult_course = models.ForeignKey("Course",verbose_name="咨询课程",on_delete=models.CASCADE)
    content = models.TextField(verbose_name="咨询详情")
    tags = models.ManyToManyField("Tag",blank=True,null=True)
    consultant = models.ForeignKey("UserProfile",on_delete=models.CASCADE)#课程顾问,外键账户表
    memo = models.TextField(blank=True,null=True)#备注
    date = models.DateTimeField(auto_now_add=True)

    def __str__(self):
        return self.qq

class Tag(models.Model):
    name = models.CharField(unique=True,max_length=32)

    def __str__(self):
        return self.name

class CustomerFollowUp(models.Model):
    """客户跟进表"""
    customer = models.ForeignKey("Customer",on_delete=models.CASCADE)
    content = models.TextField(verbose_name="跟进内容")
    consultant = models.ForeignKey("UserProfile", on_delete=models.CASCADE)#课程顾问,外键账户表
    date &#