#30830: django custom relationship
-----------------------------------------+------------------------
Reporter: bilnus1111 | Owner: nobody
Type: Uncategorized | Status: new
Component: Documentation | Version: 2.2
Severity: Normal | Keywords: models
Triage Stage: Unreviewed | Has patch: 0
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-----------------------------------------+------------------------
helo; supose i've tow models:
{{{
class Product(models.Model):
ref= models.CharField(max_length=12, unique=True)
code_prod= models.CharField(max_length=50)
description= models.CharField(max_length=150)
class Detail(models.Model):
ref = models.CharField(max_length=10)
year= models.IntegerField()
code = models.CharField(max_length=10)
month = models.IntegerField()
created_at = models.DateField()
class Meta:
db_table = 'details'
}}}
to make oneToMany relationship on Detail model, we can use ForeignKey.
this supose in Detail table there is column named product_id,
i want know if i can use another field for example "ref" to make this
relationship ?
also how can i perform this SQL query :
{{{
query = "select product.ref, product.description, details.year,
details.code from product left join details on details.ref = product.ref
where product.code = 'abcd' ; "
}}}
thank you very much.
--
Ticket URL: <https://code.djangoproject.com/ticket/30830>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/053.8eccd44fa71f606c62a855aba2259e16%40djangoproject.com.
