如何在Django中设计模型关系并抽取公共字段为独立表

方案合理性校验与修正说明 #

你当前的设计方向符合字段抽离的需求，但外键方向需要根据你的实际业务场景判断是否正确：

• 如果你需要实现单只宠物/单个主人只能绑定一个地址，同一个地址可以同时关联多只宠物、多个主人，你现在写的代码是完全正确的，仅需要补充Address模型的__str__方法方便后续数据识别即可。
• 如果你需要实现单只宠物/单个主人可以绑定多个地址（比如家庭地址、临时寄养地址等），那你当前的外键方向写反了，应该把关联Pet和PetOwner的外键放到Address表中。

两种业务场景的完整实现代码 #

场景1：单宠物/单主人仅对应一个地址（你当前版本适配的场景）

from django.db import models
from django.urls import reverse

# 新增的Address模型
class Address(models.Model):
    home_number = models.CharField(
        max_length=10, help_text="Enter your house/Apt/Unit number"
    )
    street = models.CharField(max_length=50, help_text="Enter your street")
    town = models.CharField(max_length=20, help_text="Enter your county/town")
    state = models.CharField(max_length=20, help_text="Enter your state")
    zipcode = models.CharField(max_length=10, help_text="Enter your zipcode")

    def __str__(self):
        return f"{self.home_number}, {self.street}, {self.town}, {self.state} {self.zipcode}"


class PetOwner(models.Model):
    """Model representing a pet owner."""
    first_name = models.CharField(max_length=50, help_text="Enter owner's first name")
    last_name = models.CharField(max_length=50, help_text="Enter owner's last name")
    email = models.EmailField(
        max_length=50, blank=True, unique=True, help_text="Enter owner's email"
    )
    # 删除原来的CharField类型address字段，替换为外键
    address = models.ForeignKey('Address', on_delete=models.SET_NULL, null=True, blank=True, help_text="Select address for this owner")
    phone_number = models.CharField(
        max_length=15, blank=True, unique=True, help_text="Enter owner's phone number"
    )

    # 原有Meta、__str__、get_absolute_url方法不变
    class Meta:
        ordering = ["first_name", "last_name"]
    def __str__(self):
        return self.first_name
    def get_absolute_url(self):
        return reverse("petowner_detail", args=[str(self.id)])


class Pet(models.Model):
    """Model representing a pet."""
    first_name = models.CharField(max_length=50, help_text="Enter pet's first name")
    last_name = models.CharField(max_length=50, help_text="Enter pet's last name")
    breeds = models.ManyToManyField("Breed", help_text="Select a breed for this pet")
    weight = models.DecimalField(
        max_digits=5, decimal_places=2, help_text="Enter pet's weight"
    )
    date_of_birth = models.DateField(null=True, blank=True)
    date_of_death = models.DateField("Died", null=True, blank=True)
    owners = models.ManyToManyField(PetOwner, help_text="Select an owner for this pet")
    # 新增address外键
    address = models.ForeignKey('Address', on_delete=models.SET_NULL, null=True, blank=True, help_text="Select address for this pet")

    # 原有Meta、__str__、get_absolute_url、display_owner、display_breed方法不变
    class Meta:
        ordering = ["last_name", "first_name"]
    def __str__(self):
        return self.first_name
    def get_absolute_url(self):
        return reverse("pet_detail", args=[str(self.id)])
    def display_owner(self):
        return ", ".join(owner.first_name for owner in self.owners.all()[:3])
    def display_breed(self):
        return ", ".join(breed.name for breed in self.breeds.all()[:3])
    display_owner.short_description = "Parent"


class Breed(models.Model):
    """Model representing a pet breed"""
    name = models.CharField(
        max_length=50, help_text="Enter a pet breed (e.g. Golden Retriever)"
    )
    def __str__(self):
        return self.name

场景2：单宠物/单主人可对应多个地址

class Address(models.Model):
    home_number = models.CharField(max_length=10, help_text="Enter your house/Apt/Unit number")
    street = models.CharField(max_length=50, help_text="Enter your street")
    town = models.CharField(max_length=20, help_text="Enter your county/town")
    state = models.CharField(max_length=20, help_text="Enter your state")
    zipcode = models.CharField(max_length=10, help_text="Enter your zipcode")
    # 外键放在Address侧，通过related_name实现反向查询
    pet = models.ForeignKey(Pet, on_delete=models.SET_NULL, null=True, blank=True, related_name="addresses")
    owner = models.ForeignKey(PetOwner, on_delete=models.SET_NULL, null=True, blank=True, related_name="addresses")

    def __str__(self):
        return f"{self.home_number}, {self.street}, {self.town}, {self.state} {self.zipcode}"

# Pet和PetOwner模型不需要额外新增address字段，其余代码保持不变

验证测试方法 #

1. 迁移校验：执行python manage.py makemigrations和python manage.py migrate命令，无报错则说明模型语法和关联关系无逻辑冲突。
2. Shell交互测试：运行python manage.py shell进入交互环境，手动创建数据验证关联是否生效：

# 替换your_app_name为你的应用名称
from your_app_name.models import Address, Pet, PetOwner

# 场景1测试
addr1 = Address.objects.create(home_number="101", street="Main St", town="Los Angeles", state="CA", zipcode="90001")
owner1 = PetOwner.objects.create(first_name="John", last_name="Doe", address=addr1)
pet1 = Pet.objects.create(first_name="Mimi", last_name="Doe", weight=5.2, address=addr1)
# 验证关联
print(owner1.address.zipcode) # 应输出90001
print(pet1.address.zipcode) # 应输出90001

# 场景2测试
owner2 = PetOwner.objects.create(first_name="Jane", last_name="Doe")
pet2 = Pet.objects.create(first_name="Kiki", last_name="Doe", weight=3.8)
addr2 = Address.objects.create(home_number="102", street="Second St", town="Los Angeles", state="CA", zipcode="90002", owner=owner2, pet=pet2)
# 验证关联
print(owner2.addresses.first().zipcode) # 应输出90002
print(pet2.addresses.first().zipcode) # 应输出90002

3. Admin后台测试：将Address、Pet、PetOwner三个模型注册到admin.py中，在后台手动创建数据，测试关联字段是否可以正常选择、展示。

内容的提问来源于stack exchange，提问作者The silent one