College field in Batch model is redundant. You can get college of a batch using batch.department.college.
On Sun, Apr 7, 2013 at 10:57 AM, surya <[email protected]> wrote: > Consider a university college. > 1. College has name, uid, website > 2. Each college has a many departments - Each department has name, uid. > 3. Each batch in a department has name, and ratings. > > from django.db import models > > class College(models.Model): > name = models.CharField(max_length=200) > uid = models.CharField(max_length=10, primary_key=True) > website = models.URLField() > > def __unicode__(self): > return self.name > > class Department(models.Model): > name = models.CharField(max_length=200) > uid = models.CharField(max_length=10) > college = models.ForeignKey(College) > > def __unicode__(self): > return self.name > > class Batch(models.Model): > name = models.IntegerField(max_length=100) > department = models.ForeignKey(Department) > college = models.ForeignKey(College) > rating = models.IntegerField(default=0) > > def __unicode__(self): > return self.name > > Would you suggest any better design ? (actually, I never formally read DB) > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/django-users?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- Sincerely, Pankaj Singh http://about.me/psjinx -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/django-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
