Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select i.id, i.name, i.email, i.memo, g.id, g.name, i.birthday, i.regdt, n.number, t.name, t.id
- from webcontact_info as i
- inner join webcontact_number as n on i.id = n.info_id
- inner join webcontact_group as g on i.group_id = g.id
- inner join webcontact_type as t on n.type_id = t.id;
- class Group(models.Model):
- name = models.CharField(max_length=20)
- user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE)
- class Type(models.Model) :
- name = models.CharField(max_length=20)
- user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE)
- class Info(models.Model):
- name = models.CharField(max_length=20)
- email = models.EmailField(null=True, blank=True, unique=True)
- memo = models.CharField(max_length=200, null=True)
- birthday = models.CharField(max_length=12,null=True, blank=True)
- group = models.ForeignKey(Group, on_delete=models.CASCADE)
- user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE)
- regdt = models.DateTimeField(auto_now_add=True)
- updatedt = models.DateTimeField(auto_now_add=True)
- class Number(models.Model):
- number = models.CharField(max_length=11)
- info = models.ForeignKey(Info, on_delete=models.CASCADE)
- user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE)
- type = models.ForeignKey(Type, on_delete=models.CASCADE)
- regdt = models.DateTimeField(auto_now_add=True)
- updatedt = models.DateTimeField(auto_now_add=True)
Add Comment
Please, Sign In to add comment