多表创建,一对一,一对多,多对多

'''
1 models 导入模块
from django.contrib.auth.models import AbstractUser

2 settings 注册
AUTH_USER_MODEL = 'app01.UserInfo'

3 创建表

4 创建表关系 多表创建,一对一,一对多,多对多

'''



from django.db import models

# Create your models here.
from django.contrib.auth.models import AbstractUser


class UserInfo(AbstractUser):
phone = models.BigIntegerField(verbose_name='手机号',null=True)
# 头象
avatar = models.FileField(upload_to='avatar/',default='avatar/default.png')
'''
给avatar字段传文件对象,该文件会自动存储到avatar 文件下然后avatar字段只保个子文件的路径
'''
create_time = models.DateField(auto_now_add=True)
# 外键字段
blog = models.OneToOneField(to='Blog',null=True,on_delete=models.CASCADE)

class Blog(models.Model):
site_name = models.CharField(verbose_name='站点名称',max_length=32)
site_title = models.CharField(verbose_name='站点标题',max_length=32)

# 存css ,js 样式路径
site_theme = models.CharField(verbose_name='站点样式',max_length=64)

class Category(models.Model):
name = models.CharField(verbose_name='文章分类',max_length=32)
# 外键字段
blog = models.ForeignKey(to='Blog',null=True,on_delete=models.CASCADE)

class Tag(models.Model):
name = models.CharField(verbose_name='文章标签',max_length=32)
# 外键字段
blog = models.ForeignKey(to='Blog',null=True,on_delete=models.CASCADE)

class Article(models.Model):
title = models.CharField(verbose_name='文章标题',max_length=64)
desc = models.CharField(verbose_name='文章简介',max_length=255)
# 文章内容有很多 一般情况下都是使用TextField,
content = models.TextField(verbose_name='文章内容')
create_time = models.DateField(auto_now_add=True)

# 数据库字段设计优化
up_num = models.BigIntegerField(verbose_name='点赞数',default=0)
down_num = models.BigIntegerField(verbose_name='点踩数',default=0)
comment_num = models.BigIntegerField(verbose_name='评论数',default=0)
# 外键字段
blog = models.ForeignKey(to='Blog',null=True,on_delete=models.CASCADE)
category = models.ForeignKey(to='Category',null=True,on_delete=models.CASCADE)

#多对多
tags = models.ManyToManyField(to=Tag,
through='Article2Tag',
through_fields=('article','tag'),
)

#多对多三个种创建 ,半自动

class Article2Tag(models.Model):
article = models.ForeignKey(to='Article',on_delete=models.CASCADE)

tag =models.ForeignKey(to='Tag',on_delete=models.CASCADE)


class UpAndDown(models.Model):
user = models.ForeignKey(to='UserInfo',on_delete=models.CASCADE)
article = models.ForeignKey(to='Article',on_delete=models.CASCADE)
is_up = models.BooleanField() # 传布尔值 存0、1

class Comment(models.Model):
user = models.ForeignKey(to='UserInfo',on_delete=models.CASCADE)
article = models.ForeignKey(to='Article',on_delete=models.CASCADE)
content = models.CharField(verbose_name='评论内容',max_length=255)
content_time =models.DateField(verbose_name='评论时间', auto_now_add=True)

# 自关联
parent = models.ForeignKey(to='self',null=True,on_delete=models.CASCADE)


posted @ 2022-09-08 22:06  shclbear  阅读(37)  评论(0)    收藏  举报