class Country(models.Model):
name = models.CharField(max_length=100)
code = models.CharField(max_length=50)
class Meta:
db_table = 'countries'
def __str__(self):
return self.name
class State(models.Model):
country = models.ForeignKey(Country, on_delete=models.CASCADE)
name = models.CharField(max_length=100)
code = models.CharField(max_length=50)
class Meta:
db_table = 'states'
def __str__(self):
return self.name
class Address(models.Model):
line_1 = models.CharField(max_length=200)
line_2 = models.CharField(max_length=200)
city = models.CharField(max_length=200)
state = models.ForeignKey(State, on_delete=models.PROTECT)
postal_code = models.CharField(max_length=15)
class Meta:
db_table = 'addresses'
def __str__(self):
return '%s, %s, %s, %s' % (self.line_1, self.line_2, self.city, self.state)