django.db.utils.OperationalError: (1824, "Failed to open the referenced table 'blog_userinfo'")

When I migrate models, encountering this problem.
Django == 3.2.6
PyMySQL == 1.0.2
MySQL == 8.0.26
First, I drape all three tables; But this bug can’t fix.
Second, I register this model[Uerinfo] in app: bog’s admin, promblem sitll exists.
Following is my model, Please help me.Thanks.
from django.db import models

Create your models here.

from django.contrib.auth.models import AbstractUser

class UserInfo(AbstractUser):
nid = models.AutoField(primary_key=True)
telephone = models.CharField(max_length=11, null=True, unique=True)
# 存储用户头像文件
avatar = models.FileField(upload_to=‘avatars/’, default=“avatars/default.png”)
# 在生成字段时就以当前时间存储
create_time = models.DateTimeField(verbose_name=‘创建时间’, auto_now_add=True)
# 业务分离,用户名下blog删除,则站点blog不能被删除
blog = models.OneToOneField(to=‘Blog’, to_field=‘nid’, null=True, on_delete=models.PROTECT,

def __str__(self):
    return self.username

class Blog(models.Model):
1. 直接继承自UserInfo的nid,同时拒绝删除外键,设置自增减
nid = models.OneToOneField(UserInfo, on_delete=models.PROTECT, parent_link=True, primary_key=True, related_name=‘Blog_nid’)
title = models.CharField(verbose_name=‘个人博客标题’, max_length=64)
site_name = models.CharField(verbose_name=‘站点名称’, max_length=64)
theme = models.CharField(verbose_name=‘博客主题’, max_length=32)

def __str__(self):
    return self.title

class Category(models.Model):
nid = models.AutoField(primary_key=True)
title = models.CharField(verbose_name=‘分类标题’, max_length=32)
blog = models.ForeignKey(verbose_name=‘所属博客’, to=‘Blog’, to_field=‘nid’, on_delete=models.CASCADE,
related_name=‘Category_blog’, db_column=‘blog’)

def __str__(self):
    return self.title

class Tag(models.Model):
    nid = models.AutoField(primary_key=True)
    title = models.CharField(verbose_name='标签名称', max_length=32)
    # on_delete=models.PROTECT 标签被删除,外键关联的blog不能被删除
    # to_field='nid' 关联对象的字段名称,该字段必须是unique=True
    # related_name 指定用于反向查询的对象, 如果两个对象继承自同一个类,重命名之后则不再因为反向查询而冲突
    blog = models.ForeignKey(verbose_name='所属博客', to='Blog', to_field='nid', on_delete=models.PROTECT,
                             related_name='Article', db_column='blog')

    def __str__(self):
        return self.title

class Article(models.Model):
nid = models.AutoField(primary_key=True)
title = models.CharField(max_length=50, verbose_name=‘文章标题’)
desc = models.CharField(max_length=255, verbose_name=‘文章描述’)
create_time = models.DateTimeField(verbose_name=‘创建时间’, auto_now_add=True)

comment_count = models.IntegerField(default=0)
up_count = models.IntegerField(default=0)
down_count = models.IntegerField(default=0)

user = models.ForeignKey(verbose_name='作者', to='UserInfo', to_field='nid', on_delete=models.CASCADE,
                         related_name='Article_user', db_column='user')
category = models.ForeignKey(to='Category', to_field='nid', null=True, on_delete=models.CASCADE,
                             related_name='Article_category', db_column='category')
tags = models.ManyToManyField(
    to="Tag",  # to 参数用来指定与当前model类关联的model类
    through_fields=('article', 'tag')
content = models.TextField()

def __str__(self):
    return self.title

class Article2Tag(models.Model):
nid = models.AutoField(primary_key=True)
# 标签和文章的关联,属于多对多关系,标签可以删除,表不能删除,所以外键关联
article = models.ForeignKey(verbose_name=‘文章’, to=“Article”, to_field=‘nid’, on_delete=models.CASCADE)
tag = models.ForeignKey(verbose_name=‘标签’, to=“Tag”, to_field=‘nid’, on_delete=models.CASCADE)

class Meta:
    unique_together = [
        ('article', 'tag'),

def __str__(self):
    v = self.article.title + "---" + self.tag.title
    return v

class ArticleUpDown(models.Model):
nid = models.AutoField(primary_key=True)
user = models.ForeignKey(‘UserInfo’, null=True, on_delete=models.PROTECT)
article = models.ForeignKey(“Article”, null=True, on_delete=models.PROTECT)
is_up = models.BooleanField(default=True)

class Meta:
    unique_together = [
        ('article', 'user')

class Comment(models.Model):
nid = models.AutoField(primary_key=True)
user = models.ForeignKey(verbose_name=‘评论者’, to=‘UserInfo’, to_field=‘nid’, on_delete=models.PROTECT)
article = models.ForeignKey(verbose_name=‘评论文章’, to=‘Article’, to_field=‘nid’, on_delete=models.PROTECT)
create_time = models.DateTimeField(verbose_name=‘创建时间’, auto_now_add=True)
content = models.CharField(verbose_name=‘评论内容’, max_length=255)

parent_comment = models.ForeignKey('self', null=True, on_delete=models.PROTECT)

def __str__(self):
    return self.content

When posting code here, please enclose it between lines of three backtick - ` characters. This means you’ll have a line of ```, then your lines of code, and then another line of ```. This ensures your code remains formatted correctly, which is critical with Python. (You don’t need to repost your code, you should be able to go back and edit your post - insert the ``` before and after your code.)

Have you run makemigrations and migrate?
Can you confirm in the database that all your defined models exist?
Are all these models in the same app?
(Is your app named “blog”?)

What do you mean by this? (I’m guessing there’s some type of language / translation issue here - can you try to rephrase?)

I see where you have a field in UserInfo named “blog” which is a OneToOneField with Blog - but you also have a field in Blog named “nid”, which is a OneToOneField with UserInfo. This is improper, you only establish a relationship on one side - the other side is automatically created.

Thanks for your help and advice. When I report issues, I don’t be familiar with this form and I think this form don’t support markdown. Util I finish hand on issue, I realise many parts of content has changed forming.

This problem has been fixed. I am astonish to fare the resolution.
Because I delete migrations and in app:blog.

Thanks, that sentence is meaing that “I delete all table of databse:test”。The test belongs to MySQL, which is database of my project.

Because I want dispatch an ID for “Blog”, but I want save time. So I herite field “nid” from UserInfo. Factually, the "Blog " and “UserInfo” is the relation of “One to One”.

Note: for the formatting, you must use three backtick characters - `, not the single quote - ’ or double quote - "

Review the documentation on field relationships.

It’s not appropriate to try to establish both sides of a OneToOne. It’s not necessary. Django handles that automatically. You’re not “saving any time” by doing that.

I get the opposite of what I want