如何编辑Django中间表?

Question

所以我想让两个模型像这样

class Product(models.Model):
name = models.CharField(max_length=70)
availability = models.ManyToManyField(Store)
class Store(models.Model):
name = models.CharField(max_length=150)
location = models.CharField(max_length=150)

，问题是在数据库的某个地方，我需要存储的具体货物包含在每个商店的数量。就像产品1 -商店1(23)，商店2(12)等。

有没有可能将它存储在中间表(从ManyToManyfield)或有什么容易。

Answer 1

可以指定through=…模型<一口>[Django-doc]:

class Product(models.Model):
name = models.CharField(max_length=70)
availability = models.ManyToManyField(Store, through='StoreProduct')
class Store(models.Model):
name = models.CharField(max_length=150)
location = models.CharField(max_length=150)
classStoreProduct(models.Model):
product = models.ForeignKey(Product, on_delete=models.CASCADE)
store = models.ForeignKey(Store, on_delete=models.CASCADE)
amount= models.IntegerField(default=1)