Django 数据库表关联

from django.db import models

class SysOrders(models.Model):
    id = models.AutoField(primary_key=True)
    plain_num = models.CharField(max_length=100, verbose_name="计划号")
    slab_num = models.CharField(max_length=100, unique=True, verbose_name="板坯号")
    rolling_t = models.FloatField(verbose_name="轧厚")
    slab_w = models.IntegerField(verbose_name="板坯宽")
    slab_l = models.IntegerField(verbose_name="板坯长")
    slab_t = models.IntegerField(verbose_name="板坯厚")
    slab_hn = models.IntegerField(verbose_name="板坯硬度")
    remark = models.CharField(max_length=500, null=True, verbose_name="备注")

    class Meta:
        db_table = "sys_orders"

1.一对一关联

class PlainNum(models.Model):
    id = models.AutoField(primary_key=True)
    plain_num = models.OneToOneField(SysOrders, on_delete=models.PROTECT, to_field='plain_num', verbose_name="计划号")

    class Meta:
        db_table = "plain_num"
posted @ 2025-03-27 10:00  起名字太难0123  阅读(24)  评论(0)    收藏  举报