表與表之間的關係有一下三種：

一對多、多對多、一對一，沒關係暫且排外，下面演示如何通過ORM來建立外來鍵確立表關係~

ORM建立外來鍵欄位的位置：

一對多：建立在多的一方
一堆一：建立在任何一方都可以，但是推薦建立在查詢頻率較高的表中
多對多（兩種方式）：
自己建立第三張表
建立在任何一方都可以，但是推薦建立在查詢頻率較高
# 建立書籍表 出版者表  作者表
# 先寫表的基本結構，在考慮表關係如何寫外來鍵

# 書籍表
class Book(models.Model):
    name = models.CharField(max_length=32)
    price = models.DecimalField(max_digits=8, decimal_places=2) # 總共8位 小數佔2位
    # 作者外來鍵
    Author = models.ManyToManyField(to='Author')
    # 出版社外來鍵
    Publish = models.ForeignKey(to='Publish',on_delete=models.CASCADE)

# 作者表
class Author(models.Model):
    name = models.CharField(max_length=32)
    age = models.IntegerField()
    Atuhor_Detail = models.OneToOneField(to='Atuhor_Detail',on_delete=models.CASCADE)

# 作者詳情表
class Atuhor_Detail(models.Model):
    phone = models.BigIntegerField()
    Email = models.EmailField()

# 出版社表
class Publish(models.Model):
    name = models.CharField(max_length=32)
    address = models.CharField(max_length=32)

http://ds.163.com/article/621bfb16b3801c0001ad83d1/
http://ds.163.com/feed/621bfb16b3801c0001ad83d1/
http://ds.163.com/article/621bfb168d5cee0001a44d2e/
http://ds.163.com/feed/621bfb168d5cee0001a44d2e/
http://ds.163.com/article/621bfb18c470740001ccc939/
http://ds.163.com/feed/621bfb18c470740001ccc939/
http://ds.163.com/article/621bfb18c5e2010001399bf4/
http://ds.163.com/feed/621bfb18c5e2010001399bf4/
http://ds.163.com/article/621bfb190b83600001b8c41e/
http://ds.163.com/feed/621bfb190b83600001b8c41e/
http://ds.163.com/article/621bfb1b3967730001c00b43/
http://ds.163.com/feed/621bfb1b3967730001c00b43/
http://ds.163.com/article/621bfb1cc5e2010001399bf6/
http://ds.163.com/feed/621bfb1cc5e2010001399bf6/
http://ds.163.com/article/621bfb1d1c09770001b45b0e/
http://ds.163.com/feed/621bfb1d1c09770001b45b0e/
http://ds.163.com/article/621bfb1dd3fdd0000157797a/
http://ds.163.com/feed/621bfb1dd3fdd0000157797a/
http://ds.163.com/article/621bfb1ea1ca540001bf1916/
http://ds.163.com/feed/621bfb1ea1ca540001bf1916/
http://ds.163.com/article/621bfb1f3967730001c00b47/
http://ds.163.com/feed/621bfb1f3967730001c00b47/
http://ds.163.com/article/621bfb20cd732300016aff63/
http://ds.163.com/feed/621bfb20cd732300016aff63/
http://ds.163.com/article/621bfb2085eece000178adad/
http://ds.163.com/feed/621bfb2085eece000178adad/
http://ds.163.com/article/621bfb21d3fdd0000157797e/
http://ds.163.com/feed/621bfb21d3fdd0000157797e/
http://ds.163.com/article/621bfb210b83600001b8c422/
http://ds.163.com/feed/621bfb210b83600001b8c422/
http://ds.163.com/article/621bfb22cd732300016aff69/
http://ds.163.com/feed/621bfb22cd732300016aff69/
http://ds.163.com/article/621bfb22c5e2010001399bfa/
http://ds.163.com/feed/621bfb22c5e2010001399bfa/
http://ds.163.com/article/621bfb2485eece000178adb3/
http://ds.163.com/feed/621bfb2485eece000178adb3/
http://ds.163.com/article/621bfb241c09770001b45b18/
http://ds.163.com/feed/621bfb241c09770001b45b18/
http://ds.163.com/article/621bfb25c5e2010001399bfc/
http://ds.163.com/feed/621bfb25c5e2010001399bfc/
http://ds.163.com/article/621bfb25cd732300016aff6d/
http://ds.163.com/feed/621bfb25cd732300016aff6d/
http://ds.163.com/article/621bfb26b3801c0001ad83e2/
http://ds.163.com/feed/621bfb26b3801c0001ad83e2/
http://ds.163.com/article/621bfb268d5cee0001a44d3e/
http://ds.163.com/feed/621bfb268d5cee0001a44d3e/
http://ds.163.com/article/621bfb28a1ca540001bf191e/
http://ds.163.com/feed/621bfb28a1ca540001bf191e/
http://ds.163.com/article/621bfb28d3fdd0000157798a/
http://ds.163.com/feed/621bfb28d3fdd0000157798a/
http://ds.163.com/article/621bfb29b4e5c00001c2b3a5/
http://ds.163.com/feed/621bfb29b4e5c00001c2b3a5/
http://ds.163.com/article/621bfb2ad3fdd0000157798c/
http://ds.163.com/feed/621bfb2ad3fdd0000157798c/
http://ds.163.com/article/621bfb2a880c710001151317/
http://ds.163.com/feed/621bfb2a880c710001151317/
http://ds.163.com/article/621bfb2cd70a9b0001c2e28e/
http://ds.163.com/feed/621bfb2cd70a9b0001c2e28e/
http://ds.163.com/article/621bfb2c3967730001c00b55/
http://ds.163.com/feed/621bfb2c3967730001c00b55/
http://ds.163.com/article/621bfb2dc5e2010001399c00/
http://ds.163.com/feed/621bfb2dc5e2010001399c00/
http://ds.163.com/article/621bfb2ecb2dc40001e861aa/
http://ds.163.com/feed/621bfb2ecb2dc40001e861aa/
http://ds.163.com/article/621bfb2f880c710001151319/
http://ds.163.com/feed/621bfb2f880c710001151319/
http://ds.163.com/article/621bfb30b3801c0001ad83ec/
http://ds.163.com/feed/621bfb30b3801c0001ad83ec/
http://ds.163.com/article/621bfb303967730001c00b59/
http://ds.163.com/feed/621bfb303967730001c00b59/
http://ds.163.com/article/621bfb31d70a9b0001c2e292/
http://ds.163.com/feed/621bfb31d70a9b0001c2e292/
http://ds.163.com/article/621bfb313967730001c00b5b/
http://ds.163.com/feed/621bfb313967730001c00b5b/
http://ds.163.com/article/621bfb328d5cee0001a44d48/
http://ds.163.com/feed/621bfb328d5cee0001a44d48/
http://ds.163.com/article/621bfb333967730001c00b5f/
http://ds.163.com/feed/621bfb333967730001c00b5f/
http://ds.163.com/article/621bfb34880c71000115131f/
http://ds.163.com/feed/621bfb34880c71000115131f/
http://ds.163.com/article/621bfb3485eece000178adbd/
http://ds.163.com/feed/621bfb3485eece000178adbd/
http://ds.163.com/article/621bfb35d3fdd00001577990/
http://ds.163.com/feed/621bfb35d3fdd00001577990/
http://ds.163.com/article/621bfb36a1ca540001bf1923/
http://ds.163.com/feed/621bfb36a1ca540001bf1923/
http://ds.163.com/article/621bfb36c470740001ccc94f/
http://ds.163.com/feed/621bfb36c470740001ccc94f/
http://ds.163.com/article/621bfb3885eece000178adc3/
http://ds.163.com/feed/621bfb3885eece000178adc3/
http://ds.163.com/article/621bfb380b83600001b8c436/
http://ds.163.com/feed/621bfb380b83600001b8c436/
http://ds.163.com/article/621bfb391c09770001b45b28/
http://ds.163.com/feed/621bfb391c09770001b45b28/
http://ds.163.com/article/621bfb3a85eece000178adc9/
http://ds.163.com/feed/621bfb3a85eece000178adc9/
http://ds.163.com/article/621bfb3bc5e2010001399c08/
http://ds.163.com/feed/621bfb3bc5e2010001399c08/
http://ds.163.com/article/621bfb3ccb2dc40001e861b2/
http://ds.163.com/feed/621bfb3ccb2dc40001e861b2/
http://ds.163.com/article/621bfb3c85eece000178adcb/
http://ds.163.com/feed/621bfb3c85eece000178adcb/
http://ds.163.com/article/621bfb3dd70a9b0001c2e2a0/
http://ds.163.com/feed/621bfb3dd70a9b0001c2e2a0/
http://ds.163.com/article/621bfb3da1ca540001bf1925/
http://ds.163.com/feed/621bfb3da1ca540001bf1925/
http://ds.163.com/article/621bfb3fcb2dc40001e861b7/
http://ds.163.com/feed/621bfb3fcb2dc40001e861b7/
http://ds.163.com/article/621bfb3fb4e5c00001c2b3af/
http://ds.163.com/feed/621bfb3fb4e5c00001c2b3af/
http://ds.163.com/article/621bfb40880c71000115132b/
http://ds.163.com/feed/621bfb40880c71000115132b/
http://ds.163.com/article/621bfb411c09770001b45b30/
http://ds.163.com/feed/621bfb411c09770001b45b30/
http://ds.163.com/article/621bfb41c5e2010001399c0a/
http://ds.163.com/feed/621bfb41c5e2010001399c0a/
http://ds.163.com/article/621bfb432723790001ac8369/
http://ds.163.com/feed/621bfb432723790001ac8369/
http://ds.163.com/article/621bfb432723790001ac836b/
http://ds.163.com/feed/621bfb432723790001ac836b/
http://ds.163.com/article/621bfb440b83600001b8c444/
http://ds.163.com/feed/621bfb440b83600001b8c444/
http://ds.163.com/article/621bfb44cd732300016aff7b/
http://ds.163.com/feed/621bfb44cd732300016aff7b/
http://ds.163.com/article/621bfb45d3fdd0000157799a/
http://ds.163.com/feed/621bfb45d3fdd0000157799a/
http://ds.163.com/article/621bfb45b4e5c00001c2b3b3/
http://ds.163.com/feed/621bfb45b4e5c00001c2b3b3/
http://ds.163.com/article/621bfb463967730001c00b6a/
http://ds.163.com/feed/621bfb463967730001c00b6a/
http://ds.163.com/article/621bfb47d70a9b0001c2e2aa/
http://ds.163.com/feed/621bfb47d70a9b0001c2e2aa/
http://ds.163.com/article/621bfb48c5e2010001399c10/
http://ds.163.com/feed/621bfb48c5e2010001399c10/
http://ds.163.com/article/621bfb49d70a9b0001c2e2b0/
http://ds.163.com/feed/621bfb49d70a9b0001c2e2b0/
http://ds.163.com/article/621bfb4acd732300016aff7f/
http://ds.163.com/feed/621bfb4acd732300016aff7f/
http://ds.163.com/article/621bfb4a8d5cee0001a44d60/
http://ds.163.com/feed/621bfb4a8d5cee0001a44d60/
http://ds.163.com/article/621bfb4bc5e2010001399c12/
http://ds.163.com/feed/621bfb4bc5e2010001399c12/
http://ds.163.com/article/621bfb4cb4e5c00001c2b3bd/
http://ds.163.com/feed/621bfb4cb4e5c00001c2b3bd/
http://ds.163.com/article/621bfb4ccd732300016aff81/
http://ds.163.com/feed/621bfb4ccd732300016aff81/
http://ds.163.com/article/621bfb4d3967730001c00b6e/
http://ds.163.com/feed/621bfb4d3967730001c00b6e/
http://ds.163.com/article/621bfb4ec5e2010001399c16/
http://ds.163.com/feed/621bfb4ec5e2010001399c16/
http://ds.163.com/article/621bfb4eb4e5c00001c2b3bf/
http://ds.163.com/feed/621bfb4eb4e5c00001c2b3bf/
http://ds.163.com/article/621bfb4fcb2dc40001e861c2/
http://ds.163.com/feed/621bfb4fcb2dc40001e861c2/
http://ds.163.com/article/621bfb50c470740001ccc961/
http://ds.163.com/feed/621bfb50c470740001ccc961/
http://ds.163.com/article/621bfb51cd732300016aff87/
http://ds.163.com/feed/621bfb51cd732300016aff87/
http://ds.163.com/article/621bfb51cb2dc40001e861c4/
http://ds.163.com/feed/621bfb51cb2dc40001e861c4/
http://ds.163.com/article/621bfb52c5e2010001399c1b/
http://ds.163.com/feed/621bfb52c5e2010001399c1b/
http://ds.163.com/article/621bfb52cb2dc40001e861c6/
http://ds.163.com/feed/621bfb52cb2dc40001e861c6/
http://ds.163.com/article/621bfb53d70a9b0001c2e2b4/
http://ds.163.com/feed/621bfb53d70a9b0001c2e2b4/
http://ds.163.com/article/621bfb54d70a9b0001c2e2b8/
http://ds.163.com/feed/621bfb54d70a9b0001c2e2b8/
http://ds.163.com/article/621bfb55b4e5c00001c2b3c3/
http://ds.163.com/feed/621bfb55b4e5c00001c2b3c3/
http://ds.163.com/article/621bfb558d5cee0001a44d6e/
http://ds.163.com/feed/621bfb558d5cee0001a44d6e/
http://ds.163.com/article/621bfb5685eece000178adef/
http://ds.163.com/feed/621bfb5685eece000178adef/
http://ds.163.com/article/621bfb563967730001c00b74/
http://ds.163.com/feed/621bfb563967730001c00b74/
http://ds.163.com/article/621bfb57c5e2010001399c21/
http://ds.163.com/feed/621bfb57c5e2010001399c21/
http://ds.163.com/article/621bfb58880c710001151338/
http://ds.163.com/feed/621bfb58880c710001151338/
http://ds.163.com/article/621bfb591c09770001b45b40/
http://ds.163.com/feed/621bfb591c09770001b45b40/
http://ds.163.com/article/621bfb59d70a9b0001c2e2be/
http://ds.163.com/feed/621bfb59d70a9b0001c2e2be/
http://ds.163.com/article/621bfb5acb2dc40001e861d0/
http://ds.163.com/feed/621bfb5acb2dc40001e861d0/
http://ds.163.com/article/621bfb5bc5e2010001399c27/
http://ds.163.com/feed/621bfb5bc5e2010001399c27/
http://ds.163.com/article/621bfb5b3967730001c00b7d/
http://ds.163.com/feed/621bfb5b3967730001c00b7d/
http://ds.163.com/article/621bfb5c880c71000115133f/
http://ds.163.com/feed/621bfb5c880c71000115133f/
http://ds.163.com/article/621bfb5dcb2dc40001e861d6/
http://ds.163.com/feed/621bfb5dcb2dc40001e861d6/
http://ds.163.com/article/621bfb5ed3fdd000015779aa/
http://ds.163.com/feed/621bfb5ed3fdd000015779aa/
http://ds.163.com/article/621bfb5fc470740001ccc96d/
http://ds.163.com/feed/621bfb5fc470740001ccc96d/
http://ds.163.com/article/621bfb6085eece000178adf3/
http://ds.163.com/feed/621bfb6085eece000178adf3/
http://ds.163.com/article/621bfb608d5cee0001a44d76/
http://ds.163.com/feed/621bfb608d5cee0001a44d76/
http://ds.163.com/article/621bfb61a1ca540001bf193f/
http://ds.163.com/feed/621bfb61a1ca540001bf193f/
http://ds.163.com/article/621bfb61d3fdd000015779ac/
http://ds.163.com/feed/621bfb61d3fdd000015779ac/
http://ds.163.com/article/621bfb6285eece000178adf5/
http://ds.163.com/feed/621bfb6285eece000178adf5/
http://ds.163.com/article/621bfb63c5e2010001399c29/
http://ds.163.com/feed/621bfb63c5e2010001399c29/
http://ds.163.com/article/621bfb64c470740001ccc971/
http://ds.163.com/feed/621bfb64c470740001ccc971/
http://ds.163.com/article/621bfb64880c710001151341/
http://ds.163.com/feed/621bfb64880c710001151341/
http://ds.163.com/article/621bfb653967730001c00b83/
http://ds.163.com/feed/621bfb653967730001c00b83/
http://ds.163.com/article/621bfb6585eece000178adf7/
http://ds.163.com/feed/621bfb6585eece000178adf7/
http://ds.163.com/article/621bfb66880c710001151343/
http://ds.163.com/feed/621bfb66880c710001151343/
http://ds.163.com/article/621bfb67880c710001151345/
http://ds.163.com/feed/621bfb67880c710001151345/

ORM建立表關係

相關文章