Django models.py 表的参数选择

from django.db import models

# Create your models here.

class Department(models.Model): # 以后可以新增，删除，修改，所以单独拿出来

""" 部门表 """

title = models.CharField(verbose_name='标题', max_length=32)

def __str__(self): # 原来是对象，用来定义我们想返回的值

return self.title

class UserInfo(models.Model):

""" 员工表 """

name = models.CharField(verbose_name="姓名", max_length=16)

password = models.CharField(verbose_name="密码", max_length=64)

age = models.IntegerField(verbose_name="年龄")

account = models.DecimalField(

verbose_name="账户余额", max_digits=10, decimal_places=2, default=0)

# create_time = models.DateTimeField(verbose_name="入职时间") # 年月日，时分秒

create_time = models.DateField(verbose_name="入职时间") # 年月日

# 1.无约束

# depart_id = models.BigIntegerField(verbose_name="部门ID")

# 有约束

# - to ,与那章表关联

# - to_field ,表中的那一列关联

# 2.django自动

# - 写的depart

# - 生成数据列 depart_id

# 3.部门表被删除

# ### 3.1级联删除 on_delete=models.CASCADE 级联删除

depart = models.ForeignKey(verbose_name="部门",

to="Department", to_field="id", on_delete=models.CASCADE)

# ### 3.2置空

# null=True, blank=True, 这一列允许为空 on_delete=models.SET_NULL 置空

# depart = models.ForeignKey(

# to="Department", to_field="id", null=True, blank=True, on_delete=models.SET_NULL)

# 在 django中的约束

gender_choices = (

(1, "男"),

(2, "女"),

)

gender = models.SmallIntegerField(

verbose_name="性别", choices=gender_choices)

# level_choices = (

# (1, "1级"),

# (2, "2级"),

# (3, "3级"),

# (4, "4级"),

# )

# # SmallIntegerField 小整形（小整数） default=1 默认是1

# level = models.SmallIntegerField(

# verbose_name="级别", choices=level_choices, default=1)

class PrettyNum(models.Model):

""" 靓号管理 """

# CharField 存储为字符串类型必须设置长度,校验，re,收索

mobile = models.CharField(

verbose_name="手机号", max_length=11)

# IntegerField 整数不用设置长度

# 想要允许为空 null=True,blank=True

price = models.IntegerField(verbose_name="价格")

levels_choices = (

(1, "1级"),

(2, "2级"),

(3, "3级"),

(4, "4级"),

)

# SmallIntegerField 小整形（小整数） default=1 默认是1

levels = models.SmallIntegerField(

verbose_name="级别", choices=levels_choices, default=1)

status_choices = (

(1, "已占用"),

(2, "未占用"),

)

status = models.SmallIntegerField(

verbose_name="状态", choices=status_choices, default=2)

巴特西

Django models.py 表的参数选择

最新文章

热门文章