1、创建两张表
class Customer(models.Model):
pass
class Meta:
db_table = 'Customer'
class Sale(models.Model):
pass
class Meta:
db_table = 'Sale'
2、在MySQL中创建视图
3、在models同级的目录下创建文件(表的名字必须与数据库中创建的视图同名)(!!!在class名中 的最后加上V,在migrate时会忽略视图)
class CustomerInfoSaleV(models.Model):
name = models.CharField(max_length=50, verbose_name="客户姓名")
phone = models.CharField(max_length=50, verbose_name="客户电话")
introducer = models.CharField(max_length=50, verbose_name="被介绍人")
introducer_phone = models.CharField(max_length=50, verbose_name="被介绍人电话")
buy_date = models.CharField(max_length=50, verbose_name="被介绍时间")
class Meta:
db_table = 'view_customer_sale'