I have three tables Client, Company, Account and want to create a relation between then so that they can satisfy following conditions.
- One client can have many accounts. One Account can be associated with many clients.
- One company can have many accounts. One account can be in many companies.
- One client can have many companies. One Company can be associated with many clients.
Tables are as follows:
class Company(models.Model):
name = models.CharField(max_length=255)
website_url = models.CharField(max_length=255, null=True, blank=True, default='')
class Account(models.Model):
customer_id = models.CharField(max_length=20, null=True, blank=True)
name = models.CharField(max_length=255)
class Client(models.Model):
name = models.CharField(max_length=255)
age = models.CharField(max_length=10, null=True, blank=True)
I don't know how to define many to many relationships for these tables.