Sqlite

打开sqlite命令行

python manage.py dbshell

退出

.quit

from django.db import models
# Create your models here.
class Asset(models.Model):
    name = models.CharField(max_length=255, verbose_name="资产名称")
    staff = models.CharField(max_length=255, verbose_name="员工")
    section = models.CharField(max_length=255, verbose_name="所属部门")
    date = models.DateTimeField(verbose_name="日期")
    value = models.FloatField(verbose_name="价值")
    count = models.IntegerField(verbose_name="数量")
    condition = models.IntegerField(verbose_name="使用情况")
    class Meta:
        managed = True
        db_table = 'asset'
        verbose_name = '固定资产管理'
class User(models.Model):
    staff = models.CharField(max_length=255, verbose_name="员工姓名")
    section = models.CharField(max_length=255, verbose_name="所属部门")
    account = models.CharField(max_length=11, verbose_name="账号")
    password = models.CharField(max_length=255, verbose_name="密码")
    class Meta:
        managed = True
        db_table = 'user'
        verbose_name = '用户信息管理'