django OperationalError:no such table问题

Question

admin界面有这些table

但任何一张表打开都是operationalerror

我的数据库

文件路径

运行过如下代码

python manage.py makemigrations
python manage.py migrate

我觉得应该是运行成功了的

以下这些我找到的解决方法都试过了没有用

python manage.py syncdb

class Meta:
    managed = True

python manage.py makemigrations HERBS
python manage.py migrate HERBS

admin.py

from django.contrib import admin
from HERBS.models import Herbs,DISEASE,Chemicals,CASID,TARGET
class HerbAdmin(admin.ModelAdmin):
    search_fields = ('ID','NAME')  #可进行查询的字段
    list_filter = ('NAME','Function')   #可进行筛选的字段
    list_display = ('ID','NAME','Function')  #需要在后台显示出来的字段

class DISEASEAdmin(admin.ModelAdmin):
    search_fields = ('Disease','MolID')
    list_filter = ('Disease','MolID')
    list_display = ('Disease','MolID')

class ChemicalsAdmin(admin.ModelAdmin):
    search_fields = ('ChemName','MolID','PubChemcid','ChineseName','Smiles')
    list_filter = ('MolID','ChemName')
    list_display = ('ChemName','MolID','PubChemcid','HID','ChineseName','MF','MW','Smiles')

class CASIDAdmin(admin.ModelAdmin):
    search_fields = ('ID','MolID')
    list_display = ('ID','MolID')

class TARGETAdmin(admin.ModelAdmin):
    search_fields = ('MolID','Target')
    list_display = ('MolID','Target')

# Register your models here.
admin.site.register(Herbs,HerbAdmin)
admin.site.register(DISEASE,DISEASEAdmin)
admin.site.register(CASID,CASIDAdmin)
admin.site.register(Chemicals,ChemicalsAdmin)
admin.site.register(TARGET,TARGETAdmin)

models.py

from django.db import models
#Create your models here.
class Herbs(models.Model): 
    ID = models.DecimalField(max_digits=5,decimal_places=0)
    NAME = models.TextField(max_length=50,primary_key=True)
    Function = models.TextField(max_length=500,null=True) 

class DISEASE(models.Model):
    Disease = models.TextField(max_length=100)
    MolID = models.TextField(max_length=50)

class Chemicals(models.Model):
    ChemName = models.TextField(max_length=50)
    MolID = models.TextField(max_length=50)
    PubChemcid = models.DecimalField(max_digits=10,decimal_places=0)
    HID = models.DecimalField(max_digits=10,decimal_places=0)
    ChineseName = models.TextField(max_length=50)
    MF = models.TextField(max_length=50)
    MW = models.DecimalField(max_digits=20,decimal_places=2)
    Smiles = models.TextField(max_length=500)

class CASID(models.Model):
    ID = models.TextField(max_length=50)
    MolID = models.TextField(max_length=50)

class TARGET(models.Model):
    Target = models.TextField(max_length=100)
    MolID = models.TextField(max_length=50)

class Meta:
    managed = True

Answer 1

https://blog.csdn.net/xiao13yu14/article/details/47989885