Guest User

Untitled

a guest
Jul 17th, 2018
177
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  1. select i.id, i.name, i.email, i.memo, g.id, g.name, i.birthday, i.regdt, n.number, t.name, t.id
  2. from webcontact_info as i
  3. inner join webcontact_number as n on i.id = n.info_id
  4. inner join webcontact_group as g on i.group_id = g.id
  5. inner join webcontact_type as t on n.type_id = t.id;
  6.  
  7. class Group(models.Model):
  8. name = models.CharField(max_length=20)
  9. user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE)
  10.  
  11. class Type(models.Model) :
  12. name = models.CharField(max_length=20)
  13. user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE)
  14.  
  15. class Info(models.Model):
  16. name = models.CharField(max_length=20)
  17. email = models.EmailField(null=True, blank=True, unique=True)
  18. memo = models.CharField(max_length=200, null=True)
  19. birthday = models.CharField(max_length=12,null=True, blank=True)
  20. group = models.ForeignKey(Group, on_delete=models.CASCADE)
  21. user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE)
  22. regdt = models.DateTimeField(auto_now_add=True)
  23. updatedt = models.DateTimeField(auto_now_add=True)
  24.  
  25. class Number(models.Model):
  26. number = models.CharField(max_length=11)
  27. info = models.ForeignKey(Info, on_delete=models.CASCADE)
  28. user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE)
  29. type = models.ForeignKey(Type, on_delete=models.CASCADE)
  30. regdt = models.DateTimeField(auto_now_add=True)
  31. updatedt = models.DateTimeField(auto_now_add=True)
Add Comment
Please, Sign In to add comment