Showing posts with label foreignkey. Show all posts
Showing posts with label foreignkey. Show all posts

Wednesday, August 06, 2008

Django ORM 中ForeignKey生成sql的方式

django根据model的name按照字母序升序排序, 然后依次生成sql, 例如有model A, B, C, 此时A外键引用B, C外键引用B, 则生成的sql即为:
create table app_a(...)
create table app_b(...)
create table app_c(...reference app_b(...))
alter table app_a add foreign key fkey_name reference app_b(...))