Why django inspectdb doesn't create foreign keys correctly on an existing database?

Asked May 10 '18 at 10:32

Active Feb 04 '19 at 10:30

Viewed 561 times

I want to use an existing database but after inspectdb generates an auto generated models file the relations of the models are not according to django.

For example:

user_id = models.IntegerField(blank=True, null=True)

which should be a foreign key:

user_id = models.Foreignkey('User',on_delete=models.CASCADE)

edited Feb 04 '19 at 10:30

tread

10,133
17
95
170

asked May 10 '18 at 10:32

Abdul Haseeb

Is the relationship defined at the database level ? – Rambarun Komaljeet May 10 '18 at 13:35
No. But when I try to make that integer field a foreign key in the models.py, the following error occurs: (1054, "Unknown column 'inquiry.company_id_id' in 'field list'"). – Abdul Haseeb May 11 '18 at 05:27
1

Use user instead of user_id – Rambarun Komaljeet May 11 '18 at 13:00

Why django inspectdb doesn't create foreign keys correctly on an existing database?

0 Answers0